Mobile for Trains

Pitram Mobile allows users to submit train related events for the loading and dumping of train wagons.

Users can

  • Select the number of wagons currently connect to the train
  • Indicate wagons being loaded (eg from Chutes)
  • Dump a train

Reference Data Setup

The following configuration needs to be set up in reference data:

  • Equipment attributes to carry train related data
  • Property sheet for a train
  • Train main menu

The tables below show a default setup for trains:

Equipment Attributes Required for Trains

The following attributes need to be configured in the Equipment reference group:

Attribute Name Is Dynamic Attribute Data Type Decsription
ChutesActiveList false string Attribute against the EQUIPMENT ref group that determines list of chutes available for this train
IsTrain false numeric Attribute against the EQUIPMENT ref group that determines whether the equipment is a train.
TRAIN_LOAD_RECORDS true string Attribute against the EQUIPMENT ref group that stores information about train current loaded state (ie which wagons are loaded from which chutes)
WagonCount true double Attribute against the EQUIPMENT ref group that determines how many wagons the train currently has attached
WagonLoaded true double Attribute against the EQUIPMENT ref group that determines how many wagons it has loaded

Property Sheet Setup

This step must be done manually in various Pitram server databases.

A new reference data version needs to be created by running the script CreateNewPropertySheets.sql against the Pitram server database.

CreateNewPropertySheets.sql can be found at \\PER-SRV-DFS\Installs\Pitram Installation\4.14.0-Latest Release\Scripts\MobileForTrains\.

The new reference data version has to be used to fill in the following tables. Use the version number to substitute the (rv) placeholder:

RD_PROPERTYSHEETDEFINITION_BoxDefinition

ReferenceGroupVersion SheetName BoxNumber BoxLeft BoxTop BoxRight BoxBottom FillMode ColourDay ColourNight
(rv)* Train 1 20 330 980 335 1 255 NULL
(rv)* Train 2 20 660 980 665 1 255 NULL

 

RD_PROPERTYSHEETDEFINITION_DetailQueryParameter

ReferenceGroupVersion DetailName SheetName BusinessObjectQueryParameterName BusinessObjectQueryParameterTextValue
(rv)* CycleStatus Train statusCategory CYCLE
(rv)* LoadCount Train measureCode Wagon
(rv)* PrimaryStatus Train statusCategory PRIMARY
(rv)* TotalProduction Train measureCode TONNE
(rv)* UnitProduction Train measureCode TONNE
(rv)* WagonCount Train attributeName WagonCount
(rv)* WagonLoaded Train attributeName WagonLoaded

 

RD_PROPERTYSHEETDEFINITION_DetailRow

ReferenceGroupVersion DetailName SheetName DefaultDisplayName BusinessModelDataElement BusinessQueryObjectType
(rv)* AssignedDestination Train Destination destinationAllocation assignedDestination
(rv)* CurrentShift Train   shift shift
(rv)* CurrentTask Train Task shiftPlanning currentTask
(rv)* CycleStatus Train Cycle status statusExclusive
(rv)* LoadCount Train Loads materialMovement totalMaterialMovementsDumped
(rv)* Location Train Location primaryAllocation location
(rv)* PrimaryStatus Train Status status statusExclusive
(rv)* QuickListItem0 Train   localMobile quickList
(rv)* QuickListItem1 Train   localMobile quickList
(rv)* QuickListItem2 Train   localMobile quickList
(rv)* QuickListItem3 Train   localMobile quickList
(rv)* QuickListItem4 Train   localMobile quickList
(rv)* QuickListItem5 Train   localMobile quickList
(rv)* UnitProduction Train Tonnes materialMovement totalMaterialMovementsDumped
(rv)* WagonCount Train Wagon Count attributeValue WagonCount
(rv)* WagonLoaded Train Wagon loaded attributeValue WagonLoaded
(rv)* PrimaryOperator Train Operator: peopleAllocatedToMe primaryOperator

 

RD_PROPERTYSHEETDEFINITION_Sheet

ReferenceGroupVersion SheetName
(rv)* Train

 

