AutoCAD Map 3D General Discussion

AutoCAD Map 3D General Discussion

Reply
*Expert Elite*
neilyj
Posts: 3,748
Registered: ‎08-01-2008
Message 1 of 18 (680 Views)
Accepted Solution

Bring csv file (with additional attributes) into Map

680 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 2015 (mainly Civil 3D 2015 UKIE & Infraworks with some limited 3ds Max Design)
Win 7 Pro x64, 240Gb SSD, 1Tb HDD
32Gb Ram Intel Xeon CPU E5-2650 v2 @ 2.6GHz (32 CPUs), ~2.6GHz
NVIDIA Quadro K4000, Dual 27" Monitor, Dell T5610
Valued Mentor
parkr4st
Posts: 449
Registered: ‎03-24-2004
Message 2 of 18 (672 Views)

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. 

New Member
jimyquick
Posts: 1
Registered: ‎06-29-2010
Message 3 of 18 (654 Views)

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

05-14-2012 09:18 AM in reply to: neilyj
Distinguished Mentor
thepworth
Posts: 525
Registered: ‎03-02-2011
Message 4 of 18 (646 Views)

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
*Expert Elite*
neilyj
Posts: 3,748
Registered: ‎08-01-2008
Message 5 of 18 (641 Views)

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 2015 (mainly Civil 3D 2015 UKIE & Infraworks with some limited 3ds Max Design)
Win 7 Pro x64, 240Gb SSD, 1Tb HDD
32Gb Ram Intel Xeon CPU E5-2650 v2 @ 2.6GHz (32 CPUs), ~2.6GHz
NVIDIA Quadro K4000, Dual 27" Monitor, Dell T5610
*Expert Elite*
neilyj
Posts: 3,748
Registered: ‎08-01-2008
Message 6 of 18 (638 Views)

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 2015 (mainly Civil 3D 2015 UKIE & Infraworks with some limited 3ds Max Design)
Win 7 Pro x64, 240Gb SSD, 1Tb HDD
32Gb Ram Intel Xeon CPU E5-2650 v2 @ 2.6GHz (32 CPUs), ~2.6GHz
NVIDIA Quadro K4000, Dual 27" Monitor, Dell T5610
Distinguished Mentor
thepworth
Posts: 525
Registered: ‎03-02-2011
Message 7 of 18 (635 Views)

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
*Expert Elite*
Murph
Posts: 1,954
Registered: ‎11-13-2006
Message 8 of 18 (630 Views)

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.
*Expert Elite*
neilyj
Posts: 3,748
Registered: ‎08-01-2008
Message 9 of 18 (619 Views)

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 2015 (mainly Civil 3D 2015 UKIE & Infraworks with some limited 3ds Max Design)
Win 7 Pro x64, 240Gb SSD, 1Tb HDD
32Gb Ram Intel Xeon CPU E5-2650 v2 @ 2.6GHz (32 CPUs), ~2.6GHz
NVIDIA Quadro K4000, Dual 27" Monitor, Dell T5610
*Expert Elite*
Murph
Posts: 1,954
Registered: ‎11-13-2006
Message 10 of 18 (608 Views)

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.
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 or visit the Installation and Licensing Forum to get help installing your software.