Report Options
Last updated
Last updated
Report options are where you can specify or adjust the settings for the report file used for your model. The report options window appears when you are creating a new model and selecting the report you will be extracting from.
You can also open this window by clicking on the Edit Report Options icon >
The Report options consists of these components:
Data File Path
Loop Through All the Files in a Folder
Reading Options
Other Options
This option is for when you would like to apply your report model to multiple files in a folder.
This is where you can edit how the file is read. Reading Options can change depending on your file type. Astera's Report Models currently support: TXT, PRN, CSV, PDF, EXCEL, and COBOL file types.
Run OCR (Optical Character Reader): This option is for image-based pdfs. When this box is selected, your image will be scanned and converted into text.
Maintain Original Layout: By default, this option is selected but if you do not want to maintain the original layout, you can un-check this box.
Remove Blank Lines: If selected, this option will remove all blank lines within your report file.
Scaling Factor: The Scaling Factor applies to your pdf’s spacing value. In some cases, a pdf writer causes the scaling to be off when converting to Report Model text. If this is the case, you can fix this by changing the scaling factor value.
Owner and User Password: This option is for password protected PDFs. This is where you would insert the credentials.
Worksheet: Here you can select the worksheet you would like to extract data from.
Space Between Columns: This option allows you to increase or decrease the spacing between the excel columns to allow a clearer visual.
Other options are located at the bottom of the Report Options window in blue text. To expand these options, click the plus button. Once you do this you will see more options below:
Tab size: You can increase or decrease the tab size for your report. The default value is 8 characters.
Line Count: This controls how many lines of the report will be loaded in the report editor. This setting does not affect the amount of data exported. The default value is 5000.
Font: Here is where you can change the font of the text that appears within your report. You have the option to select the font size and bold or italicize the text.
Encoding: You can choose the Encoding for your file. The default is Unicode (UTF-8) but you can change this if you have a file with specific characters.
Display Style: Here you can select the theme for the ReportMiner editor. Choose which color scheme you prefer.
Record Delimiter: This option allows you to select the record separator or line break type. You can select <CR><LF>, <CR>, or <LF>.
<CR> (Carriage Return) moves the cursor to the beginning of the line without advancing to the next line.
<LF> (Line Feed) moves the cursor down to the next line without returning to the beginning of the line.
<CR><LF> does both.
Numeric Format: This is where you can specify the number of decimal digits.
This is where you will select the file you would like to extract from. Click the folder icon and select the file you will be using for your report model.
