osc 2.2 MS to V4: Products Import Error

[sjponosc]

Has anyone encounter this error when doing Products  Import using osc V4 admin:

Start import for Products... Expecting: 8097
Import was interrupted due an error: XML Error: Invalid document end at line 3

Any help will be appreciated.

 

Thanks

 

[osCommerce-Official]

@pandreiand this one too, please 

[pandrei]

6 hours ago, sjponosc said:

Has anyone encounter this error when doing Products  Import using osc V4 admin:

Start import for Products... Expecting: 8097
Import was interrupted due an error: XML Error: Invalid document end at line 3

Any help will be appreciated.

Please check these files: lib/common/extensions/OscLink/temp/products*.xml

One of them is invalid XML. Could you send it in pm?

[Carolina IT Systems]

not sure why it needs to be sent via PM.  I'm getting the exact same error - here's my products.xml file:

<?xml version="1.0" encoding="UTF-8"?>
<data>
<Header><type>site/products</type><projectCode>MY_PROJECT_CODE_WHICH_IS_FINE</projectCode></Header>

 

that's it.  that's the whole contents of the file.

[pandrei]

16 minutes ago, Carolina IT Systems said:

not sure why it needs to be sent via PM.

Of course, it is not necessary. Some users do not want to post their files on the forum.

19 minutes ago, Carolina IT Systems said:

<?xml version="1.0" encoding="UTF-8"?>
<data>
<Header><type>site/products</type><projectCode>MY_PROJECT_CODE_WHICH_IS_FINE</projectCode></Header>

 

that's it.  that's the whole contents of the file.

Could you show me the log file from our OSC Bridge on your old osCommerce. Its is located here: your_oscb_folder/runtime/logs/app.log

[sjponosc]

@pandrie

I have shared the files.

From V4: lib/common/extensions/OscLink/temp/products*.xml
products_offset10.xml
products_offset20.xml
products_options.xml
products_options_offset10.xml
products_options_offset20.xml
products.xml

From: 2.2
your_oscb_folder/runtime/logs/app.log

Thanks

Edited February 3 by sjponosc
additional details

[pandrei]

1 hour ago, sjponosc said:

@pandrie

I have shared the files.

Perfect. How I can access them?

[Carolina IT Systems]

3 hours ago, pandrei said:

Of course, it is not necessary. Some users do not want to post their files on the forum.

Could you show me the log file from our OSC Bridge on your old osCommerce. Its is located here: your_oscb_folder/runtime/logs/app.log

I cannot.  the entire runtime directory is empty - cache, debug, logs.  Ran the product import again to double check.  runtime directory from the your_oscb_folder contains no files - just the three directories

FYI - all the imports are successful up until the products.  Following the importing data instructions:  brands, categories, and products options all are imported properly.

[sjponosc]

Issue resolved.

error was related to V4 looking for a database table in osc 2.2 which never existed in my environment. to get pass this error I simply had to create an empty tables in osc 2.2 :

 

CREATE TABLE products_images (

  id int NOT NULL auto_increment,

  products_id int NOT NULL,

  image varchar(64),

  htmlcontent text,

  sort_order int NOT NULL,

  PRIMARY KEY (id));

 

Thank you @Oscommerce for quick support.

 

 

Edited February 3 by sjponosc

[pandrei]

59 minutes ago, Carolina IT Systems said:

I cannot.  the entire runtime directory is empty - cache, debug, logs.  Ran the product import again to double check.  runtime directory from the your_oscb_folder contains no files - just the three directories

FYI - all the imports are successful up until the products.  Following the importing data instructions:  brands, categories, and products options all are imported properly.

Did you also solve the issue by creating product_images table?