Exporting data with CSVI VirtueMart
To export data from CSVI VirtueMart a few steps have to be taken. For CSVI VirtueMart to know what to export you have to tell CSVI VirtueMart exactly what you want.
Steps to create an export template:
- Make an export template
- Go to templates
- Click on New
- Fill in the General Settings tab
- Set Choose your template to Export
- Give the template a name
- Set the delimiters you want to use
- Fill in the Export tab
- Choose the template type
- Fill in any other options to your liking
- Fill in the E-mail tab if you wish to e-mail the report
- Click on Save
- Tell the template what to export
- Select the template by clicking on the radio button
- Click on Fields
There are 2 ways of adding fields, first is the Quick Add or the New Field bar. Below is the New Field bar described. - Fill in the field order in the New Field order box
- Choose what field you want to export in the New field name dropdown box
- Optional: Fill in a New column header if you do not want the field name to appear in the export file
- Optional: Fill in a New default value if you want to export this value if there is no data in the database for this field
- If Available: Set the New replace value to yes if you want CSVI VirtueMart to replace your export value with a replacement you have set in the Replacement section
- Click on the + sign to add the field to the template
- Repeat step 3 - 8 for as many fields as you wish to export
- Click on Export
- Select the template you just made by clicking on the radio button
- Fill in any other options at the bottom if you want
- Click on Export in the top right corner
- The file will now be offered for download
