VPCART can import data into any table from a flat text file with almost any delimiter. This feature is generally used for importing products.
Note: Records can be added or updated but they cannot be deleted with this import facility.
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 UTF8Filer method. You need to make sure all
your text files are saved inUTF8 format. |
Before you can import a file to your VPCART database, you must upload it to your server. You can either do this with FTP or you can use the upload form at the top of the Bulk Import page in VPCART.
To upload your file, simply click the Browse button and locate it on your computer. Then enter the name of a write-enabled directory on your server to upload it to (you may need to contact your host and ask which directory you can upload to, or to have them set write permissions on the admin\import folder). When you have done this, click the Upload button.
The bottom form on the Bulk Import page is where you specify the details of the import. If you have used the Upload facility above, some of these fields will be automatically filled out.
|
filename |
The name of the file to be imported. It can be a full disk address or relative address. For example - products.txt orc:\imports\mydata.txt |
|
Table |
The table you want to import the data into. |
|
Match Field |
The field to match the data from the import file to the database to determine whether a record should be added or updated |
|
Delimiter |
This is the character that separates each field. Normally it is a comma (,), a semicolon (;) or a tab. |
|
Display |
Setting this to Yes displays a message on screen as each record is imported. Setting this to No displays only a summary after the import has been done |