Hi there... has anyone managed to automate exporting data out of a Knack app? I have an app that accepts transactions through out the day, I would like to automatically export out the data from some of the tables that I can copy to another external system to process, but I don't want to have to run this manually using Builder. Any suggesting appreciated.. TQ.
Alvin.
I'm also looking for this as a task feature update. The ability to export the cvs file to another account in a schedule, google sheets and api calls are not working when considering tables with thousands of lines, having the knack export it cleanly would be desirable as a solution.
We need this as a Backup feature, but also to improve integration to other apps,
The ideal would be that it exports the csv, txt or Json file to dropbox, googledrive, onedrive, sharepoint,etc.., or even as an email, anything that could be password protected and able to store the files with a timestamp (for offline backup intentions), but not removing the ability to overwrite the last file saved (for integrations).
We work with many different integrations (such as powerbi),
In which if we use the standard api call on the whole object, view or table, it takes too long, incurring on connection errors, gateway erros and such.
The ability to have whole views scheduled exported on csv on a sharepoint or onedrive account would help in better integrating knack to all other sorts of desired functions.
Please consider adding this soon.
Another free solution would be to connect an excel spreadsheet directly to your Knack tables. This spreadsheet could then be configured to refresh automatically. I explained here the process a little bit:
https://medium.com/@mgr/querying-a-knack-object-from-excel-8f2b7163d81b
Hi Alvin,
Instead of exporting, you can also choose to save your Knack data - in real time - in a google sheet. For this you can use, among other things, Zapier.
Once set up, each time a new record is created in Knack, Zapier will add a new row to your Google Sheets document. It's the good way to connect Knack to a spreadsheet and an easy way for your team to view and graph data—or just to log and backup everything in Knack to another location.
See:
Hope this helps.
Marc
There are several ways to do this. Setup a binary field_XX (Yes/No) use make or Zapier to schedule daily or whatever time increment you need. Then search knack table for field_XX to loop through and match those records to update a GS or 365 Excel or other. Then while looping change field_XX to Yes (Being skip this next time.)
The problem is none of these export the mongoDB ID (24chara unique key) Only json exports do this.
You can of course set up a page with all records and export json records to import… That’s a pain but you could also setup a headless browser to programmatically do this if it was repetitive enough.
If starting from scratch you can setup a task on every form to email all fields to a email parser, again zapier or make and update a sheet. Then a zapier watch for any updates.
I’ve had to once export all of 3 tables as json because I need the ID, parse them to CSV then import to sheets so I can make relationships of the data.