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.

Checkout our Features

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

Beyond the call of duty support
5 stars
2019-02-22
The extention is better than any of the other ones I have used to export and import data. I have during the past invested in a few.

Often when we import files we run into errors that the file is not being read correctly. Where to start looking for the cause of the issue and how to solve this?

Checkpoints

Follow these checkpoints to make sure that you have the basics right.

  1. Up-to-date Available Fields
    The list of available fields should be up-to-date before importing starts. If the field list is not up-to-date the import may fail due to missing fields. To update the list of available fields go to Maintenance -> Available Fields -> Click Update
  2. A clean CSV file
    A CSV file should not have any extra characters in any place. A good CSV file may look like this:
    "product_sku","product_name"

    A bad CSV file may look like this:
    "product_sku,product_name"  <-- The " at the beginning and end of the line are wrong
    or
    product_sku,product_name, <-- The trailing comma is wrong
  3. Delimiters
    The template must use the same delimiters as your file has. The type of delimiters does not matter. To know what delimiters your file uses look at your file with Notepad for example.
    Some examples of delimiters are:
    Sample Field delimiter Text enclosure
    "product_sku","product_name" , "
    ~product_sku~^~product_name~ ^ ~
    product_sku|product_name |  

    Check that you have the delimiters filled in your template settings. CSVI needs this to know how to read the CSV file. Alternatively you can use the Automatic delimiter detection.
  4. Encoding
    The file must always be encoded in UTF-8 format. No other encoding is supported. See this Save file as UTF-8 using Notepad2 video on how to save your file as UTF-8 using Notepad2 or this tutorial using LibreOffice/OpenOffice. This is important because files imported not in UTF-8 encoding will not import correctly with special characters like ë and sentences will be cut off.
  5. Field names
    Use only fieldnames that are available for the type of import you are doing. To see which fieldnames are available go to CSVI ---> Available Fields and filter on the type of import you want to do. It is not possible to use any other name. This means that if your CSV file contains the names sku, price, name that these cannot be used, you have to translate them to CSVI fieldnames. Your column names will change like this:
    • sku --> product_sku
    • price --> product_price
    • name --> product_name

    This needs to be done for all the fields in your file.
  6. Field data
    Make sure the data is properly formatted according to the specifications. Information on the fields can be found on the Visual Available Fields pages.
  7. Line endings
    It is best to use Unix or Windows line endings. Mac line endings can give issues, by default they are not supported by PHP. If you have Mac line endings, you can select the option I'm Mac in your template, this will tell CSVI to try to read Mac line endings.
  8. Use the CSVI Analyzer to check your file for any issues. The CSVI Analyzer is included in CSVI and can be found by going to Components -> CSVI Pro -> Maintenance -> Analyzer.
  9. Check the debug information
    The debug report shows every step CSVI takes when importing the file. See the How to collect debug information on how to get your debug report. Check the debug information for anything that might be going wrong or post it in the forum.

After having checked these checkpoints your import should be running smoothly. Check out also this Preparing your CSV file tutorial on how to prepare your CSV file.

Latest Updates

  • CSV Improved Pro 7.12.0 released

    16 May 2019 in News

    CSV Improved 7.12.0 As 2019 is speeding by we have been working hard on this release and the new features it brings. There is a lot to look forward to as we added some productive features. Templates Using templates is now even easier than before. Templates can be backed up directly from the...

    Read More ...

  • CSV Improved Pro 7.11.0 released

    07 January 2019 in News

    CSV Improved 7.11.0 We kick off 2019 with a new release which contains some notable fixes and additions. No major changes this time so it will be a smooth update. HikaShop The export of custom field values was not working but funny enough this issue has been around for quite some time and only...

    Read More ...

  • CSV Improved Pro 7.10.0 released

    04 December 2018 in News

    CSV Improved 7.10.0 The end is coming near for 2018 and we want to leave this year with a parting gift. The final release of 2018 of CSV Improved with many new features. Although you think there are a lot of features in CSVI, more and more are requested and most of them make it into the release....

    Read More ...

My Member Software

My Member Software

My Member Software is the downloadable open source member administration program with which Associations, Clubs, Foundations and even companies can administrate their members and is integrated in the Joomla CMS.

You can use CSV Improved to easily import your user data into My Member Software.

Read all about My Member Software.