Manual Export PMS Opera

To enable a smooth setup of PMI and import of history from Opera we ask you to pull the following files and send them over to d2o:

  • Report 1: Res_statistic 1 – this file can be run once (1 time) and should have the date range of 1st of January last year to yesterday.

  • Report 3: Trial Balance – this file needs to be pulled per day for historic days, i.e. we need 365 files per year. We need the files from 1st of January last year up to yesterday. Make sure to name the reports “trial_balance0101xx.txt – i.e the date in the name of the file, so we can separate them (xx = year). Please pull one test file and send to and we will check the format and say ok before you start pulling all of these files. 

Please save all files to your computer and then send them to Please make sure that the files are in the correct format, so you do not have to do the task twice. The Correct file format is “.txt”. Do not export “PDF”, as we cannot import PDF files.

To make it a bit easier you should send Trial Balance for a full month in one mail. Meaning you should send 12 mails for 2018.
Please mark your mail with your property name and make sure you have your contact details in the mail signature.

Scroll down on this page to find out in detail how to pull these reports!

Select the report you are going to export

Report 1:

Reservation Statistics 1 (res_statistics1)

Report 2:

Reservation Forecast, (res_forecast)

Report 3:

Trial Balance (trial_balance)

Report 4:

Reservation History & Forecast (history_forecast)

How Can We Help?

Hands-on exploration!

Hands-on exploration!

Explore first-hand what PMI can do for your business. Contact us now to book a webcast demo of the PMI suite or get your own login so you can play around and familiarize yourself with PMI.

Talk to our Experts!

Talk to our Experts!

Our Benefits Realization Enablement (BRE) team is there to answer your questions and make sure you get the most out of the powerful solutions PMI has to offer. Reach out today and we’ll set a date to create a custom approach with you.

Face to face!

Face to face!

Ready to embark on a journey to soaring productivity and profitability levels with PMI? A d2o representative will meet with you in person to help set you up, train you and your team and make sure you’re off on the right track.

Need more proof?

Need more proof?

Does that all sound way too good to be true? We don’t expect you to take our word for it. That’s why we’ve put together a case study about our client Pandox Hotels and the amazing results they’ve gotten from PMI.