Jump to: navigation, search

Import Runs

Revision as of 10:28, 28 November 2025 by LMA (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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)
Retrieved from "https://wiki.augmensys.com/index.php?title=Import_Runs&oldid=29203"