r/civil3d • u/BigJDoitYoDamnself • 2d ago

Help / Troubleshooting Automatic Keyed Notes

I am using keyed notes with tags and extracted data in Auto cad 27. Really a simple process. I create an excel database of all my keyed notes with description. In the drawing I put in my keyed note Multi leader. The process gets my descriptions from the excel sheet and insert it in the drawing. The issue is the keyed notes will not go in numerical order. it does 1,10,11,12,2,3,4,5. I understand the issue. auto cad reads characters and not numbers. a recommended fix was to put a character in front of the number, C1,C2,C3,C10. Well that did not work. I figured that I would do the extract data and export it as a table, go into excel and sort by the keyed note and then do a data link to my "new" table after its sorted. Anyone else have to deal with this issue. Did you use my planned method which I am 100% sure will work. I kind of hate work arounds and would rather it be automatic than what I am planning.

2 Upvotes

100% Upvoted

4 comments sorted by

2

u/BrokenSocialFilter IT/CAD Manager 2d ago

It's a datatype issue, obviously. A numeric datatype will sort as expected but text won't. You're on the right track with the character prefix but with text datatype it should be a 0 (zero): 01,02...09,10,11. However, if your number of keynotes exceed 99 then you'll have to pad two 0's.

3

u/Cyclekrieg 2d ago

01, 02, etc. is the answer.

2

u/AwesomeTowlie 2d ago

Haven’t tried exactly what OP is doing, but I can confirm adding 0 prefixes generally works.

1

u/BigJDoitYoDamnself 2d ago

Yes it is a data type issue. At first I just had numbers in there, I came back and put a C in front of it. Both failed. My next step is to save the extracted data export as a CSV, make it a new excel sheet and do a data link into the drawing. I can make the data link do exactly what I want it to do, but its a work around which I would like to avoid if possible.