[phpBB Debug] PHP Warning: in file [ROOT]/phpbb/session.php on line 580: sizeof(): Parameter must be an array or an object that implements Countable
[phpBB Debug] PHP Warning: in file [ROOT]/phpbb/session.php on line 636: sizeof(): Parameter must be an array or an object that implements Countable
ShopWise Forum • The ShopWise App and example databases
Page 1 of 1

The ShopWise App and example databases

Posted: Wed Jun 21, 2017 10:05 am
by Mike

The Latest ShopWise App.
ShopWise1_1_15V19.apk
ShopWise Version 1.1.0 Version code v19
(1.8 MiB) Downloaded 54 times
Numerous ongoing changes including handling Android 9.0 (Pie) which introduced default of using WAL (write-ahead logging) (backup/restore correctly checkpoints if WAL is being used thus negating need to handle -wal and -shm files (which cause issues with many Apps)).
The latest change was the introduction of Shop-level values (total cost, remaining cost and amount spent) in the Shop heading.

Other versions of ShopWise
ShopWise1_1_13V17.apk
ShopWise Version 1.1.0 Version code V17
(1.73 MiB) Downloaded 56 times
ShopWise1_1_12V16.apk
ShopWise Version 1.1.0 Version code V16
(1.73 MiB) Downloaded 46 times
ShopWise1_1_11V15.apk
ShopWise Version 1.1.0 Version code V15
(1.73 MiB) Downloaded 50 times
ShopWise1_1_10V14.apk
ShopWise Version 1.1.0 Version code V14
(1.65 MiB) Downloaded 56 times
ShopWise1_1_9V13.apk
ShopWise Version 1.1.0 Version code V13
(1.65 MiB) Downloaded 50 times
ShopWise1_1_8V12.apk
ShopWise Version 1.1.0 Version code V12
(1.65 MiB) Downloaded 54 times
ShopWise1_1_6V10.apk
ShopWise Version 1.1.0 Version code V10
(1.65 MiB) Downloaded 56 times
ShopWise1_1_5V9.apk
ShopWise Version 1.1.0 Version code V9
(1.69 MiB) Downloaded 52 times
ShopWise1_1_4V8.apk
ShopWise Version 1.1.0 Version code V8
(1.78 MiB) Downloaded 48 times
Changed accuracy bars to be displayed lower down in the list item rather than at the top for rule check option.
Changes to use Build Tools Version 26.0.2 from 26.0.0 and gradle version 3.0.0 from 2.3.3
ShopWise1_1_3V7.apk
ShopWise Version 1.1.0 Version code V7
(2.3 MiB) Downloaded 52 times
Accumulation of fixes and changes:-
1.1.1.V5
Implemented changes to pickdate (text sizing in date grid))
1.1.2.V6
Targetting changed to target minSDK 14 up to 26.
Changed shoppinglidt ccity to use text_size_tiny rather than nothing.
Implemented bug fix for issue #117 DisplayHelp crashing on some devices due to casting to RelativeLayout instead of LinearLayout.
1.1.3.v7
Reverted - Changed ShoppingList City to use text_size_tiny rather than nothing (unsure how this change was made but it shouldn't have been applied).

Changed Version Code from 6 to 7 changed version from 1.1.2 to 1.1.3.
ShopWise1_1_0V3.apk
ShopWise Version 1.1.0
(2.3 MiB) Downloaded 51 times
This version implements Embedded Help for all Activities.
It is also fixes a few issues with input validation allowing values that could cause issues (e.g. Interval multiplier of 0 would cause endless loop).
Basically integer validation was extended to allow a range to be specified.
Modules, such as PickDate, were changed to use external source rather than an imported copy.
A new Module DisplayHelp has been created and added, this being the utilised for the embedded help.

ShopWise1_0_1V2.apk
ShopWise Version 1.0.1
(2.21 MiB) Downloaded 55 times
This version fixes an issue when using the Rule Add/Edit Displays. The Shop Spinner (Drop Down Selector) was allowing Shops without Aisles to be selected. This was because the wrong method was being used getShops as opposed to getShopsWithAisles.
A spelling mistake was also spotted CANCE was changed to CANCEL.

Initial Production release
app-release.apk
ShopWise Version 1.0
(2.21 MiB) Downloaded 53 times
Initial test debug version. It is suggested that this is not used.
app-debug.apk
ShopWise Testing Release
(2.34 MiB) Downloaded 55 times

Installation Instructions
To install ShopWise
  • Ensure that your device allows installation from unknown devices by going into Settings and then Security and scrolling down to Unknown sources and enabling it.
  • Click on the respective link above (the assumption is that you are using the device).
  • Allow the download to proceed accepting/ignoring all warnings.
  • When prompted open the file and wait while the app installs (click Install if requested).
  • If prompted to allow access to photos media and files accept this (backup and restore accesses data (the backups) in the Downloads folder in a folder named ShopWise).
  • If desired, turn off installation from unknown sources via Setting/Security.
Note! ShopWise is also available on Google PlayStore ShopWise. Using This link to install ShopWise doesn't require allowing installation from unknown sources


Other ShopWise data (databases)
A ShopWise Backup
ShopWiseDB_201706220705.bkp
ShopWise Backup
(68 KiB) Downloaded 60 times
Backups by default are named as above, the numeric part is the year (2017), month(06), day of the month(22), hour(07), minutes(05).
This could be used by downloading it and then copying it into the ShopWise directory of the Downloads directory on the device.
It will then be visible, as an available backup, in the Restore dropdown selector (TOOLS/BACKUP).
It is suggested, before restoring from this backup (should you wish to do so) that you first backup your database (TOOLS/BACKUP then click BACKUP).


A ShopWise Database that was used for testing an issue.
ShopWiseTestingShoplistIssue47.sqlite
(56 KiB) Downloaded 58 times
To all intents and purposes this is a backup, which is a copy of the SQLite database file, other than it's name.
As such, this is could be used by ShopWise by placing it in the ShopWise directory of the Downloads folder and then renaming it accordingly e.g. rename it to ShopWiseDB_201706220000.bkp.

The Backup activity (TOOLS/BACKUP) is flexible enough to even see the un-renamed file (see the User Guide for more information)