S41 Format Examples

You can abbreviate table names in S41 and M41 formats. Here is a list of table name abbreviations:

Table Name

Abbreviation

borrower

bt

borrower_barcode

bb

borrower_address

ba

borrower_phone

bp

borrower_bstat

bs

borrower_image

bi

You can use a return in a line in any format by entering \ before the return. No spaces or tabs are allowed between the \ and the return. If there is a return mid-header line or mid-data line that is not preceded by \, Borrower Import displays an error. To check this, load your datafile into the Windows Notepad. Open the Edit menu and uncheck Word Wrap. You should see 1 line per record.

header1.txt

x– bt(1).name; bt(1).second_id; bb(1).bbarcode; ba(1).address_type; ba(1).mail_sort_type;
ba(1).address1; ba(1).address2; bi(1)

data1.txt

M-Bown, Alisa; 859-08-3798; 23124000009085; 0; dom; 1882 Columbia Lane; Orem UT 84058
M-Jensen, Dave; 338-96-9754; 23124000009098; 0; dom; 90 S 2025 N Orem UT; 84058; C:\Users\Administrator\My Pictures\9085.jpg

header2.txt

x– bt(1).name[20] bt(1).second_id[12]bb(1).bbarcode[15] ba(1).address_type[2] ba(1).mail_sort_type[5] ba(1).address1[20] ba(1).address2[20] ba(2).address_type[7] ba(2).mail_sort_type[5] ba(2).address1[21] ba(2).address2[20]

data2.txt

M Bown, Alisa 809-76-7432 23124000009085 1 dom 1882 S Columbia Ln Orem UT 84058 0 dom 18743 Fairfax Drive Farmington MI 48660
M Jensen, Dave 759-89-2234 23124000009098 1 dom
90 S 2025 N Orem UT 84058 0 dom 1660 Oak Place Nashville TN 59901

 


© 1998-2017 Sirsi Corporation