1 2 Previous Next 15 Replies Latest reply on Feb 6, 2017 11:07 PM by nexgen

    Script for importing a csv file whose column order keeps on changing

    nexgen

      I'm creating a script for importing a csv file. That file will get imported every week.

       

      I don't want to present a dialog box to user for mapping field since they might make mistake.

       

      However, there's a problem. The file's column order keeps on changing. So, I can't use the last import order.

       

      Is there anyway I can import records on the basis of column title? I know there's matching field name option but the problem is the column title of the csv file are like "Refunds ($)" and I can't name the filed using special characters like (, $ in filemaker.

       

      Any solution?

        1 2 Previous Next