Quick Start Guide: Data Imports

Quick Start Guide: Data Imports

How to setup a report in FOS and export to Excel

  1. Save RPT file to Data folder on the FOS server

  2. Click on "Rpt Setup"

3. Select "Passenger" report list
4. Click on "+" button at top

5. Select "Print to Window"
6. Enter report name/description and click on "Browse" (this opens up the Data folder)

7. Select the correct report and click "Open" (the browse window closes and puts the filename in the File Name field)
8. Click "OK" and then "Close"

9. Print report with "ALL PASSENGERS"

10. Click on the envelope to export the data

11. Select the export format as "Excel 8.0(XLS)" and click "OK" (save in a location where you can find it). When exporting the fos_paxvisa report select the .csv option. 

12. Open resulting Excel file, fit all columns to data width and confirm that all columns line up with the correct data

Ref: G-G10

    • Related Articles

    • Quick Start Guide: Calendar

      Overview Quick Start Guide: Calendars will assist in getting your calendar set up, cover various settings and provide some helpful shortcuts to help you maximize the use of the calendar. The calendar allows for complete customization by each user. To ...

    • Quick Start Guide: Account Setup

      This article outlines how to update your company information, add personnel, aircraft, customers and vendors to your account. This article details how to: Add company information, personnel and aircraft Enable personnel profile restrictions Setup ...

    • Quick Start Guide: User Basics

      This article contains: How to customize the Aircraft Calendar Accessing and personalizing user profiles Change the username and reset password CUSTOMIZE AIRCRAFT CALENDAR Each user has the ability to customize their own calendar views. There are two ...

    • Quick Start Guide: Crew Records

      This article will detail: How to create training programs and training items How to connect the training items to the training programs Adding crew members to the programs Input training dates and upload training documents for the crew members. ...

    • Quick Start Guide: Email setup

      GoDaddy Log into your GoDaddy account. Click on the plus button to the left of Domains in the Products tab. Click the green "Manage" button for the domain you use to send emails from. 4. Click on the "DNS ZONE FILE" tab.' 5. Click "Add Record" 6. ...