| Q/. Importing and Exporting data from and to the database. A/. When uploading to the database using the Import Tool you need to ensure that the following criteria is met:
- Every field in the import file matches the database table. While you do not have to have every field present in the import file you cannot have extra fields.
- Ensure that at a minimum you have the hide field in the import file set to the number 0 (zero) so the products will display as required.
- Make sure you match either the catalogid, ccode or the cname field as the match field and that the field you choose is present in the import file.
- If using a csv as the upload file make sure you change the Delimiter field from a semi colon to being a simple comma.
- When importing products look in the Admin page to see what fields are required and ensure these fields are populated for any new records.
To get the best idea of what the import file should look like try exporting the existing demo products table using the Export Tool.
Select Export from the top right of the edit products section. This will work for any of the tables in the YourVirtualStore.
Now insert the name of the file you want to export, the location you want to export to and the symbol used to indicate the end of a field. The name of the file can either end with .txt or .csv.
When you click continue you are taken back to the page you were on. Now the field at the far right is called "export" instead of delete with the check boxes and the buttons at the bottom of the page also now refer to the export function.
Select which fields you wish to export.
Click Export All Records and you will see the following message:
============================
Exporting to: C:\Documents and Settings\yvs\yvs500\export\products.txt
Number of Records written= 34
============================
Using your ftp program download this page to your local machine and open.
You need to ensure that all fields are displayed on the one line. If you have html formatting in any of the fields you will need to open the import file and delete any line breaks.
Looking at this page will give you an insight into how the txt or csv file should be set up.
When setting up your new csv or text file for a product import you must ensure that you insert a category number and a sub cat number as well if the product is to be in a sub cat. You need to insert the very top level category id and the final sub category id only.
You also can only have one number in this field. Even though YVS allows you to display your products in multiple categories and sub categories the import tool only allows the initial setting up in one.
The same theory applies with features and cross selling.
Using this method you can ensure that your data is correctly formatted.
If your products still do not appear try running the convertproducts.asp page to force them to appear. Use this only as a last check.
If you get the following error have a look at what record the error was reached at look in your csv or text file to ensure that the record is correctly formatted:
Microsoft VBScript runtime error '800a0009'
Subscript out of range: 'index'
/AB1038127equick/shopa_import.asp, line 128
This will enable you to run through the import and slowly remove all errors from your import document.
If your import file is too big it can also error out as the server times out during the import process.
printable version Back to Main Page | 
