AutoCAD Civil 3D General Discussion

AutoCAD Civil 3D General Discussion

Reply
Active Contributor
Bubba1925
Posts: 42
Registered: ‎03-05-2010
Message 1 of 8 (1,344 Views)
Accepted Solution

Import superelevation criteria from a spreadsheet in C3D2010?

1344 Views, 7 Replies
06-16-2010 12:49 PM

I've had to change the stationing of an alignment (station equation was not an option). Before doing so, I copied all of my alignment properties' superelevation tab table data to a spreadsheet. I can manipulate the key stations in excel. The spreadheet is loaded with all the inside/outside lane and shoulder slope data as well. Is there any way I can paste/import this data back into the alignment properties???? Thanks.

Hi Bubba1925-

 

This was actually functionality added with the Subscription Advantage Pack for Civil 3D 2010. From the Subscription Advantage Pack HELP file:

 

"The Subscription Advantage Pack for AutoCAD Civil 3D enables you to import superelevation data from either a CSV or XML file."

 

I have also attached a screen shot of the Superelevation Tab in Alignment Properties. The Subscription Advanatge Pack is available on the Subscription Center for download.

 

Hope this helps!

Product Support
SethHall
Posts: 723
Registered: ‎02-08-2010
Message 2 of 8 (1,334 Views)

Re: Import superelevation criteria from a spreadsheet in C3D2010?

06-16-2010 01:11 PM in reply to: Bubba1925

Hi Bubba1925-

 

This was actually functionality added with the Subscription Advantage Pack for Civil 3D 2010. From the Subscription Advantage Pack HELP file:

 

"The Subscription Advantage Pack for AutoCAD Civil 3D enables you to import superelevation data from either a CSV or XML file."

 

I have also attached a screen shot of the Superelevation Tab in Alignment Properties. The Subscription Advanatge Pack is available on the Subscription Center for download.

 

Hope this helps!



Seth Hall
Product Support
GCSO - CSS - FTS
Autodesk, Inc.


Being Civil
Being Civil Twitter
Being Civil Facebook







Active Contributor
Bubba1925
Posts: 42
Registered: ‎03-05-2010
Message 3 of 8 (1,294 Views)

Re: Import superelevation criteria from a spreadsheet in C3D2010?

06-17-2010 05:45 AM in reply to: SethHall

Thats great Seth! I'm going to see if we can get that, it will save a lot of time. Thanks!

Valued Contributor
c3dlearner
Posts: 81
Registered: ‎11-23-2007
Message 4 of 8 (1,266 Views)

Re: Import superelevation criteria from a spreadsheet in C3D2010?

06-18-2010 11:42 AM in reply to: Bubba1925

Hi Seth,

Do you mind posting and example CSV file?

 

Thanks

C3DL

Product Support
SethHall
Posts: 723
Registered: ‎02-08-2010
Message 5 of 8 (1,259 Views)

Re: Import superelevation criteria from a spreadsheet in C3D2010?

06-18-2010 12:14 PM in reply to: c3dlearner

Hi c3dlearner-

 

I took a look at the example files that ship with Civil 3D, but it doesn't look like I have any to post. Maybe someone else has an example file they wouldn't mind sharing, or possibly do what Bubba1925 did and create your own from an alignment you have already designed.

 

Thanks!



Seth Hall
Product Support
GCSO - CSS - FTS
Autodesk, Inc.


Being Civil
Being Civil Twitter
Being Civil Facebook







Active Contributor
Bubba1925
Posts: 42
Registered: ‎03-05-2010
Message 6 of 8 (1,222 Views)

Re: Import superelevation criteria from a spreadsheet in C3D2010?

06-21-2010 06:07 AM in reply to: c3dlearner

Attached is my successful .csv. It took me several hours to get one right; copying it out of another alignment and pasting results in extran, hidden, and out of order columns in excel (???). You gotta arrange to match what you see in the alignment properties, super tab, then you gotta remove special symbols like "+", ', and %. you need a column at the end (curve smoothing or something like that, I don't have it in front of me) - mine is all zeros.

 

I tried exporting the old align w/ supers to xml, then import xml - nothing happened so I'm not sure how that works.

Active Contributor
Bubba1925
Posts: 42
Registered: ‎03-05-2010
Message 7 of 8 (1,212 Views)

Re: Import superelevation criteria from a spreadsheet in C3D2010?

06-21-2010 10:45 AM in reply to: Bubba1925

after looking at my sections and seeing something wrong with the shoulders, i realized the following whacky situation occurs upon input:

 

the column of data for right outside shoulder gets inserted into the column of data in the alignment properties superelevation tab for right inside shoulder AND, the data for right inside shoulder gets inserted into the column of data in the alignment properties superelevation tab for right outside shoulder

 

I fixed this by swapping the data to the "wrong" columuns in Excel, then they go into the "right" columns in the spreadsheet! The wires got crossed somehow.

Valued Contributor
c3dlearner
Posts: 81
Registered: ‎11-23-2007
Message 8 of 8 (1,191 Views)

Re: Import superelevation criteria from a spreadsheet in C3D2010?

06-22-2010 07:36 AM in reply to: Bubba1925

Thanks Bubba

Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Announcements
Are You Going To Be @ AU 2014? Feel free to drop by our AU topic post and share your plans, plug a class that you're teaching, or simply check out who else from the community might be in attendance. Ohh and don't forgot to stop by the Autodesk Help | Learn | Collaborate booths in the Exhibit Hall and meet our community team if you get a chance!