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?

Outcomes