Archibus and Serraview Integration

Story 2: Serraview to Archibus Data Mapping
(Export Serraview Data to Archibus)

The following table summarizes data mapping.

Note:

  • You should display names or titles for imported records, as identifiers will often be numbers.
  • Primary keys are not updated by the feed where a source_record_id is present on the table.
  • Correct data in Serraview when possible; if not, issues will be imported again and reported for review again.
  • Modifications in Archibus to imported data will be overwritten.
  • If you have records in addition to data imported, you must ensure the primary keys will not conflict with Serraview data.
  • If the import fails it will stop; however, an empty import file means all records should be deleted.
Archibus Field Archibus Field Title Field Type Field Max Size Key Formula (in terms of Archibus exported fields) Formula Output Type Formula Output Size
bl table
bl_id Building Code text 36 1 sv_imp_building.id integer 10
address1 sv_ Address 1 text 90 imp_building.street text 150
city_id City Code text 64 sv_imp_building.city text 100
count_em Occupancy Count numeric 8 count of employees for building integer n/a
count_fl Number of Floors integer 3 count sv_imp_floor.id for building integer n/a
ctry_id Country Code text 36 sv_imp_building.country text 100
name Building Name text 64 sv_imp_building.building text 150
complex_id Complex Code text 36 sv_imp_building.region text 200
source_feed_comments Source Feed Comments text 1000 "Serraview Import" text 16
source_record_id Source Record ID text 36 sv_imp_building.id integer 10
source_status Source Status text 16 "ACTIVE" text 6
source_system_id Source System ID text 32 "SERRAVIEW" text 9
source_table Source Table text 32 "Building" text 8
source_date_update date Date Last Updated From Source System date n/a current timestamp n/a
source_time_update Time Last Updated From Source System time n/a current timestamp time n/a
dp table
dp source_record_id Source Record ID text 36 sv_imp_org_unit.id integer 10
dv_id Division Code text 64 1 "SERRAVIEW" text 9
dp dp_id Department Code text 64 2 sv_imp_org_unit.id integer 10
dp count_em Employee Headcount integer 8 count of employees in org unit or child org units integer n/a
dp name Department Name text 64 sv_imp_org_unit.org_unit text 100
div table
dv_id Division Code text 64 1 "SERRAVIEW" text 9
count_em Employee Headcount integer 8 count of employees in an org unit or child org units
dv name Division Name text 64 "SERRAVIEW" text 9
em table
source_record_id Source Record ID text 36 sv_imp_person.id integer 10
em_id Employee Code text 64 1 sv_imp_person.id integer 10
bl_id Building Code text 36 sv_imp_occupancy.building_id integer 10
comments Comments text 500 "Serraview Import" t text 16
curr_bl_id Current Building Code text 36 sv_imp_occupancy.building_id integer 10
curr_fl_id Current Floor Code text 4 sv_imp_occupancy.floor text 20
curr_rm_id Current Room Code text 8 sv_imp_occupancy.workpoint n/a n/a
dp_id Department Code text 64 sv_imp_person.org_unit_id integer integer
dv_id Division Code text 64 "SERRAVIEW" text 9
em_number Employee Number text 50 sv_imp_person.employee_no text 50
fl_id Floor Code text 4 sv_imp_occupancy.floor text 20
name Employee Name text 96 sv_imp_person.first_name + ' ' + sv_imp_person.last_name text 101
name_first Name - First text 64 sv_imp_person.first_name text 50
name_last Name - Last text 64 sv_imp_person.last_name text 50
rm_id Room Code text 8 sv_imp_occupancy.workpoint n/a n/a
rm table
source_record_id Source Record ID text 36 sv_imp_workpoint.id integer 10
bl_id Building Code text 36 1 sv_imp_workpoint.building_id integer 10
fl_id Floor Code text 4 2 sv_imp_workpoint.floor text 20
rm_id Room Code text 8 3 sv_imp_workpoint.workpoint test 50
cap_em Employee Capacity integer 5 sv_imp_workpoint.workpoints integer 10
dp_id Department Code text 64 sv_imp_workpoint.org_unit_id integer 10
dv_id Division Code text 64 "SERRAVIEW" text 9
hotelable Is Hotelable? integer 10 is_reserve_disabled is not set and is_point is set n/a n/a
name text Room Name text 64 sv_imp_workpoint.workpoint text 50
reservable Reservable? integer 3 is_reserve_disabled is not set and is_point is NOT set n/a n/a
rm_cat Room Category text 12 sv_imp_workpoint.space_type text 100
state table
state_id State Code text 4 1 UKN text 3
name State Name text 64 Unknown text 7
city table
state_id State Code text 4 1 UKN text 3
city_id City Code text 64 2 id sv_imp_building.city text 100
name City Name text 64 sv_imp_building.city text 100
ctry table
ctry_id Country Code text 16 sv_imp_building.country text 100
name Country Name text 64 sv_imp_building.country text 100
complex table
source_record_id Source Record ID text 36 sv_imp_region.id integer 10
complex_id Complex Code text 36 1 sv_imp_region.region text 200
name Complex Name text 64 sv_imp_region.region text 200
rmcat table
rm_cat Room Category text 12 1 sv_imp_workpoint.space_type text 100
description Description text 96 sv_imp_workpoint.space_type text 100
afm_dwgs table
dwg_name Drawing Name text 128 1 sv_imp_building.building + '_' + sv_imp_floor.floor text 171
afm_dwgvers table
auto_number Auto-Numbered ID integer 10 1 n/a n/a n/a
dwg_name text Drawing File text 128 sv_imp_building.building + '_' + sv_imp_floor.floor text 171
performed_by Performed By text 64 "SERRAVIEW" text 9
date_occurred Occurred On Date date 8 current timestamp date n/a
time_occurred Occurred On Time time 8 current timestamp time n/a
cad_file_id Serraview CAD File ID integer 10 sv_imp_floor.cad_file_id integer 10

See also

Story 2 Overview: Add Archibus Reservations and Other Features to Serraview