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.