nsForum logo

Welcome Guest ( Log In )

 
Reply to this topicStart new topic
> Help, import/export deliminator errors
marciafcfc
post Oct 22 2009, 11:32 AM
Post #1





Group: Verified NS Member
Posts: 92
Joined: 18-September 08
Member No.: 2,448



I've exported a csv file with specific fields checked. I've made simple changes, weights, categories, manufacturers, and every time I go to import, there are hundreds of deliminator errors.

Ex.: The delimiter ',' can´t be found after the field 'taxfree' at line 17 (the record has less fields, the delimiter is wrong or the next field must be marked as optional).
or
The delimiter ',' can´t be found after the field 'manufacturerpartnumber' at line 484 (the record has less fields, the delimiter is wrong or the next field must be marked as optional).

What are these and how can they be corrected? The errors are preventing 100s of products from updating.

Marcia
Go to the top of the page
 
+Quote Post
loki
post Oct 22 2009, 12:11 PM
Post #2





Group: Administrators
Posts: 10
Joined: 14-August 07
Member No.: 28



Hello Marcia,

This issue is something that will occur if your spreadsheet is incorrectly formatted (normally a bug in excel). I see this error when using excel to modify spreadsheets for import. Excel has some bugs that unfortunately, will not always insert all of the necessary commas to format the spreadsheet for import as it should. This is something that can only be seen by opening up the file as a text file. This can normally be resolved though by inserting "FALSE" into the delete column for each product. This forces excel to format the spreadsheet correctly.

QUOTE (marciafcfc @ Oct 22 2009, 11:40 AM) *
I've exported a csv file with specific fields checked. I've made simple changes, weights, categories, manufacturers, and every time I go to import, there are hundreds of deliminator errors.

Ex.: The delimiter ',' can´t be found after the field 'taxfree' at line 17 (the record has less fields, the delimiter is wrong or the next field must be marked as optional).
or
The delimiter ',' can´t be found after the field 'manufacturerpartnumber' at line 484 (the record has less fields, the delimiter is wrong or the next field must be marked as optional).

What are these and how can they be corrected? The errors are preventing 100s of products from updating.

Marcia

Go to the top of the page
 
+Quote Post
marciafcfc
post Oct 26 2009, 09:05 AM
Post #3





Group: Verified NS Member
Posts: 92
Joined: 18-September 08
Member No.: 2,448



Thank you, that worked!
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
Tags
No Tag inserted yet

1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

RSS Lo-Fi Version    Network Solutions © 2010 Time is now: 19th March 2010 - 11:47 AM
Domain Names | Web Hosting | Web Design | Shopping Cart Software | Online Marketing | SSL Certificates