Success Case: Resolving Import Errors in OSCB157

A customer encountered an error while importing customer data using the OSCB157 import process. They followed the recommended step order:

1. Products – Imported brands, categories, product options, and products successfully.
2. 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:

1. 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.
2. 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.
3. Fixing the Issue
   • The customer enabled the missing countries in the new database.
   • They attempted the import again, but the error persisted.
4. Final Resolution
   • The support team provided updated files:
     • oscb/common/api/models/XML/IOCountryMap.php
     • oscb/common/helpers/Country.php

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.