AC5X to AC7.0.7 Data Import Error

A forum where issues related to the DataPort utility can be discussed.
Post Reply
rlopez
Lieutenant Commander (LCDR)
Lieutenant Commander (LCDR)
Posts: 96
Joined: Mon Mar 15, 2004 1:08 pm
Contact:

AC5X to AC7.0.7 Data Import Error

Post by rlopez » Sun Nov 11, 2012 2:18 pm

We are currently migrating from AC5X 1306 build to AC7.0.7 SR1. However when using the AC7 data port utility we are recieving an error when trying to upload all data from the AC5X store .xml file.

Error: Pre-Processing file
Error occurred while Pre-Processing the import file.
Error details: An error occurred while parsing EntityName Line 5978, Position 24.

Our current process is as follows:
1. Exported AC5X store data through data export inside admin of store.
2. saving complete file as .xml file UTF-8
3. Opening latest version installed AC7 Data Port app with solid connections to store.
4. Clicking on AC5 Data Upload.
5. Selecting: Delete the existing object and save the imported AC5 x Objet (Dev store has no data or set-up in it)
6. Select: Complete Store
7. Clicking upload button. Process starts and then the error described above pops up.
I believe this error is due to the data we have from the AC5x store. I've tried also selecting save import log to see what errors are being generated. However no log is being written due to the process is stopping before a record can be written.
If anyone has had this problem please share any fixes that may be out there.
Rick L.
https://www.boatingsolutions.com
We make boat repair easy!

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

Re: AC5X to AC7.0.7 Data Import Error

Post by jmestep » Mon Nov 12, 2012 6:55 am

Like you say, I think it would have something to do with your data. You might need to set the chunk size in the dataport to 1 and then see what record it stops on or see if there might be some more data in the computer event log or the App_Data/Logs/app.log on the website. (I've always had trouble saving the dataport log also- my computer always froze up so I quit trying.)
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

rlopez
Lieutenant Commander (LCDR)
Lieutenant Commander (LCDR)
Posts: 96
Joined: Mon Mar 15, 2004 1:08 pm
Contact:

Re: AC5X to AC7.0.7 Data Import Error

Post by rlopez » Wed Nov 14, 2012 11:54 am

AC5 to AC7 data port migration resolved. After confirming with Mike at Ablecommerce (you should not use the Admin side of AC5) to export your data to an .XML file for import to AC7. By using the the AC55 StoreExport 5.6.54 api to creat the .XML file, I was able to uploaded with AC7 Data Port without any issues at all. Data does need to be tweeked a little but all is good.
Rick L.
https://www.boatingsolutions.com
We make boat repair easy!

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

Re: AC5X to AC7.0.7 Data Import Error

Post by jmestep » Thu Nov 15, 2012 7:26 am

Yes, you do not want to use the admin since it creates the xml in memory then populates a text box with it. If you can't access the database with the 55 export utility, you can change the code on the admin export page to write to a file instead of the text box.That is what I had to do in one case where the hoster did not allow direct database access so I couldn't use the other utility because you have to set up an ODBC connection.
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

Post Reply