Introduction

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.


Settings

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.


Format

The format of the export is .csv.


Generated data

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


Notes

  • 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.