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

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)

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)

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)

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)

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)

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)

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)

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)

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)

To import companies following columns are required:

• CompanyCode (Text)

Columns that can be imported additionally:

• Company (Text)

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)

To import materials following columns are required:

• Workorder (Text)
• FilePath (Text)

Columns that can be imported additionally:

• FileName (Text)

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)

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)