Main Menu Setup

This step must be done manually in various Pitram server databases.

A new reference data version needs to be created by running the script CreateNewMenuData.sql against the Pitram server database.

CreateNewMenuData.sql can be found at \\PER-SRV-DFS\Installs\Pitram Installation\4.14.0-Latest Release\Scripts\MobileForTrains\.

The new reference data version has to be used to fill in the following tables. Use the version number to substitute the (rv) placeholder:

RD_MAINMENU_EventTokenSelection

MenuName ReferenceGroupVersion EventInformationSelectionType DisplaySequence
TrainMenu (rv)* 0 0

 

RD_MAINMENU_FixedDataElement

DisplaySequence MenuName DataElement ReferenceGroupVersion DataElementDataType DataElementValueText DataElementValueNumeric
50 TrainMenu ATTRIBUTEVALUE (rv)* 0 ChuteList 1
51 TrainMenu ATTRIBUTENAME (rv)* 0 WagonCount NULL
52 TrainMenu STATUS (rv)* 0 HAULING NULL
52 TrainMenu STATUSCLASS (rv)* 0 CYCLE NULL
53 TrainMenu ATTRIBUTENAME (rv)* 0 WagonLoaded NULL
53 TrainMenu ATTRIBUTEVALUE (rv)* 1 NULL 1
54 TrainMenu ATTRIBUTENAME (rv)* 0 WagonLoaded NULL
55 TrainMenu MEASURECODE (rv)* 0 Wagon NULL
0 TrainMenu STATUSCLASS (rv)* 0 PRIMARY NULL
56 TrainMenu ATTRIBUTEVALUE (rv)* 0 EditLoads NULL

 

RD_MAINMENU_MainMenu

MenuName ReferenceGroupVersion DefaultDisplayName ConfigurationName ConfirmConfigurationName
TrainMenu (rv)* TrainMenu NULL NULL

 

RD_MAINMENU_MainMenuItem

MenuName

DisplaySequence

ReferenceGroupVersion

DisplayText

EventId

NextMenuId

ShortcutSequence

TrainMenu

0

(rv)*

Status

1025

NULL

NULL

TrainMenu

1

(rv)*

Locations

257

NULL

NULL

TrainMenu

2

(rv)*

Destination

265

NULL

NULL

TrainMenu

50

(rv)*

ChuteList

774

NULL

NULL

TrainMenu

51

(rv)*

Wagon count

769

NULL

NULL

TrainMenu

52

(rv)*

Haul

1025

NULL

3

TrainMenu

53

(rv)*

TrainFullLoad

769

NULL

2

TrainMenu

54

(rv)*

TrainLoad

769

NULL

1

TrainMenu

55

(rv)*

Dump

513

NULL

4

TrainMenu

56

(rv)*

EditLoads

774

NULL

NULL

 

RD_MAINMENU_Screen

ScreenId

ReferenceGroupVersion

ScreenType

ScreenDisplayName

DataElementName

ReturnValueDataType

DataTokenGroupName

ActiveListName

NumericMin

NumericMax

WagonCount

(rv)*

0

Enter Wagon Count

ATTRIBUTEVALUE

1

NULL

NULL

NULL

30

WagonLoad

(rv)*

0

Enter Wagons to Load

ATTRIBUTEVALUE

1

NULL

NULL

NULL

30

ChuteList

(rv)*

1

Chute List

LOCATION

0

Location

NULL

NULL

NULL

Status

(rv)*

1

Status

STATUS

0

Status

TrainStatusActiveList

NULL

NULL

 

RD_MAINMENU_ScreenSequence

MenuName

DisplaySequence

ScreenId

ReferenceGroupVersion

ScreenSequence

TrainMenu

1

Locations

(rv)*

0

TrainMenu

2

Destination

(rv)*

0

TrainMenu

50

ChuteList

(rv)*

0

TrainMenu

51

WagonCount

(rv)*

0

TrainMenu

54

WagonLoad

(rv)*

0

TrainMenu

0

Status

(rv)*

0

Mobile for Trains: User Interface