12/1 - AbleCommerce Data Client Utility 7.0
- Shopping Cart Admin
- AbleCommerce Admin
- Posts: 3055
- Joined: Mon Dec 01, 2003 8:41 pm
- Location: Vancouver, WA
- Contact:
12/1 - AbleCommerce Data Client Utility 7.0
Hello Everyone,
WARNING: Backup your database before using this tool !
The AbleCommerce data port utility greatly reduces the time to upload large catalogs into AbleCommerce.
1. Download your entire store as an XML package.
2. Upload your entire store as an XML package.
3. Download Products, Categories, Users and Order in CSV or XML format.
4. Upload Products, Categories, Users and Orders in CSV or XML format.
5. Create templates to map CSV data from other sources to the AbleCommerce fields and save the template for later.
6. Upload AbleCommerce 5.5 XML data to AbleCommerce 7.0
---------------------------------------------------------------------------------------
WARNING: BACKUP YOUR DATABASE BEFORE USING THIS TOOL !
---------------------------------------------------------------------------------------
Download AbleCommerce Data Client 7.0.34:
ftp://ftp.ablecommerce.com/evals/AbleCo ... 7.0.34.zip
BUG REPORTING:
---------------------------------------------------------------------------------------
Report bugs by at the following URL by clicking the need help icon at the bottom of the page.
http://help.ablecommerce.com/report_bug.htm
WARNING: Backup your database before using this tool !
The AbleCommerce data port utility greatly reduces the time to upload large catalogs into AbleCommerce.
1. Download your entire store as an XML package.
2. Upload your entire store as an XML package.
3. Download Products, Categories, Users and Order in CSV or XML format.
4. Upload Products, Categories, Users and Orders in CSV or XML format.
5. Create templates to map CSV data from other sources to the AbleCommerce fields and save the template for later.
6. Upload AbleCommerce 5.5 XML data to AbleCommerce 7.0
---------------------------------------------------------------------------------------
WARNING: BACKUP YOUR DATABASE BEFORE USING THIS TOOL !
---------------------------------------------------------------------------------------
Download AbleCommerce Data Client 7.0.34:
ftp://ftp.ablecommerce.com/evals/AbleCo ... 7.0.34.zip
BUG REPORTING:
---------------------------------------------------------------------------------------
Report bugs by at the following URL by clicking the need help icon at the bottom of the page.
http://help.ablecommerce.com/report_bug.htm
Last edited by Shopping Cart Admin on Sat Mar 29, 2008 11:03 am, edited 7 times in total.
Hi Mike,
Maybe not a bug. I didn't realize my version of Excel was so old. What are the spreadsheet/dbase programs other than Excel 2003+ are know to be compatible with the AC7 Data Client? I hate to have to buy Office 2007 just to get an updated copy of Excel.
I figured that it was the database we are uploading to that needed to be backed-up per the readme?
Best Regards,
Rom
[quote="Shopping Cart Admin"]Hello,
I don't know where your database is for backup? I've uploaded tons of products using the and never seen this error. When reporting the bug be sure to let them know what build you're running and we'll likely need a copy of your csv file to investigate this matter.
Maybe not a bug. I didn't realize my version of Excel was so old. What are the spreadsheet/dbase programs other than Excel 2003+ are know to be compatible with the AC7 Data Client? I hate to have to buy Office 2007 just to get an updated copy of Excel.
I figured that it was the database we are uploading to that needed to be backed-up per the readme?
Best Regards,
Rom
[quote="Shopping Cart Admin"]Hello,
I don't know where your database is for backup? I've uploaded tons of products using the and never seen this error. When reporting the bug be sure to let them know what build you're running and we'll likely need a copy of your csv file to investigate this matter.
csv custom order download missing order/product info
Hello,
We are able to connect to our site no problem through the data client. Custom order download to csv includes all customer info, we can see all customer information but no order or product information. Is there a post on here that addresses our problem that i might be overlooking? XML custom download includes all order and customer information, but we are having a hard time creating a template for our mail order manager program(Dydacomp M.O.M. 6.0).
We are able to connect to our site no problem through the data client. Custom order download to csv includes all customer info, we can see all customer information but no order or product information. Is there a post on here that addresses our problem that i might be overlooking? XML custom download includes all order and customer information, but we are having a hard time creating a template for our mail order manager program(Dydacomp M.O.M. 6.0).
-
- Ensign (ENS)
- Posts: 19
- Joined: Thu Dec 15, 2005 9:54 pm
- Location: ...usually Pasadena or Philadelphia.
- Contact:
- Shopping Cart Admin
- AbleCommerce Admin
- Posts: 3055
- Joined: Mon Dec 01, 2003 8:41 pm
- Location: Vancouver, WA
- Contact:
Readme.txt file that wasn't included in dataport4.zip
11/1/07
AbleCommerce Data Port Tool Beta 1
---------------------------------------------------------------------------------------
WARNING: BACKUP YOUR DATABASE BEFORE USING THIS BETA TOOL !!!! <<<< DID YOU READ THIS?
---------------------------------------------------------------------------------------
RELEASE NOTE: UTF8 encoding in Excel 2002 and older does not work properly. Use Excel 2003 or newer.
CONFIGURATION AFTER INITIAL INSTALLATION: The store URL is the only field that isn't self explanatory.
---------------------------------------------------------------------------------------
http://WWW.MYSTORE.COM/ClientApi/ClientApiService.ashx
In the zip file there is a sample CSV file with one product: 'product_sample.csv'
BUG REPORTING:
---------------------------------------------------------------------------------------
Report bugs by at the following URL by clicking the need help icon at the bottom of the page.
http://www.ablecommerce.com/CRMTree.aspx?&TopicId=424
---------------------------------------------------------------------------------------
WARNING: BACKUP YOUR DATABASE BEFORE USING THIS BETA TOOL !!!! <<<< DID YOU SEE THIS?
---------------------------------------------------------------------------------------
AbleCommerce Data Port Tool Beta 1
---------------------------------------------------------------------------------------
WARNING: BACKUP YOUR DATABASE BEFORE USING THIS BETA TOOL !!!! <<<< DID YOU READ THIS?
---------------------------------------------------------------------------------------
RELEASE NOTE: UTF8 encoding in Excel 2002 and older does not work properly. Use Excel 2003 or newer.
CONFIGURATION AFTER INITIAL INSTALLATION: The store URL is the only field that isn't self explanatory.
---------------------------------------------------------------------------------------
http://WWW.MYSTORE.COM/ClientApi/ClientApiService.ashx
In the zip file there is a sample CSV file with one product: 'product_sample.csv'
BUG REPORTING:
---------------------------------------------------------------------------------------
Report bugs by at the following URL by clicking the need help icon at the bottom of the page.
http://www.ablecommerce.com/CRMTree.aspx?&TopicId=424
---------------------------------------------------------------------------------------
WARNING: BACKUP YOUR DATABASE BEFORE USING THIS BETA TOOL !!!! <<<< DID YOU SEE THIS?
---------------------------------------------------------------------------------------
- batmike
- Commander (CMDR)
- Posts: 123
- Joined: Tue Sep 04, 2007 10:46 am
- Location: Minneapolis, MN
- Contact:
Hi,
My 5.5 XML file is actually importing! Which is great news. It's taking far longer to process the file (still going now) but that's fine with me as long as it's working.
The one thing I've been getting while it's going is an operation time out error. It works on 100 products at a time and for the last couple hundred it's processed for about ten minutes and then gave me that message. Once I clicked OK it moved to the next hundred.
I'll find out at the end if it really skipped them or not, but just though I'd throw this in there and see if anyone has any ideas.
Great job though ... it's all coming together!
Mike
My 5.5 XML file is actually importing! Which is great news. It's taking far longer to process the file (still going now) but that's fine with me as long as it's working.
The one thing I've been getting while it's going is an operation time out error. It works on 100 products at a time and for the last couple hundred it's processed for about ten minutes and then gave me that message. Once I clicked OK it moved to the next hundred.
I'll find out at the end if it really skipped them or not, but just though I'd throw this in there and see if anyone has any ideas.
Great job though ... it's all coming together!
Mike
- Shopping Cart Admin
- AbleCommerce Admin
- Posts: 3055
- Joined: Mon Dec 01, 2003 8:41 pm
- Location: Vancouver, WA
- Contact:
Dataport (CommerceBuilder.DataClient.Client.exe) XML Def?
Is there a published formal definition (xsd) for the xml generated by this tool? I've built some xsd's using sample data, but those samples don't contain all possible scenarios (e.g. no integrated shipping details present). I'd like to have something for fulfillment vendor candidates to evaluate.
Thanks,
Nick
Thanks,
Nick
- Shopping Cart Admin
- AbleCommerce Admin
- Posts: 3055
- Joined: Mon Dec 01, 2003 8:41 pm
- Location: Vancouver, WA
- Contact:
-
- Ensign (ENS)
- Posts: 19
- Joined: Thu Dec 15, 2005 9:54 pm
- Location: ...usually Pasadena or Philadelphia.
- Contact:
- Shopping Cart Admin
- AbleCommerce Admin
- Posts: 3055
- Joined: Mon Dec 01, 2003 8:41 pm
- Location: Vancouver, WA
- Contact:
Hello,
Just restore the backup of your database that you hopefully did before using the data client.
---------------------------------------------------------------------------------------
WARNING: BACKUP YOUR DATABASE BEFORE USING THIS BETA TOOL !!!!
---------------------------------------------------------------------------------------
Just restore the backup of your database that you hopefully did before using the data client.
---------------------------------------------------------------------------------------
WARNING: BACKUP YOUR DATABASE BEFORE USING THIS BETA TOOL !!!!
---------------------------------------------------------------------------------------
-
- Ensign (ENS)
- Posts: 19
- Joined: Thu Dec 15, 2005 9:54 pm
- Location: ...usually Pasadena or Philadelphia.
- Contact:
-
- Ensign (ENS)
- Posts: 19
- Joined: Thu Dec 15, 2005 9:54 pm
- Location: ...usually Pasadena or Philadelphia.
- Contact:
48 out of 339 products in our database failed to import. (You already have a copy of our export file.)
Last edited by HeroicLife on Tue Feb 19, 2008 11:42 am, edited 1 time in total.
- Shopping Cart Admin
- AbleCommerce Admin
- Posts: 3055
- Joined: Mon Dec 01, 2003 8:41 pm
- Location: Vancouver, WA
- Contact:
I can't seem to get products upload using CSV to change Category assignments. For that matter, I cannot set parent categories properly when uploading categories as well.
Are category creation and it's parents supposed to be working on upload? And also changing the categories that products are assigned to?
I'm having a tough time doing an initial data load from my data. The basic information gets imported, but the hierchical structure or categores and products is not working as far as I can tell.
I'd hate to resort to directly loading the SQL tables as it's a lot of work to create DTS packages etc...
Thanks,
Stef Cancelli.
Are category creation and it's parents supposed to be working on upload? And also changing the categories that products are assigned to?
I'm having a tough time doing an initial data load from my data. The basic information gets imported, but the hierchical structure or categores and products is not working as far as I can tell.
I'd hate to resort to directly loading the SQL tables as it's a lot of work to create DTS packages etc...
Thanks,
Stef Cancelli.
- Shopping Cart Admin
- AbleCommerce Admin
- Posts: 3055
- Joined: Mon Dec 01, 2003 8:41 pm
- Location: Vancouver, WA
- Contact:
import of AC5.5 data
I've imported only the categories from my 5.5 installation into my new 7.0 store, but now the imported categories all have different category id's. What am I to do if I have 200,000 products already mapped to my 5.5 category id's? I really don't want to recreate this file to match the new categories. Is my alternative to upload my 5.5 data using the complete 5.5 export file so that products match catogories? If so, will any old category number's from 5.5 replace the categories created in 7.0 when i imported them and add any new categories created from the 5.5 export? Also, since i'm going to keep the 5.5 store open while I develop the 7.0 store, if I import the entire exported 5.5 store into 7.0, how will i export only the new customers and orders from 5.5 into 7.0. that come in the time between export and import.
Mike Keith,
mkeith1@hotmail.com
http://www.musicmart.com
Mike Keith,
mkeith1@hotmail.com
http://www.musicmart.com
Errors when importing 5.5 to 7.0 using DataClient beta 5
I should have posted this topic in here.. I don't want it to get lost, so I'll just link it:
viewtopic.php?t=6385&highlight=
Original Post:
Mike's Response:
viewtopic.php?t=6385&highlight=
Original Post:
I just did a store import using DataClient 5 with a 60mb XML document. I had two errors when it was importing products. I haven't had a chance to compare the product list of my 5.5 store to what got imported to 7.0. Has anyone had this same error? If so, did it skip products???
Another thing I noticed was it looks like it assigned all new category and product id numbers, which changes the URL, which makes it so I’d have to do 301 redirects on all my pages to save the page rankings of the current pages. I really don't want to do that. Is there a way to import the 5.5 products and categories so it preserves the original category and product id numbers??
Here's the erorr:
Saved at: Wednesday, January 30, 2008
----------------------------
Title: Error : The remote server returned an error: (500)..
----------------------------
Summary: An error occurred while processing request
----------------------------
Detailed Message: Error : The remote server returned an error: (500) Internal Server Error.
Mike's Response:
Hello,
I'll put in a feature request for the preserve ID issue. Please post all future issues to the dataport utility thread so they are not lost. The 5.5 import routine is still being improved and when we get a new version, we'll post it to the dataport thread.
_________________
Thank's for your support
Mike Randolph
AbleCommerce.com
- mfreeze
- Commodore (COMO)
- Posts: 421
- Joined: Mon Jan 24, 2005 2:07 pm
- Location: Washington, NJ
- Contact:
I have found 2 problems with the dataport utility.
1). The product name field length in 5.5 was 255, in 7.0 it is 100. This causes errors trying to import products with names longer that 100 characters. I ran into it with names of books.
2). 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. I have increassed the timeouts in IIS to 1800 and placed a httpruntime statement into the admin web.config, the store web.config and the .Net 2.0 apppool's machine.config with timeout set as high as 4500 seconds but am still getting the timeout after loading 219 products.
This store is due to go live by 3/17 and the import is holding everything up. What could I do to accomplish the import?
1). The product name field length in 5.5 was 255, in 7.0 it is 100. This causes errors trying to import products with names longer that 100 characters. I ran into it with names of books.
2). 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. I have increassed the timeouts in IIS to 1800 and placed a httpruntime statement into the admin web.config, the store web.config and the .Net 2.0 apppool's machine.config with timeout set as high as 4500 seconds but am still getting the timeout after loading 219 products.
This store is due to go live by 3/17 and the import is holding everything up. What could I do to accomplish the import?
Mary E Freeze
Freeze Frame Graphics
Web Hosting and Design, ASP and CFMX Development
http://www.ffgraphics.com
Freeze Frame Graphics
Web Hosting and Design, ASP and CFMX Development
http://www.ffgraphics.com