Load Information page
The Load Information page is where you map index attribute names defined to hold the attribute values that ACIF extracts from the report to application group database field names.
For the sample income statement report, the attribute names are the same as the database fields. Therefore, there is no need to map the attributes names on the Load Information page. To verify this, select each name in the Application Group DB Name list. The corresponding index attribute name appears in the Load ID Name field. The names should be the same.
The Load
Information page also contains other values used when the
index data is loaded into the database, for example:
- If the appearance of the date field in the report is different than the default date format for the application, you can specify the correct date format found in the report. Verify the date format for the billing date field. Select sdate in the Application Group DB Name list. The Format field should contain the format specifier that describes the appearance of the date in the report (%m/%Y for the MM/YYYY format dates found in the report). If it does not, select the format specifier that correctly describes the appearance of the date in the report.
- If the field contains special characters, you can specify that
you want Content Manager OnDemand to remove
them from the data before storing index values in the database. For
decimal fields, such as the Total Income and Subtotal fields,
you probably want to remove the blank,
$(dollar),,(comma), and.(decimal) characters from the data. To do so, select the field in the Application Group DB Name list. In the Embedded field, enter the comma and period characters. In the Leading field, enter the blank and dollar characters.