![]() |
BillMax Billing Solutions 877.245.5629 sales@billmax.com |
lists — Default data for lists table
The /usr/local/billmax/cfg/lists file contains the definitions for the standard BillMax Lists. The lists file is used by mklists populate the lists table and the listdef table. The lists file must be formatted in the following manner:
Each line must begin with one of the following strings:
# - comment line
LISTDEF - A list definition
LISTREC - A list entry
A LISTDEF line consists of 9 fields separated by tabs. Each field must be present. Consecutive tabs are allowed. The fields are:
LISTDEF - specifying a List definition line.
List name.
List description.
List button title for display on the "Administer Lists" web page.
The Permissions set of a Authorized BillMax User must intersect this set of Permissions to be able to view the List entries.
The Permissions set of a Authorized BillMax User must intersect this set of Permissions to be able to modify the List entries.
The Constraints used enforce data integrity for lists.value when entering a new item in a List. regexmacros list values are not allowed.
User specified sort order of entries. Used for display purposes.
Specifies whether entries in a particular list may be deleted.
0 - list items may be deleted.
1 - list items may not be deleted.
Specifies whether the entries for lists.value for a particular List must be unique.
0 - non-unique entries allowed.
1 - entries must be unique.
A LISTREC line consists of 8 fields separated by tabs. Each field must be present. Consecutive tabs are allowed. The fields are:
LISTREC - specifying a List entry line.
List name.
Inserted into the lists.value field.
Inserted into the lists.descr field.
A number specifying the sort order when displaying the List entries.
Inserted into the lists.mutable field. If non-zero, the interpretation is that the entry may not be modified or deleted.
The Constraints used to enforce data integrity for the lists.value for the specific entry when entering a new item in a List. regexmacros list are not allowed.
Inserted into the lists.explanation field.
Example 4.6. List adcodes LISTDEFREC entry
LISTDEFREC adcodes Values for the "Adcodes" list on the account page. AD CODES 1 16 ^[0-9]+$ 0.00 0 1
Example 4.7. List adcodes LISTREC entry
LISTREC adcodes 0 None 0.00 1 (1) LISTREC adcodes 1 Radio 1.00 1 LISTREC adcodes 2 TV 2.00 1 LISTREC adcodes 3 Magazine 3.00 1 LISTREC adcodes 4 Newspaper 4.00 1 LISTREC adcodes 5 Phonebook 5.00 1 LISTREC adcodes 6 Billboard 6.00 1 LISTREC adcodes 7 UseNET 7.00 1 LISTREC adcodes 8 Search Engine 8.00 1 LISTREC adcodes 9 Friend 9.00 1 LISTREC adcodes 10 Web 10.00 1 LISTREC adcodes 11 Seminars 11.00 1 LISTREC adcodes 12 Direct Mail 12.00 1
| (1) | Note that absence of a constraint or a mutable entry. However, there are 2 tabs at the end of the line. |