![[ New ]](../~Louis/new_4.gif)
bp3037vw3042| Acquisitions | Authority | Booking | Cataloging | Circulation | Reserve | Serials | User | Other |
| Source Name |
Brief Description |
STATUS |
|---|---|---|
| ia3025 |
This report sets the load date of selected orders from NEVER to TODAY. By updating the load date, iLink will no longer display the ON ORDER or RECEIVED message. The API transaction in the script is hardcoded with the OLOL library. This report is based on the Sirsi delivered report List Orders Distribution (distlist). The report output remains the same as the Sirsi delivered report. INPUT: vendor, vendor cycle, order, orderline, distribution OUTPUT: updates the date loaded to TODAY, outputs the same report as List Orders Distribution (distlist) SORT OPTIONS: order ID, vendor ID, packing list | Production |
| lt3025 |
This report sets the load date of subscription orders to TODAY if the load date is NEVER. It is used to load subscription orders from prior fiscal years. This program was written for sites who have multiple orderlines for an orderid. By updating the load date, in iLink the message which displays the number of copies on order is changed to reflect the current number of copies on order. This report is based on the Sirsi delivered report List Orders Distribution (distlist). The report output remains the same as the Sirsi delivered report. INPUT: vendor, vendor cycle, order, orderline, distribution OUTPUT: updates the date loaded to TODAY, outputs the same report as List Orders Distribution (distlist) SORT OPTIONS: order ID, vendor ID, packing list | Training |
| lu3025 |
This report sets the load date of subscription orders to TODAY if the load date is NEVER. It is used to load subscription orders from prior fiscal years. This program was written for Southeastern who has multiple orderlines for an orderid. By updating the load date, in iLink the message which displays the number of copies on order is changed to reflect the current number of copies on order. This report is based on the Sirsi delivered report List Orders Distribution (distlist). The report output remains the same as the Sirsi delivered report. INPUT: vendor, vendor cycle, order, orderline, distribution OUTPUT: updates the date loaded to TODAY, outputs the same report as List Orders Distribution (distlist) SORT OPTIONS: order ID, vendor ID, packing list | Production |
| lw3025 |
This report sets the load date of subscription orders to TODAY if the load date is NEVER. It is used to load subscription orders from prior fiscal years. This program was written for sites who have multiple orderlines for an orderid. By updating the load date, in iLink the message which displays the number of copies on order is changed to reflect the current number of copies on order. This report is based on the Sirsi delivered report List Orders Distribution (distlist). The report output remains the same as the Sirsi delivered report. INPUT: vendor, vendor cycle, order, orderline, distribution OUTPUT: updates the date loaded to TODAY, outputs the same report as List Orders Distribution (distlist) SORT OPTIONS: order ID, vendor ID, packing list | Training |
| no3025 |
This report sets the load date of selected orders from NEVER to TODAY. By updating the load date, iLink will no longer display the ON ORDER or RECEIVED message. The API transaction in the script is hardcoded with the UNO library. This report is based on the Sirsi delivered report List Orders Distribution (distlist). The report output remains the same as the Sirsi delivered report. INPUT: vendor, vendor cycle, order, orderline, distribution OUTPUT: updates the date loaded to TODAY, outputs the same report as List Orders Distribution (distlist) SORT OPTIONS: order ID, vendor ID, packing list | Production |
| sl3025 |
This report sets the load date of subscription orders to TODAY if the load date is NEVER. It is used to load subscription orders from prior fiscal years. This program was written for Southeastern who has multiple orderlines for an orderid. By updating the load date, in iLink the message which displays the number of copies on order is changed to reflect the current number of copies on order. This report is based on the Sirsi delivered report List Orders Distribution (distlist). The report output remains the same as the Sirsi delivered report. INPUT: vendor, vendor cycle, order, orderline, distribution OUTPUT: updates the date loaded to TODAY, outputs the same report as List Orders Distribution (distlist) SORT OPTIONS: order ID, vendor ID, packing list | Production |
| lu3030 |
This report outputs acquisitions and bibliographic data to a tab-delimited file only. INPUT: Selection criteria includes fund, fundcycle, funding, orderline, order, title, call number, and copy. OUTPUT: The first record in the file shows the fields and their order in the tab-delimited file: title, tag001, tag022, library, call number, amount paid, date paid, fiscal cycle total amount paid, order type. SORT OPTIONS: none | Production |
| lu3047 |
This report lists unlinked orders. INPUT: orderline, callnumber, order selection criteria. OUTPUT: tab delimited file containing these fields: library, fiscal cycle, order ID, order type, title SORT OPTIONS: None. | Production |
| lu5000 |
This report is an exact duplicate of the bibload report, with one difference: this one flips the flexkeys from the 020 (ISBN) to the 035 (OCLC number) for the records. As a result, this report is unique to an LSU process. The process involves 3 steps: 1) load brief bib records from YBP creating the flexkey from the 020 (ISBN) 2) Load order records that link to the YBP records 3) overlay the brief YBP records with full marc records from OCLC matching on the flexkey (ISBN) and then change the flexkey from the ISBN to the OCLC number. This report MUST BE RUN AS STEP 3 IN ORDER TO CHANGE THE FLEXKEY FROM 020 (ISBN) TO 001 (OCLC). | Test |
| ax5001 |
This report outputs a tab-delimited file and a formatted report. It is a copy of the Sirsi delivered report fundcyclelist with the addition of a tab-delimited file. INPUT: Selection criteria includes fund and fundcycle OUTPUT: The original formatted Sirsi report and a tab-delimited report. The first record in the file shows the fields and their order in the tab-delimited file: fundcycle key, fund library, fund id, fund name, fund level1, fund level2, fund level3, fund level4, account, fund key, fiscal cycle, amount allocated, amount invoiced, unextended amount ordered, amount encumbered, amount paid SORT OPTIONS: fund, fund id | Production |
| lt5001 |
This report outputs a tab-delimited file and a formatted report. It is a copy of the Sirsi delivered report fundcyclelist with the addition of a tab-delimited file. INPUT: Selection criteria includes fund and fundcycle OUTPUT: The original formatted Sirsi report and a tab-delimited report. The first record in the file shows the fields and their order in the tab-delimited file: fundcycle key, fund library, fund id, fund name, fund level1, fund level2, fund level3, fund level4, account, fund key, fiscal cycle, amount allocated, amount invoiced, unextended amount ordered, amount encumbered, amount paid SORT OPTIONS: fund, fund id | Production |
| lu5001 |
This report outputs a tab-delimited file and a formatted report. It is a copy of the Sirsi delivered report fundcyclelist with the addition of a tab-delimited file. INPUT: Selection criteria includes fund and fundcycle OUTPUT: The original formatted Sirsi report and a tab-delimited report. The first record in the file shows the fields and their order in the tab-delimited file: fundcycle key, fund library, fund id, fund name, fund level1, fund level2, fund level3, fund level4, account, fund key, fiscal cycle, amount allocated, amount invoiced, unextended amount ordered, amount encumbered, amount paid SORT OPTIONS: fund, fund id | Production |
| lw5001 |
This report outputs a tab-delimited file and a formatted report. It is a copy of the Sirsi delivered report fundcyclelist with the addition of a tab-delimited file. INPUT: Selection criteria includes fund and fundcycle OUTPUT: The original formatted Sirsi report and a tab-delimited report. The first record in the file shows the fields and their order in the tab-delimited file: fundcycle key, fund library, fund id, fund name, fund level1, fund level2, fund level3, fund level4, account, fund key, fiscal cycle, amount allocated, amount invoiced, unextended amount ordered, amount encumbered, amount paid SORT OPTIONS: fund, fund id | Production |
| ni5001 |
This report outputs a tab-delimited file and a formatted report. It is a copy of the Sirsi delivered report fundcyclelist with the addition of a tab-delimited file. INPUT: Selection criteria includes fund and fundcycle OUTPUT: The original formatted Sirsi report and a tab-delimited report. The first record in the file shows the fields and their order in the tab-delimited file: fundcycle key, fund library, fund id, fund name, fund level1, fund level2, fund level3, fund level4, account, fund key, fiscal cycle, amount allocated, amount invoiced, unextended amount ordered, amount encumbered, amount paid SORT OPTIONS: fund, fund id | Production |
| no5001 |
This report outputs a tab-delimited file and a formatted report. It is a copy of the Sirsi delivered report fundcyclelist with the addition of a tab-delimited file. INPUT: Selection criteria includes fund and fundcycle OUTPUT: The original formatted Sirsi report and a tab-delimited report. The first record in the file shows the fields and their order in the tab-delimited file: fundcycle key, fund library, fund id, fund name, fund level1, fund level2, fund level3, fund level4, account, fund key, fiscal cycle, amount allocated, amount invoiced, unextended amount ordered, amount encumbered, amount paid SORT OPTIONS: fund, fund id | Production |
| ax5004 |
This report outputs acquisitions and bibliographic data to a tab-delimited file only. INPUT: Selection criteria includes fund, fundcycle, funding, orderline, order, title, call number, and copy. OUTPUT: The first record in the file shows the fields and their order in the tab-delimited file: author, title, flexkey, tag001, format, item id, total charges, call number, fund library, fund id, fund name, level1, level2, level3, level4, acct number, funding total amt paid, funding date paid, funding type (except multiple funding), holding code, orderline number, orderline amt paid, orderline extended price, orderline date ordered, fiscal cycle, p.o.number, order type, item type, category1, category2, home location, item library SORT OPTIONS: none | Production |
| lt5004 |
This report outputs acquisitions and bibliographic data to a tab-delimited file only. INPUT: Selection criteria includes fund, fundcycle, funding, orderline, order, title, call number, and copy. OUTPUT: The first record in the file shows the fields and their order in the tab-delimited file: author, title, flexkey, tag001, format, item id, total charges, call number, fund library, fund id, fund name, level1, level2, level3, level4, acct number, funding total amt paid, funding date paid, funding type (except multiple funding), holding code, orderline number, orderline amt paid, orderline extended price, orderline date ordered, fiscal cycle, p.o.number, order type, item type, category1, category2, home location, item library SORT OPTIONS: none | Production |
| lu5004 |
This report outputs acquisitions and bibliographic data to a tab-delimited file only. INPUT: Selection criteria includes fund, fundcycle, funding, orderline, order, title, call number, and copy. OUTPUT: The first record in the file shows the fields and their order in the tab-delimited file: author, title, flexkey, tag001, format, item id, total charges, call number, fund library, fund id, fund name, level1, level2, level3, level4, acct number, funding total amt paid, funding date paid, funding type (except multiple funding), holding code, orderline number, orderline amt paid, orderline extended price, orderline date ordered, fiscal cycle, p.o.number, order type, item type, category1, category2, home location, item library SORT OPTIONS: none | Production |
| lw5004 |
This report outputs acquisitions and bibliographic data to a tab-delimited file only. INPUT: Selection criteria includes fund, fundcycle, funding, orderline, order, title, call number, and copy. OUTPUT: The first record in the file shows the fields and their order in the tab-delimited file: author, title, flexkey, tag001, format, item id, total charges, call number, fund library, fund id, fund name, level1, level2, level3, level4, acct number, funding total amt paid, funding date paid, funding type (except multiple funding), holding code, orderline number, orderline amt paid, orderline extended price, orderline date ordered, fiscal cycle, p.o.number, order type, item type, category1, category2, home location, item library SORT OPTIONS: none | Production |
| mn5004 |
This report outputs acquisitions and bibliographic data to a tab-delimited file only. INPUT: Selection criteria includes fund, fundcycle, funding, orderline, order, title, call number, and copy. OUTPUT: The first record in the file shows the fields and their order in the tab-delimited file: author, title, flexkey, tag001, format, item id, total charges, call number, fund library, fund id, fund name, level1, level2, level3, level4, acct number, funding total amt paid, funding date paid, funding type (except multiple funding), holding code, orderline number, orderline amt paid, orderline extended price, orderline date ordered, fiscal cycle, p.o.number, order type, item type, category1, category2, home location, item library SORT OPTIONS: none | Production |
| ne5004 |
This report outputs acquisitions and bibliographic data to a tab-delimited file only. INPUT: Selection criteria includes fund, fundcycle, funding, orderline, order, title, call number, and copy. OUTPUT: The first record in the file shows the fields and their order in the tab-delimited file: author, title, flexkey, tag001, format, item id, total charges, call number, fund library, fund id, fund name, level1, level2, level3, level4, acct number, funding total amt paid, funding date paid, funding type (except multiple funding), holding code, orderline number, orderline amt paid, orderline extended price, orderline date ordered, fiscal cycle, p.o.number, order type, item type, category1, category2, home location, item library SORT OPTIONS: none | Production |
| no5004 |
This report outputs acquisitions and bibliographic data to a tab-delimited file only. INPUT: Selection criteria includes fund, fundcycle, funding, orderline, order, title, call number, and copy. OUTPUT: The first record in the file shows the fields and their order in the tab-delimited file: author, title, flexkey, tag001, format, item id, total charges, call number, fund library, fund id, fund name, level1, level2, level3, level4, acct number, funding total amt paid, funding date paid, funding type (except multiple funding), holding code, orderline number, orderline amt paid, orderline extended price, orderline date ordered, fiscal cycle, p.o.number, order type, item type, category1, category2, home location, item library SORT OPTIONS: none | Production |
| sl5004 |
This report outputs acquisitions and bibliographic data to a tab-delimited file only. INPUT: Selection criteria includes fund, fundcycle, funding, orderline, order, title, call number, and copy. OUTPUT: The first record in the file shows the fields and their order in the tab-delimited file: author, title, flexkey, tag001, format, item id, total charges, call number, fund library, fund id, fund name, level1, level2, level3, level4, acct number, funding total amt paid, funding date paid, funding type (except multiple funding), holding code, orderline number, orderline amt paid, orderline extended price, orderline date ordered, fiscal cycle, p.o.number, order type, item type, category1, category2, home location, item library SORT OPTIONS: none | Production |
| ia5007 |
Based on Sirsi delivered report: List Funded Orders. This report also has selection criteria for distribution, vendor, and vendorcycle. INPUT: Selection criteria includes fund, funding, orderline, order, distribution, vendor, vendorcycle. OUTPUT: This report outputs a tab-delimited file only. The first record in the file shows the fields and their order in the tab-delimited file: Order ID,Order Type,Line Number,Description,Fund ID,Account Number,Level 1,Level 2,Level 3,Level 4,Amt Encumbered,Amt Invoiced,Amt Paid,Date Paid,Date Received,Date Created,Date Modified,Vendor SORT OPTIONS: none | Production |
| lt5007 |
Based on Sirsi delivered report: List Funded Orders. This report also has selection criteria for distribution, vendor, and vendorcycle. INPUT: Selection criteria includes fund, funding, orderline, order, distribution, vendor, vendorcycle. OUTPUT: This report outputs a tab-delimited file only. The first record in the file shows the fields and their order in the tab-delimited file: Order ID,Order Type,Line Number,Description,Fund ID,Account Number,Level 1,Level 2,Level 3,Level 4,Amt Encumbered,Amt Invoiced,Amt Paid,Date Paid,Date Received,Date Created,Date Modified,Vendor SORT OPTIONS: none | Production |
| lu5007 |
Based on Sirsi delivered report: List Funded Orders. This report also has selection criteria for distribution, vendor, and vendorcycle. INPUT: Selection criteria includes fund, funding, orderline, order, distribution, vendor, vendorcycle. OUTPUT: This report outputs a tab-delimited file only. The first record in the file shows the fields and their order in the tab-delimited file: Order ID,Order Type,Line Number,Description,Fund ID,Account Number,Level 1,Level 2,Level 3,Level 4,Amt Encumbered,Amt Invoiced,Amt Paid,Date Paid,Date Received,Date Created,Date Modified,Vendor SORT OPTIONS: none | Production |
| ne5007 |
Based on Sirsi delivered report: List Funded Orders. This report also has selection criteria for distribution, vendor, and vendorcycle. INPUT: Selection criteria includes fund, funding, orderline, order, distribution, vendor, vendorcycle. OUTPUT: This report outputs a tab-delimited file only. The first record in the file shows the fields and their order in the tab-delimited file: Order ID,Order Type,Line Number,Description,Fund ID,Account Number,Level 1,Level 2,Level 3,Level 4,Amt Encumbered,Amt Invoiced,Amt Paid,Date Paid,Date Received,Date Created,Date Modified,Vendor SORT OPTIONS: none | Production |
| no5007 |
Based on Sirsi delivered report: List Funded Orders. This report also has selection criteria for distribution, vendor, and vendorcycle. INPUT: Selection criteria includes fund, funding, orderline, order, distribution, vendor, vendorcycle. OUTPUT: This report outputs a tab-delimited file only. The first record in the file shows the fields and their order in the tab-delimited file: Order ID,Order Type,Line Number,Description,Fund ID,Account Number,Level 1,Level 2,Level 3,Level 4,Amt Encumbered,Amt Invoiced,Amt Paid,Date Paid,Date Received,Date Created,Date Modified,Vendor SORT OPTIONS: none | Production |
| ax5008 |
This report outputs a tab-delimited file only. It is similar to ig5004, except ax5008 outputs less fields, but does include year published and publisher (260 tag). INPUT: Selection criteria includes fund, fundcycle, funding, orderline, order, title, call number, and copy. OUTPUT:The first record in the file shows the fields and their order in the tab-delimited file: author, title, publisher (260 tag), year of publication, item id, call number, fundname, level1, level2, level3, level4, funding total amount paid, funding date paid, orderline amount paid, orderline extended price, orderline date ordered, fiscal cycle, p.o. number, item type Sort Options: call number/title/author, title/author/call number | Production |
| no5008 |
This report outputs a tab-delimited file only. It is similar to ig5004, except ax5008 outputs less fields, but does include year published and publisher (260 tag). INPUT: Selection criteria includes fund, fundcycle, funding, orderline, order, title, call number, and copy. OUTPUT:The first record in the file shows the fields and their order in the tab-delimited file: author, title, publisher (260 tag), year of publication, item id, call number, fundname, level1, level2, level3, level4, funding total amount paid, funding date paid, orderline amount paid, orderline extended price, orderline date ordered, fiscal cycle, p.o. number, item type Sort Options: call number/title/author, title/author/call number | Production |
| lu5009 |
This report outputs catalog, vendor, and order information. One call number per order record is output - the one to which the order record is linked. INPUT: fund, fundcycle, funding, order, orderline, vendor, title, call number OUTPUT:tab-delimited file with the following fields: author, title, callnum, fund ID, fund levels 1-4, holding code, PO number, orderline number, fiscal cycle, vendor, orderline unit price (encumbered), orderline amount (paid) SORT OPTIONS: none | Production |
| mn5009 |
This report outputs catalog, vendor, and order information. One call number per order record is output - the one to which the order record is linked. INPUT: fund, fundcycle, funding, order, orderline, vendor, title, call number OUTPUT:tab-delimited file with the following fields: author, title, callnum, fund ID, fund levels 1-4, holding code, PO number, orderline number, fiscal cycle, vendor, orderline unit price (encumbered), orderline amount (paid) SORT OPTIONS: none | Production |
| sl5009 |
This report outputs catalog, vendor, and order information. One call number per order record is output - the one to which the order record is linked. INPUT: fund, fundcycle, funding, order, orderline, vendor, title, call number OUTPUT:tab-delimited file with the following fields: author, title, callnum, fund ID, fund levels 1-4, holding code, PO number, orderline number, fiscal cycle, vendor, orderline unit price (encumbered), orderline amount (paid) SORT OPTIONS: none | Production |
| ax5010 |
Based on Sirsi delivered report: List Funded Orders. This report also has selection criteria for vendor and vendorcycle. INPUT: Selection criteria includes fund, funding, orderline, order, vendor, vendorcycle. OUTPUT: This report outputs a tab-delimited file only. The first record in the file shows the fields and their order in the tab-delimited file: Fund ID, Budgeted, Encumbered, Invoiced, Paid, Free Balance. SORT OPTIONS: none | Development |
| bp5011 |
This report outputs a tab-delimited file only. Selection criteria includes fund, fundcycle, funding, orderline, order, title, and copy. The report shows the list price of a title (list price will be used to charge users) and the unit price which is in the orderline. List price is calculated by dividing the unit price by the parts-in-set field. DELIVERED SCRIPT: fundtitlecost.pl INPUT: fund, fund cycle, funding, orderline, order, title, and copy OUTPUT:item id,title,pubyear,fund id,date received,order id,orderline number,vendor id,unit price,list price,parts-in-set SORT OPTIONS: none | Production |
| mn5012 |
This report creates a new user order notice (called acqcatconfirm) with the following notice text: "The items which you recommended for purchase have been received and are available in the library. The following is a list of what has been received." Selection criteria includes title and distribution as well as orderline. DELIVERED SCRIPT: User Order/Request Notice (acqnotice.pl) INPUT: orderline, title, distribution OUTPUT: notices with the above text as well as all output options in delivered report | Production |
| sl5012 |
This report creates a new user order notice (called acqcatconfirm) with the following notice text: "The items which you recommended for purchase have been received and are available in the library. The following is a list of what has been received." Selection criteria includes title and distribution as well as orderline. DELIVERED SCRIPT: User Order/Request Notice (acqnotice.pl) INPUT: orderline, title, distribution OUTPUT: notices with the above text as well as all output options in delivered report | Production |
| lt5013 |
This report is a duplicate of biborderload.pl. However, whereas the delivered report does not output the file of matched bib records, this custom report does output a list of matched bib records in the log of the finished report. Selection criteria remains the same as the delivered report. DELIVERED SCRIPT: biborderload.pl INPUT: Selection criteria includes an input file menu, title control processing options, order. OUTPUT: This report loads bibliographic records and extracts a flat ASCII text file of order records that can be loaded into the Unicorn order database. SORT OPTIONS: none | Production |
| lu5013 |
This report is a duplicate of biborderload.pl. However, whereas the delivered report does not output the file of matched bib records, this custom report does output a list of matched bib records in the log of the finished report. Selection criteria remains the same as the delivered report. DELIVERED SCRIPT: biborderload.pl INPUT: Selection criteria includes an input file menu, title control processing options, order. OUTPUT: This report loads bibliographic records and extracts a flat ASCII text file of order records that can be loaded into the Unicorn order database. SORT OPTIONS: none | Production |
| lw5013 |
This report is a duplicate of biborderload.pl. However, whereas the delivered report does not output the file of matched bib records, this custom report does output a list of matched bib records in the log of the finished report. Selection criteria remains the same as the delivered report. DELIVERED SCRIPT: biborderload.pl INPUT: Selection criteria includes an input file menu, title control processing options, order. OUTPUT: This report loads bibliographic records and extracts a flat ASCII text file of order records that can be loaded into the Unicorn order database. SORT OPTIONS: none | Production |
| dl5014 |
This report outputs catalog and call number information for those titles that DO NOT have an order attached to them. INPUT: title, call number OUTPUT:tab-delimited file with the following fields: title, date created, date cataloged, call number, class scheme, created by SORT OPTIONS: none | Production |
| lw5014 |
This report outputs catalog and call number information for those titles that DO NOT have an order attached to them. INPUT: title, call number OUTPUT:tab-delimited file with the following fields: title, date created, date cataloged, call number, class scheme, created by SORT OPTIONS: none | Production |
| mn5014 |
This report outputs catalog and call number information for those titles that DO NOT have an order attached to them. INPUT: title, call number OUTPUT:tab-delimited file with the following fields: title, date created, date cataloged, call number, class scheme, created by SORT OPTIONS: none | Production |
| ns5014 |
This report outputs catalog and call number information for those titles that DO NOT have an order attached to them. INPUT: title, call number OUTPUT:tab-delimited file with the following fields: title, date created, date cataloged, call number, class scheme, created by SORT OPTIONS: none | Production |
| lu5015 |
This report is identical to ig5014.pl except it outputs an additional field: title control number. It outputs catalog and call number information for those titles that DO NOT have an order attached to them, as does ig5014. INPUT: title, call number OUTPUT:tab-delimited file with the following fields: title, title control number, date created, date cataloged, call number, call number library, class scheme, created by SORT OPTIONS: none | Production |
| ax5016 |
This report is a copy of ig5004.pl. The only difference is that this report also outputs the NOTE field in the orderline. It also outputs a tab-delimited file. Selection criteria includes fund, fundcycle, funding, orderline, order, title, call number, and copy. The first record in the file shows the fields and their order in the tab-delimited file:author,title,flexkey,tag001,format,itemid,total charges,callnumber,fund library,fundid,fundname,level1,level2,level3,level4,acct number,funding total amt paid,funding date paid,funding type,holding code,orderline number,orderline amt paid,orderline ext price,orderline date ordered,orderline note field,fiscalcyc,p.o.number,ordertype,item type,category1,category2 | Production |
| sl5016 |
This report is a copy of ig5004.pl. The only difference is that this report also outputs the NOTE field in the orderline. It also outputs a tab-delimited file. Selection criteria includes fund, fundcycle, funding, orderline, order, title, call number, and copy. The first record in the file shows the fields and their order in the tab-delimited file:author,title,flexkey,tag001,format,itemid,total charges,callnumber,fund library,fundid,fundname,level1,level2,level3,level4,acct number,funding total amt paid,funding date paid,funding type,holding code,orderline number,orderline amt paid,orderline ext price,orderline date ordered,orderline note field,fiscalcyc,p.o.number,ordertype,item type,category1,category2 | Training |
| lu5017 |
This report updates the Unit Price in the orderline from a dollar amount to a zero amount. INPUT: Selection criteria includes orderline, order. OUTPUT: This report outputs a tab-delimited file. The first record in the file shows the fields and their order in the tab-delimited file: Description, Unit Price Before Update, Order ID SORT OPTIONS: none | Production |
| mn5018 |
This report sends a user a notices that the items the user requested could not be satisfied. DELIVERED SCRIPT: Based on: User Order/Request Notice (acqnotice.pl) INPUT: Cancel selections. OUTPUT: notices as well as all output options in delivered report | Production |
| ia5019 |
This report is a copy of lu5009.pl except this report does not output holding codes. It outputs catalog, vendor, and order information. One call number per order record is output - the one to which the order record is linked. INPUT: fund, fundcycle, funding, order, orderline, vendor, title, call number OUTPUT:tab-delimited file with the following fields: author, title, callnum, fund ID, fund levels 1-4, PO number, orderline number, fiscal cycle, vendor, orderline unit price (encumbered), orderline amount (paid) SORT OPTIONS: none | Production |
| lu5019 |
This report is a copy of lu5009.pl except this report does not output holding codes. It outputs catalog, vendor, and order information. One call number per order record is output - the one to which the order record is linked. INPUT: fund, fundcycle, funding, order, orderline, vendor, title, call number OUTPUT:tab-delimited file with the following fields: author, title, callnum, fund ID, fund levels 1-4, PO number, orderline number, fiscal cycle, vendor, orderline unit price (encumbered), orderline amount (paid) SORT OPTIONS: none | Production |
| lw5020 |
This report outputs catalog, vendor, and order information. One call number per order record is output - the one to which the order record is linked. INPUT: fund, fundcycle, funding, order, orderline, vendor, title, call number OUTPUT:tab-delimited file with the following fields: author, title, 260 tag, callnum, fund ID, fund levels 1-4, holding code, PO number, orderline number, fiscal cycle, vendor, orderline unit price (encumbered), orderline amount (paid), order type SORT OPTIONS: none | Production |
| ni5021 |
This report outputs acquisitions and bibliographic data to a tab-delimited file only. INPUT: Selection criteria includes fund, fundcycle, funding, orderline, order, title, call number, and copy. OUTPUT: The first record in the file shows the fields and their order in the tab-delimited file: title, tag001, tag022, library, call number, amount paid, date paid, fiscal cycle total amount paid, order type, fund id. SORT OPTIONS: none | Production |
| lw5025 |
Originated from invdetail.pl, a custom report Margaret Pelfrey at Sirsi, wrote for LOUIS. Differences: no search box for invoice ids; outputs order ids in addition to original output; invoice ids begin with apostrophe to allow leading zeroes to display correctly in a spreadsheet. INPUT: Selection criteria includes invoice, invoice line, fund, fundcycle. OUTPUT: Tab-delimited file with Invoice ID, Invoice Date, Invoice Create Date, Vendor ID, Invoice Line Type, Invoice Line Number, Invoice Line Amount, Amount Invoiced, Amount Paid, Library, Fund ID, Account Number, Fund Level 1, Fund Level 2, Fund Level 3, Fund Level 4, Order ID. | Production |
| lu5026 |
This program will FTP invoice files from YBP to Xfer, add an extension to the files in Xfer and rename the files on YBP's server. | Production |
| lu5027 |
This report will move a selected EDI invoice file from Xfer to Edi/Incoming. | Production |
| no5030 |
This report outputs a comma delimited file of invoice data which will be sent to UNO's business office. INPUT: invoice OUTPUT: record type(UNO field),vendor id, invoice amount, freight amount (UNO field), vendor name, invoice number, invoice date, speedkey (UNO field), account (extended info field in invoice), bookstore PO (UNO field) SORT OPTIONS: none | Production |
| ax5031 |
This report is a copy of ig5016.pl. The only difference is that this report does not output item information. It also outputs a tab-delimited file. Selection criteria includes fund, fundcycle, funding, distribution, orderline, order, title, and call number. The first record in the file shows the fields and their order in the tab-delimited file: author,title,flexkey,callnumber,fundid,level3,level4,funding total amt paid,holding code,orderline date ordered,extended info field,fiscalcyc,p.o.number. | Production |
| Source Name |
Brief Description |
STATUS |
|---|---|---|
| lu3083 |
Program is a copy of List Unauthorized Tags (unauthlst) with the addition of a search box. Search term and entry id must be entered. Entry id entered cannot be "All". If you do not want to use a search term, use the delivered report. INPUT: Search box, entry ids, title, call number OUTPUT: same as delivered report SORT OPTIONS: none | Production |
| Source Name |
Brief Description |
STATUS |
|---|---|---|
| lu5003 |
This report outputs a pipe-delimited file and a formatted report. It is a copy of the Sirsi delivered report List Booking with the addition of a pipe-delimited file. INPUT: Booking OUTPUT: Pipe Delimited SORT OPTIONS: patron booking start/user name, title/author, user ID, user name, call number, library/call number, library/title/author, library user ID or library/user name | Production |
| Source Name |
Brief Description |
STATUS |
|---|---|---|
| br1014 |
North American Title Count for LC, LCPER. Counts titles. INPUT: Selection criteria for title and item. OUTPUT: Tab-delimited files with the folowing fields: line number, subject area, NATC line number, call number range, number of titles SORT OPTIONS: none | Production |
| fl1014 |
North American Title Count for LC, LCPER. Counts titles. INPUT: Selection criteria for title and item. OUTPUT: Tab-delimited files with the folowing fields: line number, subject area, NATC line number, call number range, number of titles SORT OPTIONS: none | Production |
| ia1014 |
North American Title Count for LC, LCPER. Counts titles. INPUT: title, call number, copy selections OUTPUT:tab-delimited file for spreadsheet which includes line number, subject area, NATC line number, call number range, number of titles | Production |
| le1014 |
North American Title Count for LC, LCPER. Counts titles. INPUT: title, call number, copy selections OUTPUT:tab-delimited file for spreadsheet which includes line number, subject area, NATC line number, call number range, number of titles | Production |
| lt1014 |
North American Title Count for LC, LCPER. Counts titles. INPUT: title, call number, copy selections OUTPUT:tab-delimited file for spreadsheet which includes line number, subject area, NATC line number, call number range, number of titles | Production |
| lu1014 |
North American Title Count for LC, LCPER. Counts titles. INPUT: title, call number, copy selections OUTPUT:tab-delimited file for spreadsheet which includes line number, subject area, NATC line number, call number range, number of titles | Production |
| lw1014 |
North American Title Count for LC, LCPER. Counts titles. INPUT: title, call number, copy selections OUTPUT:tab-delimited file for spreadsheet which includes line number, subject area, NATC line number, call number range, number of titles | Production |
| mn1014 |
North American Title Count for LC, LCPER. Counts titles. INPUT: Selection criteria for title and item. OUTPUT: Tab-delimited files with the folowing fields: line number, subject area, NATC line number, call number range, number of titles SORT OPTIONS: none | Production |
| ne1014 |
North American Title Count for LC, LCPER. Counts titles. INPUT: title, call number, copy selections OUTPUT:tab-delimited file for spreadsheet which includes line number, subject area, NATC line number, call number range, number of titles | Production |
| sc1014 |
North American Title Count for LC, LCPER. Counts titles INPUT: title, call number, copy selections OUTPUT:tab-delimited file for spreadsheet which includes line number, subject area, NATC line number, call number range, number of titles | Production |
| sl1014 |
North American Title Count for LC, LCPER. Counts titles. INPUT: title, call number, copy selections OUTPUT:tab-delimited file for spreadsheet which includes line number, subject area, NATC line number, call number range, number of titles | Production |
| lu1015 |
North American Title Count for Dewey NOTE: This report converts Dewey to LC and outputs the number of titles in LC call number ranges. It is not a report which outputs the number of titles in Dewey call number ranges. INPUT: Selection criteria for title, call number and item. OUTPUT: Tab-delimited files with the folowing fields: line number, subject area, NATC line number, call number range, number of titles SORT OPTIONS: none | Production |
| sl1015 |
North American Title Count for Dewey NOTE: This report converts Dewey to LC and outputs the number of titles in LC call number ranges. It is not a report which outputs the number of titles in Dewey call number ranges. INPUT: Selection criteria for title, call number and item. OUTPUT: Tab-delimited files with the following fields: line number, subject area, NATC line number, call number range, number of titles SORT OPTIONS: none | Production |
| lw1016 |
North American Title Count Counts items within call number ranges (not titles) for LC, LCPER. The call number ranges used are the same ones in sl1014.pl. INPUT: title, call number, copy selections OUTPUT:tab-delimited file for spreadsheet which includes line number, subject area, NATC line number, call number range, number of items per call number range. | Production |
| ne1016 |
North American Title Count Counts items within call number ranges (not titles) for LC, LCPER. The call number ranges used are the same ones in ne1014.pl. INPUT: title, call number, copy selections OUTPUT:tab-delimited file for spreadsheet which includes line number, subject area, NATC line number, call number range, number of items per call number range. | Production |
| no1016 |
North American Title Count Counts items within call number ranges (not titles) for LC, LCPER. The call number ranges used are the same ones in sl1014.pl. INPUT: title, call number, copy selections OUTPUT:tab-delimited file for spreadsheet which includes line number, subject area, NATC line number, call number range, number of items per call number range. | Production |
| sc1016 |
North American Title Count Counts items within call number ranges (not titles) for LC, LCPER. The call number ranges used are the same ones in sc1014.pl. INPUT: title, call number, copy selections OUTPUT:tab-delimited file for spreadsheet which includes line number, subject area, NATC line number, call number range, number of items per call number range. | Production |
| sl1016 |
North American Title Count Counts items within call number ranges (not titles) for LC, LCPER. The call number ranges used are the same ones in sl1014.pl. INPUT: title, call number, copy selections OUTPUT:tab-delimited file for spreadsheet which includes line number, subject area, NATC line number, call number range, number of items per call number range. | Production |
| bp1017 |
North American Title Count for Dewey. Dedups catalog keys. This report counts only Dewey classification scheme. DELIVERED SCRIPT: none INPUT: Selection criteria for title and item. OUTPUT: Tab-delimited files with the folowing fields: subject area, Dewey call number range, number of titles SORT OPTIONS: none | Production |
| dl1017 |
North American Title Count for Dewey. Dedups catalog keys. This report counts only Dewey classification scheme. DELIVERED SCRIPT: none INPUT: Selection criteria for title and item. OUTPUT: Tab-delimited files with the folowing fields: subject area, Dewey call number range, number of titles SORT OPTIONS: none | Production |
| gu1017 |
North American Title Count for Dewey. Dedups catalog keys. This report counts only Dewey classification scheme. DELIVERED SCRIPT: none INPUT: Selection criteria for title and item. OUTPUT: Tab-delimited files with the folowing fields: subject area, Dewey call number range, number of titles SORT OPTIONS: none | Production |
| lu1017 |
North American Title Count for Dewey. Dedups catalog keys. This report counts only Dewey classification scheme. DELIVERED SCRIPT: none INPUT: Selection criteria for title and item. OUTPUT: Tab-delimited files with the folowing fields: subject area, Dewey call number range, number of titles SORT OPTIONS: none | Testing |
| ni1017 |
North American Title Count for Dewey. Dedups catalog keys. This report counts only Dewey classification scheme. DELIVERED SCRIPT: none INPUT: Selection criteria for title and item. OUTPUT: Tab-delimited files with the folowing fields: subject area, Dewey call number range, number of titles SORT OPTIONS: none | Production |
| sl1017 |
North American Title Count for Dewey. Dedups catalog keys. This report counts only Dewey classification scheme. DELIVERED SCRIPT: none INPUT: Selection criteria for title and item. OUTPUT: Tab-delimited files with the folowing fields: subject area, Dewey call number range, number of titles SORT OPTIONS: none | Production |
| br1018 |
This report is based on ne1016.pl, North American Title Count for LC, LCPER, which counts items. It also outputs the average years of publication and the number of charges per LC classification subclasses. INPUT: title, call number, copy selections OUTPUT:tab-delimited file for spreadsheet which includes line number, subject area, NATC line number, call number range, number of items, average years of publication, total number of charges | Production |
| mn1018 |
This report is based on ne1016.pl, North American Title Count for LC, LCPER, which counts items. It also outputs the average years of publication and the number of charges per LC classification subclasses. INPUT: title, call number, copy selections OUTPUT:tab-delimited file for spreadsheet which includes line number, subject area, NATC line number, call number range, number of items, average years of publication, total number of charges | Production |
| ne1018 |
This report is based on ne1016.pl, North American Title Count for LC, LCPER, which counts items. It also outputs the average years of publication and the number of charges per LC classification subclasses. INPUT: title, call number, copy selections OUTPUT:tab-delimited file for spreadsheet which includes line number, subject area, NATC line number, call number range, number of items, average years of publication, total number of charges | Production |
| ns3003 |
DELIVERED SCRIPT: None INPUT: catalog, callnumber, and item selection criteria OUTPUT: Holdings in Ingenta's specified fixed length record format. | Production |
| lu3008 |
Extracts serials holdings for RAPID. Enables selections for location. The user is responsible for transfering the output file to RAPID company. The selection criteria in this report narrows down selections to the title level only. If you want the holdings for a specific library and location the report takes the item library and location selection criteria and looks for these values in the 852 tag of holdings data. This is the only way to output holdings for a specific library and location. For example: 852|\bMIDL-MAIN\cSTACKS\hPS4637.43|866|\81\v.23-34. | TESTING |
| dl3012 |
Program is a copy of Titles Used/Unused (titleuselst) with the addition of call number as output and also as sorting option. Read the Help on titleuselst for a full description. INPUT: title, call number, copy, transaction OUTPUT: title, author, library, usage count within library, call number, and total usage count SORT OPTIONS: descending, ascending, title/author, call number | Production |
| lt3012 |
Program is a copy of Titles Used/Unused (titleuselst) with the addition of call number as output and also as sorting option. Read the Help on titleuselst for a full description. INPUT: title, call number, copy, transaction OUTPUT: title, author, library, usage count within library, call number, and total usage count SORT OPTIONS: descending, ascending, title/author, call number | Production |
| lu3012 |
Program is a copy of Titles Used/Unused (titleuselst) with the addition of call number as output and also as sorting option. Read the Help on titleuselst for a full description. INPUT: title, call number, copy, transaction OUTPUT: title, author, library, usage count within library, call number, and total usage count SORT OPTIONS: descending, ascending, title/author, call number | Production |
| mn3012 |
Program is a copy of Titles Used/Unused (titleuselst) with the addition of call number as output and also as sorting option. Read the Help on titleuselst for a full description. INPUT: title, call number, copy, transaction OUTPUT: title, author, library, usage count within library, call number, and total usage count SORT OPTIONS: descending, ascending, title/author, call number | Production |
| ne3012 |
Program is a copy of Titles Used/Unused (titleuselst) with the addition of call number as output and also as sorting option. Read the Help on titleuselst for a full description. DELIVERED SCRIPT: titleuselst INPUT: title, call number, copy, transaction OUTPUT: title, author, library, usage count within library, call number, and total usage count SORT OPTIONS: descending, ascending, title/author, call number | Production |
| no3012 |
Program is a copy of Titles Used/Unused (titleuselst) with the addition of call number as output and also as sorting option. Read the Help on titleuselst for a full description. DELIVERED SCRIPT: titleuselst INPUT: title, call number, copy, transaction OUTPUT: title, author, library, usage count within library, call number, and total usage count SORT OPTIONS: descending, ascending, title/author, call number | Production |
| sc3012 |
Program is a copy of Titles Used/Unused (titleuselst) with the addition of call number as output and also as sorting option. Read the Help on titleuselst for a full description. DELIVERED SCRIPT: titleuselst INPUT: title, call number, copy, transaction OUTPUT: title, author, library, usage count within library, call number, and total usage count SORT OPTIONS: descending, ascending, title/author, call number | Production |
| sl3012 |
Program is a copy of Titles Used/Unused (titleuselst) with the addition of call number as output and also as sorting option. Read the Help on titleuselst for a full description. INPUT: title, call number, copy, transaction OUTPUT: title, author, library, usage count within library, call number, and total usage count SORT OPTIONS: descending, ascending, title/author, call number | Production |
| ax3013 |
Program is a copy of List Bibliography (bibliography), but it outputs a tab-delimited file. DELIVERED SCRIPT: bibliograpy INPUT: title, call number, copy OUTPUT: item id, call number, author, title, flexkey, publication year, create date, item category 1, item category 2, home location, current location, permanent or temporary, item type, library SORT OPTIONS: author/title, title/author, call number | Production |
| ia3013 |
Program is a copy of List Bibliography (bibliography), but it outputs a tab-delimited file. DELIVERED SCRIPT: bibliograpy INPUT: title, call number, copy OUTPUT: item id, call number, author, title, flexkey, publication year, create date, item category 1, item category 2, home location, current location, permanent or temporary, item type, library SORT OPTIONS: author/title, title/author, call number | Production |
| lu3013 |
Program is a copy of List Bibliography (bibliography), but it outputs a tab-delimited file. INPUT: title, call number, copy OUTPUT: item id, call number, author, title, flexkey, publication year, create date, item category 1, item category 2, home location, current location, permanent or temporary, item type, library SORT OPTIONS: author/title, title/author, call number | Production |
| lw3013 |
Program is a copy of List Bibliography (bibliography), but it outputs a tab-delimited file. INPUT: title, call number, copy OUTPUT: item id, call number, author, title, flexkey, publication year, create date, item category 1, item category 2, home location, current location, permanent or temporary, item type, library SORT OPTIONS: author/title, title/author, call number | Production |
| ne3013 |
Program is a copy of List Bibliography (bibliography), but it outputs a tab-delimited file. DELIVERED SCRIPT: bibliograpy INPUT: title, call number, copy OUTPUT: item id, call number, author, title, flexkey, publication year, create date, item category 1, item category 2, home location, current location, permanent or temporary, item type, library SORT OPTIONS: author/title, title/author, call number | Production |
| br3014 |
This report is identical to lu3013.pl, but also include these fields: item create date, charges, inhouse charges, total charges, last use date. INPUT: title, call number, copy OUTPUT: item id, call number, shelving key, author, title, flexkey, publication year, create date, item category 1, item category 2, home location, current location, permanent or temporary, item type, library, item createdate, charges, inhousecharges, total charges, lastuseddate, extended info DELIVERED SCRIPT: List Bibliography (bibliography) SORT OPTIONS: author/title, title/author, call number | Production |
| lu3014 |
This report is identical to lu3013.pl, but also include these fields: item create date, charges, inhouse charges, total charges, last use date. INPUT: title, call number, copy OUTPUT: item id, call number, shelving key, author, title, flexkey, publication year, create date, item category 1, item category 2, home location, current location, permanent or temporary, item type, library, item createdate, charges, inhousecharges, total charges, lastuseddate, extended info DELIVERED SCRIPT: List Bibliography (bibliography) SORT OPTIONS: author/title, title/author, call number | Production |
| no3014 |
This report is identical to lu3013.pl, but also include these fields: item create date, charges, inhouse charges, total charges, last use date. INPUT: title, call number, copy OUTPUT: item id, call number, shelving key, author, title, flexkey, publication year, create date, item category 1, item category 2, home location, current location, permanent or temporary, item type, library, item createdate, charges, inhousecharges, total charges, lastuseddate, extended info DELIVERED SCRIPT: List Bibliography (bibliography) SORT OPTIONS: author/title, title/author, call number | Production |
| sc3014 |
This report is identical to lu3013.pl, but also include these fields: item create date, charges, inhouse charges, total charges, last use date. INPUT: title, call number, copy OUTPUT: item id, call number, shelving key, author, title, flexkey, publication year, create date, item category 1, item category 2, home location, current location, permanent or temporary, item type, library, item createdate, charges, inhousecharges, total charges, lastuseddate DELIVERED SCRIPT: List Bibliography (bibliography) SORT OPTIONS: author/title, title/author, call number | Production |
| sl3014 |
This report is identical to lu3013.pl, but also include these fields: item create date, charges, inhouse charges, total charges, last use date. INPUT: title, call number, copy OUTPUT: item id, call number, shelving key, author, title, flexkey, publication year, create date, item category 1, item category 2, home location, current location, permanent or temporary, item type, library, item createdate, charges, inhousecharges, total charges, lastuseddate, extended info DELIVERED SCRIPT: List Bibliography (bibliography) SORT OPTIONS: author/title, title/author, call number | Production |
| lz3015 |
This program will FTP MARC files from Ebsco on a monthly basis and copy them into each site's Marcimport directory. This runs for the sites who have their own A to Z with MARC subscription. The site will then load their A-Z MARC file into their catalog via the Sirsi bibload report. | Production |
| lu3017 |
This report is a copy of Sirsi delivered report List Items. It outputs a tab-delimited file. The first record in the file shows the fields and their order in the tab-delimited file. DELIVERED SCRIPT: List Items (itemlist) INPUT: call number, copy OUTPUT: flexkey, title, entry 001, entry 022, call number, itemid, library, item type, item category 1, item category 2, create date, charges, inhouse charges, total charges, last use date, home location, current location, extended information: CIRCNOTE,PUBLIC,STAFF,SUFFIX. SORT OPTIONS: title, flexkey | Production |
| sa3017 |
This report is a copy of Sirsi delivered report List Items. It outputs a tab-delimited file. The first record in the file shows the fields and their order in the tab-delimited file. DELIVERED SCRIPT: List Items (itemlist) INPUT: call number, copy OUTPUT: flexkey, title, entry 001, entry 022, call number, itemid, library, item type, item category 1, item category 2, create date, charges, inhouse charges, total charges, last use date, home location, current location, extended information: CIRCNOTE,PUBLIC,STAFF. SORT OPTIONS: title, flexkey | Production |
| lz3018 |
This program(aka ECAT) FTPs a MARC file from Ebsco on a monthly basis and copies it to each site's Marcimport directory to be loaded into the catalogs via the Sirsi bibload report. Processing has been added for some sites prior to the load in order to remove bib records that contain an 856 field for specified resources for which they do not have access This runs for the sites who do not have their own A to Z with MARC subscription. | Production |
| lw3019 |
This report outputs a tab-delimited file with bib data and subject headings (subject headings are from 6xx entry ids). Note: if a record has more than one 6xx entry id, only the first 2 6xx entry ids are displayed in the output. The first record in the file shows the fields and their order in the tab-delimited file: Subjects, Author, Title, Call Number, Location DELIVERED SCRIPT: List Bibliography (bibliography.pl) INPUT: title, call number, item OUTPUT:tab-delimited file with subject, author, title, call number and home location | Production |
| ne3019 |
This report outputs a tab-delimited file with bib data and subject headings (subject headings are from 6xx entry ids). Note: if a record has more than one 6xx entry id, only the first 2 6xx entry ids are displayed in the output. The first record in the file shows the fields and their order in the tab-delimited file: Subjects, Author, Title, Call Number, Location DELIVERED SCRIPT: List Bibliography (bibliography.pl) INPUT: title, call number, item OUTPUT:tab-delimited file with subject, author, title, call number and home location | Training |
| bp3020 |
Extracts serials holdings information. DELIVERED SCRIPT: none INPUT: item, serial control OUTPUT: ISSN, Title, Call number, Holdings, 852 Entry id SORT OPTIONS: none | Production |
| lu3021 |
This report outputs a tab-delimited file with bib data with the following entry ids: flexkey, all 856 entry ids. The first record in the file shows the fields and their order in the tab-delimited file: Flexkey, 856 Entries. This report is based on the delivered report catlist. Review records are excluded from output. DELIVERED CODE: catlist.pl INPUT: catalog OUTPUT: flexkey, 856 entries SORT OPTIONS: flexkey, 856 entry | Production |
| lu3032 |
This report is based on Sirsi delivered report List Bibliography (bibliography.pl). It outputs a tab-delimited file with the following fields: flexkey, title, 856 entres. INPUT: title,copy,callnum OUTPUT: flexkey, title, 856 entries SORT OPTIONS: flexkey, title, 856 entries | Production |
| br3035 |
Extracts ISSN & title and outputs a tab-delimited report that can be saved into a file and sent to a vendor. Unique ISSNs will be output. Titles with no ISSN will be excluded. View or print the finished report in WorkFlows with Excel. Check off "View Result", but uncheck "Format Report" and "View Log". INPUT: Selection criteria includes title and copy. OUTPUT: Tab-delimited report with ISSN and title. | Production |
| lt3035 |
Extracts ISSN & title and outputs a tab-delimited report that can be saved into a file and sent to a vendor. Unique ISSNs will be output. Titles with no ISSN will be excluded. View or print the finished report in WorkFlows with Excel. Check off "View Result", but uncheck "Format Report" and "View Log". INPUT: Selection criteria includes title and copy. OUTPUT: Tab-delimited report with ISSN and title. | Production |
| ne3035 |
Extracts ISSN & title and outputs a tab-delimited report that can be saved into a file and sent to a vendor. Unique ISSNs will be output. Titles with no ISSN will be excluded. View or print the finished report in WorkFlows with Excel. Check off "View Result", but uncheck "Format Report" and "View Log". INPUT: Selection criteria includes title and copy. OUTPUT: Tab-delimited report with ISSN and title. | Production |
| ns3035 |
Extracts ISSN & title and outputs a tab-delimited report that can be saved into a file and sent to a vendor. Unique ISSNs will be output. Titles with no ISSN will be excluded. View or print the finished report in WorkFlows with Excel. Check off "View Result", but uncheck "Format Report" and "View Log". INPUT: Selection criteria includes title and copy. OUTPUT: Tab-delimited report with ISSN and title. | Production |
| bp3037 |
This report is based on the delivered report: Edit Item Types by Call Number. This report will allow the selection criteria of title, call number, and copy to be used to change the item type of copy records. Rebuildtext must be run after this report in order to pick up the changes to items. bp3037.pl is password protected. DELIVERED SCRIPT: calledititype INPUT: title, call number, copy, value modification of item type OUTPUT: tab-delimited file with itemid, original item type | Production |
| dl3037 |
This report is based on the delivered report: Edit Item Types by Call Number. This report will allow the selection criteria of title, call number, and copy to be used to change the item type of copy records. Rebuildtext must be run after this report in order to pick up the changes to items. lt3037.pl is password protected. DELIVERED SCRIPT: calledititype INPUT: title, call number, copy, value modification of item type OUTPUT: tab-delimited file with itemid, original item type | Production |
| lt3037 |
This report is based on the delivered report: Edit Item Types by Call Number. This report will allow the selection criteria of title, call number, and copy to be used to change the item type of copy records. Rebuildtext must be run after this report in order to pick up the changes to items. lt3037.pl is password protected. DELIVERED SCRIPT: calledititype INPUT: title, call number, copy, value modification of item type OUTPUT: tab-delimited file with itemid, original item type | Production |
| mn3037 |
This report is based on the delivered report: Edit Item Types by Call Number. This report will allow the selection criteria of title, call number, and copy to be used to change the item type of copy records. Rebuildtext must be run after this report in order to pick up the changes to items. mn3037.pl is password protected. DELIVERED SCRIPT: calledititype INPUT: title, call number, copy, value modification of item type OUTPUT: tab-delimited file with itemid, original item type | Production |
| ax3038 |
Program is a copy of List Bibliography (bibliography), but it outputs a tab-delimited file. DELIVERED SCRIPT: bibliograpy INPUT: title, call number, copy OUTPUT: item id; call number; author; title; flexkey; entry ids 050, 082, first 650, first 856, 260 (pupblisher); publication year; create date; item category 1; item category 2; home location; current location; permanent or temporary; item type; library SORT OPTIONS: none | Production |
| bp3038 |
Program is a copy of List Bibliography (bibliography), but it outputs a tab-delimited file. DELIVERED SCRIPT: bibliograpy INPUT: title, call number, copy OUTPUT: item id; call number; author; title; flexkey; entry ids 050, 082, first 650, first 856, 260 (pupblisher); publication year; create date; item category 1; item category 2; home location; current location; permanent or temporary; item type; library SORT OPTIONS: none | Production |
| ne3038 |
Program is a copy of List Bibliography (bibliography), but it outputs a tab-delimited file. DELIVERED SCRIPT: bibliograpy INPUT: title, call number, copy OUTPUT: item id; call number; author; title; flexkey; entry ids 050, 082, first 650, first 856, 260 (pupblisher); publication year; create date; item category 1; item category 2; home location; current location; permanent or temporary; item type; library SORT OPTIONS: none | Production |
| no3038 |
Program is a copy of List Bibliography (bibliography), but it outputs a tab-delimited file. DELIVERED SCRIPT: bibliograpy INPUT: title, call number, copy OUTPUT: item id; call number; author; title; flexkey; entry ids 050, 082, first 650, first 856, 260 (pupblisher); publication year; create date; item category 1; item category 2; home location; current location; permanent or temporary; item type; library SORT OPTIONS: none | Production |
| sh3038 |
Program is a copy of List Bibliography (bibliography), but it outputs a tab-delimited file. DELIVERED SCRIPT: bibliograpy INPUT: title, call number, copy OUTPUT: item id; call number; author; title; flexkey; entry ids 050, 082, first 650, first 856, 260 (pupblisher); publication year; create date; item category 1; item category 2; home location; current location; permanent or temporary; item type; library SORT OPTIONS: none | Production |
| lu3039 |
This report is a copy of titleuselst (Titles Used/Unused). This report takes a while to run even if compare database is NO. DELIVERED SCRIPT: titleuselst.pl INPUT: title, call number, copy, transaction OUTPUT: tab-delimited file with title, author, library, flexkey, tag 022, usage count within library, call number, and total usage count SORT OPTIONS: None | Production |
| mn3039 |
This report is a copy of titleuselst (Titles Used/Unused). This report takes a while to run even if compare database is NO. DELIVERED SCRIPT: titleuselst.pl INPUT: title, call number, copy, transaction OUTPUT: tab-delimited file with title, author, library, flexkey, tag 022, usage count within library, call number, and total usage count SORT OPTIONS: None | Production |
| ne3039 |
This report is a copy of titleuselst (Titles Used/Unused). This report takes a while to run even if compare database is NO. DELIVERED SCRIPT: titleuselst.pl INPUT: title, call number, copy, transaction OUTPUT: tab-delimited file with title, author, library, flexkey, tag 022, usage count within library, call number, and total usage count SORT OPTIONS: None | Production |
| no3039 |
This report is a copy of titleuselst (Titles Used/Unused). This report takes a while to run even if compare database is NO. DELIVERED SCRIPT: titleuselst.pl INPUT: title, call number, copy, transaction OUTPUT: tab-delimited file with title, author, library, flexkey, tag 022, usage count within library, call number, and total usage count SORT OPTIONS: None | Production |
| sc3039 |
This report is a copy of titleuselst (Titles Used/Unused). This report takes a while to run even if compare database is NO. DELIVERED SCRIPT: titleuselst.pl INPUT: title, call number, copy, transaction OUTPUT: tab-delimited file with title, author, library, flexkey, tag 022, usage count within library, call number, and total usage count SORT OPTIONS: None | Production |
| sl3039 |
This report is a copy of titleuselst (Titles Used/Unused). This report takes a while to run even if compare database is NO. DELIVERED SCRIPT: titleuselst.pl INPUT: title, call number, copy, transaction OUTPUT: tab-delimited file with title, author, library, flexkey, tag 022, usage count within library, call number, and total usage count SORT OPTIONS: None | Production |
| ax3042 |
This report edits items globally. It has a search box which uses the keyword index. It also has an update database buttom which allows the report to run with or without updating the database. INPUT: catalog, call number, item OUTPUT: updates Item Type, Home Location, Item Category 1, Item Category 2, or copy shadowing for all items matching the title, call number, or copy search selections. Editing is done via API transactions, so changed items are reindexed almost immediately. SORT OPTIONS: title/author,call number, item id | Training |
| br3042 |
This report edits items globally. It has a search box which uses the keyword index. INPUT: catalog, call number, item OUTPUT: updates Item Type, Home Location, Item Category 1, Item Category 2, or copy shadowing for all items matching the title, call number, or copy search selections. Editing is done via API transactions, so changed items are reindexed almost immediately. SORT OPTIONS: title/author,call number, item id | Production |
| gu3042 |
This report edits items globally. It has a search box which uses the keyword index. INPUT: catalog, call number, item OUTPUT: updates Item Type, Home Location, Item Category 1, Item Category 2, or copy shadowing for all items matching the title, call number, or copy search selections. Editing is done via API transactions, so changed items are reindexed almost immediately. SORT OPTIONS: title/author,call number, item id | Production |
| lt3042 |
This report edits items globally. It has a search box which uses the keyword index. It also has an update database buttom which allows the report to run with or without updating the database. INPUT: catalog, call number, item OUTPUT: updates Item Type, Home Location, Item Category 1, Item Category 2, or copy shadowing for all items matching the title, call number, or copy search selections. Editing is done via API transactions, so changed items are reindexed almost immediately. SORT OPTIONS: title/author,call number, item id | Production |
| lu3042 |
This report edits items globally. It has a search box which uses the keyword index. INPUT: catalog, call number, item OUTPUT: updates Item Type, Home Location, Item Category 1, Item Category 2, or copy shadowing for all items matching the title, call number, or copy search selections. Editing is done via API transactions, so changed items are reindexed almost immediately. SORT OPTIONS: title/author,call number, item id | Production |
| ne3042 |
This report edits items globally. It has a search box which uses the keyword index. INPUT: catalog, call number, item OUTPUT: updates Item Type, Home Location, Item Category 1, Item Category 2, or copy shadowing for all items matching the title, call number, or copy search selections. Editing is done via API transactions, so changed items are reindexed almost immediately. SORT OPTIONS: title/author,call number, item id | Production |
| no3042 |
This report edits items globally. It has a search box which uses the keyword index. INPUT: catalog, call number, item OUTPUT: updates Item Type, Home Location, Item Category 1, Item Category 2, or copy shadowing for all items matching the title, call number, or copy search selections. Editing is done via API transactions, so changed items are reindexed almost immediately. SORT OPTIONS: title/author,call number, item id | Production |
| sl3042 |
This report edits items globally. It has a search box which uses the keyword index. INPUT: catalog, call number, item OUTPUT: updates Item Type, Home Location, Item Category 1, Item Category 2, or copy shadowing for all items matching the title, call number, or copy search selections. Editing is done via API transactions, so changed items are reindexed almost immediately. SORT OPTIONS: title/author,call number, item id | Production |
| sn3042 |
This report edits items globally. It has a search box which uses the keyword index. INPUT: catalog, call number, item OUTPUT: updates Item Type, Home Location, Item Category 1, Item Category 2, or copy shadowing for all items matching the title, call number, or copy search selections. Editing is done via API transactions, so changed items are reindexed almost immediately. SORT OPTIONS: title/author,call number, item id | Production |
| vw3042 |
This report edits items globally. It has a search box which uses the keyword index. INPUT: catalog, call number, item OUTPUT: updates Item Type, Home Location, Item Category 1, Item Category 2, or copy shadowing for all items matching the title, call number, or copy search selections. Editing is done via API transactions, so changed items are reindexed almost immediately. SORT OPTIONS: title/author,call number, item id | Production |
| sl3043 |
This report outputs a tab-delimited file. It is a copy of the Sirsi delivered report bibliography. The first record in the file shows the fields and their order in the tab-delimited file. INPUT: title, call number, copy OUTPUT: tab delimited output SORT OPTIONS: none | Production |
| lu3046 |
Extracts keys for exporting marc records. DELIVERED CODE: derived in part from prepmarcexp.pl and bibliography.pl INPUT: Identical to prepmarcexp except the field in which to enter item ids is replaced with a field to enter a search string. Added selection criteria: copy selection, callnum selection, title selection. If you want to enter item ids you must use the delivered report. OUTPUT: keys for export utility in the Xfer directory SORT OPTIONS: none | Production |
| lw3046 |
Extracts keys for exporting marc records. DELIVERED CODE: derived in part from prepmarcexp.pl and bibliography.pl INPUT: Identical to prepmarcexp except the field in which to enter item ids is replaced with a field to enter a search string. Added selection criteria: copy selection, callnum selection, title selection. If you want to enter item ids you must use the delivered report. OUTPUT: keys for export utility in the Xfer directory SORT OPTIONS: none | Production |
| gu3048 |
This report allows the circ flag on items to be edited globally. It has a search box which uses the keyword index. It also has an update database buttom which allows the report to run with or without updating the database. INPUT: catalog, call number, item OUTPUT: updates the circulate flag for all items matching the title, call number, or copy search selections. Items that are checked out will be skipped. Editing is done via API transactions, so changed items are reindexed almost immediately. SORT OPTIONS: title/author,call number, item id | Production |
| lu3048 |
This report allows the circ flag on items to be edited globally. It has a search box which uses the keyword index. It also has an update database buttom which allows the report to run with or without updating the database. INPUT: catalog, call number, item OUTPUT: updates the circulate flag for all items matching the title, call number, or copy search selections. Items that are checked out will be skipped. Editing is done via API transactions, so changed items are reindexed almost immediately. SORT OPTIONS: title/author,call number, item id | Production |
| ne3048 |
This report allows the circ flag on items to be edited globally. It has a search box which uses the keyword index. It also has an update database buttom which allows the report to run with or without updating the database. INPUT: catalog, call number, item OUTPUT: updates the circulate flag for all items matching the title, call number, or copy search selections. Items that are checked out will be skipped. Editing is done via API transactions, so changed items are reindexed almost immediately. SORT OPTIONS: title/author,call number, item id | Production |
| sl3048 |
This report allows the circ flag on items to be edited globally. It has a search box which uses the keyword index. It also has an update database buttom which allows the report to run with or without updating the database. INPUT: catalog, call number, item OUTPUT: updates the circulate flag for all items matching the title, call number, or copy search selections. Items that are checked out will be skipped. Editing is done via API transactions, so changed items are reindexed almost immediately. SORT OPTIONS: title/author,call number, item id | Production |
| sc3050 |
Program is a copy of List Bibliography (bibliography), but it outputs a tab-delimited file. DELIVERED SCRIPT: bibliograpy INPUT: title, call number, copy OUTPUT: Outputs 3 different reports with these fields: call number, author, title, number of call numbers, number of copies, price Report 1: List of Titles and Call Numbers with No Copies Report 2: List of Titles with One Call Number and One or More Copies Report 3: List of Titles with Multiple Call Numbers Each with One or More Copies | Production |
| lw3053 |
This report looks at titles that have a 599 entry. It outputs the title, title control number, the data in the 599 and the data in the 362 if the 362 entry exists. The 599 is a local field. DELIVERED SCRIPT: List Entries (entrylist.pl) INPUT: title OUTPUT:tab-delimited file with title control number, title, data in 599, data in 362. If no 362 is in bib record, the field is blank. | Production |
| dl3054 |
This report looks at titles that have a 999 entry. It outputs the title and the data in the 999. DELIVERED SCRIPT: none INPUT: call number, title OUTPUT:tab-delimited file with title (245) and data in 999. If no 999 is in bib record, the record is not output. | Production |
| lm3055 |
This report looks at titles that have a 556 entry. It outputs the title, and the data in the 556 DELIVERED SCRIPT: List Entries (entrylist.pl) INPUT: title OUTPUT:tab-delimited file with title, data in 556. | Production |
| le3060 |
Originated from catitemlist.pl from Michael Ridinger from INFOhio. Produce a shelflist in one of three formats: Brief, Long and Spreadsheet. This report can take quite a while to run depending on your selections. | Production. |
| lt3060 |
Originated from catitemlist.pl from Michael Ridinger from INFOhio. Produce a shelflist in one of three formats: Brief, Long and Spreadsheet. This report can take quite a while to run depending on your selections. | Production. |
| lw3060 |
Originated from catitemlist.pl from Michael Ridinger from INFOhio. Produce a shelflist in one of three formats: Brief, Long and Spreadsheet. This report can take quite a while to run depending on your selections. | Production. |
| mn3060 |
Originated from catitemlist.pl from Michael Ridinger from INFOhio. Produce a shelflist in one of three formats: Brief, Long and Spreadsheet. This report can take quite a while to run depending on your selections. | Production. |
| ns3060 |
Originated from catitemlist.pl from Michael Ridinger from INFOhio. Produce a shelflist in one of three formats: Brief, Long and Spreadsheet. This report can take quite a while to run depending on your selections. | Production. |
| sa3060 |
Originated from catitemlist.pl from Michael Ridinger from INFOhio. Produce a shelflist in one of three formats: Brief, Long and Spreadsheet. This report can take quite a while to run depending on your selections. | Production. |
| sc3060 |
Originated from catitemlist.pl from Michael Ridinger from INFOhio. Produce a shelflist in one of three formats: Brief, Long and Spreadsheet. This report can take quite a while to run depending on your selections. | Production. |
| ns3062 |
INPUT: text from search string gadget, title, call number, item info OUTPUT: This report will change the Current Location Status of MISSING copies to DISCARD for selected records. | Production |
| br3064 |
Selection Criteria: catalog, callnumbers, items. Outputs a pipe delimited file: shelving key | title | price of item. The price is pulled from the item record, not any aquisitions record. | Test/training |
| lu3065 |
This report is a duplicate of additemlist.pl which is for the New Books List which appears in iLink. This script has the addition of call number selection. DELIVERED SCRIPT: additemlist.pl INPUT: selorder, selcatalog, selitem, selcallnum OUTPUT: same as delivered script SORT OPTIONS: None. | Production |
| lt3070 |
Originated from globaledit.pl, this report also includes call number and item selection criteria. DELIVERED SCRIPT: globaledit.pl INPUT: Selection criteria includes title, call number and copy. OUTPUT: Same output as delivered globaledit. SORT OPTIONS: none | Production |
| sl3071 |
in progress | Production |
| ns3072 |
This report is a copy of titleuselst (Titles Used/Unused). This report takes a while to run even if compare database is NO. DELIVERED SCRIPT: titleuselst.pl INPUT: title, call number, copy, transaction OUTPUT: tab-delimited file with title, author, publication year, library, flexkey, tag 022, usage count within library, call number, and total usage count SORT OPTIONS: None | Production |
| ns3073 |
This report is a copy of List Titles. DELIVERED SCRIPT: catlist.pl INPUT: title OUTPUT: a text file with title from subfields a and b only SORT OPTIONS: None | Production |
| lm3074 |
This report outputs a tab-delimited file with bib data and subject headings from 653 and 650 entry ids and where the 650 entries have non-zero indicators. 653 entry ids are output regardless of indicator values. The first record in the file shows the fields and their order in the tab-delimited file: Subjects, Title DELIVERED SCRIPT: none INPUT: title, call number, item OUTPUT:tab-delimited file with title, entry id, and subject | Production |
| ns3075 |
This report is a copy of List Titles. DELIVERED SCRIPT: catlist.pl INPUT: title OUTPUT: a text file with title from subfields a, b, n, p only SORT OPTIONS: None | Production |
| ax3076 |
Program is a copy of List Bibliography (bibliography), but it outputs a tab-delimited file. DELIVERED SCRIPT: bibliograpy INPUT: title, call number, copy OUTPUT: item id; call number; author; title; flexkey; entry ids 050, 082, first 650, first 856, 260 (publisher); publication year; create date; item category 1; item category 2; home location; current location; permanent or temporary; item type; library; is item checked out; in-house charges; total charges; last used date SORT OPTIONS: none | Production |
| bp3077 |
IMPORTANT! This report will remove all 863 fields when update option is selected. This custom report allows you to enter a flexkey and a year in the search tab. The year is found in subfield i of the 863. This report will remove 863's in batch. In the search field make sure the flexkey and year are entered in this format: flexkey=year, example: i0747-4733=2005. DELIVERED SCRIPT: none INPUT: Selection criteria includes search tab, catalog, and an update option. OUTPUT: Tab formatted list of titles and 863's. SORT OPTIONS: none | Production |
| lu3078 |
Based on Sirsi delivered report: marcholdexp. INPUT: Selection criteria includes search string (required), marc holdings, item, call number, title, serial control. OUTPUT: A file. SORT OPTIONS: none | Test |
| bp3079 |
Program is a copy of List Bibliography (bibliography), but it outputs a tab-delimited file. INPUT: title, call number, copy OUTPUT: title, author, publication year, call number SORT OPTIONS: author/title, title/author, call number | Production |
| mn3081 |
This report outputs a list of ISBN's. McNeese will send the list to the vendor ParaText Reference who will attach their holding to searches. The list will be put in Xfer. DELIVERED SCRIPT: none INPUT: Selection criteria includes catalog, call number, item. OUTPUT: list of ISBN's. | Production |
| lw3082 |
Program is a copy of List Bibliography (bibliography), but it outputs a tab-delimited file. INPUT: title, call number, copy OUTPUT: item id, shelving key, call number, author, title, flexkey, publication year, create date, item category 1, item category 2, home location, current location, permanent or temporary, item type, library, pieces, 035 SORT OPTIONS: none | Production |
| sl4000 |
The "Set Inventory Date" was customized by Christopher Sterback at Rutgers to be able to select on call number and title. This report can be used to set inventory date based on call number range. DELIVERED SCRIPT: initinv.pl INPUT: title, call number, item OUTPUT: same output as the delivered report SORT OPTIONS: none | Production |
| lu5002 |
Creates a listing of all MARC holdings records based on selection criteria. | Production |
| lu5006 |
Analyzes all index policy settings INPUT: Policies file, OUTPUT: Output is simply a tab-delimited text file in the form of formatname|indextype (KIND or BIND)|indexname|fieldname|field description|subfields SORT OPTIONS: None | Production |
| sc5024 |
This program creates a tab-delimited file of items. The tab-delimited report contains the price found in the item record. DELIVERED SCRIPT: bibliograpy INPUT: item, catalog, call number OUTPUT: current location, itemtype, library, pubyear, Dewey call number, item price, Title | Production |
| sn5024 |
This program creates a tab-delimited file of items. The tab-delimited report contains the price found in the item record. DELIVERED SCRIPT: bibliograpy INPUT: item, catalog, call number OUTPUT: current location, itemtype, library, pubyear, Dewey call number, item price, Title | Production |
| ns7016 |
This report is a copy of avgpubyrbyityp.pl (Avg Pub Yr By Item Type). There are 4 reports that output average publication year. One each for call number, location, item type, and item category 1. This report combines the selection criteria for all four. The output is the same as the delivered report. DELIVERED SCRIPT: avgpubyrbyityp.pl INPUT: Call number, Item OUTPUT : Same as delivered script: Number of titles read, Non-Zero Pub Years Selected, Average Pub Year, Most Recent, Oldest | Training |
| sh7017 |
This report is a copy of "Step 3b) Inventory Date NEVER" (invnever.pl) and is found under the "My Inventory" tab of reports. The original report has this warning which should be observered when running this report: "Be sure that you have scanned all barcodes and uploaded your complete collection to the central Server before running this report. Also, the System Administrator must perform Steps ! and 2, before you run this report." DELIVERED SCRIPT: invnever.pl INPUT: item OUTPUT: tab-delimited file with call number, title, item id SORT OPTIONS: None | Production |
| bp8001 |
This report is a copy of Item Statistics (itemstat), but, whereas itemstat provides statistics for all items, this report provides statistics for only the first item which represents a title. Output remains the Sirsi delivered report. INPUT: title, call number, copy OUTPUT: the Sirsi delivered report for itemstat SORT OPTIONS: none | Production |
| dl8001 |
This report is a copy of Item Statistics (itemstat), but, whereas itemstat provides statistics for all items, this report provides statistics for only the first item which represents a title. Output remains the Sirsi delivered report. INPUT: title, call number, copy OUTPUT: the Sirsi delivered report for itemstat SORT OPTIONS: none | Production |
| lw8001 |
This report is a copy of Item Statistics (itemstat), but, whereas itemstat provides statistics for all items, this report provides statistics for only the first item which represents a title. Output remains the Sirsi delivered report. INPUT: title, call number, copy OUTPUT: the Sirsi delivered report for itemstat SORT OPTIONS: none | Production |
| sl8001 |
This report is a copy of Item Statistics (itemstat), but, whereas itemstat provides statistics for all items, this report provides statistics for only the first item which represents a title. Output remains the Sirsi delivered report. INPUT: title, call number, copy OUTPUT: the Sirsi delivered report for itemstat SORT OPTIONS: none | Production |
| ne9991 |
This report lists invalid, mis-entered, and mis-scanned item ids as described by ULM. INPUT: Selection criteria is title call number, and item. OUTPUT: tab-delimited file with item id, date item created, call number, title. DELIVERED SCRIPT: none SORT OPTIONS: none | Production |
| Source Name |
Brief Description |
STATUS |
|---|---|---|
| sl3006 |
INPUT: No Selection criteria. OUTPUT:(Format of the report: fixed length fields. Fields:charge date|user id|user name|title|item id|charge code|bill| SORT OPTIONS: None. | Production |
| lu3009 |
Extracts user for bills and zeros out bills in batch. INPUT:(Selection criteria. Bill,User,Copy etc.) OUTPUT:(Format of the report: Pipe Delimited Fields. User id, item type and bill reason. SORT OPTIONS: None. | Production |
| ns3009 |
Extracts user for bills and zeros out bills in batch. INPUT:(Selection criteria. Bill,User,Copy etc.) OUTPUT:(Format of the report: Pipe Delimited Fields. User id, item type and bill reason. SORT OPTIONS: None. | Production |
| lu3010 |
Extracts user for bills and zeros out bills in batch. INPUT:(Selection criteria. Bill,User,Copy etc.) OUTPUT:(Format of the report: Pipe Delimited Fields. User id, item type and bill reason. SORT OPTIONS: None. | Production |
| br3011 |
Prints out one or all user bills. INPUT:(Selection criteria. Bill,User,Copy etc.) OUTPUT:(item id, library, due date, date billed, bill reason, amount, user id, username address, zipcode, title, author.) SORT OPTIONS: User id,User name and Zipcode. | Production |
| dl3011 |
Prints out one or all user bills. INPUT:(Selection criteria. Bill,User,Copy etc.) OUTPUT:(item id, library, due date, date billed, bill reason, amount, user id, username address, zipcode, title, author.) SORT OPTIONS: User id,User name and Zipcode. | Production |
| le3011 |
Prints out one or all user bills. INPUT: Bill, User, Copy, etc. OUTPUT: Item id, library, due date, date billed, bill reason, amount, user id, username, address, zipcode, title, author SORT OPTIONS: User ID, User name and Zipcode | Production |
| ne3011 |
Prints out one or all user bills. INPUT:(Selection criteria. Bill,User,Copy etc.) OUTPUT:(item id, library, due date, date billed, bill reason, amount, user id, username address, zipcode, title, author.) SORT OPTIONS: User id,User name and Zipcode. | Production |
| ni3011 |
Prints out one or all user bills. INPUT:(Selection criteria. Bill,User,Copy etc.) OUTPUT:(item id, library, due date, date billed, bill reason, amount, user id, username address, zipcode, title, author.) SORT OPTIONS: User id,User name and Zipcode. | Production |
| rp3011 |
Prints out one or all user bills. INPUT:(Selection criteria. Bill,User,Copy etc.) OUTPUT:(item id, library, due date, date billed, bill reason, amount, user id, username address, zipcode, title, author.) SORT OPTIONS: User id,User name and Zipcode. | Production |
| ne3027 |
Extracts circulation data for auditors into tab-delimited file. Extracts current bills and charges. Report is loosely modelled after "List Users with Bills, Charges" (billchargeuser). INPUT: Bill Selection, Charge Selection, and User Selection. OUTPUT: Name, Userid, Altid, Profile, Bill or Charge, Date, Balance, Billed by, Reason or Location, Call number, Title, Author SORT OPTIONS: none. | Production |
| le3029 |
This report is a custom report of cash report per station. INPUT: Transaction in history file.(Selection Criteria: Transaction Selection-->Station,Transaction data range,Command. Bill Selection-->Payment Type) OUTPUT:Format of the report. patron's name, ID, alt ID, time of transaction, payment type, amount, associated item ID and station. SORT OPTIONS: by station. | Production |
| ne3029 |
This report is a custom report of cash report per station. INPUT: Transaction in history file.(Selection Criteria: Transaction Selection-->Station,Transaction data range,Command. Bill Selection-->Payment Type) OUTPUT:Format of the report. patron's name, ID, alt ID, time of transaction, payment type, amount, associated item ID and station. SORT OPTIONS: by station. | Production |
| bp3034 |
This report is a copy of List Users with Bills,Charges(billusercharge) with the addition of item selection. INPUT: bill, charge, user, item OUTPUT: 2 files: Users with Bills (user name, user id, sum of bill amts), Users with Overdues (user name, user id). SORT OPTIONS: none | Production |
| ia3034 |
This report is a copy of List Users with Bills,Charges(billusercharge) with the addition of item selection. INPUT: bill, charge, user, item OUTPUT: 2 files: Users with Bills (user name, user id, sum of bill amts), Users with Overdues (user name, user id). SORT OPTIONS: none | Production |
| sh3036 |
Derived from List users with charges. INPUT:(Selection criteria: Copy,User,Charge,call number,Title, User Status) OUTPUT:(Format of the report: Pipe Delimited Fields. User ID, User Name, Total number of charges. SORT OPTIONS: User ID, User name. | Training |
| ia3045 |
INPUT: Selection Criteria: User id, Charges, Copy, Call number, Title. OUTPUT: This report outputs in columes: user_name, user id, shelving key call number, spine label call number, author, title. SORT OPTIONS: You can sort on User name or user id or author/title or call number (shelving key). | Production |
| le3045 |
INPUT: Selection Criteria: User id, Charges, Copy, Call number, Title. OUTPUT: This report outputs in columns: user_name, user id, shelving key call number, spine label call number, author, title. SORT OPTIONS: You can sort on User name or user id or author/title or call number (shelving key). | Production |
| lw3045 |
INPUT: Selection Criteria: User id, Charges, Copy, Call number, Title. OUTPUT: This report outputs in columes: user_name, user id, item id, shelving key call number, spine label call number, author, title. SORT OPTIONS: You can sort on User name or user id or author/title or call number (shelving key). | Production |
| ia3049 |
This report is a copy of List Users with Bills,Charges(billusercharge) with the addition of item selection. INPUT: bill, charge, user, item OUTPUT: 2 files: Users with Bills (user name, title, bill for that title), Users with Overdues (user name, title, charge date, due date). SORT OPTIONS: none | Production |
| lu3051 |
This report removes holds/recalls that are overdue. INPUT: charges, users, catalog, callnumber, item, holds selection criteria. OUTPUT: to be determined SORT OPTIONS: None. | Production |
| lu3052 |
This report sends users a notice that their holds have been cancelled. This report should follow xx3051.pl INPUT: selhold, seluser, selitem, seluserstatus OUTPUT: to be determined SORT OPTIONS: None. | Production |
| no3063 |
This report enables a user to change user pins. To change a user pin from "oldpin" to "newpin", enter the oldpin and the newpin seperated by an equal sign "="; for example, if the oldpin is FALL08TERM and the newpin is SPRING09TERM, in the "Search string" field you would enter FALL08TERM=SPRING09TERM. The equal sign is required. Illegal characters in the pins are: `~!@#$%^&.,*()_+:;"?><. The report will reject any of these entered into the "Search string" field. It is best to run the report with the "Update database" option UNchecked so that you can see the changes to the database that would be made if the "Update database" were checked off. Once you're happy with the would-be changes, check off the "Update database" and run the report again to actually apply the changes. You can only change one user pin at a time. You must run the report for each user pin change you want to make. CRITICAL: run this report on the test server before the production server. IMPORTANT: In addition to changing current (in the system) user pins, the default pin assigned to a user record when the user record is created or updated must be set in the /Unicorn/Autoids/pin<1> file. See LOUIS documentation on how to set this default pin "How to Change the System Default for Pins" (only LOUIS staff can make this change). | Test/training |
| Source Name |
Brief Description |
STATUS |
|---|---|---|
| LOUIS_utility |
Provides a library of functions for repetitious LOUIS specific tasks. | Production |
| ezproxylogin_louis |
Authenticates users against the user's appropriate Unicorn user file. | Production |
| ezproxylogin_louis_latech |
Authenticates users against the user's appropriate Unicorn user file. | Production |
| ezproxylogin_louis_lsu |
Authenticates users against the user's appropriate Unicorn user file. | Production |
| ezproxylogin_louis_lsus |
Authenticates users against the user's appropriate Unicorn user file. | Production |
| ezproxylogin_louis_msu |
Authenticates users against the user's appropriate Unicorn user file. | Production |
| ezproxylogin_louis_nsu |
Authenticates users against the user's appropriate Unicorn user file. | Production |
| ezproxylogin_louis_slu |
Authenticates users against the user's appropriate Unicorn user file. | Production |
| ezproxylogin_louis_subr |
Authenticates users against the user's appropriate Unicorn user file. | Production |
| ezproxylogin_louis_ulm |
Authenticates users against the user's appropriate Unicorn user file. | Production |
| lz0000 |
This program builds the webpage to display custom report written by the Louis Staff. Here is the link: http://utils.triaining.louislibraries.org/cgi-bin/lz0000.x INPUT: All html file in /home/Louis/public_html. OUTPUT: Name,descritpion,status and module of each custom report. SORT: sort by module. |
|
| lz0001 |
FTP Govdocs Weekly which runs every Monday INPUT:None OUTPUT:None SORT OPTIONS: None | Production |
| lz0002 |
FTP's monthly govdocs file from Marcive INPUT:None OUTPUT:None SORT OPTION: None | Production |
| lz0003 |
This program looks at the 856 field and does a check on the address. URLs that fail the testare reported to a mailbox corresponding to the library that owns the URLs. | Production |
| lz0004 |
Helps a LOUIS Analyst copy production site to training. | LOUIS Staff Only -- only in training |
| lz0005 |
Controls backups and rsyncs of critical file systems and directories from meg504 (prod) to meg503 (hotsite). | Production |
| lz0005_training |
Controls backups (not rsyncs) of critical file systems from training (on meg503 at LaTech) to TSM (at ISB). This is NOT the same backup script used on production (usually meg504). Because there is no mirroring on the training server, sites must remain down during the entire backup run. |
working on training instance |
| lz0007 |
This program switches nobody user to sirsi user so nobody user can excutate sirsi seltool in command line. INPUT: sirsi seltools. OUTPUT: Unicorn database records. SORT OPTIONS: None. | Production |
| lz0008 |
Create a report of all WorkFlows environment policies that have system logging turned on. | LOUIS staff only |
| lz0009 |
Helps a LOUIS Analyst copy Production site to Beta. | LOUIS Staff Only -- lives in Training (for podding purposes) but should only run in Beta |
| lz0010 |
Script to do auto_haltrun on one site or all sites. Script is located in /home/Louis/Utilities/Lz0010/ Script requires two of three possible arguments. Required arguments are arg_1 and arg_2. examples of arguments: arg_1: site code. Example: LALR or all(all must be lower case) arg_2: operation. Example: status, init, run, cycle, halt (operation must be lower case) arg_3: optional operation: force (operation must be lower case) force will kick out all logon users and close WFs sessions. To execute the script type on the command line: ./lz0010.pl arg_1 arg_2 or ./lz0010.pl arg_1 arg_2 arg_3 INPUT: NONE OUTPUT: NONE SORT OPTIONS: NONE. | LOUIS staff only |
| lz0011 |
Copy Workflows/Access/workflow.list to /Workflows/Access/ for sirsi, admin and louis user accesslist files. INPUT: NONE OUTPUT:NONE SORT OPTIONS: NONE. | LOUIS staff only |
| lz0012 |
This is a post upgrade process. This script copies the stamp file from LSUCES and puts it every other institutions /home/sirsi/LAig/Unicorn/Workflows directory. This prevents the question of updating the workflows client each time you try to logon. | LOUIS Staff Only |
| lz0013 |
Create backup copy of previous release upgrade files. Remove individual site directories and files under them. Create a new Files directory where the upgrade files will be placed. Create new individual site directories. | LOUIS staff only |
| lz0014 |
Copy upgrade files to each site's upgrade directory | LOUIS staff only |
| lz0015 |
This uses the Louis::subroutine module to return a list of site codes to either a shell script or another perl script. | LOUIS staff only |
| lz0016 |
This program reads the directory of podded custom reports and prints a listing sorted by number. It will help the LOUIS analyst in finding the next program number. | LOUIS staff only |
| lz0017 |
The process to remove loadbins|1|sh for all sites except LALR.The loadbins line that is being removed is the step that would install Unicorn binaries.We only need to install the binaries once. We do that in LALR only.The Upgrade directory will need to be changed with every upgrade in order to match the Unicorn release number given during the ``setup''. | LOUIS staff only |
| lz0018 |
This program has many steps to help the LOUIS staff recover from a power outage or an unexpected downtime on the Unicorn servers. | LOUIS Staff Only |
| lz0019 |
This script lists the steps that the input_queue will use | LOUIS Staff Only |
| lz0020 |
This script manages the web server apache. | LOUIS Staff Only |
| lz0021 |
This script copies the mserver file from /home/sirsi/Unicorn/Bin to every institutions /home/sirsi/LAig/Unicorn/Bincustom directory. This prevents the workstation server from coming up in a restore. | LOUIS Staff Only |
| lz0022 |
This program will search through each site's sirsi directory to find large files. Files containing text in the input file will not be written to the output file since these are files that have to remain, or they will be cleaned up with lz7004.pl. | LOUIS staff only |
| lz0023 |
Copies dev/null over ezproxy log and miscellaneous files to reduce size. The main problem is that ezproxy runs as user ezproxy and will automatically change the permission bits on ezproxy.hst file to something too restrictive for Bron's clean up program to dev/null itself. So this script does that. It runs as a cron job under the user ezproxy. You must su to ezproxy, then type crontab -l to see a list of cronjobs for user ezproxy. It runs everyday at 6:30 AM. If you want to change when it runs, type crontab -e; you will be brought into ezproxy user's crontable. |
Production |
| lz0024 |
Script to do auto_haltrun on all sites to find out which servers are halted. INPUT: NONE OUTPUT: NONE SORT OPTIONS: NONE. | LOUIS staff only |
| lz0025 |
NOTE: THIS SCRIPT MAY NOT HAVE TO BE USED WITH UPGRADE. WILL HAVE TO SEE AFTER TRAINING UPGRADE. This is a post-upgrade step used with upgrade to 2003.1.4.5. The process adds a /0 (slash zero) to the file /home/sirsi/$site/WWW/cgi-bin/webcat. | LOUIS Staff Only |
| lz0026 |
This process copies LALR's custom pages that display Unicorn policies to all other sites. | LOUIS Staff Only |
| lz0027 |
This program adds the comments about usage_logging and sets the USAGE_LOGGING variable to yes in each sites system.env. |
LOUIS staff only |
| lz0028 |
Copy the custom iLink pages directory /Elib_revC to production | LOUIS staff only |
| lz0029 |
Strips out the word training in rootbar.h after iLink custom pages have been copied over from training | LOUIS staff only |
| lz0031 |
This program sets .set file for ECAT Bibload to no for dynamic indexing. Changes load|25||YES| To load|25||NO| |
LOUIS staff only |
| lz0032 |
This program changes ownership of files & directories in /home/sirsi/sitecode/WWW/ |
LOUIS staff only |
| lz0033 |
This program will count the number of active iLink sessions and the number of WorkFlows logins. | LOUIS staff only |
| lz0034 |
Search each site's error log file in Unicorn/Logs for the current day for a FIFO queue in double-digits and busy messages greater than or equal to 70% of attempts. The output will be written to a file named with today's date. If both are true, the LOUIS staff will run this periodically. If it's happening over a period of time, the LOUIS staff should consider adding a new part program for the site. See LOUIS staff notes in doc database. | LOUIS staff only |
| lz0035 |
Copy LALR custom jar file to all other sites and increment stamp file. | LOUIS staff only |
| lz0036 |
This script functions in the same way as a sirsi 'tool'. It receives catkeys from standard in and outputs entry ids and marc holdngs. | Production |
| lz0037 |
This script parses Unicorn/Webcat/Logs/yyyymm.weblog files for use as input into lz7014.pl. INPUT: sitecode/Unicorn/Webcat/Logs/yyyymm.weblog OUTPUT: SORT OPTIONS: None | Production. |
| lz0038 |
Script to do auto_haltrun cycle force on all sites. INPUT: NONE OUTPUT: NONE SORT OPTIONS: NONE. | LOUIS staff only |
| lz0050 |
CGI script to be used in 856 URLs fields in order to capture statistics on specific 856 clicks. | Production |
| lz0051 |
CGI script to be used on iLink pages in order to capture statistics on 856 clicks. | Training |
| lz0052 |
This scipt will delete the custom pages in /home/sirsi/$site/Unicorn/Webcat/Pages_custom/Elib_revC then copy the custom iLink pages from /home/sirsi/Upgrades/GL3.2_Webcatcommon/$site to /home/sirsi/$site/Unicorn/Webcat/Pages_custom/Elib_revC |
LOUIS staff only |
| lz3004 |
Splits input shipping list file from Marcive into individual files for ig's Looks at the 049 tag in the marc record for holding codes for each ig and creates a record based on the holding code. INPUT: Marcive file of marc records OUTPUT: files of marc records - one for each govdocs site |
Production |
| lz3005 |
Splits input monthly file from Marcive into individual files for ig's Looks at the 049 tag in the marc record for holding codes for each ig and creates a record based on the holding code. INPUT: Marcive file of marc records OUTPUT: files of marc records - one for each govdocs site |
Production |
| bp3040 |
This program allows the patron to enter their ID and have their PIN emailed to the address they have in the user database. *** Located in /home/sirsi/site/WWW/cgi-bin/ instead of the /Rptcustom/Runs directory. | Production |
| br3040 |
This program allows the patron to enter their ID and have their PIN emailed to the address they have in the user database. *** Located in /home/sirsi/site/WWW/cgi-bin/ instead of the /Rptcustom/Runs directory. |
Production |
| dl3040 |
This program allows the patron to enter their ID and have their PIN emailed to the address they have in the user database. *** Located in /home/sirsi/site/WWW/cgi-bin/ instead of the /Rptcustom/Runs directory. |
Production |
| gu3040 |
This program allows the patron to enter their ID and have their PIN emailed to the address they have in the user database. *** Located in /home/sirsi/site/WWW/cgi-bin/ instead of the /Rptcustom/Runs directory. |
Production |
| le3040 |
This program allows the patron to enter their ID and have their PIN emailed to the address they have in the user database. *** Located in /home/sirsi/site/WWW/cgi-bin/ instead of the /Rptcustom/Runs directory. |
Production |
| lt3040 |
This program allows the patron to enter their ID and have their PIN emailed to the address they have in the user database. *** Located in /home/sirsi/site/WWW/cgi-bin/ instead of the /Rptcustom/Runs directory. |
Production |
| lu3040 |
This program allows the patron to enter their ID and have their PIN emailed to the address they have in the user database. *** Located in /home/sirsi/site/WWW/cgi-bin/ instead of the /Rptcustom/Runs directory. |
Production |
| lw3040 |
This program allows the patron to enter their ID and have their PIN emailed to the address they have in the user database. *** Located in /home/sirsi/site/WWW/cgi-bin/ instead of the /Rptcustom/Runs directory. |
Production |
| ni3040 |
This program allows the patron to enter their Alt ID and have their PIN emailed to the address they have in the user database. *** Located in /home/sirsi/site/WWW/cgi-bin/ instead of the /Rptcustom/Runs directory. |
Production |
| no3040 |
This program allows the patron to enter their ID and have their PIN emailed to the address they have in the user database. *** Located in /home/sirsi/site/WWW/cgi-bin/ instead of the /Rptcustom/Runs directory. |
Production |
| sh3040 |
This program allows the patron to enter their ID and have their PIN emailed to the address they have in the user database. *** Located in /home/sirsi/site/WWW/cgi-bin/ instead of the /Rptcustom/Runs directory. |
Production |
| lz7001 |
Deletes reports from finished reports that are older than ten days. | Production |
| lz7004 |
Cleans various directories and files to release space. | Production |
| lz7005 |
Compresses and copies previous month's data from WWW/logs/access_log to Xfer directories for all sites. INPUT: sitecode/WWW/logs/access_log OUTPUT: sitecode/Unicorn/Xfer/yyyymm.access.Z SORT OPTIONS: None | Production |
| lz7006 |
Compresses and copies previous year's data from WWW/logs/access_log WWW/logs/yyyy.access.Z and copy /dev/null to access_log for all sites. INPUT: sitecode/WWW/logs/access_log OUTPUT: sitecode/WWW/logs/yyyy.access.Z; sitecode/WWW/logs/access_log SORT OPTIONS: None |
LOUIS staff only |
| lz7007 |
Copies previous month's file from Unicorn/Logs/Stat to Xfer directories. INPUT: sitecode/Unicorn/Logs/Stat/yyyymm.stat.Z OUTPUT: sitecode/Unicorn/Xfer/yyyymm.stat.Z SORT OPTIONS: None | Production |
| lz7008 |
Lists all files under /home/sirsi/$site for the purpose of interrogating the growth of a file system. | Training |
| lz7009 |
This LOUIS utility gets executed by 3.pg in each site's Elib_policy directory. It builds the *.pg policy pages for each site. The policy pages are viewed on the web via the site's webify url. 3.pg passes the sitecode to this script. If you run this script on the command line you need to uncomment the part that loops through all sites. See notes in the script. | LOUIS Staff Only |
| lz7010 |
lz7005 was used as the basis of this report. For each site, consolidates daily weblog files into a monthly, then copies that consolidated file to each site's Xfer directory and compresses it. INPUT: sitecode/Unicorn/Webcat/Logs/yyyymm.weblog OUTPUT: sitecode/Unicorn/Xfer/yyyymm.weblog.Z SORT OPTIONS: None | Production. |
| lz7011 |
Count the number of WorkFlows reports run by each site for the previous month. INPUT: /Unicorn/Logs/Report/ SORT OPTIONS: None | LOUIS Staff Only |
| lz7012 |
Runs on the third day of each month, and counts the number of circulation transactions for the previous month for each LOUIS site. The report loops through each site & extracts transactions from their current Unicorn statistics log. |
LOUIS Staff Only |
| lz7013 |
Count Symphony titles, items, call numbers, users and orders for all LOUIS sites. INPUT: catalog, item, callnum, user and order databases. OUTPUT: Symphony Record Counts. SORT: NONE. |
LOUIS Staff Only |
| lz7014 |
This script calls lz0037.pl monthly for specified LOUIS sites, calculates iLink search stats and outputs delimited files into each site's Xfer directory. INPUT: sitecode/Unicorn/Webcat/Logs/yyyymm.weblog OUTPUT: sitecode/Unicorn/Xfer/ SORT OPTIONS: None | Production |
| lz7015 |
Copies previous month's data from logs in /sitecode/Unicorn/Xfer/856_URL_Logs to monthly logs in the same directory. INPUT: govdocs.log and ilink.log in sitecode/Unicorn/Xfer/856_URL_Logs/ OUTPUT: yyyymm.govdocs.log and yyyymm.ilink.log in sitecode/Unicorn/Xfer/856_URL_Logs/ SORT OPTIONS: None | LOUIS staff only |
| Source Name |
Brief Description |
STATUS |
|---|---|---|
| lu3022 |
This report is based on the Sirsi delivered report Set Reserves to Select Status (setrsvstat). It updates three reserve fields and outputs a tab-delimited file with reserve information. These updates are done in order and are dependent upon the preceding update. 1. Updates reserve stage of reserve record to INACTIVE. 2. Updates the reserve control status to DORMANT if the reserve stage is INACTIVE. 3. Updates the copy reserve status to NOT ON RESERVE if the reserve stage is INACTIVE and the reserve control status DORMANT. 4. Outputs a tab-delimited file of reserve information which includes: call number,date placed,date expired,reserve stage,reserve control status,course,instructor,home location,item id,library,flexkey,author,title. INPUT: reserve control, reserve OUTPUT: call number, date placed, date expired, reserve stage, reserve control status, course, instructor, home location, item id, library, flexkey, author, title. SORT OPTIONS: instructor, instructor/call number, library/home location/title | Production |
| sl3022 |
This report is based on the Sirsi delivered report Set Reserves to Select Status (setrsvstat). It updates three reserve fields and outputs a tab-delimited file with reserve information. These updates are done in order and are dependent upon the preceding update. 1. Updates reserve stage of reserve record to INACTIVE. 2. Updates the reserve control status to DORMANT if the reserve stage is INACTIVE. 3. Updates the copy reserve status to NOT ON RESERVE if the reserve stage is INACTIVE and the reserve control status DORMANT. INPUT: reserve control, reserve OUTPUT: call number, date placed, date expired, reserve stage, reserve control status, course, instructor, home location, item id, library, flexkey, author, title. SORT OPTIONS: instructor, instructor/call number, library/home location/title | Production |
| Source Name |
Brief Description |
STATUS |
|---|---|---|
| lt3003 |
Extracts serials holdings for ingenta. The report outputs a file to the user's PC. The user is responsible for transfering the output file to ingenta. It looks for an 001 with the "ocm" prefix. If the "ocm" prefix is found in the 001, then the OCLC number in the 001 is used rather than the OCLC number in the 035. INPUT: selection criteria for catalog, call number, copy OUTPUT: each record is list of ingenta defined output which includes: ISSN, OCLC number, title, call number, holdings SORT OPTIONS: None | Production |
| lu3003 |
Extracts serials holdings for ingenta. The report outputs a file to the user's PC. The user is responsible for transfering the output file to ingenta. It looks for an 001 with the "ocm" prefix. If the "ocm" prefix is found in the 001, then the OCLC number in the 001 is used rather than the OCLC number in the 035. INPUT: selection criteria for catalog, call number, copy OUTPUT: each record is list of ingenta defined output which includes: ISSN, OCLC number, title, call number, holdings SORT OPTIONS: None | Production |
| ax3020 |
Extracts serials holdings information. DELIVERED SCRIPT: none INPUT: copy OUTPUT: pipe-delimited report with ISSN, TITLE, VOLUME (holdings), ERROR for 866, LOCATION, CALL NUMBER SORT OPTIONS: none | Training |
| sh3020 |
serials holdings information. INPUT:(Selection criteria: Copy) OUTPUT:(Format of the report: Pipe Delimited Fields. ISSN,TITLE,VOLUME,ERROR for 866,LOCATION,CALL NUMBER. SORT OPTIONS: None. | Production |
| lt3023 |
Program is a copy of serctllist INPUT: serial, catalog, vendcycle OUTPUT: Serial Control Records in a tab delimited output SORT OPTIONS: none | Training |
| lu3023 |
Program is a copy of serctllist INPUT: serial, catalog, vendcycle OUTPUT: Serial Control Records in a tab delimited output SORT OPTIONS: none | Production |
| lw3023 |
Program is a copy of serctllist INPUT: serial, catalog, vendcycle OUTPUT: Serial Control Records in a tab delimited output SORT OPTIONS: none | Production |
| no3023 |
Program is a copy of serctllist INPUT: serial, catalog, vendcycle OUTPUT: Serial Control Records in a tab delimited output SORT OPTIONS: none | Production |
| sl3023 |
Program is a copy of serctllist INPUT: serial, catalog, vendcycle OUTPUT: Serial Control Records in a tab delimited output SORT OPTIONS: no sort options | Production |
| ia3024 |
This report is identical to issuelate.pl except this reports sorts by title. Marks serial predictions as late based on date to claim. DELIVERED SCRIPT: issuelate.pl INPUT: serial control, predictions OUTPUT: Same output as issuelate.pl (see NOTES below) SORT OPTIONS: title | Production |
| ns3026 |
Extracts serials to send to AtoZ. This report outputs a tab-delimited report with title, ISSN, and the first 1,2,or 3 letters in call number. If a call number does not begin with 3,2,or 1 letter, then the first 3 characters of the call number are output. This file can be saved to the user's pc and sent to AtoZ. If a record has more than one ISSN, the first will be kept. Titles are deduped. All periods are removed from the title. Sorts by call number, title, or ISSN. This report is for LC classification only. Note: In configuration of Finished Reports, set Page Width > 500 in order for output to display properly. INPUT: Selection criteria includes title and copy. OUTPUT: tab-delimited report which includes title, ISSN, and first 1, 2, or 3 letters in call number. SORT OPTIONS: call number, title, or ISSN. | Production |
| ax3028 |
Extracts serials holdings information for OCLC. It selects ITEM TYPE = SERIAL, it does not select SHADOWED items, and it dedups. INPUT: no selection criteria OUTPUT: two files: a file of marc records to send to OCLC, and another file in a Sirsi format that lists the fields. SORT OPTIONS: none | Training |
| lt3028 |
Extracts serials holdings information for OCLC. It selects ITEM TYPE = SERIAL, it does not select SHADOWED items, and it dedups. INPUT: no selection criteria OUTPUT: two files: a file of marc records to send to OCLC, and another file in a Sirsi format that lists the fields. SORT OPTIONS: none | Production |
| ax3041 |
Extracts serials holdings information. Report is similar to ig3020.pl. ISSN is from first 022; TITLE is from 245 subfields a,b; LOCATION is from 852 subfield c, CALL NUMBER is from 852 subfield h, VOLUMES is from 866 (one or more). For every 852, a record is output with the same ISSN and TITLE. DELIVERED SCRIPT: none INPUT: copy OUTPUT: pipe-delimited report with the following fields: ISSN,TITLE,LOCATION,CALL NUMBER,VOLUMES. SORT OPTIONS: None. | Training |
| ni3041 |
Extracts serials holdings information. Report is similar to ig3020.pl. ISSN is from first 022; TITLE is from 245 subfields a,b; LOCATION is from 852 subfield c, CALL NUMBER is from 852 subfield h, VOLUMES is from 866 (one or more). For every 852, a record is output with the same ISSN and TITLE. DELIVERED SCRIPT: none INPUT: copy OUTPUT: pipe-delimited report with the following fields: ISSN,TITLE,LOCATION,CALL NUMBER,VOLUMES. SORT OPTIONS: None. | Training |
| lw3044 |
This report is exactly like issuelate.pl, but it also sorts by title and outputs an additional field: base call number. DELIVERED SCRIPT: Prediction as Late(issuelate.pl) INPUT: title, call number, item OUTPUT:tab-delimited file with title, call number, numeration, name (chronology), expected date, date published, claim reason, date claimed, number of copies, times claimed, send claim | Production |
| ne3044 |
This report is exactly like issuelate.pl, but it also sorts by title and outputs an additional field: base call number. DELIVERED SCRIPT: Prediction as Late(issuelate.pl) INPUT: title, call number, item OUTPUT:tab-delimited file with title, call number, numeration, name (chronology), expected date, date published, claim reason, date claimed, number of copies, times claimed, send claim | Production |
| lw3061 |
Make predictionlist tab-delimited | Production |
| lu5022 |
This report produces a tab-delimited file of serial control records that do not have predictions. DELIVERED SCRIPT: none INPUT: serial control OUTPUT: tab delimited output :: Library, Serial Control ID, Call Number, Title SORT OPTIONS: none | Production |
| lw5022 |
This report produces a tab-delimited file of serial control records that do not have predictions. DELIVERED SCRIPT: none INPUT: serial control OUTPUT: tab delimited output :: Library, Serial Control ID, Call Number, Title SORT OPTIONS: none | Production |
| sl5022 |
This report produces a tab-delimited file of serial control records that do not have predictions. DELIVERED SCRIPT: none INPUT: serial control OUTPUT: tab delimited output :: Library, Serial Control ID, Call Number, Title SORT OPTIONS: none | Production |
| lu5023 |
This report produces a tab-delimited file of serial control records, number of expected issues, number of received issues, and the difference between the two. DELIVERED SCRIPT: none INPUT: serial control OUTPUT: tab delimited output :: Title, Library, Serial Control ID, Base Call No., Number of Expected Issues, Number of Received Issues, Difference SORT OPTIONS: none | Production |
| sl5023 |
This report produces a tab-delimited file of serial control records, number of expected issues, number of received issues, and the difference between the two. DELIVERED SCRIPT: none INPUT: serial control OUTPUT: tab delimited output :: Title, Library, Serial Control ID, Base Call No., Number of Expected Issues, Number of Received Issues, Difference SORT OPTIONS: none | Production |
| lw5028 |
This report outputs a list of received serials. INPUT: receipt, prediction, serial control OUTPUT: title, serial control ID, SISAC ID, base call number on serial control record, enumeration and chronology on received tab of serial control record, date received, receipt number (number of items received) SORT OPTIONS: none | Production |
| no5028 |
This report outputs a list of received serials. INPUT: receipt, prediction, serial control OUTPUT: title, serial control ID, SISAC ID, base call number on serial control record, enumeration and chronology on received tab of serial control record, date received, receipt number (number of items received) SORT OPTIONS: none | Production |
| mn7018 |
IMPORTANT! This report will remove serial issues when update option is selected. Read the Sirsi Helps for report "Delete Received Issues" to know what this report can do. This custom report is based on the Delete Received Issues report which allows you to remove serial issues in batch. This report will assist you in deleting older issues that are no longer a part of the library's physical collection. This report allows you to select serial control ids in the search tab. In the search field make sure the serial control ids are entered in this format: library=serial control id, example: LAMNMAIN=SC-279. DELIVERED SCRIPT: Delete Received Issues (remrecissues.pl) INPUT: Selection criteria includes search tab, receipt, prediction, serial control, vendor, vendorcycle, and an update option. OUTPUT: Sirsi formatted list of removed issues. | Production |
| Source Name |
Brief Description |
STATUS |
|---|---|---|
| lt3001 |
Extracts users for ingenta. INPUT: selection criteria for users OUTPUT: pipe-delimited file. Each record is list of ingenta defined output which includes: user id, name, profile, department SORT OPTIONS: None | Production |
| lu3001 |
Extracts users for ingenta. INPUT: selection criteria for users OUTPUT: pipe-delimited file. Each record is list of ingenta defined output which includes: user id, name, profile, department SORT OPTIONS: None | Production |
| sl3001 |
Extracts users for ingenta. INPUT: selection criteria for users OUTPUT: pipe-delimited file. Each record is list of ingenta defined output which includes: user id, name, profile, department SORT OPTIONS: None | Production |
| le3031 |
This report outputs user information to a tab-delimited file only. INPUT: Selection criteria includes user. OUTPUT: The first record in the file shows the fields and their order in the tab-delimited file: user name, user id, user profile,department,phone number fron address 1 SORT OPTIONS: none | Production |
| ns3031 |
This report outputs user information to a tab-delimited file only. INPUT: Selection criteria includes user. OUTPUT: The first record in the file shows the fields and their order in the tab-delimited file: user name, user id, user profile,department,phone number fron address 1 SORT OPTIONS: none | Production |
| sc3031 |
This report outputs user information to a tab-delimited file only. INPUT: Selection criteria includes user. OUTPUT: The first record in the file shows the fields and their order in the tab-delimited file: user name, user id, user profile,department,phone number fron address 1 SORT OPTIONS: none | Production |
| lu3080 |
Based on Sirsi delivered report: rembill.pl. INPUT: Selection criteria includes search string (required), bill, and user. OUTPUT: tab-delimited file of UserId, Name, DateBilled, BillAmounts, BillReason SORT OPTIONS: none | Production |