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+

Cron command requirements

The cron command is a combination of a few settings:

  1. The PHP executable
  2. The path to cron.php
  3. The arguments

Let's take a closer look at these requirements.

PHP executable

The PHP executable is the program that processes the cron script. How the PHP executable is called completely depends on your host, check with them where your PHP executable resides. Some examples of the PHP executable are:

  • php
  • /usr/local/bin/php

Path to the cron.php file

The file that starts the import or export is called cron.php, this file can be called directly from the command line. The file is located in /administrator/components/com_csvi/helpers/cron.php. It is important to know where the file is as you need to use the path to build the cron command. The full path needs to be the complete path to the cron.php file. The full path depends on your host, check with them what your path needs to be. Some examples of the full path are:

  • /home/domain/public_html/administrator/components/com_csvi/helpers/cron.php
  • /www/administrator/components/com_csvi/helpers/cron.php

Arguments

There are several arguments that need to be passed on to make the cron work. These arguments are:

  • username

This must be a known user in the Joomla system that has backend access.

  • passwd

The password belonging to the supplied username.

  • template_name / template_id

The name of the template that needs to be used. This must exactly match the name of the template in the template list. Instead of using the template name, the template ID can also be used.

  • filename
The full path and name of the file to import. This is only used for imports. It is also possible to store the filename in the template by setting the source to load from server and specify the full path to the filename. Some examples of the full path and name are:
  • /home/domain/public_html/example.csv
  • /www/example.csv

Build the cron command

With all the requirements in place we can build the cron command. The command is build up in this order:
PHP executable path to the cron.php arguments
 
Including the arguments the full command for an import can look like this:

/usr/local/bin/php /home/domain/public_html/administrator/components/com_csvi/helpers/cron.php username="admin" passwd="admin" template_name="CSVI Product import" filename="/home/domain/public_html/example.csv"
/usr/local/bin/php /home/domain/public_html/administrator/components/com_csvi/helpers/cron.php username="admin" passwd="admin" template_id="123" filename="/home/domain/public_html/example.csv"

Including the arguments the full command for an export can look like this:

/usr/local/bin/php /home/domain/public_html/administrator/components/com_csvi/helpers/cron.php username="admin" passwd="admin" template_name="CSVI Product export"
/usr/local/bin/php /home/domain/public_html/administrator/components/com_csvi/helpers/cron.php username="admin" passwd="admin" template_name="124"

Including the arguments the full command for a maintenance task can look like this:

/usr/local/bin/php /home/domain/public_html/administrator/components/com_csvi/helpers/cron.php username="admin" passwd="admin" task="maintenance" operation="emptydatabase"

Make sure this command is all on one line. In a cronjob you cannot span an entry across multiple lines. 

Cron generator

CSVI cron 48

CSVI includes a cron generator option and this is located on the supported pages in the top right corner. This button creates the cron command, however you still need to update the command with the correct PHP executable and username/password.

Template settings

All settings from the template will be used when importing or exporting data. It is possible to use specific settings for a specific cron job. To add these specific settings, after loading the template, make the changes to the template and then click on the cron command. You will now get a cron command with all the changed settings. The command can look like this:

php "D:\server\www\csvi4pro/administrator/components/com_csvi/helpers/cron.php" username="" passwd="" template_id="119" jform:general:category_separator="/"

Setting up the cron command

How to setup the cron command depends on your host. Check with them how to set it up for your site. There are 2 control panel systems used often, these are cPanel and DirectAdmin, instructions for these follow here.

cPanel

  1. Login to cPanel for your site
  2. Click on Cron Jobs in the Advanced area.
    cPanel advanced cron
  3. Select the time you want the job to run in the Add New Cron Job
  4. Fill in your cron command in the Command box
    cPanel cron setting
  5. Click on Add New Cron Job
  6. The job is now scheduled

DirectAdmin

  1. Login to DirectAdmin for your site
  2. Click on Cronjobs in the Advanced Features area
    directadmin advanced cron
  3. Fill in the time you want the job to run in the Create a New Cron Job
  4. Fill in your cron command in the Command box
    directadmin cron setting
  5. Click on Add
  6. The job is now scheduled

EasyCron

If your host does not allow you to run cron jobs, there is an alternative service called EasyCron. EasyCron give you the ability to run cron jobs whenever you like and customize them to your own needs.

The output

The output has been optimized for command line output, this means there is no HTML code. This can be forwarded (piped) to a file for later analyzes.

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