24.7.1 Procedure - Display/Save Sampled Data in CSV with a Custom Format

Configure settings so that the display format for Sampling Group 1 is as follows.

  1. In the [Common Settings (R)] menu, select [Sampling (D)] or click , and a list of registered sampling groups appear. Double-click row 1 and the sampling group 1 setup screen appears.

    (For information about Address/Action 24.3.1 Procedure - Sampling Data at Constant Intervals.)

  2. Open the [Display/Save in CSV] tab.

  3. Select the [Display/Save in CSV] check box, and select [Custom Settings].

  4. Set [Item Name (Horizontal) Rows] to 1, and [Calculation Result] to 2.

    • When the [Overwrite old data after finishing the specified cycles] check box is cleared, set the [Data Display Rows]. Adjust the number of data display rows to match the number of sample ocurrences.

  5. Select the Date column in the Preview area and click [Detail Settings]. The [Date Set] dialog box appears. Change the date form to [mm/dd].

    Click [OK] to close the dialog box.

  6. Delete the address D101 data column from the display format. Select the fifth column (Data 2) and click [Delete] key.

    • To delete, you can right-click the fifth column (Data 2) to display a popup menu, then click [Delete].

  7. Double-click each Item Name (Horizontal) cell and input the Item Name.

    You can input text in the language designated in the Sampling List [Language].

  8. Move the column. Select the fourth column (Data 1) and click [Move Right].

  9. Select the third row and click [Row Details]. The [Calculation Settings] dialog box appears. Change the [Calculated Data] to [Max].

    As needed, set the calculation row [Data Type], [Total Display Digits] and click [OK].

    • If you select a data column's calculation cell and click [Row Details], you can set [Data Type], or [Total Display Digits] independently.

  10. Select the calculation data in the fourth row and set [Min] in the same way.

  11. Double-click the calculation cells in the Item Name (Vertical) column and input the Item Name for each row.
    The customized Display/Save in CSV format is now set.

    • The format of CSV files saved in a CF Card differs slightly from the state displayed on the setting screen. Refer to the following.
      24.11.4.3 CSV File Format

    • You can save sampling data to a CF card and USB storage device.

  12. Open the editing screen, and on the [Parts (P)] menu select [Sampling Data Display (S)], or click , to place the Part on the screen.

  13. Double-click the placed Sampling Data Display. The settings dialog box appears.

  14. Define the sampling group you want to display on the screen. Set Sampling Group No. to "1".

    • To display the sampling group, use the [Block Number Specification Address] to define which block to display. This field is enabled if in the [Common Settings (R)] workspace, [Sampling] screen, [Mode] tab, [Extended] area, the [Overwrite old data after finishing the specified cycles] check box is cleared.

  15. Set the [Display Rows] and [Display Columns].

    • When you wish to edit the sampling data on the screen, select the [Edit Data] check box, and set up a keypad for editing the data. The screen will change to the editing screen by touching the data, and the data can be edited using the keypad.

  16. Select whether or not to show Ruled Line/Border and select the [Clear Color].

  17. As needed, set the font size and scroll switch layout on the [Display] and [Switch] tabs and click [OK].