Creating a Custom Import Template and Importing

Creating a Custom Import Template and Importing

Here are items you will need before you can begin this process:
  1. An Excel file, with the data you want to import
  2. The appropriate defines sheet, attached to the bottom of this article, for the import type you're completing

The below steps are the process to load the data. In these screen shots, I am importing fuel for a vendor that does not have a hot button. The same steps can be followed for passengers, personnel, costs.

1. Take the data file you have, create a new row at the top, above the row headers already on the sheet.


2. Look at the column on your data sheet and find the corresponding Code # in the defines file, for each appropriate column. There are lots of similar fields, so be sure yours is unique.  You can use Ctrl F to "find" the code names. 



3. Put the corresponding define number at the top of each column, in row 1. 
NOTE:  Use 999 for Unusable or Blank Columns


4. Go to the Import Utility and clear everything out of the right side window and start typing all of the codes you have added into the data sheet using one line per code. Then choose save. Name the template, save as a .tem file type.
NOTE:  Use 999 for Unusable or Blank Columns



5. Load the template



6. Delete the top 2 rows of the data sheet (template number and column headers) and save to .csv formatting.
  1. If the data sheet has multiple pages, make additional documents instead of tabs/pages. 

7. Lookup and load the saved .csv data file 



8. For custom fuel vendors that do not have a hot button on the left, select the Template-Full File option on the fuel tab, and add the vendor ID. Once the process is done, "DONE" will be shown at the top.

**you can then see the fuel entries into the airport records



** Depending on the import you are completing, the button may be on the User tab . If you are importing Personnel, use the Personnel button to import once steps 1-7 are complete.  



    • 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 ...

    • Introduction to the Import Utility

      The import utility allows users to import various data directly into the system quickly. The most commonly used import functions are for fuel pricing information and the No Fly and Selectee lists. There are a number of other import tools users may ...

    • Importing Aircraft Data from Template File

      The attached files allow users to import limited aircraft data into the FOS system. In order to import the data, it must be in the format outlined in the csv file attached. Once the data is in the format outlined it must be saved to a .csv file. How ...

    • TAG Crew Qual Custom Import

      Tag Crew Qual - The TAG Crew Qual custom Import tool allows users to automatically import completion and next due dates into training items. Next Date Due Fixed - This will mark the fix check box next to the due date imported with the custom 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 ...