The Statement Format section within AutoMail® is used to specify locations of text within the statement text file; so as to ultimately determine a total number of pages (specifically... total sheets of paper) which make up a "document", or mailpiece. (a)In order for AutoMail® to be able to determine when a new document begins or a new page begins within a given document, the location of the page breaks must be entered into this section. (b)Statement Format is also used to specify the location of the account number and address location of each statement within the file.

 

To enter the ‘Statement Format’ section, select ‘Data Capture’ on the left side of the AutoMail screen. Once you have selected ‘Data Capture’ you will select ‘Statement Format’. Once you have done this, you will be asked for a password. A AutoMail technician can give you this information if necessary.

 

Click the links, below, to see detailed information about the tools used to "map" a document in AutoMail®.

 

 

StmtFormat1

 

minusInput Form

After entering the password, you will see the ‘Statement Format’ window. We will be discussing the

‘Input’ tab in this section.

 

StmtFormat2

 

The ‘Input’ tab is the area of the program used to identify statement and page separators. Automail

must be able to determine where a statement changes compared to simply a page change. The purpose

of this is so that Automail can correctly determine the proper weight and postage to apply to each

statement. The resulting information will print on the printed statement. Let’s begin by discussing the

‘Statement Type:’

 

StmtFormat3

 

The ‘Statement Type’ is used to indicate the file structure you will be using. There are multiple options here. What is chosen will typically be based on the core software or the image vendor that the customer uses. Keep in mind that this may not always be the case. Some of the types will be used everytime for certain vendors. If you are unsure of what ‘Type’ to use, please ask a AutoMail technician. They may have setup the type of file you are working on before.
The next option is ‘Image Type:’. The same description and senerios also apply here as it does with ‘Statement Type:’ The majority of configurations will require this option to be set to ‘None’, but there are circumstances which require this to be changed. Simply ask a AutoMail technician if you are unsure of what to use.

 

StmtFormat4

 

The next option you will see is ‘Statement Verification’.

 

StmtFormat5

 

‘Statement Verification’ was added to the program simply to verify that the output file that Automail creates matches the statement file that was processed. If for some reason Automail modifies the format of the file, (only done in exceptional scenarios, if absolutely necessary) it can cause problems when the file is imported back into the vendor software that is being used to print the statements.

 

Now that you have seen how to set the type of statement file that Automail will be processing, Automail must now be configured to know the difference as to when a new statement begins vs.a new page begins. Because Automail prints the weight of each statement on the first page of the statement, the software must know how many pages each statement has. This information is also necessary when Automail is responsible for printing. (discussed in another section) Let’s begin by setting up Automail to separate the accounts within the file.

 

Accounts Separated By

StmtFormat6

 

As you will see, there are 5 options that can be used to determine when a new statement begins within the statement file. Keep in mind, the option that you choose will be based on the format of the file you are configuring. The first option is ‘Change In Account No’. (Entering the location of the account number will be discussed in the next section.)
This option is typically used when then there is nothing specific that designates the first page of a new statement. It can also be used if the file has multiple statements with the same account number and they need to be placed in the same envelope.
The ‘Ignore Blanks’ option is used when you are separating statements by account number but the additional pages of a statement do not have an account number listed. This tells the software to not treat the blank area as a change in the account number, but to include it as an additional page of the current statement.
The next option that can be used is ‘Keyword:’. This option is used when there is specific text that designates the first page of a statement (for example: Page 1). If this text is on the first page of every account you can designate the location of this text, which prompts the software to begin calculating a new statement each time this text is found.

 

StmtFormat7

As you will see in the above illustration, you have to designate the specific location of the text within the file.
oBegin by designating the text to be used. EX. Page 1
oEnter the line number where the text is located. As you can see there is a beginning and ending position. This will be used if the text floats from line to line. (Carefully watch the effects this has on the file. If the text moves, it can affect the output results.)
oDesignate the column location of the text. You can find this information in the text editor that you are using to view the file.
oEnter the length of the text. In the above example, the text is 6 characters long. This must be exact.
The next option that may be used is ‘Acct Hdr:’.

StmtFormat8

The ‘Acct Hdr:’ option will typically be used for specific vendors. In the example above, the <A> is being used in a file created for the Jack Henry 4Sight vendor. <A> represents the start of a new statement. As you can see there is no need to specify line and page number. Automail is programmed to look at the first line of text in the file for the specified text.
The options of ‘Page Header On Next Line’ and ‘Page Header Must Follow Acct Header For New Statement’ are used mainly for specific vendors or file formats. Some statement might have the <A>, (or some other text) on every page, but there may be a <P>, (or some other text) following the <A> on the first page that specifies the first page of a statement.
There is no definitive way to determine every vendor that requires this setup. You have to be able to base your decision on what you see in the file and learn from other technicians who have dealt with this setup.
The next option that is available to use is ‘Acct Ftr:’.

