Map GPS .csv

Calibrating the haul network using the Map GPS .csv data, removes the need to manually create waypoints and calculate haul times outside of HI.

To use this method, data must be arranged in columns and provide enough information to obtain the following information.

For example: Payload can be used with a Custom Variable to determine if the truck is loaded or empty.

Required Field	Purpose
Truck Name	Used to determine which fleet the movement belongs to. These need to match the Truck types setup in HI.
Truck Type	Used to determine if the haul cycle falls under loaded travel or unloaded travel.
Loaded (y/n)	Used to determine if the truck is moving and how fast or if it stationary based on GPS location.
Timestamp	Used to determine if the truck is moving and how fast or if it stationary based on GPS location.
GPS Coordinates (x,y,z)	Used in conjunction with timestamps to determine speed.

Importing Data

1. Select the Calibration – Map GPS .csv option from the Extensions menu.

2. Select the .csv file to import.

3. Click the Blue Plus Icon to add a new mapping. Mappings will be saved for use with future imports.

   Available Variables will be shown on the right-hand side once a file has been selected.

   

4. Map the required fields from the Available Variables to the Field Mappings. This can be done by dragging and dropping, or by selecting a field and double-clicking on the appropriate variable.

   Custom Variables can be used to process the data into the required output. For example:

Copy

1
2
3
4
5
6
7
8
public class IsLoaded : ITextCustomVariable
                    {
                    public string GetText(CustomVariablesContext context)
                    {
                    return context.N("PAYLOAD") > 100 ? "y" : "n";
                    }
                    }
                

To name a workflow the easier way would be to set the Caption property of the workflow variable inside the MyWorkflow method. We are going to give the workflow the name My Workflow to keep the theme with the method.

After this change if we recompile the scripts and select the MyWorkflow node in the script select of the Workflow Panel, then we should see that the root node has been renamed to My Workflow.

5. Once everything is mapped, click OK to read in the data.

In some cases, ‘bad’ data may be present in the data. These will be identified and ignored as part of the Import process.

Calibration setup has several variables which can be adjusted to help fit data to the network. For more information, see: Calibrate from GPS Options