Programmatic CSV import/export
Is there a way via the API or other method to programmatically import and/or export CSV content to/form a table. Basically a scripted way to match CSV and table columns without going through the manual method.
Here are the three solutions that come to me:
1 - Use Zapier between Ninox and a CSV reader like Google Sheet.
2 - Use the Google Sheet macro to call the Ninox API.
Why do you use a CSV file?
Because CSV is the only Import/Export option and it is the quickest way to bulk move data. It would seem that there should be a builtin in process to use that feature without jumping through third party hoops.
I use csv file. I open the csv file into visual studio code editor and i put # in the end of file because i dont find why ninox dont reconize the end of file.
After this, copy my file into visual code and put it in text fiel multi line.
My input is ready now.
In a button :
let myDataArray := split(myTextFieldMultiLine, "#");
and after you loop through the array with a for loop
Have a nice day.
Finding the manual import tedious, I was wanting to do something similar. The multi-line text field approach looked like a good approach. Instead, I decided to copy the data and paste into a blank Ninox table. The Ninox data was a duplicate table of the table requiring the updates. From there I can update the data with a script. I don't think yhis was possible until the new release of Ninox.
- 2 yrs agoLast active