Importing data from other software

[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

[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.

[gemini929]

How do I determine which xml values are absolutely required? Is there an xml schema or documentation that indicates this?

-Joshua

[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.

[Naveed]

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