I have a client in the antiques business. They are moving their online shopping cart to Magento. I am working on an export from their FM database so that the Magento Admin tool will be able to upload the FM export file with the Product import wizard.
I have scripted FileMaker to export a found set of Product (i.e., Antiques ) records to a .csv file with column ordering that matches the Magento example .csv file. The example .csv file Magento provides looks like this in TextWrangler:
My .csv FM export file is using the "ANSI" text encoding option and looks like this in TextWrangler:
The Magento import tool throws an error when trying to assimilate the FM export file - obviously I suspect the quotation marks in the FM export.
Can FileMaker export the data per the example file on top natively, perhaps with the correct text encoding?
PS: At some point, we plan to use the Magento 2 RESTful API to replace the export/import process - but that will be a different thread I'm sure.
Your suggestions are much appreciated!