ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / Managing databases / HFSQL / Managing log processes
  • Overview
  • Data file JNL_FILES.FIC
  • Data file JNL_OPERATION.FIC
  • Data file JNL_USERS.FIC
  • Data file *JNL.FIC (log file)
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
Structure of log files (HFSQL Client/Server)
HFSQL Client/ServerAvailable only with this kind of connection
Overview
The following files are automatically created when logging an HFSQL Client/Server data file:
JNL_FILES.FICDescription of log data files.
JNL_OPERATION.FICDescription of actions performed on a log data file.
JNL_USERS.FICDescription of users performing an action on a log data file.
xxxJNL.FICFile created for each log data file. Contains the value of records used before and after each operation.

These files are created according to the following structure:
1. __JNL directory
This directory contains:
  • The data file log file.
  • The user log.
  • The operation log.
  • For each log data file in each database, the corresponding log file. The tree structure used corresponds to the tree structure of the data files associated with the database.
For exampleif DataApplicationA's Command data file is logged, the subdirectory __JNL\DataApplicationA will contain the data file CommandJNL.FIC.
Another example If the Customer data file of DataApplicationB is jounalized, the subdirectory __JNL\DataApplicationA\Customer will contain the data file CustomerJNL.FIC.
2. Database directory DataApplicationA
3. Database directory DataApplicationB
This page presents the structure of these files.
Data file JNL_FILES.FIC
The various fields in the JNL_FILES.FIC data file are as follows:
JNLFile_IDData file identifier.
Source_DB_File_LocationName of database + '\' + relative path of log file.
Source_File_GUIDGUID of log data file.
JNL_File_GUIDGUID of write-to-file log.
Data file JNL_OPERATION.FIC
The various fields in the JNL_OPERATION.FIC data file are as follows:
Operation_IDIdentifier of the operation.
USER_IDIdentifier of user who performs the operation. This identifier corresponds to the identifier of the data file JNL_USER.Fic
JNLFile_IDIdentifier of logged file where the operation is performed. This identifier corresponds to the identifier of the data file JNL_FILES.Fic.
WLFunction_IDIdentifier of the WLanguage function used in the program. To find out the name of the WLanguage function used, simply check the ListeDéfinitionHF.WL file (located in the "Personal\Extern\" subdirectory of the product)
Server_TimeDate of operation on the server (in UTC format, universal time)
Record_NumberNumber of the modified record
Source_Record_Backup_IDIdentifier in the file of values. Corresponds to the record value before the operation.
Modified_Record_Backup_IDIdentifier in the file of values. Corresponds to the record value after the operation.
HLogInfoMsgValue defined by HLogInfo.
HComputer_IDText defined by HComputer.
Data file JNL_USERS.FIC
The various fields in the JNL_USERS.FIC data file are as follows:
USER_IDUser identifier.
LoginUsername.
Workstation_NameName of user computer.
Workstation_IPAddressIP address of user computer.
ApplicationApplication name
Data file *JNL.FIC (log file)
The data file *JNL.Fic contains:
  • the items found in the table below,
  • all log fields in the corresponding HFSQL log data file.
USER_IDIdentifier of the user who performed the operation. This number identifies the record in the JNL_Users.Fic data file
Record_NumberRecord number in original log file.
Record_StatusRecord status (modified, deleted, added, ...)
WLFunction_IDIdentifier of the WLanguage function used in the program. To find out the name of the WLanguage function used, simply check the ListeDéfinitionHF.WL file (located in the "Personal\Extern\" subdirectory of the product used)
Server_TimeDate of operation on the server (in UTC format, universal time)
HLogInfoMsgValue defined by HLogInfo.
HComputer_IDText defined by HComputer.
IDJNLIdentifier of the log
Minimum version required
  • Version 10
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 12/08/2024

Send a report | Local help