For Subjects and Names

From UA Libraries Digital Services Planning and Documentation
(Difference between revisions)
Jump to: navigation, search
(Created page with "==getNames.py== ==getSubjects.py==")
 
Line 1: Line 1:
 
==getNames.py==
 
==getNames.py==
 +
===Instructions for using the getNames script===
 +
getNames.py is an application written in Python, it is used for searching and editing name authority records from VIAF and in our Mads Database.
 +
To use the script you will need to have Python 2.7 installed on your machine along with the addon module MySQLdb.
 +
 +
The script is located in the administrative\scripts\metadata folder.
 +
when you launch the application you will see this window.
 +
 +
[[Image:Main_search_box.PNG]]
 +
 +
entering a string in the search field and clicking on the search button will cause the script to query the online VIAF database and return records form there and at the same time send a search request to our local Mads Database and return records for there.
 +
 +
using the "%" wildcard before or after your search string will match anything that might come before or after the characters you typed. However this only works for the MadsDB part of the search and will confuse VIAF and cause it to return no records. So I suggest you only use it when focusing on getting records from our Mads database.
 +
 +
VIAF only really seems to like exact string matches so when at all possible type as much of the name as you know and put it in the Lastname, Firstname format.
 +
 +
The MadsDB results window is colored pink and looks like this:
 +
 +
 +
[[File:Mads_results.PNG]]
 +
 +
for here any of the field values can be clicked to have their value placed into the paste buffer for use by pasting where ever you might need to use that value (like into an excel field)
 +
 +
clicking on the "Fix this record" button at the end of a row will load that records data into a update madsdb window and allow you to make changes to that record and update the database
 +
 +
 +
The VIAF results window is colored green and looks like this:
 +
 +
[[File:Viaf_results.PNG]]
 +
 +
The VIAF window works much like the Mads results window displaying a list of records and allowing you to click on the values and paste them where needed. however at the end of each row there is a "make new MadsDB entry?" button that will open a new record creation window and populate it with values from the VIAF and LOC fields returned from the VIAF search.
 +
 +
The new record window looks like this:
 +
 +
[[File:Record_entry_window.PNG]]
 +
 +
This window will allow you to enter values into any of the madsdb fields that you require and then submit the record to the database for inclusion. there is a brief QC inspection of the values to be submitted and the software will prompt you to make revisions if particular values are not allowed in to specific fields.
 +
 +
Here is a list of the fields and a description of what they contain:
 +
 +
“dnum” – Database Number. An auto-incrementing integer unique to the entry.
 +
 +
“namePart” – The name entry, without dates or honorifics (such as Mr., Mrs., etc.) or generational terms (Jr., Sr., III, etc.)
 +
 +
“nameDate” – the dates associated with the name (usually {birthdate}-{deathdate} in years, though one of them may be missing or unknown.)
 +
 +
“nameType” – Type of name as restricted by MODS, such as “personal”, “conference”, “corporate”, "geographic".  Currently, “family” is not in use.
 +
 +
“typeAuth” -  Authority type:  currently we support “naf” if there’s an LCCN number; otherwise, “local” is the correct entry.
 +
 +
“nameTerms” – honorifics or generational terms, semi-colon separated, such as “Captain; Jr.” or “Mrs.”, or “Dr.; Sr.”
 +
 +
“creationDate” – the date this entry was added to the database, in yyyy-mm-dd form
 +
 +
“changeDate” – the date this entry was changed in the database, in yyyy-mm-dd form
 +
 +
“LCCN” – the LCCN number if known
 +
 +
“VIAF” – the VIAF number if known
 +
 +
“notes”  -- any additional notes you want to add that will help others
 +
 +
“status” – “C” if checked;  otherwise this is currently left blank.
 +
 +
“collection” – optional field for collection number where this name was first found.
 +
 +
“source” – optional field for item number where this name was first found.
 +
 +
“altFor”  - may contain a single Database Number (dnum) referencing the correct entry to be used in place of this alternative name.  When entering a nickname, be sure to reference the correct database number here.
 +
 +
 +
 +
 +
  
 
==getSubjects.py==
 
==getSubjects.py==

Revision as of 16:52, 11 December 2015

getNames.py

Instructions for using the getNames script

getNames.py is an application written in Python, it is used for searching and editing name authority records from VIAF and in our Mads Database. To use the script you will need to have Python 2.7 installed on your machine along with the addon module MySQLdb.

The script is located in the administrative\scripts\metadata folder. when you launch the application you will see this window.

Main search box.PNG

entering a string in the search field and clicking on the search button will cause the script to query the online VIAF database and return records form there and at the same time send a search request to our local Mads Database and return records for there.

using the "%" wildcard before or after your search string will match anything that might come before or after the characters you typed. However this only works for the MadsDB part of the search and will confuse VIAF and cause it to return no records. So I suggest you only use it when focusing on getting records from our Mads database.

VIAF only really seems to like exact string matches so when at all possible type as much of the name as you know and put it in the Lastname, Firstname format.

The MadsDB results window is colored pink and looks like this:


Mads results.PNG

for here any of the field values can be clicked to have their value placed into the paste buffer for use by pasting where ever you might need to use that value (like into an excel field)

clicking on the "Fix this record" button at the end of a row will load that records data into a update madsdb window and allow you to make changes to that record and update the database


The VIAF results window is colored green and looks like this:

Viaf results.PNG

The VIAF window works much like the Mads results window displaying a list of records and allowing you to click on the values and paste them where needed. however at the end of each row there is a "make new MadsDB entry?" button that will open a new record creation window and populate it with values from the VIAF and LOC fields returned from the VIAF search.

The new record window looks like this:

Record entry window.PNG

This window will allow you to enter values into any of the madsdb fields that you require and then submit the record to the database for inclusion. there is a brief QC inspection of the values to be submitted and the software will prompt you to make revisions if particular values are not allowed in to specific fields.

Here is a list of the fields and a description of what they contain:

“dnum” – Database Number. An auto-incrementing integer unique to the entry.

“namePart” – The name entry, without dates or honorifics (such as Mr., Mrs., etc.) or generational terms (Jr., Sr., III, etc.)

“nameDate” – the dates associated with the name (usually {birthdate}-{deathdate} in years, though one of them may be missing or unknown.)

“nameType” – Type of name as restricted by MODS, such as “personal”, “conference”, “corporate”, "geographic". Currently, “family” is not in use.

“typeAuth” - Authority type: currently we support “naf” if there’s an LCCN number; otherwise, “local” is the correct entry.

“nameTerms” – honorifics or generational terms, semi-colon separated, such as “Captain; Jr.” or “Mrs.”, or “Dr.; Sr.”

“creationDate” – the date this entry was added to the database, in yyyy-mm-dd form

“changeDate” – the date this entry was changed in the database, in yyyy-mm-dd form

“LCCN” – the LCCN number if known

“VIAF” – the VIAF number if known

“notes” -- any additional notes you want to add that will help others

“status” – “C” if checked; otherwise this is currently left blank.

“collection” – optional field for collection number where this name was first found.

“source” – optional field for item number where this name was first found.

“altFor” - may contain a single Database Number (dnum) referencing the correct entry to be used in place of this alternative name. When entering a nickname, be sure to reference the correct database number here.




getSubjects.py

Personal tools