Jump to content

<p>Importing and exporting schedules</p>


Nabeel
  • Importing Schedules

    You can import all your schedules from CSV. Goto “Operations” and then “Import Schedules”. There is a link to download the CSV template, or you can download it from below (the attachment). There's also an option to delete ALL previous schedules, and import fresh from the CSV file.

    Note: If you're using Microsoft Excel, make sure the "day of week" column is set to a string column, otherwise, it will truncate the 0 from the front, leaving out Sundays as a schedule date.

    Exporting Schedules

    There is also an option to export your schedules. They will be in the same CSV format, so they can be modified, and re-imported.

    Import/Export Rules:

    1. The airline code must be added, or import will fail
    2. You can leave out the header, but if it is there, check off the box
    3. All of the columns can be there, but only the route, leg, distance, and flighttime can be blank
    4. Routes which already exist (based on the code and flight number) will be updated
    5. Aircraft must be added by registration number.
    6. Flight Type can be "P" (Passenger), "C" (Cargo) or "H" (Charter). Enter it without quotes
    7. Days of week - last column - enter 0-6 for Sunday (0) to Saturday (6): ie: Monday, Wed, Fri, Sat flights will be: 1356 as the value
    8. Enabled column - 1 for enabled, 0 for disabled. Blank defaults to enabled

    For best results - add all your airports before you import. Otherwise, it will go and grab the airport, but this can potentially cause a problem by either PHP running past it's maximum execution time, or completely failing because your host blocks URL fopen commands. The route, leg, distance, and flight time columns can be blank. If you do not use registration numbers, view this post on how to get around it.

    template.csv

Importing and exporting schedules


User Feedback

Recommended Comments

There are no comments to display.



Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Add a comment...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...