Magento

This might have something to do with the charsets I chose when running. But I ran the migration tool, it took around 3 hours and appeared to be working like a charm. But when it was complete, I was missing:

Product Names (Only had ids and prices)
Category Names (Only Ids and Parent linkage)
Customer Names (Only email address, date since, country, zip and phone)
Customer Address(See above - Only country and zip)

In addition:
No Order data was imported at all (report said it only missed 2 because there was no customer for them)
No image links for products (Images HAVE been imported and arranged properly in the media dir though - just no links to products)

This is the first time I have run this. So not sure if my settings were sweet or not. I set both the Connection and Data charset to UTF-8. This is what my database told me in the admin.

Any ideas?

Sorry

Using the latest download of both Magento and The migration tool
OsCommerce 2.2-MS2

Cheers
Aaron

I’ve tried using utf-8 for both as well - same results for me.

What charsets should we be using?

If I run the query on my database:

SHOW VARIABLES LIKE ‘c%’;

I get:

character_set_client utf8
character_set_connection utf8
character_set_database latin1
character_set_results utf8
character_set_server latin1
character_set_system utf8
character_sets_dir /usr/local/share/mysql/charsets/
collation_connection utf8_general_ci
collation_database latin1_swedish_ci
collation_server latin1_swedish_ci

But if I try the import with:

Connection charset = utf8
Database charset = western(latin1)

I get a blank page and a hang - ‘waiting for the website to respond’

We really need this mod in order to migrate our stores across, but at present it’s unusable.

It’s been over 4 weeks since there was an update, and the mod is still in beta - is anyone actually working on it, and is anyone answering questions and dealing with the problems people are finding when they try to use it?