Fuel Import Guide
Fuel Import
The following screenshots will show you how to perform a fuel import into FOS. Before starting the import save the CSV file to either a folder on your desktop or a shared company drive then if hosted ,upload the file to the U Drive for a quicker import. Uploading Docs to FOS instructions can be found here Uploading Documents to FOS
1. From the FOS Main Menu select → Utilities → Import
2. From the Import Utility, on the Fuel tab, select the Lookup button and choose the CSV file to import. Select the button of the appropriate fuel vendor.
3. Information will start populating on the right hand side of the white box.
4. Once the import is complete, DONE in green will be listed.
5. Now that import was successful, start using the imported fuel prices in the trip planning/setup process. The fuel prices imported can be viewed on the vendor fuel tab or in each airport on the fuel tab.
REMOVING PRICE DATA FROM FOS:
You have three options to remove/purge fuel data from your FOS database.
1. Use the 'Clear Vendor' button from within the import utility - This option allows you to type the fuel vendor ID (i.e. 'RC') in the Vendor field, then click 'Clear Vendor' to remove all pricing data for that selected vendor.
Note: This feature permanently removes/purges the price records from the database (does not mark them as past). Additionally, if there are any prices with an effective date in the future, you will have to change the effective date to extend beyond that date in order to capture/remove those records.
2. Import a blank csv file - This option allows you to clear a vendor without completely purging them from the database. Create a blank csv file, save, and then upload it using the respective vendor import. This will mark current pricing as 'past', and then uploading no information to replace it.
Note: If there are any prices with an effective date in the future, you will have to change the effective date to extend beyond that date in order to capture/remove those records.
3. Completely remove all pricing data from FOS - If you want to simply remove all pricing from FOS for all vendors, you can have your hosting support team rename the APFUEL.BTR as APFUEL.old, then recreate the APFUEL.BTR using the 'Create Files' utility from the login window.
Related Articles
Import: Fuel Tab
The fuel tab allows users to import third party fuel pricing information into FOS to allow for easier price shopping during the trip planning process. Note: Users will need to obtain csv pricing files from the various fuel vendors in order to import ...Fuel Management in FOS - From Import to Report
FOS has several features that can help your flight department manage fuel expenses and communicate value to your owners/management. This article will attempt to walk you through the process and capabilities of importing fuel prices, selecting and ...Fuel Tab
The Fuel tab within an airport records allows users to view the fuel prices at the airport. Fuel prices can be manually entered into the database or there is the ability to import csv files from fuel vendors and the prices will show on this tab. ...Creating a Custom Import Template and Importing
You will need to start with an Excel file with the data you want to import i.e. Aircraft, Personnel, Passengers. 1. Find the Code # for each appropriate column. There are lots of similar fields, so be sure yours is unique. a. You can use Ctrl F to ...Accessing the Import Utility
To access the Import Utility select the Utilities drop down menu from the FOS Main menu and select the Import option: