Method Reference E-H | Historian 2023 Documentation

Exports the contents of the AlarmRecordSet into the specified file.

Syntax

object.Export(AlmRS, RSInfo, FileName, FileFormat)

Table 1. Parameters
Name	Data Type	Description
AlmRS	AlarmRecordSet	Returns the requested records (writeable).
RSInfo	AlarmOpenRecordSetInfo	Contains descriptions of the desired records (read-only).
FileName	String	Fully qualified export filename (read-only).
FileFormat	ihFileFormat	File format of the export file (read-only).

Returns

Boolean. Returns whether or not the Export operation succeeded.

Exports the contents of the current DataRecordset into the specified file.

Syntax

object.Export(FileName, FileFormat)

Table 2. Parameters
Name	Data Type	Description
FileName	String	Fully qualified export filename (read-only.
FileFormat	ihFileFormat	File format of the export file (read-only).

Returns

Boolean. Returns whether or not the Export operation succeeded.

Example

' Export File From Existing Query Results
If Not MyRecordset.Export("C:\Temp\DataReport.RPT", ihFileFormat.Report) Then
Err.Raise 1, , "Error Exporting File: " + MyRecordset.LastError
End If

Applies to:

Exports the contents of the EnumeratedSets collection into the specified file.

The following file formats are supported:


Name	Description	Value
CSV	File is imported/exported as comma separated values.	1
XML	File is imported/exported as XML.	2

Imported files follow a specific format that contains specific keywords. With CSV, the first row of the file establishes the fields in the file and their positions. With XML reports, the files describe the format of the data.

Syntax

object. Export(FileName, FileFormat)

Table 3. Parameters
Name	Data Type	Description
FileName	String	Fully qualified export file name (read-only).
FileFormat	ihFileFormat	File format of the export file (read-only).

Returns

Boolean. Returns True if the sets have been exported successfully.

Exports the contents of the current MessageRecordset into the specified file.

The following file formats are supported. Exported files follow a specific format containing specific keywords. With CSV and tabular reports, the first row of the file establishes the fields in the file and their positions. With XML, the file itself describes the format of the data.


Name	Description	Value
CSV	File is imported/exported as comma separated values.	1
XML	File is imported/exported as XML.	2
Report	File is exported as a columnar report	3

Syntax

object.Export(FileName, FileFormat)

Table 4. Parameters
Name	Data Type	Description
FileName	String	Fully qualified export file name (read-only).
FileFormat	ihFileFormat	File format of the export file (read-only).

Returns

Boolean. Success/Failure.

Exports the contents of the current TagRecordset into the specified file.

The following file formats are supported:


Name	Description	Value
CSV	File is imported/exported as comma separated values.	1
XML	File is imported/exported as XML.	2
Report	File is exported as a columnar report	3

Imported files follow a specific format that contains specific keywords. With CSV and tabular reports, the first row of the file establishes the fields in the file and their positions. With XML reports, the files describe the format of the data. Prepare a file for import by exporting it with the desired fields for import.

Syntax

object.Export(FileName, FileFormat)

Table 5. Parameters
Name	Data Type	Description
FileName	String	Fully qualified export file name (read-only).
FileFormat	ihFileFormat	File format of the export file (read-only).

Returns

Returns whether or not the Export operation succeeded.

Example

' Export file from existing query results
Set MyRecordset = MyServer.Tags.NewRecordset 
MyRecordset.Criteria.Tagname = "*" 
MyRecordset.Fields.AllFields 
MyRecordset.QueryRecordset
If Not MyRecordset.Export(Path & "TagReport.RPT", ihFileFormat.Report) Then 
err.Raise 1, , "Error exporting file: " & MyRecordset.LastError
End If

Applies to:

Exports the contents of the User Defined Type into the specified file.

The following file formats are supported:


Name	Description	Value
CSV	File is imported/exported as comma separated values.	1
XML	File is imported/exported as XML.	2

Imported files follow a specific format that contains specific keywords. With CSV, the first row of the file establishes the fields in the file and their positions. With XML reports, the files describe the format of the data.

Syntax

object. Export(FileName, FileFormat)

Table 6. Parameters
Name	Data Type	Description
FileName	String	Fully qualified export file name (read-only).
FileFormat	ihFileFormat	File format of the export file (read-only).

Returns

Boolean. Returns TRUE if the User Defined Type is exported successfully.

Returns the current value for a given tag.

Syntax

object.GetCurrentValue(SourceAddress, ErrorMessage, CurrentValue)

Table 7. Parameters
Name	Data Type	Description
SourceAddress	String	The tag source address.
ErrorMessage	String	The error message string encountered, if any.
CurrentValue	String	A DataValue object representing the current tag value.

Returns

Boolean. Succeeded/Failed. Example

Dim OPC1 As iHistorian_SDK.Collector
Dim MyTagValue As Variant
Dim MyErrorMessage As String
' Request The Collector To Get the Current Value for a Tag 
Set OPC1 = MyCollectors.Item("USIM031_OPC1") 
OPC1.GetCurrentValue "OPCTag1", MyErrorMessage, MyTagValue

Returns the current set of Filters configured for MyCollector.

Syntax

object.GetFilters(MyServer, MyCollector)

Table 8. Parameters
Name	Data Type	Description
MyServer	Variant	The Historian server connection.
MyCollector	MyCollector	The Collector object to acquire the Filter information for.

Returns

Boolean true on success, false otherwise

Returns the last error message encountered by the Server object. To see a complete list of messages, refer to the ErrorList property. When possible, the system translates messages into the locale of the client.

Syntax

object.GetLastError

Parameters

None

Returns

String. The last error message encountered.

Returns the name of the Primary Collector for a set of redundantly configured Collectors.

Syntax

object.GetPrimaryCollectorName(CollectorName)

Table 9. Parameters
Name	Data Type	Description
CollectorName	String	The name of the Collector.

Returns

String. The primary collector name.