Start Mapping By Ftp Folder

Please follow the following steps in sequence

Step 1 - Prepare hotel content files:

Please refer the content hotel static content file template here:

The file extension must be .csv.

All the columns from the content template file must be present in your content file.

Create separate .csv file for each provider.

Make sure the column names in your content file are matching exactly with the column names in Vervotech Mappings content template file.

The column names are case sensitive.

Make sure there are no invalid/junk values like for any of the content fields. For example, "NULL", "null", " " etc.

Following are the columns included in the template:

SupplierName: Required. The name of the provider providing that hotel. This must be from the master Vervotech Mappings master provider names: GetAllProviderNames

SupplierHotelId: Required. This would be the property's ID, provided to you by the provider.

HotelName: Required. Name of the property.

Line1: Required. Property's address line 1.

Line2: Property's address line 2.

CityName: Required. Name of the city where the property is located.

CityCode: Optional. Code for the city/location where the property is located.

StateName: Name of the state where the property is located.

StateCode: Code of the state where the property is located.

ZipCode: Required. Zip code of the property.

CountryName: Either one of CountryName or CountryCode is required. Name of the country where the property is located. Either one of the CountryName and CountryCode is sufficient.

CountryCode: Either one of CountryName or CountryCode is required. ISO country code where the property is located.

StarRating: Required. Star ratings of the property.

Lat: Required. Latitude of the property.

Long: Required. Longitude of the property

ChainCode: Optional. Information about the chain code.

Phones: Property's phone numbers.

Fax: Property's fax number.

Email: Property's email address.

Website: Property's official website address.

PropertyType: Hotel property type. E.g.: - Motel, Resort, Villa, etc.

Step 2 - Upload the hotel content files to SFTP site:

Step 2.1: Connect to the SFTP server.

Connect to the FTP site using any FTP client. You can get the FTP credentials from Vervotech client portal under "Load Provider Content".

Step 2.2: Create folder path for files.

Create new folders at the root of the FTP site. You can tools like FileZilla or any other SFTP client. Alternatively, you can use any programming client.

The directory path of the folder should be in following format:

[FTP Root]/[DATE]/[ProviderName]/[ProviderKey]

FTP Folder path essentially has 3 components:

Date: The [DATE] format should be DDMMYYYY.

ProviderName: The name of the provider. This must be one of the provider name from the master Vervotech Mappings master provider names: GetAllProviderNames

If the provider name is not present in the master provider list, please contact Vervotech Mappings support team at Vervotech Support

ProviderKey: This will be provided by the Vervotech Mappings team for each provider. You can get the FTP credentials from Vervotech client portal under "Manage Your Providers" tab as shown below.

Step 2.3: Upload the file to SFTP server

You can upload multiple provider files in single SFTP folder. The provider file name can be in any format. However, we recommend placing only one file per folder.

Examples:

18122022/HotelBeds/accountId__accountId__HotelBeds/HotelBedsProperties.csv
18122022/Priceline/accountId__accountId__Priceline/PricelineProperties.csv
18122022/EAN/accountId__accountId__EAN/EANProperties.csv

Step 3 - Trigger the hotel mapping using Client Portal:

Go to "Load Provider Content" in the navigation pane.

Enter the full FTP path URL in the "SFTP Folder Path" text box.

Click on the "Start Mapping" button. You should see multiple unique identifier/number (RunId) on the screen for your mapping request. There will be unique RunId generated for each file from your upload directory.

The processing of the file must be completed before uploading any new files.

Step 4 - Review mapping progress for your files:

You can check the status of any of the mapping against any RunId which you have triggered. Go to "Providers Content Processing" and see the progress of any RunId.

Step 5 - Trigger the hotel mapping using APIs:

The entire process of uploading the files can be automated programtically using SFTP client.

Once the files are uploaded, integrate with https://hotelmapping.vervotech.com/api/3.0/mappings/StartMappingByFtpFolder.

The input to this web service is mainly the FTP upload directory path.

Trigger the hotel mapping request by invoking this web service.

curl --location --request GET 'https://hotelmapping.vervotech.com/api/3.0/mappings/StartMappingByFtpFolder?templateType=Vervotech_Template&folderName=18122019/HotelBeds/johndoe__johndoe__HotelBeds' \ --header 'apikey: 056ec4c3-be6b-4c36-a4cc-a403ce9592a1' \ --header 'accountId: DemoAccount'

{ "Status": true, "Message": "Success", "RunId": "rc1234-3232-5657", "MappingStats": [ { "RunId": "f676e8a6-00b4-4231-8a1a-5a19d290837d", "MissingCountryCodes": 0, "MissingGeoCodes": 0, "MissingHotelChains": 0, "MissingPhones": 0, "MissingStarRatings": 0, "MissingZipCodes": 0, "MissingCity": 0, "MissingFax": 0, "MissingName": 0, "MissingState": 0, "MissingAddress": 0, "PublishCount": 0, "TotalProviderCount": 0, "StorageFilePath": "11092022/MGHoliday/via__via__MGHoliday/MGHoliday.csv", "ValidationMessage": "File format is Valid. Hotel count 269076.", "Status": "Completed", "StartDate": "2022-09-12T10:03:57.134Z", "EndDate": "2022-09-12T11:30:07.219Z", "WorkFlowType": "FTPDownloader", "DownloadStats": {} } ], "StatusCode": 2000 }

Start Mapping By Ftp Folder

Step 1 - Prepare hotel content files:

Step 2 - Upload the hotel content files to SFTP site:

Step 2.1: Connect to the SFTP server.

Step 2.2: Create folder path for files.

Step 2.3: Upload the file to SFTP server

Step 3 - Trigger the hotel mapping using Client Portal:

Step 4 - Review mapping progress for your files:

Step 5 - Trigger the hotel mapping using APIs:

Request

Responses

Start Mapping By Ftp Folder

Step 1 - Prepare hotel content files:#

Step 2 - Upload the hotel content files to SFTP site:#

Step 2.1: Connect to the SFTP server.#

Step 2.2: Create folder path for files.#

Step 2.3: Upload the file to SFTP server#

Step 3 - Trigger the hotel mapping using Client Portal:#

Step 4 - Review mapping progress for your files:#

Step 5 - Trigger the hotel mapping using APIs:#

Request

Responses

Step 1 - Prepare hotel content files:

Step 2 - Upload the hotel content files to SFTP site:

Step 2.1: Connect to the SFTP server.

Step 2.2: Create folder path for files.

Step 2.3: Upload the file to SFTP server

Step 3 - Trigger the hotel mapping using Client Portal:

Step 4 - Review mapping progress for your files:

Step 5 - Trigger the hotel mapping using APIs: