Difference between revisions of "Import Runs"
| Line 1: | Line 1: | ||
| − | |||
= Equipment Import = | = Equipment Import = | ||
| Line 119: | Line 118: | ||
* QRFDescription (Text) | * QRFDescription (Text) | ||
| + | = Blinding Operation Import = | ||
| + | |||
| + | To import Blinding 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 (Number) | ||
| + | * 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) | ||
| + | * BlindingLocation (Text) | ||
| + | * BlindingPackage (Text) | ||
| + | * Type (Text) | ||
| + | |||
| + | |||
| + | = Joint Operation Import = | ||
| + | |||
| + | To import Joint 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 (Number) | ||
| + | * 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) | ||
| + | * JointLocation (Text) | ||
| Line 222: | Line 285: | ||
Columns that can be imported additionally: | Columns that can be imported additionally: | ||
* FileName (Text) | * FileName (Text) | ||
| + | |||
| + | = Blinding Location Import = | ||
| + | |||
| + | To import Blinding Locations following columns are required: | ||
| + | * BlindingLocationID (Text) | ||
| + | |||
| + | Columns that can be imported additionally: | ||
| + | * No | ||
| + | |||
| + | = Joint Location Import = | ||
| + | |||
| + | To import joint locations following columns are required: | ||
| + | * Joint_ID (Text) | ||
| + | |||
| + | Columns that can be imported additionally: | ||
| + | * No | ||
| + | * Equipment | ||
| + | * SOP | ||
| + | * Description | ||
| + | * BlindingNumber | ||
| + | * PID | ||
| + | * Size | ||
| + | * Type | ||
| + | * LocationType | ||
| + | * NormalPosition | ||
| + | * OnSite | ||
| + | * ICCNumber | ||
| + | * BlindSapNumber | ||
| + | * BlindQuantity | ||
| + | * GasketSAPNumber | ||
| + | * GasketQuantity | ||
| + | * Stage | ||
| + | * Height | ||
| + | * Scaff | ||
| + | * Insul | ||
| + | * Crane | ||
| + | * Remarks | ||
[[Category:MaTaP|Import Runs]] | [[Category:MaTaP|Import Runs]] | ||
Revision as of 14:17, 17 November 2025
Contents
- 1 Equipment Import
- 2 Workorder Import
- 3 Progress Operation Import
- 4 QRF Operation Import
- 5 Blinding Operation Import
- 6 Joint Operation Import
- 7 Check Operation Import
- 8 Scheduling Import (for Operations)
- 9 User Import
- 10 Company Import
- 11 Material Import
- 12 Preparation Document Import
- 13 Blinding Location Import
- 14 Joint Location Import
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 column is required:
- Workorder (Text)
Columns that can be imported additionally:
- EquipmentID (Text)
- Description (Text)
- WBS (Text)
- Comment (Text)
- Longtext (Text)
- DrainlistDocument (Text)
Following columns are optional, as we recommend to import them directly using the Equipment.import instead:
- EquipmentType (Text)
- EquipmentGroup (Text)
Progress 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 (Number)
- 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)
QRF 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 (Number)
- 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)
- QRFKey (Text)
- QRFDescription (Text)
Blinding Operation Import
To import Blinding 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 (Number)
- 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)
- BlindingLocation (Text)
- BlindingPackage (Text)
- Type (Text)
Joint Operation Import
To import Joint 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 (Number)
- 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)
- JointLocation (Text)
Check 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 (Number)
- 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)
NOTE: To ensure the correct icon is displayed on the client, the “ItemCategory” must have a value of either '0' which is translated to Category Stock or '1' which is translated to Category Skid!
- 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)
Blinding Location Import
To import Blinding Locations following columns are required:
- BlindingLocationID (Text)
Columns that can be imported additionally:
- No
Joint Location Import
To import joint locations following columns are required:
- Joint_ID (Text)
Columns that can be imported additionally:
- No
- Equipment
- SOP
- Description
- BlindingNumber
- PID
- Size
- Type
- LocationType
- NormalPosition
- OnSite
- ICCNumber
- BlindSapNumber
- BlindQuantity
- GasketSAPNumber
- GasketQuantity
- Stage
- Height
- Scaff
- Insul
- Crane
- Remarks
