AnsweredAssumed Answered

Export FM Items for Magento 2 Import

Question asked by edwardlscott on Feb 16, 2018
Latest reply on Feb 16, 2018 by beverly

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:

FM Export.png


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!