|
|
### **Import**
|
|
|
|
|
|
|
|
|
|
* Importing Contact data from a CSV file, an email, a form submitted on your website, or a
|
|
* Importing Contact data from a CSV file, an email, a form submitted on your website, or a
|
|
|
third-party app like Google Contacts or Office 365
|
|
third-party app like Google Contacts or Office 365
|
| ... | @@ -92,6 +91,27 @@ If you are importing a multi-select picklist values, multiple values should be s |
... | @@ -92,6 +91,27 @@ If you are importing a multi-select picklist values, multiple values should be s |
|
|
|
|
|
|
|
If you are importing values into a reference field (ex: Organization field in Çontact), and a record is not present with the value, Vtiger will create a new record. Any mandatory values in the referenced record will be set to ????. Import fails if a record has mandatory Reference fields with an empty value.
|
|
If you are importing values into a reference field (ex: Organization field in Çontact), and a record is not present with the value, Vtiger will create a new record. Any mandatory values in the referenced record will be set to ????. Import fails if a record has mandatory Reference fields with an empty value.
|
|
|
|
|
|
|
|
|
* Inventory fields
|
|
|
|
|
|
|
|
Points to be noted while importing files into Inventory.
|
|
|
|
|
|
|
|
**1.** The item name in CSV file has to be same as that present in Product/Service list.
|
|
|
|
|
|
|
|
**2.** The specified item name by default will be searched in Product list first and then in the Service list. To make your work easy, append the item name with product/service in the following format
|
|
|
|
Products::::Product_Name
|
|
|
|
Services::::Service_Name
|
|
|
|
|
|
|
|
**3.** The Quantity and Selling price fields have to be specified properly and must be mapped. If you don’t specify it, the Import will fail.
|
|
|
|
|
|
|
|
**4.** The Tax values must be in percentage format, as it is calculated on the Total amount.
|
|
|
|
|
|
|
|
**5.** Discount can be applied to an Individual item or on a group of items, specify the type of discount you prefer to add.
|
|
|
|
|
|
|
|
**6.** Tax type has to be mapped correctly and in CSV file the Tax type should be specified either group or individual, if not it would consider the default tax type.
|
|
|
|
|
|
|
|
**7.** If 2 records with 2 different items contain the same Subject, then it would be considered as a single record.
|
|
|
|
|
|
|
|
**8.** Specifying the Items Total, Pre-Tax Total, Received, Balance and Grand Total in CSV file will not be considered, as these fields depend on Item total, discount and taxes added to it, other fields like Quantity, Selling Price, Discount, and Tax added to it.
|
|
|
|
|
|
|
|
### **Inventory Management**
|
|
### **Inventory Management**
|
|
|
|
|
|
| ... | |
... | |
| ... | | ... | |