SELECT LANGUAGE:

IMPORT

all kind of files.

CSVI is a versatile management tool for importing all kinds of data into many different extensions.

Learn More

EXPORT

the easy way.

Export your data into different formats to different locations, automatic or manual. The choice is yours.

Get started! It's free

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.

 Template based import/export Multi-component Support  Automated import/export Rule engine Field mapper Multi-source IMPORT/EXPORT

Learn More

Perfect order export tool for VirtueMart and more
5 stars
2014-07-31
My customer wanted a VirtueMart order export for Excel and after trying some other extensions, this one was the only one that did the job. I had to filter out some unnecessary text in the fields, so I used the replacement function. Earlier I used the Free version for simple product import/export, that was fine. The Pro version really has so many functions, you can adjust everything according to your needs. Really excellent work.

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.

Start import and export your files with CSV Improved

GET STARTED!

Latest Updates

  • CSVI Pro 5.20, Joomla! 2.5 and more

    01 December 2014 in News

    CSVI Pro 5.20 The CSVI Pro 5.20 is the last release of this year and has quite a few changes. Here is the full list: Import changes Fixed VirtueMart product import not removing product reviews on product deletion Added VirtueMart shopper group import Added support for Customfields for all 2.0 and...

    Read More...

  • CSVI Pro 5.19 released

    03 August 2014 in News

    New release CSVI Pro 5.19 The CSVI Pro 5.19 is a stability release with a few fixes: Added Support for VirtueMart 2.9.2 and higher Added Tags support for K2 Item import Fixed Joomla native SEF on Joomla 3

    Read More...

  • CSVI Pro 5.18 released

    01 July 2014 in News

    New release CSVI Pro 5.18 The CSVI Pro 5.18 is a stability release with a few fixes: Updated the handling of K2 extra fields The VirtueMart product import now always assumes there is one product price only. Use the Multiple prices import to add extra prices. Added a check for Joomla 3 on the cron...

    Read More...

More products by RolandD

JD iDEAL Gateway

Integrate iDEAL and other payments into your site with JD iDEAL Gateway. JD iDEAL Gateway supports 25 different extensions among VirtueMart, RSForm! Pro, RSEvents! Pro, RSMembership!, HikaShop and Membership Pro and features a payment page. Now also with RaboBank Omnikassa, Ogone and SEPA support.

Go to JD iDEAL Gateway