Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Q&A with Qlik - Qlik Cloud Migration: Questions about migrating to Qlik Cloud? Catch the latest replay!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Publisher Datetime Format

Hi

Does anybody know where the Publisher Datetime Format is set ? 

[So I know what it is to configure the Governance Dashboard]

Many Thanks,     Bill

Labels (1)
1 Solution

Accepted Solutions
Tyler_Waterfall
Employee
Employee

I believe it's just the system timestamp format (where the Publisher is running).

However, you can easily find out by opening a TaskResult_*.xml log in the

C:\ProgramData\QlikTech\DistributionService\TaskResults folder (for Win7 or Server 2012)

and taking note of format of the "StartedAt" timestamp.

View solution in original post

3 Replies
Tyler_Waterfall
Employee
Employee

I believe it's just the system timestamp format (where the Publisher is running).

However, you can easily find out by opening a TaskResult_*.xml log in the

C:\ProgramData\QlikTech\DistributionService\TaskResults folder (for Win7 or Server 2012)

and taking note of format of the "StartedAt" timestamp.

ashfaq_haseeb
Champion III
Champion III

Anonymous
Not applicable
Author

Tyler

Many thanks for the pointer the xml log files, the contents of one is pasted below.

From this I sussed the Publisher Date Format need to be DD/MM/CCYY H*24:MI:SS

This url I also found useful.

http://documentation.qlik.com/governance-dashboard/1.1/QlikView_help.htm#Publisher_datetime_format.h...

<?xml version="1.0" encoding="UTF-8"?>

-<Root Modified="2014-05-23T14:26:10.1996534Z" Status="Finished" HasWarnings="False" StartCount="7435" MaxRunTime="1.00:00:00" FinishedAt="23/05/2014 14:26:10" StartedAt="23/05/2014 14:25:44" LastExecution="23/05/2014 14:25:44" InternalError="False" PreviousRunHadErrors="False" TaskException="" TaskManuallyAborted="False" RunID="bc2181b0-0435-4f79-b147-6e0519ae4b88" OwnedByClusterID="2" TaskID="62020c03-aac8-43c5-a2dd-e1f01a8b2b74">-<LogFinalEntries><LogFinalEntry Text="Executing commandline: "C:\QV.Menzies\Ops.Monitor.with.Cal\RefreshUserCALData.bat" in folder "C:\QV.Menzies\Ops.Monitor.with.Cal"." Date="23/05/2014 14:25:44" Type="Information"/><LogFinalEntry Text="The process exited with ExitCode zero (OK) at 23/05/2014 14:26:10" Date="23/05/2014 14:26:10" Type="Information"/><LogFinalEntry Text="Task Execute Duration=00:00:25.9122644" Date="23/05/2014 14:26:10" Type="Information"/><LogFinalEntry Text="The task "Test QV System: RefreshUserCALData.bat" finished successfully" Date="23/05/2014 14:26:10" Type="Information"/><LogFinalEntry Text="TaskResult.status=Finished" Date="23/05/2014 14:26:10" Type="Information"/></LogFinalEntries></Root>

Best Regards,     Bill