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.
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.