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

Discussion in 'Android Questions' started by JamesGreaves, May 3, 2019.

  1. JamesGreaves

    JamesGreaves Member Licensed User

    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?
     
  2. JamesGreaves

    JamesGreaves Member Licensed User

  3. Didier9

    Didier9 Active Member Licensed User

    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.
     
  4. Erel

    Erel Administrator Staff Member Licensed User

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

    JamesGreaves Member Licensed User

    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)
    ' ----------------------------------------------------------------
     
  6. Erel

    Erel Administrator Staff Member Licensed User

    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 likes this.
  7. JamesGreaves

    JamesGreaves Member Licensed User

    Great, thank you very much for the advice.
     
Loading...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice