topic Point List Report by Point Number in Civil 3D Customization Forum

Point List Report by Point Number

Anonymous — Mon, 19 Sep 2011 16:57:51 GMT

I thought I had solved this long ago. I am in C3D 2009. I am not sure how my Reprts - Point List is being sorted. It looks like by code, but not necessarily that. I want the list to sort by Point Number. I have looked at the XSL/XML file, but haven't seen where to do this. Can someone help??

Couchpotato

Re: Point List Report by Point Number

Jeff_M — Tue, 20 Sep 2011 16:52:39 GMT

I'm pretty sure the LandXML point export does so in the order in which the points were created, so if you add point 100 after point 200, it will be displayed in the report after 200 as well. I know no way of changing this, since the XLS style sheets read the XML file line by line. Possibly work around this by Editing the desired points, then in the Panorama set the columns you want in the report, sort by point number, select all, right-click, copy to clipboard. Open Notepad, Wordpad, whatever.....paste, edit to include a Title, column headings, etc.

Re: Point List Report by Point Number

Anonymous — Tue, 20 Sep 2011 17:08:01 GMT

I was afraid there was something like that. I may resort to just exporting a CSV file and printing that. Not formatted pretty, but points are sorted. Thanks, Jeff for looking at this. I may look at a way to create the list by selection somehow and format the printout.

Couchpotato

Re: Point List Report by Point Number

Civil3DReminders — Sat, 24 Sep 2011 05:44:10 GMT

Adding the sort after the for-each appears to get the list to sort. It looks like the report gives the expected results if the name field isn't filled in, but if the name field is filled in it appears the report then puts things out of order. This appears to fix it.

<xsl:for-each select="//lx:CgPoint[not(@pntRef)]">
<xsl:sort select="@name"/>

Christopher

Re: Point List Report by Point Number

Anonymous — Mon, 26 Sep 2011 16:00:22 GMT

Thanks, Christopher, almost there. The sort is Text oriented. i.e. Point numbers in this order.

100

1000

1001

110

1100

Etc.

Can we convert the sort to a numerical order??

Dave

Re: Point List Report by Point Number

Civil3DReminders — Mon, 26 Sep 2011 18:07:01 GMT

It's always something. This should work. It tells the sort to use number, the default was text. Unsure what happens if the name has both numbers and text.

<xsl:sort select="@name"
data-type="number"/>

Re: Point List Report by Point Number

Anonymous — Mon, 26 Sep 2011 20:51:45 GMT

Christopher, PERFECT. Thank you. Taht will make my surveyor much happier.

Dave