You are here:  » Problems importing CSV file

Support Forum



Problems importing CSV file

Submitted by morgana on Sat, 2008-10-18 10:13 in

Hello,

I have problems with importing the following csv file:

Product Name ; Manufacturers Name ; Product Model ; Category ; Price ; Info link ; Image link ; Gewicht
128000IN (intern) PCI ISDN kaart, incl. RVS-Com software ; Victory ; 128000IN ; ISDN produkten ;30,12; http://www.dealerwebsite.nl/product_info.php?products_id=12331 ; http://www.dealerwebsite.nl/images/victory_logo.bmp ; 1000.00
128000PC (pcmcia) Actieve ISDN adapter ; Victory ; 128000PC ; ISDN produkten ;220; http://www.dealerwebsite.nl/product_info.php?products_id=12334 ; http://www.dealerwebsite.nl/images/victory_logo.bmp ; 1000.00
128000PC-L (pcmcia) ISDN Adapter ; Victory ; 128000PC-L ; ISDN produkten ;96,9; http://www.dealerwebsite.nl/product_info.php?products_id=12333 ; http://www.dealerwebsite.nl/images/victory_logo.bmp ; 1000.00
16 GB Mini-Mate USB Flash Drive ; Dane-Elec ; DA-ZMP-16GBZL-R ; USB sticks/Pendrives ;79,99; http://www.dealerwebsite.nl/product_info.php?products_id=22554 ; http://www.dealerwebsite.nl/images/DA-ZP-02GJB1-R.jpg ; 800.00
16 GB USB 2.0 Pendrive Jelly ; Dane-Elec ; DA-ZMP-16GBJY-R ; USB sticks/Pendrives ;79,99; http://www.dealerwebsite.nl/product_info.php?products_id=10477 ; http://www.dealerwebsite.nl/images/DA-ZMP-16GBJY-R.jpg ; 500.00

I selected the Text-header row-semicolon seperated and after submitting that I do see the first product.

I selected the necessary fields for field mapping and "register and trial or full import" doesn't show any products.

What am I doing wrong?

Submitted by support on Sun, 2008-10-19 13:40

Hi,

It sounds like you selected the correct format from the drop down box, so I suspect there's something else going on. Could you perhaps email me a link to your site and the name of the feed and i'll download it (from your /feeds/) to my test server and take a look for you!

Cheers,
David.

Submitted by morgana on Sun, 2008-10-19 16:26

I solved it by converting the csv file to an xml file and it works now.

Submitted by morgana on Wed, 2008-10-22 13:34

I want to let everyone know that David spend a lot of hours helping me out with this problem.

This great product comes with excellent support.

David, thanks for your help so far.