View source for HOWTO:Remove Duplicate Drawings From the Database

{{PageHeader
|shortcut=sdg
|perms=All
|level=All
|desc=Fix duplicate drawings in the drawings database.}}<br>

__TOC__


== Summary ==
Older builds of WireCAD suffer from a condition where it is possible to inadvertently create duplicate drawing names in the drawings database. This occurs when different users map different drive letters to the same file. For example; Bob has mapped the path \\ENG1\WireCAD\Projects to his X:\ drive, while Fred has mapped his Y:\ drive to the same path. In earlier builds of WireCAD - some of which are still in service - encounter this situation a duplicate entry would be created because the paths are different. Recent builds do not suffer from this as they use the UNC path ie: \\SERVER\SHARE\FOLDER instead of the mapped network drive letter. It is still conceivable that a project created with an older build, then subsequently opened with the fixed build would cause the same issue where we would have the mapped path and the UNC path. The following procedure should only have to be done once assuming that WireCAD is using a later build.
[[File:ProjectExplorerDrawingsAndRefresh.png|thumb|Project Explorer]]

== Before You Start ==
Launch WireCAD and open the problem child project.

== HOW TO ==

# Open the Project Drawings Database grid by locating the Project Databases\Drawings node in the Project Explorer or type sdg followed by the [Enter] key in the WireCAD Command Line.
# Click the DrawingPath column header to sort by that field. This will order all of your different paths together.
# Select all drive letter pathed records, ie: x:\xxxx\xx\xx and g:\blah\blah.
# Click Edit>Delete Selected Rows to remove the entries from the database.
# Click File>Save to commit your changes.
# Click the Refresh button at the top of the Project Explorer to rebuild the drawings database.
# Close and reopen the drawings database and make sure that the refresh did not add any additional duplicates. If it did, you have deleted the wrong path. Not to worry. You can delete all records and they will be rebuilt on Project Explorer refresh.