Skip to main content

Profile Export

This is an CSV (export file) creates from ISQL (Interactive SQL) that has a list of Guest Profile numbers to send emails to. The first column of the extract must be a guest profile number such as VIPFILE.NUMBER or HISTHD.VIPNUMBER or RESERVE.VIPNUMBER -- all additional columns can exist, but they are ignored. This is useful if you want to write your own extract (from your own tables and sql statement), export a list of Guest Profile Numbers, and send a mass marketing email to all these guests.

First you must decide which guests you want to send an email to and use the Interactive SQL tool to create an export file of Guest Profile numbers. You would do this by selecting Tools / Interactive SQL Report. You can use an SQL statement or the Wizard to create a list of guests, but the first column must be the guest profile number,

Example of all guests who stayed last summer, who paid RACK rate, and stayed more than 3 nights. Notice that the email address does not need to be included, as just the guest profile number is required.

SELECT HISTHD.VIPNUMBER 

 FROM HISTHD 

 WHERE HISTHD.CHECKIN BETWEEN '2013-06-01' AND '2013-09-30' 

   AND RATE_REQ = 'RACK' AND HISTHD.NIGHTS > 3

You can select additional columns if you want to check your results and verify they are the right record that you want. Once the query results are displayed, and you are satisfied with the results, select the Export button and save the results to a CSV file and note the name/location that the file is stored - which is usually on your Desktop.

Next, using Back Office / Letter Editor - create your letter using Guest Profile Letters. You can create any letter you wish with any merge fields.

Finally, go into the Letter Scheduler and Insert a new Scheduled Job.

  1. Select Profile Export (CSV File)

  2. (Choose Schedule Letter) by selecting the letter you have just created in the above step

  3. Enter a return email address in Email Settings so the people who receive this email would know who/where to reply if they wish.

  4. Click on Export File tab and select the file you created in step 1 above.

  5. Click on Preview to verify that your email addresses/record come in.

  6. Press OK to save this Job

  7. Highlight the job you have just created and select Start New Job and run it Interactively

Once the letters have been sent, the Export file can be deleted.