12/1 - AbleCommerce Data Client Utility 7.0

[Naveed]

I'm trying to export a category using customized download with a selected category so i can change the category names of the products and reload them to a different category . (Doesn't matter if i export in .XML or .CSV, the error below is the same:

Application Error:
Authentication Failed. An unknow error occured while processing request. Exception Message: The text, ntext or image data type cannot be selected as DISTINCT.
at CommerceBuilder.DataClient.Api.ACRequestHandler.ProcessRequest(String requestXml)
at Client APIService.ProcessRequest(HttpContext context)

Invalid Response From Server.

What's happening?

This seems some versioning problem. I think you have not updated your store correctly. Can you please confirm copy paste your AbleCommerce versioning information here?
You can collect this information from your website admin interface. Login to your website as an administrator and navigate to Help -> About AbleCommerce page. From the "About AbleCommerce" page copy paste the information shown in the text area.

[jmestep]

I tried it and didn't get an error, but it added them to another category instead of moving them.
Here is what I did:
Downloaded 9 products from a category
Changed the category in the spreadsheet to a different category
Uploaded that file.
Categories in the .csv downloaded were:
Paintball:Barrels:Barrels by Gun:Angel Barrels

I changed to
Paintball:Barrels:Barrels by Gun:Autococker Barrels

They are now in both categories, so I guess you can't move them with the Dataport csv

[mfreeze]

I downloaded and installed the Dataport 19 and it looks like it is still not handling ESD files. I exported an ACMX 5.5 store and imported it to an AC7 store and it appears that the ESD files were not imported even though the ESD.txt file was created and there were no errors in the log. I checked the ac_DigitalGoods and ac_ProductDigitalGoods tables after the import and they are both empty so it seems that no ESD information was imported.

This particular client has over 1100 ESD files and we desperately need to get them imported to the AC7 store; there are far too many to manually redo. If the Dataport is not going to handle them, can Able supply a script to migrate them to the 7.0 release? If not can you give us a list of all AC7 tables that need updated for digital goods and, if possible, their 5.5 equivalents so we can write our own script.

This is an important feature that the Dataport needs to handle. I have a number of clients that use digital goods, some that have already been upgraded, and have vehemently complained about the need to manually redo all their digital goods. When might we expect the Dataport to handle them?

I tried to attach my XML file but the upload never completed (it is about 60mb) so if you need it, I can either try again or make it accessible on one of my ftp sites.

[mfreeze]

The import also missed importing a large number of products. The 5.5 products table contains 1434 products and the 7.0 table has only 1077.

I uploaded the XML file for your review.

[Shopping Cart Admin]

Hello Mary,

I'm unable to find a bug report on this, when and how was this reported?

I downloaded and installed the Dataport 19 and it looks like it is still not handling ESD files. I exported an ACMX 5.5 store and imported it to an AC7 store and it appears that the ESD files were not imported even though the ESD.txt file was created and there were no errors in the log. I checked the ac_DigitalGoods and ac_ProductDigitalGoods tables after the import and they are both empty so it seems that no ESD information was imported.

[mfreeze]

Case # 2315.

[Shopping Cart Admin]

Hello Mary,

That was just posted today, so I doubt the fix made it into last weeks release . Thank you for posting and choosing AbleCommerce.

[mfreeze]

That's correct. I downloaded the new release because the prior one didn't work with ESD files, which I believe has been reported previously, hoping it would handle them.

Since it didn't I need some resolution to get the digital goods moved over since this site can't go live without them.

[jmestep]

The import also missed importing a large number of products. The 5.5 products table contains 1434 products and the 7.0 table has only 1077.

Did the missing ones have kits? It might not do kits yet.

[mfreeze]

I don't believe this site uses kits. I suspect the missing products are ones that have names too long to fit into the new size specification for the product names. He has some products with really long names. In older Dataports, I got an error message and had to fix the length of the title but I suspect the new Dataport is just skipping them.

