Export Mappings File

Exports all the mappings associated to the given account in the .csv format and the file is sent to you by email.
The associated files will be uploaded into your ftp account. The files can be accessed by ftp credentials, which is already been shared during the signup process.

File description:

When this API is requested by the client the following files are generated -:

1. Mapping File.
   This file contains mapping information in your account corresponding to each provider. The file name convention is -: accountname_mappings_guid.csv

• Following are the columns included in the template:

  • UnicaId: The name of the provider providing that hotel. This must be from the master Vervotech Mappings master provider names
  • ProviderHotelId: This would be the property's ID, provided by the provider.
  • ProviderFamily: Name of the provider.
  • ModifiedOn: Date of the mapping when updated.
  • ChannelIds: ChannelName.Rate plan type for the provider.
  • ProviderLocationid: DestinationCode for providerHotelId grouped under unicaId.
  • Please refer the mapping file template here,

2) Mapping File(New format). This file contains mapping information in new csv format to each provider. The file name convention is -: accountname_transformed_guid.csv * Following are the columns included in the template:

• UnicaId: Unique Vervotech hotel Id
• Provider Name: This would be the property Id provided by the provider which exist in that vervotech Id group.
• Please refer the mapping file template in new format here,

3. Content File.
   This file contains mapping information in new csv format to each provider. The file name convention is -: accountname_hotels_guid.csv

• Following are the columns included in the template:

  • UnicaId: Unique Id for each group of similar hotels.
  • HotelName: Name of the property.
  • Lat: Latitude of the property.
  • Long: Longitude of the property.
  • AddressLine1 : Property's address line 1.
  • AddressLine2 : Property's address line 2.
  • City : Name of the city where the property is located.
  • State: Name of the state where the property is located.
  • StateCode : Code of the state where the property is located.
  • CountryName: Name of the country where the property is located. Either one of the CountryName and CountryCode is sufficient.
  • CountryCode : ISO country code where the property is located.
  • PostalCode: Zipcode of the property.
  • StarRating: Star ratings of the property.
  • PropertyType: Hotel property type. Eg: - Motel, Resort, Villa, etc.
  • ChainName: Information about the chain name.
  • BrandName: Information about the brand name.
  • CityLocationId: Master city location id associated with this property.
  • MasterCityName: MasterCityLocationName is the cityname associated with city location id.
  • LocationIds: Master location ids associated with this property.
  • Phones: Property's phone numbers.
  • Fax: Property's fax number.
  • Email: Property's email address.
  • Website: Property's official website address.
  • AirportCodes: List of Airports nearby the hotel.
  • TrainStations: List of TrainStations nearby the hotel.
  • ProviderHotelId: Provider hotel id.
  • ProviderFamily: Name of hotel provider.
  • GooglePlusCode: GooglePlusCode is the unique code for the property.
  • Please refer the curated content file template here,