Import Runs
Contents
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 Operations 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)
- 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 (for Operations)
To import scheduling data of Operations the 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)
Preparation Document Import
To import materials following columns are required:
- Workorder (Text)
- FilePath (Text)
Columns that can be imported additionally:
- FileName (Text)