3,114 bytes added,
31 March === Equipment Import ===
To import equipments following columns are required:
* EquipmentID (Text)
'''NOTE:''' “CoordinateLong”, “CoordinateLat” and “CoordinateAltitude” must be formatted as Number!
Columns that can be imported additionally:
* PIDNumber (Text)
* Medium (Text)
* System (Text)
* SystemDescription (Text)
* PlanNumber (Text)
* GridCode (Text)
* Location (Text)
* LocationStage (Text)
* LocationHeight (Text)
* Plant (Text)
* Tag_Nr (Text)
* EquipmentDescription (Text)
* Maint_Plant (Text)
* AssistingSystem1 (Text)
* AssistingSystem2 (Text)
* Subsystem (Text)
* SubsystemDescription (Text)
* Zone (Text)
* CoordinateLong (Number)
* CoordinateLat (Number)
* CoordinateAltitude (Number)
* PrioritySAP (Text)
* EquipmentType (Text)
* EquipmentGroup (Text)
=== Workorder Import ===
To import workorders following columns are required:
* Workorder (Text)
Columns that can be imported additionally:
* EquipmentID (Text)
* Description (Text)
* WBS (Text)
* Comment (Text)
* Longtext (Text)
* DrainlistDocument (Text)
* EquipmentType (Text)
* EquipmentGroup (Text)
=== Operation Import ===
To import operation following columns are required:
* OperationID (Text)
'''NOTE:''' “Number” and “NormalDuration” must be formatted as Number and all dates must be formatted as TT/MM/JJJJ hh:mm!
Columns that can be imported additionally:
* Workorder (Text)
* Operation (Text)
* ShortText (Text)
* Number (Number)
* NormalDuration (Number)
* NormalDurationUnit (Text)
* Work (Text)
* WorkUnit (Text)
* Workcenter (Text)
* ActivityCode (Text)
* eStart (TT/MM/JJJJ hh:mm)
* eFinish (TT/MM/JJJJ hh:mm)
* lStart (TT/MM/JJJJ hh:mm)
* lFinish (TT/MM/JJJJ hh:mm)
* Company (Text)
* CompanyCode (Text)
* LongText (Text)
* Comment (Text)
* PermitCode (Text)
* Planner (Text)
* Suboperation (Text)
=== Scheduling Import ===
To import schedulings following columns are required:
* OperationID (Text)
'''NOTE:''' All dates must be formatted as TT/MM/JJJJ hh:mm!
Columns that can be imported additionally:
* eStart (TT/MM/JJJJ hh:mm)
* eFinish (TT/MM/JJJJ hh:mm)
* lStart (TT/MM/JJJJ hh:mm)
* lFinish (TT/MM/JJJJ hh:mm)
=== User Import ===
To import users following columns are required:
* DesktopLogin (Text)
Columns that can be imported additionally:
* Name (Text)
* NFC (Text)
* MobileLogin (Text)
* Password (Text)
* CompanyCode (Text)
* ReportingUserrights (Text)
* PunchpointUserrights (Text)
* ScopechangeUserrights (Text)
* SuperuserUserrights (Text)
* Comment (Text)
* Position (Text)
* Availability (Text)
* Adress (Text)
* Skype (Text)
* Telephone (Text)
* Email (Text)
=== Company Import ===
To import companies following columns are required:
* CompanyCode (Text)
Columns that can be imported additionally:
* Company (Text)
=== Material Import ===
To import materials following columns are required:
* OperationId (Text)
* MaterialNr (Text)
'''NOTE:''' “Quantity” must be formatted as Number!
Columns that can be imported additionally:
* MaterialDescr (Text)
* BOMItemNr (Text)
* ItemCategory (Text)
* Quantity (Number)
* Unit (Text)
* ReservationStatus (Text)