AutoCAD Civil 3D General Discussion

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

Import superelevation criteria from a spreadsheet in C3D2010?

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

Product Support
SethHall
Posts: 723
Registered: ‎02-08-2010
Message 2 of 8 (1,259 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,219 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,191 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,184 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,147 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,137 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,116 Views)

Re: Import superelevation criteria from a spreadsheet in C3D2010?

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

Thanks Bubba

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

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 to get help installing your software.

Ask the Community


Civil 3D Exchange Apps

Created by the community for the community, Autodesk Exchange Apps for AutoCAD Civil 3D helps you achieve greater speed, accuracy, and automation from concept to manufacturing.

Connect with Civil 3D

Twitter

Facebook

Blogs