Archibus Data Alignment
- John Mark Asis
- Tatiana Kosmida
In order for us to be able to receive data from Archibus, the Building Manifest and Point of Interest (POI) List need to be formatted as follows:
MazeMap Building Manifest fields: Building_Manifest.csv
Column Name | Description |
FILENAME | Name of the drawing file; Can contain more names separated by a slash (/); .dwg extension must be included |
CAMPUS_ID | Archibus Field - Campus Code |
CAMPUS_NAME | Archibus Field - Campus Name |
BUILDING_ID | Archibus Field - Building Code |
BUILDING_NAME | Archibus Field - Building Name |
FLOOR_ID | Archibus Field - Floor Code |
FLOOR_NAME | Archibus Field - Floor Name |
LAT_COORDINATES | Latitude coordinates of the centroid of the building |
LONG_COORDINATES | Longitude coordinates of the centroid of the building |
MazeMap POI List fields: POIList.csv
Column Name | Description |
CAMPUS_ID | Archibus Field - Campus Code |
BUILDING_ID | Archibus Field - Building Code |
FLOOR_ID | Archibus Field - Floor Code |
ROOM_ID | Archibus Field - Room Code |
TITLE | Archibus Field - Room Name |
TEXT_DISPLAY_ON_MAP | Archibus Field - Room Name |
ROOM_TYPE | Archibus Field - Room Type |
EXTRA_SEARCH_WORD | Add search words; Can contain more words separated by a slash (/) |
LINKABLE_IDENTIFIER | The unique code / key that is used to identify the POI in your FMS system |
EXTERNAL_REFERENCES | Archibus Field - Room Use
Only action when Room Use flags are the following flags: OUTLOOK OUTLOOK & MAZEMP
And use the UPN that is stored in the Archibus Field Room Extension
Each of them should be url-encoded then separated by a slash (/)
For a POI that has the Room Use of OUTLOOK: Room_booking;outlook;john@oslo.edu.au would become Room_booking%3Boutlook%3Bjohn%40oslo.edu.au
For a POI that has the room use of OUTLOOK & MAZEMP: link_insertion;outlook;john@oslo.edu.au/Room_booking;outlook;john@oslo.edu.au would become link_insertion%3Boutlook%3Bjohn%40oslo.edu.au%2FRoom_booking%3Boutlook%3Bjohn%40oslo.edu.au |
INFO_URL | Show more information about a POI containing an absolute url to a web site with additional relevant information about the POI |
INFO_URL_TEXT | Can contain link text that will be displayed instead of the raw url provided in the INFO_URL column |
DESCRIPTION | Archibus Field - Type Description |
PEOPLE_CAPACITY | Archibus Field - Room Capacity |