TSC3 stakeout report

They still have it; you may need to download the style sheet from the Trimble web site.

Trimble style sheets

Go to this link to download the style sheet:

http://www.trimble.com/globalTRLTAB.asp?nav=Collection-62098

Unzip the file and put the XSL file in your Trimble DataSystem Files folder on the TSC3. The report will now appear in the Custom Export Formats menu.

Trimble style sheets

Thanks Lee that was exactly what I was looking for.

Trimble style sheets

Lee,
Great link!!
I can't wait to get a chance to try a few of these!

I looked all over the place on the Trimble site for some sort of style sheet generation information!

THIS is the first time I've seen anything on it!!!

Thanks again Lee!! 😀

Trimble style sheets

Any one writing their own style sheets?
I looked inside one to edit it but got scared off, it looked way to complex for what it was.
I might get into it again if I get time. What would be a suitable program to edit the XML? I mean is there something better than notepad?

Trimble style sheets

Follow the Link in Lee's Post...

Go allllll the way to the bottom of that page for a LOT of info on style sheets!

I haven't cracked them open yet.....
But it does address editing stylesheets.

Trimble style sheets

Thanks I had never noticed that there was documentation.
It will definitely help!

Trimble style sheets

I went to a seminar at Dimensions about editing style sheets; the guy said it's best to start with one that is close to what you want and edit it rather than try to start from scratch. I want to say he said he uses C++.

Trimble style sheets

> I want to say he said he uses C++.

He was probably using one of the flavor Microsoft VisualStudio (VS).
C++ is a language, not an editor.
VS is WAAYYYY more than you guys need - plus it costs a good chunk.
Notepad++ is pretty dam fancy editor that will handle XML/XSLT and just about any kind of programming language you fellers never heard of.

The price is right - FREE!
Enjoy.

Trimble style sheets

I just had a look at one. Those files are a mix of HTML and XSLT. I've never seen that before. I wonder how they are blending the XML with these. I have not done anything with XSLT in well over 10 years.

Trimble style sheets

I can give you a little project if you want to get back into it????;-)

Trimble style sheets

Sure, why not. Email in profile is good.
Don't make it too huge of a project and tell me which one of the reports I should [attempt to] apply it to.
It's been so long since I've messed with this stuff, I might just as well start over.
Oh well, got nothing else better to do. Might as well keep the brain active.
E.

Trimble style sheets

Hi BigE that's a very kind offer sorry for belated response. I was only being cheeky but if you could offer some help or advice that would be most welcome.

I had a few quibbles with the "cut sheet" reports produced by the style sheets on a previous job.

The style sheet we find very useful on particular jobs - what we call P-way, (rails for trains) is "cut sheet 1". It basically outputs the deviations of measured points from the alignment string. The deviations are measured in offset and cut/fill. The chainages of the measured points are also recorded. We then bring this into excel. It can then be combined with other info as make records of the progress of the re-alignment or relaying job. My colleagues would typically be typing this into excel manually so I'm trying to streamline things.

I was going to suggest that this cut sheet would be better if it exported as CSV not HTM, but actually it is very easy to "select all" in chrome, and paste into excel.
However a CSV would be just as simple to use.

Quibbles were for example that the chainage was being reported as 1+135.000 which required reformatting with formulas before it could be used as a number in excel. I have found a setting in access to change this format though so now that is no problem.

Other things that would be beneficial are
1) The string that was being setout should be output for each measured point.
2) The point number of each measured point should be shown.
3) The date/time when each point was being measured should be shown.

A screengrab of the output is below.

Do you have the use of Access to use the stylesheet files? If not, would you be able to use the XSLT files to process the info on the computer what would the input file be - XML? I know you can save an Access job as JobXML so maybe that would be it.

For other users of Access Roads module you may be interested to know that the reports offered in the roads module are ones that have "roads_" at the start of the filename. So if you want them in the list then copy and rename them.

Trimble style sheets

Yes, having read the documents there is a Trimble ASCII file generator program that can use the XSL stylesheet files to transform the JobXML files, so allowing development of the code without doing it on the controller.

I am just beginning to look at this with more (slowly) educated eyes. I think it's something that could be very useful.

The "Defining Stakeout Reports" document describes the things I need I think. There are also SSS files to be considered which are the ones that control the information shown on screen.

There are also reports that will use a RoadXML file to process observations relative to a road alignment. This opens the possibility, using the ascii file generator program, of using observations from other instruments or re-using the same observations against a different alignment.

Trimble style sheets

> Go to this link to download the style sheet:
>
>> http://www.trimble.com/globalTRLTAB.asp?nav=Collection-62098
>
> Unzip the file and put the XSL file in your Trimble DataSystem Files folder on the TSC3. The report will now appear in the Custom Export Formats menu.

This link is a different one (with more downloads) than the one I had always used before which comes up on first on google.

thanks again for helping me find the stiff Trimble hides away on it;s website.