gdherbert/findduplicatesaddin

Find Duplicates tool for ESRI ArcMap in VB.Net

FindDuplicatesAddIn

Find Duplicates tool for ESRI ArcMap use, written in VB.Net. Supplied as a Visual Studio 2010 Solution.

ESRI Add-In does not require admin rights to install. Requires Visual Studio and ArcMap SDK to build.

This code is based off of VBA code downloaded from the ESRI site back in 2010, unfortunately I do not have the attribution information of the original writer and am now unable to find the VBA code on the ESRI site. If you know who wrote this please let me know so that I can attribute them correctly.

---

Installing AddIns:

Copy the .esriAddIn file to a local folder, or the well known folder below: Vista/7: C:\Users<username>\Documents\ArcGIS\AddIns\Desktop10.1 XP: C:\Documents and Settings<username>\My Documents\ArcGIS\AddIns\Desktop10.1

Open the appropriate Arc product (eg ArcMap, ArcGIS Explorer). Choose Customize, Add-In Manager. If you placed the Add-In in a well known location then it should appear in the My Add-Ins section. If it is elsewhere, click the options tab and add the folder location that you placed the AddIn into. Make sure that you have selected the “Load all Add-ins without restrictions” radio button as this add-in is not digitally signed. Click Close and reopen the Add-In Manager. You should now be able to see all the add-ins in the Shared Add-ins or My Add-ins section.

Click the Customize button and choose the commands tab. In the Add-In Controls category you will find the various add-ins available, drag them to a toolbar to access them.

findduplicatesaddin's Issues

Error when selecting get fields and layers is highlighted in TOC

System.InvalidCastException: Unable to cast COM object of type 'System.__ComObject' to interface type 'ESRI.ArcGIS.Geodatabase.ITable'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{FCB01CB5-9F0B-11D0-BEC7-00805F7C4268}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).
at FindDuplicatesAddIn.frmFindDups.btnGetFields_Click(Object sender, EventArgs e) in C:\Projects\Addins ArcMap\FindDuplicatesAddIn\FindDuplicatesAddIn\frmFindDups.vb:line 54

Error when text file is selected in TOC

Unhandled Exception occurs trying to Find Duplicates when text file is selected in TOC.
Field list is successful. Also No Field Selected error when first field is selected rather than unhandled exception.

Error HRESULT E_FAIL has been returned from a call to a COM component.

************** Exception Text **************
System.Runtime.InteropServices.COMException (0x80004005): Error HRESULT E_FAIL has been returned from a call to a COM component.
at ESRI.ArcGIS.Geodatabase.TableSortClass.set_Table(ITable Table)
at FindDuplicatesAddIn.frmFindDups.btnFindDups_Click(Object sender, EventArgs e) in C:\Users\Grant\Documents\Coding ESRI\Addins ArcMap\FindDuplicatesAddIn\FindDuplicatesAddIn\frmFindDups.vb:line 243
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Closing table window on ArcMap increase speed of the research

Searching 2500 duplicates on a 8000 features class on ArcMap 10.5.1 , the research takes:

• around 3'15" with table, "Show only the selected records" view
• around 6" with table opened, "All records" view
• around 2" with table closed.

Maybe you can add a comment in the help?
Or force to close the table?