Point List Report by Point Number

[Anonymous]

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

[Jeff_M]

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.

[Anonymous]

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

[Civil3DReminders]

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

[Anonymous]

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

10

100

1000

1001

11

110

1100

12

Etc. 

Can we convert the sort to a numerical order??

Dave 

[Civil3DReminders]

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"/>

[Anonymous · Accepted solution]

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

Dave