VirtueMart Forum

VirtueMart Dev/Coding Central: VM1 (old version) => Virtuemart 1.1 Development (Archiv) => Quality & Testing VirtueMart 1.1.x => Topic started by: steve1084 on March 27, 2008, 14:45:51 PM

Title: Virtuemart Data Migration from 1.0.* to 1.5.*
Post by: steve1084 on March 27, 2008, 14:45:51 PM
Just wondering if anyone has ideas on the best way to migrate virtuemart shop data, images,files etc from joomla 1.0.* to joomla 1.5.*

CSV can migrate much of the data but not everything, are there planes for a special migration script.


Thanks
Karim :)
Title: Re: Virtuemart Data Migration from 1.0.* to 1.5.*
Post by: jenkinhill on March 27, 2008, 22:05:42 PM
I think it is more difficult to migrate from Joomla 1.0.x to 1.5.x than it will be to migrate from VM1.0.x to 1.1

As I understand it, a script will be available for VirtueMart migration.
Title: Re: Virtuemart Data Migration from 1.0.* to 1.5.*
Post by: steve1084 on April 05, 2008, 07:22:05 AM
Quote from: jenkinhill on March 27, 2008, 22:05:42 PM
I think it is more difficult to migrate from Joomla 1.0.x to 1.5.x than it will be to migrate from VM1.0.x to 1.1

As I understand it, a script will be available for VirtueMart migration.


Yes this is what I was meaning as I would like to migrate my 1.0 joomla site to joomla 1.5 and use the new virtuemart 1.1 as it looks and behaves way nicer than the old 1.0 version. Many many thanks to all the contributors, it realy is very nice.

If there is any such script available yet.  I am quite willing to do some testing.

I have about 1200 products I need to migrate, I dread the thought of starting from scratch again to build the shop.

Thanks
Steve
Title: Re: Virtuemart Data Migration from 1.0.* to 1.5.*
Post by: kilian73 on April 07, 2008, 09:24:20 AM
I am also searching for this script to migrate my Products.
Where could i get it?  ???

Greetz
kili
Title: Re: Virtuemart Data Migration from 1.0.* to 1.5.*
Post by: jenkinhill on April 07, 2008, 11:04:08 AM
It is now built in to the manual installation package, which includes a .pdf file of instructions. http://dev.virtuemart.net/cb/proj/doc.do?doc_id=1328

Don't forget to back up first.....
Title: Re: Virtuemart Data Migration from 1.0.* to 1.5.*
Post by: MoonWizard on April 08, 2008, 11:27:28 AM
NICEE!!!!!!

A question first... this script upgrades from VM 1.0.15 to VM 1.1.0 RC3 in a Joomla 1.0.15?? Does VM 1.1 work in Joomla 1.0.15?

And then will be possible to move all data to a VM 1.1 in Joomla 1.5.2?

Thank you very much!!!  ;D
Title: Re: Virtuemart Data Migration from 1.0.* to 1.5.*
Post by: jenkinhill on April 08, 2008, 13:20:19 PM
Yes, VM 1.1 works in Joomla 1.0.15
Title: Re: Virtuemart Data Migration from 1.0.* to 1.5.*
Post by: MoonWizard on April 08, 2008, 23:21:05 PM
Thankyou jenkinhill!

So the process is...

1. Migrate from VM 1.0.15 to VM 1.1

2. Migrate all data + VM 1.1 to Joomla 1.5.X, isn't it? Am I correct?

Thank you!!
Title: Re: Virtuemart Data Migration from 1.0.* to 1.5.*
Post by: jenkinhill on April 08, 2008, 23:55:25 PM
I did a site the other way round, updating Joomla first. That took longer as I had some custom code to recreate. The VM update was really quick.
Title: Re: Virtuemart Data Migration from 1.0.* to 1.5.*
Post by: MoonWizard on April 09, 2008, 00:01:19 AM
Ok!!!

Thank you!! I will try upgrading first Virtuemart and then Joomla.

Virtuemart ROCKS!!!!  ;D
Title: Re: Virtuemart Data Migration from 1.0.* to 1.5.*
Post by: TRIPLEdm on April 14, 2008, 09:54:22 AM
Thank you for this post.

