You are hereMonthly archive / March 2010
March 2010
Beginning Migrating Oscommerce to Drupal Ubercart
The process of migrating Oscommerce to Drupal Ubercart, does involve a few processes, however, the advantages are numerous. Check out http://www.ubercart.org/drupal-ecommerce and http://groups.drupal.org/node/8096 for some data about why Ubercart/Migrating from Oscommerce. Personally I feel that the codebase of oscommerce has become very outdated and is no longer running to the potential it could. Alongside this, the Drupal project is growing and Oscommerce shrinking, with a large proportion of new modules being produced for Drupal/Ubercart.
Migration of OsCommerce Products to Node Products
The difficult thing that appears with moving the products using the migrate moduel appears to be the inability to put multiple tables into one table. To counteract this I ended up migrating all ot the Oscommerce product data into one database table and then sending the content over with the migrate module. The code ended up something like this although this is obviously editable dependant on what data you have in Oscommerce/want in Drupal:
Product aggregator to take products from Oscommerce and dump into a mysql file for insertion to Drupal Database.
<?php
Migration of OsCommerce Products to Node Products: 2
Following the uploading of products to one product database within phpmyadmin/mysql root, you will now have a Drupal database with a new table named 'products' within it. You can then use the table wizard module to expose the table to the migrate module and draw relationships between the 'products' and 'uc_products' database table.
I have added another little script which runs almost the same process as the migrate module, however, this may need to be edited to run successfully:
<?php
$ubercart_database = 'uberdrupal_tensor';
Migration of OsCommerce Users to Drupal Users
The migration of OsCommerce user to Drupal user can be a troublesome one, largely due to the password storage within OsCommerce. Ryan from Ubercart "the osCommerce method of storing passwords involves using "salt" on the password... appending some random characters and making an MD5 of it all. You can't undo MD5 hashes to get the original password, unfortunately, and Drupal just uses an MD5 of the password itself" (http://www.ubercart.org/forum/development/1379/oscommerce_ubercart).
NOSql/MongoDB and Drupal: Implications
Recently I have been reading a lot more about NoSQL databases, specifically MongoDB and CouchDB, ad how 2010 will be the year of NoSql. NoSql databases themselves move away from the structure of a relational database, mssql/mysql, and move more toward storing all of their data in views, which can contain a range of information.
Why NoSql?
