DataPort 7.7 issues

A forum where issues related to the DataPort utility can be discussed.
Post Reply
sweeperq
Commodore (COMO)
Commodore (COMO)
Posts: 497
Joined: Tue Jan 03, 2006 2:45 pm

DataPort 7.7 issues

Post by sweeperq » Wed Mar 11, 2015 5:42 am

Going from AC5.5 to AC7 and most of the data ported well, but I noticed the following things and was hoping someone could tell me if this is the expected behavior:
  • Orders do not maintain their OrderId, despite checking the first option to use the original ids. The Categories, Products, Webpages, and Users do.
  • Transactions are not migrated
  • Custom fields are not migrated
Luckily, I have access to the source and destination databases and can probably download the missing data and get it stuffed in there. Just curious why those things don't seem to port? There were no errors regarding data formatting or anything like that.

rmaweb
Commander (CMDR)
Commander (CMDR)
Posts: 118
Joined: Fri Sep 10, 2010 9:41 am

Re: DataPort 7.7 issues

Post by rmaweb » Wed Mar 11, 2015 2:14 pm

Hello Sweeperq,

I remember that happened when we updated from 5.5 to 7 a few years back. I can't remember what actually caused the orders to become disassociated with the customers, but your not the only one to experience that.
Ryan A.
Scott's Bait and Tackle
http://store.scottsbt.com
Work In Progress
Able Gold R10
Bootstrap 3.3

User avatar
jmestep
AbleCommerce Angel
Posts: 8164
Joined: Sun Feb 29, 2004 8:04 pm
Location: Dayton, OH
Contact:

Re: DataPort 7.7 issues

Post by jmestep » Thu Mar 12, 2015 1:38 am

I believe it is normal for the transaction to not be transferred. The custom fields should have come across as templates and there might be many of them because of data naming anomalies. For example, if you had a custom field that said P.O.Box: and another that said PO Box, two templates would have been created.
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx

sweeperq
Commodore (COMO)
Commodore (COMO)
Posts: 497
Joined: Tue Jan 03, 2006 2:45 pm

Re: DataPort 7.7 issues

Post by sweeperq » Thu Mar 19, 2015 6:27 am

Thank you both for your feedback. Product custom fields did indeed port over as Product Templates. Other custom fields that we created did not. I was able to manually back-port them with some custom SQL. Was a little tricky when Ids changed, but we managed!

So glad to finally have our last store off of AC5x an everything into a common platform :) Too bad it isn't the latest version though.

Are there any major compelling reasons to go from AC 7 to AC Gold?

My biggest issue with AC7 at the moment is that if it loses the connection to the database for any reason it caches the bad connection and I have to recycle the application pool to fix the site. It doesn't happen very often, but it is pretty annoying.

sweeperq
Commodore (COMO)
Commodore (COMO)
Posts: 497
Joined: Tue Jan 03, 2006 2:45 pm

Re: DataPort 7.7 issues

Post by sweeperq » Thu Mar 19, 2015 6:46 am

And I just found a patch for the AC7 connection issue :) http://help.ablecommerce.com/upgrades/a ... atches.htm

Post Reply