SELECTSIMILAR disregards SELECTSIMILARMODE settings
Hi,
I have thousands of points imported from CSV into my DWG. I imported them with a Name attribute, as they need to be color coded according to the variable in the Name. Name is the only variable selected in the property window when I type SELECTSIMILAR > SE, however when I SELECTSIMILAR on any of the imported points, all imported points are selected regardless of what their name attribute contains.
I've also deselected all options in the SE property window with the same results- it still selects everything. Points only don't get selected if they're on a different layer, even though the layer option is deselected in the SELECTSIMILAR > SE properties window.
Is there some other variable setting driving what SELECTSIMILAR filters for similarity, or is this a bug that needs to be submitted for?
Comments
-
I would go back a step and look at improving your import points, yes that is built in to many programs to do what you want layer etc by point name.
You can read say a CSV get XYZ and name then use a look up for the "name" so put on correct layer or set color.
Post a sample file with a few points don't need thousands.
In civil software the reading of points would include stringing points by name.
0 -
If you have BricsCAD Pro or greater, then I would investigate using CIVILPOINTs. These entities include the option to for grouping.
0 -
Thank you for your replies. Uploaded a sample file (saved as XLS as this forum doesn't allow CSV uploads). Imported into BricsCAD as "NameENZD (comma delimited)"
Am running BricsCAD Pro and tried CIVILPOINTS — when attempting to group with CIVILPOINTSGROUP by Raw Description (color), it returns no points. When attempting to group by Name, it returns all points in the selection regardless of Name match.
Edit: to make things weirder, if I filter for "does not contain" for either Name or Raw description, it does return all other points that don't fit a given name or color- but that's not particularly useful.
0 -
Using DATAEXTRACTION on these points, I've found that each point contains two Name fields— All points contain a Name field populated with "BsysCvDbPoint" which seems to be what SELECTSIMILAR is picking up, as well as my Name field that I attribute on import. I suppose that answers why all points are selected when I SELECTSIMILAR with the Name filter on, but it doesn't get me closer to a solution to this issue
0 -
1st step is rearrange the excel file new Column A has 1 2 3 etc for point number, column B moved to column F, Column B removed.
Using the civil points is way to go but need to make a library of the point descriptions so point properties are set correct so need an entry for each color.
I use CIVIL SITE DESIGN under Bricscad so have not used CIVILPOINTS. It has a point Library that you fill in.
Some one may explain more how to set up Civilpoints. Found this will explore more. Yes got points in using PENZD, need to work out filters.
Anyway try this
(defun imppts ( / lst plst col)
; thanks Lee-mac for this defun
(defun csv->lst ( str / pos )
(if (setq pos (vl-string-position 44 str))
(cons (substr str 1 pos) (csv->lst (substr str (+ pos 2))))
(list str)
)
)(setq lst '())
(setq fo (open (setq csv (getfiled "Select CSV File" "" "csv" 16)) "R"))
(while (setq nline (read-line fo))
(setq Plst (csv->lst nline))
(cond
((= (nth 4 plst) "Yellow")(setq col 2))
((= (nth 4 plst) "Pink")(setq col 211))
((= (nth 4 plst) "Orange")(setq col 32))
((= (nth 4 plst) "Black")(setq col 250))
)
(command "point" (list (atof (nth 1 plst))(atof (nth 2 plst))))
(command "chprop" (entlast) "" "C" col "")
)(close fo)
(princ)
)
(imppts)0
