Skip to main content

Currencies

Distribution Master files contain the product you will buy and sell in our Marketplace: hotels, mealplans and other required data to apply your business rules subsequently.

Currencies exchange.

Create and Upload your Currencies Master File​

To get started, create your currencies master file in the correct format and then upload it to your SFTP account. We've provided a template file below ⬇️ to help you with this process. Just click on the file name, add your data, save it in CSV format, and then upload it to the corresponding folder in your SFTP.

sftp.xmltravelgate.com

📁Distribution
     📄Master_CurrenciesExchange.csv

File Format Specification​

  • File Name: Master_CurrenciesExchange.csv
  • Directory: Distribution
  • Delimiter: Hashtag (#)
  • Data:
    • ISO Currency Code (mandatory): 3 chars (e.g. EUR, USD,GBP etc.)
    • Exchange value (mandatory): It indicates the equivalence of this currency with 1 unit of the base currency.
      • Decimal value has to be set using ‘.’ as separator.
    • Agency Code: To create specific currencies. If the agency doesn't specify a currency, it defaults to global currency; otherwise, it uses the specified currencies.
  • Base Currency:
    • The file must be created on a base currency, and all other currencies have to be defined with their exchange with this base currency.
    • TGX Distribution system operates using EUR as the base currency for all the internal operations, so if the file does not uses EUR as the base currency then the TGX Distribution team must be noticed of this point and needs to know which is the base currency.
    • The base currency must be included into the file and will have an exchange value of 1.
    • The exchange value of a currency indicates the equivalence of this currency with 1 unit of the base currency.
  • Note:
    • The first line is not a header line: it contains data directly.
    • The data of the fields is not encapsulated by " or any other character.
    • Each line represents a currency exchange.
    • Any blank line will be skipped.
    • If a field’s data is not mandatory and we don’t want to set it then we just keep it empty: e.g. …##…
    • The file and its data have to be encoded using UTF-8. Otherwise strange characters can be stored.
📹 Learn how to change the format of the csv file in order to edit and save it
TAKE INTO CONSIDERATION
  • If a currency exists then it is updated.
  • If a currency does not exist then it is created.
  • Existing currencies that are not referenced are not removed.
  • If an existing currency has to be removed from system then you have to contact with Travelgate.
  • If specific currencies for an agency have to be removed from system then you have to contact with Travelgate.
  • If there is any problem with a currency’s information then it is omitted (and logged) but the load continues.