• Industries
  • Products
  • Buy
  • Services & Support
  • Communities
  • Discussion Groups

    AutoCAD Map 3D

    Reply
    *Expert Elite*
    neilyj
    Posts: 2,672
    Registered: ‎08-01-2008
    Accepted Solution

    Bring csv file (with additional attributes) into Map

    466 Views, 17 Replies
    05-14-2012 12:47 AM

    I found this post which describes exactly what I want to do to get data into Map http://map3d.wordpress.com/2008/01/02/bring-a-csv-file-into-map-3d-with-data/ but I get stuck almost at the first hurdle (see screenshot).

     

    Isn't there any easier way to get this data into Map??

     

    Thanks

    neilyj
    (No connection with Autodesk other than using the products in the real world)


    IDSP Premium 2014, Civil 3D 2013 (UKIE) Hotfix 3; Win 7 Pro x64
    256Gb SSD, 300Gb 15,000 rpm HDD
    16Gb Ram Intel Xeon CPU E5-1607 0 @ 3.00GHz (4 CPUs), ~3.0GHz
    NVIDIA Quadro 4000, Dual 27" Monitor, Dell T3600
    Please use plain text.
    Valued Mentor
    Posts: 311
    Registered: ‎03-24-2004

    Re: Bring csv file (with additional attributes) into Map

    05-14-2012 02:12 AM in reply to: neilyj

    search this forum for 64 bit odbc. 

    Please use plain text.
    New Member
    jimyquick
    Posts: 1
    Registered: ‎06-29-2010

    Re: Bring csv file (with additional attributes) into Map

    05-14-2012 09:18 AM in reply to: neilyj
    Please use plain text.
    Distinguished Mentor
    thepworth
    Posts: 525
    Registered: ‎03-02-2011

    Re: Bring csv file (with additional attributes) into Map

    05-14-2012 11:01 AM in reply to: neilyj

    Neily,

     

    Murph's post was for the 2008 version - more functionality (i.e. the survey tab under mapwspace) has been added, but you can still follow through & use ODBC to connect to Excel.  If using ODBC, you must use a named range in Excel and have the current 64bit excel driver.

     

    If you're really stuck, send me a PM and I'll see what I can do to help walk you through it.

     

    Todd Hepworth, P.E.


    C3D 2011
    Intel Xeon E5630@2.53Ghz
    NVIDA Quadro NVS420 Dual Monitor
    12GB Ram / Win7 Professional 64bit SP1
    Please use plain text.
    *Expert Elite*
    neilyj
    Posts: 2,672
    Registered: ‎08-01-2008

    Re: Bring csv file (with additional attributes) into Map

    05-14-2012 12:52 PM in reply to: jimyquick

    Gracias por esto voy a echarle un vistazo (from Google translate....)

    neilyj
    (No connection with Autodesk other than using the products in the real world)


    IDSP Premium 2014, Civil 3D 2013 (UKIE) Hotfix 3; Win 7 Pro x64
    256Gb SSD, 300Gb 15,000 rpm HDD
    16Gb Ram Intel Xeon CPU E5-1607 0 @ 3.00GHz (4 CPUs), ~3.0GHz
    NVIDIA Quadro 4000, Dual 27" Monitor, Dell T3600
    Please use plain text.
    *Expert Elite*
    neilyj
    Posts: 2,672
    Registered: ‎08-01-2008

    Re: Bring csv file (with additional attributes) into Map

    05-14-2012 12:55 PM in reply to: thepworth

    thepworth wrote:

    Neily,

     

    Murph's post was for the 2008 version - more functionality (i.e. the survey tab under mapwspace) has been added, but you can still follow through & use ODBC to connect to Excel.  If using ODBC, you must use a named range in Excel and have the current 64bit excel driver.

     

    If you're really stuck, send me a PM and I'll see what I can do to help walk you through it.

     

    Todd Hepworth, P.E.


    Thanks Todd, I only have 32 bit Office so will need to look at the link in the post from jimyquick....

    neilyj
    (No connection with Autodesk other than using the products in the real world)


    IDSP Premium 2014, Civil 3D 2013 (UKIE) Hotfix 3; Win 7 Pro x64
    256Gb SSD, 300Gb 15,000 rpm HDD
    16Gb Ram Intel Xeon CPU E5-1607 0 @ 3.00GHz (4 CPUs), ~3.0GHz
    NVIDIA Quadro 4000, Dual 27" Monitor, Dell T3600
    Please use plain text.
    Distinguished Mentor
    thepworth
    Posts: 525
    Registered: ‎03-02-2011

    Re: Bring csv file (with additional attributes) into Map

    05-14-2012 12:58 PM in reply to: neilyj

    I also only have 32 bit office.

     

    What I had to do was to uninstall office, install the 64-bit Access driver, reinstall 32-bit office over the 64-bit driver - you can't update the driver with 32-bit office on the machine.

     

    Then use a named range in excel - this is critical.

     

    Worked for me only after upgrading to 2012 - wouldn't work with C3D 2011 for ODBC to excel.

     

    HTH!


    C3D 2011
    Intel Xeon E5630@2.53Ghz
    NVIDA Quadro NVS420 Dual Monitor
    12GB Ram / Win7 Professional 64bit SP1
    Please use plain text.
    *Expert Elite*
    Murph
    Posts: 1,584
    Registered: ‎11-13-2006

    Re: Bring csv file (with additional attributes) into Map

    05-14-2012 02:59 PM in reply to: neilyj

    neilyj wrote:

    I found this post which describes exactly what I want to do to get data into Map http://map3d.wordpress.com/2008/01/02/bring-a-csv-file-into-map-3d-with-data/ but I get stuck almost at the first hurdle (see screenshot).

     

    Isn't there any easier way to get this data into Map??

     

    Thanks


    Yes with the newer version (2010 and up) Use the Mapimport and select the ASCII format, You may need to edit the CVS file a bit but that's one way with out ODBC.

    Murph
    Supportting the troops daily.
    Please use plain text.
    *Expert Elite*
    neilyj
    Posts: 2,672
    Registered: ‎08-01-2008

    Re: Bring csv file (with additional attributes) into Map

    05-15-2012 02:30 AM in reply to: Murph

    Thanks for this but when I try the ASCII file, there doesn't seem to be an option to change the input fields....

    neilyj
    (No connection with Autodesk other than using the products in the real world)


    IDSP Premium 2014, Civil 3D 2013 (UKIE) Hotfix 3; Win 7 Pro x64
    256Gb SSD, 300Gb 15,000 rpm HDD
    16Gb Ram Intel Xeon CPU E5-1607 0 @ 3.00GHz (4 CPUs), ~3.0GHz
    NVIDIA Quadro 4000, Dual 27" Monitor, Dell T3600
    Please use plain text.
    *Expert Elite*
    Murph
    Posts: 1,584
    Registered: ‎11-13-2006

    Re: Bring csv file (with additional attributes) into Map

    05-15-2012 05:14 AM in reply to: neilyj

    Neilyj, If you have C3D why not just use the Civil3D opint import tools and create the format you need? Once you import the the cvs as points do a export to Geospatial of that point group to SDF format.

    Can you attach a few lines of the CVS file?

    Murph
    Supportting the troops daily.
    Please use plain text.