How to Connect to Opera Reports for Opera v5 PMS

Please follow the instructions to complete the reports setup for connection to Opera on Prem v5.

In order to start the process, please inquire with Duve Support. 

To start the process, ensure that you have all the information from Duve Support to start and all the permissions to access the reports. 

1. Download the file sent to you by Duve Support
2. Save the email address sent to you by Duve Support

Go to Opera onPrem instance and go to PMS.

1. Go to the Configuration menu
2. Create the report for reservation updates:
   1. Name = <HOTELCODE> - Duve Reservation Updates Report
   2. ✅Opera Simple report
   3. File name = reservationupdates
   4. Report Group = Reservation(s)-> Click “Customize”
       
3. On the bottom left of the screen, click “Import” and select the reservationsupdates.osr configuration file that was uploaded earlier.
    
4. After the selecting the report file and agreeing to import you might receive the following prompt:Please select “No” for every window, if not available - then “Yes”.
5. Save the changes - Click OK (bottom right) -> Click OK
    
6. Create another report that will be used for Full Sync. In the same window with reports, select “New” and fill in the following details:
   1. Name = <HOTELCODE> - Duve Reservation Full Sync Report
   2. ✅Opera Simple report
   3. File name = reservationfullsync
   4. Report Group = Reservation(s)-> Click “Customize”
7. On the bottom left of the screen, click “Import” and select the reservationsupdates.osr configuration file that was uploaded earlier. Repeat the steps with “No”/”Yes” if prompted.
    
8. Now you need to edit the filters of the report:
   1. Click on Filters
       
   2. In the window on the right side of the screen, you will see current filter - 2 lines based on the Update Date
   3. Please select the first line and click on the top arrow in the middle of the screen (<), it should remove the filter.
   4. Repeat for the second line
   5. In the list on the left side of the screen, please find a filter called “Arrival Date” and use an arrow (>)to move it to the right side
   6. On the bottom, you will be able to customize how the filter works:
      1. In the first column, select “Between”
      2. In the second column, select “Parameter”
      3. Then, the third column will appear, please select “Parameter”
   7. Select “Save” -> the Arrival date filter will appear on the right list
9. Select “OK” -> Select “OK”
10. Select “Close”
11. Select “Exit” to close the Opera Configuration menu
     
12. Now, you can schedule the report. Go out of Opera Configuration and go in the Opera PMS, please navigate to Miscellaneous → Reports Scheduler → Select “New”
13. Search for the report created in Step 1, Duve Reservation Updates;
    1. Select the relevant report from the list
    2. Check the ‘Print to File’ option (if not available - ‘Fax - Email”)
    3. Change the ‘File Format’ to “DELIMITED DATA”
    4. Set the ‘Delimiter’ to “|” (this is a Pipe or Bar, it can be selected from the drop down too)
    5. Select “OK”
        
14. Define the schedule frequency of the report: recommended 1 hour (could also be 30 mins)
15. If prompted - add a recipient email in the field “Email TO” - open the Opera Reports connection in their Duve account, turn on the toggle and copy the email address from the connection into the Opera Account

Paste it here without the “host.”:

16. Select “OK” -> Select “File”
17. Make sure that the email copied without the “host.”:
18. move on to the reservation full sync file.
     
    1. Go back to the main Opera PMS application, Navigate to Miscellaneous → Reports
    2. Find the Flush report in the list (use keyword HOTELCODE) and select it
    3. On the bottom, please choose “Print to File”,  (if not available, don’t select anything)
    4. Format as “DELIMITED DATA”, and Delimiter as “|” -> Select “OK”
    5. On the next screen, you will be prompted to select the timeframe for the arrival date filter - select 2 weeks in the past to 1 year in the future

Select File