Moving data from live Virtuemart 1 site to an already migrated Virtuemart 2 site

[msargenttrue]

I have a current version and redesigned version of a Joomla/Virtuemart website:

Current Live Version: http://fairgirls.earthcare.com/ - Joomla 1.5.25, Virtuemart 1.1.9
New Version: http://fg.earthcaretest.com - Joomla 2.5.8, Virtuemart 2.0.22c

I want to get all the most up-to-date store data: users, products, orders, etc. from the current live site and bring it into the new site. I thought this would entail a normal Virtuemart migration, however, another developer already migrated the store a few months ago. The old store has still been live this whole time and now the new store data is out-of-date. The New Version of the site has all the most up-to-date content in the Joomla core so I don’t want to touch any of that stuff. But the old version of the site has the most up-to-date store info. So, I just want to update all the Virtuemart data in the new site.

I started by looking at this guide: http://www.ostraining.com/blog/joomla/virtuemart-11-to-version-2/

There doesn’t seem to be anything in the guide about how to get the original (old) database tables into the new site. Probably because the guide is expecting me to be starting from a full Joomla 1.5 Virtuemart 1.1.x site and migrating.

Is there a guide out there that just covers what database tables to move over from the Virtuemart 1.x install to the 2.y.x install? And how to use the database tools to update the databases for compatibility with Virtuemart 2?

I also found the “Migrator for Virtuemart” extension:
http://extensions.joomla.org/extensions/extension-specific/virtuemart-extensions/virtuemart-administration/25279

I would be willing to purchase this tool to do the job however, it also looks like it expects you to start from a full Joomla 1.5 Virtuemart 1.1.x site in order to migrate. I’m unsure if it will handle the job properly if I already have the Joomla 2.5 site in place instead of a blank Joomla 2.5 install that it mentions.

I’m rather confused about how to handle updating this Virtuemart data in the state that the site is currently in. I’ve done a lot of searching but haven’t come across something that cleanly fits the bill. Any guidance and advice that you all can provide would be very helpful.

Thanks,
Mike S

[GJC Web Design]

As I understand it - (quite happy to be shouted down) - as long as you put ALL the old vm1.1  tables in the new VM2 database (they are named differently so they don't over write anything) you can happily click the "Start Migration" button as many times as you like...

It takes that data and imports everything to VM2.0

I also assume you would do an import first of the J1.5 users via one of the importer extensions

But as with everything, backup, make copies etc etc

What I would do is clone your current J2.5 site and play...

mind u before doing any of that I would upgrade your horribly old J2.5 and your mediumly old VM2.0

[msargenttrue]

Thank you for the prompt feedback.

For testing purposes I ended up cloning the site and upgrading to Joomla to 2.5.16 with no issues.

Updating Virtuemart, on the other hand, would not work with live update. I would get the error message: “Invalid Token, in store config”. I heard that the live update does not work on some shared servers (this one is hosted on Hostgator) so best to always use Joomla's extensions manager. I went that route to install the newest version of Virtuemart core and aio.

That seemed to go fine, but then I realized there were modifications to some of the Virtuemart core files and styles that were lost with this update. I was able to replace 2 of the files with their original modified versions but still have very small thumbnails on the product categories pages.

Now onto the Migration steps:

1. I went into the live (old) virtuemart database and exported all the tables with the vm prefix. 
2. I deleted any old vm tables in the new site database that were used with the previous migration.
3. I imported the up-to-date vm tables into the new site.
4. I went into the Virtuemart backend, navigated to Tools > Tools & Migration and clicked Start Migration.

I also did a separate export/import with Jos_users and Jos_users2 tables and tried the migrator again.

The result was nothing useful migrating to the new store and a bunch of error messages…

I really don’t need the users though. I just want records of the order history and all the image updates that have been made to the products.

The final time i tried an export/import migration i included all the vm tables and both jos_users and jos_users2 tables in one package with the same results.

Questions:

1. I have attached the error messages that resulted from the last migration I tried. Any ideas of how to resolve these?

2. Does it matter that all the Joomla tables in the original live site have a “jos” prefix and the new site has the prefix “fgt2”?

3. Am I missing steps? I’ve yet to find a straight-forward guide of moving content from a live virtuemart 1.x.y site to a new virtuemart 2.x.y version of the same site that has already been migrated but is a few months out of date… its hard to even search for something like this because whenever i search for migration and virtuemart its all about moving an entire Joomla 1.5/Virtuemart 1.x.y site to Joomla 2.5/Virtuemart 2.x.y.

4. Any recommended tools on how to migrate users from 1.5 to 2.5 that will keep passwords intact? Can I get all the orders history without bringing over the users?  I would prefer not to move the users at all. Existing users can just re-register when they want to buy products on the new site. Besides there are a horrendous amount of spam users that should be weeded out from the original user list…

Thanks again for the help.

[attachment cleanup by admin]

[GJC Web Design]

1&2 - would say most definitely the table prefix has to be the same

that's what the first error is saying table fgt2_vm_userinfo doesn't exist - I assume it is still jos_vm_userinfo

re users - I have used this succesfully - not bad for $10
http://www.joomlarra.com/arra-user-export-import-for-joomla-3.0-and-2.5/vmchk.html

you need to install the free version on the J1.5 to export