on the toolbar and select the format of the data you want to load.
For details on which settings to select, please refer to Types of load settings.
There are two types of data that can be loaded into Sigma, "raw waveform data" and "trend data". The icon displayed at the beginning of the name of each load setting indicates which type of data the setting is for.
 |
Text load setting for raw waveform |
 |
Text load settings for trend |
Loaded records are usually stored in the "Loaded Data" folder. If you have specified a destination folder in the custom (user-defined) load settings, they will be stored in the specified folder.
The data will be converted into a format for Sigma and copied to a dedicated area. Moving or deleting the original file will not affect the records in Sigma.
The data that can be loaded into Sigma can be classified into two types: raw waveform data and trend data.
Raw waveform data is typically data such as a vibration signal recorded at a constant high sampling rate. For example, if a single file containing 10 seconds of vibration signals is loaded into Sigma, it will be stored as a single record in Sigma.
When multiple channels of data are recorded in a single file, each channel is saved as a separate record in Sigma. For example, if a file with 3 channels of vibration signals recorded simultaneously is loaded into Sigma, it will be stored as 3 records.
Trend data is data that is recorded as a set of measurement times and values,
typically assumed to be data measured every few minutes or hours or days (the interval does not have to be constant).
Unlike raw waveform data, a single point of data is loaded as a single record.
For example, if a file with 100 lines of measurement date and temperature data is loaded into Sigma,
it will be saved in Sigma as 100 records.
As with raw waveform data, when multiple channels of trend data are recorded in a single file, each channel becomes a separate record.
| IIU Product | |
Sigma Text(.csv) | Load CSV files exported from Sigma. |
|
RIS (.ris) | Load binary files exported from RIS Interface | |
|
RIS Text(.csv) | Load CSV files exported from RIS Interface | |
|
AMADIS text(.dat) | Load text files exported from AMADIS | |
| Others | |
WAVE(.wav) | Load audio files in WAVE format |
|
General text (Simple) | Load general text with only simple settings. For more information, see Simple loading | |
| |
General text (custom) | Load text files with a detailed setting defined by user. Raw waveform data or trend data can be loaded. See Custom loading for details. |
All settings except General text (Custom) are for loading raw waveform data.
Files other than those exported from IIU products or WAVE files are loaded as general text format. General text format is categorized into raw waveform data and trend data.
The text format of the raw waveform data that can be loaded is as follows. Any extension is acceptable.
The raw waveform data is loaded as a constant sampling rate, regardless of the presence of a time stamp of each sample.
The text format of the trend data that can be loaded is as follows. Any extension is acceptable.
This is the mode to load text as raw waveform with minimum information set. The number of delimiters, header lines, etc. is automatically determined, and the signals of all channels are loaded as the specified physical quantity signals. If you want to select the channels to be loaded, set different physical quantities for each channel, or if the loading fails, use Custom Loading. If you want to define a new physical quantity, please refer to Managing physical quantities.
Select General Text(Simple) from the Load button
to display the Simple load settings dialog.
Select files in the file selection dialog that appears after clicking OK to start loading.
Load text using the predefined text load settings. For details on how to define text load settings, see Defining (custom) text load settings. The following types of loading can be done, which cannot be done with simple loading.
To define the text load settings, click the Setting button 
on the toolbar and select "Load Setting" to open the Load Setting List screen.
To define a new text load setting, press the Add button 
and select either "For Raw Waveform" or "For Trend".
To edit an existing setting, select the setting you want to edit and press the Edit button 
.
You can choose to use the modified date of the file as the measurement date or read it from the header. When reading from the header, you need to set the position (row, column) and date/time format to be read. The format string is an alphabetic substitution for the numbers of the measurement date and time. Please refer to the following table for the alphabets to be used.
| Year | Month | Date | Hour | Minute | Second |
| y | M | d | H | m | s |
For example, if the text file records "4/24/2021 10:05:05", the format will be "M/d/y H:m:s". If the date and time are recorded in different cells, check "Read date and time from different cells" to set the destination and format for each.
| Text | Format |
|---|---|
| 4/24/2021 10:05:05 | M/d/y H:m:s |
| 4-24-2021 10:05:05 | M-d-y H:m:s |
In physical quantity tab, you can set what physical quantity the data for each channel should be loaded as, and the associated information.
Select "All Channel" to load all channels with the same settings, or select "Individual channel" to load each channel with its own settings.
to edit it in the "Channel settings edit screen".
Channel setting items
Y = a X + b
X : Numerical value recorded in the text
Y :
Numerical value (physical quantity) loaded into Sigma.
To add channels to be loaded, press the Add channel button .
To edit the settings of multiple channels at once,
select multiple lines and click the edit button to open the Channel settings edit screen.
Click the edit button for the item you want to edit, then click the OK button after editing.
The tag setting allows you to read a string from anywhere in the header and record it as a tag of the record. You can set multiple destinations for reading and set a name for each. Multiple strings are concatenated with commas and recorded as a tag.
In the case of configuration shown above, the following string will be recorded as a tag for the record.
Measurement Place:"String read from row 6 column 2", Operator:"String read from row 5 column 3"
Most of the settings are the same as those for raw waveform data (see Text load settings - for raw waveform), but since there is no raw waveform in the case of trend data, there is no item to specify the feature values to be calculated. Instead, specify what feature value the trend data is recorded as. Normally you can leave it as "mean", but if the data recorded in the text is the RMS of vibration acceleration for example, then set the feature to "RMS". The numerical value will be loaded into the RMS item of the record in Sigma, and the threshold settings for the RMS of vibration acceleration can be applied. For more information about the concept of raw waveform data and trend data, please refer to Concepts of raw waveform data and trend data.
To change the parameters of the preset load settings such as Sigma text format and RIS text format,
click the Setting button on the toolbar and select "Load setting" to open the Load setting list screen.
With one of the preset load setting selected,
click the Edit button or double-click on an item in the list to open the Preset load setting edit screen.
You can change whether or not to display the corresponding setting as an option when loading data.