Exporting Data

You can export the entire contents of any table or only a select number of fields with the Export Data function. VPCART will create a text or CSV file on your server that you can then download and use with accounting applications such as Microsoft Excel and others.

Note :

You need to set the following configuration if your country is using double byte language :

xReadTextUTF8Filer

Set this to Yes to enable reading text file (*.txt) with UTF8Filermethod.

You need to make sure all your text files are saved inUTF8 format.
If you are from countries using double byte language such as China, Korea, Italy, Sweden, Thailand, Japan etc., please set to Yes.

Set this to No to enable reading text file (*.txt) with FileSystemObject method.
You need to make sure all your text files are saved inANSI format (normal saving).
If you are from countries using non double byte language such as USA, UK, Australia etc., please set to No.

You can access the export feature via Misc> Export Tables. You then need to select the table you wish to update and click the View button.

Then you need to set up the export.

Filename	The name of the file to be exported. For example - products.txt
Directory	The name of the directory to save the exported file into. This directory must have WRITE permissions enabled. If you leave it blank, then VPCart will it storein the admin folder.
Delimiter	This is the character that separates each field. Normally it is a comma (,), a semicolon (;) or a tab.
Header Required	Setting this to Yes means VPCART will write a row at the start of the file with the fieldnames in it.

Click the Continue button and you will be taken to the standard record display page.

If you want to only export selected fields, switch to Advanced mode using the link at the top right of the page and select the fields from the Display list. To select multiple fields, hold down the CTRL key and use your mouse to select the fields.

You can also filter your records using our advanced search filter system by inserting in the search fields what criteria you wish to have returned.

Once you have selected the fields you wish to export, click Display.

You can now either click the Export All Records button, which will export all records in the table to a text file or select each product to be exported individually,then click the Export Selected Records button.

A confirmation page will provide a link to the file created.

NOTE : If you want to export Categories table, make sure you first set “xAdminProCategoryTreeView” to No. So you can select the category records when trying to export the Categories table.