Index of contents

• Environment and pre-requisites
• Step 1) building FreeXL
• Step 2) building libsqlite
• Step 3) building libxml2
• Step 4) building libspatialite
• Packaging

Environment and pre-requisites

• some version of the MSVC (Microsoft Visual Studio) compiler.
  I've personally used the free (as in free beer) Microsoft Visual C++ 2010 Express edition, but I presume that different versions will work as well.
• a working installation of the osgeo42-setup installer tool.
• check / install the following OSGeo4W package (command shell):
  • msys
• and the following OSGeo4W depending libraries:
  • geos
  • iconv
  • proj
  • zlib
  • zlib-devel

Step 1) building FreeXL

• download the latest sources: freexl-1.0.0e.zip
• uncompress this zip-file
• manually edit the nmake.opt file: change the target destination as follows:
  INSTDIR=C:\osgeo-pack\new\freexl-1.0.0e-1
• then open a Visual Studio Command Prompt shell

• go to the target folder: cd C:\osgeo-pack\new\freexl-1.0.0e-1
  
• it should contain three sub-folders: bin, include, lib
• enter into the lib sub-folder
  • manually remove the static library freexl.lib (not required by OSGeo4W)
  • you'll simply leave the import (aka stub) library freexl_i.lib

Step 2) building libsqlite

• download the latest sources: sqlite-amalgamation-3071700.zip
• uncompress this zip-file
• download nmake.opt and makefile.vc
• now copy both files into the same folder containing the sources
• then manually edit the sqlite3.c source file as follows:

  	#define SQLITE_CORE 1/td>
  	#define SQLITE_AMALGAMATION 1
  	#ifndef SQLITE_PRIVATE
  	# define SQLITE_PRIVATE static
  	#endif
  +	#ifdef DLL_EXPORT
  +	#define SQLITE_API __declspec(dllexport)
  +	#endif
  	#ifndef SQLITE_API
  	# define SQLITE_API
  	#endif

• save your changes, and finally open a Visual Studio Command Prompt

• go to the target folder: cd C:\osgeo-pack\new\sqlite-3.7.17-1
  
• simply copy all files from bin, include and lib into the corresponding folders you'll find on C:\OSGeo4W

Step 3) building libxml2

• download the latest sources: libxml2-2.9.1.tar.gz
• uncompress this gzipped-file
• then open a Visual Studio Command Prompt shell

• go to the target folder: cd C:\osgeo-pack\new\libxml2-2.9.1-1
  
• it should contain three sub-folders: bin, include, lib
• enter into the bin sub-folder
  • manually remove all run*.exe and test*.exe executables(not required by OSGeo4W)
  • you'll simply leave libxml2.dll, xmlcatalog.exe and xmltest.exe
• enter into the include sub-folder
  • this will contain a further libxml2 folder, wich in turn will containt yet another libxml folder
  • you simply have to reposition libxml immediately under the include parent
  • then removing the useless libxml2 folder
  • in other words: after this you'll have -\include\libxml
• enter into the lib sub-folder
  • manually remove both libxml2_a.lib and libxml2_a_dll.lib (not required by OSGeo4W)
  • you'll simply leave the import (aka stub) library libxml2.lib

Step 4) building libspatialite

• download the latest sources: libspatialite-4.1.1.zip
• uncompress this zip-file
• manually edit the nmake.opt file:
  • change the target destination as follows:
    INSTDIR=C:\osgeo-pack\new\spatialite-4.1.1-1
  • change the version number as follows:
    VERSION=4
  • save and exit
• manually edit the makefile.vc file:
  • search for: C:\OSGeo4w\lib\freexl.lib
  • replace as: C:\OSGeo4w\lib\freexl_i.lib
  • save and exit
• then open a Visual Studio Command Prompt shell

• go to the target folder: cd C:\osgeo-pack\new\spatialite-4.1.1-1
  
• it should contain three sub-folders: bin, include, lib
• enter into the lib sub-folder
  • manually remove the static library spatialite.lib (not required by OSGeo4W)
  • you'll simply leave the import (aka stub) library spatialite_i.lib

Packaging

• open an OSGeo4W / MSYS shell
• then simply execute the following commands