I just had some success with creating a simple method of backing up a local database. More work is needed and this would require a web service to actually store the data someplace, but I can build that stuff. My concern was how to get the data out of my Thunkable app and I think this will work. This…

That looks like a straightforward way to store the data and makes use of Thunkable’s own JSON parsing so it’s pretty block efficient. If you need a suggestion for where on the cloud to store it, you might consider using Firebase - have your users log in so each one has their own data storage, then …

Local Data in Thunkable is formatted as table so if I want to take a copy I would connect Google sheet and go through the records in the Local Data to append them into my Google sheet.

I agree and that would be great for just me but that won’t work for others because I don’t see any way for you to create a connection to a personal Google Sheet on the fly correct? The issue I’m trying to solve is that when a new release of my app comes out the users can back up their data. I need t…

That might be an option. It might also be a few more steps then my mountain biker folks will take. I was going to try this approach. Have a button that says “SMS your Backup ID” and a text box for the phone number (could do the same thing with email so just not sure) When ID arrives you copy it. A…

In this case, you can store the data as a stored variable in the phone but it will only be accessed by the app. Alternatively, allow the user to store the file as .txt local in the phone. You can use a variation of my app Export to vCard to accomplish it. Here is a link to Export to vCard

I like that vCard example. So you’re using a service you created up on GitHub to create the card file and since you are trying to open it as a link the default open for the file type kicks in. Very cool indeed!

Now, is it possible for an app to read from that file? I thought I saw an option in the list object to create a list from a csv so I’m thinking yes.

[image] gene.arnold9d: So you’re using a service you created up on GitHub to create the card file I chose to place it in GitHub but you can have it anywhere including the phone storage itself as long as you have the path to run it. You van have it as part of your assets if you wish.

But how would I now read this file and restore the database from it?

Backup local database idea. Your thoughts?

Questions about Thunkable X

gene.arnold9d July 9, 2021, 1:54pm 7

Oh that sounds promising! I didn’t know we could read flat files off the phone’s storage. Thank you!

File Picker: how to get/read the content of a JSON file?

Topic		Replies	Views
How to i use local storage db in my app Questions about Thunkable X beginner	16	2649	July 14, 2018
Saving a local DB? Questions about Thunkable X	34	2976	June 13, 2021
Address Book App HELP Questions about Thunkable X beginner	18	679	April 21, 2021
Upload offline data and upload to Database Questions about Thunkable X	4	496	May 29, 2023
Local file data storage Questions about Thunkable X file	4	1506	March 23, 2018

Backup local database idea. Your thoughts?

Related topics