Lost password?    Lost username?    Create an account
OverviewDownloadsForumSupport
CSV Improved

CSV Improved

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
    VirtueMart User permissions
  • 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.

Joomla username

The username field is not required and if you do not include it, CSVI will use the email address as username field.

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.

TESTIMONIAL

A life saving extension
5 stars
2012-10-31
Working on a conversion site from an old CMS to Joomla, I needed a solution that would import the old users, plus, set them up with correct subscriptions within Akeeba Subscriptions.

A quick pre-sales email to Roland and he said he would be happy to add the features that I needed, but it might take a few weeks. All good, I can wait, it was ready the next day!!

A session with Roland in Skype and any minor issues were sorted and now I can easily import over 2000 users with active subscriptions, saving me who knows how much time in the process.

Roland is one of the true professionals of the extension community and if you are looking for a solution, then you have found it and more!!

Awesome stuff!

STAY INFORMED


Stay informed with the CSVI newsletter.