STR Global Daily Import Specification
Comma-separated variable import specification for importing daily STR Global data
| Col | Caption | Comment |
|---|---|---|
| 1 | ID | Contact ID. Must match contact attached to STR Global profiles |
| 2 | NUMBER | The number of the profile within the contact |
| 3 | DATA | The type of data on this row. Can be any of: ROOMS, BEDS, OCCUPIED, TOTAL_STAYS or REVENUE |
| 4 | YEAR | Year, e.g. 2010 |
| 5 | MONTH | Month number, e.g. 5 for May |
| 6-37 | 1 to 31 | Day number. One column for each day, depending on the number of days in the month |
Notes
- Captions are case-sensitive so must be in upper case.
Sample
The following sample shows a (partially complete) sample to illustrate the required format. All the STR profiles are in a contact with an ID of 'STR'. The first sample sector typically has 1750 rooms and 2415 bedspaces.
ID,NUMBER,DATA,YEAR,MONTH,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30
STR,1,ROOMS,2010,5,1750,1760,1760,1765,1750,1755,1757,1760,1760,1850,1750,1745,1760,1750,1750,1750,1750,1750,1750,1750,1750,1750,1750,1750,1750,1750,1750,1750,1750,1750,1750
STR,1,OCCUPIED,2010,5,1245,1569,987,1245,1669,987,956,988,1023,1458,1036,1489,1687,984,897,869,985,1025,1445,1169,1025,1036,1068,1145,1208,987,1254,1245,988,912,1234
STR,1,BEDS,2010,5,2415,2415,2415,2415,2415,2415,2415,2415,2465,2475,2515,2425,2435,2415,2415,2415,2415,2415,2415,2415,2415,2415,2415,2415,2415,2415,2415,2415,2415,2415,2415
STR,1,TOTAL_STAYS,2010,5,1745,2069,1487,1745,2169,1487,1456,1488,1523,1958,1536,1989,2187,1484,1397,1369,1485,1525,1945,1669,1525,1536,1568,1645,1708,1487,1754,1745,1488,1412,1734
STR,1,REVENUE,2010,5,31745,42069,21487,31745,52169,71487,21456,31488,41523,41958,51536,41989,42187,51484,41397,41369,41485,31525,41945,41669,41525,51536,61568,51645,51708,51487,61754,41745,31488,41412,51734
STR,2,ROOMS,2010,5,2345,2345,2345,2345,2345,2345,2345,2345,2345,2345,2345,2345,2345,2345,2345,2345,2345,2345,2345,2345,2345,2345,2345,2345,2345,2345,2345,2345,2345,2345,2345,2345
STR,2,OCCUPIED,2010,5,etc, etc
website design by ReZolve. An SSIDM v1.6.003 website