WelcomeFriday, December 2nd, 2022
Trimble Access question
I need to generate a csv report from Access containing the plan point number, the plan point coordinates, and the delta elevations for about 1000 3d points (i.e. 1,1000.00,1000.00,-.10) so I can plot it out with the delta elevations labeled. Havent been able to get any of the stakeout reports to do it, and haven't been able to figure out how to create a custom report that only shows that info, or anything that I can edit to get just that info easily. Any help appreciated before I wait until tomorrow to call the support guy.
Need to shoot the provided points on an existing asphalt mat on a 15' grid to show any high and low spots, and also be able to insert them to an xcel spread sheet that will highlight the amount of points that are out of tolerance.
Intended to be retired, but got called and agreed to do this because it has to be stamped and signed by a PLS.
Havent been able to get any of the stakeout reports to do it
Haven't had to do that before. Would it be worth your time to go into 'Survey Styles' and adjust your 'As-Staked Point Defaults' preferences ?
Maybe check the 'Store Grid Deltas' option box. Then check the 'View Created File' under the 'Export' file options.
You could see the format instantly, and then decide whether you need to tweek the settings, without having to download/upload the whole deal.
Yeah, I tried that, but the Stakeout Report it spits out is an htm file with only the n,e, and z deltas. If I switch to a Check Shot report, it's an htm file with nothing in it, even thought I have the h and v tolerances set to 0. It says the shots that exceed the tolerances will be highlighted, which they all should be in the test I am doing, but it shows no points.
Sorry the whole link didn't come through.
Check that page for style sheets. One of the is called "As staked delta display" of it doesn't do what you want there's documentation with it so that it can probably be modified to do what you're looking for.
I've done quite a few custom stylesheets and this seems like a pretty simple one, although field workflow does matter.
If all of these points are going to be stored as stakeout points, and there's nothing screwy going on like staking to a DTM or staking multiple elevations, it's a pretty simple process.
I'm in the middle of moving houses but I'll see if I have something that could easily be modified to suit.
The low-tech option would be to set your store point feature code to be the stakeout point name, then export out a comma-delimited file from the controller, and drop the original stakeout CSV and the Access-exported CSV into excel and sync them up.
Thanks. I may have to take the low tech option, just thought that would be a pretty standard type file to generate.
For each survey style there is an option on stakeout called 'Store grid deltas'.
It is going to be much easier to generate your report if this is turned on.
The standard stakeout reports usually report these numbers.
You will probably get N E Z and dN dEd dZ in the standard outputs.
You can either remove the columns you dont want with excel, or make a custom report by copying the original report and removing the columns you dont want
Try this one:
Change the file extension to XSL, then drop into the Trimble Data/System Files directory.
This will output the point name, design northing, design easting, cut/fill or delta elevation (from staked elevation to design), and feature code.
Thanks. Found one called Point Stakeout Cutsheet that has it all in there that will work with some editing.
That one is perfect without having to get rid of a bunch of extra columns. Thanks! And thanks to RJ, Bob, and Jim also.