Share My Creation [BANano] Walts B4xGoodies Explorer Using BVAD3

Ola

Version 1.01 released with speed improvements due to BANAnoSQL bulk inserts

This is just to showcase one of the projects we will be doing in class @ https://classroom.google.com/c/MzI1MDg2MTMwODc1?cjc=clzmpm3.

walt06.png



This features..

1. Downloading the xlsm file from dropbox using BANanoAxios directly inside the app. BANanoAxious works like BANanoFetch or Ajax, however makes life easy. Its just a personal option.
2. Using BANanoExcel (OXML) to read the file and import it to IndexedDB using AlaSQL aka BANanoSQL.
3. Backup & Restore IndexedDB to external text file i.e. json file
4. How to use BANanoPromise & BANano.Await.
5. Adding Gradients & Tooltips to your BVAD3 Elements
6. CRUD functionality with BANanoSQL
7. Creating Lists, Chips, ChipGroups etc.
8. Designing Grids
9. Reactive State & Freezing State to be non-reactive.
10. Passing parameters / query strings to pages
11. Badges, Events
12. Creating a hidden file input and clicking it to show the file selector
13. Vue Life Cycle and many many more.

B4XGoodies is an awesome project started by Walt @https://www.b4x.com/android/forum/threads/b4xgoodies-a-maintained-library-class-code-module-inventory-last-updated-2021-04-19.56175/#content

It has helped me before create an OverView Creator as discussed here: https://www.b4x.com/android/forum/threads/mashoverviewcreator.91337/#content

 
Last edited:

Mashiane

Expert
Licensed User
Walts B4xGoodies has been published and is running on github, you can access it here:


If you open the link and you don't see any badge numbers on the icons.. (like this)

,
1619353452911.png


You need to Restore the database. Why - this apps uses BANanoSQL (IndexedDB) as a backend database, which is web based.

Then, download this file first. https://github.com/Mashiane/Walts-B4XGoodies-using-BVAD3/blob/main/2021-04-25 04_05_BVAD3_B4XGoodies_BackUp.json

On the app, click the hamburger and click Restore, when prompted, select the file and be patient... unti it finishes.

1619353607072.png


After that you are good to go!

Enjoy.
 

Mashiane

Expert
Licensed User
Version 1.01 released.

This has improved speed when creating the underling BANanoSQL database due to the bulk insert functionality added.

Example source code

B4X:
'execute a bulk import
    Dim rsB4xGoodies As BANanoALASQLE 
    rsB4xGoodies.Initialize("b4xgoodies", "b4xgoodies", "id", "id") 
    rsB4xGoodies.SchemaAddInt(Array("id"))
    rsB4xGoodies.InsertBulk(rows)
    rsB4xGoodies.Result = db.ExecuteWait(rsB4xGoodies.query, rsB4xGoodies.args) 
    rsB4xGoodies.FromJSON 
    Select Case rsB4xGoodies.OK 
    Case False 
        Dim strError As String = rsB4xGoodies.Error 
        Log(strError) 
    End Select

Enjoy!
 
Top