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.




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:
Click to expand...

Mashiane

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

Walt's B4x Goodies Version 1.01 using BVAD3

BVAD3
mashiane.github.io

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

,

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.



After that you are good to go!

Enjoy.
 

Mashiane

Expert
Licensed User
Longtime 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!
 
You must log in or register to reply here.

Similar Threads

A
  • Question
B4J Question B4X Zkteco Library
Replies
3
Views
746
Ninja33
N
  • Question
B4J Question Integrated B4JPackager11 and jGoogleMaps library 2.00
Replies
1
Views
841
Erel
  • Article
B4J Tutorial [BANano] Searching B4xGoodies & Creating Overviews with Walt's B4xGoodies Explorer using BVAD3
Replies
0
Views
1K
Mashiane
  • Article
B4J Tutorial Erels B4J Oveview from Walt's B4xGoodies - created with B4xgoodies Explorer using BVAD3
Replies
0
Views
2K
Mashiane
  • Article
B4J Library [B4J only] MercadoPago Library released
Replies
1
Views
2K
Alex Oscar Hedman
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…