Changes

Import Runs

3,114 bytes added, 31 March

Created page with "=== Equipment Import === To import equipments following columns are required: * EquipmentID (Text) '''NOTE:''' “CoordinateLong”, “CoordinateLat” and “CoordinateAlt..."

=== 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)

BRP

73

edits