How to import csv format into FileMaker file, so that every data goes into its field
One way is to open your .csv in Excel (or any spreadsheet app) and edit the first row to make the column names match what you have in FileMaker. If the first row in your .csv doesn't already have column names, just insert a new row at the top.
Then, in FileMaker, in the Import settings window:
1. Select "Don't import first record (field names)"
2. Select "Arrange by: Matching names"
That should align all of the .csv source fields with your FileMaker fields.
Thank you very much, but the problem is that I'm interested in getting a csv. if I do not have Excel installed since the import goes to one field. Probably need some script.
Importing into FileMaker help starts here: Importing data into FileMaker Pro Advanced
The 'expected' format for .CSV to import into FileMaker is to have commas between the columns and double-quote the text values. The end-of-line should be the carriage return.
If you are getting every "line" into one field, then the format is not quite right. Can you post an example (bogus data is fine) of what your .CSV file looks like?
You might also read this recent thread on issues with import:
I'll echo Beverly's advice. Try the links she provided. If you're still unsure about something, try posting a screenshot or a code sample, and one of us can help point you in the right direction.
the import goes to one field.
This could happen if the file is not really comma-separated (for example, it uses the semi-colon as separator). Or, FMP may think it is importing a tab-delimited file (make sure you select the correct file type during the import dialog.)
if you have a csv file, you can make a copy of it, then in the copy change the extension to .txt, and open it with any text editor. Then you can see what is being used as a delimiter, i.e. comma, or … then find and replace if it is not a comma with a comma. Then change the extension back to csv, and then drop it on the Filemaker Icon to open it.
thanks, thank you, I'm clear and full you helped me
Also if you use the Merge file format, you can Import CSV files with the advantage it will follow the Country settings in macOS also. For instance, if the Country is France, it will allow you to import semi-colon separated CSV.
find and replace if it is not a comma with a comma.
If that's all you do, then all in-field commas will turn into separators.
Retrieving data ...