Hi, I am an Adobe Business Catalyst refugee and have to set up a store for a client. I have all the csv records files of the database tables but they no longer are in a relationship. I was hoping to recreate the relationships in TF but I don’t see a way to export the relational DB to MySql. Wondering if that is possible and if you have Open Doc export possibilities.
Tap Forms 5 is built on CouchbaseLite, technically a document store rather than relational database. TF5 has a sync feature that allows you to push these documents to a CouchDB server (or IBM Cloudant) which you can then pull data from. The CouchDB functionality enables multiple Tap Forms 5 instances to communicate but I use this myself to enable two way communication to retrieve and process data. I have a Github repo that has some samples of working with Tap Forms data and you could use an approach similar to this to push to a MySQL database. This isn’t an entirely great fit because MySQL enforces a schema whilst obviously document stores don’t enforce schemas and are more flexible about data they store. One could map it across but would have to deal with ensuring the consistency as fields are separate documents and the type can change which causes issues for relational databases.
Hi Jefferis,
Tap Forms can export as a CSV file which theoretically you could import into MySQL.
Thanks,
Brendan
.
