Rob Koot

How is a tally created?

Blog Post created by Rob Koot on Mar 10, 2016

The tally file is simply a CSV file, each line in the CSV holds the Joint ID, and the joint's attributes.

Where possible, the tally should be created from the pipe manufacturers manifest, but when this is not available, creating a new CSV file is a simple process.

To start, you need to create a CSV header that contains the joint ID, and headings for all the attributes you wish to collect, it might look like this:

Unique ID,Pipe #,Heat #,Length,Diameter,Wall thickness,Manufacturer,Coating,Grade,Comments,Photo1


So, you just need to create a .csv file, with a header looking something like the above, and copy the file to the \Trimble Data\Common\Tally folder on the controller.


The next step is create a 'dummy' code in your feature and attribute library called tally, and then create attribute names that match the headers in your tally CSV file, and configure those to match the properties required. For example, you would create a Number attribute called Length, a suitable min and max and the number of decimal places. A List attribute for things like Diameter, Wall thickness, Manufacturer, Coating, and Grade. For the Pipe and Heat number you could create a text attributes simply to make them 'required' fields to ensure they are completed.


The next thing you need to be aware of, is that because the tally attributes are now recorded to the tally file, you need to setup the feature codes such as Welds, Bends and Valves to only record the attributes of the welds, bends and valves and the Joint ID - but not the attributes of the joint. The attributes for the joint are recorded with the asbuilt survey measurements simply through the relationship to the Joint ID.


To see an example, check out the sample files that can found here: Trimble Access v2015.2x Pipelines sample files