Migrating Data from 5.5 to 7.0

[gdelorey@mitcs.com]

Hi there -

We are looking to move our client's store from 5.5 to 7.0, and I wanted to get an idea of how the migration process has gone for those of you who have done it. Can you offer any suggestions or pitfalls after going through this process? Does anyone have a decent time estimation for who long it actually took to export data from their 5.5 store and re-import it into 7.0?

Thank you; we're just trying to get an idea of what is involved initially in this process.

: Greg

[jmestep]

It went very smoothly, The only problem with the export from 5.5 was that it is set up to create xml data that is pasted into an input box on the export page and I had to change the code so it wrote it to the file system instead. I don't know if the dataport imports orders and users without re-numbering them, which is not good for current customers. You can choose to retain the numbering for categories and products, which you want to do because that way your links in search engines won't break.

[gdelorey@mitcs.com]

Hi Judy -

Thanks for the reply! I just finished installing 7.0 locally so I'm going to give the data transfer a shot and see what happens...

: Greg

[gdelorey@mitcs.com]

Judy -

I'm wondering if by chance you ran into this issue; I've been able to successfully connect to my 7.0 store using the DataPort utility, however when I try to connect to our 5.5 store I receive the following error:

Error: The remote server returned an error: (500) Internal Server Error.

If I navigate directly to the ClientApiService.ashx file in my browser, I get the following application error:

Code: Select all

Server Error in '/' Application.
Compilation Error
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: CS0246: The type or namespace name 'CommerceBuilder' could not be found (are you missing a using directive or an assembly reference?)

Source Error:

Line 5:  using System.IO;
Line 6:  using System.Security.Principal;
Line 7:  using CommerceBuilder.DataClient.Api;
Line 8:  using CommerceBuilder.DataClient.Api.Schema;
Line 9:  

I have verified that the CommerceBuilder.DataClient.Api.dll file is included in the /Bin directory, so I'm a bit confused on why this might be occurring. Any chance you are familiar with this type of error? I may need to post this in the DataPort thread as well.

Thanks,

: Greg

[gdelorey@mitcs.com]

Oops...I think I've been going about this wrong. Just found the data export feature within the 5.5 admin area....

Thanks,

: Greg

[CraigH]

It went very smoothly, The only problem with the export from 5.5 was that it is set up to create xml data that is pasted into an input box on the export page and I had to change the code so it wrote it to the file system instead.

Any chance you could release that code? I'm having the same issue with the export. I wish there was a way to export only specific items in the store similar to when the import happens.

[jmestep]

It is pretty much a one-line fix. In you admin/data/_exportdata.aspx, make this change. It saves the export to a file in that same folder.

xmlExport.Save(Server.MapPath("Export.xml"))
'sExportXML = xmlExport.OuterXML()
sExportXML = ""

You can also comment out sections of code that you don't want to export, like wishlists for example.

[jmestep]

The AbleCommerce dataclient export utility works for this also instead of using the store export from the admin.
Here is a link to it:
http://help.ablecommerce.com/upgrades/a ... _tools.htm