nsForum logo

Welcome Guest ( Log In )

 
Reply to this topicStart new topic
> Same Error Message In Product Upload, Continues to appear
maxgs
post Jul 1 2009, 12:02 PM
Post #1





Group: Verified NS Member
Posts: 2
Joined: 1-July 09
Member No.: 4,693



message in my exported file reads::
The delimiter ',' can´t be found after the field 'purchasable' at line 17 (the record has less fields, the delimiter is wrong or the next field must be marked as optional).

Im able to upload the first 16 products of the file with no problems and i cannot find any differences in the the products loaded vs. those that are not loaded. What could be the reason? Just got up and running the new version, yet not able to get test uploads completed.
Go to the top of the page
 
+Quote Post
ddavisNS
post Jul 1 2009, 12:01 PM
Post #2


QA


Group: Administrators
Posts: 1,864
Joined: 10-August 07
Member No.: 6



QUOTE (maxgs @ Jul 1 2009, 12:20 PM) *
message in my exported file reads::
The delimiter ',' can´t be found after the field 'purchasable' at line 17 (the record has less fields, the delimiter is wrong or the next field must be marked as optional).

Im able to upload the first 16 products of the file with no problems and i cannot find any differences in the the products loaded vs. those that are not loaded. What could be the reason? Just got up and running the new version, yet not able to get test uploads completed.



You are missing a comma or have an extra comma somewhere, most likely after the purchasable field on line 17 of the csv. If you open it in notepad the problem should be easier to see than in excel.
Go to the top of the page
 
+Quote Post
maxgs
post Jul 1 2009, 12:16 PM
Post #3





Group: Verified NS Member
Posts: 2
Joined: 1-July 09
Member No.: 4,693



QUOTE (ddavisNS @ Jul 1 2009, 01:19 PM) *
You are missing a comma or have an extra comma somewhere, most likely after the purchasable field on line 17 of the csv. If you open it in notepad the problem should be easier to see than in excel.



Thanks. I see the difference between the products above line 17 vs those below it. They're lacking commas. But how can I ensure that be fixed in the csv before i upload? Each product below in notepad shows the lack of commas (theres about 7 commas before it goes to the next line?
Go to the top of the page
 
+Quote Post
ddavisNS
post Jul 1 2009, 01:02 PM
Post #4


QA


Group: Administrators
Posts: 1,864
Joined: 10-August 07
Member No.: 6



QUOTE (maxgs @ Jul 1 2009, 12:34 PM) *
Thanks. I see the difference between the products above line 17 vs those below it. They're lacking commas. But how can I ensure that be fixed in the csv before i upload? Each product below in notepad shows the lack of commas (theres about 7 commas before it goes to the next line?


You would need to either manually fix it or do an export from the site with the columns you want to modify and modify and then reimport that export. If you include the delete column at the end sometimes that helps keep excel from eating your commas.
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: 21st March 2010 - 07:06 AM
Domain Names | Web Hosting | Web Design | Shopping Cart Software | Online Marketing | SSL Certificates