Importing from osCommerce using the 'osc2oxid.php script'

English forums
1

Dear friends,

I am currently evaluating OXID CE and consider to migrate from osCommerce to OXID CE - which is an outstanding piece of Software

I also tried to ‘poke around’ with the oscommerce import script in order to move my about 3000 articles in an automated way.

To my understanding such script must be started from the command line in order to allow the proper database accesses.

Unfortunately my Provider does not offer the option to start scripts from a command line and I got now stuck with my efforts.

Would it be possible to modify such scrips in a way that they can be started from the WEB-Browser?

Or has anyone another hint how to get this achieved?

Thanks for any productive proposal.

Greetings from Wiesbaden/Germany

Dieter Haude

2

Hi Dieter,

here:http://www.oxid-esales.com/en/resources/help-faq/eshop-manual/importing-os-commercext-commerce

I found the import howto which says

As the import may take some time, the script should be called from the command line of your server.

which means that it is depending from the script runtime (max_execution_time) and the size of data you have to import. So maybe it would work without any hassle from your browser as well otherwise ask your provider to increase the execution time for a moment. Just give it a try. :wink:

I will forward your suggestion anyway.

Thanks!

Marco Steinhäuser
Community Guide
OXID eSales AG
http://twitter.com/marcosteinhaeus

3

@ Marco

Thanks for the fast reply - very much appreciated!

Unfortunately it does not work since the script is not passing any mySQL user and password entries and therefore the script termiates and claims it cannot access the osCommerce database

regards

Dieter Haude

4

hmm… it shall perhaps work like this:

Do a parallel installation of an OXID eShop on the server where your osc runs. Probably the database of your osc doesn’t grant any access from outside the server. Maybe this is the point. Afterwards, you might easily move the OXID.

Regards

Marco Steinhäuser
Community Guide
OXID eSales AG
http://twitter.com/marcosteinhaeus

5

Hi Marco,

Thank you very much for the hint - but I already have both shops installed on the same server.

The 2 databases (OXID & osCommerce) do have different user- and database names and here seems to be the problem with the script.

I personally believe that the script needs to be extended a little bit in order to provide separated database names and user id’s.

I’ve got stuck

regards

Dieter

6

Hi Dieter,

Philipp was so nice to adopt the manual
Importing from osCommerce/xt:Commerce a bit so it shall work for you now.

Regards

Marco Steinhäuser
Community Guide
OXID eSales AG
http://twitter.com/marcosteinhaeus