KIU_Click_FARES_Export/Import

This functionality enables the possibility to update the air fare amounts via a file that is exported and imported from the Kiu Fares Module (Kiu Click).

Duty 8 is required to access the module.

Step by Step:

1. Fare Export

Enter Kiu Click > Settings > Other Options > Kiu Fares > Fares Export

Open

2. Filters

Enter the filters to search the fares

Open

Notes:

• Filters are optional fields, if they are not entered the system will generate a file or display all the existing fares in Kiu Fares

• The maximum fares to be displayed on the screen or included in the exported file cannot exceed 155000 characters. If the search result exceeds the maximum file size and the "SEARCH" button has been selected, the system will display a message asking for filters. If the "EXPORT" button had been selected, a file with no data will be downloaded and its name will contain the text "FILE ERROR MAX SIZE EXCEEDED".

• Each filter has a help icon next to it with a description of the field and its limitations

• By clicking the SEARCH button, the system will display the fares on the screen

• By clicking the EXPORT button and then the CSV option, the system will generate a file including all the fares according to the filters criteria.

• It is not necessary to click SEARCH first and then EXPORT; a file can be exported directly without having to display the data on the screen previously

• The exported file will be saved locally in "DOWNLOAD" folder

• If the maximum allowed is exceeded in the SR: OFFICE field, the “+” symbol will be displayed at the end of the data in order to notify the user that there is more information but it will not be displayed on the screen or included in the exported file.

3. File Name

The file name structure is as follows:

Example: XX_FTERGA_28MAR23_20_13_22_UTC.csv

Notes:

• If it is not filtered by specific origin and/or destination, "ALL" will be displayed in the file name

• If a "file reference", the name structure is as follows:

  • <CARRIER>_<ORIG><DEST>_<FILE REFERENCE>_<FILE DATE>_<HOUR>_<MINUTES>_<SECONDS>_UTC.CSV

  • Example: XX_FTERGA_PROMOFARES_28MAR23_18_02_20_UTC.csv

4. Fare Amount Modification

Once the file has been downloaded, the fare amounts can be modified from:

• Notepad, Excel, Google Sheets

• Only the FARE AMOUNT can be modified

• Important: the file must be saved as CSV

• If any other data (other than the amount) is modified, the system will not process the record and will not apply the change

• The maximum number of decimals is 2. Decimals are separated from the amount by a “period”. Eg 100.00 (When editing in excel or google sheets, the cell format must be "text").

5. File Import

Enter Kiu Click > Settings > Other Options > Kiu Fares > Fares Import

Upload to the file that has the new amounts and click on the "Confirm and Upload" button.

The file validation process may take a few minutes:

Note: The file cannot be imported after 24 hours of export

6. File Processing / Monitoring

In order to apply the changes, go to the "File import process and monitoring" section

Screen detail:

• File status

• Number of records with errors

• Number of records with no changes

• Number of records to be processed

• Number of records processed

By clicking on the first "Actions" icon, a summary of the file validation will be displayed. By clicking the "PROCESS" button the fare modifications will apply.

Important: an email must be entered in order to start processing the file. A notification will be sent to that email when the process has finished.

By clicking on the second "Actions" icon, a detail of each fare will be shown.

By clicking on the "eye icon" at the end of the line, a comparative detail between the exported file and the imported file will be displayed:

7. End of process

After clicking the "PROCESS" button, the system will apply the changes in the fare amounts.

Note: The update process may take a few minutes.

8. History

The user ID who imported the file will appear in the Fare History.