 <?xml-stylesheet type="text/css" href="https://www.esdm.co.uk/Data/style/rss1.css" ?> <?xml-stylesheet type="text/xsl" href="https://www.esdm.co.uk/Data/style/rss1.xsl" ?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:itunes="http://www.itunes.com/dtds/podcast-1.0.dtd">
  <channel>
    <title>The knowledge base blog</title>
    <link>https://www.esdm.co.uk/knowledge</link>
    <description />
    <docs>http://www.rssboard.org/rss-specification</docs>
    <generator>mojoPortal Blog Module</generator>
    <language>en-GB</language>
    <ttl>120</ttl>
    <atom:link href="https://www.esdm.co.uk/Blog/RSS.aspx?p=138~108~58" rel="self" type="application/rss+xml" />
    <itunes:owner />
    <itunes:explicit>no</itunes:explicit>
    <item>
      <title>ArcGIS MapLink: finding and checking dll registration</title>
      <description><![CDATA[<p>The ArcGIS extension (XGMapLinkArcGISExtension.dll) is located using COM registration.</p>

<p>If you have multiple installations it can be confusing working out which copy you are actually running.&nbsp; Looking in the registry at:</p>

<blockquote>
<p>HKEY_CLASSES_ROOT\Wow6432Node\CLSID\{EDFA6FE2-C2C5-4BE1-9F12-F1ED37D85EE2}\InprocServer32</p>
</blockquote>

<p>will tell you where the file(s) are being run from.</p>

<p>If you want to manually register the dll to a particular location you need to open a cmd window as Administrator and then run:</p>

<blockquote>
<p>C:\Windows\Microsoft.NET\Framework\v4.0.30319\regasm.exe /codebase /tlb C:\AMS\CMSI_v2.2.0a\code\XGMapLinkArcgisExtension.dll</p>
</blockquote>

<blockquote>
<p>C:\Program Files (x86)\Common Files\ArcGIS\bin\ESRIRegasm.exe" /p:Desktop C:\AMS\CMSI_v2.2.0a\code\XGMapLinkArcgisExtension.dll</p>
</blockquote>
<br /><a href='https://www.esdm.co.uk/arcgis-maplink-finding-and-checking-dll-registration'></a>&nbsp;&nbsp;<a href='https://www.esdm.co.uk/arcgis-maplink-finding-and-checking-dll-registration'>...</a>]]></description>
      <link>https://www.esdm.co.uk/arcgis-maplink-finding-and-checking-dll-registration</link>
      <author>()</author>
      <comments>https://www.esdm.co.uk/arcgis-maplink-finding-and-checking-dll-registration</comments>
      <guid isPermaLink="true">https://www.esdm.co.uk/arcgis-maplink-finding-and-checking-dll-registration</guid>
      <pubDate>Wed, 25 Sep 2013 08:17:00 GMT</pubDate>
    </item>
    <item>
      <title>Fixing ArcGIS personal geodatabase autonumber problem</title>
      <description><![CDATA[<p>A number of HBSMR&nbsp;clients have been experiencing problems with creating new features in ArcGIS personal geodatabases via MapLink, resulting in a error similar to this:</p>

<pre style="line-height: 21.59375px;">
<em><strong>Your edits could not be saved
Error HRESULT E-FAIL has been returned from a call to a COM component.
Would you like to keep the temporary edit layers in the map?</strong></em></pre>

<p style="font-size: 19px;">The problem is due to a fault with the MS Access database that forms the geodatabase, which means after a feature has been moved or deleted the database tries to reuse that ID value and this upsets the autonumber process, or so we believe.</p>

<p style="font-size: 19px;">At present we do not have a solution to this problem but we do have a bit of code that can be used to reset the autonumber values for any chosen field. This code can be used as a function and bundled in an mdb with a macro that runs the function and sent out to clients as needed. The code for the functions is as follows (this was originally Hartmut's code but I modified from the a sub to a function adding the return and msgbox, just so I could see that something was happening):</p>

<p style="font-size: 19px;">&nbsp;</p>

<p style="font-size: 19px;">Public Function ResetAutoNumber(ByVal tableName As String, ByVal autoNumberColumnName As String)<br />
&nbsp;&nbsp;&nbsp; Dim maxAutoNumber As Long<br />
&nbsp;&nbsp;&nbsp; maxAutoNumber = DMax(autoNumberColumnName, tableName) + 1<br />
&nbsp;&nbsp;&nbsp; DoCmd.RunSQL "ALTER TABLE " &amp; tableName &amp; " ALTER COLUMN " &amp; autoNumberColumnName &amp; " COUNTER(" &amp; maxAutoNumber &amp; ",1)"<br />
&nbsp;&nbsp;&nbsp; ResetAutoNumber = True<br />
&nbsp;&nbsp;&nbsp; MsgBox tableName + " done!"<br />
End Function</p>

<p style="font-size: 19px;">&nbsp;</p>

<p style="font-size: 19px;">And macro simple needs to have a number of RunCode lines that call this function for each of the layers in the personal geodatabase, like so:</p>

<p style="font-size: 19px;">&nbsp;</p>

<p style="font-size: 19px;">RunCode</p>

<p style="font-size: 19px;">&nbsp; &nbsp; &nbsp; &nbsp;Function Name ResetAutoNumber ("Mon_point", "OBJECTID")</p>

<p style="font-size: 19px;">RunCode</p>

<p style="font-size: 19px;">&nbsp; &nbsp; &nbsp; &nbsp;Function Name ResetAutoNumber ("Mon_poly", "OBJECTID")</p>

<p style="font-size: 19px;">RunCode</p>

<p style="font-size: 19px;">&nbsp; &nbsp; &nbsp; &nbsp;Function Name ResetAutoNumber ("Mon_line", "OBJECTID")</p>

<p style="font-size: 19px;">&nbsp;</p>
<br /><a href='https://www.esdm.co.uk/fixing-arcgis-personal-geodatabase-autonumber-problem'>Steve Ellwood</a>&nbsp;&nbsp;<a href='https://www.esdm.co.uk/fixing-arcgis-personal-geodatabase-autonumber-problem'>...</a>]]></description>
      <link>https://www.esdm.co.uk/fixing-arcgis-personal-geodatabase-autonumber-problem</link>
      <author>stevee@esdm.co.uk (Steve Ellwood)</author>
      <comments>https://www.esdm.co.uk/fixing-arcgis-personal-geodatabase-autonumber-problem</comments>
      <guid isPermaLink="true">https://www.esdm.co.uk/fixing-arcgis-personal-geodatabase-autonumber-problem</guid>
      <pubDate>Wed, 29 May 2013 12:42:00 GMT</pubDate>
    </item>
    <item>
      <title>Find "Godzillas" in your ArcGIS feature class (by counting vertices)</title>
      <description><![CDATA[<p>To count the number of vertices:</p>

<ul>
	<li>Add a new field to the feature class called, for example, VertexCount</li>
	<li>Use the Calculate Field tool within the attribute table, or in ArcToolbox, with the following Python expression - !shape!.pointcount</li>
	<li>Sort the feature class on the VertexCount field to find the worst offenders. If there is any bad geometry the expression may trip up, which is informative in itself.</li>
	<li>You can now select only the most complex features for generalising.</li>
</ul>

<p>See the following article for more information. I have not tried the dicing method that is discussed later in the article: <a href="http://blogs.esri.com/esri/arcgis/2010/07/23/dicing-godzillas-features-with-too-many-vertices/">http://blogs.esri.com/esri/arcgis/2010/07/23/dicing-godzillas-features-with-too-many-vertices/ </a></p>

<p>&nbsp;</p>
<br /><a href='https://www.esdm.co.uk/find-godzillas-in-your-arcgis-feature-class-by-counting-vertices'>Sylvina Tilbury</a>&nbsp;&nbsp;<a href='https://www.esdm.co.uk/find-godzillas-in-your-arcgis-feature-class-by-counting-vertices'>...</a>]]></description>
      <link>https://www.esdm.co.uk/find-godzillas-in-your-arcgis-feature-class-by-counting-vertices</link>
      <author>sylvinat@esdm.co.uk (Sylvina Tilbury)</author>
      <comments>https://www.esdm.co.uk/find-godzillas-in-your-arcgis-feature-class-by-counting-vertices</comments>
      <guid isPermaLink="true">https://www.esdm.co.uk/find-godzillas-in-your-arcgis-feature-class-by-counting-vertices</guid>
      <pubDate>Wed, 15 May 2013 11:07:00 GMT</pubDate>
    </item>
    <item>
      <title>MapLink issue when packaged with ArcMap 10 and HBSMR or CAMS using AppV</title>
      <description><![CDATA[<p>
	ArcGIS (v10 on) no longer reads component categories from the registry, instead component category information is read from configuration files (*.ecfg) stored in:</p>
<p>
	C:\Program Files (x86)\Common Files\ArcGIS\Desktop10.0\Configuration\CATID</p>
<p>
	When ArcGIS 10 is packaged in an AppV sequence (bubble), to be used with HBSMR or CAMS, in their own sequences, {a4d1597d-bc1c-4f37-b12a-4bcb2cd2ec2f}_xgmaplinkarcmapextension.ecfg must be present in the <strong>real file store</strong> rather than <strong>Virtual File Store</strong>. Ie&nbsp;:</p>
<p>
	%ProgramFiles(x86)%\Common Files\ArcGIS\Desktop10.0\Configuration\CATID\{a4d1597d-bc1c-4f37-b12a-4bcb2cd2ec2f}_xgmaplinkarcmapextension.ecfg</p>
<p>
	The GUIDs shown above are for MapLink v4. The following GUID: {a315d61f-0f18-41c8-88dc-f650ae76014c} is for MapLink v5 for ArcGIS.</p>
<br /><a href='https://www.esdm.co.uk/maplink-issue-when-packaged-with-arcmap-10-and-hbsmr-or-cams-using-appv'></a>&nbsp;&nbsp;<a href='https://www.esdm.co.uk/maplink-issue-when-packaged-with-arcmap-10-and-hbsmr-or-cams-using-appv'>...</a>]]></description>
      <link>https://www.esdm.co.uk/maplink-issue-when-packaged-with-arcmap-10-and-hbsmr-or-cams-using-appv</link>
      <author>()</author>
      <comments>https://www.esdm.co.uk/maplink-issue-when-packaged-with-arcmap-10-and-hbsmr-or-cams-using-appv</comments>
      <guid isPermaLink="true">https://www.esdm.co.uk/maplink-issue-when-packaged-with-arcmap-10-and-hbsmr-or-cams-using-appv</guid>
      <pubDate>Mon, 17 Dec 2012 15:53:00 GMT</pubDate>
    </item>
    <item>
      <title>Configuring .ini files to use in-built and custom MS Access functions</title>
      <description><![CDATA[<p>
	When configuring the mapping section of an .ini file for any exeGesIS product&nbsp;certain limitations apply to the use of functions to extract data&nbsp;from the&nbsp;relational database. Specifically, functions that need more data than the relevant entity UID&nbsp;need to be 'wrapped' in a DLookup. For example, in the cases of 'NGRoutput' and 'Left', respectively:</p>
<p>
	AccessField1==Dlookup("NGRoutput([Easting],[Northing])","Mon","[MonUID]=""#MonUID#"""))</p>
<p>
	AccessField2==Dlookup("Left([Summary],254)","Mon","[MonUID]=""#MonUID#""")</p>
<br /><a href='https://www.esdm.co.uk/configuring-ini-files-to-use-in-built-and-custom-ms-access-functions'></a>&nbsp;&nbsp;<a href='https://www.esdm.co.uk/configuring-ini-files-to-use-in-built-and-custom-ms-access-functions'>...</a>]]></description>
      <link>https://www.esdm.co.uk/configuring-ini-files-to-use-in-built-and-custom-ms-access-functions</link>
      <author>()</author>
      <comments>https://www.esdm.co.uk/configuring-ini-files-to-use-in-built-and-custom-ms-access-functions</comments>
      <guid isPermaLink="true">https://www.esdm.co.uk/configuring-ini-files-to-use-in-built-and-custom-ms-access-functions</guid>
      <pubDate>Tue, 03 Jul 2012 11:53:00 GMT</pubDate>
    </item>
  </channel>
</rss>