Understanding Horizon’s email Flat-File Structure

Horizon’s automated email send process uses a data flat-file to extract and build email notices. If your library wants to use a non-Horizon extraction and email sending process, you can use the same flat-file.

Here is the flat-file structure for email notices as defined in Horizon:

Header line (is all one line)

#####<1h><0h><1h>borrower name<1Fh>borrower email<1Fh>subject<1Fh>from address name<1Fh>

from e-mail address<1Fh>reply to e-mail address<1Fh>BCC e-mail address<1Fh>batch number <1Fh>content number<iFh><\n>

Body information (starts on next line following the header line)

line<\n>

line<\n>

<1Fh><1Dh>

The email structure repeats for each email message in the flat-file.

Horizon email notices use information from the Addresses group of the location view to define these elements:

From Address Name
From email Address
Reply to email Address
BCC email Address

If the location’s Addresses group fields contain no information, Horizon looks for the email addresses in the email_param view. If those fields contain no information, these elements will not display in the email messages that you send.

The batch number and content number refer to the corresponding rows in notice_batch, notice, and notice_content tables from which the email is created.

You can extract other information for your email messages from the columns in the notice and notice_content tables. (For more information, see Using Notice Tables. For instructions on formatting notices, see Setting Up a Circulation Notice Format.)

 


© 1998-2017 Sirsi Corporation