StmtFormat9

The ‘Acct Ftr:’ option is very rarely used. You will not see many files that require this option. However, it does occur. Some statement files will have the first page indicator at the bottom of the page instead of the beginning. Once again this will be vendor specific as Automail will be programmed to understand the specific position of the text in order to properly process the statement text that is above the footer text.
The final option used to separate accounts will be ‘Change in Name/Address’.

StmtFormat10

This option will be used mainly in only two scenerios.
oFirst scenario is when there is no other option to separate accounts. If none of the previous options are available to use, then this option may be used as there will always be address information available.
oThe second scenario is when you want to put different statements that have the same address information into the same envelope to mail. Maybe the address information is the same but the account number is different, then this option can be used to combine the statements.
Be very careful using this option. It is recommended that this only be used with non-imaged statements. If you try to use this for imaged statements, you run the risk of causing issues with image vendor software. Mainly, it can cause the image vendor software to incorrectly group the correct images with the correct customer statement

 

Account No.

StmtFormat11

This section is used to extract the account number from the statement file. The main purpose of this feature is for reporting. However, there are some vendors that in order to calculate images correctly, Automail must match the account number in the statement file with the account number that is in an image file created by the vendor.
The account number will be located in different positions according to the file type and vendor that created the file. You will see that there are some vendor files that the account number is in the same position in every file they produce and there are some that it will be in different positions for different customers.

 

The next section in the ‘Statement Format’ is the ‘Statement Pages Separated By’ section.

StmtFormat12

 

This section is used to tell Automail the method used to separate the pages in a statement file.

There are three options that can be used to do this.

o‘Lines per Page:’ -This option if very rarely used. It would typically only be used when there is no other option available. The pages within the statement file must have the same number of lines per page in order for this option to function correctly.
o‘Header Text:’ –This option functions much in the same way the ‘Keyword’ option does in the ‘Accounts Separated By’ section to separate statements. However, this text must be at the beginning of each page. There is no way to define a specific position so Automail will look at the beginning of each page.
o‘Form Feed’ – This has two possible settings.
i.‘Header’ – Form feed will be place at the beginning of each page
ii.‘Footer’ – Form feed will be place at the bottom of each page.
oForm feeds can be tricky. You must be able to properly determine whether a form feed is a header or footer based on how they are positioned in the file at the beginning and end of the file. If you need help, ask another technician.

 

File Header

StmtFormat13

 

Some statement files that are produced have extra lines at the beginning of the file. These lines only exist before the first statement. When specifying your text locations, Automail does not need to count these as it will cause your location settings to be incorrect for everything after your first statement. Automail must be set to not count these lines. There are two ways to do this.
oNumber of Lines in Header:’ – This option is used if the number of extra lines is specific and will always remain the same.
o‘Header By Keyword’ – This option is used if the number of extra lines will change on a ‘per file’ basis. Ex: ITI Director.
If the number of lines change but the last line always has specific text, then this option will work. For example, ITI files always will say ~EDICT on the last header line. In this case this will be entered into the ‘Header Keyword:’ field. The number ‘0’ will then be entered into the ‘Lines Diff From’ field.

StmtFormat14

 

Name/Address Start Position

 

StmtFormat15

 

This section is used to extract the address data from the statement file. One of Automail’s functions is to position the address in the file that allows it to be visible in the window of the envelope being used to mail the statement. In order to do this, Automail must know the exact position of the address.
Another function of Automail is to verify the accuracy of the address using the CASS database provided by the USPS. This function takes the address listed in the statement file and compares it to the USPS database.

 

Address Service Change

StmtFormat16

This section is not used in Automail Pro 7.

 

Import Defaults

StmtFormat17

The options in this section will vary depending on the situation you are dealing with. The first option tells Automail how many lines of address to process. This can vary depending on the statement file layout.
The next option, ‘When Input File is selected, make Output File the same’ is used when the output file that Automail is created must be the same as the input file being processed. This will overwrite the input file and replace it with the output file.
‘Clean-up Nulls, CrLf and Form Feeds is used by Automail to remove any additional items not needed by the system.

 

Define Fields for Filters

StmtFormat18

Define Fields for Filters is used in different situations which are discussed in other sections of this manual. The function of it however, is to define a specific location of text that can be extracted by Automail for different purposes. Some of the uses of this are: setting up excludes or defining pages for Automail controlled printing.

 

This is the end of the ‘Statement Format’ section. Next topic that will be discussed is the ‘Output’ tab.

minusOutput

Once data is parsed for input, stored in AutoMail®'s databases, and any all presort functions are accomplished, Output formatting needs to be identified. This is accomplished in both the Output and More Output forms / screens.

 

This particular section will detail each setting / field within the Output form.

clip0002

 

minusMove Lines:

clip0003

AutoMail® has the ability to move data, or portions thereof. Ideally, the goal is to NOT move pre-defined data, but if necessary it can be done. This functionality defines itself with the FROM Line, Col, Len, TO Line, Col description. Multiple "moves" can be added.

minusFixed-Length Files

clip0004

Fixed-Length Files:

Fixed-Length I/O

Though not often used, AutoMail® has functionality to "output" files in a fixed-length (as opposed to relative length) format. By default, output will be generated with the same record lengths as input. However, depending on what text AutoMail® may add, these record lengths could, potentially, be extended. Some vendors "require" a static, or fixed, length for their files. This counts when AutoMail® is instructed to pass a file to, back to, a vendor's system for final processing and printing.

Output Lf Only

Strips the standard CR from CR/LF (carriage-return / line-feed). This can be viewed as ASCII characters 0D (Carriage Return) and 0A (LineFeed).

See also ASCII Table.

Internal Record Len:

Indicates record length for internal files created for master purpose (e.g. StmtFL.txt, Append StmtFL.txt, etc.)

Starting with AutoMail® version 8 this concept changes. These "master files" are no longer used.

hmtoggle_arrow1Add Lines

clip0006

 

Allows addition of extra blank lines; different from the original input file parsed in. Use with caution.

hmtoggle_arrow1Miscellaneous

clip0007

 

Last Page Totals-Keyword:

e.g. if checked, and the field populated, AutoMail® locates a Last Page Totals-Keyword, stores that page information, and then creates output as a final page. In other words, this will prevent AutoMail® from treating a page intended for last page total display to be handled as if it were a part of a document.

Include Postage On Keyline For Flat Singles

old field. This occurs by default, regardless of whether or not this box is checked.

Run FTP for File Transfer

old field. All FTP functionality is controlled in FTP Settings.

 

clip0008

 

Print Name/Address from Top Down (unchecked is Bottom Up)

Determines direction (up or down) for which Name/Address information is written to output. Name/Address "Start Line" is defined in More Output. Whatever the Start Line, having this field checked / un-checked will determine whether Name/Address data is written from the Start Line "down", or the Start Line "up".

Add AutoMail Header Line (required for processing multiple files)

This is indicative of the <AccountHdr>, <PageNbr>, etc. tags needed in the output when AutoMail® is combining / reformatting multiple files.

oAdd OMR String

If checked, allows for configuring OMR settings.

clip0009

oCalculate Inserting Last Page on Duplex

This selection forces AutoMail® to maintain an accurate / true page count if the documents will ultimately be printed in Duplex mode. For example, if a final page of a document set were to be "blank", this causes AutoMail® to calculate that page as part of the document.

Add Process Verification Information Line

clip0010

 

Remove Non-print User Text (headers, footers, JCL, etc.)necesss

Strips the file of headers, footers, etc. if not being used for print purposes. In other words, text such as form-feeds would not necessarily be removed by this function.

oNumber of Bytes to Format File:

Usually an extended value, if used, to indicate a total number of bytes (file size) for output.

 

 

minusMore Output

clip0011

 

clip0016

indicate start line / column to write OEL, Keyline, Name lines

 

 

clip0014

 

minusCustomizations

clip0015

 

minusImages

BIG IDEA:

AutoMail®'s StatementFile ToolSet does NOT handle images (text only). That is why these functions exist.Both the Images and Image File forms (in Statement File ToolSet) direct AutoMail® to glean image information either from the main document / statement itself or from a separate file provided by a vendor (most typically an image system vendor). This is an important aspect of correctly calculating weights based on the number of pages / sheets of paper in a give document. Depending on the file type / file layout / vendor provider ....several image information tools are available.

 

See details, below this screen-shot, describing the various methods AutoMail® uses to gather image information for the purpose of page / sheet calculation.

clip0017

 

Count Items in Statement -

clip0019

clip0020

 

Identical to the Checks form. Most typically customer financial statements do not delineate deposit (credits) checks from customer checks written against the account (debits). Therefore, it is not typically necessary to identify them separately.

 

Above is a typical example of counting items within the statement file. Fairly self-explanatory, check images are identified by...

a.determining the number of visual columns of check items listed
b.then determining the literal character Start Col and End Col.
i.Notice that the Dec Pt (decimal point) location / column can be identified as well.
c.Under the Use heading (just below the Close button) a technician can indicate what fields should be parsed.

 

minusImage File

Some vendors provide image information in a file, which requires that we understand the file-layout. You'll need to obtain this from the vendor or customer.

 

Define Image Layout

clip0021

 

The example below demonstrates that AutoMail® will pick up the account number (so as to reconcile image information with each document / account) and we are also given explicit Image Codes.

 

Image Layout Information

clip0022

 

Define Image Codes

clip0023

 

Image File Info

clip0024

 

Image Properties

clip0025