CSV Import Errors -- Product info - DataPort Utility

[hautebox]

I am attempting to import a large number of products using the csv import feature.

The DPU is returning error messages (see below) like the one below for all 50 products. I have checked that the Category field (Categories) match the entries I uploaded prior.

I know the import utility is connecting correctly because I tested the program by attempting to import the same file by eliminating the category field and was successful in uploading, however, the products get classified as "orphans" -- thereby requiring manual data manipulation to get them back into the category listings.

Any possible explanation on the error messages and how to correct?.

***************
Below is a sample error message for just one of the 50 entries...

Code: Select all

[Import(Upload) Information]:-


Importing 50 Products

Invalid column name 'Categories'.
ImportOrUpdate unsuccessful for Product
ProductId = 0
Name = Wheat Tortilla filled with  Potatoes  Eggs and Spanish Beef Chorizo
Error message: Invalid column name 'Categories'.

   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.Practices.EnterpriseLibrary.Data.Database.DoExecuteReader(DbCommand command, CommandBehavior cmdBehavior)
   at Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteReader(DbCommand command)
   at CommerceBuilder.Data.Database.ExecuteReader(DbCommand command)
   at CommerceBuilder.Products.ProductDataSource.LoadForCriteria(String sqlCriteria, Int32 maximumRows, Int32 startRowIndex, String sortExpression)
   at CommerceBuilder.Products.ProductDataSource.LoadForCriteria(String sqlCriteria)
   at CommerceBuilder.DataClient.Api.ObjectHandlers.ImportHandler.af.a(Object A_0)
   at CommerceBuilder.DataClient.Api.ObjectHandlers.ImportHandler.a(Array A_0, Type A_1, String A_2, String A_3, String A_4, Object A_5, aa A_6, z A_7, ae A_8, c A_9, String A_10)

Base Exception: Invalid column name 'Categories'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.Practices.EnterpriseLibrary.Data.Database.DoExecuteReader(DbCommand command, CommandBehavior cmdBehavior)
   at Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteReader(DbCommand command)
   at CommerceBuilder.Data.Database.ExecuteReader(DbCommand command)
   at CommerceBuilder.Products.ProductDataSource.LoadForCriteria(String sqlCriteria, Int32 maximumRows, Int32 startRowIndex, String sortExpression)
   at CommerceBuilder.Products.ProductDataSource.LoadForCriteria(String sqlCriteria)
   at CommerceBuilder.DataClient.Api.ObjectHandlers.ImportHandler.af.a(Object A_0)
   at CommerceBuilder.DataClient.Api.ObjectHandlers.ImportHandler.a(Array A_0, Type A_1, String A_2, String A_3, String A_4, Object A_5, aa A_6, z A_7, ae A_8, c A_9, String A_10)

[Naveed]

To properly diagnose the issue please post more details:

1. Store version and build number
2. DataPort version
3. Client Api version

Also please post the version information from Admin -> Help -> About Able commerce page of your store.

[hautebox]

AbleCommerce 7.0.3 build 12458

data port version 7.3.130.0
client api 7.0.3 (not sure if how to access the detailed portion of this one) downloaded off site yesterday

PLATFORM: ASP.NET
VERSION: 7.0.3
BUILD: 12458
MSSQL v2005
AC SCHEMA v2005

