| (5 intermediate revisions by one other user not shown) | |||
| Line 1: | Line 1: | ||
| + | = Naming Convention = | ||
| + | |||
| + | '''General file naming convention:''' | ||
| + | All import Excel files must follow the pattern: | ||
| + | |||
| + | xxxx.<import-type>.xlsx | ||
| + | |||
| + | Where xxxx can be any project- or customer-specific identifier. | ||
| + | |||
| + | Supported import types: | ||
| + | |||
| + | * Equipment Import | ||
| + | xxxx.equipment.xlsx | ||
| + | |||
| + | * Workorder Import | ||
| + | xxxx.workorder.xlsx | ||
| + | |||
| + | * Progress Operation Import | ||
| + | xxxx.progress-op.xlsx | ||
| + | |||
| + | * QRF Operation Import | ||
| + | xxxx.qrf-op.xlsx | ||
| + | |||
| + | * Check Operation Import | ||
| + | xxxx.check-op.xlsx | ||
| + | |||
| + | * Joint Operation Import | ||
| + | xxxx.joint-op.xlsx | ||
| + | |||
| + | * Blinding Operation Import | ||
| + | xxxx.blinding-op.xlsx | ||
| + | |||
| + | * Scheduling Import | ||
| + | xxxx.scheduling.xlsx | ||
| + | |||
| + | * User Import | ||
| + | xxxx.user.xlsx | ||
| + | |||
| + | * Company Import | ||
| + | xxxx.company.xlsx | ||
| + | |||
| + | * Material Import | ||
| + | xxxx.material.xlsx | ||
| + | |||
| + | * Preparation Document Import | ||
| + | xxxx.preparation-document.xlsx | ||
| + | |||
| + | * Joint Location Import | ||
| + | xxxx.joint-location.xlsx | ||
| + | |||
| + | * Blinding Location Import | ||
| + | xxxx.blinding-location.xlsx | ||
| + | |||
| + | |||
= Equipment Import = | = Equipment Import = | ||
| Line 118: | Line 172: | ||
* QRFDescription (Text) | * QRFDescription (Text) | ||
| − | |||
| − | To import | + | |
| + | = Check Operation Import = | ||
| + | |||
| + | To import Operations following columns are required: | ||
* OperationID (Text) | * OperationID (Text) | ||
| Line 147: | Line 203: | ||
* Planner (Text) | * Planner (Text) | ||
* Suboperation (Text) | * Suboperation (Text) | ||
| − | |||
| − | |||
| − | |||
= Joint Operation Import = | = Joint Operation Import = | ||
| − | To import | + | To import Operations following columns are required: |
* OperationID (Text) | * OperationID (Text) | ||
| Line 183: | Line 236: | ||
* JointLocation (Text) | * JointLocation (Text) | ||
| + | = Blinding Operation Import = | ||
| − | + | To import Blinding Operations following columns are required: | |
| − | + | ||
| − | To import Operations following columns are required: | + | |
* OperationID (Text) | * OperationID (Text) | ||
| Line 213: | Line 265: | ||
* Planner (Text) | * Planner (Text) | ||
* Suboperation (Text) | * Suboperation (Text) | ||
| − | + | * BlindingLocation (Text) | |
| − | + | * Type (Text) | |
| + | * BlindingPackage (Text) | ||
= Scheduling Import (for Operations)= | = Scheduling Import (for Operations)= | ||
| Line 285: | Line 338: | ||
Columns that can be imported additionally: | Columns that can be imported additionally: | ||
* FileName (Text) | * FileName (Text) | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
= Joint Location Import = | = Joint Location Import = | ||
| Line 300: | Line 345: | ||
Columns that can be imported additionally: | Columns that can be imported additionally: | ||
| − | * No | + | * Joint_Location_Number (Text) |
| − | * Equipment | + | * Name (Text) |
| − | * SOP | + | * Remark (Text) |
| − | * Description | + | * Tag_Number (Text) |
| − | * BlindingNumber | + | * Gasket_Type (Text) |
| − | * PID | + | * Flange_Spec (Text) |
| − | * Size | + | * Flange_Size (Text) |
| − | * Type | + | * Flange_Rating (Text) |
| − | * LocationType | + | * Bolt_Size (Text) |
| − | * NormalPosition | + | * Bolt_Number (Text) |
| − | * OnSite | + | * Bolt_Material (Text) |
| − | * ICCNumber | + | * Torque_Value (Text) |
| − | * BlindSapNumber | + | * Pressure (Text) |
| − | * BlindQuantity | + | * Assembled_By (Text) |
| − | * GasketSAPNumber | + | * Assembled Date (TT/MM/JJJJ hh:mm) |
| − | * GasketQuantity | + | * Inspected_By (Text) |
| − | * Stage | + | * Inspected_Date (TT/MM/JJJJ hh:mm) |
| − | * Height | + | * Equipment (Text) |
| − | * Scaff | + | |
| − | * Insul | + | = Blinding Location Import = |
| − | * Crane | + | |
| − | * Remarks | + | To import joint locations following columns are required: |
| + | * BlindingLocation_ID (Text) | ||
| + | |||
| + | Columns that can be imported additionally: | ||
| + | * No (Text) | ||
| + | * Equipment (Text) | ||
| + | * SOP (Text) | ||
| + | * Description (Text) | ||
| + | * BlindingNumber (Text) | ||
| + | * PID (Text) | ||
| + | * Size (Text) | ||
| + | * Type (Text) | ||
| + | * LocationType (Text) | ||
| + | * NormalPosition (Text) | ||
| + | * OnSite (Text) | ||
| + | * ICCNumber (Text) | ||
| + | * BlindSapNumber (Text) | ||
| + | * BlindQuantity (Number) | ||
| + | * GasketSAPNumber (Text) | ||
| + | * GasketQuantity (Number) | ||
| + | * Stage (Text) | ||
| + | * Height (Text) | ||
| + | * Scaff (Text) | ||
| + | * Insul (Text) | ||
| + | * Crane (Text) | ||
| + | * Remarks (Text) | ||
[[Category:MaTaP|Import Runs]] | [[Category:MaTaP|Import Runs]] | ||
Latest revision as of 10:28, 28 November 2025
Contents
- 1 Naming Convention
- 2 Equipment Import
- 3 Workorder Import
- 4 Progress Operation Import
- 5 QRF Operation Import
- 6 Check Operation Import
- 7 Joint Operation Import
- 8 Blinding Operation Import
- 9 Scheduling Import (for Operations)
- 10 User Import
- 11 Company Import
- 12 Material Import
- 13 Preparation Document Import
- 14 Joint Location Import
- 15 Blinding Location Import
Naming Convention
General file naming convention: All import Excel files must follow the pattern:
xxxx.<import-type>.xlsx
Where xxxx can be any project- or customer-specific identifier.
Supported import types:
- Equipment Import
xxxx.equipment.xlsx
- Workorder Import
xxxx.workorder.xlsx
- Progress Operation Import
xxxx.progress-op.xlsx
- QRF Operation Import
xxxx.qrf-op.xlsx
- Check Operation Import
xxxx.check-op.xlsx
- Joint Operation Import
xxxx.joint-op.xlsx
- Blinding Operation Import
xxxx.blinding-op.xlsx
- Scheduling Import
xxxx.scheduling.xlsx
- User Import
xxxx.user.xlsx
- Company Import
xxxx.company.xlsx
- Material Import
xxxx.material.xlsx
- Preparation Document Import
xxxx.preparation-document.xlsx
- Joint Location Import
xxxx.joint-location.xlsx
- Blinding Location Import
xxxx.blinding-location.xlsx
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)
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)
Joint 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)
- JointLocation (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)
- Type (Text)
- BlindingPackage (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)
Joint Location Import
To import joint locations following columns are required:
- Joint_ID (Text)
Columns that can be imported additionally:
- Joint_Location_Number (Text)
- Name (Text)
- Remark (Text)
- Tag_Number (Text)
- Gasket_Type (Text)
- Flange_Spec (Text)
- Flange_Size (Text)
- Flange_Rating (Text)
- Bolt_Size (Text)
- Bolt_Number (Text)
- Bolt_Material (Text)
- Torque_Value (Text)
- Pressure (Text)
- Assembled_By (Text)
- Assembled Date (TT/MM/JJJJ hh:mm)
- Inspected_By (Text)
- Inspected_Date (TT/MM/JJJJ hh:mm)
- Equipment (Text)
Blinding Location Import
To import joint locations following columns are required:
- BlindingLocation_ID (Text)
Columns that can be imported additionally:
- No (Text)
- Equipment (Text)
- SOP (Text)
- Description (Text)
- BlindingNumber (Text)
- PID (Text)
- Size (Text)
- Type (Text)
- LocationType (Text)
- NormalPosition (Text)
- OnSite (Text)
- ICCNumber (Text)
- BlindSapNumber (Text)
- BlindQuantity (Number)
- GasketSAPNumber (Text)
- GasketQuantity (Number)
- Stage (Text)
- Height (Text)
- Scaff (Text)
- Insul (Text)
- Crane (Text)
- Remarks (Text)