Help with store products upload errors

[jedidadjc]

Hi, I am new at this. I have uploaded csv spreadsheets, and it seems that only some of them are uploading ok, some are coming back with errors. I am trying to figure out why. I am enclosing the error it gives me for a particular part I am trying to add. Any help would be appreciated, as I am going nuts trying to figure out why. Thanks! John

I have an ablecommerce 7.0 store
dataport version- 1.0.0.31

-----------------------------------------------
Gives me this error when I log into the dataport- not sure it this is why it is only giving me errors on SOME of the products, not all:

Title: Warning...
Summary: You have successfully authenticated and connected to the server. However, while checking for version compatibility the following warning(s) occurred:
Detailed Message: Warning: Version mismatch, You are running DataPort utility 1.0.0.31 for AbleCommerce 7.0 Store and we have detected an older version of CommerceBuilder.DataClient.Api.dll in the AbleCommerce \bin\ folder. Please update the DLL to match the version of the DataPort utility.
Please make sure that you are using the latest version of DataPort and the DataPort API. It is strongly recommended to update your store and get the compatible version of DataPort application.

--------------------------------------------------------------------
Here is the error the dataport gives me when uploading my csv file. This is just ONE example, but they all look the same:


Exception has been thrown by the target of an invocation.
Import unsuccessful for Product
ProductId = 0
Name = 930-1026 GR-303 host with P-phone service support
Error message: Exception has been thrown by the target of an invocation.

at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at System.Reflection.MethodBase.Invoke(Object obj, Object[] parameters)
at CommerceBuilder.DataClient.Api.ObjectHandlers.ImportHandler.<.ctor>b__83(Object& acObject)
at CommerceBuilder.DataClient.Api.ObjectHandlers.ImportHandler.ImportChildObjectsArray(Array schemaObjectsArray, Type acType, String objName, String idFieldName, String displayNamePropertyName, Object parentId, TryLoadExistingObject tryLoadExistingObject, TranslateObjectAssociatedIds translateObjectAssociatedIds, SaveACObject saveACObject, ImportObjectChildsAndAssociations importObjectChildsAndAssociations)

Base Exception: String or binary data would be truncated.
The statement has been terminated.
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.ExecuteScalar()
at Microsoft.Practices.EnterpriseLibrary.Data.Database.DoExecuteScalar(DbCommand command)
at Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteScalar(DbCommand command)
at CommerceBuilder.Products.Product.BaseSave()
at CommerceBuilder.Products.Product.Save()

[jmestep]

The problem could be caused because of the version mis-match. You need to upload the dataclient dlls from the install folder of your dataport to your site bin folder.

[Jaz]

I get this same error and I checked that all the proper files are loaded on my web site. Looking at my store info, it list:

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


Could the posibility that the Build: is listed as unknown be a problem?

[Jaz]

I have the same problem for certain individual products, but I do not get a version mismatch error though. I just get:

Products Import(Upload) Log Dated:11/4/2010 8:06:07 PM
User Name:- david@trickconcepts.com
Store:- Trick Concepts
Service URL:- http://www.trickconcepts.com/ClientApi/ ... rvice.ashx
Start Time:- 11/4/2010 8:05:56 PM End Time:- 11/4/2010 8:06:07 PM
Total Products:- 301 Chunk Size:- 50
Imported File:- C:\Users\JAZ\Desktop\ac.csv
************************************************************

[Import(Upload) Information]:-

And then a lis of failed uploads.

[Jaz]

Well, I found the problem. I had too many characters for the keywords.