Page 1 of 1
Importing data from other software
Posted: Tue Jul 08, 2008 6:56 pm
by gemini929
Hello,
I have purchased AbleCommerce 7.0. I need to migrate customer data from my existing cart software to AC. I looked at the Data Port utility. It described the format for importing "user" information (as far as I can tell, user = customer), but it was unclear how to import the users address information. Later, I came across an xml data format. It is unclear if I can upload just a collection of "user" nodes.
How should I move forward?
Regards,
joshua
Re: Importing data from other software
Posted: Wed Jul 09, 2008 7:04 am
by Naveed
You can found a lot of information about DataPort at following links:
viewtopic.php?f=42&t=5707&start=0&st=0&sk=t&sd=a
http://wiki.ablecommerce.com/index.php/ ... rt_Utility
If you want user addresses to be imported as well then the CSV format can not work for you and the only choice is the XML format.
To proceed with the XML format import / export I recommend you to create a couple of users on your website and populate their addresses. Now export the Users data by Customized Users export (download) in xml format. It will give you an xml file containing user data in xml format. Such a file will be required by DataPort to import user information to AC7.
Re: Importing data from other software
Posted: Wed Jul 09, 2008 7:14 am
by gemini929
How do I determine which xml values are absolutely required? Is there an xml schema or documentation that indicates this?
-Joshua
Re: Importing data from other software
Posted: Wed Jul 09, 2008 8:52 am
by jmestep
Able doesn't have the schema out yet. Your best bet is to do what Naveed said, then delete some of the fields and see if the upload works with out them. If it doesn't work, add them back.
Re: Importing data from other software
Posted: Wed Jul 09, 2008 8:55 am
by Naveed
gemini929 wrote:How do I determine which xml values are absolutely required? Is there an xml schema or documentation that indicates this?
-Joshua
We have not yet released the XML schema for XML import, but fortunately the XML format is pretty dependent on the database schema, you can safely assume that all the not null fields are required.
You can found the database schema at:
http://wiki.ablecommerce.com/images/3/3 ... Schema.pdf