HomeHome Product Discus... Product Discus...SmithCartSmithCartError when importing Product info - "delimiter ',' can't be found after the field'HideProduct'Error when importing Product info - "delimiter ',' can't be found after the field'HideProduct'
Previous
 
Next
New Post
4/11/2017 2:03 AM
 
I recently exported my product info so I could make changes.  When attempting to upload the changes later I received the following error message - 

Error: The delimiter ',' can´t be found after the field 'HideProduct' at line 1 (the record has less fields, the delimiter is wrong or the next field must be marked as optional).

I'm running the most recent version of Smith Cart under DNN 9.2

Any ideas on how to correct this?

Thanks - Fred

Event Log - 





checkbox
4/11/2017 4:46:56 AM
Admin Alert 
host 
Sommer Gardens 
Import Product Error at FileHelpers.DelimitedField.BasicExtractString(Line 

Import Product Error: at FileHelpers.DelimitedField.BasicExtractString(LineInfo line) at FileHelpers.DelimitedField.ExtractFieldString(LineInfo line) at FileHelpers.FieldBase.ExtractValue(LineInfo line) at FileHelpers.RecordInfo.StringToRecord(LineInfo line) at FileHelpers.FileHelperEngine.ReadStream(TextReader reader, Int32 maxRecords, DataTable dt) at FileHelpers.FileHelperEngine.ReadFile(String fileName, Int32 maxRecords) at FileHelpers.FileHelperEngine.ReadFile(String fileName) at Smith.DNN.Modules.BuyNow.ImportProducts.ProductImportCSV()

Server Name: vserver515

checkbox
4/11/2017 4:46:56 AM
Admin Alert 
host 
Sommer Gardens 
Import Product Error The delimiter can´t be found after the field HideProd 

Import Product Error:The delimiter ',' can´t be found after the field 'HideProduct' at line 1 (the record has less fields, the delimiter is wrong or the next field must be marked as optional).

Server Name: vserver515

checkbox
4/11/2017 4:46:56 AM
Admin Alert 
host 
Sommer Gardens 
Import Product Error at FileHelpers.DelimitedField.BasicExtractString(Line 

Import Product Error: at FileHelpers.DelimitedField.BasicExtractString(LineInfo line) at FileHelpers.DelimitedField.ExtractFieldString(LineInfo line) at FileHelpers.FieldBase.ExtractValue(LineInfo line) at FileHelpers.RecordInfo.StringToRecord(LineInfo line) at FileHelpers.FileHelperEngine.ReadStream(TextReader reader, Int32 maxRecords, DataTable dt) at FileHelpers.FileHelperEngine.ReadFile(String fileName, Int32 maxRecords) at FileHelpers.FileHelperEngine.ReadFile(String fileName) at Smith.DNN.Modules.BuyNow.ImportProducts.ProductImportCSV()

Server Name: vserver515

checkbox
4/11/2017 4:46:56 AM
Admin Alert 
host 
Sommer Gardens 
Import Product Error The delimiter can´t be found after the field HideProd 

Import Product Error:The delimiter ',' can´t be found after the field 'HideProduct' at line 1 (the record has less fields, the delimiter is wrong or the next field must be marked as optional).

Server Name: vserver515

Date
Log Type
Username
Website
Summary
checkbox
4/11/2017 4:58:55 AM
Admin Alert 
host 
Sommer Gardens 
Import Product Error at FileHelpers.DelimitedField.BasicExtractString(Line 

Import Product Error: at FileHelpers.DelimitedField.BasicExtractString(LineInfo line) at FileHelpers.DelimitedField.ExtractFieldString(LineInfo line) at FileHelpers.FieldBase.ExtractValue(LineInfo line) at FileHelpers.RecordInfo.StringToRecord(LineInfo line) at FileHelpers.FileHelperEngine.ReadStream(TextReader reader, Int32 maxRecords, DataTable dt) at FileHelpers.FileHelperEngine.ReadFile(String fileName, Int32 maxRecords) at FileHelpers.FileHelperEngine.ReadFile(String fileName) at Smith.DNN.Modules.BuyNow.ImportProducts.ProductImportCSV()

Server Name: vserver515

checkbox
4/11/2017 4:58:55 AM
Admin Alert 
host 
Sommer Gardens 
Import Product Error The delimiter can´t be found after the field HideProd 
 
New Post
4/11/2017 10:03 AM
 
Please download the following product import example.

http://www.razorcart.com/Portals/0/SC...oductImport.zip

I tested it on the latest version and it works. Make sure your data is in this format and all your columns line up. Additionally, make sure all your text fields like product name, description, etc are wrapped in double quotes as having a comma in any of your data could create an extra column causing the import to fail.

At your service,
Dave Smith
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartError when importing Product info - "delimiter ',' can't be found after the field'HideProduct'Error when importing Product info - "delimiter ',' can't be found after the field'HideProduct'