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


      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