Move users from Joomla 1.0 to 1.7

[codj2k]

I am taking over a site that is still running on Joomla 1.0. I need to move the users to Joomla 1.7.

There are currently over 200 active users on the 1.0 site.

I have built the new version of the site from scratch on 1.7.

However, I need to import these users from 1.0 to 1.7.

I understand that I will have to export the following tables from phpMyAdmin on the 1.0 and import them to the 1.7 site.

These are the tables in 1.0:
1. jos_users
2. jos_groups
3. jos_core_acl_aro
4. jos_core_acl_groups_aro_map

However, Joomla 1.7 doesn't use the same / exact names as 1.0 and the structures appear different.

This is what I done so far...the items on the right are the table names in 1.7
1. jos_users = jml_users
2. jos_groups = jml_usergroups
3. jos_core_acl_aro =! COULDNT FIND A CLOSE MATCH IN 1.7
4. jos_core_acl_groups_aro_map = jml_user_usergroup_map

While the export and import processes were successful, when I try to login, both as an admin/backend and a a regular user, I get the following error messages:

ADMIN SITE ERROR
JUser: :_load: Unable to load user with id: 62
JUser: :_load: Unable to load user with id: 62
You do not have access to the administrator section of this site.


MAIN SITE ERROR
JUser: :_load: Unable to load user with id: 93
JUser: :_load: Unable to load user with id: 93
You cannot access the private section of this site.


Could someone help with which table matches what and if I need to edit any table to ensure this works?

[RussW]

the J!1.0 and J!1.7 ACL tables are not compatible. You will need to find an extension that exports the J!1.0 users to maybe a CSV file and then maybe another extension that can import tthe CSV in to J!1.7

or, do them by hand.

[Per Yngve Berg]

You are missing the jml_user_usergroup_map table which maps users to groups.

[codj2k]

I have that, it is the 4th table above. Please see the original post

[Per Yngve Berg]

jos_core_acl_aro is the jos_users table in 1.7