Monitor Incoming data – Import status
About
Import Status is used to get an overview of your properties´ daily imports from your source systems (PMS, POS, Timekeeping etc). The main features of this module include:
- Detecting data that has not been updated in PMI e.g data missing for the property and various options for handling it depending on what sort of data it is.
- Viewing imported data to PMI. As a user, you can no use our drill-down feature to view what was imported to PMI, and see what accounts are connected to the figure. This way you can check what we received and what the output in PMI was.
- An overview of active interfaces PMI uses to import data to your property.
Intended Users
All users with Administrator, or Controller rights have access to this module.
Instructions
- Breadcrumb menu – Chain is by default the chain you have access to and can not be changed.
- Property will display the properties you have access to, that have the status you have selected in the menu, in this case “not updated in PMI”. Properties with missing data will show if you have access to more than one.
- Refresh Table – You can click this to refresh the table and get the latest update. If you know an interface has been updated refresh the table and the line should disappear, It will now be under the option “Updated in PMI”.
- Actions – Depending on how we collect the data for the interface showing you will have different options. See the actions listed below.
4.1 Rotating arrow – Important: The interface will change its status to “In progress” found in the menu selector. Most data will be collected in between 3-15min, but note that some interfaces can take up to one hour in some cases. OTB is usually the longest import.
Re-trigger the API to collect data. This option is only available if your interface is connected to an API. Clicking this will start the process of collecting the latest data from the API. Note this usually takes up to fifteen minutes before data is collected to PMI, sometimes longer, depending on the provider. If data is still not updated in PMI, contact the provider and explain that data is missing.
4.2 Question mark – Click this to get info on who to contact if data is missing, and steps to upload the data. Question mark will have a blue color if it contains text. If the question mark is empty, please contact support@d2o.com and let them know.
4.3 Snooze button – Clicking this will set the interface to Ignored. Ignored means that you do not need to update PMI with this information today and you do not wish to have it populate the table. Use only if you are sure you are not expecting this data today.
Different statuses
- All – Will list all interfaces and show the status they have in the table
- In Progress – Will show data that has been retriggered by the user and data that is expected to arrive later due to ETA settings.
- Ignored – An ignored interface that the user has deemed as data they do not expect to receive today.
- Not updated – Data that is missing in PMI.
This view lists your interfaces and displays the status. If the file is imported you will find them in the status “updated in PMI” If the file is not imported, it will be listed in the “Not updated in PMI” table.
If you are aware of how to export source files then you should perform a new export of the missing files. If not, read the info in the question mark and follow the steps.
The missing files are also listed on the PMI Desktop.
Viewing imported files
- Choose Updated in PMI under status
Magnifier glass feature (import drill-down)
Imported source data = what we received. Transformed values = What you see in PMI.
Click the magnifier glass on any interface that has been imported and you will get an overview of what PMI has received and what was imported to PMI. This is a great way to validate the figures in PMI (transformed values) against what you expect to see. The drill-down will also highlight any account that is unmapped or has been ignored. Reasons for data not showing in PMI can be:
- New accounts that are not mapped to a specific department in PMI.
- Ignored accounts are accounts that are ignored in the mapping module, meaning the figures will be blocked.
- Another reason could be that the expected figures are not included in the import and a new import is needed.
Tools
Under the Tools Menu, you may enable or disable the different interfaces connected with your property. You must have a property selected in the menu for this setting to appear as this is property specific
- Name of the data receiving interface.
- Is this interface active? e.g should you receive data from this interface to PMI. Deactivating will stop data import through this interface. Only deactive this if you are sure it should not be in use.
- Warning refers to the red message seen on you landing page (home page) Do you wish to see this when data is missing?
- Track status enable the data to be shown in the updated or not updated interface table.
- Delay days – How often do we expect the import to contain data?
- ETA – At what time should this data be updated. If the data is not updated before the ETA it will show as not updated in PMI until data is received.
Watch the video tutorial here:
Troubleshooting tips
Resolving Data Discrepancies Between PMI and Your Source System
The data in PMI are extracted not only from an export file we receive but also through various active APIs that provide real-time data from the source system interface. If you find any discrepancies, you can cross-check the figures using the Import status module in PMI. The module lets you track down imported data at a granular level, which can considerably simplify the process of validating the figures.
If discrepancies or missing data between PMI and the source system persist, the first step should be to inspect the PMI settings and mappings. This knowledge base article provides step-by-step guidance for troubleshooting the common issues:
You can also open a support ticket at your chain's service desk or the source system provider. When doing so, include all relevant information and specify that the issue is related to data discrepancies between the source system interface and PMI.
-
Getting started
-
-
- Arrivals/Departures
- Data elements required from PMS
- Manual Export PMS – Fidelio
- How to do a manual PMS export from Opera
- Manual Export PMS – Picasso
- Manual Export PMS – Protel
- Manual Export PMS – Spirit Web
- PMS – Cenium
- PMS – Citybreak
- PMS – Fidelio
- PMS – Opera
- PMS – Protel
- How to do a manual PMS export from HotSoft
-
Video tutorials
-
- Administration Labor cockpit [14:49]
- Bar and Pub Labor cockpit [12:21]
- Breakfast Labor cockpit [12:05]
- Consolidated view in Benchmarking and Management Perspective [3:20]
- Flash Report Onboarding [6:27]
- Flash report overview [2:25]
- Food cost cockpit [6:21]
- Kitchen Labor cockpit [11:28]
- Labor Cockpit Onboarding [18:16]
- Labor cockpit overview [3:12]
- Live forecast 1/5 navigation [5:05]
- Live Forecast 2/5 Rooms [5:05]
- Live forecast 3/5 meeting & event [5:40]
- Live forecast 4/5 food & beverage [6:11]
- Live forecast 5/5 breakfast [7:19]
- Live forecast onboarding [6:06]
- Live forecast overview [2:58]
- Management perspective overview [3:06]
- P&L Planning 1/10 Purpose and benefits [2:25]
- P&L Planning 10/10 How to approve forecast and budget or target [2:34]
- P&L Planning 2/10 Navigation [4:26]
- P&L Planning 3/10 How to build a total [4:29]
- P&L Planning 4/10 Three ways of inserting figures [4:32]
- P&L Planning 5/10 How to add a sub account [1:42]
- P&L Planning 6/10 How to build a constant [2:42]
- P&L Planning 7/10 Staff module [2:48]
- P&L Planning 8/10 How to add a staff member [1:33]
- P&L Planning 9/10 How to revise and submit a forecast [3:01]
- PMI Planning Staff Module Overview [3:07]
- Repair and Maintenance Labor cockpit [13:01]
- Restaurant Labor cockpit [12:30]
- Schedule 1/8 Navigation [5:12]
- Schedule 2/8 How to create a labor cockpit schedule [4:29]
- Schedule 3/8 How to add a team member [2:07]
- Schedule 4/8 How to create a shift code [3:30]
- Schedule 5/8 How to add shift codes to team members [3:41]
- Schedule 6/8 How to create a rotating schedule [3:20]
- Schedule 7/8 How to replace shift codes for a period [2:00]
- Schedule 8/8 How to create split shifts between departments [2:42]
- Stewarding Labor cockpit [11:38]
- Timesheet Onboarding [4:14]
- Show all articles ( 26 ) Collapse Articles
-
- Articles coming soon
-
- Administration Labor cockpit [14:49]
- Bar and Pub Labor cockpit [12:21]
- Breakfast Labor cockpit [12:05]
- Food cost cockpit [6:21]
- Front office Labor cockpit [12:05]
- Housekeeping Labor cockpit [11:20]
- Kitchen Labor cockpit [11:28]
- Labor Cockpit Onboarding [18:16]
- Labor cockpit overview [3:12]
- Repair and Maintenance Labor cockpit [13:01]
- Restaurant Labor cockpit [12:30]
- Schedule 1/8 Navigation [5:12]
- Schedule 2/8 How to create a labor cockpit schedule [4:29]
- Schedule 3/8 How to add a team member [2:07]
- Schedule 4/8 How to create a shift code [3:30]
- Schedule 5/8 How to add shift codes to team members [3:41]
- Schedule 6/8 How to create a rotating schedule [3:20]
- Schedule 7/8 How to replace shift codes for a period [2:00]
- Schedule 8/8 How to create split shifts between departments [2:42]
- Stewarding Labor cockpit [11:38]
- Timesheet Onboarding [4:14]
- Show all articles ( 6 ) Collapse Articles
-
- How to create a pre-populated new plan for Budget or Forecast [3:02]
- How to edit a plan [3:52]
- P&L Planning 1/10 Purpose and benefits [2:25]
- P&L Planning 10/10 How to approve forecast and budget or target [2:34]
- P&L Planning 2/10 Navigation [4:26]
- P&L Planning 3/10 How to build a total [4:29]
- P&L Planning 4/10 Three ways of inserting figures [4:32]
- P&L Planning 5/10 How to add a sub account [1:42]
- P&L Planning 6/10 How to build a constant [2:42]
- P&L Planning 7/10 Staff module [2:48]
- P&L Planning 8/10 How to add a staff member [1:33]
- P&L Planning 9/10 How to revise and submit a forecast [3:01]
- PMI Planning Staff Module Overview [3:07]
-
- PMI GoGreen - Cockpit overview [2:49]
- How to create a pre-populated new plan for Budget or Forecast [3:02]
- PMI GoGreen - Water [3:04]
- PMI GoGreen - Missed opportunities [2:57]
- PMI GoGreen - Register actual consumption [2:24]
- PMI GoGreen -Towels & linens [3:02]
- PMI GoGreen - How to prevent food waste [3:03]
- PMI GoGreen - How to reduce energy waste [3:08]
- PMI GoGreen - Waste [3:04]
-
-
PMI Release notes
-
- GoGreen manual entry enhancement - October 2024
- CO2 factors enhancement - September 2024
- KPI targets enhancement - July 2024
- NextGen Rooms Live forecast statistics and pickup data enhancement - July 2024
- Date picker enhancement - July 2024
- Update to NextGen Rooms Live forecast - June 2024
- P&L planning accounts enhancement - June 2024
- Weather normalization enhancement May 2024
- Update to NextGen Rooms Live forecast page: Sense check updates, May 2024
- PMI adoption index enhancement May 2024
- PMI adoption index enhancements - April 2024
- Consolidation OTB enhancement - April 2024
- Update to NextGen Rooms live forecast page: Personal view options, Mar 2024
- User administration enhancements March 2024
- GM daily digest enhancement March 2024
- PMI Index calculation updates for 2024
- KPI targets enhancement February 2024
- KPI targets enhancement - January 2024
- Show all articles ( 3 ) Collapse Articles
-
- GoGreen benchmarking
- GoGreen index calculation enhancement
- PMI adoption index: Help videos for measurements
- Activity log enhancement
- Arrivals and departures forecast enhancement
- KPI upload tool enhancement
- GoGreen Food waste cockpit enhancement
- GoGreen Doing cockpit enhancement
- Benchmarking: PMI Index value updates based on time period selected
- GoGreen cockpit: Highlight months missing data on 12 month graph
- KPI targets enhancement - January 2023
- Goal distribution tool enhancement - September 2023
- Planning set up enhancement: Roll forward forecast
- Live forecast enhancement: Editing ARR values
- User administration release note
- New page view of Rooms live forecast - Dec 2023
- Show all articles ( 1 ) Collapse Articles
-
- 15th of March – Ability to reverse Benchmarking calculation
- 15th of March – Possibility to add department type as an additional dimension when using Account ID in the P&L report
- 15th of March – Print a list of all unmapped accounts on chain level
- 15th of March – Printing to excel and PDF
- 16th of March – Introduction to PMI
- 26th of April – Room Live Forecast – Change to pickup fields
- Import status enhancement - September 2022
- 7th of September – Information/calculation rows in PMI schedule
- 9th of August – Export to Google Sheets
- 9th of June – PMI Advanced settings – Period locking
- GM daily digest enhancements
- PMI adoption index: Option to filter scores by group and export scores
- Profit center Live forecast: Automatically switch between OTB and revenue driver
- SMART Forecast enhancement - September 2022
-
-
Onboarding
-
- Onboarding roles – Breakfast
- Onboarding roles – Finance
- Onboarding roles – Food cost
- Onboarding roles – Front Office
- Onboarding roles – Housekeeping
- Onboarding roles – Kitchen
- Onboarding roles – Restaurant and Meeting & Event
- Onboarding roles – Stewarding
- Onboarding roles – Repair and Maintenance
- GM Introduction to PMI
- Onboarding roles – Bar and Pub
- Onboarding roles – Administration
-
-
GM's corner
-
PMI homepage
-
PMI planning
-
- Setting productivity targets and hours
- How to set productivity targets and/or hours in Budget & Forecast module
- How to work with Rooms Budget and forecast
- How to work with non-rooms Budget and forecast
- Use Forecast/Budget hours from Cockpit in P&L Staff module
- What is Room revenue planning?
- Express planner overview
- How the Express planner works
- Express planner: Settings explanation
- Operational targets overview
- How to input a budget in PMI
-
- Accounts overview
- How to populate and edit accounts
- How to approve a forecast or budget in PMI
- How to copy from reference
- How to edit and update using the staffing tool
- How to make a profit forecast
- How to set up a weekly Live forecast
- How to add a comparison year in P&L
- How to modify a P&L report
- Planning Menu – Tools and View Options overview
- Planning staff module overview
- How to build a report
- How to add staff and manage staff cost
- Staffing screen overview
- How to input a budget in PMI
-
-
Cockpit
-
- Labor cockpit overview
- Labor Cockpit Preparations
- Labor cockpit cost driver
- SMART forecast explained
- How does SMART allocate daily hours?
- Using arrivals and departures as a cost driver
- Closing Profit Center or Cockpit
- How to work with labor cost
- Min/Max explanation
- Parent and sub-cockpits explained
- Staffing guide explained
- How to calulate arrivals and departures in the Labor cockpit
- Types of cockpits in PMI explained
- Daily and weekly routines for department heads
- Understanding the importance of including outsourced labor hours in PMI
-
- Labor cockpit schedule
- How to make a schedule
- How to revise a schedule
- PMI Schedule: Information, Calculation rows explanation
- Predefined shift codes
- Printing a schedule
- Revise staff
- Schedule 1/8 Navigation [5:12]
- Schedule 2/8 How to create a labor cockpit schedule [4:29]
- Schedule 3/8 How to add a team member [2:07]
- Schedule 4/8 How to create a shift code [3:30]
- Schedule 5/8 How to add shift codes to team members [3:41]
- Schedule 6/8 How to create a rotating schedule [3:20]
- Schedule 7/8 How to replace shift codes for a period [2:00]
- Schedule 8/8 How to create split shifts between departments [2:42]
- Scheduling
- Split Shifts Between Departments
- The Schedule Tools & View menu
- Show all articles ( 3 ) Collapse Articles
-
-
Live forecast
- Live forecast overview
- How to set up a Live forecast: configuration settings
- Live forecast tools and personal view settings
- PMI prediction explained
- Pickup explanation
- Profit center Live forecast: Automatically switch between OTB and revenue driver
- Revenue driver explained
- Segment OTB
- Submit Live Forecast to Forecast (monthly routine)
- NextGen Rooms Live forecast overview
- Rooms Live forecast: Weekly routine overview
- Rooms live forecast: How to work with auto Live forecast
- NextGen Rooms live forecast: Personal view options
- Rooms Live forecast: Sense check mode explained
-
Data analysis views
-
Administration
-
GoGreen
-
- Comparative data explained
- Data table general explained
- Formula/Calculations explained
- Goal charts and YoY comparison explained
- GoGreen Learning page overview
- How to edit a GoGreen plan
- How to set up a Plan
- Intro to NextGen GoGreen Planning
- Main chart explained
- Plan values explained
- Save your progress explained
- Sense check mode explained
- Unit price explained
- Volume/usage/consumption explained
- How to do a monthly forecast routine in NextGen Planning
- How the GoGreen targets are calculated
- Show all articles ( 1 ) Collapse Articles
- GoGreen Doing Cockpit overview
- GoGreen index overview
- GoGreen benchmarking
- GoGreen index: How are the measurements calculated?
- GoGreen Learning page overview
- Useful links for sustainability and environmental management best practice
- GoGreen targets explanation
- How to make a manual entry in a GoGreen cockpit
- Weather normalization explained
- Weather normalization overview
- GoGreen home page overview
- CO2 factors overview
-
-
FAQ
-
- How can I see the hours that are imported to PMI?
- How do I enter the rates?
- How do I know if I am scheduling according to activity?
- How does PMI summarize the hours?
- How is productivity calculated?
- What are fixed hours?
- What are non-productive and productive hours?
- What are the rates and how are they calculated?
- What is a cost driver?
- What is min/max hours?
- Why do the planned hours in the Timekeeping System (TKS) not match PMI?
- Why is the total number of hours for the month too low/high?
- What is SMART?
-
- How do I estimate my Closing Inventory?
- My food cost % is wrong (too high/low). Why is that?
- My turnover days are set to 32. What does that mean?
- What are my routines in the Food cost cockpit?
- What do I enter in the Purchase column?
- What is opening and closing stock?
- What is the recommended number of turnover days?
- What is turnover days and how is it calculated?
- Where do I change my food cost forecast?
- Why is opening and closing stock important?
-
- Can one employee work in two departments?
- How do I add a shift code?
- How do I copy hours into the unspecified row (Timekeeping system excluded)
- How do I create a rotating schedule?
- How do I make a new schedule?
- How do I navigate the tools in the schedule?
- What are timekeeping system (TKS) excluded hours for?
- How do I add a schedule to my cockpit?
-
- How do I copy to Live forecast?
- How do I submit my Live forecast to forecast?
- How do I reset the pickup for a full month?
- Why do I have a red triangle to the left of the date?
- What is Pickup statistics?
- What are covers?
- What are the seasons in PMI?
- What do the pickups show and why are they sometimes negative?
- What is a revenue driver?
- What is the difference between Forecast and Live forecast?
- Why does on the books in PMI not match what we have in our PMS?
- How do I calculate ARR and ADR?
-
- Can I edit the figures in the Flash report?
- Different view options in the Flash report
- How am I performing compared to my forecast/budget/last year?
- How can I print the report?
- How can I switch between viewing daily and monthly figures?
- How do I check what segments add to the total daily figure?
- How do I edit my covers?
- Why are my room/guest nights wrong?
- What is the Flash Report
- Why is my revenue wrong?
-
- How do I know if the mapping is correct?
- How do I know where accounts should go in PMI?
- How do I map the categories in Timekeeping (TKS)?
- I cannot see my department in Timekeeping System (TKS) mapping. How do I see it?
- There is a position missing in the Timekeeping system mapping. How can I fix this?
- What are Categories in PMI Timekeeping system?
- What is Departments in Timekeeping system (TKS) mapping?
- What is mapping accounts?
- What is mapping – timekeeping system?
-
KPIs
-
General user knowledge
-
Miscellaneous
-
access system
-
d2o team only
-
- Articles coming soon
-
- Articles coming soon
-
- Articles coming soon
-
- Articles coming soon
-