Logging

Back to index page

Basically there are five components relating to JChem for Excel which the user can expect log files generated from.

 

JChem for Excel: This folder represents logging information of the core JChem for Excel components .

CXNdotNetClassCOMLoader: This logging folder contains log files if .NET components are about to be loaded, typical case when .NET part of JChem for Excel begins to run.

CXNOLEClient: OLE Client component is used when the JChem for Excel system structures are converted to Marvin OLE shapes.

Marvin OLE: This logging folder represents all logging information written out from the OLE sketch in the case of JChem for Excel image conversion.

JChem for Excel API: When JChem Excel programmatic interface is used (external API) log files can be expected in this folder.

 

Component specific folders can be found in the ChemAxon root folder under the following locations:

Windows XP: C:\Documents and Settings\{CURRENT USER}\Application Data\ChemAxon
Windows Vista or above: C:\Users\{CURRENT USER}\AppData\Roaming\ChemAxon

If the users turn to support help, these folders need to be zipped and sent to the relevant support team/department. Please take care of that log files might contain confidential local information (molecules) therefore log files are better to be sent directly to the support teams. Forum posts are public and searchable for other users therefore should be avoided for any log file uploading. Support teams handle the logging information confidentially.

How to set logging

In JChem for Excel (but also true for other components listed above) the verbose and style of the logging can be set in the following location of the registry: HKEY_CURRENT_USER\Software\ChemAxon\\JChem for Excel. Under the Verbose registry key there are five options to be set:

 

DateFormat: The default time format of the logging is %H:%M:%S. Log files are separated by dates so the relevant date information can be seen in the name of the log file as default. User can freely customize it to include full date time if necessary. Microsoft DateTime formatting guidelines

FileExtension: This setting contains the file extension of the log file.

FileName: The name of the log file can also be changed, but it should keep the rules of file name generation under Windows.

Level: This is the most important setting for both the users and the adminsitrators. It allows to change the verbose level, i.e. how much information the log file needs to contain.

FATAL (0): Reports only fatal errors. We do not use this and it is not recommended. All error level problems should be logged.
ERROR (1 Default): Recommended setting for error reporting.
WARNING (2): Reports the more problematical things, which are not error but relevant for support.
INFO (3): Lighter infromation, which can be very useful in the case of support.
DEBUG (4): Development level information, e.g. Variable contents.
ALL (5): All logging.

 

Logging level can also be set from user interface of JChem for Excel if the options module can be

loaded without any problems please see relevant section of the user guide here:

Office 2003

Office 2007

 

MessageFormat: The default format is {%s [%d]%s %s - %s} e.g.: 10:13:43 [1]ERROR JCHEMforEXCEL - Error displaying help.

 

%s : the formatted date/time stamp value indicating the moment when the log information arrives in the logger component.
[%d] : level of the current logging
%s : name of the current logging level
%s - %s : application domain name - and the message itself

 

Microsoft message formatting guidelines

 

Event logging

All CXN components, and applications like JChem for Excel, also place error level log information in the System Event Log (in addition to the log file). Microsoft Event Log Guide Event Viewer shows all types of logs, ChemAxon generally reports problems under the Application section.


Back to index page