AjaxControlToolkit: 3.0.20229.20843
CommerceBuilder: 7.3.12065.0
CommerceBuilder.AbleCommerceTax: 7.3.12396.0
CommerceBuilder.AcTestProvider: 1.0.0.0
CommerceBuilder.AustraliaPost: 7.1.0.0
CommerceBuilder.AuthorizeNet: 7.0.9764.0
CommerceBuilder.BankOfCanada: 7.3.0.0
CommerceBuilder.CanadaPost: 7.0.0.0
CommerceBuilder.Configuration: 7.3.12065.0
CommerceBuilder.CyberSource: 7.0.9310.0
CommerceBuilder.Data: 7.3.12065.0
CommerceBuilder.DataClient.Api: 7.3.130.0
CommerceBuilder.DataClient.Csv: 7.3.130.0
CommerceBuilder.DHLInternational: 7.2.11307.0
CommerceBuilder.ECB: 7.0.0.0
CommerceBuilder.FedEx: 7.0.9725.0
CommerceBuilder.GoogleCheckout: 7.0.10052.0
CommerceBuilder.InternetSecure: 7.0.9764.0
CommerceBuilder.LinkPoint: 7.0.9764.0
CommerceBuilder.Paradata: 7.0.9764.0
CommerceBuilder.PayFlowPro: 7.0.10061.0
CommerceBuilder.PayJunction: 7.2.11284.0
CommerceBuilder.PayPal: 7.3.12238.0
CommerceBuilder.Protx: 7.3.12327.0
CommerceBuilder.Services: 7.3.12065.0
CommerceBuilder.SkipJack: 7.0.9764.0
CommerceBuilder.UPS: 7.0.10041.0
CommerceBuilder.USPS: 7.0.9728.0
CommerceBuilder.Web: 7.3.12065.0
ComponentArt.Web.UI: 2008.2.1267.35
CyberSource.Base: 2.0.0.0
CyberSource.Clients: 5.0.2.0
CyberSource.Clients.XmlSerializers: 5.0.2.0
CyberSource.WSSecurity: 2.0.0.0
CybsWSSecurityIOP: 1.0.0.0
FredCK.FCKeditorV2: 2.5.2912.21007
ICSharpCode.SharpZipLib: 0.85.5.452
LinkPointTransaction: 1.0.1797.29766
log4net: 1.2.10.0
Microsoft.Practices.EnterpriseLibrary.Common: 2.0.0.0
Microsoft.Practices.EnterpriseLibrary.Data: 2.0.0.0
Microsoft.Practices.ObjectBuilder: 1.0.51205.0
Microsoft.Web.Preview: 1.2.61025.0
NVelocity: 7.2.0.0
PaygatewayNET: 3.0.0.0
paypal_base: 4.2.1.0
PFProCOMLib: 1.0.0.0
PFProdotNET: 0.0.0.0
Validators: 1.0.0.0
WebChart: 1.1.1.6
wwHoverPanel: 1.85.0.0

[mazhar]

I just tried the universal version of dataport and seems good to me. You can try it by downloading it from here
ftp://ftp.ablecommerce.com/DataPort/beta/
download File:AbleCommerceDataPort_Universal_74.zip (DataPort) and then download AbleCommerceDataPort_ClientAPI_703_4.zip file containing updated api file and service file. Give a try to it.

[mazhar]

hautebox I have tried the 7.0.3 dataport with 7.3.130 API and it seems good to me. Could you post some sample CSV for which you are having problem?

[hautebox]

here is a listing which contains a sub-set of the larger dataset....this too is giving me the same error message...

ps...tried to upload the actual csv file to this mssg, but say's the following when i post

The extension csv is not allowed.

Below is the data in my csv file
*********************

SKU Name Retail Category
0100-0200-0001 Wheat Tortilla filled with Potatoes Eggs and Spanish Beef Chorizo 5.95 Breakfast
0100-0200-0002 Wheat Tortilla filled with Traditional Ham Gruyere Cheese Italian Parsley Omelet 5.95 Breakfast
0100-0200-0003 Wheat Tortilla filled with Scrambled Eggs Turkey Bacon Roasted Red Bell Pepper 5.95 Breakfast
0100-0200-0004 Wheat Tortilla filled with Scrambled Eggs Spanish Chorizo and Spinach 5.95 Breakfast
0100-0200-0005 French Crepe filled with Mushrooms Bechamel Ham and Swiss Cheese 5.95 Breakfast
0100-0200-0006 French Crepe Filled with Breakfast Sausage Red Onion Marmalade 5.95 Breakfast
0100-0200-0007 Spinach Tortilla Tacos filled with Potatoes Eggs Spinach and Salmon 5.95 Breakfast
0100-0200-0008 Wheat Tortilla Tacos filled with Potatoes Eggs Lean Turkey Sausage 5.95 Breakfast

[hautebox]

just a note...on the universal dataport...got the following message...selected ok

Field length should be extended from '100' to '255' for field 'Name' for database table 'ac_DigitalGoods'.
Field length should be extended from '100' to '255' for field 'FileName' for database table 'ac_DigitalGoods'.
Field length should be extended from '100' to '255' for field 'MediaKey' for database table 'ac_DigitalGoods'.
Field length should be extended from '100' to '255' for field 'Name' for database table 'ac_GiftCertificates'.
Field length should be extended from '40' to '50' for field 'SerialNumber' for database table 'ac_GiftCertificates'.
Field length should be extended from '100' to '255' for field 'Name' for database table 'ac_OptionChoices'.
Field length should be extended from '20' to '255' for field 'SkuModifier' for database table 'ac_OptionChoices'.
Field length should be extended from '100' to '255' for field 'Name' for database table 'ac_OrderItemDigitalGoods'.

Selected Ok...

Data fields changed successfully...

Will run the new utility to test shortly...back with results in a minute

[hautebox]

BRILLIANT...!!!!

Same dataset imported without error and to the correct categories with the Universal DPU...

So much for the old DPU version...