app shop
Success Case: Resolving Import Errors in OSCB157
February 07, 2025
A customer encountered an error while importing customer data using the OSCB157 import process. They followed the recommended step order:
- Products – Imported brands, categories, product options, and products successfully.
- Orders – Started by importing customers and order statuses before orders.
Problem:
During the customer import process, an error occurred:
"Start import for Customers... Expecting: 37083. Import was interrupted due to an error: XML Error: Invalid document end at line 14."
The user attempted to reimport customers, but the same error persisted.
Support Team's Investigation and Solution:
- Analyzing the Issue
- The support team requested the log file from runtime/logs/app.log.
- The latest XML file in lib/common/extensions/OscLink/temp/customers.xml was invalid.
- Identifying the Cause
- A missing country entry in the database caused the issue.
- The customer ran an SQL query to find missing country records:
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; - The query identified 26 customer records with missing country data.
- Fixing the Issue
- The customer enabled the missing countries in the new database.
- They attempted the import again, but the error persisted.
- Final Resolution
- The support team provided updated files:
- oscb/common/api/models/XML/IOCountryMap.php
- oscb/common/helpers/Country.php
- The support team provided updated files:
These updates ensured that customers with missing country IDs were imported, but their address book remained empty.
The customer successfully completed the import and shared a step-by-step tutorial to help others facing the same issue.
You can further discuss it on our Forum