This document serves as a guide for any hotel in Spain that wishes to have the report for police generated automatically daily in the required format to a specific email address.
Hotels can set up the integration by themselves following the points below:
Name: This field may remain blank.
Hotel code: Hotel establishment code provided by the Spanish police.
To: Email address where the export should be sent. There can be multiple emails set up (using either coma or semicolon)
Daily report execution time: Time when should the export be generated and sent. By default it is set up to 9:00AM but you may change it to any time of the day you wish (the logic is that when you fill in 0 hours and 0 minutes it is generated at midnight. If you fill in 10 hours and 45 minutes it is generated at 10:45AM, etc.).
Once you fill everything in, you click the button Create and then you Enable the integration.
The format of the export is .csv.
The report is generated for all the arriving guests for yesterday.
1st line consists of:
1 (Constant value) | Hotel establisment code | Hotel name | Date of the export | Time of the export | Number of reported guests
2nd line and further consist of:
2 (Constant value) | Number of the identity document | Type of the document | Document expiration date | Last name | Second last name | First name | Gender | Birthdate | Nationality | Reservation start
- Only guests with identity document filled in are part of the export.
- Hotels are responsible for the all the fields being filled in accordingly.
- Hotels are also responsible to make sure that the reports are delivered to the police as required.