Chadduck Posted June 30, 2023 Posted June 30, 2023 While using the oscb157 import processes, followed the recommended import step order We would recommend to import the data in the following order: Step 1 1. For products first import brands, categories and product options, then products NO PROBLEM Step 2 For orders first import customers and order statuses, then orders PROBLEM APPEARED Start import for Customers... Expecting: 37083 Import was interrupted due an error: XML Error: Invalid document end at line 14 Ideas, recommendations, or suggestions? BJ Quote
pandrei Posted July 1, 2023 Posted July 1, 2023 20 hours ago, Chadduck said: Start import for Customers... Expecting: 37083 Import was interrupted due an error: XML Error: Invalid document end at line 14 Please check these files: lib/common/extensions/OscLink/temp/customers*.xml The latest of them is invalid XML. Could you send it to me or show the invalid part? Quote
Chadduck Posted July 3, 2023 Author Posted July 3, 2023 (edited) On 7/1/2023 at 10:30 AM, pandrei said: Please check these files: lib/common/extensions/OscLink/temp/customers*.xml @pandrei There is only 1 file lib/common/extensions/OscLink/temp/customers.xml the contents are <?xml version="1.0" encoding="UTF-8"?> <data> <Header><type>site/customers</type><projectCode><my code></projectCode></Header> <Customers> <Customer><customers_id type="IOPK" internalId="1"/><purchased_without_account>0</purchased_without_acco <Customer><customers_id type="IOPK" internalId="3"/><purchased_without_account>0</purchased_without_acco <Customer><customers_id type="IOPK" internalId="4"/><purchased_without_account>0</purchased_without_acco <Customer><customers_id type="IOPK" internalId="5"/><purchased_without_account>0</purchased_without_acco <Customer><customers_id type="IOPK" internalId="6"/><purchased_without_account>0</purchased_without_acco <Customer><customers_id type="IOPK" internalId="7"/><purchased_without_account>0</purchased_without_acco <Customer><customers_id type="IOPK" internalId="8"/><purchased_without_account>0</purchased_without_acco <Customer><customers_id type="IOPK" internalId="9"/><purchased_without_account>0</purchased_without_acco <Customer><customers_id type="IOPK" internalId="10"/><purchased_without_account>0</purchased_without_acc <Customer><customers_id type="IOPK" internalId="11"/><purchased_without_account>0</purchased_without_acc That is the COMPLETE file Edited July 3, 2023 by Chadduck Quote
pandrei Posted July 4, 2023 Posted July 4, 2023 6 hours ago, Chadduck said: That is the COMPLETE file 1. Thanks. But I can't see its invalid part. 2. Could you send me a log file from the oscb directory: runtime/logs/app.log 3. Did you try to reimport customers? It may be a temporary network error. Quote
Chadduck Posted July 5, 2023 Author Posted July 5, 2023 On 7/3/2023 at 10:10 PM, pandrei said: Could you send me a log file from the oscb directory: runtime/logs/app.log Sent as a private message. On 7/3/2023 at 10:10 PM, pandrei said: Did you try to reimport customers? It may be a temporary network error. After the first failure - yes Waited. closed browser. Restarted and tried again. The same failure occurred after both retries. BJ Quote
pandrei Posted July 6, 2023 Posted July 6, 2023 21 hours ago, Chadduck said: Sent as a private message. Thanks. You have some customer whose country does not exist in the countries table. Just add a record for this country or change customer address. You can find the customer and it's country by this SQL: SELECT a.customers_id, c.countries_id FROM address_book a LEFT JOIN countries c ON c.countries_id = a.entry_country_id WHERE c.countries_id IS NULL Quote
Chadduck Posted July 6, 2023 Author Posted July 6, 2023 59 minutes ago, pandrei said: You have some customer whose country does not exist in the countries table. Just add a record for this country or change customer address. @pandrei Thank you - will investigate and see if I can locate it. BJ Quote
Chadduck Posted July 6, 2023 Author Posted July 6, 2023 @pandrei After running the provided sql - there were 26 customer records identified. The majority were Australia which had not been enabled within the new version. Since locating that I have compared the ORIGINAL database countries and have enabled ALL of the identified countries in the new database (OSC V4). Before beginning the import again, is that sufficient or is there something else I should do? BJ Quote
pandrei Posted July 7, 2023 Posted July 7, 2023 13 hours ago, Chadduck said: Before beginning the import again, is that sufficient or is there something else I should do? I hope it is enough. Quote
Chadduck Posted July 7, 2023 Author Posted July 7, 2023 6 hours ago, pandrei said: I hope it is enough. @pandrei OK, will attempt the import later today... BJ Quote
Chadduck Posted July 7, 2023 Author Posted July 7, 2023 @pandrei Attempted the import but unfortunately received the same error 0% Start import for Customers... Expecting: 37083 Import was interrupted due an error: XML Error: Invalid document end at line 14 Any additional ideas or suggestions? BJ Quote
Chadduck Posted July 7, 2023 Author Posted July 7, 2023 Since I am dealing with a backup of the live store database I will try DELETING those 26 customer records and then attempt the import again. Quote
pandrei Posted July 8, 2023 Posted July 8, 2023 11 hours ago, Chadduck said: Attempted the import but unfortunately received the same error 0% Start import for Customers... Expecting: 37083 Import was interrupted due an error: XML Error: Invalid document end at line 14 Any additional ideas or suggestions? Could you again send me a log file from the oscb directory: runtime/logs/app.log It maybe another error with the same customer. Quote
Chadduck Posted July 8, 2023 Author Posted July 8, 2023 4 hours ago, pandrei said: Could you again send me a log file Sent via PM Quote
pandrei Posted July 10, 2023 Posted July 10, 2023 (edited) On 7/8/2023 at 4:24 PM, Chadduck said: Sent via PM It is the same error. One of customer still has an unknown country id. Replace the files with the attached ones: oscb/common/api/models/XML/IOCountryMap.php oscb/common/helpers/Country.php It will fix the error, but the address book for a customer with an unknown country will be empty. IOCountryMap.php Country.php Edited July 10, 2023 by pandrei Quote
Chadduck Posted July 16, 2023 Author Posted July 16, 2023 After conversing with @pandrei I was ultimately able to get my cutomers imported. The culmination of our conversations are contained in the attached file which is a step by step tutorial for resolving the issue which was causing the error message Start import for Customers... Expecting: <number of customers> Import was interrupted due an error: XML Error: Invalid document end at line 14 If the tutorial is followed you will be able to import your customers. Thanks goes to @pandrei for the assistance. BJ Purge of bad customers records.pdf pandrei 1 Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.