AutoCAD Map 3D General Discussion

AutoCAD Map 3D General Discussion

Reply
Valued Contributor
davidm
Posts: 54
Registered: ‎05-22-2008
Message 1 of 7 (425 Views)

Import data from files

425 Views, 6 Replies
01-29-2013 09:57 AM

I want to import a csv file into map3D and set the layers to which the blocks with attributes are inserted on. I've found in the help guide that using

Click Home tab > Data panel > Import From Files > mapimport.

Problem is, when I do this, I do not get the dialog that the help file says I should, like a place to define an insert layer or schema. All I get is the plain dialog that asks for formatting (file format such as autodesk uploadable file), Z unit, Coordinate system, and create block.

 

I also want to export the attribute data into a survey point file.

*Expert Elite*
antoniovinci
Posts: 1,700
Registered: ‎06-03-2011
Message 2 of 7 (421 Views)

Re: Import data from files

01-29-2013 10:44 AM in reply to: davidm

It behaves so, because you must declare how your .CSV is formatted, i.e. what's the meaning of the fields.

Please copy and paste here a couple of .CSV lines, thx.

Valued Contributor
davidm
Posts: 54
Registered: ‎05-22-2008
Message 3 of 7 (416 Views)

Re: Import data from files

01-29-2013 12:29 PM in reply to: antoniovinci

This is from the help file

In the table, you can specify properties for each input layer (sometimes called a schema, level, or file).

To import an input layer, select its check box. To change other settings for an input layer, click in the field to change. Click the down arrow to choose from a list of choices, or click for additional choices.

To sort on a specific column, right-click the column heading. Click Sort Ascending or Sort Descending.

 

see dialog box,jpg attached nothing like this shows up on my dialog box

 

here is the first few lines of the csv file.(point number, Northing, Easting, elevation, description)

 

121913436526767471.9744.667curb cut
122113436525767499.7744.605curb
122213436524767521.2744.54curb
122313436525767526.5744.501curb
122413436525767529744.382

St Drain

Valued Contributor
davidm
Posts: 54
Registered: ‎05-22-2008
Message 4 of 7 (407 Views)

Re: Import data from files

01-29-2013 01:24 PM in reply to: davidm

Maybe to simplify things I'll explain what I'm really trying to do.

I have GPS data in a CSV file. I want to import that data into map so that I have a block with attribute info. I also want that block to be on seperate layers based on the description, so all the curb shots are on layer curb, etc... this will allow me to insert my blocks - like catchbasins and manholes - and connect the points between relevant features.like curbs and edge of bit.

 

I've been able to import the blocks, but not on specific layers. I've also brought the points in via a survey data store which I like because the data is in a table, but I do not like the formatting of the data having to use the style tool, there is no real seperation.

Mentor
Robert_Fritz
Posts: 170
Registered: ‎12-08-2011
Message 5 of 7 (394 Views)

Re: Import data from files

01-29-2013 11:23 PM in reply to: davidm

Hi,

 

not sure if that helps. When you import a SHP file you can put import data on different layers depending on an attribute in the import data set. This option doesn't seem to be available when importing CSV files.

 

Have a look at the SHP import - the import dialog box has an option called "drawing layer" (or something similar) - clicking on it opens a new dialog box where you can specifiy which data goes where.

 

If that helps you would need to convert your CSV file into a SHP file (or any other import file format Map can process via mapimport). I suppose there a free tools available for that.

 

Rob

http://raumpatrouille3d.blogspot.ch/
Valued Contributor
davidm
Posts: 54
Registered: ‎05-22-2008
Message 6 of 7 (367 Views)

Re: Import data from files

01-31-2013 05:24 AM in reply to: Robert_Fritz

I don't know if i can convert a CSV file to a SHP file.

 

I'm very frustrated, I would think importing GPS points into a GIS program would be much more refined.

Mentor
Robert_Fritz
Posts: 170
Registered: ‎12-08-2011
Message 7 of 7 (364 Views)

Re: Import data from files

01-31-2013 05:51 AM in reply to: davidm

low frustration level? Get used to the shortcomings of Map as it is mainly a CAD with additional GIS functionality.

But it is quite flexible if you are willing to work around things.

with regards to CSV to Shp: https://www.google.de/search?q=convert+csv+to+shp

 

good luck

http://raumpatrouille3d.blogspot.ch/
Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Need installation help?

Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.