Import Formulas screen

Use the Import Formulas screen to define import formulas to be used when you import data. Advanced users can create import formulas to lessen the number of validation errors you receive when you get external data from Microsoft Excel or QuickBooks.

CAUTION: The Import Formulas screen is primarily intended for use by Viewpoint Customer Support and Professional Services.Viewpoint strongly recommends that you Contact Trimble Viewpoint before attempting to create or work with import formulas.

Use the Import Formulas screen to define import formulas to be used when you import data. Advanced users can create import formulas to lessen the number of validation errors received when you get external data from Microsoft Excel or QuickBooks.

These are just a few examples of what you can do with import formulas:

Example 1) Combining Columns
Example 2) Changing Case
Example 3) Adding Columns
Example 4) Mapping Values
Example 5) Conditionally Converting Values
Example 6) Evaluating Data

Note: To open the Import Formulas screen, select Administration > Utilities > Import > Import Formulas.

Import Formulas screen

Table of Contents