12/1 - AbleCommerce Data Client Utility 7.0

[mfreeze]

Clarification. I get the timeout after about 18 minutes.

[bha]

Where is the location of the database?

Thanks,
Bruce.

[mkeith1]

In the forthcoming dataport will there be a way to map any fields in my 5.5 version, such as name, sku, description1, or description 2 to the Keywords field found in AC7. I've got 180,000 products in version 5.5, and no way to import any of this into the keywords field. In ver. 5.5, the admin side can search for items using the Name, Description or SKU fields., version 7RC2 doesn't use the SKU field which would be the most unique field. Try searching for something which has a common description1 field with 100 other products.

[sohaib]

In the forthcoming dataport will there be a way to map any fields in my 5.5 version, such as name, sku, description1, or description 2 to the Keywords field found in AC7.

Yes I think there is a way using custom CSV templates. You define your own field mapping in these templates

[jmestep]

I did a test on the utility that is not available now, and I was able to map description to keywords, but only if description wasn't mapped to description. What you would have to do is put the description field in twice in your import file, once as description and once as keywords.

[jmestep]

The 'Preserve Ids' features will be part of the next build.
We are currently testing the implementation.

Are you going to be able to do this? I'm asking because the ProductId is an autonumber identity field. I just worked on an AC7 site where the customer was having database problems (not Able's fault) and to keep the numbering for all the products he had in a different database, I had to change ProductID from identity, copy the products in, set it back to identity.

[sohaib]

Are you going to be able to do this? I'm asking because the ProductId is an autonumber identity field. I just worked on an AC7 site where the customer was having database problems (not Able's fault) and to keep the numbering for all the products he had in a different database, I had to change ProductID from identity, copy the products in, set it back to identity.

We have already done it and it is working quite nicely in our tests.
In SQL you can turn On/Off the Identity Insert when inserting items with pre-calculated Ids

Code: Select all

SET IDENTITY_INSERT [ac_Products] ON;

[mkeith1]

I did a test on the utility that is not available now, and I was able to map description to keywords, but only if description wasn't mapped to description. What you would have to do is put the description field in twice in your import file, once as description and once as keywords.

Ok, Judy, after i've exported that 170,000 item, 700 category, 283,244 kb xml file, how do you suggest I open it in Excel so i can copy the description field and paste it into a new "keyword" field?

Shouldn't there be an easier way? Didn't Able already plan for this when they created a new field?

[jmestep]

They might have planned for it, but it isn't in the version of the dataport that I have. I did some quick testing after you asked the question. I know there were some 5.5 data import problems so they are working on the utility.
I could experiment a little more- what did you use to create your xml file-- the 5.5 store interface?
Are you trying to get this done before the data port utility comes out again? I have a client who was able to upload his products with the .csv file, but he wasn't moving from a 5.5 store. If I had a csv file and the older dataport that I have, I would do a computation in Excel or an Access query to create what I wanted into the keyword field.
I don't think that it is good that we have to put all this stuff in the keyword field just so it will show up in searches. That is too much redundancy and too much to maintain. I've been working on the Able code some to try to add description to the search fields where it isn't included. To me, keywords should be fairly short and used for things a customer might want to search on that isn't in the description. For example, for "toilet paper? I would put in Charmin in the keywords.

[mkeith1]

I tried to use the built in data transfer export option in able, but it errored out after exporting the products. So AC support sugested that i use the separate store export utility which I installed directly on the database server. This extracts the store in an .XML format. I used this file to import the 5.5 store into the 7.0 store. I'm waiting for the new and improved dataport which i hope will import the products into their 5.5 categories, and keep the same ID categories. I've already tried the import once, but products were placed into the root category. Users and orders from my 5.5 store didn't import either.

ok, got it.

[Shopping Cart Admin]

Hello,

The dataport for RC3 has been re-released !! Please see the initial post in this thread. The dll in the /bin directory still needs to be updated to include bug fixes over the last couple of days for 5.5 import.

[Michael Ward]

Hello Folks
Please note that the FTP location has changed. it is now at ftp://ftp.ablecommerce.com/evals/AbleCo ... 0.0.11.zip

Thanks

[Mark Harris]

Few bugs below,

* csv upload: The text is "please select xml file" however it only allows you to select a CSV file.
* the radio buttons are too far over to the right, i lose about 3 pixels of them to the group box.

