Jump to: navigation, search

Difference between revisions of "Import Runs"

Line 1: Line 1:
 +
 
= Equipment Import =
 
= Equipment Import =
  
Line 118: Line 119:
 
* 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 286: Line 223:
 
* FileName (Text)
 
* FileName (Text)
  
−
= Blinding Location Import =
+
[[Category:MaTaP|Import Runs]]
−
 
+
−
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

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)


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