Need to export tinydb as csv file.

1,247 views
Skip to first unread message

hewitts driving

unread,
Jan 2, 2017, 4:01:17 PM1/2/17
to MIT App Inventor Forum
Hi i have created an app for driving instructors to save their pupils contact details and also keep a progress report on each pupil. I save everything to the tinydb and everything works great but i would like to know how to save that tinydb to a csv file and be able to re populate the apps tinydb from the csv file if app has to be re installed. I have tried alsorts but cant integrate into my app. Any help would be great thanks.

Taifun

unread,
Jan 2, 2017, 5:07:17 PM1/2/17
to MIT App Inventor Forum
what about doing a search in the forum like this https://groups.google.com/forum/#!searchin/mitappinventortest/tinyDB$20export$20csv%7Csort:relevance

It does not look like you have used the forums yet, as a search using the search box above would have returned several threads about this topic.

Taifun

Trying to push the limits of App Inventor! Snippets, Tutorials and Extensions from Pura Vida Apps by Taifun. 



Advice: Before posting, it's a good idea to search in this forum. Many others have likely run into problems similar to yours. How to search see screenshot.

Timothy Fox

unread,
Jan 5, 2017, 3:53:27 AM1/5/17
to MIT App Inventor Forum
Please post a screen shot of your save blocks and the fields that your saving. I've finished an app that exports and imports. Be happy to help you out

hewitts driving

unread,
Jan 9, 2017, 8:12:50 AM1/9/17
to MIT App Inventor Forum
I am saving each pupils name as thd tag in tiny db and saving a list to each name . I have looked at the above export app and cant work oug how to do the make list bit which has the "a" and the "3" withing the make list block.

Abraham Getzler

unread,
Jan 9, 2017, 11:23:22 AM1/9/17
to MIT App Inventor Forum

hewitts driving

unread,
Jan 15, 2017, 9:13:06 AM1/15/17
to MIT App Inventor Forum
Could i send you my project aia to look at. I would be happy to pay someone to add the export import ability to my apl then i can put it on the app store thanks.

hewitts driving

unread,
Jan 15, 2017, 9:18:56 AM1/15/17
to MIT App Inventor Forum
The problem with all the tutorials is that they are all built up in one page. My app passes tinydb data between 3 pages. Would the tutorials still work.
Thanks

Taifun

unread,
Jan 15, 2017, 9:46:40 AM1/15/17
to MIT App Inventor Forum
ll the tutorials is that they are all built up in one page. My app passes tinydb data between 3 pages. Would the tutorials still work. 

what about adjusting them to your needs?
Taifun 

hewitts driving

unread,
Jan 15, 2017, 11:30:40 AM1/15/17
to MIT App Inventor Forum
My app is all fully working with using the the tiny db to allow me to click on the add pupil button which opens the Add pupil Page.. there i can add the pupils name, house and street, town, postcode, contact number, and then save that to the tinydb.
If i click the Edit Pupil button it will Open the Edit puoil page whicn has a list picker allowing me to selecg a pupil from the list picker list and then it fills the details of the chosen pupil in the name and address boxes. I can then edit details and re save details for that pupil.
Then i can click on the progress button to open the pupil progress page that allows me to choose a pupil from the list picker again and then i can store their progress which has a selection of driving skills such as turning left and turning right , t junctions, mqnouevres. Each of the skills are scored out of 5 stars. Then i can save that pupils progress.

This app works perfectly as it is but i want to be able to save all this data in a way that it can be exported by the driving instructor to a computer so that if they buy a new android device and re install my app they can import the data that they had saved so that it can populate the tiny db and their app is bac, to how it was on the other device.

hewitts driving

unread,
Jan 15, 2017, 11:45:33 AM1/15/17
to MIT App Inventor Forum
Could i send you my aia file as theres loads of blocks.

Abraham Getzler

unread,
Jan 15, 2017, 12:46:15 PM1/15/17
to MIT App Inventor Forum
Feel free to use my TinyDB_export_import sample from the Gallery in your app:
ABG

Reply all
Reply to author
Forward
0 new messages