AutoCAD Civil 3D Customization

AutoCAD Civil 3D Customization

Reply
Valued Mentor
370 Posts
0 Kudos
Registered: ‎10-22-2003
Post 1 of 7
Accepted Solution

Point List Report by Point Number

203 Views, 6 Replies
09-19-2011 09:57 AM

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

 

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

 

Dave

*Expert Elite*
4,621 Posts
921 Kudos
Registered: ‎07-22-2003
Post 2 of 7

Re: Point List Report by Point Number

09-20-2011 09:52 AM in reply to: dcouch

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.

Jeff_M, also a frequent Swamper
Valued Mentor
370 Posts
0 Kudos
Registered: ‎10-22-2003
Post 3 of 7

Re: Point List Report by Point Number

09-20-2011 10:08 AM in reply to: Jeff_M

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

Distinguished Mentor
910 Posts
18 Kudos
Registered: ‎03-24-2009
Post 4 of 7

Re: Point List Report by Point Number

09-23-2011 10:44 PM in reply to: dcouch

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

Valued Mentor
370 Posts
0 Kudos
Registered: ‎10-22-2003
Post 5 of 7

Re: Point List Report by Point Number

09-26-2011 09:00 AM in reply to: Civil3DReminders

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 

Distinguished Mentor
910 Posts
18 Kudos
Registered: ‎03-24-2009
Post 6 of 7

Re: Point List Report by Point Number

09-26-2011 11:07 AM in reply to: dcouch

 

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

 

Valued Mentor
370 Posts
0 Kudos
Registered: ‎10-22-2003
Post 7 of 7

Re: Point List Report by Point Number

09-26-2011 01:51 PM in reply to: Civil3DReminders

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

 

Dave

Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Announcements
Are you interested in helping shape the future of the Autodesk Community? To participate in this brief usability study, please click here. Your time and input is greatly appreciated!