Toggle navigation

Masterdatabase

<
  • Dashboard
  • Airports
  • Cities
  • Hotels
    • Hotel chains
    • Hotel descriptions
    • Hotel consolidated
    • Hotel crossreferences
  • Services
    • PluginController
    • HotelConsolidator
  • Reports

Help - Hotel consolidated

  1. Home
  2. Help
  3. Hotel consolidated

Matching

A. No baseprovider
  • Nominate new basehotel and get consolidatedId
  • Retrieve all crossreferences associated with selected consolidated hotels
    • Update all HotelConsolidatedId values from Crossreferences table with consolidatedId from basehotel
      • Update MatchingAlgorithm to 'manual-matched' for all Crossreferences which do not belong to consolidatedHotel
  • Update all ReplacedWithHotel values from HotelConsolidated table for selected non-basehotel with consolidatedId from basehotel
    • Update all replacedwith consolidated hotels, which will otherwise hold a reference to another replacedwith consolidatedhotel

B. Has 1 baseprovider
  • Get consolidatedId from baseprovider
  • Retrieve all crossreferences associated with selected consolidated hotels
    • Update all HotelConsolidatedId values from Crossreferences with consolidatedId from baseprovider
      • Update MatchingAlgorithm to 'manual-matched' for all Crossreferences which do not belong to consolidatedHotel
  • Update all ReplacedWithHotel values from selected non-baseprovider hotels with consolidatedId from baseprovider
    • Update all replacedwith consolidated hotels, which will otherwise hold a reference to another replacedwith consolidatedhotel

C. Has > 1 baseprovider
  • Present dialog to select baseprovider
  • same steps as B.

Column filtering

To apply column filtering, enter values in the input fields above the row, then press enter to apply the filter

Columns which allow multiple values (seperated by comma's)

  • Filter Id
  • HotelProvider
  • CrossRefCount

Shortcuts

Highlight match bundles

alt+1 - Bundle #1
alt+2 - Bundle #2
alt+3 - Bundle #3
alt+4 - Bundle #4
alt+5 - Bundle #5
alt+6 - Bundle #6

Actions

ctrl+m - Match dialog
ctrl+enter - Submit match dialog
ctrl+x - Show crossreferences
ctrl+a - Select all
ctrl+/ - Open selection in fast filter

Paging

ctrl+left - Previous page
ctrl+right - Next page

Fast filter - Load all data into the client

When you click on the 'Fast filter' button. The current filter criteria will be applied and all the hoteldata will be loaded at once. Don't this this if your filtered records count is higher than 4000 records This mode has a lot of extra power compared to the normal paging.
For example: