how to create a profile from text file

[yemigere]

hello there! when i am trying to create a profile from a text file it will appear as the picture i uploaded below in the panorama view...what do you think is the mistake i did and what should i do? 

thanks in advance!

[m.mitic]

maybe this could help

https://knowledge.autodesk.com/support/civil-3d/learn-explore/caas/CloudHelp/cloudhelp/2017/ENU/Civi...

[Jeew-m]

Check your first row and last row.

It should contain only 2 readings (station and elevation) - Refer to the attached link by @m.mitic.

[yemigere]

that really helped me to solve the problem but again I am facing a problem ….I have attached what I found in the panorama view .....your suggestions will help me a lot.

[m.mitic]

pay attention to this, it can be a common problem when switching from excel to txt

in row data are divided by "space" not "tab"

[m.mitic]

can you attach your txt file?

[yemigere]

yes of course... here is it..

[m.mitic]

this is what i found

62583.274 2541.346 80
62642.93 2534.188   the order of stationations is wrong

62640 2534.188       the order of stationations is wrong
62868.339 2506.791 100
62983.932 2499.884 90
63141.182 2481.471 60
63359.646 2460.667 140
63679.905 2465.42 190
63917.005 2440.1983        the order of stationations is wrong
63715.28 2460.509           the order of stationations is wrong
63720 2460.509
63684.621 2465.42           the order of stationations is wrong
63917.005 2440.7 160
64117.655 2434.33 120
64361.129 2435.668

you need to check the whole file

[yemigere]

Oh thank you so much i will check it!

[yemigere]

depending on your suggestions I have checked all my data, …first I re-ordered it to ascending order then deleted the repeated stations because of station equation and also deleted the first and last rows curve data...but still the panorama window shows message 'input file has invalid geometry' and I don't really get what the problem with my data is .....so can we say that the vertical alignment data is incorrect? if so, how could it be corrected? I have attached my final data  below.

thanks in advance

[m.mitic · Accepted solution]

63917.005

64638.715

80870.001

in these places there are duplicate stations with different heights which implies a vertical profile layout part,  

civil 3d does not allow vertical lines when creating profile layout

[ivs_gopal]

HI 

IN YOUR TEXT FILE THERE IS A SMALL GAP BETWEEN CHAINAGE AND ELEVATION, PLEASE CHECK