How to configure DSTAT to Import from
Galaxy Lightspeed How to configure DSTAT to Import from
Galaxy Lightspeed A special export from Galaxy was implement that outputs Trial Balance, Market Segment and other Statistics to text files in Comma-separated Values (.csv) files. The files are:
DRRyyyymmddppppp.csv - Daily Revenue Report data where yyyymmdd is the date, ppppp is the Galaxy property code
MGRyyyymmddppppp.csv - Manager Statistics Data (e.g. guestroom stats)
MSEyyyymmddppppp.csv - Market Segment Data
DSTAT will import selective data from these reports.
The next step to importing the Galaxy values is to setup the workstation to read the files from the pre-determined location on your network. Follow the instructions in the section titled 'Setup PMS Interface' to assure that the Galaxy data will be read on your workstation. This particular setting is by user by workstation. That way, one workstation can be setup to import the data (e.g. the Night Audit workstation) while other users assume that the data has already been read.
A message is displayed stating "Importing Galaxy Segment data for: ..." letting you know that the data has been found. This data will be read into the 'Gross Amount' column. This column should be locked to user input. The adjustment column should be used to make any necessary adjustments to the imported value.
The sections that read from Galaxy into DSTAT should be configured with Balance Check lines. When the Balance Check is not zero, you should first verify that all the data transferred completely from Galaxy to DSTAT. Print the Daily Revenue Report and compare the values to the DSTAT values.
If Galaxy is in Balance but DSTAT is not, then use the information below to check the Input Configuration in DSTAT. Likely issues are:
When the interface runs, a Log file is generated indicating any data that is used by DSTAT. You can examine the log file using Windows Notepad to see what PMS code may need to be added. The filename is in the form pppp_Galaxy_yyyymmdd.log where pppp is the property code and yyyymmdd is the date. A sample log file looks like that below:
Special codes have to be entered for each row in the Input Configuration for DSTAT to pull the correct values from Galaxy Reports. All of these codes are entered in the column labeled ‘PMS Code’.
If a row in DSTAT is Market Segment Roomnights, the Market Segment
is read from the Market Segment extract file. The code should match
that in the MSEyyyymmdd.csv file. The code is entered into the PMS Code
column with the prefix ‘PMS_RMS.’ For example, for market segment
CORPORATE, the PMS Code is PMS_RMS.CORP
If a row in DSTAT is Market Segment Revenue, the Market Segment is read from the Market Segment extract file. The code should match that in the MSEyyyymmdd.csv file. The code is entered into the PMS Code column with the prefix ‘PMS_REV.’ For example, for market segment CORPORATE, the PMS Code is PMS_REV.CORP
Department Codes
If a row in DSTAT is a Galaxy Subdept value, the Department and Sub-department codes are entered in the PMS Code column sepearated by a period. For example, for Department 1-Rooms, Sub-department 13-Wholesale market segment, enter the code "1.13". Insert a minus sign in front of the code to reverse the sign of the value. For example "-1.13" would insert the negative of the Wholesale revenue. Multiple rows in the DSTAT configuration may use the same code.
In addition to Market Segment values and Sub-department Code Values, DSTAT can pull specific statistical data from Galaxy. These are preceeded by 'PMS.'. This data includes items in the DDRyyyymmdd.csv that do not have Dept/Subdept codes, and items in the MGRyyyymmdd.csv extract file. The title of the statistic is entered with spaces. The first 20 characters are used.
To add an item in DSTAT, select Input Screen Configuration from the Setup Menu or the Toolbar. Click on the line where you want to insert an item and press Ctrl-I. This opens a blank line:
Next, type the PMS code and tab to the Account Number column:
If this is an item that is linked to an account number, typing a valid account number will fill in the rest of the information for the item. If this item is not linked to an account, leave the account number cell blank and fill in the rest of the row manually. Note that the item description defaults to the account name which you can type over to enter a more specific description.
