Define Data Preparation Procedure for XLSX Files

Define Data Preparation Procedure for XLSX Files

Use the Data Preparation Procedure dialog box to generate a file (*.dpp) with which to convert data files into a uniform format in order to make them comparable. You generate this file in DIAdem and then apply the process steps stored in the file in the Data preparation in SystemLink TDM.

Complete the following steps in DIAdem to define a data preparation procedure for XLSX files:

Rename Data Preparation Procedure

First, load an existing data preparation procedure and assign a new name to this procedure.

1. Select DIAdem SCRIPT.
2. Select Settings»SystemLink TDM»Data Preparation Procedure.
3. Click Open Data Preparation Procedure and enter <DIAdem Program Folder>\Examples\TDM Server configurations\Process_Example_Data_TDMS.DPP.
   You can also click here to copy all example files for data preparation procedures for SystemLink TDM, for example, into your user folder.
4. Click Open.
5. Select the Identifier tab.
6. Click Rename.
7. Change the Name.
8. Click OK.

Configuring Property Identifier Mapping

Define how Data Preprocessor replaces the property names.

1. Select the Replace Identifiers tab.
2. Enable Replace property identifiers.
3. Click Edit.
4. Click Copy DataPlugin Mapping and select ExcelTDM as the DataPlugin name.
5. Click OK.
6. Click Close.

Configuring the Units Catalog

Convert the units of the channel data according to a unit set.

1. Select the Convert Units tab.
2. Enable Unit conversion.
3. Click Edit.
4. Enable SI units.
5. Select the Quantities tab.
6. Scroll down in the list and select the Temperature row.
7. Select the Units tab.
8. Enable degrees Celsius as Default.
9. Click Close.
10. Click the Save Data Preparation Procedure As button.
11. Click Save to save the procedure as a DPP file.