SISfm Test Data

SISfm includes a suite of test data designed to exercise many of its features using a minimum of data.

The supplied configuration in *.config is for this test data, so that SISfm can be explored as soon as installation is complete.

Test Data Content

The test data consists of:

A Facility, bookings and Move Manager database
A CMIS timetable database simulation with one timetable entry.
A CELCAT timetable database simulation with one week of timetable entries for one room.
A telephone PBX database with one entry matching a person for each supported PBX database product.
The supplied Map Compiler and web application settings.
One site named Mount Lester (site ID=02, site code=ML).
Site plan route networks for pedestrians and for vehicles, and floor 1 plan for pedestrians.
One building 15A of two floors with three rooms, one of occupant type and two of sessional type.
One building 16 of one floor with one room.
One car park 1 of two floors with 5 bays.
One department with cost code pppppcccc
One or more persons with staff number 123, etc.
Assets of three types (tables eq, hazmat, sign), two with photographs.
Map Enquiry custom links and item link test web pages.

The test data files are:

`databaseIFM.mdb`	Facility, bookings and Move Manager database
`databaseCELCAT1.mdb`	Room Bookings CELCAT timetabling database subset
`databaseCMIS.mdb`	Room Bookings CMIS timetabling database subset
`databaseMap.mdb`	Map real time database containing View Points table
`databasePBX.mdb`	Telephone PBX database subset
`mapItemLink.aspx`	Map Enquiry item link example (show room occupant email addresses)
`mapLink.aspx`	Map Enquiry custom link test
`assets\0\eq\EQ54322_1.jpg`	Full photograph of equipment asset EQ54322 in the Facility database
`assets\0\eq\EQ54323_1.jpg`	Full photograph of equipment asset EQ54323 in the Facility database
`assets\thumb\blank.gif`	No asset photograph available image
`assets\thumb\doc.gif`	Asset document icon image
`assets\thumb\0\eq\EQ54322_1.jpg`	Thumbnail photograph of equipment asset EQ54322 in the Facility database
`assets\thumb\0\eq\EQ54322_1.txt`	Thumbnail tooltip text of equipment asset EQ54322 in the Facility database
`assets\thumb\0\eq\EQ54323_1.jpg`	Thumbnail photograph of equipment asset EQ54323 in the Facility database
`bimdata`	(BIM sample data available on request)
`dwgdata\ML\20015A01.dwg`	Building 15A floor 1 DWG for compilation
`dwg_afm\20015A01.dxf`	Building 15A floor 1 DXF compilation result
`itemdata\20015A01.xml`	Building 15A floor 1 offline room data
`itemdata\20015A02.xml`	Building 15A floor 2 offline room data
`itemdata\20016001.xml`	Building 16 floor 1 offline room data
`itemdata\CP_20001001.xml`	Car park 1 floor 1 offline room data
`itemdata\CP_20001002.xml`	Car park 1 floor 2 offline room data
`itemdata\MLsite.xml`	Site offline building data
`mapdata\20015A01\20015A01.pdf`	Building 15A floor 1 PDF
`mapdata\20015A01\20015A01.xml`	Building 15A floor 1 layers
`mapdata\20015A01\20015A01_N.svg`	Building 15A floor 1 layer N SVG
`mapdata\20015A02\20015A02.pdf`	Building 15A floor 2 PDF
`mapdata\20015A02\20015A02.xml`	Building 15A floor 2 layers
`mapdata\20015A01\20015A02_N.svg`	Building 15A floor 2 layer N SVG
`mapdata\20016001\20016001.pdf`	Building 16 floor 1 PDF
`mapdata\20016001\20016001.xml`	Building 16 floor 1 layers
`mapdata\20016001\20016001_N.svg`	Building 16 floor 1 layer N SVG
`mapdata\CP_20001001\CP_20001001.pdf`	Car park floor 1 PDF
`mapdata\CP_20001001\CP_20001001.xml`	Car park floor 1 layers
`mapdata\CP_20001001\CP_20001001_N.svg`	Car park floor 1 layer N SVG
`mapdata\CP_20001002\CP_20001002.pdf`	Car park floor 2 PDF
`mapdata\CP_20001002\CP_20001002.xml`	Car park floor 2 layers
`mapdata\CP_20001002\CP_20001002_N.svg`	Car park floor 2 layer N SVG
`mapdata\MLsite\MLsite.pdf`	Site map PDF
`mapdata\MLsite\MLsite.xml`	Site map layers
`mapdata\MLsite\MLsite_N.svg`	Site map layer N SVG
`mapicons\*.gif`	Map icons
`photos\ML\20_1.jpg`	Full photograph of Site ML
`photos\ML\20015A_1.jpg`	Full photograph of Building ML 15A
`photos\ML\20015A01_1.jpg`	Full photograph of Floor 1 of Building ML 15A
`photos\ML\20015A01102_1.jpg`	Full photograph of Room ML 15A.102
`photos\ML\20015A01102_2.txt`	Text document for Room ML 15A.102
`photos\ML\CP_200010_1.jpg`	Full photograph of car park 1
`photos\thumb\blank.gif`	No photograph available image
`photos\thumb\doc.gif`	Document icon image
`photos\thumb\ML\20_1.jpg`	Thumbnail photograph of Site ML
`photos\thumb\ML\20015A_1.jpg`	Thumbnail photograph of Building ML 15A
`photos\thumb\ML\20015A01_1.jpg`	Thumbnail photograph of Floor 1 of Building ML 15A
`photos\thumb\ML\20015A01102_1.jpg`	Thumbnail photograph of Room ML 15A.102
`photos\thumb\ML\20015A01102_1.txt`	Description of photograph of Room ML 15A.102
`photos\thumb\ML\20015A01102_2.txt`	Description of text document for Room ML 15A.102
`photos\thumb\ML\CP_200010_1.jpg`	Thumbnail photograph of car park 1
`reports\test.avw`	Report Maker test Archibus report definition
`reports\test.rpt`	Report Maker test Crystal report definition
`reports\test.text`	Report Maker test Crystal report title and data source
`reports\test.web`	Report Maker test Web report definition
`reports\sub\test2.avw`	Report Maker test report definition 2
`sisdata\DwgTemplate.swd`	Cadcorp SIS template for DWG compilation
`sisdata\test.nol`	Cadcorp SIS library containing mapicon symbol
`sisdata\ML\20015A01.swd`	Cadcorp SIS building 15A floor 1 layers
`sisdata\ML\20015A01-route-Pedestrian.bds`	Cadcorp SIS floor route network for pedestrians
`sisdata\ML\20015A02.swd`	Cadcorp SIS building 15A floor 2 layers
`sisdata\ML\CP_20001001.swd`	Cadcorp SIS car park 1 floor 1 layers
`sisdata\ML\CP_20001002.swd`	Cadcorp SIS car park 1 floor 2 layers
`sisdata\ML\site.jpg`	Site map image
`sisdata\ML\site.swd`	Cadcorp SIS site map layers
`sisdata\ML\site-route-Pedestrian.bds`	Cadcorp SIS site route network for pedestrians
`sisdata\ML\site-route-Vehicle.bds`	Cadcorp SIS site route network for vehicles

