AutoCAD Map 3D General Discussion

AutoCAD Map 3D General Discussion

Reply
*Expert Elite*
neilyj
Posts: 3,788
Registered: ‎08-01-2008
Message 11 of 18 (1,580 Views)

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

05-15-2012 05:26 AM in reply to: Murph

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

 

#PtENNameDescriptionRegion
1278200647200CanderiggLochhead/BroomfieldSth. Lanarks
2279100648700Woodside Colliery Sth. Lanarks
3297900689000Bogside Mine West Fife
4347300709200Highham FarmRadernieEast Fife
5280000645700East Draffan Sth. Lanarks
     
      
      
      
      
      
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,986
Registered: ‎11-13-2006
Message 12 of 18 (1,577 Views)

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

05-15-2012 05:46 AM in reply to: neilyj

neilyj 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

 

#PtENNameDescriptionRegion
1278200647200CanderiggLochhead/BroomfieldSth. Lanarks
2279100648700Woodside Colliery Sth. Lanarks
3297900689000Bogside Mine West Fife
4347300709200Highham FarmRadernieEast Fife
5280000645700East Draffan Sth. Lanarks
     
      
      
      
      
      

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


 

Murph
Supportting the troops daily.
Distinguished Mentor
thepworth
Posts: 525
Registered: ‎03-02-2011
Message 13 of 18 (1,572 Views)

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

05-15-2012 07:19 AM in reply to: neilyj

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!

 


C3D 2011
Intel Xeon E5630@2.53Ghz
NVIDA Quadro NVS420 Dual Monitor
12GB Ram / Win7 Professional 64bit SP1
*Expert Elite*
neilyj
Posts: 3,788
Registered: ‎08-01-2008
Message 14 of 18 (1,569 Views)

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

05-15-2012 07:26 AM in reply to: neilyj
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
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 15 of 18 (1,567 Views)

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

05-15-2012 07:30 AM in reply to: neilyj

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.


C3D 2011
Intel Xeon E5630@2.53Ghz
NVIDA Quadro NVS420 Dual Monitor
12GB Ram / Win7 Professional 64bit SP1
Active Contributor
CivilFF
Posts: 29
Registered: ‎12-22-2010
Message 16 of 18 (1,536 Views)

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

06-13-2012 08:24 AM in reply to: neilyj

1. Get your pure data

1.Pure data.png

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

2.CSV data.png

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

4.CSV file.png

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 ;

3.PEN semicolon.png

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

5.Import CSV.png

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

6.Points in C3D.png

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

7.import SDF.png

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

8.Empty table.png

12. Export Layer Data to SQLite

9.Export SQLite.png

 

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

10. sqlite manager.png

 

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

11. open sqlite.png

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)

12.copy statement.png

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 ( ; )

13. export table.png

19. Select the exported Points table and delete it

16.drop table.png

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

14.open points csv.png

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

15. change data.png

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 ( ; )

17.import.png

 

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.


18. set data type.png

25. Save and Close SQLite Manager

19.check data.png

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

20.import sqlite.png

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

21. data from sqlite.png

If you check the result - geometry matches the description.

22.check.png

Regards,
CivilFF
www.civilfastforward.com
*Expert Elite*
neilyj
Posts: 3,788
Registered: ‎08-01-2008
Message 17 of 18 (1,529 Views)

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

06-13-2012 08:43 AM in reply to: CivilFF

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??

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,788
Registered: ‎08-01-2008
Message 18 of 18 (1,502 Views)

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

06-15-2012 02:10 AM in reply to: CivilFF

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

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