Qlik Subroutine - Write To Log File

Meant to be paired with:

• Qlik Subroutine - Check Log File Exists

SUB WriteToLogFile(mProcess,mApp,mSection,mType,vStart,mLog_Message,mUser,mTags)
/*
	Assumes:
	- CheckLogFileExists() has already run
	- vStart has been assigned the starting timestamp for the given task that is being logged
 
	Adds a single line to the $(vLoaderLogFileLocation) QVD file. This is intended to add a single row ot the logging table that includes the start / end time of that task, for transparency and meta metrics.
*/
 
	zLoaderLog:
		ID,
		RunID,
		Process,
		App,
		Section,
		Type,
		TaskStart,
		TaskEnd,
		Log_Message,
		User,
		Tags
	FROM [$(vLoaderLogFileLocation)] (QVD);
 
	LET vEnd = TimeStamp(Now());
 
	LET vMaxID = PEEK('ID',-1,'zLoaderLog');
	LET vMaxID = vMaxID + 1;
 
	CONCATENATE (zLoaderLog)
		LOAD
			*
		INLINE [
			ID,RunID,Process,App,Section,Type,TaskStart,TaskEnd,Log_Message,User,Tags
			$(vMaxID),$(vRunID),"$(mProcess)","$(mApp)","$(mSection)","$(mType)","$(vStart)","$(vEnd)","$(mLog_Message)","$(mUser)","$(mTags)"
		];
 
	STORE zLoaderLog INTO $(vLoaderLogFileLocation);
 
	DROP TABLE zLoaderLog;
 
	// If keeping track of specific meta information related to ID, that subroutine can be called here
 
END SUB;