mz5005

Importing large number of CSV files

Discussion created by mz5005 on Jan 24, 2017
Latest reply on Feb 1, 2017 by fmpdude

We need to import about 100 large CSV files into FMP.

 

Q1: Of course I prefer to import directly from the CSV file (instead of via Excel). I know about the import file command, but FMP seems to know only comma delimited, not semicolon-. Result is records with a long string in the first field only.

Script ref guide gives nothing useful reg CSV. Not possible in any way to import directly from CSV file?

 

Q2: if it IS possible, is there also a way to let a script unzip the files automatically?

 

All suggestions welcome and thanks in advance!

Outcomes