For room zones/occupants View Points layers:

Map Compiler setting MapFloorLayerPointParams compiles these without requiring a View Points overlay in their SWDs.
The web setting MapFloorLayerPointView provides the SQL to view their zones/occupants. Values are provided for PersonArchibusMode TRUE (occupants) and FALSE (zones); reverse their order if necessary to make the applicable value the first one.

Test Data Usage

For modules which send email messages, refer to the MailTesting setting.

Microsoft Access can be used to examine and modify the databases. Note that:

the Room Bookings CMIS timetable database databaseCMIS.mdb contains the CMIS tables and fields accessed, with a single test timetable entry for room 102 which can be updated to a date in the near future so it can be seen when making a booking, as follows: update field ccalmaps.mapdate with a date which is a Thursday (otherwise other fields in more than one table will also need updating). Note that MS Access does not support the SQL operator LEFT JOIN required to select all slots from a CMIS database, therefore when using an MS Access database SISfm uses simplified SQL and some slots may not be displayed.
the Room Bookings CELCAT timetable database databaseCELCAT1.mdb contains the CELCAT tables and fields accessed, with illustrative data. However, MS Access does not support the SQL required to access these tables, therefore when using an MS Access database SISfm instead accesses the table sample which contains one week of timetable entries for a room with original_id='O120' which matches rm.celcat_id for room 102 in the facility database (see setting BookCELCATRoomKeyField).

