0

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.

4 replies

null
    • Ninox developper
    • Jacques_TUR
    • 3 yrs ago
    • Reported - view

    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.
    3 - Write JavaScript in a Ninox HTML field to read your CSV file and save the data via the Ninox API.

    Why do you use a CSV file?

    • adrianklaver
    • 3 yrs ago
    • Reported - view

    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.

    • CISOFT_Sarl
    • 3 yrs ago
    • Reported - view

    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.

    • jstephengeorge
    • 3 yrs ago
    • Reported - view

    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.

Login to reply

Content aside

  • 3 yrs agoLast active
  • 4Replies
  • 1068Views