Jump to: navigation, search

Difference between revisions of "Import Runs"

Line 309: Line 309:
 
* Inspected_Date  (TT/MM/JJJJ hh:mm)
 
* Inspected_Date  (TT/MM/JJJJ hh:mm)
 
* Equipment  (Text)
 
* 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)
  
 
[[Category:MaTaP|Import Runs]]
 
[[Category:MaTaP|Import Runs]]

Revision as of 13:29, 25 November 2025

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=29180"