Jump to: navigation, search

Import Runs


Revision as of 13:26, 16 July 2024 by LMA (Talk | contribs) (Material Import)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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.