I'm going to run a compare tomorrow and see if my hunch is correct.

[Shopping Cart Admin]

Hello Mary,

When final is release the product title field has been expanded back to 255 char's. So that issue should be gone.

[Naveed]

Yes the ESD import for AC5x is not yet supported. And the missing products might be ESD products..

Can you please share your AC55 data with us so that we can examine what products are missing and what is causing this issue?

[mfreeze]

Naveed,

I had trouble uploading the XML file so I zipped it and emailed it to you.

We did find out one thing. A query of the old database shows 357 products that have names longer than 100 and this matches the number of missing products. I am going to restore the database, increase the name field in the db to 255 and try the import again.

[pmcalister]

I exported my AC 5.5 .net data and the only option I have is to export all the data to an xml file. I did this through the 5.5 admin interface Setup>Data Transfer>Export Data.

I then go to Store Upload in the Data Port tool. Browse to the xml created in the steps above. I select IMPORT new.

It says it is done but I dont see any of the info in the new store.

[Naveed]

I exported my AC 5.5 .net data and the only option I have is to export all the data to an xml file. I did this through the 5.5 admin interface Setup>Data Transfer>Export Data.

I then go to Store Upload in the Data Port tool. Browse to the xml created in the steps above. I select IMPORT new.

It says it is done but I dont see any of the info in the new store.

I suppose you have choosen AC5x import option. If you are using the DataPort vs. .19 then
please :
1. Have you manually verified the exported XML file and all the expected exported data is there?
2. If AC55 xml file is Ok, then you can enable Extra debug option and this will save all import log in smaller chunk log files. Then please check that log and see what errors are registered during import. Is all log Ok and showing all data is imported successfully?

[Naveed]

Naveed,

I had trouble uploading the XML file so I zipped it and emailed it to you.

We did find out one thing. A query of the old database shows 357 products that have names longer than 100 and this matches the number of missing products. I am going to restore the database, increase the name field in the db to 255 and try the import again.

By enabling the extra debug options shows that about 357 products import fails due to some SQL truncation error. Although my database field length for product name is 255 but those products still failed to import... May be some other lengthy database field is causing this issue. Will post the exact problem after some more debugging..

[Shopping Cart Admin]

Hello All,

Naveed and Sohaib have put together some good documentation on the dataport utility in the AbleCommerce WIKI.

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

[jmestep]

Naveed, I think there is a post elsewhere in the forum about a couple of other fields that need to be increased >255 characters, like the image alt tag field.

[mkeith1]

mkeith1 wrote:
I'm trying to export a category using customized download with a selected category so i can change the category names of the products and reload them to a different category . (Doesn't matter if i export in .XML or .CSV, the error below is the same:

Application Error:
Authentication Failed. An unknow error occured while processing request. Exception Message: The text, ntext or image data type cannot be selected as DISTINCT.
at CommerceBuilder.DataClient.Api.ACRequestHandler.ProcessRequest(String requestXml)
at Client APIService.ProcessRequest(HttpContext context)

Invalid Response From Server.

What's happening?

Mike Keith



This seems some versioning problem. I think you have not updated your store correctly. Can you please confirm copy paste your AbleCommerce versioning information here?
You can collect this information from your website admin interface. Login to your website as an administrator and navigate to Help -> About AbleCommerce page. From the "About AbleCommerce" page copy paste the information shown in the text area.

_________________
Naveed Ashraf

Naveed, here is the build information

PLATFORM: ASP.NET
VERSION: 7.0
BUILD: 9381

