12/1 - AbleCommerce Data Client Utility 7.0

[AbleBody]

Found the Wiki entry for this... want to let you know the link to download the dataport still points to .19... can you pl. change it to the .31 version?

http://wiki.ablecommerce.com/index.php/DataPort_Utility

Thanks.
-sri
sri@awcs.net

[Naveed]

Yes, options and variants are fully importable from AC55 now for .31 version.

[Naveed]

the link to download the dataport still points to .19... can you pl. change it to the .31 version?

Thanks for the information, the link is updated.

[AbleBody]

Thanks Naveed for the response.

I checked the Wiki page but it doesn't seem to contain any info on how the Options / Variants have to be setup for import... can you point me to where the layout in the excel or CSV is described? Thanks again for watching this forum...

-sri
sri@awcs.net

[Naveed]

I checked the Wiki page but it doesn't seem to contain any info on how the Options / Variants have to be setup for import... can you point me to where the layout in the excel or CSV is described?

I think you are taking about AC7 product variants CSV import feature request. Unfortunately that feature is not yet there in beta .31. Hopefully it will be available for next versions..

Feature request is already under discussion...

[mkeith1]

how about creating a new topic in the forum for the new dataport, so we dont have to dig through 10 pages of posts on the old one.

[AbleBody]

Yes... please start a new thread.

Meantime, Naveed - can you clarify: you are saying I won't be able to export AC 5.5 products that have options/variants and import them into AC 7.0 store using dataport?

So, the steps would be to import the products using Dataport and then manually import the Options/Variants using SQL or some other way?

Pl. confirm.

Thanks.
-sri
sri@awcs.net

[Shopping Cart Admin]

Hello Sri,

Meantime, Naveed - can you clarify: you are saying I won't be able to export AC 5.5 products that have options/variants and import them into AC 7.0 store using dataport?

Using xml yes. Using CSV no.

[AbleOne]

Mike,

just need to be clear as this has been a big issue for us.

If we use the XML file we can import options. If we use the CSV format we cannot.

If you read your answer literally as if answering Sri's post it could be interpreted as the opposite.

thanks,

Randy

[Shopping Cart Admin]

Hello Randy,

This is correct.

If we use the XML file we can import options. If we use the CSV format we cannot.

[Naveed]

AC55 import feature supports product options and variants import. AC55 import feature is there to upgrade your store from AC55 to AC7. To use this feature you should have AC55 data exported in XML format form AC55 stores.

However if we are using CSV import / export features you can not export/import product variants. Keep in mind that CSV import / export feature is there to facilitate batch editing and to help you importing data from sources other then AbleCommerce.

To import data from AC55 stores always use the AC 5.x Upload feature.

[Naveed]

Yes, beta .31 supports options and variants import from AC55, however we have a known issue when importing (ESD digital good -> product variants) associations. This is fixed for the next release which we are planning to release in a week or so...

[eggheaddesign]

Hi

Is it possible using the Store Upload to update the fields in the ProductCustomFiled table?

We created some data in ProductCustomField and did a download of the store, and were very happy when the product node had the custom field in it.

However, when we modified the custom field node and uploaded the XML file, we got an exception.

Is this normal?

Cheers

Tony

[sohaib]

However, when we modified the custom field node and uploaded the XML file, we got an exception.

What did you change/modify in the custom field node?

[eggheaddesign]

However, when we modified the custom field node and uploaded the XML file, we got an exception.

What did you change/modify in the custom field node?

Hi Sohaib

I changed the contents of the FieldValue node

Cheers

Tony

[Naveed]

If it is behaving like this then it must be a bug
Let me verify myself...

[sohaib]

What exception do you get?

Can you give some example of field value before and after your changes?

[Naveed]

I am not much confirm about Product Custom fields, I think this is an unused feature in AC7 and Product Template fields is the new feature currently replacing this one...
May be Mazhar can do a little research that how we can define custom fields using product xml....

[eggheaddesign]

Hi Sohaib/Naveed

XML downloaded from store originally was:

<CustomFields>
<ProductCustomField>
<ProductFieldId>1</ProductFieldId>
<ProductId>1</ProductId>
<IsUserDefined>true</IsUserDefined>
<IsVisible>true</IsVisible>
<FieldName>tEST</FieldName>
<FieldValue>Test</FieldValue>
</ProductCustomField>
</CustomFields>

Modified to:

