Symphony Framework
Symphony Utilities

Symphony Framework provides a number of utilities

 

 Symphony ISAM Manager

The Symphony ISAM Manager allows you to access and manage data in your ISAM files.  This powerful tool uses code-generated Symphony Data Object classes to expose the underlying data in the ISAM file as it's constituent fields.  Using the Symphony ISAM Manager you can query and maintain the data in the files using standard SQL commands.  For example;

"SELECT * FROM CUSTOMER_FILE"

will return all the data from the CUSTOMER_FILE.  you can limit the results by defining the fields you wish to view and the criteria to define the records to query;

"SELECT CUS_CODE, CUS_NAME FROM CUSTOMER_FILE WHERE CUS_STATUS != 0"

You can also manage the data in the file using standard SQL query commands, for example;

"UPDATE CUSTOMER_FILE SET CUS_STATUS = 3 WHERE CUS_CODE = 'C199856'"

and also delete records from the file with;

"DELETE FROM CUSTOMER_FILE WHERE CUS_CODE = 'C199856'"

Review the Symphony ISAM Manager for full details.


 Symphony Event Viewer

The Symphony Event Viewer allows you to view and monitor real-time events being posted by Symphony Framework elements and your application. 

Writing to the Symphony Event Log from you application allows you to provide real-time monitoring of your systems within the Symphony Event Viewer.  To create an event from your application code, use this example code;

EventLog symEventLog = new EventLog();
symEventLog.WriteEvent("FileTransferServer", "PushFile", EventLevel.Information, $"Received PushFile request from machine {computerName}");
symEventLog.WriteEventInformation($"File name: {fileName}");
symEventLog.WriteEventInformation($"folder name: {folderName}");
symEventLog.WriteEventInformation($"File size (bytes): {fileData.Length}");

Full details on the Symphony Event Log can be found here.

 

See Also