This programme exports the departures of the respective period into a cvs-file.
The option e-mail filter takes the guest’s e-mail filter settings (guest profile) into consideration and does not generate a record for those guests who do not wish to be contacted. If Outlook Integration is serialised, the report can also be forwarded directly by e.mail; e.g. to an external company conducting quality checks with the hotel’s customers.
If required, the Support team can specify the fields to be included in the report. If there are no particular specifications, all of the following fields will be exported:
•object ID
•hotel number
•hotel name
•hotel street
•hotel city
•Lastname
•firstname
•street
•country
•region
•address
•ZIP/postcode
•city
•date of birth
•room number
•arrival date
•departure date
•gender
•titel
•reservation number
•GDS-number
•market segment
•medium
•source
•channel
•NN1
•language
The cvs-file that is generated can be found in the SIHOT path under the directory transfer\staysformarketing.
Figure 1: Calling up the report and direct transmission via e-mail
Figure 2: Locating the cvs-file in the SIHOT directory
Figure 3: Generic report in Excel format
The cvs-file for the feedback system and post-stay mails also include the guest’s language and the post-stay-ID. This ID is a unique link to the hotel’s electronic questionnaire. Once the guest has completed the questionnaire, the ID shows which guest has provided the feedback.
The post-stay-ID (<postStayID>20000744-2159</postStayID>) is also included in the mix-file of the reservation confirmation, which provides the data for the post-stay-mail.
Use registry key [8155] to configure that the cvs-file is sent via SFTP using an external exe.
Figure 4: Registry setting