{{Under construction | This page is under construction}}The IMSMA Staging Area Generator is a tool that allows to create creates a staging area from an IMSMA {{IMSMANG}} database. It is thus part of the {{IMSMANG}} tool set, but not directly integrated into included in the {{IMSMANG}} installation package. It IMSMA Staging Area Generator thus needs to be installed separately. Please contact your country focal point [[Information Management Team | GICHD IM advisor]] in order to get the latest installation package.== Installing the IMSMA Staging Area Generator==__NOEDITSECTION__<ol><li>To install the staging area generator (SAG) double-click on the '''etl.exe''' file..</li><li>The graphical installer then starts. On the first screen, choose the language you would like to use for the installation and click '''OK'''.[[Image:SAGInstallStep1.png|center|200px]]</li><li>Navigate the Installation panels of the graphical installer as described below:<ol><li>On the Welcome screen, click '''Next'''.</li><li>On the Infromation screen, click '''Next'''.</li><li>We strongly recommend to use the default installation path for the Staging Area Generator. '''Click Next'''.</li><li>If the target folder (C:\IMSMAETLTool) does not already exist a message will be shown, click '''OK'''. </li><li>In the packages selection panel, click '''Next'''.</li><li>Wait for the installation progress bar to finish, then click '''Next'''.</li><li>When the Setup Shortcuts panel displays, click '''Next'''.</li><li>When the installation has completed successfully, click '''Done'''.</li></li></ol></ol>After the installation, the following menu entry will be visible in Start → All Programs → IMSMA:[[File:Staging_Area_Generator_Icon.png]]<br />
==Using the IMSMA {{Note | The Staging Area Generator==__NOEDITSECTION__can only be used with {{IMSMANG}} 6.0 and higher.}}===Basic Principles===__NOEDITSECTION__===Where to use it===__NOEDITSECTION__===The Staging Area Generator Graphical User Interface===__NOEDITSECTION__To start the Staging Area Generatortakes an {{IMSMANG}} database as input and outputs a staging area database, click on the Staging Area Generator Icon in Start → All Programs → IMSMAi. This will open the following graphical user interfacee.[[Image:Staging_Area_Generator_GUI.png|center]]<br />{| class="wikitable" width="1000"|-| align="center" colspan="2" | '''Sections in a flattened version of the Staging Area Generator user interfaceIMSMA database, containing only '''|-| width="200pt" | approved'''Section''' | width="800pt" | '''Description'''|-| align="left" | '''1 - Source Database''' | align="left" | This section defines the connection data. The structure of the source database, i.e. the {{IMSMANG}} database from which a staging area should be generated. If the source and the target databases should be a details on the same computer, the default connection parameters data it contains can be kept. If the staging area is generated found on another server, then the IP address of the source server hosting the {{IMSMANG}} database has to be provided in the '''Host''' field.|-| align="left" | '''2 - Target Database''' | align="left" | desc|-| align="left" | '''3 - Post Processing SQL Scripts''' | align="left" | desc|-| align="left" | '''4 - Additional Options''' | align="left" |* '''Conversion Language:'''* '''Gazetteer Seq No:'''* '''Do Geodata:'''* '''Target SRID:'''|-|}[[Image:Staging_Area_Generator_GUI_options.pngStaging Area Database|centerIMSMA Staging Area Database]]page.
==When creating the Staging Area database with the [[Using Staging Area Generator | Staging Area Generator]] is possible to choose:* which language to use* which Country structure name to use (main or any of the alternative names)* if PostGIS geodata should be created* which projection to use* to do data post-processing. It is easy to [[Scheduling the Staging Area creation==__NOEDITSECTION__| schedule the creation]] of the Staging Area database.
