Transferring user accounts from ASP.NET to MojoPortal Occasionally we need to transfer user accounts from existing ASP.NET membership based sites into MojoPortal Note : if the databases are on the same server, or can be linked, then it is possible to ... read more Posted by 04 March 2013 Categories: mojoPortal SQL Server Comments(0)
QGIS field calculator backslash gotcha Quantum GIS has a powerful field calculator, similar to that in ArcGIS, and described here. I was using it to update a tile index shapefile for use with GeoServer and a folder full of georeferenced... read more Posted by Crispin Flower 28 February 2013 Categories: Quantum GIS (QGIS) Comments(0)
How to set the spell checking language in CKEditor as used in mojoPortal mojoPortal uses either CKEditor or TinyMCE as the default HTML editor. We tend to use CKEditor. The default configuration is American English. To change this in such a way that mojoPortal... read more Posted by Crispin Flower 14 February 2013 Categories: mojoPortal Comments(0)
MapLink issue when packaged with ArcMap 10 and HBSMR or CAMS using AppV ArcGIS (v10 on) no longer reads component categories from the registry, instead component category information is read from configuration files (*.ecfg) stored in: C:\Program Files... read more Posted by 17 December 2012 Categories: AppV CAMS HBSMR MapLink Comments(0)
British National Grid in MapInfo A problem frequently encountered with sharing data between MapInfo and ArcGIS is that the British National Grid projection used by ArcGIS is accurate to 1 mm, whilst the standard projection used... read more Posted by Mike Lush 28 November 2012 Categories: GIS (general) MapInfo Professional Projections Comments(2)
How to take a SQL Server backup without breaking the backup sequence When a SQL Server is configured to run scheduled full backups followed by a sequence of differential backups, taking an ad hoc backup will affect how backups can be restored, potentially breaking the ... read more Posted by Crispin Flower 06 October 2012 Categories: SQL Server Comments(0)
WMS GetFeatureInfo in OpenLayers on right click Assuming that one already has a WMSGetFeatureInfo on the map then its quite simple: Add new class Use new class New class // A control class for capturing click... read more Posted by Stewart Bellamy 01 October 2012 Categories: OpenLayers WMS Comments(1)
Handling different character encodings when importing tabular data from CSV I’ve been fixing some minor issues with the utility in HBSMR that imports data from the Portable Antiquities Scheme. One issue was that some characters were mojibaked during the import, for example... read more Posted by Crispin Flower 24 September 2012 Categories: HBSMR MS Access VBA Comments(0)
How to drop all connections to a SQL Server database Mike S-G has passed me this useful tool for dropping all connections from a database. This is required before deleting or re-naming databases, for example. This creates a stored procedure in... read more Posted by Crispin Flower 18 September 2012 Categories: SQL Server Comments(0)
Windows updates break MS Common Controls Tree Control This is a replacement blog-post, based on our developing understanding of the problem and users' experiences. It appears that the update that disrupts the operation of 'tree' controls in HBSMR v3 and ... read more Posted by Crispin Flower 16 August 2012 Categories: HBSMR Microsoft Office MS Access Comments(0)