Cogo point insert from excel not removing previous inserted cogo points

Civil3D
1

I have two questions maybe some could explain why this sample graph throws a warning, and also why it inserts additional cogo points when run more than once.

  1. while using dynamo to do the same station offset task using a block, dynamo seems to track the number of objects inserted. if I remove or add a station offset value in the excel file, the object is removed or added to the drawing when the graph is run again. why doesn’t this happen with cogo points?
    the graph keeps inserting more points every time the graph is run.

  2. The sample inserts the cogo points into the drawing at the correct location and layer, but it throws a warning einvalidinput ? could not find reason seeing it’s inserting the pointCogoPoints by station offset-from-excel.xlsx (10.0 KB)
    CogoPoints by station offset-from-excel.dyn (58.2 KB)
    s.

Thank you

2

It is inserting the COGO points, but the layer actually isn’t correct. If you check the layer for each COGO point they are actually inserted on layer 0. This is because the string for the layer name includes quotation marks, which is invalid for a layer name and hence the eInvalidInput error.

Capture
Capture1113×509 33.2 KB

So just remove the quotation marks and it will work! If the layer name was in a Code Block instead of a String node, then the quotation marks would need to stay.

The above change to the layer name should fix this problem as well.

1 Like
3

mzjensen,

Thanks, I looked at this for an hour or more and couldn’t find the error. I check help and some other places with no luck. and it did fix the object tracking!

Still very new to this, looking to find ways to use it in our dwg production.

Thank you

4

mzjensen,

One other question if you have time. To take this one more step I added point style and point label style, but the style don’t update the points in the dwg. The graph doesn’t throw an error, and the node list shows the correctly for point style and point label styles from excel.

Any hits are welcome.

Thank you,CogoPoints by station offset-AND-STYLES-from-excel.dwg (1.0 MB)
CogoPoints by station offset-AND-STYLES-from-excel.xlsx (10.2 KB)
CogoPoints by station offset-AND-STYLES-from-excel.dyn (89.1 KB)

5

All,
Had some time to get back to this. I found part of the reason the point style were inserting the correct symbol. The text name did not match the text case in the civil 3D drawing. I had upper case text and the drawing had lower case.

The second issue, which I still can’t figure out is: the point label style is not updating. I checked the style name in the drawing matches the excel file. any ideas

Thank you

CogoPoints by station offset-AND-STYLES-from-excel.xlsx (10.2 KB)
CogoPoints by station offset-AND-STYLES-from-excel.dwg (1.0 MB)
CogoPoints by station offset-AND-STYLES-from-excel.dyn (89.1 KB)

6

Seems to work fine for me. Maybe try and update your toolkit version?

7

KirkWM,

For some reason it doesn’t seem to be updating my version. I’ll try later in the day.
It is pacing the correct blocks with the points, its the point label style is not working. I did a test with the point label styles all being the same, it worked. then I changed a few in the list and then it didn’t work.

Thank you for your help, I’ll keep looking.