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).
Does not apply to allotment or ancillary service fares
Step by Step:
1. Fare Export
Enter Kiu Click > Settings > Other Options > Kiu Fares > Fares Export
2. Filters
Enter the filters to search the fares
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 is 1500. If there are more than 1500 fares, the system will display a message asking for filters. Once they are entered try again.
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
3. File Name
The file name structure is as follows:
<CARRIER>_<ORIG><DEST>_<FILE DATE>_<HOUR>_<MINUTES>_<SECONDS>_UTC.CSV
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
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.