Hello.
My e-shop currently is running on J1.5 and VM1. I've just installed J1.7.2 and VM2.0.0-RC2i and I want to import all the products and categories from my old site. Does the migrator do that?
Thanks in advance!
on a different install?
Export the database tables for virtuemart. THEN, import into the new database.
MOVE your image files into the correct folder.
Then, use the migrator
Export the database tables for virtuemart. THEN, import into the new database.
How is this done?
Venkko, there is an import and export button in phpmyadmin
YIU HAVE to make sure you only get the vm_ tables though
I should export all the vm tables? What about the tables prefix being different in the 1.7 installation than this in the 1.5? I suppose that's what the migrator does?
thats exactly what the migrator does
1.1 is _vm 2.0 is _virtuemart
I've just importe the tables in the new database and tried to use the migrator (without uploading the product images, just to see if it works). I got this message and no products was imported:
QuoteFound prior migration process, resume migration maxScriptTime 26 maxMemoryLimit 96
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/
Looks everything worked correct, migrated 0 categories
No categories to import
Looks everything worked correct, migrated 0 manufacturer categories
Looks everything worked correct, migrated 0 manufacturers
_productPorter Table 'ebath_main.hc0zn_vm_product' doesn't exist SQL=SELECT * FROM hc0zn_vm_product AS `p` LEFT JOIN hc0zn_vm_product_price ON hc0zn_vm_product_price.product_id = `p`.product_id LEFT JOIN hc0zn_vm_product_mf_xref ON hc0zn_vm_product_mf_xref.product_id = `p`.product_id LIMIT 0,8500
Worked on general migration for 0.0415258407593 seconds
Was this suppose to happen?
Thanks in advance.
update your vmart and try again.
It is already updated (j).
However, I've also installed the aio (latest) but when I go to the aio component it says that I have the 'i' version even though I have the j installed, so I get a 'new version is available' message.
this is exactly how I migrated a site on friday.
How did you import and export tables?
Using phpMyAdmin, I've did an export selecting the old tables (saving it to a .sql file) and went to the new database and imported (uploading the file). So my database looks like this.
note: I still haven't uploaded the product images, all I've done was the db thing.
[attachment cleanup by admin]
if you do the migration without the images, you will have to do it all over again.
ALSO, what you do is keep hitting the migrate "all" until it finishes.
So I should upload the product & category images too and then retry? Or there are more steps before it?
Note that I only want to get the products/categories from the old shop. I'll reconfigure it myself. No shopper groups etc need to be imported.
And by "ALL" you mean "Migrate everything"?
yes move pics first
2nd tab "Migration" and choose "everything" and you have to probably do it 5 times for all to migrate
Uploaded the images and did a migrate everything. I got this message:
QuoteFound prior migration process, resume migration maxScriptTime 26 maxMemoryLimit 96
Synchronized 489 media for product in directory images/stories/virtuemart/product/
Worked on migration for 26.0135719776 seconds
Migration finished
Info: File for images/stories/virtuemart/product/ΚΑΜΠΙΝΑ ΜΠ is missing
EDIT: Now i'm running the migration for 3rd time to see what happens. By the way I don't see any imported products on my product list.
I'm about on the 6th execution of the migration (I have 2639 products). I always get some messages like these:
QuotemError: Couldnt create thumb, file not found /home/ebath/public_html/images/stories/virtuemart/product/A_1.JPG4d19cd41a9e80.jpg
vmError: Couldnt create thumb, file not found /home/ebath/public_html/images/stories/virtuemart/product/A_1.JPG4d19ccb06ad09.jpg
and
Info: File for images/stories/virtuemart/product/ΚΑΜΠΙΝΑ ΜΠ is missing
Info: File for images/stories/virtuemart/product/ΚΑΜΠΙΝΑ ΜΠ is missing
Info: File for images/stories/virtuemart/product/ΚΑΜΠΙΝΑ ΝΤ is missing
do it a few times, and u should see them
I've run it like 15 times.
I've also tried the "Synchronize media to Virtuemart" button in the "DB Tools" tab in which case I get a slightly different message that says
QuoteFound prior migration process, resume migration maxScriptTime 26 maxMemoryLimit 96
Synchronized 59 media for product in directory images/stories/virtuemart/product/
Synchronized 176 media for category in directory images/stories/virtuemart/category/
The synchronisation is not finished, please execute again
By the way I keep migrating "everything" to see what happens.
After a lot of executions, it seems like it's finished but I don't see any products or categories..
Here's what I get if I try to migrate again now...I always get the 31 products message.
[attachment cleanup by admin]
and no products?
No products/categories at all, only the sample data from when I first installed VM2.
Hmmm, cyrillic letters. Maybe the problem is there. It would be good to have a russian sampel, please contact me via pn, if you are interested.
It's not cyrillic, it's Greek (utf8). Shouldn't it be supported?
Quote from: Milbo on October 24, 2011, 22:47:15 PM
Hmmm, cyrillic letters. Maybe the problem is there. It would be good to have a russian sampel, please contact me via pn, if you are interested.
Would it help if I gave you an admin account to my site?
So any more help about this? Problem still isn't resolved :(
Nevermind, I'll stick to 1.1.9. Thanks for the help.
mandingueiro
are you using the joomla setting mysql or mysqli ? In joomla config?
ALSO, anything different on your server? Is this local xampp? or real host? It it cpanel, or windows?
You have very strange filenames in your products for the media _________________4cb8af5fc2c8c.jpg, when you have cyrrilic letters, then there is no filesuffix ΚΑΜΠΙΝΑ ΜΠ . But you have this values also in your vm1 product table. Hmm, strange thing.
The vm1 is on a Linux cPanel webhost. The vm2 is on a different webhost but also linux cPanel.
Yes a lot of product images indeed were using Greek letters (http://www.greekschoolnottingham.co.uk/pics/adults/greek_alphabet.gif) but *not* Cyrillic.
The point is that you use non lain characters and this is not so easy
I see. So what do you suggest me to do now?
It would be good, when you do some tests.
Upload some media in greek letters and test if that works. Can you enter greek names and all that? Is it stored correctly in the db?
Atm I have an idea, why it is not working, I create a fix and upload the file here, then you can test it next hours.
Same problem, my site runs under a fresh J1.7 installation, and a fresh VM2 install, with french language installed. I migrated my VM1 tables via a sql file and checked if everything as ok for it. I read all the posts concerning Migration between VM1 and VM2, but here are the messages i receive when using the migration tool :
Found prior migration process, resume migration maxScriptTime 44999 maxMemoryLimit 96
Synchronisé 0 des médias pour product dans images/stories/virtuemart/product/ répertoire
Synchronisé 0 des médias pour category dans images/stories/virtuemart/category/ répertoire
Synchronisé 0 des médias pour manufacturer dans images/stories/virtuemart/manufacturer/ répertoire
Synchronisé 0 des médias pour vendor dans images/stories/virtuemart/vendor/ répertoire
Processed 0 vm1 shoppergroups time: 5.0067901611328E-6
Looks everything worked correct, migrated 0 categories
No categories to import
Looks everything worked correct, migrated 0 manufacturer categories
Looks everything worked correct, migrated 0 manufacturers
Forget IT
Info: File for images/stories/virtuemart/product/1ff5f2527907ca86103288e1b7cc3446.jpg is missing
Info: File for images/stories/virtuemart/product/480655b410d98a5cc3bef3927e786866.jpg is missing
Info: File for images/stories/virtuemart/product/520efefd6d7977f91b16fac1149c7438.jpg is missing
Info: File for images/stories/virtuemart/product/578563851019e01264a9b40dcf1c4ab6.jpg is missing
Info: File for images/stories/virtuemart/product/8716aefc3b0dce8870360604e6eb8744.jpg is missing
Info: File for images/stories/virtuemart/product/8cb8d644ef299639b7eab25829d13dbc.jpg is missing
Info: File for images/stories/virtuemart/product/9a4448bb13e2f7699613b2cfd7cd51ad.jpg is missing
Info: File for images/stories/virtuemart/product/cca3cd5db813ee6badf6a3598832f2fc.jpg is missing
Info: File for images/stories/virtuemart/product/e614ba08c3ee0c2adc62fd9e5b9440eb.jpg is missing
Info: File for images/stories/virtuemart/category/1b0c96d67abdbea648cd0ea96fd6abcb.jpg is missing
Info: File for images/stories/virtuemart/category/756ff6d140e11079caf56955060f1162.jpg is missing
Info: File for images/stories/virtuemart/category/fc2f001413876a374484df36ed9cf775.jpg is missing
Info: File for images/stories/virtuemart/category/fe2f63f4c46023e3b33404c80bdd2bfe.jpg is missing
Info: File for images/stories/virtuemart/vendor/washupito.gif is missing
Info: Worked on general migration for 0.58302903175354 seconds
MIGRATION VM1 > VM2
VM 2.0.0-RC-2j | Joomla 1.5.24
Virtuemart V2 works fine but the migration not !
I have about 1050 images products (40Mo)
Found prior migration process, resume migration maxScriptTime 107 maxMemoryLimit 768
Synchronized 0 media for product in directory images/stories/virtuemart/product/
The synchronisation is not finished, please execute again
=> See below
I tried to Synchronize media to VirtueMart 10,20, 100 times !!!!
So i decided to change view things in my php.ini :
max_execution_time = 120
max_input_time = 120
memory_limit = 1024M
post_max_size = 80M
upload_max_filesize = 10M
So What can i do ? Any idea ?
Thanks,
Edouard
[attachment cleanup by admin]
The problem appears due different char encodings.
Quote from: ed4sof
Could you tell me what should I do ?
Do I need to change the encoding of my DB (php myAdmin ?)
I can do that in local(wamp) but which encoding should I use ? UTF8 ?
There are various possibilities. I tested it, stored an image with cyrillic chars. I could open it with my windows media browser, but not with irfanview. My apache shows me just ?? for a cyrillic char. But our russian and greek developers dont have problems. Both use linux and of course their server is compiled to support this.
So I think there are various possibilities.
- your php must support multibyte (UTF-8)
- the php command readdir must support unicode (UTF-8)
- your server (Filesystem) should run maybe just in unicode (UTF-8)
- your browser should also use UTF-8 (they usually do)
The database is usally in utf-8, the collation is NOT setting the charset, it is just setting the method to sort.
Tried to upload an image with greek letters in an existing product (nice saw) and it's not uploaded right. The proper filename was ασδ.jpg but when I uploaded it on the product images the image wasn't visible (broken src) and the filename wasn't right after the upload. Basically what I got is displayed in the screenshot attached.
I also attached a screenshot from the database virtuemart's media table.
I also noticed that any new products I add in the virtuemart are not displayed in the front-end even though they are displayed on the backend (latin chars everywhere).
[attachment cleanup by admin]
My host just enabled the Multibyte support and now I get this error on all my joomla pages: Infinite loop detected in JError.
Any clues?
So Milbo, are you planning to fix the bug (if it's a bug) with the non-latin characters in the migrator or I have to work it out myself? Or maybe if I paid some1 he could do this for me?