'Matching Field Names option not working during import to FileMaker with CSV

I have created product table with filed name product_id, prod_name and description. But while importing field from file fields in file are not matching. Please any one tell me how to achieve this?



Solution 1:[1]

CSV files don't include field names so you can't use the Matching Names optio.

But you can drag the fields up and down so that they match up and then in a script you can import by last order.

Solution 2:[2]

I found that checking the box marked "Don't import first record (contains field names)" tells FM that the first row contains field names and then the "matching names" option for arrange by becomes available. I'm in FM Pro 16 and using MS Excel (.xlsx) format to import.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Adam Dempsey
Solution 2 Stephen Burian

Related Questions