Import VirtueMart 2 users

Requirements

• CSVI 4.0+
• VirtueMart 2.0.2
• Joomla 2.5+
• PHP 5.2+

Required Fields

New users

The required fields for importing new users are:

• email
  The e-mail address of the customer/user
• address_type
  
  • BT for Billing address
  • ST for Shipping address
• address_type_name
  A name for the address, the default is -default-
• first_name
• middle_name
• last_name
• address_1
• city
• country
• perms
  The is the VirtueMart user permission
  
• password
• usergroup_name
  This is the name of the Joomla user group the customer needs to be assigned to

Existing users

• user_id or email
• address_type
• address_type_name

VirtueMart users

CSVI checks first if the user_info_id is in the imported file because this is the unique identifier for each address. In case this is not present, CSVI will try to find the user_info_id based on the user_id or email, address_type and address_type_name. When no user_info_id is found a new address will be added, otherwise the existing one is updated.

Shopper groups

CSVI will use the shopper_group_name field to find the correct ID to link the user to the correct shopper group. If the supplied shopper_group_name cannot be found the default shopper group will be used.

Vendor ID

CSVI will use the vendor_name field to find the correct ID to link the user to the correct vendor. If the supplied vendor_name cannot be found the default vendor will be used.

Joomla users

A Joomla user is updated when the email field is imported.

Passwords

There are 2 fields to handle passwords, only 1 should be used for import:

• password
  This is the plain text password. CSVI will encrypt this password on import to get a valid Joomla password.
• password_crypt
  This is the encrypted password. On import CSVI will not change this and assumes it is a valid Joomla password.

Creating Joomla users

CSVI creates Joomla users if:

• the email is in the imported file
• the password is in the imported file
• there is no user_id in the imported file
• no existing user can be found

If the user_id field is imported, the user data will only be updated.

Example file

"email","address_type","address_type_name","first_name","middle_name","last_name","address_1","city","country","perms","password","usergroup_name"
" This email address is being protected from spambots. You need JavaScript enabled to view it. ","BT","-default-","John",,"Doe","Unknown","Missing City","USA","shopper","showmein","Registered"

Download the CSV file

Locked out from the website

See the Joomla documentation on how to recover the administrator password.