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).
...
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:
...
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").
...
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.
...