ASERL Documents Disposition Database: Expired Offers Export

Any library that has posted Offers to the ASERL Disposition Database can export a list of their offers that have not been claimed within the 45 day cycle, as they may desire. 

This export is designed to streamline the importing of data into the FDLP eXchange database.  The CFDP Program Guidelines do not require the posting of offers to the national list  – however, they do strongly recommend that rare or otherwise significant publications which are not selected by libraries within the Southeast Region be included in the national Needs.  (This automatically applies to items with publication dates prior to 1907.)

When you click the button named 'EXPORT EXPIRED ITEMS (for FDLP eXchange)' on the My Submitted items page, the following "pop-up" form will appear.   The form allows you to filter or exclude expired Item records from your export file.

You can filter the export data by the ‘expiration date’ (the date that the Offer automatically expired in the Disposition database) by using a date range in the FROM and TO fields: 

• If both the FROM date and the TO date are left blank, your export will include all records in the database, from your very first expired offer to your most recent expired offer.
• If the FROM date is blank, and you have included a TO date, your export will include your very first expired offer up to the TO date.
• If you include a date in the FROM date and leave the TO date blank, your export will include records starting at the FROM date up to the most recent expired date.
• If both the FROM date and the TO date include dates, your export will include all records within that date range.

You will notice the checkbox to limit the results to expired offers that have a ‘publication date’ prior to January 1, 1907. This box will be checked by default, if unchecked, there is no restriction from the publication start date.

Please know –

• The User conducts the export – determining both the records that are exported and those chosen for import into FDLP eXchange.
• The export template is designed to match the FDLP eXchange Offers template (http://bit.ly/2ivIIgN) so that minimal editing will be required to import the file.
• The default export incorporates a date filter for expired offers with a publication date prior to 1907.  The option to export a list of all expired offers is also available.