I dont want to sound like idiot but for some reason I cannot find the Joomla Migration tool... it's more than likely infront of me but just cannot find it.

Can you please help?

And am I correct that migration instructions is in the PDF file included with VM 1.1 files?

Thank you in advance!
Title: Re: Virtuemart Data Migration from 1.0.* to 1.5.*
Post by: jenkinhill on April 14, 2008, 10:07:14 AM
You get the Joomla Migrator from Joomla!!

http://docs.joomla.org/Migrating_from_1.0.x_to_1.5_Stable

And see http://forum.joomla.org/viewtopic.php?f=430&t=283807
Title: Re: Virtuemart Data Migration from 1.0.* to 1.5.*
Post by: kilian73 on April 15, 2008, 12:50:43 PM
Hi There

I've got an other Question.
Could you help me with the migrations Tool?

What are the Plugins and the Table Files that i have to copy in this Migrator Directory?
Where can i find this Files? (virtuemart.sql and the Tablefiles.php)
Are they in the Virtuemart Installationpackage?

Thanks for your Answer.

Greetz
kili
Title: Re: Virtuemart Data Migration from 1.0.* to 1.5.*
Post by: lowlight on April 25, 2008, 12:10:40 PM
Quote from: jenkinhill on April 14, 2008, 10:07:14 AM
You get the Joomla Migrator from Joomla!!
http://docs.joomla.org/Migrating_from_1.0.x_to_1.5_Stable
And see http://forum.joomla.org/viewtopic.php?f=430&t=283807
So just to make sure, before I mess anything up.

You are saying that once we have upgraded to VM 1.1, we can then upgrade to Joomla 1.5 simply by using the base migrator component found here? (http://joomlacode.org/gf/project/pasamioprojects/frs/) You are saying that we don't need to use a 3rd party migrator plugin?
Title: Re: Virtuemart Data Migration from 1.0.* to 1.5.*
Post by: aravot on April 25, 2008, 17:58:16 PM
That is a Joomla question to be 100% it is better to ask in their forum, I have not yet updated a site from Joomla 1.0.x to Joomla 1.5 so not sure of side effects.

Make sure you BACKUP before proceeding.
Title: Re: Virtuemart Data Migration from 1.0.* to 1.5.*
Post by: lowlight on April 27, 2008, 14:00:17 PM
Quote from: aravot on April 25, 2008, 17:58:16 PM
That is a Joomla question to be 100% it is better to ask in their forum, I have not yet updated a site from Joomla 1.0.x to Joomla 1.5 so not sure of side effects.
Make sure you BACKUP before proceeding.
It's not really a Joomla question, because migrating Joomla is easily doable by moving the database over. Virtuemart puts its own tables in, which Joomla will ignore if not migrated properly. So it's up to the developers to come up with a way for us to do that. Thanks in advance, developers! ;)
Title: Re: Virtuemart Data Migration from 1.0.* to 1.5.*
Post by: Vinh on April 28, 2008, 03:00:34 AM
Hi guys,
I just tried to migrate from VM1.0.2 -> VM1.1 and at the same time migrate to Joomla 1.5 and it was rather a desaster...

the VM transition is really quite simple, getting VM1.1 to run was no problem. You just have to be aware that the templating system changed so if you have modified something in your browse or flypages (and I'm sure you did), you have to manually change that to the new structure (e.g. no all data is now directly derived from php variables instead of "{product_or_whatever}"). I haven't done it, but it looks rather painless in my case - at least I could see my old shop in VM1.1, just here and there needing some fix and all.

The transition to Joomla 1.5 was hell. =D
First, there is no migration script for VM as far as I know (might be wrong), so you have to kind of migrate manually. What I did was to have the database backed up during the joomla installation (They rename the tables to "bak_..."). After that, I reinstalled Virtuemart 1.1 directly onto the new and fresh Joomla 1.5 (you cannot use your old joomla as the internal structure has changed). Then I wrote a small script to rename all bak_vm_** back to jos_vm_**

Well, the biggest problem and the reason why I'm now switching back to the previous Joomla installation is:

1) My template needs to again be adapted to Joomla 1.5. I think they have a new structure too. So at least for my template, it didn't work at all in the new Joomla.

