OSCommerce Import Module Settings

[curtdonohue]

Hello,

I'm trying to figure out how to use the Importer OSCommerce v1.0 module from the Back Office. I'm using PrestaShop v1.4.3. I'm using OSCommerce v2.3.1.

I set up a test OSCommerce store last night, but I just cannot figure out what the settings should look like for the following fields:

Server: ?
User: ?
Password: ?
Database: ?
Database Prefix: ?

I went into the OSCommerce configure.php file and found the following settings (I modified the results below so you can't see the actual values):

define('DB_SERVER', 'localhost');
define('DB_SERVER_USERNAME', 'xyz_scm1');
define('DB_SERVER_PASSWORD', 'xyz123');
define('DB_DATABASE', 'xyz_scm1');

With this information, I thought that the settings should look like this:

Server: localhost
User: xyz_scm1
Password: xyz123
Database: xyz_scm1
Database Prefix: xyz_

Unfortunately, those values aren't working and I cannot make a connection to the OSCommerce database. Can anyone tell me what I'm doing wrong?

[curtdonohue]

Update:

I determined that I was incorrect in thinking that the database prefix was supposed to be "xyz_" as noted above. I opened up the OSCommerce tables and didn't see anything like what PrestaShop has as a database prefix. PrestaShop uses the prefix of "ps_", unless you change it when you install your store initially.

Since OSCommerce did not appear to have a database prefix, I left that field blank and moved on. That seemed to work, however, I came across an error that said: Fatal error : iso code is not correct. After looking around a bit, I found many posts on OSCommerce importing issues.

Here is a link to what, I think, is the most current status of the Importer OSCommerce Module: http://forge.prestashop.com/browse/PSCFI-2340.

The short story is that is doesn't currently work, but the thread moderator sounds like he may be able to help.

[salazar]

hi

I try to know how to use the Importer OSCommerce but without success

I find the error

TECHNICAL ERROR

 

Details: Fatal error (Group->name est vide pour la langue par défaut)

[mux]

I also want to use "Importer osCommerce" but found no way till now....