Jump to: navigation, search

Difference between revisions of "Import Runs"


(Material Import)
 
(2 intermediate revisions by 2 users not shown)
Line 62: Line 62:
 
* NormalDuration (Number)
 
* NormalDuration (Number)
 
* NormalDurationUnit (Text)
 
* NormalDurationUnit (Text)
* Work (Text)
 
 
* WorkUnit (Text)
 
* WorkUnit (Text)
 
* Workcenter (Text)
 
* Workcenter (Text)
Line 77: Line 76:
 
* Planner (Text)
 
* Planner (Text)
 
* Suboperation (Text)
 
* Suboperation (Text)
 +
 +
  
 
= Scheduling Import  (for Operations)=
 
= Scheduling Import  (for Operations)=
Line 137: Line 138:
 
* Unit (Text)
 
* Unit (Text)
 
* ReservationStatus (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)
  
 
{{Attention|This page is under construction.}}
 
{{Attention|This page is under construction.}}
  
 
[[Category:MaTaP|Import Runs]]
 
[[Category:MaTaP|Import Runs]]

Latest revision as of 13:26, 16 July 2024

IC Attention.pngThis page is under construction.

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 columns are required:

  • Workorder (Text)

Columns that can be imported additionally:

  • EquipmentID (Text)
  • Description (Text)
  • WBS (Text)
  • Comment (Text)
  • Longtext (Text)
  • DrainlistDocument (Text)
  • EquipmentType (Text)
  • EquipmentGroup (Text)

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)
  • 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)
  • 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)
IC Attention.pngThis page is under construction.