Zynk Workflow Documentation

ZLM Icon

You can use Zynk Log Manager (ZLM) to perform a variety of operations on your two Zynk databases (Zynk.sdf and Log.sdf).

The two database files are located in your data directory, typically this is C:\ProgramData\Zynk Software\Zynk\2.0, although if you have configured a custom data directory in ‘Tools -> Options’ your database files will be located there. You can browse to your custom data directory if necessary.

As the Sql CE version was updated to 4.0 in version 2.16 of Zynk Workflow, you can select whether to use a Sql CE 3.5 connection or a Sql CE 4.0 connection. For clarification, please see the below: -

If you enter the correct Sql CE version, the full path to your database file, your password (if required), size and click connect, you can query the database you’ve selected for information.

If you enter all the above information and don’t click connect, you can verify (test the connection), compact, repair and shrink your database.

General Settings

Database

Required
The database (.sdf) file you are looking to repair, shrink, verify or query.

Password

Optional
If your Zynk database is password protected, enter the password in this setting.

Size

Required
The maximum size of the database you’re connecting to (4091 default).

Compact To

Optional
If you’re compacting your database, optionally write the resulting .sdf file to a different location.

Size (Manage)

Optional
The maximum size of the database your compacting to.

Records Settings

Please note, you must be connected to a database to configure and use these settings.

Keep the logs for the last

Optional
Optionally remove log files for a period of workflow runs or time.

Remove all logs

Optional
This setting will erase all log entries from the database when enabled.

Remove orphaned logs

Optional
This setting will remove orphaned logs from the database when enabled. An orphaned log is an entry in either the Log or JobItem table that has no related entry in the Job table.

Remove all truth entries

Optional
This setting will remove all truth entries from the truth database when enabled.

Query Settings

Please note, you must be connected to a database to configure and use these settings.

Workflow

Optional
If you are looking to query a specific workflow, and are unsure how to do so, select a workflow from the drop down list and then select one of the available query templates.

Query Template

Optional
Optionally use one of the available query templates and click ‘Send to Query Editor’ to run and edit the query.

Query

Required
Enter your query manually or select one of the available query templates and click ‘Execute’. Your results will appear in the window below which you can export or send in csv, xml or html.

Exporting and Sending Query Data

Once you have successfully executed a query in Zynk Log Manager (ZLM) you can choose to export and/or send the data in one of the following formats:

If you choose to send an email with an attachment of the data, you can use the default Zynk Workflow SMTP connection, but we’d prefer you to use your own if possible.

Examples

Please see below a series of screenshots of the Zynk Log Manager (ZLM).

Zynk Log Manager General Tab
* Not connected to database

Zynk Log Manager Records Tab
* Connected to database

Zynk Log Manager Query Tab
* Connected to database

Zynk Log Manager Query
* Connected to database

CSV

Id,Profile,Type,InternalId,ExternalId,Hash,Created,Modified,Purge,Collection
164,d3f9adfe-6002-41f2-bb98-fd0bc6e6154c,Zynk.SAAS.Peoplevox.Objects.ItemType,1152593,01152593,757602046,26/09/2018 14:41:20,26/09/2018 14:41:20,,

XML

<?xml version="1.0" encoding="utf-8"?>
<QueryResults>
  <QueryResult>
    <Id>164</Id>
    <Profile>d3f9adfe-6002-41f2-bb98-fd0bc6e6154c</Profile>
    <Type>Zynk.SAAS.Peoplevox.Objects.ItemType</Type>
    <InternalId>1152593</InternalId>
    <ExternalId>01152593</ExternalId>
    <Hash>757602046</Hash>
    <Created>26/09/2018 14:41:20</Created>
    <Modified>26/09/2018 14:41:20</Modified>
    <Purge />
  </QueryResult>
</QueryResults>

HTML

Zynk Log Manager HTML Example * Right click and open image in new tab for better viewing


Back | Edit on Github