* Cant upload customer passwords
* Cant upload customer addresses
* Cant upload customer date of birth
* Cant upload customer telephone, fax

pretty major: cannot import what products on the order. This software is therefore pretty useless if you want to transfer data from an old store to this one.


Can we get the source code for this application?

[AbleMods]

Shouldn't there be an easier way? Didn't Able already plan for this when they created a new field?

Have you tried doing a SQL query to populate the Keywords field after you import instead of during the import?

[bha]

Using the DataPort 1.0.0.11 and and corresponding api I get this error during the download of complete store and then it freezes.



Thanks,
Bruce.

[sohaib]

I have a 5.5 store with only 480 products but many variations. The store will not import into 7.0; it fails with an http timeout.

If you can share this file, It will certainly be very helpful. There is probably something in your file that hasn't come up in our test scenarios yet.

[HeroicLife]

I created a new RC3 store and tried to import our 5.5 data. The import ran for about 12 hours, but it failed to import any orders. I did copy the CommerceBuilder.DataClient.Api.dll to bin.

I don't see anything regarding orders in the log, but I do see:

75% : Import Unsuccessfull, Error Message:Method not found: 'CommerceBuilder.Common.SaveResult CommerceBuilder.Users.Wishlist.SaveForUser(Int32)'.
at CommerceBuilder.DataClient.Api.Ac55Importer.ImportWishlists(XmlNode nodSourceStore)
at CommerceBuilder.D(for more details check server log)...

Also lots of:

63% : The INSERT statement conflicted with the FOREIGN KEY constraint "ac_Countries_ac_Addresses_FK1". The conflict occurred in database "AbleCommerce", table "dbo.ac_Countries", column 'CountryCode'.
The statement has been terminated.

[sohaib]

Which version of DataClient utility are you using?
How big is your XML file btw? 12 hrs is a lot of time.
Did the import process complete or did it halt after 12 hours?

[HeroicLife]

Using AbleCommerceDataPort_1.0.0.11.zip
We have about 30,000 orders, and they took almost the whole of that duration, even though 0 succeed.
192mb XML file. We've send you two previous versions of our export before.

[sohaib]

We did a lot of testing using the files that you sent.
We will have a look at them once again.

Just to confirm.
- You are using RC3
- You copied the latest CommerceBuilder.DataClient.Api.dll to Website/Bin
- You were importing in a new empty store?
- The import process did complete but orders were not imported
- The error log shows two type of errors as reported above

[HeroicLife]

Yes. Using ac7_b9381.zip

The order import worked fine with previous versions. Nothing else seems to be missing, other than Wishlists and user roles.
Any inventory item with options is showing 0 for inventory.

From the "Method not found" error, it looks like a version mismatch somewhere. Here is the import log: http://www.mises.org/AC7/ImportErrors.txt

We are using ASP.Net 3.5, but we used that for previous versions as well.

PLATFORM: ASP.NET
VERSION: 7.0
BUILD: 7973

AjaxControlToolkit: 3.0.20229.20843
CommerceBuilder: 7.0.0.1
CommerceBuilder.AuthorizeNet: 7.0.0.0
CommerceBuilder.DataClient.Api: 1.0.0.11
CommerceBuilder.DataClient.Csv: 1.0.0.0

[sohaib]

It seems your store hasn't been upgraded properly.

Code: Select all

ac7_b9381.zip

Build should be 9381

Code: Select all

VERSION: 7.0
BUILD: 7973

Latest version of CommerceBuilder DLL is

Code: Select all

CommerceBuilder: 7.0.9381.0

Your version is

Code: Select all

CommerceBuilder: 7.0.0.1

[dwawrzyn]

Has anyone tried to upload a product with multiply options? The example is product that comes in a small, medium or large size?

[HeroicLife]

Latest version of CommerceBuilder DLL is

Code: Select all

CommerceBuilder: 7.0.9381.0

Your version is

Code: Select all

CommerceBuilder: 7.0.0.1

OK, I have downloaded my third copy of "ac7_b9381.zip" aka "AbleCommerce 7x Development" in my Orders page. All the versions of CommerceBuilder.dll say "7.0.0.1" for the file version. Also, the most recent date is October 12, 2007.

[HeroicLife]

Update: The 30-day evaluation version on the other hand, is the right version of ac7_b9381.zip!