+ Reply to Thread
Page 1 of 5 1 2 3 ... LastLast
Results 1 to 10 of 46

Thread: Export Points

  1. #1
    Forum Newbie
    Using
    Land Desktop 2000i
    Join Date
    Oct 2006
    Posts
    4

    Default Export Points

    Hi I am a Surveying Engineer I use AutoCAD Land Development 2000i.
    I think that I am the newest member in this forum so I don’t know much how to manage it and maybe the question that I am going to ask someone already asked but if you can help me my question is this:

    How to export coordinates of points from AutoCAD work to the Excel or Notepad. Example I have 10 000 from the old work in AutoCAD. That work need to be partially replaced and need to create an Database which new and old points. How do I do that. I hope that someone can help me.

    Thank you for taking your time.

  2. #2
    Super Moderator fuccaro's Avatar
    Using
    AutoCAD 2006
    Join Date
    Nov 2002
    Location
    Romania, Marosvasarhely
    Posts
    3,543

    Default

    Hello Selim and velcome!
    For manipulate a huge amount of points I send you a lisp routine to save the coordinates in a text file. Run the Lisp and select the points when prompted. The WINDOW selection method can be used (or any other AutoCAD selection method), the routine will filter out other entities than POINTs. Open EXCEL and click OPEN. In the FILES OF TYPE select TEXT FILES and select the file created by the lisp. The TEXT IMPORT WIZARD will pop up. Select DELIMITED in the first step, click next and select SEMICOLON as delimiters. Click FINISH and the coordinates are on your screen!

    And here is the lisp routine:
    Code:
    ;| Save the co-ordinates of POINT entities in text file 
    mfuccaro@hotmail.com December 2003 
    _____________________________________|;
    (defun c:PO2TXT (/ file points c i) ;POints to TeXT 
      (setq file (open (getfiled "specify output file" "c:/" "TXT" 1) "w"))
      (setq points (ssget) i 0)
      (repeat (sslength points)
        (if (= "POINT" (cdr (assoc 0 (entget (ssname points i)))))
          (setq c (cdr (assoc 10 (entget (ssname points i))))
         i (1+ i)
          )
        )
        (write-line
          (strcat (rtos (car c)) " ; "
           (rtos (cadr c)) " ; "
           (rtos (caddr c))
          ) file)
      )
      (close file)
      (Princ)
    )
    It's nice to be nice, but sometimes is nicer to be evil!.
    Tip: Please do not PM or email me with CAD questions - use the forums, you'll get an answer sooner.

  3. #3
    Forum Newbie
    Using
    Land Desktop 2000i
    Join Date
    Oct 2006
    Posts
    4

    Default Export Points

    Thank you for your answer but I still have the same problem because I dont know to work with LISP, so if you can explain me litel bit more or you can tell me another way I will be very thankfull.

    Best regards
    Selim

  4. #4
    Super Moderator fuccaro's Avatar
    Using
    AutoCAD 2006
    Join Date
    Nov 2002
    Location
    Romania, Marosvasarhely
    Posts
    3,543

    Default

    It is not hard at all to use Lisp routines. If you work on a full AutoCAD -and not an LT version- you may use this power. Follow this link: http://www.cadtutor.net/forum/showthread.php?t=1390
    It's nice to be nice, but sometimes is nicer to be evil!.
    Tip: Please do not PM or email me with CAD questions - use the forums, you'll get an answer sooner.

  5. #5
    Forum Newbie
    Using
    Land Desktop 2000i
    Join Date
    Oct 2006
    Posts
    4

    Default Export Points

    Dear mr. Fuccaro,

    I am very thankfulled that you helped me again and I think that we almost solved the problem of exporting points from dwg to txt. I think that maybe the problem is that Points are Civil Point Object. In another case these Points we EXPODED but again it apears the same argument, here is the way that I did and the argument that apears in the comand line. We folowed yuor advice but in the end we get the empty txt file.
    The reason that I need this transfer is because I need these points for Total Station and GPS 530 for stakeout.

    Command:
    Command: _appload PO2TXT.LSP successfully loaded.
    Command:
    Command:
    Command: PO2TXT
    Select objects: Specify opposite corner: 3539 found
    Select objects: *Cancel*
    bad argument type: numberp: nil

  6. #6
    Forum Deity
    Using
    AutoCAD 2002
    Join Date
    Sep 2006
    Location
    East Sussex, U.K.
    Posts
    3,475

    Default

    Hi selim,

    I think the main difference between AutoCADers and surveyors is one of terminology i.e. what you call things. To a surveyor, a point is a mark on the ground where a detail pole was held and to which a reading was taken. It has a unique point identification number and x,y and z coordinates and possibly other stringing information. To a draughtsman, a point is an entity in the drawing.

    Thus the confusion arises when you want to export points, the Autolisp boffins do not know about the other surveying properties of your point.

    It is important to know how the points in your drawing are drawn. Are they simply two lines forming a cross with the level text alongside, or are they blocks with all the surveying information as attributes? If your points are blocks with attributes, then you can use the attribute extraction.

    For stakeout, it is very important to know which point is which, and so the points, when extracted, have to have reference numbers. I would think that it is beyond any programming to select a whole lot of points and have them referenced in the order you wish. It may be a case for you to slog your way through the drawing point by point, unless you can find a routine to do what you want it to.

  7. #7
    Super Moderator fuccaro's Avatar
    Using
    AutoCAD 2006
    Join Date
    Nov 2002
    Location
    Romania, Marosvasarhely
    Posts
    3,543

    Default

    Selim
    Sorry, the routine exports AutoCAD points (created with the POINT command).
    Let's try again. Enter in the command line:
    (entget (car (entsel)))
    press enter and pick a ... "point". Press F2 to see the text screen and copy-paste here the result.
    It's nice to be nice, but sometimes is nicer to be evil!.
    Tip: Please do not PM or email me with CAD questions - use the forums, you'll get an answer sooner.

  8. #8
    Junior Member alderney's Avatar
    Using
    Land Desktop 2004
    Join Date
    Nov 2006
    Location
    Dartmouth, Nova Scotia
    Posts
    17

    Default

    Creat e a point group containing the points you wish to export.
    Go to Points --- Export Points & select the group name you created
    Export as a .txt then you may change it to an .asc file later if needed.
    To import:
    Points--Import points
    Just follow the prompts after that.
    Hope that was helpful!
    Nicole

  9. #9
    Senior Member Cymro's Avatar
    Using
    AutoCAD 2008
    Join Date
    Jul 2006
    Location
    Gwynedd Wales
    Posts
    165

    Default

    Hi I work in a similar field using autocad 2005.
    the po2txt lisp is really great and was wondering if anybody has a similar lisp to export the nodes or points on a polyline straight to a txt file or ideally an excel.
    Thanks very much
    Stephen

  10. #10
    Forum Newbie
    Using
    AutoCAD 2008
    Join Date
    Sep 2007
    Posts
    2

    Default

    Registered forum members do not see this ad.

    thank you fuccaro for the lisp routine... it was really very useful...

Similar Threads

  1. export a big map as bmp or jpg
    By harawer in forum AutoCAD General
    Replies: 4
    Last Post: 6th Dec 2009, 02:04 am
  2. Trying to Export UCS
    By thebandit in forum AutoCAD General
    Replies: 1
    Last Post: 10th Jul 2006, 04:39 pm
  3. TIN export
    By peter2 in forum AutoCAD Drawing Management & Output
    Replies: 10
    Last Post: 13th May 2005, 11:00 am
  4. Export to DXF
    By fuccaro in forum AutoCAD General
    Replies: 3
    Last Post: 15th Feb 2005, 03:57 am

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts