Define and import a print image file
Concept Information
You can create an Analytics table by defining and importing a print image file.
When you use the Data Definition Wizard to process a print image file, Analytics may fully or partially auto-define the file, or you may need to manually define the file.
Note
Defining print image files can be challenging. If you encounter problems, review Defining and importing print image (report) files and PDF files.
Locate and select the print image file
- Select .
- If the Select Platform for Data Source page is displayed, select Local and click Next.
- In the Select Local Data Source page, select File and click Next.
- In the Select File to Define dialog
box, locate and select the print image file you want to create the Analytics table
from and click Open.
Print image files typically have a .txt file extension.
- In the Character Set page, verify that the correct character set option has been selected and click Next.
- In the File Format page, verify
that Print Image (Report) file is selected and click Next.
The print image file is parsed and the Print Image File Definition page displays the parsed file.
Define the print image file
- In the Print Image File Definition page,
scroll vertically and horizontally to examine the parsed file.
Highlighting indicates whether Analytics has auto-defined data in the file:
Highlighting Meaning Aqua-blue highlighting Data auto-defined as a field. Gray highlighting Data auto-defined as a record.
Record definition depends on at least one field being defined in the record.
White background Undefined data.
Analytics was not able to detect a pattern in the data and could not auto-define it.
- Do one of the following:
Result of auto-definition Action to take If Analytics auto-defined the file and you do not want to make any updates If Analytics auto-defined the entire file perfectly, and you do not want to: - update the generic field names
- add any header or footer data to the detail data
If Analytics auto-defined the file and you want to make updates If Analytics auto-defined the entire file perfectly, and you want to: - update the generic field names (“Field_1”, “Field_2”, and so on), go to Edit the auto-definition
- If you want to add header or footer data to the detail data, go to Manually define the print image file
Tip
You can also update the generic field names in a subsequent page in the Data Definition Wizard, which you may find more convenient.
If the auto-definition contains errors If the auto-definition: - contains errors
- excludes data that you need
- includes data that you do not need
you must do one of the following:
- Edit the auto-definition
- delete the entire auto-definition and Manually define the print image file
Tip
If the auto-definition contains significant errors, deleting the entire auto-definition and manually defining the file can be easier.
If the parsed file is entirely undefined If the parsed file is entirely undefined, indicated by a completely white background, you must Manually define the print image file
Edit the auto-definition
If you want to edit the auto-definition (or a manual definition), in the Print Image File Definition page, do any of the following:
Edit task | Instructions |
---|---|
Edit a field definition | Right-click
an aqua-blue field and select Edit Field,
or double-click the field. You can make a number of changes, including:
For detailed information, see Working with field definitions. |
Edit a record definition | Right-click a gray
record and select Edit Record, or double-click
the record. You can make two main changes:
For detailed information, see Working with record definitions. |
Delete a field definition or a record definition | Right-click a field or a record and select Delete Field or Delete
Record. You can delete definitions for fields that you do not want in the Analytics table, or that you want to define manually because of errors in their auto-definition. If you delete a record definition, any field definitions contained by the record are also deleted, and all instances of the record definition in the file are deleted. Note You are deleting the field definition or the record definition only, not the actual data. If necessary, you can redefine the same field or record data. Tip If you want to selectively delete records, select Edit Record and fine-tune the criteria that Analytics used to capture the set of records. For detailed information, see Working with record definitions. |
Manually define the print image file
Tip
Before you begin, you may find it helpful to first review the basic version of the steps below, with accompanying screen captures: Quick start steps.
Note
You can also define a print image file using saved field and record definitions, if they exist.
For more information, see Define the print image file using a set of saved field and record definitions.
- In the Print Image File Definition page,
select a data value to start defining one
of the fields in the table.
For example, you could select a social security number in an SSN field. When you select the data value, the Field Definition dialog box opens.
Guidelines:
- You can select a value anywhere in the data. You do not have to use the first field in the table, or select the first value in a field.
- The value you select can be detail data, header data, or footer data.
- Do not select field names. Leave all field names in the source file unselected. If you select field names in the source file, Analytics treats them as data contained in fields.
- If field values vary in length, select the longest value, or select extra blank spaces to allow for longer values that may be lower in the field and not currently displayed.
If you intend to use the initial data value you selected to uniquely identify a set of records, see Working with field definitions.
- Enter a name for the field, if necessary update the data type, and click OK.
- In the data value you just selected, or in the same
row in the file, select the character, or string of characters,
that uniquely identifies the set of records in the source file.
For example, select:
- a slash in a date value
- a decimal point in a numeric value
- a unique identifying value anywhere in the row containing the data value you selected
When you select the unique character or characters, the Record Definition dialog box opens, and all records containing the character or characters are highlighted gray.
For detailed information, see Defining and importing print image (report) files and PDF files.
If you need to define a record that extends beyond one row in the source file, see Working with multiline records and fields.
- If required, update the Record Type to match the type of data you are defining: detail, header, or footer.
- If required, modify the criteria used to capture the
set of records.
For example, you could add additional criteria to omit some of the records that were initially captured.
For detailed information, see Working with record definitions.
- Click OK.
The field you defined is highlighted aqua-blue, and the associated set of captured records is highlighted gray.
- Scroll vertically to examine the defined field, and the associated set of captured records.
- If the field is not defined correctly, or if the set
of captured records needs adjustment, double-click the field or
the record, and make the necessary edits in the Field
Definition dialog box, or the Record Definition dialog
box.
For more information, see Working with field definitions, or Working with record definitions.
- Define the remaining fields in the record by selecting
a representative data value for each field.
Additional fields automatically conform to the set of records.
Guidelines:
- Define only those fields you want in the resulting Analytics table.
- With each field definition,
scroll vertically to examine the defined field. Edit the definitions
as required.
For example, if data values are not fully contained by a field, you need to adjust the length or starting position of the field, or both.
For more information, see Edit the auto-definition.
- If you need to define field values that extend beyond one row in the source file, see Working with multiline records and fields.
TipThe order in which you define detail fields is the order in which they appear in the resulting Analytics table.
If you delete a detail field during the definition process, and then re-add it, it loses its original position and is placed last among detail fields.
- If you want to define another record, repeat steps 1 to 9.
Guidelines:
- When you select a data value to start defining a new field and associated set of records, ensure New Record is selected in the dialog box that appears, and click OK.
- You can define multiple header or footer records, but only one detail record. The order in which you define the different record types is not enforced.
Define the print image file using a set of saved field and record definitions
You can define a print image file using field and record definitions from a previous file definition session that have been saved in a print image query file. The print image query file must already exist, and the saved definitions must match the current data.
Note
Loading a print image query file deletes any current field and record definitions.
- In the Print Image File Definition page, click Load.
- Navigate to a previously saved print image query file, select it, and click Open.
The definitions are applied to the current data.
Print image query files have a .txt extension.
Note
Only load a file with definitions that you know match, or closely match, the current data.
- After loading the file, do one of the following:
- If the entire file is now perfectly defined go to Finalize the print image file definition
- If the file definition needs adjustment go to Edit the auto-definition
Finalize the print image file definition
- Optional. If you want to save the current set of field and record definitions to a print image query file, do the following:
- Click Save.
- Enter a name for the print image query file and click Save.
Note
Field and record definitions often represent a lot of work, and it is recommended that you save them.
If you subsequently discover that the imported data needs an adjustment, and must be redefined and reimported, saved definitions do not have to be recreated from scratch.
- When you are satisfied with all field and record definitions,
click Next.
Note
If required, you can return to this point in the process and make updates to the field and record definitions.
Save the Analytics data file
In the Save Data File As dialog box, enter a name for the Analytics data file and click Save.
If Analytics prefills a data file name, you can accept the prefilled name, or change it.
You can also navigate to a different folder to save the data file if you do not want to use the default location opened by Analytics.
Edit the Analytics field properties
In the Edit Field Properties page, review the settings assigned by Analytics to the properties listed below, make any required updates, and click Next.
Note
Select a column heading in the preview table to see the properties associated with the column.
Property | Description |
---|---|
Ignore this field | Excludes the field from the resulting table layout. The data in the field is still imported, but it is undefined, and does not appear in the new Analytics table. It can be defined later, if necessary, and added to the table. |
Name | The name for the field in the table layout. You can keep the name assigned by Analytics, or enter a different name. |
Column Title | The column
title for the field in the default Analytics view. If you do not specify a column title, the Name value is used. |
Type | The data type assigned to the field in Analytics. You can keep the data type assigned by Analytics, or select an appropriate data type from the dropdown list. For information about the supported data types in Analytics, see Data types in Analytics. |
Value | A read-only property that
displays the first value in the field. The value dynamically updates based on any edits you make. |
Decimal | Numeric fields only. The number of decimal places in the source data. Note The Decimal text box appears automatically when you select a Numeric data type. |
Input Format | Datetime fields
only. The format of datetime values in the source data. The format you specify must exactly match the format in the source data. For more information about date and time formats, see Formats of date and time source data. |
Finalize the import
- In the Final page, verify the
settings for the new Analytics table and click Finish.
If you want to make any changes, click Back to get to the appropriate page in the wizard.
- Enter a name for the table layout that you are adding
to the project, or keep the default name, and click OK.
The new Analytics table is created with data from the imported file.
Note
Analytics table names are limited to 64 alphanumeric characters, not including the .FIL extension. The name can include the underscore character ( _ ), but no other special characters, or any spaces. The name cannot start with a number.