Android Question Connect offline DB in Android > Cloud > Desktop > Excel

[JamesGreaves]

I have an B4A app which takes readings and then uploads text files via ftp. I then download the text files and import into Excel. It works, but I am not convince it is the best solution. I want to venture into a more professional database solution.

Do you think CloudKVS is right for the job?
The app will sometimes be offline, but should sync when online again.

What do you think?

 

[JamesGreaves]

 

[Didier9]

If you only create data on the app and use the cloud to retrieve it, you do not need a full fledged database. You can simply export your data as an Excel file directly from the app to any cloud storage provider like Dropbox or Google Drive. You would need a database if multiple users were to update the data at the same time or possibly if you want to log data continuously into a single file instead of potentially having a bunch of little files that you have to download and concatenate.
There are free services like Thinkspeak.com that let you do just that.

 

[Erel]

CloudKVS is a good option for this task. The PC and the mobile client will be synchronized automatically.

 

[JamesGreaves]

Thanks for you reply, please humor me a little longer.

Will CloudKVS still be suitable for a situation where the database is as follows:

It will have one company,
which has many buildings,
which has many Units,
which have 2 utility meters (Elec & Water) each with unique serial number
which have to store each month's readings.

And if CloudKVS is suitable, am I correct in saying that the code might eventually look something like this?:
' ----------------------------------------------------------------
Company = "ABComp"
Building = "Crossway Lodge"
DoorNo = "56"
ThisMonth = "2019-05"
Utility = "Water"
MeterNo = "M12334334"

ThisKey = Company & "/" & Building& "/" & Doorno & "/" & ThisMonth & "/" & Utiliy & "/" & Meterno
ThisReading = "01011394"

Put(ThisKey, ThisReading)
' ----------------------------------------------------------------

 

[Erel]

The "key" in CloudKVS is made of a <user, key> tuple. You can set the user to be made of the company and building for example if you want to have a client that only synchronizes the data of a specific building.

 

[JamesGreaves]

Great, thank you very much for the advice.