|
Lines 55-64
Options:
Link Here
|
| 55 |
-fu=X --fineunder=X update if fines under X amount |
55 |
-fu=X --fineunder=X update if fines under X amount |
| 56 |
-rb=date --regbefore update if registration date is before given date |
56 |
-rb=date --regbefore update if registration date is before given date |
| 57 |
-ra=date --regafter update if registration date is after a given date |
57 |
-ra=date --regafter update if registration date is after a given date |
| 58 |
-d --dbfield name=value where <name> is a column in the borrowers table, patrons will be updated if the field is equal to given <value> |
58 |
-d --field name=value where <name> is a column in the borrowers table, patrons will be updated if the field is equal to given <value> |
| 59 |
-dn --notfield name=value where <name> is a column in the borrowers table, patrons will be updated if the field is equal to given <value> |
59 |
-dn --notfield name=value where <name> is a column in the borrowers table, patrons will be updated if the field is not equal to given <value> |
| 60 |
-dl --likefield name=value where <name> is a column in the borrowers table, patrons will be updated if the field is equal to given <value> |
60 |
-dl --likefield name=value where <name> is a column in the borrowers table, patrons will be updated if the field is like the given <value> |
| 61 |
-dnl --notlikefield name=value where <name> is a column in the borrowers table, patrons will be updated if the field is equal to given <value> |
61 |
-dnl --notlikefield name=value where <name> is a column in the borrowers table, patrons will be updated if the field is not like the given <value> |
| 62 |
-v -verbose verbose mode |
62 |
-v -verbose verbose mode |
| 63 |
-c --confirm commit changes to db, no action will be taken unless this switch is included |
63 |
-c --confirm commit changes to db, no action will be taken unless this switch is included |
| 64 |
-b --branch <branchname> only deal with patrons from this library/branch |
64 |
-b --branch <branchname> only deal with patrons from this library/branch |
|
Lines 125-130
Enter a date in ISO format YYYY-MM-DD and only patrons registered after this dat
Link Here
|
| 125 |
=item B<--field column=value | -d column=value> |
125 |
=item B<--field column=value | -d column=value> |
| 126 |
|
126 |
|
| 127 |
Use this flag to specify a column in the borrowers table and update only patrons whose value in that column equals the value supplied (repeatable) |
127 |
Use this flag to specify a column in the borrowers table and update only patrons whose value in that column equals the value supplied (repeatable) |
|
|
128 |
A value of null will check for a field that is not set. |
| 128 |
|
129 |
|
| 129 |
e.g. |
130 |
e.g. |
| 130 |
--field dateexpiry=2016-01-01 |
131 |
--field dateexpiry=2016-01-01 |
|
Lines 133-143
will update all patrons who expired on that date, useful for schools etc.
Link Here
|
| 133 |
=item B<--notfield column=value | -dn column=value> |
134 |
=item B<--notfield column=value | -dn column=value> |
| 134 |
|
135 |
|
| 135 |
Use this flag to specify a column in the borrowers table and update only patrons whose value in that column does not equal the value supplied (repeatable) |
136 |
Use this flag to specify a column in the borrowers table and update only patrons whose value in that column does not equal the value supplied (repeatable) |
|
|
137 |
A value of null will check for a field that is not set. |
| 136 |
|
138 |
|
| 137 |
e.g. |
139 |
e.g. |
| 138 |
--notfield email=NULL |
140 |
--notfield email=NULL |
| 139 |
will update all patrons with no value for email |
141 |
will update all patrons with no value for email |
| 140 |
|
142 |
|
|
|
143 |
=item B<--likefield column=value | -dl column=value> |
| 144 |
|
| 145 |
Use this flag to specify a column in the borrowers table and update only patrons whose value in that column is like the value supplied (repeatable) |
| 146 |
use '%' as a wildcard. |
| 147 |
A value of null will check for a field that is not set. |
| 148 |
|
| 149 |
e.g. |
| 150 |
--likefield categorycode=%CHILD |
| 151 |
will update all patrons with a category ending in CHILD. |
| 152 |
|
| 153 |
=item B<--notlikefield column=value | -dnl column=value> |
| 154 |
|
| 155 |
Use this flag to specify a column in the borrowers table and update only patrons whose value in that column is not like the value supplied (repeatable) |
| 156 |
use '%' as a wildcard. |
| 157 |
A value of null will check for a field that is not set. |
| 158 |
|
| 159 |
e.g. |
| 160 |
--notlikefield categorycode=RESIDENT% |
| 161 |
will update all patrons whose category does not begin with RESIDENT. |
| 162 |
|
| 141 |
=back |
163 |
=back |
| 142 |
|
164 |
|
| 143 |
=head1 DESCRIPTION |
165 |
=head1 DESCRIPTION |
| 144 |
- |
|
|