Cadcorp SIS can be used to examine and modify the contents of the SIS Workspace Definition (SWD) files for the site and building floors.

Map Compiler - If the SISfm web application has been installed at its default location, the Map Compiler can be immediately used to recompile the site map (Mount Lester) and the two building floors (20015A01 and 20015A02).

If the SISfm web application has NOT been installed at its default location, first edit this location in the DataFolder* parameters of the configuration file MapCompiler.exe.config in the Map Compiler folder of the SISfm Administrator installation.

Note that the custom field rm.room_view is configured as a Map Enquiry standard theme.

SISfm is launched using a web browser with the address http://localhost/SISfm on the web server itself if it has been installed with the default application name.

Selecting a module displays a Log In link, click this to display the login window (this is displayed directly by Map Enquiry). Login as david who is in the SYSADMIN group, or as tim who is a non-privileged user.

Note that if DbAccessSecurity is TRUE the Move Manager module is restricted to access by the SYSADMIN group.

Space Manager - select the Mount Lester site, then browse and search at will, searches on "ar" and "a o" are simple examples. Click the Space Manager menu item to return to the home page.

Note that if DbAccessSecurity is TRUE the following are restricted to access by the SYSADMIN group:

the site link MountLester.pdf.
the feature field rm.brownout.

Map Enquiry - select the Mount Lester site, then browse and search at will. Click the Map Enquiry title to return to the home page.

Note that if DbAccessSecurity is TRUE the following are restricted to access by the SYSADMIN group:

the map layer Street Name on the site plan.
the function to search.
the function to display the occupants theme.
the function to click a room on a floor plan to view its details.

Note that the colour field rmcat.hpattern_acad exists and is populated for category 1, so if in the supplied Web.config MapLegendColours is AFM and the colour is removed from the MapLegend* setting for "rm_cat, 1" the database colour will be used.

Report Maker - select a test report, modify conditions if desired, generate report.

Note that if DbAccessSecurity is TRUE the report sub\test2 is restricted to access by the SYSADMIN group.

Room Bookings - the Booking List page is initially displayed:

Select the Mount Lester tab.
Click a Room number to book.
Select a week using the calendar.
Drag a time period.
Enter meeting title, OK.
Click My Bookings to review, modify, etc.
Room 201 requires approval for a booking, when one of MailtestingN.html is a request for approval, click its Approve or Decline link to approve or decline the move request.

Note that if DbAccessSecurity is TRUE the following are restricted to access by the SYSADMIN group:

making bookings for room 102.
the function to override opening and maximum hours (e.g for room 201).

Move Manager - the New Move page is initially displayed:

Agree to the disclaimer, press Continue.
Select move date, press Continue.
Select the Business Unit, select the Division, enter the values david, ppppp and cccc, press Continue.
Enter the value 123, press Add, press Continue.
Select site Mount Lester, the building, the room, press Continue. (move to the same room.)
Optionally enter a port number, etc., press Continue.
Optionally enter equipment notes, press Continue.
Optionally enter staff notes, press Continue.
Optionally enter removalist notes, press Continue.
Optionally click items to revise them.
Press Finish.
One of MailtestingN.html is a request to the Business Unit manager for approval, click its Approve or Decline link to approve or decline the move request.
Select the Move List page to review the move, click the View Move Details icon to review move details, modify, delete, etc.
Click Email Config and Email Groups to review and configure email groups and their members.