Add New Resource Page URL to Databases Feed

[kevinreiss]

What maintenance needs to be done?

A new field containing the value of the new individual database page in libguides for a resource needs to be added to to export CSV file for databases.

Level of urgency

• High
• Moderate
• Low

Why is this maintenance needed?

• E-resource staff would like these URLs used in the search results we present to users in the All Search.

Acceptance criteria

• A new field called "resource_page_url" is added to each row in the CSV
• The base value for the URL will be https://libguides.princeton.edu/az/
• Create a unique "path" for the URL by taking the title and executing the following algorithm: Remove all non A-Z,0-9 characters, convert all spaces between words to the "-" character. One special cases: The "&" character is converted to the following string "-and-".
• Check the database for any titles with special characters and make sure the are handled correctly. Example

Implementation notes, if any

Springshare does not release the URL in the API so we need to construct the path by manipulating the string. Adding it to the API would have to go through their "enhancement" voting process according to their support.

Example URLs

URL: https://libguides.princeton.edu/az/african-american-periodicals-1825-1995 - Title: African American Periodicals, 1825-1995
URL https://libguides.princeton.edu/az/afghan-serials-collection - Title: Afghan Serials Collection
URL: https://libguides.princeton.edu/az/oil-and-gas-etrack - Title: Oil & Gas etrack

[maxkadel]

There does not seem to be a reliable pattern for these urls. For example, "Chosŏn ŏllon chŏngbo kiji" has the url https://libguides.princeton.edu/az/choson-ollon-kiji. Created a draft PR for this work #830