The DtWebProvider class implements an object that imports data from tables that can be found on web pages or in local HTML file.
Object of the class can be used for direct data import from tables that can be found on a web page in the Internet or in local HTML file. It is also used to set up the Import from Web ETL task object.
Property name | Brief description | |
The HasHeader property determines whether field headers are imported from the first table row. | ||
The TableAttributeName property determines name of the table attribute, data of which has to be imported. | ||
The TableAttributeValue property determines the value of the table attribute, data of which has to be imported. | ||
The TableIdentificationType property determines table identification type on the Web page. | ||
The TableNumber property determines the number of the table, from which data is imported. | ||
The Url property determines web page address, or the path and the number of the file, from which data is imported. |
Property name | Brief description | |
AutoFillFieldsMode | The AutoFillFieldsMode property determines the field type detection mode of the data provider. | |
CalcFieldsErrors | The CalcFieldsErrors property returns a collection of errors appeared on calculated fields calculation. | |
Eof | The Eof property returns True if the cursor in the data source is on the last record. | |
FetchErrors | The FetchErrors property returns errors occurred on data import. | |
FilterIf | The FilterIf property returns condition of loading of records from data provider. | |
StringDataFormat | The StringDataFormat property returns settings used on data identification. | |
TypeGuessRows | The TypeGuessRows property determines number of rows by means of which the data type of each field will be determined. |
Property name | Brief description | |
Active | The Active property returns data source or data consumer state. | |
Fields | The Fields property returns data provider/data consumer fields description. | |
GetType | The GetType property returns data provider/data consumer type. | |
Metabase | The Metabase property determines the repository, in which data is imported or exported. |
Method name | Brief description | |
Fetch | The Fetch method reads data of the current entry from the data provider. | |
FetchRows | The FetchRows method reads data of the specified number of entries from the data provider and returns the number of actually read entries. | |
ReadingRowsCount | The ReadingRowsCount method returns the number of records read from the data source with taking into account loading condition. | |
ReadingRowsTotalCount | The ReadingRowsTotalCount method returns the number of records read from the data source without taking into account loading condition. |
Method name | Brief description | |
ClearFields | The ClearFields method clears fields list of the data provider or data consumer. | |
Close | The Close method closes data provider or data consumer. | |
FieldsFromFile | The FieldsFromFile method reads fields list from the source file. | |
Load | The Load method loads data source or data consumer parameters from XML. | |
Open | The Open method opens data provider or data consumer. | |
Save | The Save method saves data source or data consumer parameters in XML format. |
See also: