Builder Service

Builder / Bulk Loader Installation and Configuration

The builder / bulk loader is a service application which runs in the background on a server. To perform some of the necessary tasks, several outside applications are necessary.

For additional information about this service, see the Builder / Bulk Loader Architecture Page.

Server Information

It is recommended to use a 64-bit version of the latest Microsoft Server operating system. (i.e., Server 2008 R2 64-bit).

Generally it is recommended that it runs on a different server than the web server, since this will perform some CPU and memory intensive processes when creating image derivatives for example. This process will perform alot of database and solr/lucene updates, so it is recommended that it run on the same server as one or both of those services.

The builder must have access to the web server, database server, and solr/lucene server.

Software Installs

Installation of the following software packages is required for the builder to perform all processing steps. Recent versions of all of these are also present in the install bundles.

Latest version of GhostScript ( gs902w##.exe in the install bundles ) for creating thumbnail images for submitted PDFs.
Latest version of ImageMagick ( ImageMagick-6.7.1-0-Q16-windows-dll.exe in the install bundles ) for image derivative creation. If you download the latest version, the 16-bit windows dll version is recommended. You should restart the server after this install.
A recent version of Microsoft Office for converting Word and Powerpoint documents to PDF. (This process is automated through the builder).
Run the installation MSI for the builder / bulk loader. ( 32-bit MSI | 64-bit MSI )

Configuration

Scheduled Task

This service is actually a console application which will run in the background until 11:00 pm (by default) every evening. It should be added as a scheduled task to start early each morning (usually 4am) so it can run continuously. It will sleep for a minute after each execution process before waking up and trying to perform more work. Set this task to run under the service account with highest priviledges. By default, the service will stop at 11pm each night. The action will be launching the SobekCM_Builder.exe application and the argument '--background' should be utilized to have the application run in background mode, rather than only once.

The screen shots below show the proper settings for the scheduled task.

Figure 1: Scheduled Task General Settings

Figure 2: Scheduled Task Triggers Settings

Figure 3: Scheduled Task Trigger Details

Figure 4: Scheduled Task Action Settings

Figure 5: Scheduled Task Action Details

Builder Configuration

The builder application installs with a small configuration application. The first time it is installed on your machine, it should automatically launch. In addition, you can launch the configuration process in one of two ways, at any time:

Launch the SobekCM Builder from the command-line with '--config' as an argument
Navigate to the config subfolder under the application and launch the configuration tool there

The localization information for your instance of the SobekCM Builder is saved in a small XML file under the config subfolder. This configuration file provides several very basic configuration options for the builder:

Database Type	Microsoft SQL Server is currently the only supported database, but work is progressing on adding PostgreSQL as an option.
Database Connection String	Connection string to connect the Builder to the SobekCM database.
Ghostscript Executable File	Path and name for the Ghostscript executable file, which is used to convert PDFs into TIFFs.
ImageMagick Executable File	Path and name for the ImageMagick executable file, which is used for image manipulation and jpeg creation.

Table 1: SobekCM Builder Settings in the Configuration File

The included configuration tool provides access initially to those settings during the install process. You can select the wrench next to the connection string box to have the system help you build a Microsoft SQL Server connectoin string.

Figure 6: SobekCM Configuration Form

Once you enter all the data necessary, select SAVE to rewrite the configuration file for the builder.

You can also use the configuration options to establish the SobekCM Builder incoming folders to use.

This completes the configuration of the Builder/Bulk Loader server.