Managing Fuel Import Settings

The Fuel Import Setup page lets you configure and manage the settings to import fuel transactions in FASTER Web. To successfully import fuel transactions to FASTER Web, the import file provided by the vendor must match the import settings configured for that vendor.

Managing the fuel import settings include the following:

·      Configuring Fuel Import Settings

·      Editing Fuel Import Setup

·      Editing Fuel Import Preferences

Configuring Fuel Import Settings

The Fuel Import Setup dialog box lets you configure the settings of a fuel import transaction such as configuring file name, vendor, fueler ID type, asset identifier and cost identifier.

Note: The vendor information must exist in FASTER Web in order to configure fuel import settings for that vendor. You can add the vendor information from the Vendors module of FASTER Web.

Tip

To view the Fuel Import Setup dialog box, click the Fuel Import Setup link.

To configure fuel import settings

1.    Open the Fuel Import Setup page.

2.    Click Add New Item.

The Unlock Fuel Import Setup dialog box opens.

3.    In the Password box, type the password, and then click Validate.

The Fuel Import Setup dialog box opens.

4.    In the Name the Import Configuration File box, type a name for the import configuration file.

5.    In the Select a Vendor list, select a vendor from the list.

Note: The Select a Vendor list displays the names of vendors that exist in FASTER Web.

6.    In the Is this a Fixed Column? list, select Yes or No.

Note:

  • If you set the fixed column to Yes, it is mandatory for you to set the fixed length validation for each field name. For information about setting validations, see Setting Validations to Import Fuel Files.

  • If you set the fixed column to No, you must select a file delimiter from the Select a File Delimiter list. The file delimiter separates the fields in the import file. Since the column size is not fixed, there is no restriction on the number of characters for each field.

  • If you set the fixed column to No, and select a file delimiter from the Select a File Delimiter list as comma ',' , only then the Support Quoted Value list is enabled. You can select Yes or No from the list. By default, No is selected.

  • If you  select Yes, then the value in the Fuel Import file which is delimited by comma and enclosed with double quotation mark is considered as a single value.

  • If you  select No, then the value in the Fuel import file is delimited based on the value selected from File Delimiter list. Hence, the file is imported as per previous functionality.

This setting is also applicable for Schedule Automated Fuel Import Settings.

  • In the Select the Fueler ID Type list, select the fueler ID type to one of the following:

  • Employee: You can specify the employee number/ vendor employee number of a person in the fuel import file. The employee number is validated during fuel import only if the Validate Employee check box in the Edit Fuel Import Preferences dialog box is selected. For a successful validation of employee number, you must specify a valid employee number in the import file. The employee number information in the import file cannot be blank.

  • Driver License: You can specify the driver license of the person in the fuel import file.

  • Last Four Digits of Fuel Card: You can specify the last four digits of the fuel card number in the fuel import file.

  • Other Fueler ID: If you want to provide a Fueler ID other than employee, driver license, or last four digits of fuel card, you can specify any number as fueler ID in the fuel import file.

7.    In the Select the Asset Identifier list, select an option to identify the asset.

8.    In the Select Date and Time format list, select the date and time format to be used in the fuel import file.

§      Select Date and Time combined (single value) to provide fuel transaction date and time as a single value. Example: 2/8/178:00:00

§      Select Date and Time separated (two values) to provide fuel transaction date and time as two different values separated by a delimiter. Example: 2/8/17; 8:00:00

Note: Based on the selected format, the date and time options appear as a single field or two separate fields while configuring layout settings for fuel import. To know the different formats of date and time, see Fuel transaction date and time format.

9.    In the Select the Cost Identifier list, select the cost identifier to declare the cost.

Note: The total cost is considered without markup.

10.  Click one of the following:

§      Save to save the information and close the dialog box.

§      Cancel to disregard any changes and close the dialog box.

Editing Fuel Import Settings

The Edit Fuel Import Configuration dialog box lets you update the configuration settings of fuel import in FASTER Web.

Tip

To view the Edit Fuel Import Configuration dialog box, click the Edit Fuel Import Configuration link.

To edit fuel import settings

1.    Open the Fuel Import Setup page.

2.    Click the View link next to the fuel import name.

The Fuel Import Setup dialog box opens.

3.    Click Enable Editing.

The Unlock Fuel Import Configuration dialog box opens.

4.    In the Password box, type the password, and then click Validate.

The Edit Configuration link is enabled in the Fuel Import Setup dialog box.

5.    Click the Edit Configuration link.

The Edit Fuel Import Configuration dialog box opens.

6.    Make the changes as required.

7.    Click one of the following

§      Save to save the information and close the dialog box.

§      Cancel to disregard any changes and close the dialog box.

Editing Fuel Import Preferences

The Edit Preferences dialog box lets you assign organizations for fuel import. These organizations are assigned to a specific vendor. While importing fuel transactions of a vendor, FASTER Web validates the organizations against the vendor name and imports only transactions of the assigned organization.

Tip

To view the Edit fuel import preferences dialog box, click the Edit fuel import preferences link.

To assign organizations for fuel import

1.    Open the Fuel Import Setup page.

2.    Click the Edit Preferences link next to a fuel import record.

The Edit Fuel Import Preferences dialog box opens.

Note: While configuring settings for fuel import, if you have selected Employee as the Fueler ID Type, the Validate Employee check box is enabled. You can select this check box if you want FASTER Web to validate the employee number of the user who performs fuel import.

3.    Select the Enable Fuel Import Scheduling in the Integrations Module check box to add this Fuel Configuration to the Integrations Module for scheduling fuel import.

Note: If you clear the Enable Fuel Import Scheduling in the Integrations Module check box for a fuel import, a message box is displayed and when you click Ok to it, the fuel configuration is removed from the Integrations module and from the associated fuel import settings.  

4.    Assign organizations for fuel import by using navigation icons.

Note:

·      Ensure that the organizations that you add are assigned to the user who imports fuel transactions.

·      Add at least one organization for successful fuel import.

§      To add organizations for fuel import, select the organization and click .

§      To remove organizations from fuel import, select the organization and click .

§      To add all the organizations for fuel import, click .

§      To remove all the organizations from fuel import, click .

5.    Click one of the following

§      Save to save the information and close the dialog box.

§      Cancel to disregard any changes and close the dialog box.

Top of Page