AutoCAD Civil 3D General Discussion

Reply
Active Contributor
torner
Posts: 41
Registered: ‎02-02-2007
Message 1 of 11 (218 Views)
Accepted Solution

Export points - order

218 Views, 10 Replies
08-06-2013 08:05 AM

I have a PNEZD .txt file that was used to bring into C3D using Points From a File.

After this, figures were brought in using Import Survey Data with the option Process Linework Sequence= By Import Order.

Some Raw Description edits were then made within the dwg file.

Finally, an Export Points (back to a PNEZD txt file) was made.This file has the Points listed numerically 1-10000.

If a user wanted to Import this file, it wouldn't come in correctly because it has lost the "Import Order".

 

Is there any way that this "order" could be preserved? Is there a different process that could be used?

Kinda learning this on my own, so bear with me.

Tom
C3D 2012 sp1
W7Pro 64bit
HP Z400 Workstation
16 GB RAM
Intel Xeon CPU W3565@3.20GHz
NVIDIA Quadro 4000
Valued Mentor
dmartin
Posts: 406
Registered: ‎04-09-2013
Message 2 of 11 (200 Views)

Re: Export points - order

08-06-2013 09:26 AM in reply to: torner

I have never heard of a way, but you might be able to get creative with excel?

Thanks,
Dave

Civil 3D 2013
HP Z400 Workstation
6GB of RAM
296GB HDD
ATI FirePro V5700(FireGL)
Win 7 Home Professional
Please use Kudos Where Deserved



*Expert Elite*
tcorey
Posts: 2,482
Registered: ‎12-18-2002
Message 3 of 11 (187 Views)

Re: Export points - order

08-06-2013 11:05 AM in reply to: torner

Post your original import file for us to play with.

Tim Corey, Owner
Delta Engineering Systems
Redding, CA
Autodesk Authorized Value-Added Reseller
Active Contributor
torner
Posts: 41
Registered: ‎02-02-2007
Message 4 of 11 (184 Views)

Re: Export points - order

08-06-2013 11:40 AM in reply to: tcorey

The points in particular are the centerline of road points (CLN). It seems that some CLN was picked up by survey (1000 point #'s) and then some was picked up again later (23000 point #'s). Example: 1338 and 23170 area is "filling in" the CLN line.

 

 

Tom
C3D 2012 sp1
W7Pro 64bit
HP Z400 Workstation
16 GB RAM
Intel Xeon CPU W3565@3.20GHz
NVIDIA Quadro 4000
Valued Mentor
ericcollins6932
Posts: 332
Registered: ‎05-13-2010
Message 5 of 11 (173 Views)

Re: Export points - order

08-06-2013 12:57 PM in reply to: torner

I would suggest creating a point group with the points you want, assuming pt numbers are incrementally correct. Then you can either export the group, or renumber the points and then export.

Eric Collins, P.Tech.(Eng.)

Win 7 Enterprise SP1 64 bit
Intel i7 3770 @ 3.40 GHz
16 GB RAM
Civil 3D 2012 SP2
Distinguished Contributor
cbaildon001
Posts: 151
Registered: ‎06-28-2008
Message 6 of 11 (164 Views)

Re: Export points - order

08-06-2013 01:20 PM in reply to: torner

Another option would be to ignore/remove the points you have and use Create Points>Polyline Vertices - Automatic. This will create points with sequential point numbers.

Caleb Baildon
Surveyor
Opus International Consultants Ltd
Greymouth, New Zealand
Civil3D 2015 - Windows7 64bit
*Expert Elite*
tcorey
Posts: 2,482
Registered: ‎12-18-2002
Message 7 of 11 (151 Views)

Re: Export points - order

08-06-2013 02:40 PM in reply to: torner

The following code will export your points in the order of creation, without regard to point number.

 

;routine exports points in order of creation, not point number order
;|Copyright (c) Timothy K. Corey
Delta Engineering Systems
Redding, CA
for use by Autodesk AutoCAD Civil 3D discussion group participants.
You may distribute the code as-is but you may not sell it for any reason|;

(defun c:go (/ fl ls len ctr p pvl info)

  (vl-load-com)

  (setq fl (open "c:\\ExportedPoints.txt" "w"))

  (setq ls (ssget "x" (list (cons 0 "AECC_COGO_POINT")))
	len (sslength ls)
	ctr (- len 1)
	)


   (while (>= ctr 0)

    (setq p (ssname ls ctr)
	  pvl (vlax-ename->vla-object p)
	  )
     (ptInfo)
     (write-line Info fl)
     (setq ctr (- ctr 1))
     )
  (close fl)
  (princ)

);end defun


(defun ptInfo(/ nor eas z no desc)
  (setq Nor (vlax-get-property pvl 'Northing)
	  Eas (vlax-get-property pvl 'Easting)
	  Z (vlax-get-property pvl 'Elevation)
	  No (vlax-get-property pvl 'Number)
	  Desc (vlax-get-property pvl 'Description)
	Info (strcat (itoa no) "," (rtos Nor) "," (rtos Eas) "," (rtos Z) "," Desc)
	  )
  (princ)
  );end PtInfo

Best regards,

 

Tim

 

Tim Corey, Owner
Delta Engineering Systems
Redding, CA
Autodesk Authorized Value-Added Reseller
Active Contributor
torner
Posts: 41
Registered: ‎02-02-2007
Message 8 of 11 (135 Views)

Re: Export points - order

08-07-2013 06:16 AM in reply to: tcorey

Thanks Tim. I'd like to try this but have no idea how to run this or any code. If it is something easy I'd give it a try, but if it's going down another track I would rather not. I think I have some more learning and testing to do in C3D survey area. Thanks.

Tom
C3D 2012 sp1
W7Pro 64bit
HP Z400 Workstation
16 GB RAM
Intel Xeon CPU W3565@3.20GHz
NVIDIA Quadro 4000
Valued Mentor
IanMcClain
Posts: 440
Registered: ‎09-29-2008
Message 9 of 11 (129 Views)

Re: Export points - order

08-07-2013 07:11 AM in reply to: torner

I would edit the input file with necesary edits. I do this commonly do this for survey data so as to preserve and document any edits made to the data. Typically I comment out the original line, copy and past it to the next line and make an edit there.

-Ian McClain
(running C3D 2012 sp4, Win7 64bit, 8GB)
*Expert Elite*
tcorey
Posts: 2,482
Registered: ‎12-18-2002
Message 10 of 11 (122 Views)

Re: Export points - order

08-07-2013 08:35 AM in reply to: torner

Hello Tom,

 

Copy the code I posted. Paste into a Notepad document. Save the file as ExportPointsinCreationOrder.lsp. 

 

When in AutoCAD Civil 3D, use the Appload command to find and load ExportPointsinCreationOrder.lsp. Once it has been loaded, type Go and it will run.

 

I didn't take the time to make dialog calls so it just creates a file called ExportedPoints.txt in C:\. The format is P,N,E,Z,D.

 

Tim

Tim Corey, Owner
Delta Engineering Systems
Redding, CA
Autodesk Authorized Value-Added Reseller

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.

Need installation help?

Start with some of our most frequented solutions to get help installing your software.

Ask the Community


Civil 3D Exchange Apps

Created by the community for the community, Autodesk Exchange Apps for AutoCAD Civil 3D helps you achieve greater speed, accuracy, and automation from concept to manufacturing.

Connect with Civil 3D

Twitter

Facebook

Blogs