2) I don't need a new fancy Joomla. The only reason I have Joomla is because Virtuemart runs on it, I'm actually just using VM anyways   =)

Yep...just wanted to share my small "night" experience.
Title: Re: Virtuemart Data Migration from 1.0.* to 1.5.*
Post by: pablo0713 on April 29, 2008, 08:20:35 AM
I was able to migrate from Virtuemart/Joomla 1.1/1.0.15 to 1.1/1.5 without too many hiccups. I'm a newb at such things, but was able to figure it out from reading this thread (so thank you!!!). Basically this is what I did:

1. Backed up web site.
2. Upgraded Virtuemart to the latest version.
3. Ran Migration tool for Joomla for SQL data dump.
4. Used phpMyAdmin to export the _vm tables for virtuemart.
5. Installed Joomla 1.5 in a new folder.
6. Imported Joomla data from SQL data dump.
7. Installed Virtuemart 1.1.
8. Deleted new _vm tables in phpMyAdmin.
9. Imported previous _vm tables in phpMyAdmin
10. Renamed tables to match the database prefix.
11. Uploaded images to the /shop_image/product directory.

My biggest hurdle was having to deal with file permissions and not being able to write to certain folders. All it took were a couple of emails to my web hosting tech support, they reset permissions, and I was good to go.

Obviously, I need to redo all templates - but the catalog is functional. Although, I am noticing some missing product images...but not too many. If I can't figure out why this is happening, I can always upload them again.

Not sure if this will help anyone, but feel free to ask me questions as I've spent a good day trying to migrate/upgrade Joomla and Virtuemart so it is fresh in my head! I'm no expert but I'll do my best to help.
Title: Re: Virtuemart Data Migration from 1.0.* to 1.5.*
Post by: graham on April 30, 2008, 14:54:36 PM
Hi I have tried what you have said to the letter and when it goes to import the Imported Joomla data from SQL data dump. I just get errors, I have also had my tec team try this and the same thing happened to them.
anyone esle running into this problem or have found a way round this????
Title: Re: Virtuemart Data Migration from 1.0.* to 1.5.*
Post by: pablo0713 on April 30, 2008, 20:05:57 PM
Quote from: graham on April 30, 2008, 14:54:36 PM
Hi I have tried what you have said to the letter and when it goes to import the Imported Joomla data from SQL data dump. I just get errors, I have also had my tec team try this and the same thing happened to them.
anyone esle running into this problem or have found a way round this????
I did not experience any errors during the importing process of the Joomla SQL dump. It was an option during the installation process so it went smoothly for me.

What sort of error messages are you receiving? Perhaps I or someone else can help if we know what kind of errors are occurring.
Title: Re: Virtuemart Data Migration from 1.0.* to 1.5.*
Post by: gwilym on May 20, 2008, 13:24:42 PM
Hi there,

I have just followed the excellent advice above and have everything smoothly into 1.5 - the only problem I have is that the product detail pages are not showing up. They are there because I can see the SQL and in the menu and in the 'latest products' module etc they are all there - but when you click on a product there is no product info.

Is this a flypage problem? Any advice appreciated...

Gwilym

BTW - I've tried different templates but that makes no diference...
Title: Re: Virtuemart Data Migration from 1.0.* to 1.5.*
Post by: jenkinhill on May 20, 2008, 23:54:36 PM
Check all file ownerships.
Title: Re: Virtuemart Data Migration from 1.0.* to 1.5.*
Post by: pablo0713 on May 28, 2008, 16:23:48 PM
Quote from: gwilym on May 20, 2008, 13:24:42 PM
Hi there,
I have just followed the excellent advice above and have everything smoothly into 1.5 - the only problem I have is that the product detail pages are not showing up. They are there because I can see the SQL and in the menu and in the 'latest products' module etc they are all there - but when you click on a product there is no product info.
Is this a flypage problem? Any advice appreciated...
Gwilym
BTW - I've tried different templates but that makes no diference...
Not sure if you solved your problem, but try turning off SEF links (under SEO section of Joomla global config). I had this same problem and thanks to the advice by Jenkinhill, turning off SEF links fixed my product detail pages (which also weren't showing up)