topic Re: Bring csv file (with additional attributes) into Map in AutoCAD Map 3D Forum

Bring csv file (with additional attributes) into Map

neilyj666 — Mon, 14 May 2012 07:47:00 GMT

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

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

parkr4st — Mon, 14 May 2012 09:12:29 GMT

search this forum for 64 bit odbc.

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

Anonymous — Mon, 14 May 2012 16:18:39 GMT

Hola creo que este link te puede ayudar http://usa.autodesk.com/adsk/servlet/ps/dl/item?siteID=123112&id=18307898&linkID=9240697

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

Anonymous — Mon, 14 May 2012 18:01:26 GMT

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.

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

neilyj666 — Mon, 14 May 2012 19:52:53 GMT

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

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

neilyj666 — Mon, 14 May 2012 19:55:04 GMT

@Anonymous 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....

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

Anonymous — Mon, 14 May 2012 19:58:47 GMT

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!

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

Murph_Map — Mon, 14 May 2012 21:59:18 GMT

@neilyj666 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.

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

neilyj666 — Tue, 15 May 2012 09:30:53 GMT

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

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

Murph_Map — Tue, 15 May 2012 12:14:02 GMT

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?

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

neilyj666 — Tue, 15 May 2012 12:27:44 GMT

I have tried this and the additional attributes are visible in C3D but the SDF export seems to ignore them. The lines below show the data I am tryingto work with - there are more fields in the full dataset but these are the main ones of interest at the moment

#Pt	E	N	Name	Description	Region
1	278200	647200	Canderigg	Lochhead/Broomfield	Sth. Lanarks
2	279100	648700	Woodside Colliery		Sth. Lanarks
3	297900	689000	Bogside Mine		West Fife
4	347300	709200	Highham Farm	Radernie	East Fife
5	280000	645700	East Draffan		Sth. Lanarks

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

Murph_Map — Tue, 15 May 2012 12:46:00 GMT

@neilyj666 wrote:
I have tried this and the additional attributes are visible in C3D but the SDF export seems to ignore them. The lines below show the data I am tryingto work with - there are more fields in the full dataset but these are the main ones of interest at the moment

#Pt E N Name Description Region
1 278200 647200 Canderigg Lochhead/Broomfield Sth. Lanarks
2 279100 648700 Woodside Colliery Sth. Lanarks
3 297900 689000 Bogside Mine West Fife
4 347300 709200 Highham Farm Radernie East Fife
5 280000 645700 East Draffan Sth. Lanarks

I'll tinker with it later today, got some boats engines to get running first. 🙂

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

Anonymous — Tue, 15 May 2012 14:19:09 GMT

Neily,

I was able to connect to your data via FDO ODBC to Excel.

I've got the current 64-bit Access ODBC driver and 32-bit Office 2007.

From Excel - highlight all of your data & set up a "named range"

From the ODBC data sources in Control Panel, Create a DSN to the Excel workbook.

From Data Connect in Map/C3D, select the DSN from a FDO to ODBC.

You should see the named range & X/Y/Z columns - select your easting & northing & points should come into the workspace.

Update if you need more help... I didn't have to modify anything you posted regarding characters...

Best of Luck!

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

neilyj666 — Tue, 15 May 2012 14:26:09 GMT

Thanks for trying the odbc method - but this will mean an uninstall and reinstall of office 2007 which I'd prefer to avoid if at all possible

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

Anonymous — Tue, 15 May 2012 14:30:16 GMT

You are correct. However, when I uninstalled Office I was prepared with backing up all of my email/info to a .pst and thought I'd have to reload all of my messages/notes/calendar from it. Turned out not to be the case - everything was "as-is" prior to the installation. Dunno if this is because we're on a MS Exchange server, or if some of the settings are retained in the registry (or elsewhere) even with the uninstall (maybe uninstall not complete/clean???) Won't promise it would be the same for you, but was less painful that monkeying around with a VM..... the only other alternative I could think of for you.

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

Anonymous — Wed, 13 Jun 2012 15:26:22 GMT

1. Get your pure data

2. Insert the data to your favorite spreadsheet (in this description I use Microsoft Excel)

3. Save your pure data to the CSV file called CSV (Comma delimited) but notice that you get a semicolon separator ( ; )

4. Create a new Point File Format in Autodesk Civil 3D and call it e.g. PEN(semicolon) with settings:
- Default file extension .csv
- Comment Tag #
- Format options Delimited by ;

5. Import the points to Autodesk Civil 3D from your CSV file

6. Choose Output and Export Civil Object to SDF Set your coordinate system in this example Arbitrary X-Y Coordinates (XY-BC) is used

7. Change the workspace to Autodesk Map 3D (Planning and Analysis)

8. Type a MAPWSPACE command and choose On

9. Connect to the SDF file

10. Choose Points data from Civil_Schema and press Add to Map
11. The Data Table is empty

12. Export Layer Data to SQLite

13. Open the Mozilla Firefox browser
14. Install Extension called SQLite Manager from Mozilla Add-Ons
15. From the Mozilla Firefox browser choose Web Developer and open SQLite Manager

16. Open the SQLite Points base exported by Autodesk Map 3D

17. Open the table called Points, select Stucture and copy the statement (mentioned below) to the notepad for future reuse in next steps:

CREATE TABLE "Points" ("Autogenerated_SDF_ID" INTEGER PRIMARY KEY, "Geometry" BLOB, "Name" TEXT, "Description" TEXT, "RawDescription" TEXT, "Number" INTEGER, "Elevation" REAL, "Latitude" TEXT, "Longitude" TEXT)

18. Select Points, choose Export Table and export the data to the CSV file Select the checkboxes: First row contains column names and Fields separated by Semicolon ( ; )

19. Select the exported Points table and delete it

20. Open the exported Points table form the CSV file format in Microsoft Excel

21. Change the column names and copy your data to these empty columns from the pure data CSV file

22. Save the edited CSV file as the CSV format file

23. Go back to SQLite Manager and import the edited CSV file
- Select First row containing column names
- Select Fields separated by Semicolon ( ; )

24. Set types of data for all columns from the information that you have saved in the notepad:
Autogenerated_SDF_ID -> INTEGER
Geometry - > BLOB
Name - > TEXT
… etc.

25. Save and Close SQLite Manager

26. Go Back to Autodesk Map 3D and connect to the re-edited SQLite database
27. Select Points and Add to Map

28. Finally you will get your points from Civil 3D with data from the CSV table, other words you have just inserted all pure data

If you check the result - geometry matches the description.

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

neilyj666 — Wed, 13 Jun 2012 15:43:36 GMT

CivilFF - Thanks for taking the time to produce the instructions and screen shots, I'll give it a try and see if I can get it to work.

Incidentally, it seems like we have to jump through several hoops to get any useful data exchange between Map and C3D - it really shouldn't be this involved should it??

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

neilyj666 — Fri, 15 Jun 2012 09:10:10 GMT

Just worked through this and it worked like a charm - it's not a procedure you just stumble upon though....!!!!