This page describes the formatting for the .xls used in importing Resources to the FSM.
You can download a sample .xls file here: GC_SchedulingResources_Import.xlsx
Sheet 1
Sheet Name: _Scheduling Resources_
|
Excel File Column |
DB Table AUSER Field ID |
Required? |
Allowed Values |
Data Type |
|---|---|---|---|---|
|
User Type |
AUSEID_TUSE |
Required |
|
VARCHAR2(20) |
|
Operations Center |
AUSEID_AOCE |
Required |
|
VARCHAR2(40) |
|
Surname |
AUSESURNAME |
Required |
|
VARCHAR2(40) |
|
Name |
AUSENAME |
Required |
|
VARCHAR2(40) |
|
Birth Date |
AUSEBIRTHDATE |
|
|
DATE |
|
|
AUSEEMAIL |
|
|
VARCHAR2(80) |
|
Username |
AUSEUSERNAME |
Required |
|
VARCHAR2(40) |
|
Password |
AUSEPWD |
Required |
|
VARCHAR2(40) |
|
Start Date |
AUSESTARTDATE |
|
|
DATE |
|
End Date |
AUSEENDDATE |
|
|
DATE |
|
Serial Number |
AUSEIDENTIFICATIONNUMBER |
Required |
|
VARCHAR2(40) |
|
Secondary identification number |
AUSEIDENTIFICATIONNUMBER2 |
Required |
|
VARCHAR2(40) |
|
Fiscal Code |
AUSETAXCODE |
|
|
VARCHAR2(16) |
|
Language |
AUSELANGUAGE |
|
|
VARCHAR2(10) |
|
Gender |
AUSEGENDER |
|
M/F |
VARCHAR2(1) |
|
Mobile Phone |
AUSEMOBILEPHONE |
|
|
VARCHAR2(20) |
|
Work Center |
AUSEUD_TWCE |
|
|
VARCHAR2(40) |
|
Vehicle |
AUSEID_AVEH |
|
|
VARCHAR2(255) |
|
Warehouse |
AUSEID_AWAR |
|
|
NUMBER(10,0) |
|
Enterprise |
AUSEUD_ACTR |
|
|
VARCHAR2(200) |
|
Enterprise Group |
AUSEID_ACGR |
|
|
VARCHAR2(40) |
|
Movement Type |
AUSEID_AOSP |
|
|
VARCHAR2(40) |
|
Resource Type |
AUSEID_TRES |
|
|
VARCHAR2(40) |
|
Resource Management |
AUSEID_LRMA |
|
Normal/Box/Esternal Box |
VARCHAR2(100 CHAR) |
|
Change Password Required |
In Import: If the file has 'Y' then set the AUTEULTIMAMODIFICAPWD field = null If the file has’N' then set the AUTEULTIMAMODIFICAPWD field = sysdate(now) In Export: If AUTEULTIMAMODIFICAPWD = null then it puts ‘Y' in the file, otherwise if it is set with any date it puts 'N’ |
Required |
Y/N |
|
|
Color |
AUSECOLOR |
|
|
|
Sheet 2
Sheet Name: _Addresses_
|
Excel File Column |
DB Table AADDRESS Field ID |
Required? |
Allowed Values |
Data Type |
|---|---|---|---|---|
|
Description |
AADDDESCRIPTION |
Required |
|
VARCHAR2(40) |
|
Resource Serial Number |
AUSEIDENTIFICATIONNUMBER |
Required |
|
VARCHAR2(40) |
|
Is Departure From Home |
RRESOURCEADDRESS-RRADISDEPARTUREFROMHOME |
|
|
CHAR(1) |
|
Country |
AADDID_LCOU |
Required |
|
VARCHAR2(3) |
|
District |
AADDID_LDIS |
|
|
VARCHAR2(3) |
|
Municipality |
AADDMUNICIPALITY |
Required |
|
VARCHAR2(40) |
|
Postcode |
AADDPOSTCODE |
|
|
VARCHAR2(9) |
|
Municipality Code |
AADDMUNICIPALITYCODE |
|
|
VARCHAR2(6) |
|
Locality |
AADDLOCALITY |
|
|
VARCHAR2(50) |
|
Toponym |
AADDTOPONYM |
|
|
VARCHAR2(50) |
|
Address |
AADDSTREET |
|
|
VARCHAR2(254) |
|
Street number |
AADDSTREETNUMBER |
|
|
NUMBER(10,0) |
|
Latitude |
AADDXCOORD |
|
|
NUMBER(10,8) |
|
Longitude |
AADDYCOORD |
|
|
NUMBER(10,8) |
Sheet 3
Sheet Name: _Departure-Arrival_
|
Excel File Column |
DB Table AUSER Field ID |
Required? |
Allowed Values |
Data Type |
|---|---|---|---|---|
|
Resource Serial Number |
AUSEIDENTICATIONNUMBER |
Required |
|
VARCHAR2(40) |
|
User Departure address Description |
RRADDDESCRIPTION |
|
|
VARCHAR2(40) |
|
User Arrival address Description |
RRADDESCRIPTION |
|
|
VARCHAR2(40) |
|
Operations Center Departure address Description |
ROADDESCRIPTION |
|
|
VARCHAR2(40) |
|
Operations Center Arrival address Description |
ROADDESCRIPTION |
|
|
VARCHAR2(40) |
Related Tasks
Technical Documentation
-
Submitting this form triggers the EVENT NAME HERE Business Event.
-
Resources are also added to the database using the Resource endpoints in the FSM’s Private API Suite. This is for internal use only. External systems can add Resources to the database by using the Resource endpoints in the FSM’s Integration API Suite.