Context: |
Class Method (Function) |
Library/Class: |
FileImport Class |
Function FileImport.ReadNext() As Integer
ReadNext (stats As StaticVars)
Word
This method is called for every Word document that has been selected for import. The method creates the required Word COM objects and opens the to be imported Word document. It is then calling the FileImport.ReadWordProperties() method to read in any Word property or Word field as defined in the Integra profile.
Excel
This method is called for every row in the to be imported Excel spreadsheet. The method will read in the values of each column cell in the current Excel row either by
- referring to the columns tag name (which is the field name as listed in the Selected Field List). This requires the Integra profiles Use Tags option to be set to Yes.
- or by calculating the column number using the index of the fields in the Selected Field List adding the Column Offset as defined in the Integra profile.
Note: for the latter it is important that ALL fields in the Selected Field List which refer to an Excel property (EXCEL.PROPERTY.property) are listed after ALL column fields.
Text
This method is called for every record in the to be imported text file. A record is determined by the Line Separator field in the Integra profile. For CSV formatted files this is the carriage return character.
Note: XML import is not supported
Parameters:
Handle to Integra's runtime object stats
Return Value:
Returns True if no error exceptions occured (e.g. triggered by field formulae), otherwise False
|