Net compare

The net compare file should be in the format below:

  • Encoding: UTF-8
  • File Name:
  • Extension file: csv
  • Headers:

    • ruleId → rule identifier
    • clientTokens → client Tokens*
    • supplierCodes → supplier code
    • notSupplierCodes → supplier code
    • bookingDateFrom → booking date from Date format
    • bookingDateTo → booking date to Date format
    • startDateFrom → start date from Date format
    • startDateTo → start date to Date format
    • hotelCodes → hotel code
    • nothotelCodes → hotel code
    • chainsCodes → chain code
    • notChainCodes → chain code
    • destinationCodes → destination code
    • notDestinationCodes → destination code
    • percentage → commission value, decimal separator must be point (“.”)
    • amount → amount

    client tokens Identifier provided by the client that is used to filter which business rules can be applied for the sent request.

    • List file fields

      Field Mandatory Excluded fields* Multi-value
      ruleId Yes - No
      clientTokens Yes - Yes
      supplierCodes Yes notSupplierCodes Yes
      notSupplierCodes Yes supplierCodes Yes
      bookingDateFrom No - No
      bookingDateTo No - No
      startDateFrom No - No
      startDateTo No - No
      hotelCodes No nothotelCodes Yes
      nothotelCodes No hotelCodes Yes
      chainsCodes No notChainCodes Yes
      notChainCodes No chainsCodes Yes
      DestinationCodes No notDestinationCodes Yes
      notDestinationCodes No DestinationCodes Yes
      percentage Yes amount No
      amount Yes percentage No

      *Excluded fields Informed field will be ignored

  • Delimiter:  Comma (“,”)

  • Separator for multiples codes in the same row: Semicolon (“;”)

  • Directory: /F[folder code]_[unique code]/HotelX_[unique code]/

Sample File

Name: context_sequential_netCompare.csv

Data:

Simple value field

ruleId,clientTokens,supplierCodes,notSupplierCodes,bookingDateFrom,bookingDateTo,startDateFrom,startDateTo,hotelCodes,notHotelCodes,chainCodes,notChainCodes,destinationCodes,notDestinationCodes,percentage,amount
2795,,SUN2,,2018-06-04,2018-06-17,,2018-12-31,,,,,,,-2,1
2796,,EPL,,2018-06-04,2018-06-17,,2018-12-31,,,,,,,-1,2
2327,,TEC,,,,,2019-04-30,59735,,,,,,-3,3
2429,,CFT,,,,,2019-04-30,,,,,,,2.5,
2193,,DIN,,,,,2018-12-31,16038,,,,,,-2,
1315,,CIM,,,,,2018-12-31,39088,,,,,,-2,
1272,,TEC,,,,,2018-12-31,40912,,,,,,-4,
1332,,DIN,,,,,2018-12-31,40371,,,,,,3.5,
1323,,SMD,,,,,2018-12-31,,,DCHOT,,,,-3,
2213,,GNA,,,,,2018-12-31,,,GHT,,,,-2.5,
2225,,PRS,,,,,2019-04-30,,,MEDIT,,,,-4,
1019,,MED,,,,,2019-04-30,,,MEDP,,,,-3,
1020,,SEN,,,,,2019-04-30,,,PLYHT,,,,-4.25,

Multivalue field

ruleId,clientTokens,supplierCodes,notSupplierCodes,bookingDateFrom,bookingDateTo,startDateFrom,startDateTo,hotelCodes,notHotelCodes,chainCodes,notChainCodes,destinationCodes,notDestinationCodes,percentage,amount
2795,,SUN2;DIN;HOB;JMB,,2018-06-04,2018-06-17,,2018-12-31,,,,,,,-2,1
2796,,EPL,,2018-06-04,2018-06-17,,2018-12-31,,,,,,,-1,2
2327,,TEC,,,,,2019-04-30,59735,,,,,,-3,3
2429,,CFT,,,,,2019-04-30,,,,,,,2.5,
2193,,DIN,,,,,2018-12-31,16038,,,,,,-2,
1315,,CIM,,,,,2018-12-31,39088,,,,,,-2,
1272,,TEC,,,,,2018-12-31,40912,,,,,,-4,
1332,,DIN,,,,,2018-12-31,40371,,,,,,3.5,
1323,,SMD,,,,,2018-12-31,,,DCHOT,,,,-3,
2213,,GNA,,,,,2018-12-31,,,GHT,,,,-2.5,
2225,,PRS,,,,,2019-04-30,,,MEDIT,,,,-4,
1019,,MED,,,,,2019-04-30,,,MEDP,,,,-3,
1020,,SEN,,,,,2019-04-30,,,PLYHT,,,,-4.25,

Date format

Date format yyyy-mm-dd is mandatory


Comments