Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Recommended Posts

Posted

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

Posted
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?

Posted (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 by Chadduck
Posted
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.

Posted
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

Posted
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

 

Posted
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

Posted

@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

Posted
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.

Posted

@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

Posted

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.

Posted
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.

Posted (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 by pandrei
Posted

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

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.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...