Processing data from text files

To process data from a text file you need a Microsoft Excel file (containing functions to process the data) as well as the text file containing the records to be imported. You run the import with the Excel file open.

Sample import files are supplied.

See Sample import files.

To process data from a text file:

Ensure that only the Excel file used to process the data is open.
The import process recalculates each open report after reading each record. So, if other reports are open, this can greatly increase processing time.
Set Excel calculation to Manual before importing data.
Click Options in the Extras group on the ribbon. Click the Calculation tab and select Enable Manual calculation in Excel when Office Plus starts.
Select More > Process Data.
Select External file from the Process from list.
Click Find in the Source field to go to the file from which to import the data.
To keep a record of any processing errors, select Log file.
By default, the log file is in: C:\Documents and Settings\All Users\Shared Documents\Infor\BI\OLAP\Transfer.
In the Delimiter section of the Preview, select the delimitation method used in the source file.
The sample source file, Import2.txt is comma separated.
Click OK to start processing.
A progress bar opens and the first record is displayed in the first line of the worksheet. Use the Step and Continue buttons on the progress bar to process the file one record at a time or all at once. It may be useful to validate the first few records of an import by clicking Step. When you are satisfied that the data will be imported correctly, click Continue.
Note: To increase performance during import, the progress bar and the number of processed data records is updated every 1000 records.
To reduce the processing time, close all open worksheets except the import worksheet. OLAP Server recalculates all worksheets in the selection after processing each data record. No other worksheets can be activated during processing.