Leaderboard

Hi, If you want use the DXF code 62, you are limited to (0 at 256) 0=ByBlock 256=ByLayer Else you must use DXF code 420 with RGB colors (it's a long interger) and is more complicated. Exemple whith: (setq colorMap '(11 41 71 101 131 161 191 221 32 62 92 122)) Your code work's well!

ok , updated code one last time. I saw you changed the name to SLD so I updated this to. Also added button to open csv with excel or notepad and added publish option in case you also want single pdf. ;;; SLD : Single Line Drawing by Smitaranjan ;;; Last update : 2023-05-06 - new scenarios ;;; Last update : 2023-05-18 - new scenarios (defun c:SLD ( / OldErr SLD_Err regkey regvar prog-base csv-data-list old-osm ActApp ActDoc ActLay ActSpace SLD-PlotDevices SLD-Papersizes SLD-PlotStyles SLD-PlotRange SLD-PlotInitialized #SLD-data-Source-Filename #SLD-Symbol-Source-Folder #SLD-Drawing-Output-Folder #SLD-MaxNofColumns #SLD-ColumnDistance #SLD-MaxNofRows #SLD-RowDistance #SLD-BorderSize #SLD-Start-Point-X #SLD-Start-Point-X #SLD-Line-Color #SLD-Symbol-Color #SLD-Text-Color #SLD-LastPlotDevice #SLD-LastPaperSize #SLD-LastPlotStyle #SLD-LastPlotRange #SLD-Print-Each-Diagram #SLD-Publish) (SLD_Init) (SLD_Main_Dialog_Start) (if (eq #SLD-Publish "1")(_publish))(SLD_Exit)(princ)) (princ "\nSingle Line Generator - Last update : 2023-05-18 (new scenarios)") (defun SLD_Init () (defun SLD-Util_Err ($s) (princ $s)(SLD_Exit)(setq *error* OldErr)(princ))(setq OldErr *error* *error* SLD_Err) (setq ActApp (vlax-get-acad-object) ActDoc (vla-get-ActiveDocument ActApp) ActLay (vla-get-activelayout ActDoc) ActSpace (vla-get-modelspace ActDoc)) (if (not (vl-file-directory-p (setq prog-base (strcat (getvar 'MYDOCUMENTSPREFIX) "\\lisp\\"))))(vl-mkdir prog-base)) (setq old-osm (getvar 'osmode))(setvar 'OSMODE 0)(setvar 'cmdecho 0)(InitDefaultRegistrySettings)(ReadSettingsFromRegistry)(SLD_Preload_Data_Source_File)) (defun SLD_Exit () (setvar 'OSMODE old-osm)(setvar 'cmdecho 1) (if (and main-dialog-fn (findfile main-dialog-fn)) (progn (princ (strcat "\nCleaning up temporary dialog file : \n" main-dialog-fn))(vl-file-delete main-dialog-fn))) (if main-dialog-fp (close main-dialog-fp)) (setq *error* OldErr) (gc)(princ)) (defun splitss (s / a c p l d i) (if (and s (= (type s) 'str)(> (strlen s) 0)(setq i 1)(setq d ""))(progn (if (wcmatch (substr s i 1) "#")(setq p "num")(setq p "s")) (while (<= i (strlen s))(if (wcmatch (substr s i 1) "#")(setq c "num")(setq c "s")) (if (= c p)(setq d (strcat d (substr s i 1))) (progn (setq l (append l (list d)) p c d (substr s i 1))))(setq i (1+ i)))(if (and d (/= d ""))(setq l (append l (list d)))))) l) (defun SplitStr (s d / p)(if (setq p (vl-string-search d s))(cons (substr s 1 p) (SplitStr (substr s (+ p 1 (strlen d))) d))(list s))) (defun commatize (l) (apply 'strcat (cdr (apply 'append (mapcar '(lambda (x) (list "," x)) l))))) (defun de-commatize (s / p)(if (setq p (vl-string-search "," s))(cons (substr s 1 p)(de-commatize (substr s (+ p 2))))(list s))) (defun StrRemove (s l)(foreach x l (while (vl-string-search x s) (setq s (vl-string-subst "" x s)))) s) (defun getip ( e / p)(if (and e (setq e (entget e) p (assoc 11 e)) (not (equal p '(11 0.0 0.0 0.0)))) (list (cadr (assoc 11 e))(caddr (assoc 11 e))) (list (cadr (assoc 10 e))(caddr (assoc 10 e))))) (defun GetShellFolder ( m / f s) (if (and (setq s (vlax-create-object "Shell.Application")) (setq f (vlax-invoke s 'browseforfolder 0 m 0 "")))(setq f (vlax-get-property (vlax-get-property f 'self) 'path)) (setq f nil))(vl-catch-all-apply 'vlax-release-object (list s)) (if f (strcat (vl-string-right-trim "\\" (vl-string-translate "/" "\\" f)) "\\"))) (defun _getfolder ( m / sh f r )(setq sh (vla-getinterfaceobject (vlax-get-acad-object) "Shell.Application") f (vlax-invoke-method sh 'browseforfolder 0 m 0)) (vlax-release-object sh)(if f (progn (setq r (vlax-get-property (vlax-get-property f 'self) 'path))(if (wcmatch r "*\\") r (strcat r "\\"))))) (defun Dos_Path ($p) (if (= (type $p) 'STR) (strcase (strcat (vl-string-right-trim "\\" (vl-string-translate "/" "\\" $p)) "\\")) "")) (defun vl_path ($p)(if (= (type $p) 'str)(strcat (vl-string-right-trim "\\/" (strcase (vl-string-translate "\\" "/" $p) t)) "/") "")) (defun wai (b a v) (setq a (strcase a) b (ent->vla b)) (if (and (eq (vla-get-objectname b) "AcDbBlockReference") (= (vla-get-hasattributes b) :vlax-true)) (vl-some '(lambda (x) (if (equal a (strcase (vla-get-tagstring x)))(progn (vla-put-textstring x v)(if (not (void #SLD-Text-Color)) (vla-put-color x (atoi #SLD-Text-Color))) v)))(vlax-invoke b 'getattributes)))) (defun tai ( blk tag )(setq tag (strcase tag) blk (ent->vla blk))(setq lst nil)(if blk (vl-some '(lambda (x) (if (equal tag (strcase (vla-get-tagstring x))) (vla-get-textstring x)))(vlax-invoke blk 'getattributes)))) (defun ent->vla (e)(cond ((= (type e) 'VLA-OBJECT) e)((= (type e) 'ENAME)(vlax-ename->vla-object e)) ((and (= (type e) 'STR)(tblsearch "block" e))(ent->vla (ssname (ssget "x" (list (cons 0 "INSERT")(cons 2 e))) 0)))(t nil))) (defun dbx_ver ( / v) (strcat "objectdbx.axdbdocument" (if (< (setq v (atoi (getvar 'acadver))) 16) "" (strcat "." (itoa v))))) (defun void (x)(or (not x)(= "" x)(and (listp x)(not (vl-consp x)))(and (eq 'STR (type x)) (not (vl-remove 32 (vl-string->list x)))))) (defun isnum (n)(if (or (numberp n) (distof n)) t nil)) (defun block-n (o) (if (and (setq o (ent->vla o)) (eq (vla-get-objectname O) "AcDbBlockReference")) (if (vlax-property-available-p o 'EffectiveName)(vla-Get-EffectiveName o)(vla-Get-Name o)) nil)) (defun insert_block_vla (bn ip) (if (vl-catch-all-error-p (setq bo (vl-catch-all-apply 'vla-InsertBlock (list ActSpace (vlax-3D-point ip) bn 1.0 1.0 1.0 0.0)))) nil bo)) (defun BlockInsert-VLA (dwg-list)(foreach dwg dwg-list (if (vl-catch-all-error-p (setq b (vl-catch-all-apply 'vla-InsertBlock (list ActSpace ip dwg 1.0 1.0 1.0 0.0))))(put_on_my_naughty_list (strcat dwg "\n** Error: " (vl-catch-all-error-message b) " **")) (progn (and (eq (vla-get-isDynamicBlock b) :vlax-true)(vla-resetBlock b))(vla-delete b))))) (defun vl_delete_everything ( / d)(vl-load-com)(setq d (vla-Get-ActiveDocument (vlax-Get-Acad-Object))) (vlax-map-collection (vla-get-layers d) '(lambda (l)(vlax-put-property l 'lock :vlax-false))) (vlax-for b (vla-get-blocks d)(vlax-for x b (vl-catch-all-apply 'vla-delete (list x))))(vla-purgeall d)(gc)) (defun shell_open ( $f / it sh ) (if (and (not (void $f)) (setq $f (findfile $f)) (setq sh (vla-getInterfaceObject (vlax-get-acad-object) "Shell.Application"))) (progn (setq it (vl-catch-all-apply 'vlax-invoke (list sh 'open $f)))(vlax-release-object sh)(not (vl-catch-all-error-p it))) (progn (prompt "\nShell application was unable to open file")(setq it nil)))) (defun InitDefaultRegistrySettings () (setq regkey "HKEY_CURRENT_USER\\SOFTWARE\\SLD\\" regvar '(("#SLD-Data-Source-Filename" "")("#SLD-Symbol-Source-Folder" "")("#SLD-Drawing-Output-Folder" "") ("#SLD-MaxNofColumns" "7")("#SLD-ColumnDistance" "50")("#SLD-MaxNofRows" "5")("#SLD-RowDistance" "50")("#SLD-BorderSize" "3")("#SLD-Start-Point-X" "40") ("#SLD-Start-Point-y" "250")("#SLD-Line-Color" "1")("#SLD-Symbol-Color" "2")("#SLD-Text-Color" "7")("#SLD-LastPlotDevice" "Default Windows System Printer.pc3") ("#SLD-LastPaperSize" "A4")("#SLD-LastPlotStyle" "Acad")("#SLD-LastPlotRange" "Extents")("#SLD-Print-Each-Diagram" "1")("#SLD-Publish" "0"))) (mapcar '(lambda (x)(set (read (car x)) (cadr x))) regVar)) (defun ReadSettingsFromRegistry () (mapcar '(lambda (x / n v)(if (setq v (vl-registry-read regkey (setq n (car x)))) (set (read n) v) (vl-registry-write regkey n (cadr x)))) regvar)) (defun WriteSettingsToRegistry ()(mapcar '(lambda (x) (vl-registry-write regkey (car x) (eval (read (car x))))) regvar)) (defun Save_Dialog_Data (%tl) (mapcar '(lambda (x) (eval (car x))) %tl)) (defun Reset_Dialog_Data (%tl %rd) (mapcar '(lambda (x y) (set (car x) y)) %tl %rd)) (defun Set_Dialog_Tiles (%tl) (mapcar '(lambda (x / v) (if (eq 'str (type (setq v (eval (car x))))) (set_tile (cadr x) v))) %tl)) (defun Main_Dialog_Cancel () (Reset_Dialog_Data MainDialog-tl MainDialog-rd) (WriteSettingsToRegistry)) (defun SLD_Main_Dialog_Create ( / lst ) (setq lst (list '(83 76 68 32 58 32 100 105 97 108 111 103 32 123 108 97 98 101 108 61 34 83 76 68 32 45 32 83 105 110 103 108 101 32 76 105 110 101 32 68 105 97 103 114 97 109 32 71 101 110 101 114 97 116 111 114 32 40 82 108 120 32 50 48 50 51 45 48 53 45 49 56 41 34 59 115 112 97 99 101 114 59 58 114 111 119 32 123 103 97 112 59 58 105 109 97 103 101 32 123 104 101 105 103 104 116 61 48 46 49 59 99 111 108 111 114 61 50 53 51 59 125 103 97 112 59 125 115 112 97 99 101 114 59) '(58 98 111 120 101 100 95 99 111 108 117 109 110 32 123 108 97 98 101 108 61 34 68 97 116 97 32 83 111 117 114 99 101 32 70 105 108 101 110 97 109 101 32 40 99 115 118 41 34 59 58 114 111 119 32 123 58 101 100 105 116 95 98 111 120 32 123 101 100 105 116 95 119 105 100 116 104 61 57 54 59 107 101 121 61 34 101 98 95 83 76 68 95 100 97 116 97 95 115 111 117 114 99 101 95 102 105 108 101 110 97 109 101 34 59 125) '(58 98 117 116 116 111 110 32 123 102 105 120 101 100 95 119 105 100 116 104 61 116 114 117 101 59 119 105 100 116 104 61 49 54 59 108 97 98 101 108 61 34 83 101 108 101 99 116 34 59 107 101 121 61 34 98 116 95 83 76 68 95 115 101 108 101 99 116 95 100 97 116 97 95 115 111 117 114 99 101 95 102 105 108 101 110 97 109 101 34 59 125 125) '(58 99 111 110 99 97 116 101 110 97 116 105 111 110 32 123 58 98 117 116 116 111 110 32 123 108 97 98 101 108 61 34 79 112 101 110 32 99 115 118 32 119 105 116 104 32 69 120 99 101 108 34 59 107 101 121 61 34 98 116 95 83 76 68 95 111 112 101 110 95 99 115 118 95 119 105 116 104 95 101 120 99 101 108 34 59 125) '(58 98 117 116 116 111 110 32 123 108 97 98 101 108 61 34 79 112 101 110 32 99 115 118 32 119 105 116 104 32 78 111 116 101 112 97 100 34 59 107 101 121 61 34 98 116 95 83 76 68 95 111 112 101 110 95 99 115 118 95 119 105 116 104 95 110 111 116 101 112 97 100 34 59 125 125 125) '(58 98 111 120 101 100 95 114 111 119 32 123 108 97 98 101 108 61 34 83 121 109 98 111 108 32 83 111 117 114 99 101 32 70 111 108 100 101 114 34 59 58 101 100 105 116 95 98 111 120 32 123 101 100 105 116 95 119 105 100 116 104 61 57 54 59 107 101 121 61 34 101 98 95 83 76 68 95 115 121 109 98 111 108 95 115 111 117 114 99 101 95 102 111 108 100 101 114 34 59 125) '(58 98 117 116 116 111 110 32 123 102 105 120 101 100 95 119 105 100 116 104 61 116 114 117 101 59 119 105 100 116 104 61 49 54 59 108 97 98 101 108 61 34 83 101 108 101 99 116 34 59 107 101 121 61 34 98 116 95 83 76 68 95 115 101 108 101 99 116 95 115 121 109 98 111 108 95 115 111 117 114 99 101 95 102 111 108 100 101 114 34 59 125 125) '(58 98 111 120 101 100 95 114 111 119 32 123 108 97 98 101 108 61 34 68 114 97 119 105 110 103 32 79 117 116 112 117 116 32 70 111 108 100 101 114 34 59 58 101 100 105 116 95 98 111 120 32 123 101 100 105 116 95 119 105 100 116 104 61 57 54 59 107 101 121 61 34 101 98 95 83 76 68 95 100 114 97 119 105 110 103 95 111 117 116 112 117 116 95 102 111 108 100 101 114 34 59 125) '(58 98 117 116 116 111 110 32 123 102 105 120 101 100 95 119 105 100 116 104 61 116 114 117 101 59 119 105 100 116 104 61 49 54 59 108 97 98 101 108 61 34 83 101 108 101 99 116 34 59 107 101 121 61 34 98 116 95 83 76 68 95 115 101 108 101 99 116 95 100 114 97 119 105 110 103 95 111 117 116 112 117 116 95 102 111 108 100 101 114 34 59 125 125 115 112 97 99 101 114 59) '(115 112 97 99 101 114 59 58 114 111 119 32 123 103 97 112 59 58 105 109 97 103 101 32 123 104 101 105 103 104 116 61 48 46 49 59 99 111 108 111 114 61 50 53 51 59 125 103 97 112 59 125 115 112 97 99 101 114 59) '(58 98 111 120 101 100 95 114 111 119 32 123 108 97 98 101 108 61 34 67 111 108 117 109 110 32 38 38 32 82 111 119 32 83 101 116 116 105 110 103 115 34 59 58 99 111 108 117 109 110 32 123 97 108 105 103 110 109 101 110 116 61 99 101 110 116 101 114 100 59) '(58 98 117 116 116 111 110 32 123 107 101 121 61 34 98 116 95 115 101 108 101 99 116 95 115 116 97 114 116 95 112 111 105 110 116 34 59 108 97 98 101 108 61 34 83 116 97 114 116 32 80 111 105 110 116 34 59 125 58 114 111 119 32 123 58 101 100 105 116 95 98 111 120 32 123 107 101 121 61 34 101 98 95 120 95 99 111 111 114 100 34 59 125 32 58 101 100 105 116 95 98 111 120 32 123 107 101 121 61 34 101 98 95 121 95 99 111 111 114 100 34 59 125 125 125) '(115 112 97 99 101 114 59 118 108 105 110 101 59 115 112 97 99 101 114 59 58 99 111 108 117 109 110 32 123 58 116 101 120 116 32 123 108 97 98 101 108 61 34 35 67 111 108 117 109 110 115 34 59 125 58 116 101 120 116 32 123 108 97 98 101 108 61 34 35 82 111 119 115 34 59 125 125) '(58 99 111 108 117 109 110 32 123 58 101 100 105 116 95 98 111 120 32 123 101 100 105 116 95 119 105 100 116 104 61 54 59 107 101 121 61 34 101 98 95 83 76 68 95 109 97 120 95 110 111 102 95 99 111 108 117 109 110 115 34 59 125 58 101 100 105 116 95 98 111 120 32 123 101 100 105 116 95 119 105 100 116 104 61 54 59 107 101 121 61 34 101 98 95 83 76 68 95 109 97 120 95 110 111 102 95 114 111 119 115 34 59 125 125) '(115 112 97 99 101 114 59 118 108 105 110 101 59 115 112 97 99 101 114 59 58 99 111 108 117 109 110 32 123 58 116 101 120 116 32 123 108 97 98 101 108 61 34 67 111 108 46 32 68 105 115 116 46 34 59 125 32 58 116 101 120 116 32 123 108 97 98 101 108 61 34 82 111 119 32 68 105 115 116 46 34 59 125 125) '(58 99 111 108 117 109 110 32 123 58 101 100 105 116 95 98 111 120 32 123 101 100 105 116 95 119 105 100 116 104 61 54 59 107 101 121 61 34 101 98 95 83 76 68 95 99 111 108 117 109 110 95 100 105 115 116 97 110 99 101 34 59 125 58 101 100 105 116 95 98 111 120 32 123 101 100 105 116 95 119 105 100 116 104 61 54 59 107 101 121 61 34 101 98 95 83 76 68 95 114 111 119 95 100 105 115 116 97 110 99 101 34 59 125 125) '(115 112 97 99 101 114 59 118 108 105 110 101 59 115 112 97 99 101 114 59 58 99 111 108 117 109 110 32 123 119 105 100 116 104 61 56 59 125 125 58 98 111 120 101 100 95 114 111 119 32 123 108 97 98 101 108 61 34 67 111 108 111 114 32 38 38 32 66 111 114 100 101 114 32 115 105 122 101 34 59) '(58 116 101 120 116 32 123 108 97 98 101 108 61 34 83 121 109 98 111 108 32 67 111 108 111 114 34 59 125 58 105 109 97 103 101 95 98 117 116 116 111 110 32 123 119 105 100 116 104 61 54 59 107 101 121 61 34 105 98 95 115 121 109 98 111 108 95 99 111 108 111 114 34 59 125 58 116 101 120 116 32 123 108 97 98 101 108 61 34 76 105 110 101 32 67 111 108 111 114 34 59 125 58 105 109 97 103 101 95 98 117 116 116 111 110 32 123 119 105 100 116 104 61 54 59 107 101 121 61 34 105 98 95 108 105 110 101 95 99 111 108 111 114 34 59 125) '(58 116 101 120 116 32 123 108 97 98 101 108 61 34 84 101 120 116 32 67 111 108 111 114 34 59 125 58 105 109 97 103 101 95 98 117 116 116 111 110 32 123 119 105 100 116 104 61 54 59 107 101 121 61 34 105 98 95 116 101 120 116 95 99 111 108 111 114 34 59 125 115 112 97 99 101 114 59 58 116 101 120 116 32 123 108 97 98 101 108 61 34 66 111 114 100 101 114 32 83 105 122 101 34 59 125) '(58 99 111 108 117 109 110 32 123 58 112 111 112 117 112 95 108 105 115 116 32 123 119 105 100 116 104 61 50 52 59 107 101 121 61 34 112 108 95 83 76 68 95 98 111 114 100 101 114 95 115 105 122 101 34 59 118 97 108 117 101 61 34 51 34 59 125 58 105 109 97 103 101 32 123 104 101 105 103 104 116 61 48 46 53 59 99 111 108 111 114 61 100 105 97 108 111 103 95 98 97 99 107 103 114 111 117 110 100 59 125 125 125 115 112 97 99 101 114 59 115 112 97 99 101 114 59) '(58 98 111 120 101 100 95 99 111 108 117 109 110 32 123 108 97 98 101 108 61 34 80 114 105 110 116 101 114 32 38 38 32 80 97 112 101 114 32 83 101 116 116 105 110 103 115 34 59 58 114 111 119 32 123 58 99 111 108 117 109 110 32 123 108 97 98 101 108 61 34 80 108 111 116 32 68 101 118 105 99 101 115 34 59 32 58 112 111 112 117 112 95 108 105 115 116 32 123 107 101 121 61 34 112 108 95 112 108 111 116 95 100 101 118 105 99 101 115 34 59 32 118 97 108 117 101 61 34 48 34 59 125 115 112 97 99 101 114 59 125) '(58 99 111 108 117 109 110 32 123 108 97 98 101 108 61 34 80 97 112 101 114 32 83 105 122 101 115 34 59 32 58 112 111 112 117 112 95 108 105 115 116 32 123 107 101 121 61 34 112 108 95 112 97 112 101 114 95 115 105 122 101 115 34 59 32 118 97 108 117 101 61 34 48 34 59 125 115 112 97 99 101 114 59 125) '(58 99 111 108 117 109 110 32 123 108 97 98 101 108 61 34 80 108 111 116 32 83 116 121 108 101 115 34 59 32 58 112 111 112 117 112 95 108 105 115 116 32 123 107 101 121 61 34 112 108 95 112 108 111 116 95 115 116 121 108 101 115 34 59 32 118 97 108 117 101 61 34 48 34 59 125 115 112 97 99 101 114 59 125) '(58 99 111 108 117 109 110 32 123 108 97 98 101 108 61 34 80 108 111 116 32 82 97 110 103 101 34 59 32 58 112 111 112 117 112 95 108 105 115 116 32 123 107 101 121 61 34 112 108 95 112 108 111 116 95 114 97 110 103 101 34 59 32 118 97 108 117 101 61 34 48 34 59 125 115 112 97 99 101 114 59 125 125) '(58 114 111 119 32 123 58 116 111 103 103 108 101 32 123 108 97 98 101 108 61 34 80 114 105 110 116 32 101 97 99 104 32 100 105 97 103 114 97 109 34 59 107 101 121 61 34 116 103 95 112 114 105 110 116 95 101 97 99 104 95 100 105 97 103 114 97 109 34 59 125 58 116 111 103 103 108 101 32 123 108 97 98 101 108 61 34 80 117 98 108 105 115 104 34 59 107 101 121 61 34 116 103 95 112 117 98 108 105 115 104 34 59 125 125 125) '(115 112 97 99 101 114 59 115 112 97 99 101 114 59 58 114 111 119 32 123 103 97 112 59 58 105 109 97 103 101 32 123 104 101 105 103 104 116 61 48 46 49 59 99 111 108 111 114 61 50 53 51 59 125 103 97 112 59 125 115 112 97 99 101 114 59 115 112 97 99 101 114 59 115 112 97 99 101 114 59 111 107 95 99 97 110 99 101 108 59 125) '(103 97 112 58 105 109 97 103 101 32 123 102 105 120 101 100 95 119 105 100 116 104 61 116 114 117 101 59 119 105 100 116 104 61 49 59 99 111 108 111 114 61 100 105 97 108 111 103 95 98 97 99 107 103 114 111 117 110 100 59 125) ' (115 116 105 99 107 58 105 109 97 103 101 32 123 102 105 120 101 100 95 104 101 105 103 104 116 61 116 114 117 101 59 104 101 105 103 104 116 61 48 46 48 49 59 102 105 120 101 100 95 119 105 100 116 104 61 116 114 117 101 59 119 105 100 116 104 61 48 46 49 59 99 111 108 111 114 61 100 105 97 108 111 103 95 98 97 99 107 103 114 111 117 110 100 59 125) '(118 108 105 110 101 58 99 111 108 117 109 110 32 123 115 116 105 99 107 59 58 105 109 97 103 101 32 123 102 105 120 101 100 95 119 105 100 116 104 61 116 114 117 101 59 119 105 100 116 104 61 48 46 49 59 99 111 108 111 114 61 50 53 51 59 125 115 116 105 99 107 59 125) )) (if (and (setq main-dialog-fn (vl-filename-mktemp "Main.dcl")) (setq main-dialog-fp (open main-dialog-fn "w"))) (mapcar '(lambda (x)(write-line (vl-list->string x) main-dialog-fp)) lst)) (if main-dialog-fp (close main-dialog-fp))(gc)) (defun SLD_Main_Dialog_Action () (mapcar '(lambda (x)(action_tile (car x) (cadr x))) '(("cancel" "(done_dialog 0)") ("accept" "(done_dialog 1)")("eb_SLD_data_source_filename" "(setq #SLD-data-Source-Filename $value)") ("bt_SLD_select_data_source_filename" "(SLD_Select_Data_Source_Filename)")("bt_SLD_open_csv_with_excel" "(shell_open #SLD-data-Source-Filename)") ("bt_SLD_open_csv_with_notepad" "(startapp \"Notepad\" #SLD-data-Source-Filename)")("eb_SLD_symbol_source_folder" "(setq #SLD-Symbol-Source-Folder $value)") ("bt_SLD_select_symbol_source_folder" "(SLD_Select_Symbol_Source_Folder)")("eb_SLD_drawing_output_folder" "(setq #SLD-Drawing-Output-Folder $value)") ("bt_SLD_select_drawing_output_folder" "(SLD_Select_Drawing_Output_Folder)")("eb_SLD_max_nof_columns" "(setq #SLD-MaxNofColumns $value)") ("eb_SLD_column_distance" "(setq #SLD-ColumnDistance $value)")("eb_SLD_max_nof_rows""(setq #SLD-MaxNofRows $value)") ("eb_SLD_row_distance" "(setq #SLD-RowDistance $value)")("pl_SLD_border_size""(setq #SLD-BorderSize $value)") ("eb_x_coord""(setq #SLD-Start-Point-X $value)")("eb_y_coord""(setq #SLD-Start-Point-y $value)")("bt_select_start_point" "(done_dialog 2)") ("ib_symbol_color""(SLD_Select_Symbol_Color)")("ib_line_color" "(SLD_Select_Line_Color)")("ib_text_color" "(SLD_Select_Text_Color)") ("pl_plot_devices""(SLD_Select_Printer $value)")("pl_paper_sizes""(SLD_Select_Paper_Size $value)")("pl_plot_styles""(SLD_Select_Plot_Style $value)") ("pl_plot_range""(SLD_Select_Plot_Range $value)")("tg_print_each_diagram""(setq #SLD-Print-Each-Diagram $value)")("tg_publish""(setq #SLD-Publish $value)") ) ) ) (defun SLD_Main_Dialog_Start ( / drv ) (setq main-dialog-fn nil)(if (null main-dialog-fn)(SLD_Main_Dialog_Create))(if (null SLD-PlotInitialized)(SLD_Init_Plot_Settings)) (if (and (setq main-dialog-dcl (load_dialog main-dialog-fn)) (new_dialog "SLD" main-dialog-dcl)) (progn (SLD_Main_Dialog_Update)(SLD_Main_Dialog_Action)(setq drv (start_dialog))(cond((= drv 0)(Main_Dialog_Cancel))((= drv 1) (WriteSettingsToRegistry)(SLD_DoIt))((= drv 2)(WriteSettingsToRegistry)(SLD_Select_Start_Point))))) (if main-dialog-fn (vl-file-delete main-dialog-fn))(setq main-dialog-fn nil)) (defun SLD_Main_Dialog_Update ( / ) (setq MainDialog-tl '((#SLD-data-Source-Filename "eb_SLD_data_source_filename")(#SLD-Symbol-Source-Folder "eb_SLD_symbol_source_folder") (#SLD-Drawing-Output-Folder "eb_SLD_drawing_output_folder")(#SLD-MaxNofColumns "eb_SLD_max_nof_columns")(#SLD-ColumnDistance "eb_SLD_column_distance") (#SLD-MaxNofRows "eb_SLD_max_nof_rows")(#SLD-RowDistance "eb_SLD_row_distance")(#SLD-BorderSize "pl_SLD_border_size")(#SLD-Start-Point-X "eb_x_coord") (#SLD-Start-Point-y "eb_y_coord")(#SLD-Print-Each-Diagram "tg_print_each_diagram")(#SLD-Publish "tg_publish"))) (if (null MainDialog-rd) (setq MainDialog-rd (Save_Dialog_Data MainDialog-tl)))(Set_Dialog_Tiles MainDialog-tl)(start_list "pl_SLD_border_size") (mapcar 'add_list '("A0" "A1" "A2" "A3" "A4")) (end_list)(set_tile "pl_SLD_border_size" #SLD-BorderSize)(SLD_SetColorImage "ib_line_color" #SLD-Line-Color) (SLD_SetColorImage "ib_symbol_color" #SLD-Symbol-Color)(SLD_SetColorImage "ib_text_color" #SLD-Text-Color)(SLD_Update_Plot_Settings)) (defun SLD_Select_Start_Point ( / pt)(if (setq pt (getpoint "\nSelect Start Point : "))(progn (set_tile "eb_x_coord" (setq #SLD-Start-Point-X (rtos (car pt) 2 2)))(set_tile "eb_y_coord" (setq #SLD-Start-Point-Y (rtos (cadr pt) 2 2)))(WriteSettingsToRegistry)))(SLD_Main_Dialog_Start)) (defun SLD_Select_Line_Color ( / col )(if (setq col (acad_colordlg 7 t)) (progn (setq #SLD-Line-Color (itoa col))(WriteSettingsToRegistry)(SLD_SetColorImage "ib_line_color" col)))) (defun SLD_Select_Symbol_Color ( / col )(if (setq col (acad_colordlg 7 t)) (progn (setq #SLD-Symbol-Color (itoa col))(WriteSettingsToRegistry)(SLD_SetColorImage "ib_symbol_color" col)))) (defun SLD_Select_Text_Color ( / col )(if (setq col (acad_colordlg 7 t)) (progn (setq #SLD-Text-Color (itoa col))(WriteSettingsToRegistry)(SLD_SetColorImage "ib_text_color" col)))) (defun SLD_SetColorImage (im c / col x y ) (if (isnum c) (cond ((= (type c) 'STR)(setq col (atoi c)))((= (type c) 'INT)(setq col c))(t (setq col nil)))) (cond ((= c "bylayer")(setq col 256)) ((= c "byblock")(setq col 0))) (if col (progn (setq x (dimx_tile im) y (dimy_tile im))(start_image im)(fill_image 0 0 x y col)(end_image))) ) (defun SLD_Read_Data_Source_file ( fn / fp header *dl* data lst new-dwg dwg-record) (cond ((void fn)(alert "Computer says no : CSV filename invalid"))((not (findfile fn)) (alert "Computer says no : CSV file missing")) ((not (setq fp (open fn "r"))) (alert "Computer says no : unable to read from CSV file")) (t (setq header (read-line fp))(setq *dl* "," new-dwg nil) (while (setq data (read-line fp))(setq data (vl-list->string (vl-remove 59 (vl-string->list data))))(cond ((eq (vl-string-trim "," data) "") (setq dwg-record (append dwg-record (list data)) lst (append lst (list dwg-record)) dwg-record nil))(t (setq dwg-record (append dwg-record (list data)))))) (setq lst (append lst (list dwg-record)))(close fp))) lst) (defun SLD_Select_Data_Source_Filename ( / d f l) (if (not (void #SLD-data-Source-Filename))(setq d (strcat (vl-filename-directory #SLD-data-Source-Filename) "\\"))(setq d (getvar "SAVEFILEPATH"))) (if (setq f (getfiled "Select Data Source File (csv)" d "csv" 16))(progn (set_tile "eb_SLD_data_source_filename" (setq #SLD-data-Source-Filename f)) (WriteSettingsToRegistry)(if (vl-consp (setq l (SLD_Read_Data_Source_file f)))(setq csv-data-list l)(alert "no data found in data file"))))) (defun SLD_Preload_Data_Source_File ()(if (and (not (void #SLD-data-Source-Filename)) (findfile #SLD-data-Source-Filename)) (setq csv-data-list (SLD_Read_Data_Source_file #SLD-data-Source-Filename))(princ "\nIO data list not yet initialized"))) (defun SLD_Select_Symbol_Source_Folder ( / f )(if (setq f (GetShellFolder "Select Symbol Source Folder")) (progn (set_tile "eb_SLD_symbol_source_folder" (setq #SLD-Symbol-Source-Folder (vl-string-right-trim "\\/" f)))(WriteSettingsToRegistry)))) (defun SLD_Select_Drawing_Output_Folder ( / f )(if (setq f (GetShellFolder "Select Drawing Output Folder")) (progn (set_tile "eb_SLD_drawing_output_folder" (setq #SLD-Drawing-Output-Folder (vl-string-right-trim "\\/" f)))(WriteSettingsToRegistry)))) (defun SLD_DoIt ( / dwg-number start-point current-row current-col current-direction symbol-half-width begin-point new-insertion-point block-list titleblock sym-tag sym-des sym-dist sym-des2 ring-info-list bobj l-dwg-record line-count l) (cond ((void #SLD-Drawing-Output-Folder) (alert "Please select output folder for your drawings")) ((void #SLD-Symbol-Source-Folder) (alert "Please select folder for your symbols")) ((void csv-data-list) (alert "No data found in data list")) (t (if (void #SLD-BorderSize)(setq #SLD-BorderSize "3")) (draw_border (atoi #SLD-BorderSize))(vla-ZoomExtents (vlax-get-acad-object)) (setq dwg-number 1) (if (and (isnum #SLD-Start-Point-X)(isnum #SLD-Start-Point-Y)) (setq start-point (list (atof #SLD-Start-Point-X) (atof #SLD-Start-Point-Y))) (setq start-point (list 40 250)) ) (setq symbol-half-width 15) (foreach dwg-record csv-data-list (vl_delete_everything) (if (setq bobj (Insert_Block (nth (atoi #SLD-BorderSize) '("A0" "A1" "A2" "A3" "A4")) (list 0 0)))(setq titleblock (entlast))) (vla-ZoomExtents (vlax-get-acad-object))(setq new-insertion-point start-point current-row 1 current-col 1 current-direction 0 block-list nil ring-info-list nil) (setq l (mapcar 'de-commatize dwg-record) dwg-record-summary (mapcar '(lambda (x) (nth 6 (nth x l))) '(0 1 2 4 5 6 7 8))) (if (vl-consp dwg-record)(setq l-dwg-record (length dwg-record) line-count 1))(setq dwg-record (vl-remove "" dwg-record)) (while (vl-consp dwg-record) (setq sym-record (Splitstr (car dwg-record) ","))(setq sym-tag (nth 0 sym-record) sym-des (nth 1 sym-record) sym-dist (nth 2 sym-record)) (setq sym-des2 (nth 3 sym-record) ring-info-list (append ring-info-list (list (cons (nth 5 sym-record) (nth 6 sym-record))))) (cond ((or (wcmatch (strcase sym-des) "*POP*") (wcmatch (strcase sym-des) "*POP*")) (setq sym-des (StrRemove sym-des (list " POP" "-POP"))) (if (setq blk (Insert_Block "POP" new-insertion-point)) (progn (setq block-list (append block-list (list blk)))(wai blk "DESCRIPTION" sym-des)(wai blk "number" sym-des2) (if (= current-direction 0) (wai blk "DIST-PL" sym-dist) (wai blk "DIST-NL" sym-dist)))) (setq dwg-record (cdr dwg-record))(setq new-insertion-point (next_point))) ((wcmatch (strcase sym-tag) "GP*")(setq sym-des (StrRemove sym-des (list " GP" "-GP"))) (if (setq blk (Insert_Block "GP" new-insertion-point)) (progn (setq block-list (append block-list (list blk))) (wai blk "DESCRIPTION1" sym-des)(wai blk "DESCRIPTION2" sym-des2) (wai blk "GP" sym-tag)(if (= current-direction 0) (wai blk "DIST-PL" sym-dist) (wai blk "DIST-NL" sym-dist)))) (setq dwg-record (cdr dwg-record))(setq new-insertion-point (next_point))) ((wcmatch (strcase sym-tag) "CLAMP*")(process_clamp)(setq dwg-record (cdr dwg-record))(setq new-insertion-point (next_point))) ((wcmatch (strcase sym-tag) "BJC-U")(process_BJC-U)(setq dwg-record (cdr dwg-record))(setq new-insertion-point (next_point))) ((wcmatch (strcase sym-tag) "4 WAY BJC")(process_4_WAY_BJC)(setq dwg-record (cdr dwg-record))(setq new-insertion-point (next_point))) (t (> i l-dwg-record) (alert "Unknown symbol in data - exit")(exit)))(setq line-count (1+ line-count)))(Connect_Symbols)(Update_Clamps) (update_titleblock titleblock dwg-record-summary)(save_drawing)(if (eq #SLD-Print-Each-Diagram "1")(cond ((wcmatch (strcase #SLD-LastPlotDevice t) "*pdf*") (plot_pdf))(t (plot_other))))(setq dwg-number (1+ dwg-number))))) ) (defun process_clamp ( / clamp-record done l tmp-record) (setq clamp-record (cons sym-record clamp-record) done nil) (while (and (vl-consp dwg-record) (not done)) (setq dwg-record (cdr dwg-record))(setq sym-record (de-commatize (car dwg-record))) (setq clamp-record (cons sym-record clamp-record))(if (wcmatch (strcase (car sym-record)) "CLAMP*")(setq done T))) (setq clamp-record (reverse clamp-record) l (length clamp-record))(setq clamp-record (vl-remove "" clamp-record)) (cond ((not l)) ((eq l 3) (cond ((and (wcmatch (strcase (nth 0 (nth 1 clamp-record))) "GP*")(setq blk (Insert_Block "Clamp" new-insertion-point))) (setq block-list (append block-list (list blk))) (if (= current-direction 0) (wai blk "DIST-PL" sym-dist) (wai blk "DIST-NL" sym-dist)) (setq tmp-record (nth 1 clamp-record)) (setq sym-tag (nth 0 tmp-record) sym-des (nth 1 tmp-record) sym-dist (nth 2 tmp-record)) (setq sym-des2 (nth 3 tmp-record) ring-info-list (append ring-info-list (list (cons (nth 5 tmp-record) (nth 6 tmp-record))))) (setq sym-des (StrRemove sym-des (list " GP" "-GP")))(wai blk "DESCRIPTION1" sym-des)(wai blk "DESCRIPTION2" sym-des2) (wai blk "GP" sym-tag)(wai blk "DIST-CLAMP-BGP" sym-dist)(setq tmp-record (nth 2 clamp-record)) (setq sym-tag (nth 0 tmp-record) sym-des (nth 1 tmp-record) sym-dist (nth 2 tmp-record)) (setq sym-des2 (nth 3 tmp-record) ring-info-list (append ring-info-list (list (cons (nth 5 tmp-record) (nth 6 tmp-record))))) (if (= current-direction 0) (wai blk "DIST-NL" sym-dist) (wai blk "DIST-PL" sym-dist))) ((and (wcmatch (strcase (nth 0 (nth 1 clamp-record))) "POP")(setq blk (Insert_Block "Clamp-pop" new-insertion-point))) (setq block-list (append block-list (list blk))) (if (= current-direction 0) (wai blk "DIST-PL" (strcat (StrRemove (nth 2 (nth 0 clamp-record)) (list " km" " KM")) " KM")) (wai blk "DIST-NL" (strcat (StrRemove (nth 2 (nth 0 clamp-record)) (list " km" " KM")) " KM"))) (wai blk "DIST-POP-NL" (strcat (StrRemove (nth 2 (nth 1 clamp-record)) (list " km" " KM")) " KM")) (wai blk "DESCRIPTION" (StrRemove (nth 1 (nth 1 clamp-record)) (list " POP")))(wai blk "NUMBER" (nth 3 (nth 1 clamp-record))) ) ) ) ((eq l 4) (if (setq blk (Insert_Block "Clamp-2GP" new-insertion-point)) (progn (setq block-list (append block-list (list blk))) (if (= current-direction 0) (wai blk "DIST-PL" sym-dist) (wai blk "DIST-NL" sym-dist)) (setq tmp-record (nth 1 clamp-record)) (setq sym-tag (nth 0 tmp-record) sym-des (nth 1 tmp-record) sym-dist (nth 2 tmp-record) sym-des2 (nth 3 tmp-record) ring-info-list (append ring-info-list (list (cons (nth 5 tmp-record) (nth 6 tmp-record))))) (setq sym-des (StrRemove sym-des (list " GP" "-GP")))(wai blk "DESCRIPTION1-a" sym-des)(wai blk "DESCRIPTION2-a" sym-des2) (wai blk "GP-a" sym-tag)(wai blk "DIST-CLAMP-GPa" sym-dist)(setq tmp-record (nth 2 clamp-record)) (setq sym-tag (nth 0 tmp-record) sym-des (nth 1 tmp-record) sym-dist (nth 2 tmp-record) sym-des2 (nth 3 tmp-record) ring-info-list (append ring-info-list (list (cons (nth 5 tmp-record) (nth 6 tmp-record))))) (setq sym-des (StrRemove sym-des (list " GP" "-GP")))(wai blk "DESCRIPTION1-b" sym-des)(wai blk "DESCRIPTION2-b" sym-des2) (wai blk "GP-b" sym-tag)(wai blk "DIST-GPa-GPb" sym-dist)(setq tmp-record (nth 3 clamp-record)) (setq sym-tag (nth 0 tmp-record) sym-des (nth 1 tmp-record) sym-dist (nth 2 tmp-record) sym-des2 (nth 3 tmp-record) ring-info-list (append ring-info-list (list (cons (nth 5 tmp-record) (nth 6 tmp-record))))) (if (= current-direction 0) (wai blk "DIST-NL" sym-dist) (wai blk "DIST-PL" sym-dist)) ) ) ) ((eq l 7) (if (setq blk (Insert_Block "BJC-D" new-insertion-point)) (progn (setq block-list (append block-list (list blk))) (if (= current-direction 0) (wai blk "DIST-PL" sym-dist) (wai blk "DIST-NL" sym-dist)) (wai blk "DIST-1" (strcat (StrRemove (nth 2 (nth 1 clamp-record)) (list " km" " KM")) " KM")) (wai blk "DIST-2" (strcat (StrRemove (nth 2 (nth 2 clamp-record)) (list " km" " KM")) " KM")) (wai blk "DIST-3" (strcat (StrRemove (nth 2 (nth 4 clamp-record)) (list " km" " KM")) " KM")) (wai blk "DESCRIPTION1-a" (StrRemove (nth 1 (nth 2 clamp-record)) (list " gp" " GP"))) (wai blk "DESCRIPTION2-a" (nth 3 (nth 2 clamp-record)))(wai blk "GP-a" (nth 0 (nth 2 clamp-record))) (wai blk "DESCRIPTION1-b" (StrRemove (nth 1 (nth 4 clamp-record)) (list " gp" " GP"))) (wai blk "DESCRIPTION2-b" (nth 3 (nth 4 clamp-record)))(wai blk "GP-b" (nth 0 (nth 4 clamp-record)))) (princ "\nUnable to insert block : BJC-D")))(t (princ "Unknown clamp detected")))(princ)) (defun process_BJC-U ( / clamp-record done l tmp-record) (setq clamp-record (cons sym-record clamp-record) done nil) (repeat 5 (setq dwg-record (cdr dwg-record))(setq sym-record (de-commatize (car dwg-record)))(setq clamp-record (cons sym-record clamp-record)) (if (wcmatch (strcase (car sym-record)) "BJC-U")(setq done T))) (setq clamp-record (reverse clamp-record) l (length clamp-record))(setq clamp-record (vl-remove "" clamp-record)) (if (setq blk (Insert_Block "BJC-U" new-insertion-point)) (progn (setq block-list (append block-list (list blk))) (if (= current-direction 0) (wai blk "DIST-PL" sym-dist) (wai blk "DIST-NL" sym-dist)) (setq tmp-record (nth 1 clamp-record)) (setq sym-tag (nth 0 tmp-record) sym-des (nth 1 tmp-record) sym-dist (nth 2 tmp-record) sym-des2 (nth 3 tmp-record) ring-info-list (append ring-info-list (list (cons (nth 5 tmp-record) (nth 6 tmp-record))))) (wai blk "DIST-1" sym-dist) (setq tmp-record (nth 2 clamp-record)) (setq sym-tag (nth 0 tmp-record) sym-des (nth 1 tmp-record) sym-dist (nth 2 tmp-record) sym-des2 (nth 3 tmp-record) ring-info-list (append ring-info-list (list (cons (nth 5 tmp-record) (nth 6 tmp-record))))) (wai blk "DESCRIPTION1-a" sym-des) (wai blk "DESCRIPTION2-a" sym-des2) (wai blk "GP-a" sym-tag) (wai blk "DIST-2" sym-dist) (setq tmp-record (nth 3 clamp-record)) (setq sym-tag (nth 0 tmp-record) sym-des (nth 1 tmp-record) sym-dist (nth 2 tmp-record) sym-des2 (nth 3 tmp-record) ring-info-list (append ring-info-list (list (cons (nth 5 tmp-record) (nth 6 tmp-record))))) (setq tmp-record (nth 4 clamp-record)) (setq sym-tag (nth 0 tmp-record) sym-des (nth 1 tmp-record) sym-dist (nth 2 tmp-record) sym-des2 (nth 3 tmp-record) ring-info-list (append ring-info-list (list (cons (nth 5 tmp-record) (nth 6 tmp-record))))) (setq sym-tag (StrRemove sym-tag (list "SPUR-"))) (setq sym-des (StrRemove sym-des (list " GP-SL"))) (wai blk "DESCRIPTION1-b" sym-des) (wai blk "DESCRIPTION2-b" sym-des2) (wai blk "GP-b" sym-tag) (wai blk "DIST-3" sym-dist) (setq tmp-record (nth 5 clamp-record)) (setq sym-tag (nth 0 tmp-record) sym-des (nth 1 tmp-record) sym-dist (nth 2 tmp-record) sym-des2 (nth 3 tmp-record) ring-info-list (append ring-info-list (list (cons (nth 5 tmp-record) (nth 6 tmp-record))))) ) ) (princ) ) (defun process_4_WAY_BJC ( / clamp-record done tmp-record) (setq clamp-record (cons sym-record clamp-record) done nil) (repeat 4 (setq dwg-record (cdr dwg-record)) (setq sym-record (de-commatize (car dwg-record))) (setq clamp-record (cons sym-record clamp-record)) (if (wcmatch (strcase (car sym-record)) "BJC-U")(setq done T)) ) (setq clamp-record (reverse clamp-record)) (setq clamp-record (vl-remove "" clamp-record)) (cond ((and (wcmatch (strcase (nth 0 (nth 1 clamp-record))) "POP-U") (wcmatch (strcase (nth 0 (nth 3 clamp-record))) "GP*") (setq blk (Insert_Block "BJC-4WAY-POP-GP" new-insertion-point))) (setq block-list (append block-list (list blk))) (if (= current-direction 0) (wai blk "DIST-PL" (strcat (StrRemove (nth 2 (nth 0 clamp-record)) (list " km" " KM")) " KM")) (wai blk "DIST-NL" (strcat (StrRemove (nth 2 (nth 0 clamp-record)) (list " km" " KM")) " KM")) ) (wai blk "DIST-CLAMP-POP" (strcat (StrRemove (nth 2 (nth 1 clamp-record)) (list " km" " KM")) " KM")) (wai blk "DESCRIPTION" (StrRemove (nth 1 (nth 1 clamp-record)) (list " POP-U"))) (wai blk "NUMBER" (nth 3 (nth 1 clamp-record))) (wai blk "DIST-CLAMP-GP" (strcat (StrRemove (nth 2 (nth 3 clamp-record)) (list " km" " KM")) " KM")) (wai blk "DESCRIPTION1-b" (StrRemove (nth 1 (nth 3 clamp-record)) (list " GP"))) (wai blk "DESCRIPTION2-b" (nth 3 (nth 3 clamp-record))) (wai blk "GP" (nth 0 (nth 3 clamp-record))) ) ((and (wcmatch (strcase (nth 0 (nth 1 clamp-record))) "GP*") (wcmatch (strcase (nth 0 (nth 3 clamp-record))) "GP*") (setq blk (Insert_Block "BJC-4WAY" new-insertion-point))) (setq block-list (append block-list (list blk))) (if (= current-direction 0) (wai blk "DIST-PL" sym-dist) (wai blk "DIST-NL" sym-dist)) (setq tmp-record (nth 1 clamp-record)) (setq sym-tag (nth 0 tmp-record) sym-des (nth 1 tmp-record) sym-dist (nth 2 tmp-record) sym-des2 (nth 3 tmp-record) ring-info-list (append ring-info-list (list (cons (nth 5 tmp-record) (nth 6 tmp-record))))) (setq sym-des (StrRemove sym-des (list " GP" "-GP"))) (wai blk "DESCRIPTION1-a" sym-des) (wai blk "DESCRIPTION2-a" sym-des2) (wai blk "GP-a" sym-tag) (wai blk "DIST-CLAMP-GPa" sym-dist) (setq tmp-record (nth 2 clamp-record)) (setq sym-tag (nth 0 tmp-record) sym-des (nth 1 tmp-record) sym-dist (nth 2 tmp-record) sym-des2 (nth 3 tmp-record) ring-info-list (append ring-info-list (list (cons (nth 5 tmp-record) (nth 6 tmp-record))))) (setq sym-des (StrRemove sym-des (list " GP" "-GP"))) (wai blk "DESCRIPTION1-b" sym-des) (wai blk "DESCRIPTION2-b" sym-des2) (wai blk "GP-b" sym-tag) (wai blk "DIST-GPa-GPb" sym-dist) (setq tmp-record (nth 3 clamp-record)) (setq sym-tag (nth 0 tmp-record) sym-des (nth 1 tmp-record) sym-dist (nth 2 tmp-record) sym-des2 (nth 3 tmp-record) ring-info-list (append ring-info-list (list (cons (nth 5 tmp-record) (nth 6 tmp-record))))) (if (= current-direction 0) (wai blk "DIST-NL" sym-dist) (wai blk "DIST-PL" sym-dist)) ) ) ) (defun Connect_Symbols ( / old-col i blk b1 ip1 b2 ip2 ang pt1 pt2 pt3 pt4) (setq old-col (getvar 'CECOLOR)) (vl-catch-all-apply 'setvar (list 'CECOLOR #SLD-Line-Color)) (if (vl-consp block-list) (progn (setq i 0 l (length block-list)) (foreach blk block-list (setq b1 (nth i block-list) b2 (nth (1+ i) block-list)) lst (cond ((and b1 b2) (setq ip1 (getip b1) ip2 (getip b2) ang (angle ip1 ip2)) (cond ((equal ang 0) (setq pt1 (list (+ (car ip1) symbol-half-width) (cadr ip1)) pt2 (list (- (car ip2) symbol-half-width) (cadr ip2))) (_AddLines (list pt1 pt2)) ) ((equal ang pi) (setq pt1 (list (- (car ip1) symbol-half-width) (cadr ip1)) pt2 (list (+ (car ip2) symbol-half-width) (cadr ip2))) (_AddLines (list pt1 pt2)) ) ((and (equal ang (* pi 1.5)) (= pi (angle ip1 (getip (nth (1- i) block-list))))) (setq pt1 (list (+ (car ip1) symbol-half-width) (cadr ip1)) pt2 (list (+ (car ip1) (atoi #SLD-ColumnDistance)) (cadr ip1)) pt3 (list (+ (car ip2) (atoi #SLD-ColumnDistance)) (cadr ip2)) pt4 (list (+ (car ip2) symbol-half-width) (cadr ip2))) (_AddLines (list pt1 pt2 pt3 pt4)) ) ((and (equal ang (* pi 1.5)) (equal 0 (angle ip1 (getip (nth (1- i) block-list))))) (setq pt1 (list (- (car ip1) symbol-half-width) (cadr ip1)) pt2 (list (- (car ip1) (atoi #SLD-ColumnDistance)) (cadr ip1)) pt3 (list (- (car ip2) (atoi #SLD-ColumnDistance)) (cadr ip2)) pt4 (list (- (car ip2) symbol-half-width) (cadr ip2))) (_AddLines (list pt1 pt2 pt3 pt4)) ) ) ) ) (setq i (1+ i)) ) (princ "\nBlocks connected") ) (princ "\nUnable to connect blocks") ) (setvar 'CECOLOR old-col) ) (defun _AddLines ( l / s) (setq m (vla-get-ModelSpace (vla-get-ActiveDocument (vlax-get-acad-object)))) (while (> (length l) 1)(vla-AddLine m (vlax-3d-point (car l))(vlax-3d-point (cadr l)))(setq l (cdr l)))) (defun Update_Clamps ( / i l blk ang next-blk ) (if (vl-consp block-list) (progn (setq i -1 l (length block-list)) (foreach blk block-list (setq i (1+ i)) (if (and (> i 0) (< i l) (setq next-blk (nth (1+ i) block-list))) (setq ang (angle (getip blk) (getip next-blk))) (setq ang nil)) (if (and (setq bn (block-n blk)) (wcmatch (strcase bn t) "clamp*")) (cond ((and (not (void (setq dist-1 (tai blk "DIST-CLAMP-BGP")))) (not (void (setq dist-2 (tai blk "DIST-PL"))))) (wai blk "DIST-BGP-PL" (sum_dist dist-1 dist-2))) ((and (equal ang 0) (void (tai blk "DIST-PL")) (not (void (setq dist-1 (tai blk "DIST-CLAMP-BGP")))) (not (void (setq dist-2 (tai (nth (1- i) block-list) "DIST-NL"))))) (wai blk "DIST-BGP-PL" (sum_dist dist-1 dist-2))) ((and (equal ang pi) (void (tai blk "DIST-PL")) (not (void (setq dist-1 (tai blk "DIST-CLAMP-BGP")))) (not (void (setq dist-2 (tai (nth (1+ i) block-list) "DIST-NL"))))) (wai blk "DIST-BGP-PL" (sum_dist dist-1 dist-2))) ((and (equal ang (* pi 1.5)) (void (tai blk "DIST-PL")) (not (void (setq dist-1 (tai blk "DIST-CLAMP-BGP")))) (not (void (setq dist-2 (tai (nth (1- i) block-list) "DIST-NL"))))) (wai blk "DIST-BGP-PL" (sum_dist dist-1 dist-2))) (t (princ "\nNo match found for clamp")) ) ) ) (princ "\nClamps updated") ) (princ "\nUnable to update clamps") ) ) (defun sum_dist (d1 d2) (strcat (rtos (+ (atof (vl-string-trim " KM" (strcase d1))) (atof (vl-string-trim " KM" (strcase d2)))) 2 3) " km")) (defun Clean_Drawing () (vl-cmdf "erase" "all" "")(vla-purgeall (vla-get-activedocument (vlax-get-acad-object)))(gc)) (defun Save_Drawing ( / dwg-name exist-dwg) (cond ((void #SLD-Drawing-Output-Folder) (princ "\nInvalid output folder : unable to save drawing")) ((not (vl-file-directory-p #SLD-Drawing-Output-Folder)) (princ "\nInvalid output folder name : folder doesn't exist")) (t (setq dwg-name (strcat #SLD-Drawing-Output-Folder "\\diagram-" (itoa dwg-number))) (if (findfile (setq exist-dwg (strcat dwg-name ".dwg"))) (progn (vl-file-delete exist-dwg)(gc))) (setvar "expert" 5)(setvar "cmdecho" 0)(setvar "attreq" 0)(setvar "FILEDIA" 0) (cond ((void dwg-name) (alert (strcat "Invalid dwg name : " (vl-princ-to-string dwg-name)))) ((vl-catch-all-error-p (setq err (vl-catch-all-apply 'vla-saveas (list ActDoc dwg-name)))) (alert (strcat "Unable to save file\n" (vl-catch-all-error-message err)))) (t (princ (strcat "\nFile saved : " dwg-name))) ) (setvar "expert" 1)(setvar "cmdecho" 1)(setvar "attreq" 1)(setvar "FILEDIA" 1) ) ) (gc)(gc)(gc) ) (defun insert_block ( bn ip / old-col ) (setq old-col (getvar 'CECOLOR)) (vl-catch-all-apply 'setvar (list 'CECOLOR #SLD-Symbol-Color)) (if (vl-catch-all-error-p (setq bo (vl-catch-all-apply'vla-InsertBlock (list ActSpace (vlax-3D-point ip) (findfile (strcat #SLD-Symbol-Source-Folder "\\" bn ".dwg")) 1.0 1.0 1.0 0.0)))) nil (progn (setvar 'CECOLOR old-col) (vlax-vla-object->ename bo)) ) ) (defun next_point ( / pt) (cond ((and (= current-direction 0) (< current-col (atoi #SLD-MaxNofColumns))) (setq current-col (1+ current-col))) ((and (= current-direction 180) (> current-col 1)) (setq current-col (1- current-col))) ((and (= current-direction 0) (= current-col (atoi #SLD-MaxNofColumns))) (setq current-direction 180 current-row (+ current-row 2))) ((and (= current-direction 180) (= current-col 1)) (setq current-row (+ current-row 2) current-direction 0)) ((and (= current-direction 180) (= current-col (atoi #SLD-MaxNofColumns))) (setq current-col (1- current-col))) ) (setq pt (list (+ (car start-point) (* (1- current-col) (atoi #SLD-ColumnDistance))) (- (cadr start-point) (* (1- current-row) (atoi #SLD-RowDistance))))) (princ) pt ) (defun Draw_Border ( n / f) (defun f (p) (vl-cmdf ".pline" '(0 0) (list 0 (cadr p)) p (list (car p) 0) "c")) (f (nth n '((1188 840) (840 594) (594 420) (420 297) (210 297))))) (defun update_titleblock (b l) (if (and b (vl-consp l))(mapcar '(lambda (a v)(wai b a v)) '("Ring-ID""Pop-to-Pop""District-Code""DISTRICT""APPROVED_MANDAL""RING_NUMBER""NO_OF_GP-S""TOTAL_LENGTH") l) (princ "\nUnable to update titleblock"))) (defun analyze (r) (mapcar '(lambda (x) (nth 6 (nth x r))) '(0 1 2 4 5 6 7 8))) (defun _GetPlotDevices () (vla-RefreshPlotDeviceInfo ActLay) (cdr (vlax-safearray->list (vlax-variant-value (vla-getplotdevicenames (vla-item (vla-get-layouts ActDoc) "Model")))))) (defun SLD_GetPlotDevices () (vla-RefreshPlotDeviceInfo ActLay) (cdr (vlax-safearray->list (vlax-variant-value (vla-getplotdevicenames ActLay))))) (defun SLD_GetPaperSizes () (vla-RefreshPlotDeviceInfo ActLay) (if (>= (vlax-safearray-get-u-bound (vlax-variant-value (vla-GetCanonicalMediaNames ActLay)) 1) 0) (vlax-safearray->list (vlax-variant-value (vla-GetCanonicalMediaNames ActLay)))(list "none"))) (defun SLD_GetPlotStyles () (vla-RefreshPlotDeviceInfo ActLay) (acad_strlsort (vl-directory-files (SplitPath (getenv "PrinterStyleSheetDir")) (if (= 1 (getvar "PSTYLEMODE")) "*.ctb" "*.stb") 1 ))) (defun SplitPath ($p / l) (if (wcmatch $p "*;*")(car (splitstr $p ";")) $p)) (defun SLD_GetPaperSizesFor ( $prt / old-prt-name l-cano l-loco) (vla-RefreshPlotDeviceInfo ActLay) (if (/= $prt (setq old-prt-name (vla-get-configname ActLay))) (progn (vla-put-configname ActLay $prt) (vla-RefreshPlotDeviceInfo ActLay))) (if (>= (vlax-safearray-get-u-bound (vlax-variant-value (vla-GetCanonicalMediaNames ActLay)) 1) 0) (setq l-cano (vlax-safearray->list (vlax-variant-value (vla-GetCanonicalMediaNames ActLay)))) (setq l-cano nil)) (if l-cano (setq l-loco (mapcar '(lambda (x) (if (not (eq x "None")) (vla-GetLocaleMediaName ActLay x) "Nothing")) l-cano))) (if (and old-prt-name (/= (strcase old-prt-name t) "none")) (if (vl-catch-all-error-p (vl-catch-all-apply 'vla-put-configname (list ActLay old-prt-name))) (princ (strcat "\nUnable to use old printer (missing) : " old-prt-name)))) (vla-RefreshPlotDeviceInfo ActLay) l-loco ) (defun deletePageSetup (doc name) (vlax-for pc (vla-get-plotconfigurations doc) (if (= (strcase (vla-get-name pc)) (strcase name)) (vla-delete pc)))) (defun addPageSetup (doc name / space pc lay)(deletePageSetup doc name) (if (= (getvar "ctab") "Model")(setq space :vlax-true lay (vla-get-Layout (vla-get-ModelSpace (vla-get-activedocument (vlax-get-acad-object))))) (setq space :vlax-false lay (vla-get-ActiveLayout (vla-get-activedocument (vlax-get-acad-object))))) (setq pc (vla-add (vla-get-plotconfigurations doc) name space))(vla-CopyFrom pc lay)(vla-put-name pc name)) (defun SLD_Pagesetup ( / psname pConfigs pItem org avp) (setq psname "SLD") (addPageSetup actDoc psname) (setq pConfigs (vla-get-plotconfigurations actDoc) pItem (vl-catch-all-apply 'vla-Item (list pConfigs psname))) (vla-refreshplotdeviceInfo pItem) (vla-put-configname pItem #SLD-LastPlotDevice) (vla-put-canonicalmedianame pItem (vl-string-translate " " "_" #SLD-LastPaperSize)) (vla-put-paperunits pItem acMillimeters) (vla-put-PlotType pItem (nth (vl-position #SLD-LastPlotRange SLD-PlotRange) (list acDisplay acExtents acLimits))) (vlax-safearray-fill (setq org (vlax-make-safearray vlax-vbDouble '(0 . 1))) (list 0.0 0.0)) (vla-put-PlotOrigin pItem org) (if (= :vlax-false (vla-get-CenterPlot pItem)) (vla-put-CenterPlot pItem :vlax-true)) (vla-put-UseStandardScale pItem :vlax-true) (vla-put-StandardScale pItem acScaleToFit) (vla-put-PlotHidden pItem :vlax-false) (vla-put-PlotWithPlotStyles pItem :vlax-true) (vla-put-StyleSheet pItem #SLD-LastPlotStyle) (vla-put-PlotRotation pItem ac0degrees) (vla-put-PlotViewportBorders pItem :vlax-true) (vla-put-PlotViewportsFirst pItem :vlax-true) (vla-put-PlotWithLineweights pItem :vlax-true) (vla-put-ScaleLineweights pItem :vlax-true) (if (= (getvar "TILEMODE") 1)(setq avp (vl-catch-all-apply 'vla-get-ActiveViewport (list actDoc))) (setq avp (vl-catch-all-apply 'vla-get-activepviewport (list actDoc)))) (vl-catch-all-apply 'vla-put-ShadePlot (list avp acShadePlotAsDisplayed)) (vla-put-ShowPlotStyles pItem :vlax-false) (vla-CopyFrom (vla-get-ActiveLayout (vla-get-activedocument (vlax-get-acad-object))) pItem) (vla-refreshplotdeviceInfo pItem) ) (defun SLD_Init_Plot_Settings ()(if (null SLD-PlotInitialized)(progn (setq SLD-PlotInitialized t SLD-PlotDevices (SLD_GetPlotDevices)) (if (and (not (void #SLD-LastPlotDevice)) (not (void SLD-PlotDevices))(member #SLD-LastPlotDevice SLD-PlotDevices)) (setq SLD-Papersizes (SLD_GetPaperSizesFor #SLD-LastPlotDevice))(setq SLD-Papersizes (SLD_Getpapersizes))) (setq SLD-PlotStyles (SLD_GetPlotStyles) SLD-PlotRange '("Display" "Extents" "Limits"))))) (defun SLD_Update_Plot_Settings ()(mapcar '(lambda (x) (start_list (car x))(mapcar 'add_list (cdr x))(end_list)) (list (cons "pl_plot_devices" SLD-PlotDevices)(cons "pl_paper_sizes" SLD-Papersizes)(cons "pl_plot_styles" SLD-PlotStyles)(cons "pl_plot_range" SLD-PlotRange))) (mapcar '(lambda (x y z / i)(if (or (void (vl-symbol-value x)) (not (setq i (vl-position (vl-symbol-value x) y)))) (set (read (vl-symbol-name x)) (nth (setq i 0) y)))(set_tile z (itoa i))) (list '#SLD-LastPlotDevice '#SLD-LastPaperSize '#SLD-LastPlotStyle '#SLD-LastPlotRange) (list SLD-PlotDevices SLD-Papersizes SLD-PlotStyles SLD-PlotRange) (list "pl_plot_devices" "pl_paper_sizes" "pl_plot_styles" "pl_plot_range"))) (defun SLD_Select_Printer ($v)(if (and (not (void (setq #SLD-LastPlotDevice (nth (atoi $v) SLD-PlotDevices)))) (not (void (setq SLD-Papersizes (SLD_GetPaperSizesFor #SLD-LastPlotDevice)))))(progn (start_list "pl_paper_sizes") (mapcar 'add_list SLD-Papersizes)(end_list)(if (or (void #SLD-LastPaperSize)(not (member #SLD-LastPaperSize SLD-Papersizes))) (if (not (void SLD-Papersizes))(setq #SLD-LastPaperSize (car SLD-Papersizes))))(set_tile "pl_paper_sizes" #SLD-LastPaperSize)))) (defun SLD_Select_Paper_Size ($v) (setq #SLD-LastPaperSize (nth (atoi $v) SLD-Papersizes))) (defun SLD_Select_Plot_Style ($v) (setq #SLD-LastPlotStyle (nth (atoi $v) SLD-PlotStyles))) (defun SLD_Select_Plot_Range ($v) (setq #SLD-LastPlotRange (nth (atoi $v) SLD-PlotRange))) (defun plot_drawing ( / ActPlot plotFileName) (setq ActPlot (vla-get-Plot ActDoc)) (setq plotFileName (strcat #SLD-Drawing-Output-Folder "\\diagram-" (itoa dwg-number) ".pdf")) (if (wcmatch (strcase #SLD-LastPlotDevice t) "*pdf*") (vla-PlotToFile ActPlot plotFileName) (vla-PlotToDevice ActPlot)) ) (defun plot_pdf ( / prtname papsize orient plotupsidedown p1 p2 pstname ) (setq prtname #SLD-LastPlotDevice) (setq papsize #SLD-LastPaperSize) (setq orient "landscape") (setq plotupsidedown "no") (setq p1 (getvar 'extmin) p2 (getvar 'extmax)) (setq pstname #SLD-LastPlotStyle) (setq pdf-name (strcat (getvar "dwgprefix") (vl-filename-base (getvar "dwgname")))) (command ".-Plot" "Yes" "" prtname papsize "Millimeters" orient plotupsidedown "WINDOW" P1 P2 "Fit" "Center" "Yes" pstname "Yes" "As displayed" pdf-name"Yes" "Yes" )(command ".qsave")) (defun plot_other ( / prtname papsize orient plotupsidedown p1 p2 pstname ) (setq prtname #SLD-LastPlotDevice) (setq papsize #SLD-LastPaperSize) (setq orient "landscape") (setq plotupsidedown "no") (setq p1 (getvar 'extmin) p2 (getvar 'extmax)) (setq pstname #SLD-LastPlotStyle) (setq pdf-name (strcat (getvar "dwgprefix") (vl-filename-base (getvar "dwgname")))) (command ".-Plot" "Yes" "" prtname papsize "Millimeters" orient plotupsidedown "WINDOW" P1 P2 "Fit" "Center" "Yes" pstname "Yes" "As displayed" "n" "yes" "Yes")) (defun _publish ( / dwg-list dsd-fn dsd-fn tab-lst pdf-path pdf-fn d old-filedia) (setq dwg-list (vl-directory-files (setq d (dos_path #SLD-Drawing-Output-Folder)) "*.dwg")) (setq dsd-fn (strcat d "Single-Lines.dsd") dsd-fp (open dsd-fn "w")) (mapcar '(lambda (s) (write-line s dsd-fp)) '("[DWF6Version]" "Ver=1" "[DWF6MinorVersion]" "MinorVer=1")) (foreach dwg (mapcar '(lambda (x)(strcat d x)) dwg-list) (foreach tab (setq tab-lst '("Model")) (write-line (strcat "[DWF6Sheet:" (vl-filename-base dwg) "_" tab "]") dsd-fp) (write-line (strcat "DWG=" dwg) dsd-fp)(write-line (strcat "Layout=" tab) dsd-fp)(write-line "Setup=" dsd-fp) (write-line (strcat "OriginalSheetPath=" dwg) dsd-fp)(write-line "Has Plot Port=0" dsd-fp)(write-line "Has3DDWF=0" dsd-fp))) (setq pdf-path (dos_path #SLD-Drawing-Output-Folder) pdf-fn (strcat pdf-path "Single-Lines.pdf")) (mapcar '(lambda (s) (write-line s dsd-fp))(list "[Target]" "Type=6" (strcat "DWF=" pdf-fn) (strcat "OUT=" pdf-path) "PWD=")) (if dsd-fp (progn (close dsd-fp)(gc)))(setq old-filedia (getvar 'filedia))(setvar 'filedia 0)(command "-publish" dsd-fn)(setvar 'filedia old-filedia) ) I've attached last csv file(s) you sent with two more case. I've combined them to one. Note that I've added one line (one but last line in csv because you started with clamp but did not closed it with keyword 'clamp' I have also changed csv engine so it now uses a blank line for next drawing. I still use single symbols for complex branches like 4-way clamp with pop & gp. Have to move on to new project now , so good luck! ATCHAMPETA _ATCHAMPETA _ATCHAMPETA _RING3.pdf CSV-2023-05-18.csv DACHEPALLE_DACHEPALLE_DACHEPALLE_RING2 (2) (1).pdf diagram-1.dwg diagram-1.pdf diagram-2.dwg diagram-2.pdf Single-Lines.pdf SLD.lsp symbols-2023-05-18.zip

I have done more conversions than I want to think about. The sad thing is most of the PDFs I converted should have been supplied as .dwg, but the powers that be either didn't ensure compliance and/or it was never stipulated. Fortunately, we can usually make a call or send an email these days and get a .dwg. (If the company is still in business.) Try redoing a batch of Raster PDFs and Raster Images. No matter how much is in the drawing, I would wager you will be fine using a Script and Batch file on them in that case.

When I say simple, I mean the font used. If everything is horizontal and pretty much all simplex, that would be an easy conversion to run a script in batch of drawings. One other thing, you might try this VectPDF download | SourceForge.net I used it prior to AutoCAD having the import PDF function. Not sure if it has had any updates in a while. As for SHX fonts, you can make them comments when plotted to PDF. Acrobat can plot them as searchable with PDFMaker. (I am not sure how that comes back into AutoCAD, though.) True Type Fonts can also be made non-searchable, so not foolproof either. (I am not sure how that comes back into AutoCAD, either.) How to create selectable and searchable text in a PDF from AutoCAD (autodesk.com) Unfortunately, OCR has been used a lot more for creating image text to editable text, much more development in that area I would surmise, I had some very good OCR software that came with a scanner way back in the 80s. I have found very little on batch converting, either in AutoCAD, Adobe or others. Acrobat may be able to batch convert, I am not sure on that. I would just suggest pick a method and get to work on them manually.

@CANDOWE Once upon a time, circa 55 years, a teacher show us this say

Try this (defun c:5blks ( / tot co-ord ent ss txtnum) (setq tot 0.0) (setvar 'clayer "66. COBERTURA NAP") (command-s "Pline") (setq ent (entlast)) (setq co-ord (mapcar 'cdr (vl-remove-if-not '(lambda (x) (= (car x) 10)) (entget ent)))) (setq co-ord (cons (last co-ord) co-ord)) (setq ss (ssget "WP" co-ord (list (cons 0 "TEXT,MTEXT")(cons 8 "10. NUMERO DE CASAS ALIMENTADAS,12. NUMERO DE COMERCIOS ALIMENTADOS,14. NUMERO DE DEPARTAMENTOS ALIMENTADOS,15. NUMERO DE COMERCIOS ALIMENTADOS EN EDIFICIOS,14. NUMERO DE DEPARTAMENTOS ALIMENTADOS,49. NUMERO DE DEPARTAMENTOS EN EDIFICIOS PROYECTADOS,50. NUMERO DE COMERCIOS EN EDIFICIOS PROYECTADOS,51. NUMERO DE LOTE BALDIO")))) (repeat (setq x (sslength ss)) (setq txtnum (atof (cdr (assoc 1 (entget (ssname ss (setq x (1- x)))))))) (setq tot (+ tot txtnum)) ) (command "text" (getpoint "Pick point for text ") 3.0 0.0 (rtos tot 2 0)) (princ) ) (c:5blks)

But that isn't brilliant. A quick 13 character test found 13 letters - including 2 that were the dots above the letter i, 2 were missed. At an angle of 32 degrees it didn't convert any. The help suggests converting the characters 1 by 1 and then checking, and recombining - not brilliant yet. A LISP I part built a while ago asked the user to select the lines that made up a word or sentence, gave a pop up box for the user to retype the word. The original lines were deleted and that text inserted, angled and sized to the longest lines on the assumption that these were the uprights. A couple of tweaks to set the text to a standard size (so no 2.4876 height - it would be 2.5) and the angle was a mean angle between the uprights. It didn't work well so left it on the 'come back later' pile