How can we help you today?

How can a report be configured to output in CSV format in Citect SCADA?

SUMMARY
This FAQ describes how a report can be configured in Citect SCADA to output in CSV format.

SITUATION
All versions of Citect SCADA.

ACTION
In order to create a CSV format report output, the ASCII_DEV device format needs to be used together with a comma separated template

Please follow the step by step instruction below to configure the report.

1. Create the following device, which will be used as an "output device" for the report. Please note the Device type has to be an ASCII_DEV :

Citect SCADA

2. Create a text file in Notepad, which will be used as a "format" file for the report.

Citect SCADA

Date() - gets the current date
TIME() - gets the current time
LOOP_1_OP, LOOP_2_OP and LOOP_3_OP - test variable tags configured in Citect. Please see LOOP_1_OP variable configuration below.

Citect SCADA

3. Create a new report specifying the Format File, that was created in step 2, and the Output Device, that was created in step 1:

Citect SCADA


4. When the report is run, the following .csv file is created with the following contents:

Citect SCADA

5. Further if you would like headings in the report file, you would just need to pre-create the report file, with the headings separated by commas:

Citect SCADA

Schneider Electric Australia

Explore more
Range:
Users group

Discuss this topic with experts

Visit our Community for first-hand insights from experts and peers on this topic and more.
Explore more
Range:

Need help?

Need help?

Product Selector

Product Selector

Quickly and easily find the right products and accessories for your applications.

Get a Quote

Get a Quote

Start your sales inquiry online and an expert will connect with you.

Where to buy?

Where to buy?

Easily find the nearest Schneider Electric distributor in your location.

Help Centre

Help Centre

Find support resources for all your needs, in one place.

  • Products Documentation
  • Software Downloads
  • Product Selector
  • Product Substitution and Replacement
  • Help and Contact Centre
  • Office Locations
  • Where to buy
  • Phone: 13 73 28 (13 SEAU)
  • Schneider Electric Community
  • Careers
  • Company Profile
  • Report a misconduct
  • Newsroom
  • Investors
  • EcoStruxure
  • Job Search
  • Blog
  • Privacy Policy
  • Cookie Notice
  • Terms and Conditions of Sale
  • Change your cookie settings