6

CSV Import Wizard

CSV Import Wizard.ninox Sample_CSV_Data

Hello everyone,

Since a lot of our community members are interested in ways to automate the import of a CSV file, I decided to put together a complete working example database to show how to do it.

I'm happy to share the attached database and a sample CSV file with you. The file contains data on attendees of various events. Here are some things I've put into action:

  • There's a Dashboard where users can upload their CSV file. There's no need for an intermediate import table.

  • Don't use "Select" statements. Just rely on "References" instead.

  • Use the script on the server side to speed up the import process.

  • Check for duplicates in all three tables — Contacts, Events, and Attendees.

Happy coding!

11 replies

null
    • Rafael Sanchis
    • Rafael_Sanchis
    • 1 mth ago
    • Reported - view

    Hi Sotirios, 

    It works great on the public web, but I don't know why it doesn't work on my Android app.

    Thanks for your work.

      • szormpas
      • 1 mth ago
      • Reported - view

         Hi,

      Since the main code is running on the server side, I'm not sure why it's not working on your Android app. Unfortunately, I don't have an Android device for checking.

    • gold_cat
    • 1 mth ago
    • Reported - view

    Great example! Is it possible to use it offline?

      • szormpas
      • 1 mth ago
      • Reported - view

       Thanks. Can you check this in your app?

      • gold_cat
      • 1 mth ago
      • Reported - view

       
      I've tried it, my friend. The local version can't be used this way.

      • szormpas
      • 1 mth ago
      • Reported - view

        OK, remove the "do as server.......end" from the main code inside the button.

      • gold_cat
      • 1 mth ago
      • Reported - view

       

      Hi Sotirios, 
      I did try this way, but it didn't work.

    • szormpas
    • 1 mth ago
    • Reported - view

    I see the problem now. The main script depends on the shareFile() function to create a link of the CSV file, and I guess that's not possible locally.

    So, the solution above only works for the web.

      • Rafael Sanchis
      • Rafael_Sanchis
      • 1 mth ago
      • Reported - view

       

      Hi Sotirios.

      Android app might not support shareFile or http("GET", ...) for shared files in the same way, or may not have permissions to access external URLs.

    • John_Halls
    • 2 days ago
    • Reported - view

     Thank you for this. I am trying to fully automate a CSV import. Your solution will certainly help! I have a Zap in Zapier that triggers when a CSV file is added to a folder and it should add the file to a record in Ninox, but it is adding a reference to the file instead. Do you know of a way to add a CSV file to a record, either from a file in a folder or from an attachment in Gmail.

    Thanks John

      • szormpas
      • 2 days ago
      • Reported - view

          I'm glad you find it helpful.

      Unfortunately, I haven't added external automation to my database yet, so I don't have any experience.

Login to reply

Content aside

  • 6 Likes
  • 2 days agoLast active
  • 11Replies
  • 128Views
  • 5 Following