Difference between revisions of "Import Runs"
(Created page with "=== Equipment Import === To import equipments following columns are required: * EquipmentID (Text) '''NOTE:''' “CoordinateLong”, “CoordinateLat” and “CoordinateAlt...") |
(→Material Import) |
||
| (6 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| − | + | {{Attention|This page is under construction.}} | |
| + | = Equipment Import = | ||
| − | To import | + | To import Equipments following columns are required: |
* EquipmentID (Text) | * EquipmentID (Text) | ||
| Line 32: | Line 33: | ||
* EquipmentGroup (Text) | * EquipmentGroup (Text) | ||
| − | + | = Workorder Import = | |
| − | To import | + | To import WorkOrders following columns are required: |
* Workorder (Text) | * Workorder (Text) | ||
| Line 47: | Line 48: | ||
* EquipmentGroup (Text) | * EquipmentGroup (Text) | ||
| − | + | = Operation Import = | |
| − | To import | + | To import Operations following columns are required: |
* OperationID (Text) | * OperationID (Text) | ||
| Line 61: | Line 62: | ||
* NormalDuration (Number) | * NormalDuration (Number) | ||
* NormalDurationUnit (Text) | * NormalDurationUnit (Text) | ||
| − | |||
* WorkUnit (Text) | * WorkUnit (Text) | ||
* Workcenter (Text) | * Workcenter (Text) | ||
| Line 77: | Line 77: | ||
* Suboperation (Text) | * Suboperation (Text) | ||
| − | |||
| − | To import | + | |
| + | = Scheduling Import (for Operations)= | ||
| + | |||
| + | To import scheduling data of Operations the following columns are required: | ||
* OperationID (Text) | * OperationID (Text) | ||
| Line 90: | Line 92: | ||
* 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 113: | Line 115: | ||
* Email (Text) | * Email (Text) | ||
| − | + | = Company Import = | |
To import companies following columns are required: | To import companies following columns are required: | ||
| Line 121: | Line 123: | ||
* Company (Text) | * Company (Text) | ||
| − | + | = Material Import = | |
To import materials following columns are required: | To import materials following columns are required: | ||
| Line 136: | Line 138: | ||
* Unit (Text) | * Unit (Text) | ||
* ReservationStatus (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) | ||
| + | |||
| + | {{Attention|This page is under construction.}} | ||
| + | |||
| + | [[Category:MaTaP|Import Runs]] | ||
Latest revision as of 13:26, 16 July 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)
- 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)
| This page is under construction. |
