Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

osc 2.2 MS to V4: Products Import Error


Recommended Posts

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?

Link to comment
Share on other sites

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

Link to comment
Share on other sites

@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 by sjponosc
additional details
Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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 by sjponosc
Link to comment
Share on other sites

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?

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

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