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 |