Microstation Tagset export and import
The Microstation Tagset system collects multiple values and stores them as a one table. Tagsets are commonly used to store drawing title block data e.g. initilals, dates, document numbers, etc. Individually editing tagsets, although easier than editing plain texts, is still a tedious and time consuming process. Editing these tagsets requires the user to open each individual drawing, open the tagset tables, and then finally type in new values. Consequently, having hundreds of documents be revised with this process is simply too time consuming in the context of larger engineering projects.
The program solves this inefficiency by utilizing Excel. The script eliminates the need for individual alterations by exporting all tagsets to Excel. Excel allows the user to easily select and alter numerous tagsets simultaneously. Any tagsets altered in the program can be automatically imported back to Microstation documents.
Text export from CAD to Excel
CAD documents with data stored as a regular text can be difficult to navigate. Some designers do not keep track of where the date is stored, so finding information can sometimes take an excessive amount of time.
The Microstation text scanner script has been written to address that issue. It makes an inventory of CAD documents content in easy to search Excel spreadsheet.
The program opens each CAD documents and scans all texts. Each found text is checked if meets user criteria and if it does, it is written to Excel spreadsheet with a file name where it appears. The exported texts can be compared with database e.g. IO or cable list with Compare Excel spreadsheets or Levenshtein distance
Find and point
Having a list of items to be checked on CAD drawings requires series of operations for each list item. Find CAD file, open it and if the drawing is busy search it with find/replace function.
The script Find and Point simplifies that process to just one NEXT button click.
The program opens CAD file shown in the list and scans all texts and cells and tagsets for the desired item. Once found it highlights text and zooms in view. The small popup window shows additional data taken from other Excel columns. Clicking NEXT proceeds to next list item. Both Excel and CAD documents can be edited while program is running.
