
Anonymous user
Not applicable
2021-06-09
02:55 PM
- Bookmark
- Subscribe
- Email to a Friend
- Printer Friendly Page
- Report Inappropriate Content
Link copied. Please paste this link to share this article on your social media post.
2021-06-09
02:55 PM
Viewing Archive Data in a Spreadsheet
Originally published on Geo SCADA Knowledge Base by Anonymous user | June 09, 2021 11:55 PM
📖 Home Back
Archive files are stored in the following formats, which are specially created for use in ClearSCADA.
On an archive disk, the Event Journal archive files are stored in the EventJournal directory, with each file containing one hour of events. The Event Journal archive files are named:
H.MWJ
where is a 7 digit number that represents the time for the file. The number is based on the number of hours between 00:00 on January 1st 1601 and the start of the time period that is covered by the file.
The historic data archive files are stored in Historic directories, with a separate historic directory for each point. The historic directories are named:
Historic
Where is the object Id of the point.
Within each Historic directory, there are .HRD files for each week's worth of data. The historic data archive files are named:
WK.HRD
Where is a 6 digit number that represents the time for the file. The number is based on the number of weeks between January 1st 1601 and the start of the time period that is covered by the file.
You can use the ClearSCADA command line tool (scxcmd) to convert an Event Journal file or a raw historic data file into the .csv format (comma separated value). The .csv format is recognized by programs such as Microsoft Excel, which means you can view raw archive data in a spreadsheet application.
At the Windows command prompt, enter:
\SCXCMD HISDUMP ""
where:
is the directory in which you installed ClearSCADA.
is the name of the archive file you want to convert into the .csv format.
For example:
"C:\Program Files\Control Microsystems\ClearSCADA\SCXCMD HISDUMP "D:\EventJournal\H3560276.MWJ"
The
ClearSCADA creates a new version of the file in the same directory as the original file. The new file is a .csv file and can be opened in various packages, including Microsoft Excel and Microsoft Notepad.
Go: Home Back
File Naming Conventions
Archive files are stored in the following formats, which are specially created for use in ClearSCADA.
Extension | Type |
---|---|
.MWJ | Event Journal archive data is stored in the .MWJ format. |
.HRD | Raw historic data is stored in the .HRD format. |
Event Journal
On an archive disk, the Event Journal archive files are stored in the EventJournal directory, with each file containing one hour of events. The Event Journal archive files are named:
H
where
Historic Data
The historic data archive files are stored in Historic directories, with a separate historic directory for each point. The historic directories are named:
Historic
Where
Within each Historic
WK
Where
Extracting Archive Data
You can use the ClearSCADA command line tool (scxcmd) to convert an Event Journal file or a raw historic data file into the .csv format (comma separated value). The .csv format is recognized by programs such as Microsoft Excel, which means you can view raw archive data in a spreadsheet application.
At the Windows command prompt, enter:
where:
For example:
"C:\Program Files\Control Microsystems\ClearSCADA\SCXCMD HISDUMP "D:\EventJournal\H3560276.MWJ"
The can contain wildcards, so you can convert multiple files at the same time, for example, SCXCMD HISDUMP "D:\EventJournal*.MWJ" will convert all files in the Event Journal folder on D:\ into the .csv format.
ClearSCADA creates a new version of the file in the same directory as the original file. The new file is a .csv file and can be opened in various packages, including Microsoft Excel and Microsoft Notepad.
If the file is on a read-only archive volume, you will need to copy the file onto your hard disk before you can convert the archive data.
Go: Home Back
Author
Link copied. Please paste this link to share this article on your social media post.