Bring excel points into map with data attached

[Anonymous]

Hello,

I am currently drawing a simple GIS map for a municipality that I work for. I have an excel spreadsheet with GPS points where each record has multiple columns of data with it. I have no problem bringing the points themselves in, but is there a way to bring them in using the XY coordinate columns while keeping rest of data attached to them as attributes?

Thanks!

[Anonymous]

Hello,

I am currently drawing a simple GIS map for a municipality that I work for. I have an excel spreadsheet with GPS points where each record has multiple columns of data with it. I have no problem bringing the points themselves in, but is there a way to bring them in using the XY coordinate columns while keeping rest of data attached to them as attributes?

Thanks!

[Pointdump]

DC,

Welcome to the Autodesk Forums!

Can you post a little sample of your data and the desired Coordinate System?

Dave

[Pointdump]

DC,

Welcome to the Autodesk Forums!

Can you post a little sample of your data and the desired Coordinate System?

Dave

[Anonymous]

This is a small sample of the data that shows the format. I was able to
convert it into a CVS file without any issues, but I'm having a hard time
bringing it into Map 3d for some reason. I'm just looking to insert the
points into a map with a NE83F projection so that they come in at the right
x,y coordinates with all the data attached. Elevation is not an issue at
this point so I just put an elevation of 0.



Thanks

[Anonymous]

This is a small sample of the data that shows the format. I was able to
convert it into a CVS file without any issues, but I'm having a hard time
bringing it into Map 3d for some reason. I'm just looking to insert the
points into a map with a NE83F projection so that they come in at the right
x,y coordinates with all the data attached. Elevation is not an issue at
this point so I just put an elevation of 0.



Thanks

[Pointdump]

DC,

I don't see any attachment.

Dave

[Pointdump]

DC,

I don't see any attachment.

Dave

[Anonymous]

Hi,

(1) you can import ACII file as blocks including a few attributes such as pointnumber.
command: mapimport, choose a import format which includes point number - you might need to copy your import file and re-format it in order to bring it in. Afterwards you can create a link template to link your blocks (pointnumber) to Excel:

http://help.autodesk.com/view/MAP/2017/ENU/?guid=GUID-D2B4295D-7A4B-4911-92C9-551E8E6E6127

(2) import your CSV into Excel, connect to Excel sheet via FDO ODBC in Map and add sheet
(not sure if you can modify data when you connect to Excel via FDO ODBC):
http://help.autodesk.com/view/MAP/2016/ENU/?guid=GUID-EF013ED4-3CF7-4923-8466-4E198B7C9A28

(3) as #2 but after connecting and adding Sheet to Map you export the feature class as SDF (context menu of layer), then you can import the SDF file including all attributes via mapimport, for mapping attributes in SDF file to block attributes you need to create a block with desried block attributes (attribute name as attribute name in SDF file). Or you can import as simple ACPoints and attach attribute data as MapObjectData

All approaches have their pros and cons.

Keep in mind - Office/ODBC and Map:
https://knowledge.autodesk.com/support/autocad-civil-3d/troubleshooting/caas/sfdcarticles/sfdcarticl...

Rob

[Anonymous]

Hi,

(1) you can import ACII file as blocks including a few attributes such as pointnumber.
command: mapimport, choose a import format which includes point number - you might need to copy your import file and re-format it in order to bring it in. Afterwards you can create a link template to link your blocks (pointnumber) to Excel:

http://help.autodesk.com/view/MAP/2017/ENU/?guid=GUID-D2B4295D-7A4B-4911-92C9-551E8E6E6127

(2) import your CSV into Excel, connect to Excel sheet via FDO ODBC in Map and add sheet
(not sure if you can modify data when you connect to Excel via FDO ODBC):
http://help.autodesk.com/view/MAP/2016/ENU/?guid=GUID-EF013ED4-3CF7-4923-8466-4E198B7C9A28

(3) as #2 but after connecting and adding Sheet to Map you export the feature class as SDF (context menu of layer), then you can import the SDF file including all attributes via mapimport, for mapping attributes in SDF file to block attributes you need to create a block with desried block attributes (attribute name as attribute name in SDF file). Or you can import as simple ACPoints and attach attribute data as MapObjectData

All approaches have their pros and cons.

Keep in mind - Office/ODBC and Map:
https://knowledge.autodesk.com/support/autocad-civil-3d/troubleshooting/caas/sfdcarticles/sfdcarticl...

Rob

[Anonymous]

Rob,



Thanks for your reply. I have tried connecting to the Excel spreadsheet via
the FDO ODBC. That would be my preferred method. The issue is that when I
try to connect it asks for a user name and password. I set up my autoCAD and
the only user name and password that I entered throughout the process does
not work. I also tried just hitting "connect" leaving the boxes blank (I
believe I read somewhere that if you did not set up a password that's what
you do). Regardless it gives me an error saying "WARNING: external component
has thrown an error". Any idea what I'm doing wrong? Is this password set up
through autoCAD or through the IT administration on the computer itself?



Thanks,

Travis

[Anonymous]

Rob,



Thanks for your reply. I have tried connecting to the Excel spreadsheet via
the FDO ODBC. That would be my preferred method. The issue is that when I
try to connect it asks for a user name and password. I set up my autoCAD and
the only user name and password that I entered throughout the process does
not work. I also tried just hitting "connect" leaving the boxes blank (I
believe I read somewhere that if you did not set up a password that's what
you do). Regardless it gives me an error saying "WARNING: external component
has thrown an error". Any idea what I'm doing wrong? Is this password set up
through autoCAD or through the IT administration on the computer itself?



Thanks,

Travis

[Anonymous]

Hi Travis,

I have Map 64bit and Office 32 bit installed and cannot test anything related to ODBC. Maybe someone else could help?

Last time I connected to Excel via ODBC is probably 5+ years ago....

Rob

[Anonymous]

Hi Travis,

I have Map 64bit and Office 32 bit installed and cannot test anything related to ODBC. Maybe someone else could help?

Last time I connected to Excel via ODBC is probably 5+ years ago....

Rob

[Pointdump]

Travis,

Can you post that Excel Spreadsheet? I've got an idea, but I need data to test.

Dave

[Pointdump]

Travis,

Can you post that Excel Spreadsheet? I've got an idea, but I need data to test.

Dave

[CADaSchtroumpf]

Hi,

I have posted today on this forum a lisp for import a CSV file (with semi-colon) for Autocad Map , he can be generate automaticly the Object Data.

See if can help you.

[CADaSchtroumpf]

Hi,

I have posted today on this forum a lisp for import a CSV file (with semi-colon) for Autocad Map , he can be generate automaticly the Object Data.

See if can help you.

[Anonymous]

Here is a small sample of the spreadsheet. Thanks.

[Anonymous]

Here is a small sample of the spreadsheet. Thanks.

[Pointdump]

Travis,

I don't see any attachment. Forum should be able to accept either CSV or XLS, but you might try zipping it.

Or worst case, put the text in the body of a message.

Dave

[Pointdump]

Travis,

I don't see any attachment. Forum should be able to accept either CSV or XLS, but you might try zipping it.

Or worst case, put the text in the body of a message.

Dave

[Anonymous]

I'll try again with a zipped file.



Thanks Dave!

[Anonymous]

I'll try again with a zipped file.



Thanks Dave!

[Pointdump]

Travis,

While I'm waiting for your sample file, is this something like what you wanted?

Dave

[Pointdump]

Travis,

While I'm waiting for your sample file, is this something like what you wanted?

Dave