AjaxControlToolkit: 1.0.10301.0
CommerceBuilder: 7.0.9366.0
CommerceBuilder.AuthorizeNet: 7.0.9374.0
CommerceBuilder.CanadaPost: 7.0.0.0
CommerceBuilder.CCH: 7.0.0.0
CommerceBuilder.Configuration: 7.0.9344.0
CommerceBuilder.CyberSource: 7.0.9310.0
CommerceBuilder.DataClient.Api: 1.0.0.19
CommerceBuilder.DataClient.Csv: 1.0.0.0
CommerceBuilder.DHL: 7.0.8825.0
CommerceBuilder.ECB: 7.0.0.0
CommerceBuilder.FedEx: 7.0.9292.0
CommerceBuilder.FRBNY: 7.0.0.0
CommerceBuilder.GoogleCheckout: 7.0.9243.0
CommerceBuilder.InternetSecure: 7.0.9219.0
CommerceBuilder.LinkPoint: 7.0.9195.0
CommerceBuilder.Paradata: 7.0.9206.0
CommerceBuilder.PayFlowPro: 7.0.9198.0
CommerceBuilder.PayJunction: 7.0.9197.0
CommerceBuilder.PayPal: 7.0.9354.0
CommerceBuilder.Services: 7.0.9344.0
CommerceBuilder.SkipJack: 7.0.9194.0
CommerceBuilder.UPS: 7.0.8695.0
CommerceBuilder.USPS: 7.0.8568.0
CommerceBuilder.Web: 7.0.9344.0
ComponentArt.Web.UI: 2007.1.1566.3
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
edtFTPnet: 1.2.4.0
FredCK.FCKeditorV2: 2.2.2833.20809
ICSharpCode.SharpZipLib: 0.85.1.271
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.0.8530.0
PaygatewayNET: 3.0.0.0
PayPal.Web.Controls: 1.0.22.18680
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.60.0.0

the DATAPORT is version 1.0.0.19

Ablecommerce is hosting my store, so I believe you guys are in charge of updating the store

Also, as a side note, since AC7 is in final release, did the Name field get lengthened to 255 characters?

[jmestep]

Yes, the name got changed.

[Naveed]

Ablecommerce is hosting my store, so I believe you guys are in charge of updating the store

Your file versions seems to be OK. And AbleCommerce Hosting and Development are handled by two saperate departments...

Also, as a side note, since AC7 is in final release, did the Name field get lengthened to 255 characters?

Yes the Product Name field is lengthened to 255 characters in the final build. However the SQL truncation error can occur if any of your AC55 field length exceeds then the respective AC7 field lenght.

The SQL error you are facing is strange, and I think there is still some inconsistancy at your store, may be the database is inconsistant or is not updated properly...

You can run database upgrade on your store by following these steps:

1. Navigate the following URL at your store : http://[YOURSTORE.COM]/Install/Upgrade.aspx. You will be able to do this if the Install folder is still there and not yet removed..

2. Follow the instructions on the Upgrade.aspx page to run database upgrade routines on your store.

You can get read the ReadMe instructions for database upgrade as well..
Please let me know if it is not fixed even after running database upgrade

[Naveed]

Hello Mkeith1
Perhaps upgrading to final release may solve this issue on your store..
Read this for how to upgrade to 7.0 final.
http://help.ablecommerce.com/upgrades/a ... sp.net.htm

[eggheaddesign]

Hi

Is there any possibility that you will include better support for variants in the CSV export? I ask because at the moment, you export products in CSV, but not a line per variant.

Where this would be useful is inventory management - a client could download a csv file with one line for each varaint, update the inventory level for that variant in Excel and then reupload the csv file.

Right now, the only way to achieve this is to download as XML - which isn't exactly a friendly format for a client to use. Sure, we could write a utility to do this, but I just figure that it would be easier for you guys to do this as part of the CSV export/import functionality.

I have several clients who sell fashion items and they rarely have products that don't have variants (they either have size or colour options), and they may have several thousand product lines. Managing inventory one at a time is pretty laborious, and most clients are really comfortable working in Excel.

All the Best

Tony

[jmestep]

Vista display problem.

dataport_appearance.JPG

[mkeith1]

You can use the dataport if you use the dropdown menus.