<CustomFields>
<ProductCustomField>
<ProductFieldId>1</ProductFieldId>
<ProductId>1</ProductId>
<IsUserDefined>true</IsUserDefined>
<IsVisible>true</IsVisible>
<FieldName>tEST</FieldName>
<FieldValue>Update</FieldValue>
</ProductCustomField>
</CustomFields>

Exception was:


Store Import(Upload) Log Dated:06/11/2008 12:50:12
User Name:- tony.leatham@eggheaddesign.co.uk
Store:- New Store
Service URL:- http://localhost/ac7/clientapi/clientapiservice.ashx
Start Time:- 06/11/2008 12:50:08 End Time:- 06/11/2008 12:50:12
Import(Upload) Items:- Products
Imported File:- C:\Documents and Settings\tony\Desktop\ac7.xml
*****************************************
Server Log:-


Importing 40 Products
Importing 1 ProductCustomFields

Object reference not set to an instance of an object.
ImportOrUpdate unsuccessful for Product
ProductId = 1
Name = Personalized Gift Certificate
Error message: Object reference not set to an instance of an object.

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)
at CommerceBuilder.DataClient.Api.ObjectHandlers.ImportHandler.ImportChildObjectsArray(Array schemaObjectsArray, Type acType, String objName, String idFieldName, String displayNamePropertyName, Object parentId, TryLoadExistingObject tryLoadExistingObject, TranslateObjectAssociatedIds translateObjectAssociatedIds, ImportObjectChildsAndAssociations importObjectChildsAndAssociations)
at CommerceBuilder.DataClient.Api.ObjectHandlers.ImportHandler.ImportProductCustomFields(ProductCustomField[] arrImportObjects, Int32 parentId)
at CommerceBuilder.DataClient.Api.ObjectHandlers.ImportHandler.<ImportProducts>b__89(Object& acProductKitComponent, Object schemaProductKitComponent)
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: Object reference not set to an instance of an object.
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)
at CommerceBuilder.DataClient.Api.ObjectHandlers.ImportHandler.ImportChildObjectsArray(Array schemaObjectsArray, Type acType, String objName, String idFieldName, String displayNamePropertyName, Object parentId, TryLoadExistingObject tryLoadExistingObject, TranslateObjectAssociatedIds translateObjectAssociatedIds, ImportObjectChildsAndAssociations importObjectChildsAndAssociations)
at CommerceBuilder.DataClient.Api.ObjectHandlers.ImportHandler.ImportProductCustomFields(ProductCustomField[] arrImportObjects, Int32 parentId)
at CommerceBuilder.DataClient.Api.ObjectHandlers.ImportHandler.<ImportProducts>b__89(Object& acProductKitComponent, Object schemaProductKitComponent)
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)
Importing 1 Options
Importing 2 OptionChoices
0 OptionChoice(s) imported, 2 OptionChoice(s) updated.
OptionChoice(s) Import Complete...
0 Option(s) imported, 1 Option(s) updated.
Option(s) Import Complete...
Importing 4 ProductImages
0 ProductImage(s) imported, 4 ProductImage(s) updated.
ProductImage(s) Import Complete...
Importing 1 Options
Importing 3 OptionChoices
0 OptionChoice(s) imported, 3 OptionChoice(s) updated.
OptionChoice(s) Import Complete...
0 Option(s) imported, 1 Option(s) updated.
Option(s) Import Complete...
Importing 3 ProductVariants
0 ProductVariant(s) imported, 3 ProductVariant(s) updated.
ProductVariant(s) Import Complete...
Importing 1 ProductReviews
0 ProductReview(s) imported, 1 ProductReview(s) updated.
ProductReview(s) Import Complete...
Importing 4 ProductTemplateFields
0 ProductTemplateField(s) imported, 4 ProductTemplateField(s) updated.
ProductTemplateField(s) Import Complete...
Importing 1 ProductReviews
0 ProductReview(s) imported, 1 ProductReview(s) updated.
ProductReview(s) Import Complete...
Importing 3 Options
Importing 3 OptionChoices
0 OptionChoice(s) imported, 3 OptionChoice(s) updated.
OptionChoice(s) Import Complete...
Importing 3 OptionChoices
0 OptionChoice(s) imported, 3 OptionChoice(s) updated.
OptionChoice(s) Import Complete...
Importing 31 OptionChoices
0 OptionChoice(s) imported, 31 OptionChoice(s) updated.
OptionChoice(s) Import Complete...
0 Option(s) imported, 3 Option(s) updated.
Option(s) Import Complete...
Importing 279 ProductVariants
0 ProductVariant(s) imported, 279 ProductVariant(s) updated.
ProductVariant(s) Import Complete...
Importing 1 ProductReviews
0 ProductReview(s) imported, 1 ProductReview(s) updated.
ProductReview(s) Import Complete...
Importing 1 Options
Importing 4 OptionChoices
0 OptionChoice(s) imported, 4 OptionChoice(s) updated.
OptionChoice(s) Import Complete...
0 Option(s) imported, 1 Option(s) updated.
Option(s) Import Complete...
Importing 1 ProductDigitalGoods
0 ProductDigitalGood(s) imported, 1 ProductDigitalGood(s) updated.
ProductDigitalGood(s) Import Complete...
Importing 1 Options
Importing 2 OptionChoices
0 OptionChoice(s) imported, 2 OptionChoice(s) updated.
OptionChoice(s) Import Complete...
0 Option(s) imported, 1 Option(s) updated.
Option(s) Import Complete...
Importing 2 ProductDigitalGoods
0 ProductDigitalGood(s) imported, 2 ProductDigitalGood(s) updated.
ProductDigitalGood(s) Import Complete...
Importing 1 ProductReviews
0 ProductReview(s) imported, 1 ProductReview(s) updated.
ProductReview(s) Import Complete...
Importing 1 Options
Importing 4 OptionChoices
0 OptionChoice(s) imported, 4 OptionChoice(s) updated.
OptionChoice(s) Import Complete...
0 Option(s) imported, 1 Option(s) updated.
Option(s) Import Complete...
Importing 2 Options
Importing 2 OptionChoices
0 OptionChoice(s) imported, 2 OptionChoice(s) updated.
OptionChoice(s) Import Complete...
Importing 4 OptionChoices
0 OptionChoice(s) imported, 4 OptionChoice(s) updated.
OptionChoice(s) Import Complete...
0 Option(s) imported, 2 Option(s) updated.
Option(s) Import Complete...
Importing 8 ProductVariants
0 ProductVariant(s) imported, 8 ProductVariant(s) updated.
ProductVariant(s) Import Complete...
Importing 1 ProductReviews
0 ProductReview(s) imported, 1 ProductReview(s) updated.
ProductReview(s) Import Complete...
0 Product(s) imported, 40 Product(s) updated.
Product(s) Import Complete...


