Lab summary on fence diagram

In the sense of copy-and-paste something from Graphic Table to Fence report, no.

However, you can use a SQL statement to select the data that appears in the Graphic Table for a Text entity in the Fence report - this would probably be a header/footer entity placed outside the Fence data frame.

I did this once for incorporating additional non depth related graphs on a test boring sheet.  It was a while back so my memory may not be entirely accurate but it basically worked like this.

1. Export the table (or graph) you want to place on the fence diagram as a gINT drawing(*.gdw).

2. Open the exported drawing in the gINT drawing editor and create a block from all the elements in the drawing.  Place it in the drawing library and name it something like TableInsert.  You will always use the same name.

3. In your fence template insert the block from the drawing library that you created in step 2.  You can position it where you want using the x and y offsets.  It will always apear in the same place so you need to make sure it will nevfer interfere with the fence posts (see 6 below if you want to custom position the table on each and every fence).

4. Output the fence and your table should appear on the on the fence along with the selected fence posts.

5. For the next fence you have to recreate the appropriate table, export it to gINT drawing and recreate the TableInput block  (Overwrite the contents of the old TableInput block).  If you want the same table as was placed on the previous fence then this is not necessary.  Then generate the next fence.

6. If you want to be able to place the table at different places on the fence, depending on the location of the fence posts, you can modify step 3 and 4 above by exporting the fence to a gINT drawing as well. Then open the fence in gINT draw and manually insert the block created in step 2 into the gINT drawing of the fence.

Since the table is generated from the original template, any change in the original template is automatically incorporated into the fence diagram.  Also, since they are independent templates, you can generate the table using different/more/less borings than those selected to appear on the fence,  This can be both good (it may be the desired effect) or bad (you can easily mismatch the table results to the borings shown on the fence).

A little bit cumbersome and tedious but once it is set up we were able to generate 100+ drawing sheets in a matter of a day.

If you want more specific instructions I can probably recover/recreate what I did but it may be a few weeks before I can get to it.

I was having a significant brain cramp on this, but once i realized I was over-thinking it I had it working in about 20 minutes.

Thanks for your tips!

Glad I could be of help. 

On taking a second look at this with a fresh pair of eyes the following procedure could ALSO be used.  It essentially does the same thing using a different intermediate file format but eliminates the extra step of creating a block from your exported table.

1.            Output the table you want to incorporate on the fence diagram to a bitmap file (*.bmp) using gINT’s export feature in the output tab.  Make note of the path and file name you save it to.  You will always use the same name and path.

2.            Edit your fence template by inserting a bitmap symbol.  Menu = Draw, Graphics, Bitmap Symbol.  In the bitmap symbol dialog, insert the full path and file name of the bitmap file you created in step 1 as the Bitmap symbol property.  Set size and position and other options as desired.  See image below.

3.            Output the fence with the desired borings.  The table will be printed on the fence along with the borings at the specified location and size.

4.            For the next fence, output a new bitmap file of the table (if necessary) and overwrite the contents of the previous bitmap file.  The next output fence will have the new table contents.

NOTES:

You could probably automate steps 1 and 3 above into a gINT script file that outputs the table to the bmp file and then outputs the fence.

Since this method uses a raster file as the intermediate file, the background will be solid white and will block out anything behind it.  Thus pay close attention to the print order property in the configuration tab of the bitmap symbol entity.

Again, since this uses a raster file, it’s resolution is only as good as the resolution used to create the file.  It will look jaggy if you blow it up very large and it will not plot as lines and text if exported to dxf. Using a gINT Draw block as described in my previous post preserves the vector content of the original table.

Both this suggestion and the suggestion in my previous post are essentially equivalent to windows copy and paste; but instead of using the windows clipboard to hold the copied material, you are using an intermediate graphics file (BMP in this case and gdw in the previous post).

Other graphic file formats could be used but I have not experimented with those.

This method can also be used for inserting output from other software into logs and fences.  You just have to be able to create the appropriate intermediate file.  For example, you could insert a table produced by excel directly into a fence by printing it to a bmp file (this can be done several different ways that I will not get into here).   For the method described in this post, the software creating the intermediate graphics file is gINT.

Remember that the fence template is rigidly linked to a specific file path and name for the bitmap file to be inserted. Thus, if you change the file location or name, the template will no longer find the file to be inserted.

Actually, I was able to do this without having to create a different file. I used an Sql sequence to make it do what I wanted. Much simpler and more efficient.