Import/Export File Formats
FOR OLD LIEN WRITER FORMAT ONLY

What we call the Old Lien Writer" (from MS-DOS) format is a one field per line, n number of fields per record interface that was originally designed for use with Main Frame computers and Accounting packages that were capable of printing data to disk but no other export format.  The structure for the export files is listed below:

All fields are ASCII text, one line per field terminated by a carriage return (CHR(13)) or carriage return / line feed (CHR(13) + CHR(10))

Field # = Order of input field;

Field Data = What field is filled with the data;

T = Data type (again text format):

     N = Number field

     C = Character field (Alphanumer and other legal characters);

     B = Logical or Boolean field (Y or N.  See special circumstances for Field #21, below);

     D = Date field (MM/DD/YY) or (MM/DD/YYYY)

Ln = Field Maximum Length (Date can be 10, but defaults to 8)

IMPORT/EXPORT FILE FORMAT, CURRENT JOBS OR HISTORY TABLE

Field# Field Data                     T    Ln    Field# Field Data                                  T   Ln
1)     Company Number (yours)         N     5    35)    General Contractor Contract                 C   16
2)     Customer Account Number        C    16    36)    Lender/Surety Name                          C   35
3)     Customer Company Name          C    35    37)    2nd Line Lender/Surety Name                 C   35
4)     2nd Line Customer Name         C    35    38)    Lender Mailing Address                      C   35
5)     Customer Contact Person        C    35    39)    Lender/Surety City                          C   21
6)     Customer Mailing Address       C    35    40)    Lender/Surety State                         C    2
7)     Customer City                  C    21    41)    Lender/Surety Zip Code                      C   10
8)     Customer State                 C     2    42)    Lender/Surety Acct/Bond                     C   16
9)     Customer Zip Code              C    10    43)    Accounts Receivable Number                  C   16
10)    Customer Phone                 C    12    44)    Payment Order Number                        C   16
11)    Entry Date of Record           D     8    45)    Job/Invoice Number                          C   16
12)    Follow Up Date                 D     8    46)    Estimated Amount                            N   11
13)    Project Name                   C    35    47)    Balance Due                                 N   11
14)    2nd Line Project Name          C    35    48)    Date Pre-Liened                             D    8
15)    Project Mailing Address        C    35    49)    Begin Furnishing Date                       D    8
16)    Project City                   C    21    50)    End Furnishing Date                         D    8
17)    Project State                  C     2    51)    Job Completed Date                          D    8
18)    Project Zip Code               C    10    52)    Notice of Completion Date                   D    8
19)    Assessors Parcel Number        C    64    53)    Do Releases Monthly on Job                  B    1
20)    State of Project location      C     2    54)    Have List of my Lienors? (Y or N)           B    1
21)    Is Public Job? (Y or N)*       B     1    55)    Additional Parties to Lien? (Y or N)        B    1
22)    Owner Name                     C    35    56)    Billing Cycle                               C    2
23)    2nd Line Owner Name            C    35    57)    Record ID #                                 C   12
24)    Owner Mailing Address          C    35    58)    Print Customer Certified? (Y or N)          B    1
25)    Owner City                     C    21    59)    Customer Certified Number                   C   27
26)    Owner State                    C     2    60)    Print Owner Certified? (Y or N)             B    1
27)    Owner Zip Code                 C    10    61)    Owner Certified Number                      C   27
28)    Owner Contract Number          C    16    62)    Print General Certified? (Y or N)           B    1
29)    General Contractor Name        C    35    63)    General Certified Number                    C   27
30)    2nd Line General Contractor    C    35    64)    Print Lender/Surety Certified? (Y or N)     B    1
31)    General Contractor Address     C    35    65)    Lender/Surety Certified Number              C   27
32)    General Contractor City        C    21    66)    Customer Fax Number                         C   12
33)    General Contractor State       C     2                     
34)    General Contractor Zip Code    C    10