Importing ProductAssociations
Importing 4 RelatedProduct Associations
RelatedProduct Associations Import complete.
ProductAssociations Import Complete


Importing ProductAssociations
Importing 5 UpsellProducts Associations
UpsellProducts Associations Import complete.
ProductAssociations Import Complete

Hope this helps

Tony

[sohaib]

I think we need to have a look at this one. It might be a bug.

Simple update of FieldValue should not have caused an exception.

[sohaib]

Btw. How are you using the ProductCustomFields.
Have you done any customizations?

[eggheaddesign]

Btw. How are you using the ProductCustomFields.
Have you done any customizations?

We hope to be able to use ProductCustomField to hold data elements that are not directly supported in Able, including tags for our accounting system.

The product catalogue is being generated by an external tool, and it would be really nice to use the Data Port utility as this will save on this bit of development.

All the Best

Tony

[AbleBody]

Mazhar,
One other thing I noticed : we recently imported a 50MB export file from a 5.5 store with over 1400 categories and 15000 products. Everything went fine... except quite a few categories were not put in the right place as a sub-category. Rather they all ended up in the root. Checked the original store and they are not orphans... they are setup correctly.

I looked at the XML and the only differentiating datapoint for all these categories that ended up in the root was the "OrderBy" field value. They were all "0". Like so :
<OrderBy>0</OrderBy>

There were other sub-categories for the same parent that went to the right location.. and the XML data for both looks alike except for the OrderBy above.

I think this might be causing an issue during import... can you please test this as well at your end? I have over 150 sub-categories that are in root and need to be moved manually

I will check with client and see if we can provide the XML file... but guessing you can recreate that easily at your end.

Thanks.

-sri
sri@awcs.net

[bbehm]

Is there any documentation and/or sample code published for the http://[YourStoreURL]/ClientApi/ClientApiService.ashx web service?

Also, is there any documentation or an XSD for the AbleCommerce 7 XML format used by the DataPort Utility?

Thanks,
Brian

[mkeith1]

attached is a file and the error report (zipped) which i got using the most current dataport.
the error message on the products in this file is:
Error message: Exception has been thrown by the target of an invocation.

could some of you look at the file and tell me what went wrong.

error file.zip