I am using Deltav 12.3 excel addin to get process history data to excel. But I found out that there is limitation in "RAW data function" in maximum samples of 65536. Is possible to change this limitation somehow or is there any other possibility how to get bigger amount of process history data to excel?
Thank you
In reply to LaurentB:
In reply to Dragonfly:
As I said DVCHDUMP is very powerful but less user friendly ...
But Yes you can extract data with all options you need.
To find Help on this command just type DVCHDUMP
Below the paramters yo have to use
Items that can be dumped:
HISTORY DATA SOURCES
HISTORY TAGS NAMES
[<tag criteria> [<data source criteria>]]
HISTORY CONFIGURATION
RAW HISTORY SAMPLES
[<datasource>] <tag> [<start time> [<end time> [<startBound> [<endBound>]]]]
[/INFO=4] [/EQUAL]
HISTORY STATUS CHANGE SUMMARY
[/MAX=<num>]
HOLES IN HISTORY RECORD
[<datasource>] <tag criteria> [<start time> [<end time> [<startBound> [<endBound>]]]]
[/MAX=<num>] [/INFO=2] [/ITF]
LONGEST INTERVALS IN HISTORY RECORD
[<datasource>] <tag> [<start time> [<end time> [<list length>]]]
[/MAX=<num>] [/ITF]
SHORTEST INTERVALS IN HISTORY RECORD
OUT OF TIME SEQUENCE SAMPLES
[<datasource>] <tag criteria> [<start time> [<end time>]]
[/MAX=<num>] [/ITF] [/INFO=1] [/EQUAL]
PROCESSED AGGREGATE VALUES
[<datasource>] <tag> [<aggregates+fields> [<start time> [<end time> [<interval>]]]] [/AI]
RESAMPLED VALUES
[<datasource>] <tag> [<start time> [<end time> [<resampleFactor> [<startBound> [<endBound>]]]]]
[/INFO=4] [/EQUAL] [/ALGO=1]
GRAPH PLOTTING POINTS
[<datasource>] <tag> [<start time> [<end time> [<interval> [Y-axisRange]]]]
INCREASING MAXSAMPLES
[<datasource>] <tag> [<start time> [<end time>]]
[/MIN=<num>] [/MAX=<num>] [/INCR=<num>] [/SLEEP=<num>] [/INFO=1]
ADJUSTED VALUES
[<datasource>] <tag> [<start time> [<end time> [<resample interval> [<tolerance>]]]]
ALGORITHM TEST FROM FILE
[<resample interval> [<tolerance>]] [/ALGO={0|1}]inter
(Raw samples expected as standard input)
'/NODE=<serverName>' can be added to send DvCHDump requests to a DvCH on another node.
'/PRI=< HIGH | ABOVE | NORMAL | BELOW | LOW>' will set process base priority.
Data sources are like: DeltaV=<nodeName>
Tag and data source match critera may use leading and/or trailing '*' characters
to indicate a wildcard match of 0 or more characters.
Start/end times may be absolute or relative. Always UTC based:
Absolute: example: 2004/03/19 17:53:00
Note: usually have to put date and time absolute times in double quotes so
command window shell will treat it as a single command line parameter.
Relative: (follows OPC HDA specs)
<base>[<offset>[<offset>[<offset>[...]]]]
where <base> is any of:
NOW SECOND MINUTE HOUR DAY WEEK MONTH YEAR
and an <offset> is
<inc>S <inc>M <inc>H <inc>D <inc>W <inc>MO <inc>Y
meaning: sec min hour day week month year
and
<inc> is: +|-<number>
Examples:
NOW NOW-1H-30M DAY+1H WEEK-3D+8H ...
<startBound> and <endBound> boundary type specifications are single letter abbreviations:
N - None
O - next raw sample Outside specified time span
I - Interpolated value at specified start/end time
<aggregates+fields> is a comma delimited list of aggregate ids; so far, one or more of:
%AVAIL,%GOOD,COUNT,FIRST,INTERPOLATED,LAST,MAX,MIN,AVE
%NOTBAD,%NOTLIMITED,RANGE,STDEV,TOTAL,RAW_AVE
Specifying the aggregate name produces just the "value" of the processed sample. To
also see additional information for the sample, one or more of the following
extra field ids may be appended:
+Time - includes the timestamp for the aggregate.
+DvStatus - includes the composite DeltaV (Ff) status for the aggregate.
+DStatus - includes the composite DeltaV (Ff) status decoded as a string.
+ArcStatus - includes the (numeric) DvCH archive status for the aggregate.
+AString - includes the DvCH archive status bits decoded as a string.
+Year - includes the year and month from the timestamp for the aggregate.
+Frac - includes the fractional second from the timestamp for the aggregate.
Aggregates and field ids can be abbreviated to the point ambiguity. Examples:
COUNT,%GOOD would return values for these two aggregates
MAX+T,MIN+T would return the min's and max's, along with when they occurred
I+T+D+A would return the INTERPOLATED aggregate, plus time, and both statuses
<interval> is the resample interval (time span) for reading processed values. Examples:
30S = 30 seconds
2H30M = 2 hours and 30 minutes
5D12H = 5 days and 12 hours
200T = 200 milliseconds (Thousandths)
Most commands accept '/LT' which causes all timestamps displayed to be converted to local time.
Some commands accept '/MAX=<num>' which sets the 'maxSamples' parameter on readRaw calls.
Some commands accept '/AI' show invalid content from samples with AggregateValueInvalid status.
Some commands accept '/ITF' which ingores the 'data trucated' flag on readRaw calls.
Some commands accept '/INFO=1' which includes addtional details.
Some commands accept '/EQUAL' to indicate that equal timestamps should be flaged as a problem.
Archive status bit abbreviations used:
AI - AggregateValueInvalid
CR - HistoryDataUnreadable
DU - HistoryDataUnavailable
NC - HistoryCollectionNotConfigured
SD - HistorianOrScannerShutdown