Difference between revisions of "Import Runs"
| Line 1: | Line 1: | ||
{{Attention|This page is under construction.}} | {{Attention|This page is under construction.}} | ||
| + | = Equipment Import = | ||
| − | + | To import Equipments following columns are required: | |
| − | + | ||
| − | To import | + | |
* EquipmentID (Text) | * EquipmentID (Text) | ||
| Line 34: | Line 33: | ||
* EquipmentGroup (Text) | * EquipmentGroup (Text) | ||
| − | + | = Workorder Import = | |
| − | To import | + | To import WorkOrders following columns are required: |
* Workorder (Text) | * Workorder (Text) | ||
| Line 49: | Line 48: | ||
* EquipmentGroup (Text) | * EquipmentGroup (Text) | ||
| − | + | = Operation Import = | |
| − | To import | + | To import Operations following columns are required: |
* OperationID (Text) | * OperationID (Text) | ||
| Line 79: | Line 78: | ||
* Suboperation (Text) | * Suboperation (Text) | ||
| − | + | = Scheduling Import (for Operations)= | |
| − | To import | + | To import scheduling data of Operations the following columns are required: |
* OperationID (Text) | * OperationID (Text) | ||
| Line 92: | Line 91: | ||
* lFinish (TT/MM/JJJJ hh:mm) | * lFinish (TT/MM/JJJJ hh:mm) | ||
| − | + | = User Import = | |
To import users following columns are required: | To import users following columns are required: | ||
| Line 115: | Line 114: | ||
* Email (Text) | * Email (Text) | ||
| − | + | = Company Import = | |
To import companies following columns are required: | To import companies following columns are required: | ||
| Line 123: | Line 122: | ||
* Company (Text) | * Company (Text) | ||
| − | + | = Material Import = | |
To import materials following columns are required: | To import materials following columns are required: | ||
| Line 140: | Line 139: | ||
{{Attention|This page is under construction.}} | {{Attention|This page is under construction.}} | ||
| − | |||
| − | |||
Revision as of 12:20, 22 May 2024
 | This page is under construction. |
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)
- 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 (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)
| This page is under construction. |
