Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.

Bring excel points into map with data attached

Anonymous

Bring excel points into map with data attached

Anonymous
Not applicable

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!

0 Likes
Reply
1,144 Views
12 Replies
Replies (12)

Pointdump
Mentor
Mentor

DC,

 

Welcome to the Autodesk Forums!

 

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

 

Dave

Dave Stoll
Las Vegas, Nevada

EESignature

64GB DDR4 2400MHz ECC SoDIMM / 1TB SSD
NVIDIA Quadro P5000 16GB
Windows 10 Pro 64 / Civil 3D 2024
0 Likes

Anonymous
Not applicable
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
0 Likes

Pointdump
Mentor
Mentor

DC,

 

I don't see any attachment.

 

Dave

Dave Stoll
Las Vegas, Nevada

EESignature

64GB DDR4 2400MHz ECC SoDIMM / 1TB SSD
NVIDIA Quadro P5000 16GB
Windows 10 Pro 64 / Civil 3D 2024
0 Likes

Anonymous
Not applicable

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

 

0 Likes

Anonymous
Not applicable
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
0 Likes

Anonymous
Not applicable

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

0 Likes

Pointdump
Mentor
Mentor

Travis,

 

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

 

Dave

Dave Stoll
Las Vegas, Nevada

EESignature

64GB DDR4 2400MHz ECC SoDIMM / 1TB SSD
NVIDIA Quadro P5000 16GB
Windows 10 Pro 64 / Civil 3D 2024
0 Likes

CADaSchtroumpf
Advisor
Advisor

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.

0 Likes

Anonymous
Not applicable
Here is a small sample of the spreadsheet. Thanks.
0 Likes

Pointdump
Mentor
Mentor

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

Dave Stoll
Las Vegas, Nevada

EESignature

64GB DDR4 2400MHz ECC SoDIMM / 1TB SSD
NVIDIA Quadro P5000 16GB
Windows 10 Pro 64 / Civil 3D 2024
0 Likes

Anonymous
Not applicable
I'll try again with a zipped file.



Thanks Dave!
0 Likes

Pointdump
Mentor
Mentor

Travis,

 

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

 

AZ-WIF_6.png

 

Dave

Dave Stoll
Las Vegas, Nevada

EESignature

64GB DDR4 2400MHz ECC SoDIMM / 1TB SSD
NVIDIA Quadro P5000 16GB
Windows 10 Pro 64 / Civil 3D 2024