Import users from Virtuemart

Hi,
I am in the process of migrating from an old webshop on Joomla 1.5 and Virtuemart to a new one on Jooma 2.5 and Hikashop Business. I have read that I can import my products by installing Hikashop on the old Joomla 1.5 website, importing my products from Virtuemart into Hikashop, then exporting from Hikashop and again importing the exported Hikashop files in the new website. Is this correct?

I would also like to import the users from the old website into the new website and save all the user info such as addresses, passwords etc. Is there a similar process to do this?

Kind regards,
Chris

Okay, I've installed Hikashop on the old website and imported the data from Virtuemart. This seems to have worked as it should. I cannot find out how I can now export the data from Hikashop to place it into Hikashop on the new website though. There is an option to export all products as a .CSV file, but I don't see any similar options for the user info. Can someone tell me how this can be accomplished?
Kind regards,
Chris

Hi,

I think that the best way is to export the table from phpMyAdmin and then import them on the new website still via phpMyAdmin

Hi Xavier,
Thank you for your answer. Could you tell me which tables exactly I should export and import? In PHPMyAdmin I can see several tables that have the word "user" in their name.
Kind regards,
Chris

Hi,

You have to export the tables:
_hikashop_user
_hikashop_order
_hikashop_order_product
_hikashop_address

You have too to export/import the users related tables in the joomla tables.

It's been a while since I asked my original question, but I've only now gotten around to actualy migrating the users from the old joomla 1.5 to the new 2.5 website.

I am running into quite some trouble doing what you suggested importing the MySQL tables from the old website into the new one.

I've imported the following tables from the old database into the new one:

_USERS
_hikashop_user
_hikashop_order
_hikashop_order_product
_hikashop_address

These have overwritten the existing tables. (I'm doing all this on a back-up of the website so I still have all original data saved.)
After doing so I now cannot log in to my site back end. I figured out thet this is because Joomla 1.5 does not have a table called _USER_USERGOUP_MAP. I can add the id of my super admin account to this table manually, which enables me to log in in the back-end, but this just gives me a blank page.
I also assume that the lack of the _USER_USERGOUP_MAP table will cause problems with the login's for my subscribed users.

What can I do to succesfully transfer my user details from the old Joomla 1.5 hikashop website to the new Joomla 2.5 one?

Thanks for all the tips!

I already tried taking a backup of the Joomla 1.5 website, upgrading it to Joomla 2.5 using jupgrade and installing the latest version of Hikashop on that. Importing the tables (_users, _user_notes, _user_profiles, _user_usergroup_map, _hikashop_user, _hikashop_order, _hikashop_order_product and _hikashop_address) from this Joomla 2.5 installation info my new website still gave me only error messages.

I read online that the extension for migrating users that you recommended (userport) would change the id numbers for my users, which would destroy the link between the Joomla user data and the data stored in the Hikashop tables. So I went looking for another solution.

I ended up taking the approach described here . And after importing the Joomla users I manually imported the data from the hikashop tables from my joomla 1.5 hikashop installation directly into the Joomla 2.5 database, in a similar way as described in this article. Which took some time to do table by table, but after a day of frustration finally solved my issue.

I thought I'd post how I managed to solve this because maybe someone else will benefit from these tips.

Kind regards,
Chris