{//% unless portal.user.is_agent %} Tickets
Welcome
Login Submit a Ticket News {//% endunless %}

Importing Data Files


Importing Data Files 

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

We estimate that this will take 6 minutes to complete.


Detailed Explanation 

A screenshot of a computer

AI-generated content may be incorrect.

Interaction 1 Click the Periods tab.

Start this process from the Periods tab. 

A screenshot of a computer

AI-generated content may be incorrect.

Interaction 1 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.

A screenshot of a computer

AI-generated content may be incorrect.

Interaction 1 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.

A red and white line

AI-generated content may be incorrect.

Interaction 1 Click the Import Files dropdown button.

Use the drop down to select the crew file. 

A screenshot of a computer

AI-generated content may be incorrect.

Interaction 1 Click the AIMS Personnel list item.

You can now choose the file to import with the correct type of data file (AIMS Personnel) designated.

 

A screenshot of a computer

AI-generated content may be incorrect.

Interaction 1 Click the Choose file button.

A screenshot of a computer

AI-generated content may be incorrect.

Interaction 1 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. 

A screenshot of a computer

AI-generated content may be incorrect.

Interaction 1 Click the Open button.

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

A screenshot of a computer

AI-generated content may be incorrect.

Interaction 1 Click the Import button.

A grey and orange line

AI-generated content may be incorrect.

Interaction 1 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, and Error with explanation. 

 

Error messages prevent the file from importing. You must address them prior to making another attempt at importing the file. 

 

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

A screenshot of a computer

AI-generated content may be incorrect.

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

A screenshot of a computer

AI-generated content may be incorrect.

Interaction 1 Click the Confirm button.

A screenshot of a computer

AI-generated content may be incorrect.

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.

A screenshot of a computer

AI-generated content may be incorrect.

Interaction 1 Click the Choose file button.

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

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

Interaction 1 Click the Choose file button.

A screenshot of a computer

AI-generated content may be incorrect.

Interaction 1 Click the V4.txt list item.

A screenshot of a computer

AI-generated content may be incorrect.

Interaction 1 Click the Open button.

A screenshot of a computer

AI-generated content may be incorrect.

Interaction 1 Click the Import button.

ATTENTION 

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

Interaction 2 Click the Confirm button.

A screen shot of a computer

AI-generated content may be incorrect.

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

Interaction 1 Click the Next Page button.

Interaction 1 Click the Import Files dropdown button.

As before, green bars indicate a successful import. 

Now, let's load the pairing file(s). We have two files to load for pairings in this example. You may have more, or only one, based on your configuration. 

A screenshot of a computer

AI-generated content may be incorrect.

Interaction 1 Click the CrewPlan Pairings list item.

A screenshot of a computer

AI-generated content may be incorrect.

Interaction 1 Click the Choose file button.

A screenshot of a computer

AI-generated content may be incorrect.

Interaction 1 Click the 01_FDU_DH4_FOPS_prg.txt list item.

A screenshot of a computer

AI-generated content may be incorrect.

Interaction 1 Click the Open button.

Let's now add another pairing file to import. 

A screenshot of a computer

AI-generated content may be incorrect.

Interaction 1 Click the Add Another File button.

Interaction 1 Click the second Import Files dropdown button.

A screenshot of a computer

AI-generated content may be incorrect.

Interaction 1 Click the CrewPlan Pairings list item.

A screenshot of a computer

AI-generated content may be incorrect.

Interaction 1 Click the Choose file button.

A screenshot of a computer

AI-generated content may be incorrect.

Interaction 1 Click the 01_FDU_E75_FOPS_L48_prg.txt list item.

A screenshot of a computer

AI-generated content may be incorrect.

Interaction 1 Click the Open button.

A screenshot of a computer

AI-generated content may be incorrect.

Interaction 1 Click the Import button.

When you choose to import, the system simultaneously imports all the files selected. 

A screenshot of a computer

AI-generated content may be incorrect.

Interaction 1 Click the Confirm button.

A screenshot of a computer

AI-generated content may be incorrect.

Interaction 1 Click the Done button.


SUCCESS 

Congratulations! You have successfully imported data files.

 

 

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.