How to import a batch of csv files

[DLM]

Hi,

 

I just got FM 12 (12.0v4 to be exact) so I'm new to it.

 

I'm wondering if it's possible to import a batch of csv files in one shoot.

 

I tried Import > Folder, then selected the folder where all the csv files are located, then clicked on "Text files" (rather than the default "Pictures and movies") but it won't work, I get "No files of the specified file type were found in the specified folder".

 

Technically speaking I know that csv files aren't text files but there isn't a "Comma Separated" option which would be the correct one.

 

Best,

[Matthew F]

If you change the endings of the file names to ".txt" instead of ".csv" then you should be able to import the data using Import > Folder. 

 

Note, however, that this imports all of the text from a file into a single field and then subsequent text files are imported into separate FM records.  If you need to parse the data into different fields as delimited by the commas, then you may want to write a script that loops over all of the files (using a variable for the filename) and executes an Import > File script step for each one. 

[DLM]

Hi Matt -- Thanks for that.

 

Best!