TipIn the Add Validation section of the Configurations dialog box, you can add, edit or delete multiple field level validations for the fuel import file. During import, FASTER Web validates the fuel records against the validations that you set here and imports only the valid records to FASTER Web.
Tip
To view the Add Validation section of the Configurations dialog box, click the Configure link.
1. Open the Configurations dialog box of the required field.
The Add Validations section is displayed by default.
2. In the Operator list, select the required operator.
Note: The Operator list displays options based on the characteristic of the field such as String, Decimal, Integer or Date and Time. For more information, see Operator Types.
3. In the Value box, type a value for the selected operator.
Note: To include fuel transactions of the specified operator type during fuel import, select the Accepted check box. To reject transactions of the specified operator type, do not select the Accepted check box. By default, the Accepted check box is not selected.
4. Click Add.
The provided validation is displayed in the Validations grid.
Note: Follow the same procedure to add multiple validations for the selected field type. Click Close to close the Configurations dialog box.
|
Navigation Tips: · To expand or collapse the grids in the search window, click · To move the grids in the search window, drag a grid to a desired location. To save the position of the grid, click the |
1. Open the Configurations dialog box of the required field.
The Add Validations section is displayed, by default.
2. In the Validations grid, click Edit in the Action column of the required validation.
The fields of the corresponding validation becomes edit able.
3. Make the required changes as applicable.
4. When finished, do one of the following in the Action column:
§ Click Update to save the changes made.
§ Click Cancel to disregard any changes made.
1. Open the Configurations dialog box of the required field.
The Add Validations section is displayed, by default.
2. In the Validations grid, click Delete in the Action column of the validation that you want to delete.
The Delete Validation dialog box displays the confirmation message.
3. Do one of the following:
§ Click Yes to delete the validation.
§ Click No to disregard deletion and close the Delete Validation dialog box.
· String fields such as Asset Number and Product Code displays the following options:
§ Equal To: Provide the complete value such as asset number/ product code. For example, asset number A0001.
§ In: Provide multiple comma separated values. For example, meter type in Miles, Hours.
§ Not Equal To: Type the value that you want to include/ exclude during fuel import.
§ Begin with: The starting letter (s) / digit (s) of the value. For example, all asset numbers that begin with A1.
§ Ends With: The ending letter (s) / digit (s) of the value. For example, all asset numbers that end with 00.
§ Contains: The value contains any specific letter/ digit. For example, all asset numbers that contains the number 1.
· Decimal/ Integer fields such as Unit Cost and Tax Cost displays the following options:
§ Equal To =: Provide the complete value. For example, unit cost is 10.
§ In (in a list): Provide multiple comma separated values. For example, 1,2,3,4.
§ Not Equal To <>: Provide the value that must not exist during fuel import.
§ Greater Than >: Only the values that are greater than the provided value are imported. For example, unit cost must not be equal to 0.
§ Less Than <: Only the values that are lesser than the provided value are imported. For example, unit cost must be less than 99999.
§ Greater Than Or Equal To >=: Only the values that are greater than or equal to the provided value are imported. For example, unit cost must be greater than or equal to 0.01.
§ Less Than Or Equal To <=: Only the values that are lesser than or equal to the provided value are imported. For example, unit cost must be lesser than or equal to 999.99.
§ Between < AND >: When you select this operator, you must provide the start value and the end value. Only the values that are in the specified range are imported. For example, unit cost must be between 0 and 100.
· Date/ Time fields such as Transaction DateTime displays the following options:
§ Greater Than >: Only the transactions that have occurred after the provided date are imported. For example, transaction date must be after 01-Jan-2017.
§ Less Than <: Only the transactions that have occurred before the provided date are imported. For example, transaction date must be less than 31-Dec-2020.
§ Greater Than Or Equal To >=: Only the transactions that have occurred on the specified date or after the specified date are imported. For example, transaction date must be on or after 01-Jan-2017.
§ Less Than Or Equal To <=: Only the transactions that have occurred on the specified date or before the specified date are imported. For example, transaction date must be on or before 31-Jan-2017.
§ Between < AND >: When you select this operator, you must provide the start date and the end date. Transactions that have occurred between the specified date range are imported. For example, transaction date must be after 01-Jan-2017 and before 31-Jan-2017.
to the right of the
icon. The position of the grids will be the same next time you open the search window.