CSVI is a versatile management tool for importing all kinds of data into many different extensions.
IMPORT AND EXPORT INTO AND FROM JOOMLA! 3 HAS NEVER BEEN SO FAST
CSV Improved enables you can import and export data into and from different Joomla! components.
Every component features its own import and export types to allow control over every part of the component.
Using a system that works based on a set of pre-defined fields you can match your fields with the CSV Improved fields to ensure a correct import. This way you can import all kinds of files from different kinds of sources,
for example from your supplier.
Using the same set of pre-defined fields you can set your own export fields to export for an accounting package, order list, order picking list and many other uses.
- CSVI 6.1.2+
- VirtueMart 3.0.9
The required fields for importing new users are:
The email address of the customer
- BT for Billing address
- ST for Shipping address
A name for the address, the default is -default-
This is the name of the Joomla user group the customer needs to be assigned to
An encrypted password
The is the VirtueMart user permission
If no username is provided, the email address will be used as username
- user_id or email
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.
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.
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.
A Joomla user is updated when the email field is imported.
The username field is not required and if you do not include it, CSVI will use the email address as username field.
There are 2 fields to handle passwords, only 1 should be used for import:
This is the plain text password. CSVI will encrypt this password on import to get a valid Joomla password.
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.
Locked out from the website
See the Joomla documentation on how to recover the administrator password.