A while ago, I was working on a project where the client gave us some .dwg files of the catenary as-built layouts. The pole parameters were just text boxes arranged in a certain order. There were like 50 sheets and 40 poles per sheet. That's a lot of text boxes!
😱I don't know about you, but I hate typing tables manually. It's so tedious and error-prone.
😩So, I decided to write a little script in Dynamo that does all the work for me. It collects and organizes the data into a table format (rows for poles, columns for OCS parameters) and creates .csv files for each sheet. Then, I can use PowerQuery to merge all the files into one big Excel table (that's what I did) or use some other tool to aggregate them.
This way, I can easily work with the as-built data: analyze it, check it, calculate it, count it. You name it, I can do it.
💯Sounds awesome, right? Well, it is! And I'm feeling generous today, so I'm going to share my #script with you. You're welcome.
😊Below, you can watch a short video of how the script works, and also download the files from this link. Use it, improve it, save your time.
😉
