+ Reply to Thread
Page 1 of 2 1 2 LastLast
Results 1 to 10 of 14
  1. #1
    Full Member
    Using
    AutoCAD 2007
    Join Date
    Jun 2009
    Posts
    66

    Default Is it possible to import csv. file data into AutoCAD?

    Registered forum members do not see this ad.

    I have collected point data for the positions of trees using PocketGIS software. The software produces a csv. file with the Northings and eastings of each point surveyed to which are attached a number of other attrinutes (e.g. tree tag number, height, species etc.).
    Is it possible to import and plot these points directly into AutoCAD?
    Can some or all of the attributes be included (i.e. it would be very usefull if the positions could be plotted together with the tag number)?

    Thanks

  2. #2
    Forum Newbie
    Using
    Civil 3D 2010
    Join Date
    Jul 2010
    Posts
    3

    Default

    Check out the DBConnect command. I think there are other methods to accomplish what you want to do.
    Last edited by Civil3DReminders; 5th Jul 2010 at 06:44 pm. Reason: Put in wrong command

  3. #3
    Full Member
    Using
    AutoCAD 2007
    Join Date
    Jun 2009
    Posts
    66

    Default

    I have had a perusal of the help filewith regards DBConnect Comand but I am not sure where I should start. Any further help would be greatly appreciated.

    Thanks

  4. #4
    Forum Newbie
    Using
    Civil 3D 2009
    Join Date
    Jun 2010
    Posts
    5

    Default

    What form of AutoCAD are you using? Regular CAD or Civil3D?
    I know that if you are using Civil3D you can select your Points pull down menu and then select Import/Export and from there you can import the .csv file.

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

    Default

    Can you post the first line of the csv file explaining the meaning of each data?
    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.

  6. #6
    Full Member
    Using
    AutoCAD 2007
    Join Date
    Nov 2009
    Posts
    31

    Default

    yes this is possible

    first import or open this file in eagle point from there you cad import it to autocad.
    cad you give me this file.
    thanks

  7. #7
    Full Member
    Using
    AutoCAD 2007
    Join Date
    Jun 2009
    Posts
    66

    Default

    fuccaro
    The data would be similar to that shown below, where Easting =X , Northing =Y, Tag No= Tree identifier, Common name=species, Category = A1, A2, A3, B1, B2, B3, C1, C2, C3 or R. In the first instance it would be a csv. file but could easily be an Excel worksheet.
    Easting
    Northing
    Tag_No
    Common_Name
    Height
    Category
    4703358
    5067845
    1
    sycamore
    17
    A1

  8. #8
    Full Member
    Using
    AutoCAD 2007
    Join Date
    Jun 2009
    Posts
    66

    Default

    Hmmm. It seems you cannot include a table in this forum. Or perhaps its just beyond me! Anyway hopefully you will get my drift.

  9. #9
    Super Moderator rkmcswain's Avatar
    Computer Details
    rkmcswain's Computer Details
    Operating System:
    Windows 7 Pro x64
    Motherboard:
    Intel DZ77RE-75K
    CPU:
    i7-4770K 3.50GHz
    RAM:
    32GB
    Graphics:
    Nvidia Quadro 2000
    Primary Storage:
    125GB SSD
    Secondary Storage:
    500GB SATA
    Monitor:
    ASUS 27" / ASUS 24"
    Discipline
    Civil
    Using
    Civil 3D 2015
    Join Date
    Sep 2005
    Location
    Houston
    Posts
    3,921

    Default

    Quote Originally Posted by Treehugger View Post
    I have collected point data for the positions of trees using PocketGIS software. The software produces a csv. file with the Northings and eastings of each point surveyed to which are attached a number of other attrinutes (e.g. tree tag number, height, species etc.).
    Is it possible to import and plot these points directly into AutoCAD?
    Can some or all of the attributes be included (i.e. it would be very usefull if the positions could be plotted together with the tag number)?

    Thanks
    Using vanilla AutoCAD, and without further programming, something like this should help: http://www.caddzone.com/ascpoint.lsp

    If you have Land Desktop, Civil 3D, or add-ons like Carlson or Dotsoft Mapworks, then you already have the tools to do what you wish...

  10. #10
    Forum Newbie
    Using
    AutoCAD LT 2010
    Join Date
    Jul 2010
    Posts
    1

    Default

    Registered forum members do not see this ad.

    Is this possible in AutoCAd 2010LT the DBConnect command does not seem to work?
    I am also trying to import eastings and northings from an Excel file.

Similar Threads

  1. How to import Excel x,y,z data into AutoCAD
    By sjm in forum AutoCAD Drawing Management & Output
    Replies: 24
    Last Post: 16th Nov 2012, 09:35 pm
  2. Can I import data from excel to a AutoCAD table? Ver 2007.
    By muck in forum AutoCAD Drawing Management & Output
    Replies: 19
    Last Post: 1st Oct 2010, 02:27 pm
  3. import data from autocad to excel-little only
    By vipulgos in forum AutoCAD Beginners' Area
    Replies: 4
    Last Post: 6th May 2010, 05:37 am
  4. Replies: 2
    Last Post: 5th Jan 2010, 05:04 pm
  5. Import Data from File to Find X,Y Lengths of Multiple Polylines in AutoCad
    By ambigiousop in forum AutoLISP, Visual LISP & DCL
    Replies: 9
    Last Post: 25th Mar 2009, 06:30 pm

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