\(\renewcommand\AA{\unicode{x212B}}\)

ExportSampleLogsToCSVFile v1

../_images/ExportSampleLogsToCSVFile-v1_dlg.png

ExportSampleLogsToCSVFile dialog.

Summary

Exports sample logs to spreadsheet file.

See Also

ExportExperimentLog

Properties

Name

Direction

Type

Default

Description

InputWorkspace

Input

MatrixWorkspace

Mandatory

Name of data workspace containing sample logs to be exported.

OutputFilename

Input

string

Mandatory

Name of the output sample environment log file name. Allowed extensions: [‘.txt’]

SampleLogNames

Input

str list

Names of sample logs to be exported in a same file.

WriteHeaderFile

Input

boolean

False

Flag to generate a sample log header file.

Header

Input

string

String in the header file.

DateTitleInHeader

Input

boolean

True

If true, then the first 2 lines of header will be experiment date and title.Otherwise, there will be only 1 line in header.

SeparateHeaderFile

Input

boolean

True

If true, then the header is written to another file.Otherwise, header will be in the same output file.

TimeZone

Input

string

America/New_York

Sample logs recorded in NeXus files (in SNS) are in UTC time. TimeZone can allow the algorithm to output the log with local time. Allowed values: [‘UTC’, ‘America/New_York’, ‘Asia/Shanghai’, ‘Australia/Sydney’, ‘Europe/London’, ‘GMT+0’, ‘Europe/Paris’, ‘Europe/Copenhagen’]

TimeTolerance

Input

number

0.01

If any 2 log entries with log times within the time tolerance, they will be recorded in one line. Unit is second.

Description

Algorithm LoadSampleLogsToCSVFile exports a specified set of sample logs , which are stored in a MatrixWorkspace, to a CSV file. The header for the sample log csv file can also be created by this algorithm in a separate header file.

CSV File format

Sample logs are written to a csv file. A tab separates any two adjacent values.

Each entry of each exported sample log will be an individual entry in the output CSV file, except in the situation that two entries with time stamps within time tolerance.

The output CSV file has 2+n columns, where n is the number of sample logs to be exported.

Here is the definition for the columns.

  • Column 1: Absolute time (with respect to the Unix epoch) in seconds

  • Column 2: Relative to first log entry’s time

  • Column 3 to (2 + n): log values in the order determined by input SampleLogNames

Header file

A sample log header file can be generated optionally. It contains theree lines described as below.

  • Line 1: Test date: [Test date in string]

  • Line 2: Test description: [Description of this log file]

  • Line 3: Header content given by user via input property Header. Usually it is the column names in the .csv file

Time Zone

The time stamps of sample logs are recorded as UTC time in SNS. Some users wants to see the exported sample log as the neutron facility’s local time. So the input property ‘TimeZone’ is for this purpose.

Property TimeZone does not support all the time zones but only those with facilities that use Mantid.

Here is the list of all time zones that are allowed by this algorithm. - UTC - GMT+0 - America/New_York - Asia/Shanghai - Australia/Sydney - Europe/London - Europe/Paris - Europe/Copenhagen

Usage

Example - Export a time series sample log to a csv file:

import os

nxsfilename = "HYS_11092_event.nxs"
wsname = "HYS_11092_event"

defaultdir = config["default.savedirectory"]
if defaultdir == "":
  defaultdir = config["defaultsave.directory"]
savefile = os.path.join(defaultdir, "testphase4.txt")

Load(Filename = nxsfilename,
    OutputWorkspace = wsname,
    MetaDataOnly = True,
    LoadLogs = True)

ExportSampleLogsToCSVFile(
    InputWorkspace = wsname,
    OutputFilename = savefile,
    SampleLogNames = "Phase1, Phase2, Phase3, Phase4",
    WriteHeaderFile = True,
    Header = "Test sample log: Phase1-Phase4",
    TimeZone = "America/New_York",
    TimeTolerance = 0.01)

headerfilename = os.path.join(defaultdir, "testphase4_header.txt")

print("File is created =  {}".format(os.path.exists(savefile)))
print("Header file is created =  {}".format(os.path.exists(headerfilename)))

# Get the lines of both files
sfile = open(savefile, 'r')
slines = sfile.readlines()
sfile.close()
hfile = open(headerfilename, 'r')
hlines = hfile.readlines()
hfile.close()

print("Number of lines in File = {}".format(len(slines)))
print("Number of lines in Header file = {}".format(len(hlines)))

Output:

File is created =  True
Header file is created =  True
Number of lines in File = 36
Number of lines in Header file = 3

Categories: AlgorithmIndex | DataHandling\Logs

Source

Python: ExportSampleLogsToCSVFile.py