AnsweredAssumed Answered

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

Question asked by nexgen on Feb 6, 2017
Latest reply on Feb 6, 2017 by 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?