[Extension] osCommerce Import and Login (FREE)

This is the official "osCommerce Import and Login" extension Topic.
You can find the extension here: http://www.opencart.com/index.php?route ... on_id=1936

It's a "Dumb" script I threw together, because I needed it.
You will have to be able to change some PHP settings if you're going to import large files...

Please post any questions here, and give the Extension a rating if you found it useful!

Hi AvanOsch, thanks for putting together such a useful extension. I am trying to migrate my db from OScommerce 2.2 to Opencart 1.5.4 using the VQmod method but I have run into an error that I can't resolve. I uploaded the osc-import.xml file to /VQmod/xml and ran the restore process in the admin panel as instructed. I uploaded my backed up SQL from my old site and hit restore but it comes up with the error message:

"Warning: Importing osCommerce file failed! (no further harm done)"

When I run osc-login.xml it comes up with this error:

Notice: Error: Table 'categories' already exists
Error No: 1050
-- -------------------------------------------------------- -- -- Table structure for table `categories` -- CREATE TABLE `categories` ( `categories_id` int(11) NOT NULL auto_increment, `categories_image` varchar(64) default NULL, `parent_id` int(11) NOT NULL default '0', `sort_order` int(3) default NULL, `date_added` datetime default NULL, `last_modified` datetime default NULL, PRIMARY KEY (`categories_id`), KEY `idx_categories_parent_id` (`parent_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=25 in /home/content/p/b/t/pbtam/html/system/database/mysql.php on line 49

Any help would be appreciated.

<edit> duplicate entry

How this Extension SHOULD work:
- Install the osc-import.xml and osc-login.xml
- Import/convert your database (Only works if the importing ends with a success message!)
- Check your store for converted products, customers and orders
- [optional] un-install osc-import.xml (makes no difference if you leave it.)

If the importing returns:
- Warning: Importing osCommerce file failed! (no further harm done)
It seems that the file could not be saved...

I did track down an error (don't know if that will solve it though), and will release an update a.s.a.p.

Thank you for your hard work. I'm looking forward to the release. I really don't mean to sound like a jerk, but do you have a release estimate? My OSCommerce site crashed a few days ago so that is the reason for the cart migrate. I may be forced to use cart2cart to migrate my store.

Sorry, too few hours in a day.... (You jerk! )

Attached is the xml with the bug removed.
Please check if this solves your problem.

If it doesn't:
Please check "system/logs" for a ".txt" file (NOT error.txt)

jerk status achieved. :*(

i ran the script in the same way and it returns the same error:

2012-08-29 6:49:32 - PHP Notice: Undefined variable: text_htaccess in /home/content/p/b/t/pbtam/html/vqmod/vqcache/vq2-admin_view_template_tool_backup.tpl on line 51

1) Could you delete all the files in folder: "vqmod/cache"
and then try again?
That exact error should be resolved with the above update.

2) Also check for errors in "vqmod/vqmod.log"

3) Do you see any other files in "system/logs" (NOT error.txt)?

Also, after checking your log, clear and save the log-file.
That way you can be sure the listed errors are new...

1) I have deleted all the files in vqmod/cache and tried again with same error
3) only error.txt (but it's empty)
2) vqmod.log says:

---------- Date: 2012-08-29 07:30:57 ~ IP : 209.6.65.190 ----------
REQUEST URI : /admin/index.php?route=common/home&token=b17ffdbc5d05090ab545669e54e796fb
MOD DETAILS:
modFile : /home/content/p/b/t/pbtam/html/vqmod/xml/osc-import.xml
id : osCommerce Import & Login
version : 1.0.4
vqmver : 2.1.5
author : The Wizard of Osch, for www.CrystalCopy.nl
Could not resolve path for [admin/language/dutch/tool/backup.php] (SKIPPED)

MOD DETAILS:
modFile : /home/content/p/b/t/pbtam/html/vqmod/xml/shipped_filter.xml
id : Shipped Orders Filter for OpenCart 1.5.2.x
version : 1.0.0
vqmver : 2.1.6
author : Fido-X
Could not resolve path for [admin/language/dutch/setting/setting.php] (SKIPPED)
----------------------------------------------------------------------


---------- Date: 2012-08-29 07:30:58 ~ IP : 209.6.65.190 ----------
REQUEST URI : /admin/index.php?route=common/home/chart&token=b17ffdbc5d05090ab545669e54e796fb&range=day
MOD DETAILS:
modFile : /home/content/p/b/t/pbtam/html/vqmod/xml/osc-import.xml
id : osCommerce Import & Login
version : 1.0.4
vqmver : 2.1.5
author : The Wizard of Osch, for www.CrystalCopy.nl
Could not resolve path for [admin/language/dutch/tool/backup.php] (SKIPPED)

MOD DETAILS:
modFile : /home/content/p/b/t/pbtam/html/vqmod/xml/shipped_filter.xml
id : Shipped Orders Filter for OpenCart 1.5.2.x
version : 1.0.0
vqmver : 2.1.6
author : Fido-X
Could not resolve path for [admin/language/dutch/setting/setting.php] (SKIPPED)
----------------------------------------------------------------------


---------- Date: 2012-08-29 07:31:07 ~ IP : 209.6.65.190 ----------
REQUEST URI : /admin/index.php?route=tool/backup&token=b17ffdbc5d05090ab545669e54e796fb
MOD DETAILS:
modFile : /home/content/p/b/t/pbtam/html/vqmod/xml/osc-import.xml
id : osCommerce Import & Login
version : 1.0.4
vqmver : 2.1.5
author : The Wizard of Osch, for www.CrystalCopy.nl
Could not resolve path for [admin/language/dutch/tool/backup.php] (SKIPPED)

MOD DETAILS:
modFile : /home/content/p/b/t/pbtam/html/vqmod/xml/shipped_filter.xml
id : Shipped Orders Filter for OpenCart 1.5.2.x
version : 1.0.0
vqmver : 2.1.6
author : Fido-X
Could not resolve path for [admin/language/dutch/setting/setting.php] (SKIPPED)
----------------------------------------------------------------------


---------- Date: 2012-08-29 07:31:17 ~ IP : 209.6.65.190 ----------
REQUEST URI : /admin/index.php?route=tool/error_log&token=b17ffdbc5d05090ab545669e54e796fb
MOD DETAILS:
modFile : /home/content/p/b/t/pbtam/html/vqmod/xml/osc-import.xml
id : osCommerce Import & Login
version : 1.0.4
vqmver : 2.1.5
author : The Wizard of Osch, for www.CrystalCopy.nl
Could not resolve path for [admin/language/dutch/tool/backup.php] (SKIPPED)

MOD DETAILS:
modFile : /home/content/p/b/t/pbtam/html/vqmod/xml/shipped_filter.xml
id : Shipped Orders Filter for OpenCart 1.5.2.x
version : 1.0.0
vqmver : 2.1.6
author : Fido-X
Could not resolve path for [admin/language/dutch/setting/setting.php] (SKIPPED)
----------------------------------------------------------------------


---------- Date: 2012-08-29 07:31:19 ~ IP : 209.6.65.190 ----------
REQUEST URI : /admin/index.php?route=tool/error_log/clear&token=b17ffdbc5d05090ab545669e54e796fb
MOD DETAILS:
modFile : /home/content/p/b/t/pbtam/html/vqmod/xml/osc-import.xml
id : osCommerce Import & Login
version : 1.0.4
vqmver : 2.1.5
author : The Wizard of Osch, for www.CrystalCopy.nl
Could not resolve path for [admin/language/dutch/tool/backup.php] (SKIPPED)

MOD DETAILS:
modFile : /home/content/p/b/t/pbtam/html/vqmod/xml/shipped_filter.xml
id : Shipped Orders Filter for OpenCart 1.5.2.x
version : 1.0.0
vqmver : 2.1.6
author : Fido-X
Could not resolve path for [admin/language/dutch/setting/setting.php] (SKIPPED)
----------------------------------------------------------------------


---------- Date: 2012-08-29 07:31:19 ~ IP : 209.6.65.190 ----------
REQUEST URI : /admin/index.php?route=tool/error_log&token=b17ffdbc5d05090ab545669e54e796fb
MOD DETAILS:
modFile : /home/content/p/b/t/pbtam/html/vqmod/xml/osc-import.xml
id : osCommerce Import & Login
version : 1.0.4
vqmver : 2.1.5
author : The Wizard of Osch, for www.CrystalCopy.nl
Could not resolve path for [admin/language/dutch/tool/backup.php] (SKIPPED)

MOD DETAILS:
modFile : /home/content/p/b/t/pbtam/html/vqmod/xml/shipped_filter.xml
id : Shipped Orders Filter for OpenCart 1.5.2.x
version : 1.0.0
vqmver : 2.1.6
author : Fido-X
Could not resolve path for [admin/language/dutch/setting/setting.php] (SKIPPED)
----------------------------------------------------------------------


---------- Date: 2012-08-29 07:31:52 ~ IP : 66.249.73.3 ----------
REQUEST URI : /product_info.php?products_id=54&osCsid=a5333a02c2efd0003f10be11294ddabc
MOD DETAILS:
modFile : /home/content/p/b/t/pbtam/html/vqmod/xml/osc-import.xml
id : osCommerce Import & Login
version : 1.0.4
vqmver : 2.1.5
author : The Wizard of Osch, for www.CrystalCopy.nl
Could not resolve path for [admin/language/dutch/tool/backup.php] (SKIPPED)

MOD DETAILS:
modFile : /home/content/p/b/t/pbtam/html/vqmod/xml/shipped_filter.xml
id : Shipped Orders Filter for OpenCart 1.5.2.x
version : 1.0.0
vqmver : 2.1.6
author : Fido-X
Could not resolve path for [admin/language/dutch/setting/setting.php] (SKIPPED)
----------------------------------------------------------------------


---------- Date: 2012-08-29 07:32:04 ~ IP : 209.6.65.190 ----------
REQUEST URI : /admin/index.php?route=tool/backup&token=b17ffdbc5d05090ab545669e54e796fb
MOD DETAILS:
modFile : /home/content/p/b/t/pbtam/html/vqmod/xml/osc-import.xml
id : osCommerce Import & Login
version : 1.0.4
vqmver : 2.1.5
author : The Wizard of Osch, for www.CrystalCopy.nl
Could not resolve path for [admin/language/dutch/tool/backup.php] (SKIPPED)

MOD DETAILS:
modFile : /home/content/p/b/t/pbtam/html/vqmod/xml/shipped_filter.xml
id : Shipped Orders Filter for OpenCart 1.5.2.x
version : 1.0.0
vqmver : 2.1.6
author : Fido-X
Could not resolve path for [admin/language/dutch/setting/setting.php] (SKIPPED)
----------------------------------------------------------------------

Is this caused by a lack of dutch language? The standard install only includes English

Hmmm.... No.
The script just looks for dutch language, and skips it if not present.
(Funny. Looks like "Fido-X" is also dutch, and is doing the exact same thing...)

So no (real) errors...

I'm thinking this has something to do with PHP settings...
Are you able to set PHP's max_execution_time?

You could also PM me, and send your osCommerce file.
I'll be better able to troubleshoot the problem.

After checking "javabean"s backup file, I realized I should add the following:

This Extension expects an original osCommerce backup!
Because osCommerce uses it's own function to build the backup file,
it is ONLY possible to use a backup made directly from osCommerce.

Hi, great script, but I'm having the following error when I trie to import:

Notice: Undefined index: payment_firstname in D:\xampp\htdocs\opencart\vqmod\vqcache\vq2-admin_model_tool_backup.php on line 190Notice: Undefined index: payment_firstname in D:\xampp\htdocs\opencart\vqmod\vqcache\vq2-admin_model_tool_backup.php on line 206Notice: Undefined index: payment_country in D:\xampp\htdocs\opencart\vqmod\vqcache\vq2-admin_model_tool_backup.php on line 223Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Error No: 1064
SELECT country_id FROM `country` WHERE UPPER(`name`) = in D:\xampp\htdocs\opencart\system\database\mysql.php on line 49

Thanks in advance.

fernas wrote:Thanks in advance.

You're welcome

Should be fixed in v1.0.5

Hi, I'm getting the following error when trying to import after successful conversion:

Notice: Error: Table 'poklonie_opencart.option_value' doesn't exist
Error No: 1146
TRUNCATE TABLE `option_value` in /home/poklonie/public_html/opencart/system/database/mysql.php on line 49

Any idea?

--EDIT--
I have noticed that table prefix is missing. It seems your script doesn't support installations with table prefixes

Hi Kuhada,

I admit, I did not test with table prefixes, but the script should work with them...
In your reported error, is "poklonie_opencart" not your table prefix?

Hang on... Maybe I missed it in the generated script...
I'll have a look.

--EDIT--
Yep...
I missed some entries in the Generated script. (4 to be exact)
Thanks for the Bug-report!

Released a bugfixed version (1.0.6).
Please report back with your results!

I've used this script a couple times, each with errors that I was able to get around, but nothing like this. Help? This is when I import the database into the admin of opencart.

Notice: Undefined index: price in /home/microweb/public_html/vqmod/vqcache/vq2-admin_model_tool_backup.php on line 251Notice: Undefined index: quantity in /home/microweb/public_html/vqmod/vqcache/vq2-admin_model_tool_backup.php on line 250Notice: Undefined index: price in /home/microweb/public_html/vqmod/vqcache/vq2-admin_model_tool_backup.php on line 251Notice: Undefined index: price in /home/microweb/public_html/vqmod/vqcache/vq2-admin_model_tool_backup.php on line 251Notice: Undefined index: price in /home/microweb/public_html/vqmod/vqcache/vq2-admin_model_tool_backup.php on line 249Notice: Undefined index: price in /home/microweb/public_html/vqmod/vqcache/vq2-admin_model_tool_backup.php on line 251Notice: Undefined index: value in /home/microweb/public_html/vqmod/vqcache/vq2-admin_model_tool_backup.php on line 257Notice: Undefined index: value in /home/microweb/public_html/vqmod/vqcache/vq2-admin_model_tool_backup.php on line 257Notice: Undefined index: value in /home/microweb/public_html/vqmod/vqcache/vq2-admin_model_tool_backup.php on line 257Notice: Undefined index: value in /home/microweb/public_html/vqmod/vqcache/vq2-admin_model_tool_backup.php on line 257Notice: Undefined index: name in /home/microweb/public_html/vqmod/vqcache/vq2-admin_model_tool_backup.php on line 362Notice: Undefined index: name in /home/microweb/public_html/vqmod/vqcache/vq2-admin_model_tool_backup.php on line 362Warning: Cannot modify header information - headers already sent by (output started at /home/microweb/public_html/admin/index.php:83) in /home/microweb/public_html/vqmod/vqcache/vq2-system_engine_controller.php on line 28Warning: Cannot modify header information - headers already sent by (output started at /home/microweb/public_html/admin/index.php:83) in /home/microweb/public_html/vqmod/vqcache/vq2-system_engine_controller.php on line 29

double post

Hi everyone,

I already posted this issue in the comments section of the extension.
May someone could help me?

Hi AvanOsch,

I just installed your extension. While trying to import an osCommerce Backup I get the following message: " Fatal error: Call to undefined method PHPExcel_Reader_CSV::setReadDataOnly() in /home/www/.../admin/model/tool/export.php on line 1481"
What I did:
1. Installed the osC vqmods (they both appear in the vqmoderator
2. Exported a database backup from osC admin tool (7MB .sql file)
3. Import the sql-file without any modifications via system -> backup/restore

Any idea?
Thanks a lot

Hi everyone,

Sorry to say, I have no time to actively support this extension and figure out the problems people are having...
That said, here's what I think of the latest reported errors:

@webslingers:
It seems there are fields missing from the osCommerce backup?!
The script presumes some fields are always available, like "price" and "quantity".
The error seems to state these fields are not available...

@ayz:
It seems you had an extension installed (osC - Excel Reader CSV?), that has put some PHP code into the database!
The script trips over this code when "analyzing" the backup file.
Remove any code from the database backup.
(You could search your backup for "Excel_Reader", and see what comes up)

I'm unable to get this extension to work.

I am using a database back created under osCommerce v2.2 RC2a. This may be an issue if the database format has changed too greatly between versions.

I select the database and the process starts, but seems to hang shortly after. I'm not sure if the hangup is uploading the DB or processing. After a long time (I've let it run for 20-30 minutes as wella s overnight) it times out with an Error 500.

There's nothing in the Opencart logs. I'm not sure where the process id failing.

Any suggestions? I'm willing to try to manually reformat the tables if there's a script I can try running by hand on a local copy.