Trouble exporting products.

[SethMW]

I'm trying to help someone do an export so they can do a mass edit, and I am getting an error around record 800 of 940. There's no max limit is there? At least, nothing that low.

I'm not very familiar with AC, so I was hoping for some troubleshooting advice.

I tried setting up a query to only export the records around where it stops, and they all seem to export properly, so I don't think it's a data thing.

I suspect it might be a version mismatch, as I get this error when I start the DataPort...

Code: Select 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 7.0.34.0 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.

I get this from the Admin > Help > About AC:

Code: Select all

PLATFORM: ASP.NET
VERSION: 7.0
BUILD: 10125

AjaxControlToolkit: 1.0.10301.0
CommerceBuilder: 7.0.10110.0
CommerceBuilder.AuthorizeNet: 7.0.9764.0
CommerceBuilder.CanadaPost: 7.0.0.0
CommerceBuilder.CCH: 7.0.0.0
CommerceBuilder.Configuration: 7.0.10102.0
CommerceBuilder.CyberSource: 7.0.9764.0
CommerceBuilder.DataClient.Api: 1.0.0.21
CommerceBuilder.DataClient.Csv: 1.0.0.0
CommerceBuilder.DHL: 7.0.8825.0
CommerceBuilder.ECB: 7.0.0.0
CommerceBuilder.FedEx: 7.0.9725.0
CommerceBuilder.FRBNY: 7.0.0.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.0.9764.0
CommerceBuilder.PayPal: 7.0.10071.0
CommerceBuilder.Services: 7.0.9733.0
CommerceBuilder.SkipJack: 7.0.9764.0
CommerceBuilder.UPS: 7.0.10041.0
CommerceBuilder.USPS: 7.0.9728.0
CommerceBuilder.Web: 7.0.9777.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.5.2912.21007
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_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

The version of CommerceBuilder.DataClient.Api.dll is 1.0.0.21. Should that really be 7.something? How could that be so old?

Anyway, a little guidance would be greatly appreciated.

[Naveed]

I think you are using AbleCommerce vs. 7.0 (because you are using DataPort 7.0.34 which is for 7.0 stores). Anyhow to fix the version mismatch issue upload the correct CommerceBuilder.DataClient.Api.dll file to your store bin directory. I am not sure but I think (CommerceBuilder.DataClient.Api.dll vs. 7.0.34) is provided with the DataPort 7.0.34 zip download package.

If the (CommerceBuilder.DataClient.Api.dll vs. 7.0.34) file is not provided with the zip package you can find it from the DataPort install folder. Navigate to the location where you have installed DataPort application (normally at C:\Program Files\AbleCommerce\AbleCommerce DataPort 7.0.34\ directory). Copy the CommerceBuilder.DataClient.Api.dll file and upload it to your store bin directory.

To verify that the dll is properly uploaded, navigate to Admin -> Help -> About AbleCommerce page and check the version of API dll file. It should be same as of version of DataPort (7.0.34.0 in your case).

[SethMW]

I updated the assemblies, and now I cannot connect on the "Store Administrator Login" dialog... "Authentication Failed. Invalid user name or password."

I can still log in to /Admin/ on my store, though, so the creds seem to be fine.

[Naveed]

To connect DataPort to your sever the admin user must be a "Supper User". I think you are using an admin user account but the user is not a "Supper User".

[SethMW]

To connect DataPort to your sever the admin user must be a "Supper User". I think you are using an admin user account but the user is not a "Supper User".

I was able to connect and use the tool before I upgraded those DLLs, though.

[Naveed]

I was able to connect and use the tool before I upgraded those DLLs, though.

Yes with previous versions it was possible to connect DataPort with a normal admin user account but for later versions the admin user must be a "Supper user". Please read these FAQ's for common DataPort related questions;

Frequently Asked Questions (FAQ)
viewtopic.php?f=61&t=11102

[SethMW]

I got the new version, I am using a super admin, and I am getting an error at the same point.

The error is: System.InvalidOperationException:

There is an error in XML document (2793, 26). ...


Do these errors get logged anywhere? I don't see anything in the Event Viewer.

Again, this happens every time at about record 800 of 947.

[Naveed]

Did you uploaded the API dll file to your store bin directory correctly? You can confirm it by viewing the details at Help -> About AbleCommerce page in admin.

If every thing is OK and you are not getting any version mismatch etc. then there might be something wrong with your product data which is causing an error. There were a couple of reports in past stating a similar problem in product export routine. Please have a look at following bug report, as I think your case is similar:

http://bugs.ablecommerce.com/show_bug.cgi?id=7952

By following the steps mentioned in comment # 1 (http://bugs.ablecommerce.com/show_bug.cgi?id=7952#c1) and comment # 3 http://bugs.ablecommerce.com/show_bug.cgi?id=7952#c3 , you can find the exact product whose data causing this issue and by removing those special characters you will be able to fix the issue.

If you are able to fix the issue by following the above steps, please reply to this post and let us know that what special characters were causing this issue. As from the bug report status you can see that we are still unable to reproduce the issue, so, the issue is still not fixed and pending. With your help, I believe we can find and fix the root cause of the issue.

[SethMW]

Yup, that was the problem. I wasn't able to see what the characters were. I just got the hollow boxes. I'm guessing one was a type of apostrophe, and the other was a trademark symbol.