Hello,
I've donde the migrating process and it worked great!! Thanks for this amasing piece of software you developed.
So, when I finished the migrating process (I already copied the images to the new folder images/stories/virtuemart/products) i tried to sync the media files but they won't show up in back nor frontend. When I hit the sync button again I get this message:
Found prior migration process, resume migration maxScriptTime 23999 maxMemoryLimit 358.4
Archivos %s de media sincronizados en el directorio %s.
Archivos %s de media sincronizados en el directorio %s.
Archivos %s de media sincronizados en el directorio %s.
Archivos %s de media sincronizados en el directorio %s.
Todos los archivos sincronizados 0
When I go to a product detail no images show up and no media files are there.
Any idea how I can fix this? I assume where is a sql script I can run to insert the images to the new db?
Thank you guys.
additional images dont migrate
AND, when you go into vmart admin product, do you see iimages?
I don't have additional images and no, i don't see the images in admin product. I've attached an image of what I get in admin product.
[attachment cleanup by admin]
OOOO, you have to do the images in the folder BEFORE you migrate.
Backup the site with akeeba.
THEN, empty the product, and category tables.
also empty
virtuemart_migration_oldtonew_ids
THen do the migration again.
ONLY EMPTY THE _virtuemart product and category tables.
do not empty _vm
OLD virtuemart tables use _vm and they are needed for the migration
Did the process again and it worked!!!!! Thank you very much!!
Thanks worked great for me as well/
Hello,
I leave the community because I know now the same problem with the migration of VM.
Virtuemart version 1.1.6 to 2.0.0.
I did the update via the migration tool Virtuemart.
Everything is imported without any problems, apart from images that do not import.
After many unsuccessful test, I noticed that the table "virtuemart_product_media" not responding properly.
I tested on two different sites is still the same result.
Note that I'm local.
The first site contains over 5000 products and the second just over 500.
I repeated several times that BanquetTables.pro said, but it does not solve my problem.
PS: I do not have special characters in the image name.
Could someone help me?
Thank you in advance to anyone who wants to help me on the subject.
For information is the message at the end of migration:
Quote
Found prior migration process, resume migration maxScriptTime 1439 maxMemoryLimit 89.6
Migrator store medias COM_VIRTUEMART_URL_NOT_VALID
Synchronized 0 media for product in directory images/stories/virtuemart/product/
Synchronized 0 media for category in directory images/stories/virtuemart/category/
Synchronized 0 media for manufacturer in directory images/stories/virtuemart/manufacturer/
Synchronized 0 media for vendor in directory images/stories/virtuemart/vendor/
Processed 0 vm1 shoppergroups time: 6.0796737670898E-5
Looks everything worked correct, migrated 0 categories
Looks everything worked correct, migrated 0 categories xref
Looks everything worked correct, migrated 0 manufacturer categories
Looks everything worked correct, migrated 0 manufacturers
Found 50 vm1 products to import
Found 50 vm1 products to import
Found 50 vm1 products to import
...
Worked on migration for 601.56039404869 seconds
Migration finished
Apparently there would have one or more invalid URL:
QuoteMigrator media store COM_VIRTUEMART_URL_NOT_VALID
I think the system can not find the images because it does not look to the right place.
Anyone have information on the subject?
Its possible to someone do one exemple video of that migration process with some tool like http://camstudio.org/ http://download.cnet.com/windows/video-capture-software/? And next... adding the video on youtube, vimeo, or etc ?
It will be more easy to all if we could see "step by step" all the migration process from VM 1.9 to VM 2.0. We also get less questions in forum about that :P
thanks
here is one I found with a simple search
http://www.youtube.com/watch?v=W5utvww9DLQ
nice! Many Thanks BanquetTables.pro ! only misses the audio instructions... but its ok.
:)
http://www.csvimproved.com/
csv improved is out now, so what you have problems with migrating can be done with csv improved.
AS long as you have a live site, and a development site you are working with.
Thanks again Banquet.
CSV Improved it's a nice solution.. I've read their website months ago and recognise their good job...
But my problem its biggest... i haven't enough money to spend with an small store of my dads.. Besides that my country lives in a big crises so i can afford some modules, plugs and components... The solution: I have to prefer the traditional method of going to the sql admin and try to find and make that transition by the my mind, keybord and mouse.. eheh :)
if, like I was, you're halfway trough the migration and you don't want to redo it.
Here's a solution to link the new media entry's via the old vm tables:
Replace the "
" with your own prefix
Products:
INSERT INTO _virtuemart_product_medias
SELECT null, a.virtuemart_product_id, virtuemart_media_id,1
FROM `_virtuemart_products` a
INNER JOIN `_vm_product` b ON a.product_sku= b.product_sku
INNER JOIN `_virtuemart_medias` c ON c.`file_title` = b.`product_full_image`
Categories:
INSERT INTO _virtuemart_category_medias
SELECT null, a.virtuemart_category_id, virtuemart_media_id,1
FROM `_virtuemart_categories_nl_nl` a
INNER JOIN `_vm_category` b ON a.category_name= b.category_name
INNER JOIN `_virtuemart_medias` c ON c.`file_title` = b.`category_full_image`
Quote from: douby02 on January 19, 2012, 12:54:55 PM
Migrator media store COM_VIRTUEMART_URL_NOT_VALID
if(strpos($this->file_url,'..')!==false){
$ok = false;
vmError(JText::sprintf('COM_VIRTUEMART_URL_NOT_VALID',$this->file_url ) );
}That means that your url has a .. in it and is therefore blocked, because this is something hackers do.
And to milosmilos and prolipes. The migrator is working well, but one line makes still trouble in mysql5.0, so maybe the reason is that your database is outdated. And we successfully ported shops with 20k products and images, with users, orders.
UPDATE: Problem Solved in 2.0.6
........................
Just missing that little code in javascript (like you have explained in some post before) that detects in "Upload a File" > "Image Action" if we will going to upload any image/file from our Disk and change it automaticaly from "None" default position to "Upload" position... this option will be nice!!!
PS: I've found some problems in mod vm manufacturers.. i've created a topic explain whats happening to me... i dont know who's the member that could solve this problems to the next 2.0.3 .. if you could see that we thank you :)
here: http://forum.virtuemart.net/index.php?topic=98779.0
I will make also some other topics giving some ideas/sugestions to VM2..
Thanks again.. I (we) love the VM2! :)
Thanks, milosmilos for great idea. I didn't know how to migrate additional images, but this helps:
INSERT IGNORE INTO hwfnk_virtuemart_product_medias
SELECT null, a.`virtuemart_product_id`, `virtuemart_media_id`, 2 FROM `hwfnk_virtuemart_products` AS a
INNER JOIN `hwfnk_vm_product` AS b ON a.`product_sku`= b.`product_sku`
INNER JOIN `hwfnk_vm_product_files` AS f ON f.`file_product_id` = b.`product_id`
INNER JOIN `hwfnk_virtuemart_medias` AS c ON f.`file_name` LIKE CONCAT ('%', c.`file_title`)
Note: "hwfnk_" - this is my Joomla prefix. It should be replace to yours.
I got this to work and thought I would share. If you follow the migration directions EXACTLY, then it should work fine. I got to the point where everything migrated (but for attributes and additional images) but my images weren't associated with my products. To fix this, I first backed up my database, then downloaded its contents so I was sure I could replace my work. Next, I used the Reset Tables and Do a Fresh Install tool. This wipes out all the db data. Next, I used the synchronize media tool (be sure you have your product images in the right folders first!). I ran the Synch tool twice just to be sure. Next, I set up the Shop information (currency - etc.). I also added in the original store admins shopper id. I then ran the migrator. It took 5 times to complete - but now I have everything I need! Well - everything that is possible to transfer. I hope that helps someone.
Outstanding product VM team, thank you.
Quote from: saviB on October 12, 2012, 16:30:37 PM
To fix this, I first backed up my database, then downloaded its contents so I was sure I could replace my work. Next, I used the Reset Tables and Do a Fresh Install tool. This wipes out all the db data. Next, I used the synchronize media tool (be sure you have your product images in the right folders first!). I ran the Synch tool twice just to be sure. Next, I set up the Shop information (currency - etc.). I also added in the original store admins shopper id. I then ran the migrator. It took 5 times to complete - but now I have everything I need!
saviB, I'm at the same point. I can do the migration but can't get the images associated. A few questions about your post:
1. After using the "Reset Tables and Do a Fresh Install tool", do you reupload your db before running the media sync tool?
a. When you say you backed up your db and downloaded its contents, are you referring to all the jos_vm tables?
2. Or are you saying you simply:
a. upgrade successfully to vm 2.0 (with everything that involves)
b. use the Reset Tables and Do a Fresh Install tool (presumably only affecting the new VM 2.0 db tables)
c. use the Sync tool
d. run the migrator