wf_GN4Report.xml is a GN4 workflow which creates and fills in an editorial statistics database. It calls a Report activity for each table to create into the database and contains all the ReportOptions (in serialized xml) needed to work.

Note that wf_GN4Report.xml creates the main statistics table (folders, users, titles…); then, it calls the wf_GN4ReportEdition.xml workflow which manages all the edition data (editions, pages, layers, articles, txts, imgs…)

The wf_GN4Report.xml workflow accepts the following parameters:

•List of edition ids to process or the name of the edition workstate to look for.

•Path of the folder where storing the report xml files or the ODBC connection string to store the statistics data into the reports database.

How to run wf_GN4Report.xml?

You ca run wf_GN4Report.xml as any other workflow:

•Using srv4 wf command (srv4 help wf for help)

srv4 wf GN4Report –pars “workstate:Complete;ODBCString:Driver={SQL Server}\;Server=mySQLServer\;Database=ReportDB\;uid=myDbUser\;pwd=myPassword;”

Note: the workflow parameters are in format name:value;, the semicolon characters in the connection string are escaped by the back-slash.

•Using cmd4 wf command (cmd4 help wf for help)

cmd4 wf GN4Report –pars “workstate:Complete;ODBCString:Driver={SQL Server}\;Server=mySQLServer\;Database=ReportDB\;uid=myDbUser\;pwd=myPassword;”

Note: the workflow parameters are in format name:value;, the semicolon characters in the connection string are escaped by the back-slash.

•Using do.ashx?cmd=wf REST command (http://localhost/gn4/do.ashx?cmd=help&name=wf&x=docBook for help)

http://localhost/gn4/do.ashx?Cmd=WF&Name=GN4Report&Progress=Txt&KA=400&Pars=workstate%3aComplete%3bODBCString%3aDriver%3d%7bSQL+Server%7d%5c%3bServer%3dmySQLServer%5c%3bDatabase%3dReportDB%5c%3buid%3dmyDbUser%5c%3bpwd%3dmyPassword%5c%3b%3b

Note: because of the URL syntax of the REST command, some characters in the connection string are HTTP escaped.

•Using the workflow test page (http://localhost/gn4/test/wfTestForm.aspx)