Hii
Anyone one can help me....
How i can export MicroStation line length and coordinates from line properties geometry data to Excel.
Or full data extract into in excel from microstation element properties.
Regards,
Ankit Sharma (India)
Ankit Sharma said:How i can export MicroStation line length and coordinates from line properties geometry data to Excel
Write a Report!
Here's a step-by-step guide to creating a linear report.
Probably a VBA macro is your best bet. Use VBA to scan a model to acquire line elements, then write the desired information to a CSV file. Here's an example macro that exports line coordinates. It's freeware and works with both CONNECT and V8...
Regards, Jon Summers LA Solutions
From this VBA directly line length is not coming in excal and it is not considering the intermediate point (Node point) of the any straight line.
You can check of the screen shot which I want in the excel in red highlighted full data with each line element of my work file MicroStation.
Can I get length in two part like microstation is showing in two part of length.
Is there any VBA to export all data which is highlighted in the attached Picture of MicroStation properties.
So you do not want the length of a line, like you said in your original post? You want the length of each segment of a line string?Please be specific about what you want.
You can write a VBA to get all that information. You can probably edit the one presented above as freeware to find the information you are looking for. You may need to research how to iterate segments for a line string. There is a programming forum where you can ask questions about your code (but not asking people to write it for you).
You can also look into learning how to generate a report.
MaryB
Power GeoPak 08.11.09.918Power InRoads 08.11.09.918OpenRoads Designer 2021 R2
MaryB said:You can also look into learning how to generate a report
You can also engage a VBA programmer to write code for you. That, of course, comes at a price.
Hi Ankit,Might be worth looking into GenerativeComponents. It can export the data you need in a few nodes.You could then just reference in any file and it would export the data for you. Here is a line string tree that I have exported to excel, showing the lengths and each pole of the linestring.
ThanksWayne
Wayne Dickerson said:Might be worth looking into GenerativeComponents
Ankit Sharma said:I don't understand about this script
Ankit Sharma, you originally posted your question about MicroStation V8i in a building Forum. Wayne Dickerson made the reasonable assumption that you have installed a Bentley building product that also delivers Generative Components. Subsequently, a Forum moderator moved your post to this MicroStation Forum.
Your confusion, Ankit, shows the importance of stating precisely the product you are using (MicroStation V8i) in your post, and posting to the relevant Forum.
Ankit Sharma said:The above written not working in the VBA
Generative Components (GC) and VBA are two very different technologies. GC doesn't work with VBA, and VBA doesn't work with GC. Since you are using plain old MicroStation, the question doesn't apply: you don't have GC.