* The Public Job field (#21) has several other potential settings beside yes (Y) and (N).  The default is false (N), or checkbox unchecked, but if one of the following letters is used data input is affected in the following manner:

Y = Public Job is Checked;
N = Public Job is Unchecked;
F = Public Job is Checked, Federal Job is Checked (Federal job);
S = Public Job is Checked (State job);
P = Public Job is Unchecked, Residential Job is Checked (Private, Residential job);
C = Public Job is Unchecked, Residential Job is Unchecked (Commercial, Private job).

IMPORT/EXPORT FILE FORMAT, OTHER LIENING PARTIES TABLE

Field# Field Data                     T   Ln     Field# Field Data                                  T   Ln
1)     Claim Paid? (Y or N)           B    1     14)    Customer Attention                          C   35
2)     Entry Date                     D    8     15)    Customer Street                             C   35
3)     Company Name                   C   35     16)    Customer City                               C   21
4)     Company Attention              C   35     17)    Customer State                              C    2
5)     Company Street                 C   35     18)    Customer Zip                                C   10
6)     Company City                   C   21     19)    Print Customer Certified? (Y or N)          B    1
7)     Company State                  C    2     20)    Customer Certified Number                   C   27
8)     Company Zip Code               C   10     21)    Customer Payment Order #                    C   16
9)     Print Company Certified? (Y/N) B    1     22)    Estimated Amount                            N   11
10)    Company Certified Number       C   27     23)    Balance Due                                 N   11
11)    Service Description            C   35     24)    Main Record ID Number                       C   12
12)    Company Job Number             C   16     25)    Lien Record ID Number                       C   12
13)    Customer Name                  C   35

IMPORT/EXPORT FILE FORMAT, OTHER LEGAL PARTIES TABLE

Field# Field Data                     T   Ln     Field# Field Data                                  T   Ln
1)     Owner Name                     C   35     16)    General Contr. Contract #                   C   16
2)     Owner Attention                C   35     17)    Print General Certified? (Y or N)           B    1
3)     Owner Address                  C   35     18)    General Certified Number                    C   27
4)     Owner City                     C   21     19)    Lender/Surety Name                          C   35
5)     Owner State                    C    2     20)    2nd Line Lender/Surety Name                 C   35
6)     Owner Zip Code                 C   10     21)    Lender Mailing Address                      C   35
7)     Owner Contract Number          C   16     22)    Lender/Surety City                          C   21
8)     Print Owner Certified? (Y/N)   B    1     23)    Lender/Surety State                         C    2
9)     Owner Certified Number         C   27     24)    Lender/Surety Zip Code                      C   10
10)    General Contractor             C   35     25)    Lender/Surety Acct/Bond                     C   16
11)    General Attention              C   35     26)    Print Lender Certified? (Y or N)            B    1
12)    General Address                C   35     27)    Lender Certified Number                     C   27
13)    General City                   C   21     28)    Main Record ID Number                       C   12
14)    General State                  C    2     29)    Legal Record ID Number                      C   12
15)    General Zip Code               C   10

IMPORT/EXPORT FILE FORMAT, REFERENCE TABLE

Field# Field Data                     T   Ln     Field# Field Data                                  T   Ln
1)     Customer Account Number        C   16     6)     Customer City                               C   21
2)     Customer Company Name          C   35     7)     Customer State                              C    2
3)     2nd Line Customer Name         C   35     8)     Customer Zip Cod                            C   10
4)     Customer Contact Person        C   35     9)     Customer Phone                              C   12
5)     Customer Mailing Address       C   35     10)    Customer Fax                                C   12

During import, if the data is not in this format, it will not display correctly when using the Display Import option (see below).

Special Note: The Reference table requires that every reference have an account number. This field is particularly important if you are doing a Data Update. In the case of references, you can use the Data Update feature to import records from your company table that will 1) update the current record if an account number is found or 2) add the record as a new record if not. The Current Jobs/Liens, History, Other Liening Parties and Other Legal Parties tables use automatically generated and unique Record ID# numbers without user intervention.

When exporting or importing records, you can opt to display the data being imported or exported before anything is done with the data. Pressing Import will accept the record, Skip will skip to the next record, Import Rest will accept the rest of the records without review and Cancel will abort the import or export. Display is particularly useful during import if you want to check if the data is  lining up accurately. Just use Import to make sure several of the records in a row are coming in correctly. If so, press Cancel  to abort the import, then you can import again without the display option on with confidence.

Created with the Personal Edition of HelpNDoc: Create help files for the Qt Help Framework