MARK CHAINAGE AND POINT ON POLYLINE FROM EXCEL DATA

[bilu09]

Hi,

I have a lot of chainages (around 28 kilometers) in the excel file. I need to put that on polyline in Autocad. please find sample attachments for your ready reference and please help. 

[Patchy]

Have you tried google? same question and it marked SOLVED.

[bilu09]

sir

I tried this but did not work for me.

[bilu09]

dear all,

I have attached the original excel file and Autocad version for your reference.  actually, I need to export (Label) all chainages which are in the excel file, to the alignment in the attached Autocad drawing. 

[Patchy]

It works fine for me, I tested it.

[bilu09]

Hi Sir,

Can you upload the CSV File which you converted from excel?

[Patchy]

Is there a secret code in it? ☺

[Pointdump]

Hi @bilu09,
Welcome to the Autodesk Forums.
That Lisp from @CADaSchtroumpf is doubtless genius, but I couldn't get it to work either.

I couldn't figure out what "Reference point of the measure" wanted, and absolutely no clue what "Add-Subtract [+-]?" was asking for, nor what "Reference point of the measure: _endp of" needed.
Dave

[bilu09]

These levels are imported from the profile section through the "VertexExport" lisp. I have attached the lisp.

Still, I can not get points in the cad file.  if you don't mind, can you explain step by step? that will be more clarity for me. sorry for the disturbance.  

[ВeekeeCZ]

Rule number one: AutoCAD only accepts DOTs as decimal delimiters. NEVER commas.

[Patchy]

I would be glad to go thru the steps but your .rar file is bad.

[cadffm]

Perhaps it is time for a newer Software version?

It works on my side, for you - my ZIPed version.

[cadffm]

@Patchy 

The RAR archive is in Format 5.0, I used WinRar 5.20 to extract.

[Patchy]

It extracted and got .fas and I have no idea what to do with it ☺

I'll try later at the office.

[CADaSchtroumpf]

---

@Pointdump  a écrit :

Hi @bilu09,
Welcome to the Autodesk Forums.
That Lisp from @CADaSchtroumpf is doubtless genius, but I couldn't get it to work either.

I couldn't figure out what "Reference point of the measure" wanted, and absolutely no clue what "Add-Subtract [+-]?" was asking for, nor what "Reference point of the measure: _endp of" needed.
Dave

---

@Pointdump 

Thank to quote me.
I have since further improved the lisp which offers even more possibilities.
I am also attaching a very simple example drawing to help you understand the options.

[Patchy]

I used the older .lsp written by CADaSchtroumpf

See post number 15 for the latest.

[Pointdump]

Hi Bruno,
Thank you. After several tries, experimenting with the settings, I finally got the Lisp to set 5 of the 24 points on the list by @bilu09. I mostly got "The length is too large for the object."
Anyway, I kinda understand Reference Point Operator and the "+/-" thing. I still don't understand "Factor to apply at distance? <1.0>:" and "Distances are [Partial/Cumulative]?". Maybe that's why I only got 5 out of 24 points.
Dave

[CADaSchtroumpf]

Dave,
It is important to know the construction direction of the polyline, where is the 1st vertex!. That's why in my basic example I represented the direction with arrows above the polyline.
So the '+' operator will be carried out in the direction of the polyline and the '-' sign in the opposite direction.
The factor to apply to the distance (by default at 1.0) can be useful if for example your drawing unit is in meters, but in the CSV file that we could have provided you with the distances are expressed in centimeters. In this case a factor of 0.01 will be needed to correlate the distances with your units: for example 500cm x 0.01 = 5m.
Cumulative distances are from the origin of the chosen reference point, while partial distances are from the previous point. In the CSV file the values ​​read will be considered as the inter-distances between each point.

So in the case of the 'NEED TO LABEL CHAINAGES' drawing, you have to consider the origin of the reference point at the start of the polyline in the upper part of the screen (This is where the 1st vertex is), choose the '+' operator and the 'Cumulative' option since in the file the data is always increasing from the origin.
I hope that with these explanations, it will be clearer. I thought I provided a fairly explanatory example drawing.
In my defense, I am French and my translations may be approximate.

[Pointdump]

Bruno,
Thank you. That helps to explain the Lisp better. And good job on that Lisp.
Dave

[bilu09]

sir,

sorry for the disturbance. still, I could not work on this. please find attached a screenshot for review.