Importing data files

Modified on: Thu, 7 Oct, 2021 at 2:43 PM

Link to eLearning

1 Introduction

In this topic, we review how to load data files in sequence.

We estimate that this will take 6 minutes to complete.

2 Detailed Explanation

Click the Periods tab.

Start this process from the Periods tab. If you are not already there, switch to that tab now.

Click the SEP_2021 row.

Remember to ensure that the active bid period is set up. Prior to loading, ensure that the name and dates are correct, and the period is prepared (a check mark displays in the Prepared column). With the period "prepared", the configuration from the previous period is copied over.

Click the Data button.

With the desired bid period selected, clicking the Data button allows us to load the files.

ATTENTION

The Crew data file (personnel file) must be loaded first, as the other data files reference the information in this file.

Click the Import Files dropdown button.

Use the drop down to select the crew file.

Click the AIMS Personnel list item.

With the correct type of data file (AIMS Personnel) designated, you can now choose the file to import.

Click the Choose file button.

Click the SEP21 Crew report 8.12.21.csv list item.

The name of the file and its location prior to import depends upon the conventions in place at your particular operation. The file name shown here is an example only.

Click the Open button.

The selected file name displays and the file is ready for import.

Click the Import button.

Click the Section Scroll Down vertical scroll bar.

The status of the import displays in this lower pane. The contents include three possibilities for the various import items:

Success
Success with warnings given
Error with explanation

Error messages prevent the file from importing. They must be addressed prior to making another attempt at importing the file.

Review all warnings to ensure any issues do not affect the crew data.

For this example, let's assume the warning messages can be ignored, and we can proceed.

Click the Confirm button.

These green bars indicate a successful data load operation. The numbers indicate how many crew members are in each of the listed categories. You can use this information to verify that the number of crew members matches the entries in the crew data file.

Click the Choose file button.

Once the crew data file is loaded, you can load the other data file(s). Typically, you load the absences and history file next. Depending upon the customer, these files may be separate in your system, or grouped together in a single file. In this example, they are loaded as one file.

The AIMS Absences & History option is already selected, so we can proceed with file selection.

Click the Choose file button.

Click the V4.txt list item.

Click the Open button.

Click the Import button.

ATTENTION

Remember to review any warning messages. If there are no issues, you can proceed.

Click the Confirm button.

To visually confirm the file successfully imported, find the category by stepping through the pages available in the Pairing Data Status table.

Click the Next Page button.

Click the Import Files dropdown button.

As before, green bars indicate a successful import.

Now, let's load the pairing file(s). In this example, we have two files to load for pairings. Based on your configuration, you may have more, or only have one.