More output is now written to the '''etl.log''' file.
{{Note|This is only required in case of doubt/error, when more details are needed in order to investigate what goes wrong.}}
==Scheduling the Staging Area creation==__NOEDITSECTION__The above described generation of a staging area needs human interaction. However, once all the options are fixed, there might be the requirement to re-generate the staging area regularly, in order to have an up-to-date reporting database. It is possible to automatize the staging area generation by following these steps:<ol><li>In the C:\IMSMAETLTool folder, create a .bat script named for example '''runStagingArea.bat''' with the following content:<pre>cd C:\IMSMAETLToolcall bin\runnogui.bat</pre></li><li>Edit the properties file C:\IMSMAETLTool\conf\config.PROPERTIES by specifying the required values for all the parameters (they correspond to the ones from the graphical user interface described above). If a parameter should not be used, e.g. '''script_file''', then comment it by placing a # at the beginning of the line:<pre>conversion_language=engazetteer_sequence_level=0#script_file=scripfile.sql</pre></li><li>Schedule a task in an operating system's task scheduler. For example, using Windows 7, follow those steps:<ol><li>Go to Control Panel → Administrative Tools → Task Scheduler</li><li>In the Task Scheduler interface, click on '''Create Basic Task...'''</li><li>In the Create Basic Task Wizard, provide a name, e.g. '''Staging Area Generation''' and an optional description. Click '''Next'''.</li><li>In the next window, specify the required recurrence (daily, weekly, etc.) and click '''Next'''.</li><li>Next, refine recurrence criteria (e.g. time of the day) and click '''Next'''.</li><li>In the next window, select '''Start a Program''' and click '''Next'''.</li><li>Browser to the previously created script, e.g. C:\IMSMAETLTool\runStagingArea.bat. Click '''Next''' and then '''Finish'''.</li></ol></li></ol>The staging area generation should now start at the specified time. <br/>[[Image:SAGTaskScheduler.png|center|800px]]It is advised to plan the generation time carefully, i.e. best during the night when no one is accessing and entering data into {{IMSMANG}}, as this might lead to inconsistencies. Ideally, the IMSMA server should be stopped before the staging area generation and then restarted. It also needs to be assured that no one (and no automatic reporting process) is accessing the staging area database at the time it has to be re-created. As long as there are open connections to the database, it cannot be dropped and re-created. Contact your GICHD IM advisor in case of questions.
{{NavBox Business Intelligence}}
[[Category:VIE]]
