How to integrate with OPERA using sftp – Whistle (Legacy)

Whistle can integrate with your OPERA account via a recurring emailed report to facilitate automated messages to your guests.

Setup

Go to the Company -> Integrations section inside Whistle
Click the enable button next to the SFTP banner - this will notify us to send you SFTP credentials
Create your reservation report using OPERA configuration module
1. In Opera's configuration module; select Setup in the toolbar
2. Hover over Report Setup
3. Click Reports
4. Click New
5. Fill out the following report information
  1. Report Name: Whistle Integration
  2. Check ✓ Simple Report Box
  3. Select the report group as Reservations
6. Click Customize
7. In the General tab,
  1. Check ✓ Reservations
  2. Check ✓ Profiles
8. Click Save
9. In the Columns tab; use "Like" search to find the following available columns to add to your report by selecting > at the top of the window
  *make sure available columns are marked as "RESERVATIONS" in the bottom left of the window
  1. Reservation Name ID
  2. First Name
  3. Last Name
  4. Email
  5. Phone Number
  6. Arrival Date
  7. Departure Date
  8. Room No.
  9. Reservation Status
  10. Rate Code
  11. Member Type
  12. VIP Code
  13. Salutation
  14. Country
  15. Room Type
  16. Rate Amount
10. In the Filters tab; before you add the following available columns to your report double click the column name (Arrival Date and Update Date) and select "Between" and check ✓ BOTH "Parameter" boxes and click save
  1. Arrival Date
  2. Update Date
11. Before you click Ok while selected on Update Date click the OR button
12. Search 'Room Type = PM' while selected on 'Room Type' click the NOT button
13. Click Ok
14. Click 'Ok'
15. Close out of report setup
Setup report scheduler in OPERA PMS module
1. In Opera's PMS module; select Miscellaneous
2. Click Report Scheduler
3. Click New
4. Search for Whistle Integration report
5. Change the file format to Delimited Data
6. Select the delimiter as a comma (,)
7. Set start date for today's date
8. Set start time for 10 minutes from current time
9. Set repeat to Minutes and add the value 10 after Every
10. Click Ok
11. Report parameters will appear
12. Select File
13. Close out of reports
14. Schedule window will appear
15. Select Whistle Integration
16. While on Distribution List, click second 'New' button on the right
17. Select the value as SFTP
18. Go to Configuration > Property > Delivery Method > General > SFTP Tab > New
19. Click Ok
20. Configuration;
  1. Host/URL: sftp.trywhistle.com
  2. User Id: Whistle will provide
  3. Password: Whistle will provide
  4. Target Directory: Whistle will provide
21. Click Ok
22. While still in schedule window, select Parameters
23. Highlight From Arrival Date
24. Click Set Date on the right
25. Select +/-
26. Select 1 (one)
27. Click Ok
28. While still in schedule window, select Parameters
29. Highlight To Arrival Date
30. Click Set Date on the right
31. Select +/- (click it twice so it shows +)
32. Select 5 (five)
33. Click Ok
34. While still in schedule window, select Parameters
35. Highlight From Update Date
36. Click Set Date on the right
37. Select +/-
38. Select 1 (one)
39. Click Ok
40. While still in schedule window, select Parameters
41. Highlight To Update Date
42. Click Set Date on the right
43. Select +/- (click it twice so it shows +)
44. Select 5 (five)
45. Click Ok
46. Click Run Now
47. Email support@trywhistle.com to make sure report has been received with correct reservation data from OPERA
Whistle support will complete the integration connection
1. Once enabled, a timestamp will be displayed next to SFTP banner of when we last received data from Opera
2. Contact support@trywhistle.com with any issues