Difference between revisions of "Import Runs"

Revision as of 11:51, 16 May 2024

This 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 operation 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 (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

To import schedulings 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)

This page is under construction.