Adding records to Islandora

This page is under construction

Generating records

• Use bib hldgs pairs to generate records. Use script to generate bib hldgs pairs from call numbers if needed.
• Extend the records to have the correct number of child records for each parent.
• If imaging has generated rootfiles, add them to the child records.
  • Otherwise, send the records to imaging for rootfiling
  • Rename image files with rootfile names in IrfanView thumbnails

Importing records

• Upload images to S3
• Add S3 links to records
• Upload spreadsheet to Islandora
  • After upload has processed, generate thumbnail for parent record

Useful scripts

Script to generate Islandora records from given holdings-bib pairs

import requests
import xml.etree.ElementTree as ET
import csv
from relatorDict import relatorDictionary
from ShxQuartosList import ShxQuartos
from holdingsTestDict import holdingsToBibDictionary


headers = {'Authorization': "Token APIKeyGoesHere"}
params = {"of":"xm"}
csvF=open("islandoraRecord.csv","w",newline='', encoding='utf-8')

fieldnames=["title","id","parent_id","field_resource_type","field_model","field_member_of","field_weight","field_identifier","field_linked_agent","field_creator","field_edtf_date","field_place_published","field_extent","field_rights","field_subject","field_note","field_classification","field_page_opening","field_contents","field_catalog_link","field_finding_aid_link","field_created_published","field_genre","field_iconclass_headings","field_bindings_features","field_bindings_terms","field_digital_image_type","field_microfilm_call_number","field_microfilm_reduction_ratio","field_microfilm_length","field_credit","field_sponsored_by","field_bib_id","field_holdings_id","field_display_hints","file","url_alias"]
writer=csv.DictWriter(csvF,fieldnames=fieldnames)
writer.writeheader()

i=1

newRelators=[]

for holdingsID in holdingsToBibDictionary:
	bibID=holdingsToBibDictionary[holdingsID]
	URL = "https://catalog.folger.edu/api/v1/record/"+bibID
	print("bib " + bibID)
	r = requests.request("GET", URL, headers=headers, params=params)
	root = ET.fromstring(r.content)

	sfCode=""
	sfValue=""

	callNums={}
	copyNotes={}
	holdingsIDs={}
	collections=[]
	notes=[]
	subjects=[]

	associatedNames=[]
	genresForms=[]

	#EDTF date
	edtfDate=""
	for controlfield in root.findall("controlfield[@tag='008']"):
		edtfDate=""
		lang=""
		countryCode=""
		full008=controlfield.text
		print("008: "+full008)
		date1=full008[7:11]
		print("Date 1: "+date1)
		date2=full008[11:15]
		print("Date 2: "+date2)
		dateType=full008[6]
		print("Type: "+dateType)
		lang=full008[35:38]
		countryCode=full008[15:18]

		if dateType=="b" or (date1=="\\\\" and date2=="\\\\"):
			edtfDate="XXXX"
		elif dateType=="c" or dateType=="u":
			edtfDate=date1+"/.."
		elif dateType=="d":
			edtfDate=date1+"/"+date2
		elif dateType=="e":
			edtfDate=date1+"-"+date2[0:2]+"-"+date2[2:4]
		elif dateType=="i" or dateType=="k" or dateType=="m":
			if date1==date2:
				edtfDate=date1
			else:
				edtfDate=date1+"/"+date2
		elif dateType=="n":
			edtfDate="XXXX"
		elif dateType=="p" or dateType=="r" or dateType=="t":
			edtfDate=date1
		elif dateType=="q":
			edtfDate=date1+"/"+date2
		elif dateType=="s":
			edtfDate=date1
		edtfDate=edtfDate.replace("u","X")

	full007=""
	for controlfield in root.findall("controlfield[@tag='007']"):
		full007=controlfield.text

	#creator: 100%%abcdejq  110%%abcde  111%%acdejq
	creator=""
	for datafield in root.findall("datafield[@tag='100']"):
		dict100={}
		#find first indicator
		for subfield in datafield.findall("subfield"):
			sfCode=subfield.attrib['code']#
			sfValue=subfield.text
			dict100[sfCode]=sfValue
			sfCode=""
			sfValue=""
		creator=""
		if "e" in dict100:
			relatorTerm=dict100["e"]
			relatorTerm=relatorTerm.rstrip("., ")
			if relatorTerm in relatorDictionary:
				relatorCode=relatorDictionary[relatorTerm]
			else:
				relatorCode="relators:TEST"
				newRelators.append(relatorTerm+": https://catalog.folger.edu/record/"+bibID)

			creator=relatorCode+":"
		else:
			creator="relators:cre:"
		creator=creator+"person:" 
		if "a" in dict100:
			creator=creator+" "+(dict100["a"])
		if "b" in dict100:
			creator=creator+" "+(dict100["b"])
		if "c" in dict100:
			creator=creator+" "+(dict100["c"])
		if "d" in dict100:
			creator=creator+" "+(dict100["d"])
		#if "e" in dict100:
			#creator=creator+" "+(dict100["e"])
		if "j" in dict100:
			creator=creator+" "+(dict100["j"])
		if "q" in dict100:
			creator=creator+" "+(dict100["q"])
		creator=creator.rstrip("., ")
		creator=creator.replace("  "," ")

	for datafield in root.findall("datafield[@tag='110']"):
		dict110={}
		for subfield in datafield.findall("subfield"):
			sfCode=subfield.attrib['code']#
			sfValue=subfield.text
			dict110[sfCode]=sfValue
			sfCode=""
			sfValue=""
		creator=""
		if "e" in dict110:
			relatorTerm=dict110["e"]
			relatorTerm=relatorTerm.rstrip("., ")
			if relatorTerm in relatorDictionary:
				relatorCode=relatorDictionary[relatorTerm]
			else:
				relatorCode="relators:TEST"
				newRelators.append(relatorTerm+": https://catalog.folger.edu/record/"+bibID)
			creator=relatorCode+":"
		else:
			creator="relators:cre:"
		creator=creator+"corporate_body:" 
		if "a" in dict110:
			creator=creator+" "+(dict110["a"])
		if "b" in dict110:
			creator=creator+" "+(dict110["b"])
		if "c" in dict110:
			creator=creator+" "+(dict110["c"])
		if "d" in dict110:
			creator=creator+" "+(dict110["d"])
		creator=creator.rstrip("., ")
		creator=creator.replace("  "," ")


	for datafield in root.findall("datafield[@tag='111']"):
		dict111={}
		for subfield in datafield.findall("subfield"):
			sfCode=subfield.attrib['code']#
			sfValue=subfield.text
			dict111[sfCode]=sfValue
			sfCode=""
			sfValue=""
		creator=""
		if "e" in dict110:
			relatorTerm=dict110["e"]
			relatorTerm=relatorTerm.rstrip("., ")
			if relatorTerm in relatorDictionary:
				relatorCode=relatorDictionary[relatorTerm]
			else:
				relatorCode="relators:TEST"
				newRelators.append(relatorTerm+": https://catalog.folger.edu/record/"+bibID)
			creator=relatorCode+":"
		else:
			creator="relators:cre:"
		creator=creator+"corporate_body:" 
		if "a" in dict111:
			creator=creator+" "+(dict111["a"])
		if "c" in dict111:
			creator=creator+" "+(dict111["c"])
		if "d" in dict111:
			creator=creator+" "+(dict111["d"])
		if "j" in dict111:
			creator=creator+" "+(dict111["j"])
		if "q" in dict111:
			creator=creator+" "+(dict111["q"])
		creator=creator.rstrip("., ")
		creator=creator.replace("  "," ")

	#title: 245%%abcfghknps 
	title=""
	for datafield in root.findall("datafield[@tag='245']"):
		dict245={}
		for subfield in datafield.findall("subfield"):
			sfCode=subfield.attrib['code']#
			sfValue=subfield.text
			dict245[sfCode]=sfValue
			sfCode=""
			sfValue=""
		title=""
		title=dict245["a"]
		if "b" in dict245:
			title=title+" "+(dict245["b"])
		if "c" in dict245:
			title=title+" "+(dict245["c"])
		if "f" in dict245:
			title=title+", "+(dict245["f"])
		if "g" in dict245:
			title=title+" "+(dict245["g"])
		if "h" in dict245:
			title=title+" "+(dict245["h"])
		if "k" in dict245:
			title=title+" "+(dict245["k"])
		if "n" in dict245:
			title=title+" "+(dict245["n"])
		if "p" in dict245:
			title=title+" "+(dict245["p"])
		if "s" in dict245:
			title=title+" "+(dict245["s"])
		title=title.rstrip(".,/ ")
		title=title.replace("  "," ")

	#created/published: 260%%,264%_
	createdPublished=""
	for datafield in root.findall("datafield[@tag='260']"):
		dict260={}
		for subfield in datafield.findall("subfield"):
			sfCode=subfield.attrib['code']#
			sfValue=subfield.text
			dict260[sfCode]=sfValue
			sfCode=""
			sfValue=""
		
		if "a" in dict260:
			createdPublished=createdPublished+(dict260["a"])
		if "b" in dict260:
			createdPublished=createdPublished+" "+(dict260["b"])
		if "c" in dict260:
			createdPublished=createdPublished+" "+(dict260["c"])
	for datafield in root.findall("datafield[@tag='264']"):
		dict264={}
		for subfield in datafield.findall("subfield"):
			sfCode=subfield.attrib['code']#
			sfValue=subfield.text
			dict264[sfCode]=sfValue
			sfCode=""
			sfValue=""
		if createdPublished=="":
			if "a" in dict264:
				createdPublished=createdPublished+(dict264["a"])
			if "b" in dict264:
				createdPublished=createdPublished+" "+(dict264["b"])
			if "c" in dict264:
				createdPublished=createdPublished+" "+(dict264["c"])
	createdPublished=createdPublished.rstrip("., ")

	#notes: MARC: 510$ac (when first indicator is 3 or 4) 
	for datafield in root.findall("datafield[@tag='510']"):
		dict510={}
		if datafield.attrib["ind1"]=="3" or datafield.attrib["ind1"]=="4":
			for subfield in datafield.findall("subfield"):
				sfCode=subfield.attrib['code']#
				sfValue=subfield.text
				dict510[sfCode]=sfValue
				sfCode=""
				sfValue=""
			note="Reference citation note: "
			if "a" in dict510:
				note=note+(dict510["a"])
			if "c" in dict510:
				note=note+" "+(dict510["c"])
			notes.append(note)

	#subjects 600%%abcdt 
	#         610%%abcdt
	#         611%%acdt
	#         650%%a
	#		  651%%a
	for datafield in root.findall("datafield[@tag='600']"):
		dict600={}
		for subfield in datafield.findall("subfield"):
			sfCode=subfield.attrib['code']#
			sfValue=subfield.text
			dict600[sfCode]=sfValue
			sfCode=""
			sfValue=""
		subject=""
		if "a" in dict600:
			subject=subject+(dict600["a"])
		if "b" in dict600:
			subject=subject+" "+(dict600["b"])
		if "c" in dict600:
			subject=subject+" "+(dict600["c"])
		if "d" in dict600:
			subject=subject+" "+(dict600["d"])
		if "t" in dict600:
			subject=subject+" "+(dict600["t"])
		subject=subject.replace("  "," ")
		subject=subject.rstrip("., ")
		subjects.append(subject)
	for datafield in root.findall("datafield[@tag='610']"):
		dict610={}
		for subfield in datafield.findall("subfield"):
			sfCode=subfield.attrib['code']#
			sfValue=subfield.text
			dict610[sfCode]=sfValue
			sfCode=""
			sfValue=""
		subject=""
		if "a" in dict610:
			subject=subject+(dict610["a"])
		if "b" in dict610:
			subject=subject+" "+(dict610["b"])
		if "c" in dict610:
			subject=subject+" "+(dict610["c"])
		if "d" in dict610:
			subject=subject+" "+(dict610["d"])
		if "t" in dict610:
			subject=subject+" "+(dict610["t"])
		subject=subject.replace("  "," ")
		subject=subject.rstrip("., ")
		subjects.append(subject)
	for datafield in root.findall("datafield[@tag='611']"):
		dict611={}
		for subfield in datafield.findall("subfield"):
			sfCode=subfield.attrib['code']#
			sfValue=subfield.text
			dict611[sfCode]=sfValue
			sfCode=""
			sfValue=""
		subject=""
		if "a" in dict611:
			subject=subject+(dict611["a"])
		if "c" in dict611:
			subject=subject+" "+(dict611["c"])
		if "d" in dict611:
			subject=subject+" "+(dict611["d"])
		if "t" in dict611:
			subject=subject+" "+(dict611["t"])
		subject=subject.replace("  "," ")
		subject=subject.rstrip("., ")
		subjects.append(subject)
	for datafield in root.findall("datafield[@tag='650']"):
		dict650={}
		for subfield in datafield.findall("subfield"):
			sfCode=subfield.attrib['code']#
			sfValue=subfield.text
			dict650[sfCode]=sfValue
			sfCode=""
			sfValue=""
		subject=""
		if "a" in dict650:
			subject=subject+(dict650["a"])
		subject=subject.replace("  "," ")
		subject=subject.rstrip("., ")
		subjects.append(subject)
	for datafield in root.findall("datafield[@tag='651']"):
		dict651={}
		for subfield in datafield.findall("subfield"):
			sfCode=subfield.attrib['code']#
			sfValue=subfield.text
			dict651[sfCode]=sfValue
			sfCode=""
			sfValue=""
		subject=""
		if "a" in dict651:
			subject=subject+(dict651["a"])
		subject=subject.replace("  "," ")
		subject=subject.rstrip("., ")
		subjects.append(subject)

	#genre/form: 655%%3;a;x;y;z
	for datafield in root.findall("datafield[@tag='655']"):
		dict655={}
		for subfield in datafield.findall("subfield"):
			sfCode=subfield.attrib['code']#
			sfValue=subfield.text
			dict655[sfCode]=sfValue
			sfCode=""
			sfValue=""
		genreForm=""
		if "a" in dict655:
			genreForm=genreForm+(dict655["a"])
		if "x" in dict655:
			genreForm=genreForm+(dict655["x"])
		if "y" in dict655:
			genreForm=genreForm+" "+(dict655["y"])
		if "z" in dict655:
			genreForm=genreForm+" "+(dict655["z"])
		genreForm=genreForm.rstrip("., ")
		genresForms.append(genreForm)

	#associated name: 700%%abcdejq  710%%abcde  711%%acdejq  800%%abcdejq  810%%abcde  811%%acdejq
	for datafield in root.findall("datafield[@tag='700']"):
		dict700={}
		for subfield in datafield.findall("subfield"):
			sfCode=subfield.attrib['code']#
			sfValue=subfield.text
			dict700[sfCode]=sfValue
			sfCode=""
			sfValue=""
		associatedName=""
		if "e" in dict700:
			relatorTerm=dict700["e"]
			relatorTerm=relatorTerm.rstrip("., ")
			if relatorTerm in relatorDictionary:
				relatorCode=relatorDictionary[relatorTerm]
			else:
				relatorCode="relators:TEST"
				newRelators.append(relatorTerm+": https://catalog.folger.edu/record/"+bibID)
			associatedName=relatorCode+":"
		else:
			associatedName="relators:asn:"
		associatedName=associatedName+"person:" ##CHECK INDICATOR FOR PERSON V FAMILY
		if "a" in dict700:
			associatedName=associatedName+" "+(dict700["a"])
		if "b" in dict700:
			associatedName=associatedName+" "+(dict700["b"])
		if "c" in dict700:
			associatedName=associatedName+" "+(dict700["c"])
		if "d" in dict700:
			associatedName=associatedName+" "+(dict700["d"])
		if "j" in dict700:
			associatedName=associatedName+" "+(dict700["j"])
		if "q" in dict700:
			associatedName=associatedName+" "+(dict700["q"])
		associatedName=associatedName.rstrip("., ")
		associatedName=associatedName.replace("  "," ")
		associatedNames.append(associatedName)

	for datafield in root.findall("datafield[@tag='710']"):
		dict710={}
		for subfield in datafield.findall("subfield"):
			sfCode=subfield.attrib['code']#
			sfValue=subfield.text
			dict710[sfCode]=sfValue
			sfCode=""
			sfValue=""
		associatedName=""
		if "e" in dict710:
			relatorTerm=dict710["e"]
			relatorTerm=relatorTerm.rstrip("., ")
			if relatorTerm in relatorDictionary:
				relatorCode=relatorDictionary[relatorTerm]
			else:
				relatorCode="relators:TEST"
				newRelators.append(relatorTerm+": https://catalog.folger.edu/record/"+bibID)
			associatedName=relatorCode+":"
		else:
			associatedName="relators:asn:"
		associatedName=associatedName+"corporate_body:" ##CHECK INDICATOR FOR PERSON V FAMILY
		if "a" in dict710:
			associatedName=associatedName+" "+(dict710["a"])
		if "b" in dict710:
			associatedName=associatedName+" "+(dict710["b"])
		if "c" in dict710:
			associatedName=associatedName+" "+(dict710["c"])
		if "d" in dict710:
			associatedName=associatedName+" "+(dict710["d"])
		associatedName=associatedName.rstrip("., ")
		associatedName=associatedName.replace("  "," ")
		associatedNames.append(associatedName)

	for datafield in root.findall("datafield[@tag='711']"):
		dict711={}
		for subfield in datafield.findall("subfield"):
			sfCode=subfield.attrib['code']#
			sfValue=subfield.text
			dict711[sfCode]=sfValue
			sfCode=""
			sfValue=""
		associatedName=""
		if "e" in dict711:
			relatorTerm=dict711["e"]
			relatorTerm=relatorTerm.rstrip("., ")
			if relatorTerm in relatorDictionary:
				relatorCode=relatorDictionary[relatorTerm]
			else:
				relatorCode="relators:TEST"
				newRelators.append(relatorTerm+": https://catalog.folger.edu/record/"+bibID)
			associatedName=relatorCode+":"
		else:
			associatedName="relators:asn:"
		associatedName=associatedName+"corporate_body:" 
		if "a" in dict711:
			associatedName=associatedName+" "+(dict711["a"])
		if "c" in dict711:
			associatedName=associatedName+" "+(dict711["c"])
		if "d" in dict711:
			associatedName=associatedName+" "+(dict711["d"])
		if "j" in dict711:
			associatedName=associatedName+" "+(dict711["j"])
		if "q" in dict711:
			associatedName=associatedName+" "+(dict711["q"])
		associatedName=associatedName.rstrip("., ")
		associatedName=associatedName.replace("  "," ")
		associatedNames.append(associatedName)

	#place created: 752 abcd
	hierarchicalPlaceName=""
	for datafield in root.findall("datafield[@tag='752']"):
		dict752={}
		for subfield in datafield.findall("subfield"):
			sfCode=subfield.attrib['code']
			sfValue=subfield.text
			dict752[sfCode]=sfValue
			sfCode=""
			sfValue=""
		hierarchicalPlaceName=""
		if "a" in dict752:
			hierarchicalPlaceName=(dict752["a"])
		if "b" in dict752:
			hierarchicalPlaceName=hierarchicalPlaceName+"|"+(dict752["b"])
		if "c" in dict752:
			hierarchicalPlaceName=hierarchicalPlaceName+"|"+(dict752["c"])
		if "d" in dict752:
			hierarchicalPlaceName=hierarchicalPlaceName+"|"+(dict752["d"])
		hierarchicalPlaceName=hierarchicalPlaceName.rstrip("., ")		

	for datafield in root.findall("datafield[@tag='800']"):
		dict800={}
		for subfield in datafield.findall("subfield"):
			sfCode=subfield.attrib['code']#
			sfValue=subfield.text
			dict800[sfCode]=sfValue
			sfCode=""
			sfValue=""
		associatedName=""
		if "e" in dict800:
			relatorTerm=dict800["e"]
			relatorTerm=relatorTerm.rstrip("., ")
			if relatorTerm in relatorDictionary:
				relatorCode=relatorDictionary[relatorTerm]
			else:
				relatorCode="relators:TEST"
				newRelators.append(relatorTerm+": https://catalog.folger.edu/record/"+bibID)
			associatedName=relatorCode+":"
		else:
			associatedName="relators:asn:"
		associatedName=associatedName+"person:" ##CHECK INDICATOR 1 FOR PERSON V FAMILY
		if "a" in dict800:
			associatedName=associatedName+" "+(dict800["a"])
		if "b" in dict800:
			associatedName=associatedName+" "+(dict800["b"])
		if "c" in dict800:
			associatedName=associatedName+" "+(dict800["c"])
		if "d" in dict800:
			associatedName=associatedName+" "+(dict800["d"])
		if "e" in dict800:
			associatedName=associatedName+" "+(dict800["e"])
		if "j" in dict800:
			associatedName=associatedName+" "+(dict800["j"])
		if "q" in dict800:
			associatedName=associatedName+" "+(dict800["q"])
		associatedName=associatedName.rstrip("., ")
		associatedName=associatedName.replace("  "," ")
		associatedNames.append(associatedName)

	for datafield in root.findall("datafield[@tag='810']"):
		dict810={}
		for subfield in datafield.findall("subfield"):
			sfCode=subfield.attrib['code']#
			sfValue=subfield.text
			dict810[sfCode]=sfValue
			sfCode=""
			sfValue=""
		associatedName=""
		if "e" in dict810:
			relatorTerm=dict810["e"]
			relatorTerm=relatorTerm.rstrip("., ")
			if relatorTerm in relatorDictionary:
				relatorCode=relatorDictionary[relatorTerm]
			else:
				relatorCode="relators:TEST"
				newRelators.append(relatorTerm+": https://catalog.folger.edu/record/"+bibID)
			associatedName=relatorCode+":"
		else:
			associatedName="relators:asn:"
		associatedName=associatedName+"corporate_body:" ##CAN WE DO MEETING?
		if "a" in dict810:
			associatedName=associatedName+" "+(dict810["a"])
		if "b" in dict810:
			associatedName=associatedName+" "+(dict810["b"])
		if "c" in dict810:
			associatedName=associatedName+" "+(dict810["c"])
		if "d" in dict810:
			associatedName=associatedName+" "+(dict810["d"])
		if "e" in dict810:
			associatedName=associatedName+" "+(dict810["e"])
		associatedName=associatedName.rstrip("., ")
		associatedName=associatedName.replace("  "," ")
		associatedNames.append(associatedName)

	for datafield in root.findall("datafield[@tag='811']"):
		dict811={}
		for subfield in datafield.findall("subfield"):
			sfCode=subfield.attrib['code']#
			sfValue=subfield.text
			dict811[sfCode]=sfValue
			sfCode=""
			sfValue=""
		associatedName=""
		if "e" in dict811:
			relatorTerm=dict811["e"]
			relatorTerm=relatorTerm.rstrip("., ")
			if relatorTerm in relatorDictionary:
				relatorCode=relatorDictionary[relatorTerm]
			else:
				relatorCode="relators:TEST"
				newRelators.append(relatorTerm+": https://catalog.folger.edu/record/"+bibID)
			associatedName=relatorCode+":"
		else:
			associatedName="relators:asn:"
		associatedName=associatedName+"corporate_body:" 
		if "a" in dict811:
			associatedName=associatedName+" "+(dict811["a"])
		if "c" in dict811:
			associatedName=associatedName+" "+(dict811["c"])
		if "d" in dict811:
			associatedName=associatedName+" "+(dict811["d"])
		if "e" in dict811:
			associatedName=associatedName+" "+(dict811["e"])
		if "j" in dict811:
			associatedName=associatedName+" "+(dict811["j"])
		if "q" in dict811:
			associatedName=associatedName+" "+(dict811["q"])
		associatedName=associatedName.rstrip("., ")
		associatedName=associatedName.replace("  "," ")
		associatedNames.append(associatedName)

	#call num, holdings ID, copy notes
	callNum=""
	for datafield in root.findall("datafield[@tag='852']"):
		dict852={}
		for subfield in datafield.findall("subfield"):
			sfCode=subfield.attrib['code']#
			sfValue=subfield.text
			dict852[sfCode]=sfValue
			sfCode=""
			sfValue=""
		callNum=""
		Holdings852=""
		if "7" in dict852:
			Holdings852=dict852["7"]
		else:
			Holdings852=holdingsID
		if "k" in dict852:
			callNum=dict852["k"]
		if "h" in dict852:
			callNum=callNum+" "+dict852["h"]
		if "i" in dict852:
			callNum=callNum+" "+(dict852["i"])
		callNum=callNum.replace("  "," ")
		callNum=callNum.rstrip("., ")
		callNum=callNum.lstrip(" ")
		callNums[Holdings852]=callNum
		if "z" in dict852:
			copyNotes[Holdings852]=dict852["z"]

	numericDate=False
	intDate=0000

	#collection list:
	for controlfield in root.findall("controlfield[@tag='000']"):
		fullLeader=controlfield.text
		recordType=fullLeader[6]
		numericDate=False
		intDate=0000
		try:
			intDate=int(date1.replace("u","0"))
			numericDate=True
		except:
			numericDate=False
		if recordType=="a" or recordType=="c" or recordType=="e":
			#collections.append("74")#Books
			if intDate<=1500 and numericDate==True:
				collections.append("75")#Incunabula
			if intDate<=1640 and numericDate==True:
				if lang=="eng" or countryCode[2]=="k" or countryCode[0:2]=="ie":
					collections.append("76")#STC imprints
					if "h" in dict852:
						stcNumPlus=dict852["h"]
					else:
						stcNumPlus="SKIP"
					copyLoc=stcNumPlus.find(" ",4)
					if copyLoc!=-1:
						stcNum=stcNumPlus[0:copyLoc]
					else:
						stcNum=stcNumPlus
					if stcNum in ShxQuartos:
						#collections.append("91")#Shakespeare
						collections.append("92")#Quartos
					elif stcNum == "STC 22273":
						#collections.append("91")#Shakespeare
						collections.append("93")#First folios
					elif stcNum == "STC 22274":
						#collections.append("91")#Shakespeare
						collections.append("94")#Second folios
			elif intDate>1640 and intDate<=1700 and numericDate==True:
				if lang=="eng" or countryCode[2]=="k" or countryCode[2]=="u" or countryCode[0:2]=="ie":
					collections.append("77")#Wing imprints
					wingNumPlus=dict852["h"]
					copyLoc=wingNumPlus.find(" ")
					if copyLoc!=-1:
						wingNum=wingNumPlus[0:copyLoc]
					else:
						wingNum=wingNumPlus
					if wingNum=="S2913" or wingNum=="S2914":
						#collections.append("91")#Shakespeare
						collections.append("95")#Third folios
					elif wingNum=="S2915" or wingNum=="S2916" or wingNum=="S2917":
						#collections.append("91")#Shakespeare
						collections.append("96")#Fourth folios
			if intDate<1831 and numericDate==True:
				collections.append("78")#Pre-1831 imprints
			elif intDate>1830 and numericDate==True:
				collections.append("79")#Post-1830 imprints
		if recordType=="d" or recordType=="f" or recordType=="t":
			#collections.append("80")#Manuscripts
			if intDate<1701 and numericDate==True:
				collections.append("81")#Pre-1701 manuscripts
			elif intDate>1700 and numericDate==True:
				collections.append("82")#Post-1700 manuscripts
		if recordType=="k" or recordType=="r":
			#collections.append("83")#Art & Objects
			if full007!="":
				matDes=full007[1]
			else:
				matDes=""
			if recordType=="k":
				collections.append("88")#All pictures
				if matDes=="f" or matDes=="j" or matDes=="k" or matDes=="p" or matDes=="s":
					collections.append("84")#Prints
				elif matDes=="g" or matDes=="h" or matDes=="v":
					collections.append("85")#Photos
				elif matDes=="d" or matDes=="l":
					collections.append("86")#Drawings
				if (matDes=="d" and full007[3]=="c") or matDes=="e":
					collections.append("87")#Paintings
			if recordType=="r":
				collections.append("90")#Objects

	#extent: 300$c, art notes: 300$a
	extent=""
	for datafield in root.findall("datafield[@tag='300']"):
		dict300={}
		for subfield in datafield.findall("subfield"):
			sfCode=subfield.attrib['code']#
			sfValue=subfield.text
			dict300[sfCode]=sfValue
			sfCode=""
			sfValue=""
		extent=""
		if "324" in collections:#Art & Objects
			if "a" in dict300:
				extent=dict300["a"] + ": "
		if "c" in dict300:
			extentC=dict300["c"]
			extentC.lstrip("(")
			extentC.rstrip(")")
			extent=extent + extentC
			extent=extent.rstrip("., ")

	rights="https://rightsstatements.org/page/NoC-US/1.0/|https://creativecommons.org/publicdomain/zero/1.0/"
	catalogLink="https://catalog.folger.edu/record/"+bibID
	digitalImageType="High resolution image"
	credit="Folger Imaging Department"

	fullNotes=""
	fullSubjects=""
	fullAssociatedNames=""
	fullGenresForms=""
	fullCollections=""

	notes = list(dict.fromkeys(notes))
	for note in notes:
		if fullNotes=="":
			fullNotes=note
		else:
			fullNotes=fullNotes+"|"+note
	if holdingsID in copyNotes:
		copyNote="Copy note: "+copyNotes[holdingsID]
		print(copyNote)
		if fullNotes=="":
			fullNotes=copyNote
		else:
			fullNotes=fullNotes+"|"+copyNote
	else:
		print("no copy notes")
	subjects = list(dict.fromkeys(subjects))
	for subject in subjects:
		if fullSubjects=="":
			fullSubjects=subject
		else:
			fullSubjects=fullSubjects+"|"+subject
	associatedNames = list(dict.fromkeys(associatedNames))
	for associatedName in associatedNames:
		if fullAssociatedNames=="":
			fullAssociatedNames=associatedName
		else:
			fullAssociatedNames=fullAssociatedNames+"|"+associatedName
	genresForms = list(dict.fromkeys(genresForms))
	for genreForm in genresForms:
		if fullGenresForms=="":
			fullGenresForms=genreForm
		else:
			fullGenresForms=fullGenresForms+"|"+genreForm	
	collections = list(dict.fromkeys(collections))
	for collection in collections:
		if fullCollections=="":
			fullCollections=collection
		else:
			fullCollections=fullCollections+"|"+collection

	writer.writerow({"title":title,"id":i,"parent_id":"","field_resource_type":"collection","field_model":"paged content","field_member_of":fullCollections,"field_weight":"","field_identifier":"","field_linked_agent":fullAssociatedNames,"field_creator":creator,"field_edtf_date":edtfDate,"field_place_published":hierarchicalPlaceName,"field_extent":extent,"field_rights":rights,"field_subject":fullSubjects,"field_note":fullNotes,"field_classification":callNums[holdingsID],"field_page_opening":"","field_contents":"","field_catalog_link":catalogLink,"field_finding_aid_link":"","field_created_published":createdPublished,"field_genre":fullGenresForms,"field_iconclass_headings":"","field_bindings_features":"","field_bindings_terms":"","field_digital_image_type":"","field_microfilm_call_number":"","field_microfilm_reduction_ratio":"","field_microfilm_length":"","field_credit":"","field_sponsored_by":"","field_bib_id":bibID,"field_holdings_id":holdingsID,"field_display_hints":"Mirador","file":"","url_alias":"/bib"+bibID+"-"+holdingsID})
	writer.writerow({"title":"","id":i,"parent_id":"1","field_resource_type":"still image","field_model":"page","field_member_of":"","field_weight":"","field_identifier":"","field_linked_agent":"","field_creator":"","field_edtf_date":"","field_place_published":"","field_extent":"","field_rights":rights,"field_subject":"","field_note":"","field_classification":callNums[holdingsID],"field_page_opening":"","field_contents":"","field_catalog_link":"","field_finding_aid_link":"","field_created_published":"","field_genre":"","field_iconclass_headings":"","field_bindings_features":"","field_bindings_terms":"","field_digital_image_type":digitalImageType,"field_microfilm_call_number":"","field_microfilm_reduction_ratio":"","field_microfilm_length":"","field_credit":"","field_sponsored_by":"","field_bib_id":"","field_holdings_id":"","field_display_hints":"Mirador","file":"","url_alias":"/img"})

Script to generate bib-holdings pairs from a list of call numbers

import requests
from lxml import etree
from lxml.etree import fromstring
import csv
import json
from searchList import searchList

headers = {'Authorization': "Token a5ea65f5-924f-45a4-886f-8f82a913a5b5"}
url1 = "https://catalog.folger.edu/api/v1/search"
url2 = ""
params2 = {"of":"xm"}


csvF=open("record.csv","w",newline='', encoding='utf-8')

fieldnames=["search string","callNum","bib id", "holdings id"]
writer=csv.DictWriter(csvF,fieldnames=fieldnames)
writer.writeheader()

i=1


for searchString in searchList:
	
	callNum=""
	bibID=""
	hldgID=""
	params1 = {"format":"id", "f": "callnumber", "p": searchString}
	response = requests.request("GET", url1, headers=headers, params=params1)
	jsonResponse = response.json()
	if jsonResponse["total"]==1:

		bib=jsonResponse["hits"][0]
		bibID=str(bib)

		url2="https://catalog.folger.edu/api/v1/record/"+bibID
		r = requests.request("GET", url2, headers=headers, params=params2)
		root = etree.fromstring(r.content)

		#get hldg ID and call num--this only works for records with single holdings (for now)
		for datafield in root.findall("datafield[@tag='852']"):
			dict852={}
			for subfield in datafield.findall("subfield"):
				sfCode=subfield.attrib['code']#
				sfValue=subfield.text
				dict852[sfCode]=sfValue
				sfCode=""
				sfValue=""
			callNum=""
			hldgID=""
			if "7" in dict852:
				hldgID=dict852["7"]
			if "k" in dict852:
				callNum=dict852["k"]
			if "h" in dict852:
				callNum=callNum+" "+dict852["h"]
			if "i" in dict852:
				callNum=callNum+" "+(dict852["i"])
			callNum=callNum.replace("  "," ")
			callNum=callNum.rstrip("., ")
			callNum=callNum.lstrip(" ")
			print(callNum)
			print(bibID)
			print(hldgID)

		writer.writerow({"search string":searchString,"callNum":callNum,"bib id":bibID,"holdings id":hldgID})
	else:
		numOfResponses=str(jsonResponse["total"])
		writer.writerow({"search string":searchString,"callNum":"total record response "+numOfResponses,"bib id":"","holdings id":""})

Dictionary of relator terms

relatorDictionary={
"abridger": "relators:abr",
"actor": "relators:act",
"adapter": "relators:adp",
"addressee": "relators:rcp",
"analyst": "relators:anl",
"animator": "relators:anm",
"annotator": "relators:ann",
"appellant": "relators:apl",
"appellee": "relators:ape",
"applicant": "relators:app",
"architect": "relators:arc",
"arranger": "relators:arr",
"art copyist": "relators:acp",
"art director": "relators:adi",
"artist": "relators:art",
"artistic director": "relators:ard",
"assignee": "relators:asg",
"associated name": "relators:asn",
"attributed name": "relators:att",
"auctioneer": "relators:auc",
"author": "relators:aut",
"author in quotations or text abstracts": "relators:aqt",
"author of afterword, colophon, etc.": "relators:aft",
"author of dialog": "relators:aud",
"author of introduction, etc.": "relators:aui",
"autographer": "relators:ato",
"bibliographic antecedent": "relators:ant",
"binder": "relators:bnd",
"binding designer": "relators:bdd",
"blurb writer": "relators:blw",
"book designer": "relators:bkd",
"book producer": "relators:bkp",
"bookjacket designer": "relators:bjd",
"bookplate designer": "relators:bpd",
"bookseller": "relators:bsl",
"braille embosser": "relators:brl",
"broadcaster": "relators:brd",
"calligrapher": "relators:cll",
"cartographer": "relators:ctg",
"caster": "relators:cas",
"censor": "relators:cns",
"choreographer": "relators:chr",
"collaborator": "relators:clb",
"cinematographer": "relators:cng",
"client": "relators:cli",
"collection registrar": "relators:cor",
"collector": "relators:col",
"collotyper": "relators:clt",
"colorist": "relators:clr",
"commentator": "relators:cmm",
"commentator for written text": "relators:cwt",
"compiler": "relators:com",
"complainant": "relators:cpl",
"complainant-appellant": "relators:cpt",
"complainant-appellee": "relators:cpe",
"composer": "relators:cmp",
"compositor": "relators:cmt",
"conceptor": "relators:ccp",
"conductor": "relators:cnd",
"conservator": "relators:con",
"consultant": "relators:csl",
"consultant to a project": "relators:csp",
"contestant": "relators:cos",
"contestant-appellant": "relators:cot",
"contestant-appellee": "relators:coe",
"contestee": "relators:cts",
"contestee-appellant": "relators:ctt",
"contestee-appellee": "relators:cte",
"contractor": "relators:ctr",
"contributor": "relators:ctb",
"copyright claimant": "relators:cpc",
"copyright holder": "relators:cph",
"corrector": "relators:crr",
"correspondent": "relators:crp",
"costume designer": "relators:cst",
"court governed": "relators:cou",
"court reporter": "relators:crt",
"cover designer": "relators:cov",
"creator": "relators:cre",
"curator": "relators:cur",
"dancer": "relators:dnc",
"data contributor": "relators:dtc",
"data manager": "relators:dtm",
"dedicatee": "relators:dte",
"dedicator": "relators:dto",
"defendant": "relators:dfd",
"defendant-appellant": "relators:dft",
"defendant-appellee": "relators:dfe",
"degree granting institution": "relators:dgg",
"degree supervisor": "relators:dgs",
"delineator": "relators:dln",
"depicted": "relators:dpc",
"depositor": "relators:dpt",
"designer": "relators:dsr",
"director": "relators:drt",
"dissertant": "relators:dis",
"distribution place": "relators:dbp",
"distributor": "relators:dst",
"donor": "relators:dnr",
"draftsman": "relators:drm",
"dubious author": "relators:dub",
"editor": "relators:edt",
"editor of compilation": "relators:edc",
"editor of moving image work": "relators:edm",
"electrician": "relators:elg",
"electrotyper": "relators:elt",
"enacting jurisdiction": "relators:enj",
"engineer": "relators:eng",
"engraver": "relators:egr",
"etcher": "relators:etr",
"event place": "relators:evp",
"expert": "relators:exp",
"facsimilist": "relators:fac",
"field director": "relators:fld",
"film director": "relators:fmd",
"film distributor": "relators:fds",
"film editor": "relators:flm",
"film producer": "relators:fmp",
"filmmaker": "relators:fmk",
"first party": "relators:fpy",
"forger": "relators:frg",
"former owner": "relators:fmo",
"funder": "relators:fnd",
"geographic information specialist": "relators:gis",
"graphic technician": "relators:grt",
"honoree": "relators:hnr",
"honouree": "relators:hnr",
"host": "relators:hst",
"host institution": "relators:his",
"illuminator": "relators:ilu",
"illustrator": "relators:ill",
"inscriber": "relators:ins",
"instrumentalist": "relators:itr",
"interviewee": "relators:ive",
"interviewer": "relators:ivr",
"inventor": "relators:inv",
"issuing body": "relators:isb",
"judge": "relators:jud",
"jurisdiction governed": "relators:jug",
"laboratory": "relators:lbr",
"laboratory director": "relators:ldr",
"landscape architect": "relators:lsa",
"lead": "relators:led",
"lender": "relators:len",
"libelant": "relators:lil",
"libelant-appellant": "relators:lit",
"libelant-appellee": "relators:lie",
"libelee": "relators:lel",
"libelee-appellant": "relators:let",
"libelee-appellee": "relators:lee",
"librettist": "relators:lbt",
"licensee": "relators:lse",
"licensor": "relators:lso",
"lighting designer": "relators:lgd",
"lithographer": "relators:ltg",
"lyricist": "relators:lyr",
"manufacture place": "relators:mfp",
"manufacturer": "relators:mfr",
"marbler": "relators:mrb",
"markup editor": "relators:mrk",
"medium": "relators:med",
"metadata contact": "relators:mdc",
"metal-engraver": "relators:mte",
"minute taker": "relators:mtk",
"moderator": "relators:mod",
"monitor": "relators:mon",
"music copyist": "relators:mcp",
"musical director": "relators:msd",
"musician": "relators:mus",
"narrator": "relators:nrt",
"onscreen presenter": "relators:osp",
"opponent": "relators:opn",
"organizer": "relators:orm",
"originator": "relators:org",
"other": "relators:oth",
"owner": "relators:own",
"panelist": "relators:pan",
"papermaker": "relators:ppm",
"patent applicant": "relators:pta",
"patent holder": "relators:pth",
"patron": "relators:pat",
"performer": "relators:prf",
"permitting agency": "relators:pma",
"photographer": "relators:pht",
"plaintiff": "relators:ptf",
"plaintiff-appellant": "relators:ptt",
"plaintiff-appellee": "relators:pte",
"platemaker": "relators:plt",
"praeses": "relators:pra",
"presenter": "relators:pre",
"previous owner": "relators:fmo",
"printer": "relators:prt",
"printer of plates": "relators:pop",
"printmaker": "relators:prm",
"process contact": "relators:prc",
"producer": "relators:pro",
"production company": "relators:prn",
"production designer": "relators:prs",
"production manager": "relators:pmn",
"production personnel": "relators:prd",
"production place": "relators:prp",
"programmer": "relators:prg",
"project director": "relators:pdr",
"proofreader": "relators:pfr",
"provider": "relators:prv",
"publication place": "relators:pup",
"publisher": "relators:pbl",
"publishing director": "relators:pbd",
"puppeteer": "relators:ppt",
"radio director": "relators:rdd",
"radio producer": "relators:rpc",
"recording engineer": "relators:rce",
"recordist": "relators:rcd",
"redaktor": "relators:red",
"renderer": "relators:ren",
"reporter": "relators:rpt",
"repository": "relators:rps",
"research team head": "relators:rth",
"research team member": "relators:rtm",
"researcher": "relators:res",
"respondent": "relators:rsp",
"respondent-appellant": "relators:rst",
"respondent-appellee": "relators:rse",
"responsible party": "relators:rpy",
"restager": "relators:rsg",
"restorationist": "relators:rsr",
"reviewer": "relators:rev",
"rubricator": "relators:rbr",
"scenarist": "relators:sce",
"scientific advisor": "relators:sad",
"screenwriter": "relators:aus",
"scribe": "relators:scr",
"sculptor": "relators:scl",
"second party": "relators:spy",
"secretary": "relators:sec",
"seller": "relators:sll",
"set designer": "relators:std",
"setting": "relators:stg",
"signer": "relators:sgn",
"singer": "relators:sng",
"sound designer": "relators:sds",
"speaker": "relators:spk",
"sponsor": "relators:spn",
"sponsoring body": "relators:spn",
"stage director": "relators:sgd",
"stage manager": "relators:stm",
"standards body": "relators:stn",
"stereotyper": "relators:str",
"storyteller": "relators:stl",
"supporting host": "relators:sht",
"surveyor": "relators:srv",
"teacher": "relators:tch",
"technical director": "relators:tcd",
"television director": "relators:tld",
"television producer": "relators:tlp",
"thesis advisor": "relators:ths",
"transcriber": "relators:trc",
"translator": "relators:trl",
"type designer": "relators:tyd",
"typographer": "relators:tyg",
"university place": "relators:uvp",
"videographer": "relators:vdg",
"vocalist": "relators:voc",
"voice actor": "relators:vac",
"witness": "relators:wit",
"wood engraver": "relators:wde",
"woodcutter": "relators:wdc",
"writer of accompanying material": "relators:wam",
"writer of added commentary": "relators:wac",
"writer of added lyrics": "relators:wal",
"writer of added text": "relators:wat",
"writer of introduction": "relators:win",
"writer of preface": "relators:wpr",
"writer of supplementary textual content": "relators:wst",
}

List of Shakespeare quarto call numbers

ShxQuartos=[
"STC 22275",
"STC 22276",
"STC 22276a",
"STC 22277",
"STC 22278",
"STC 22279",
"STC 22279a",
"STC 22280",
"STC 22281",
"STC 22282",
"STC 22283",
"STC 22284",
"STC 22285",
"STC 22286",
"STC 22287",
"STC 22288",
"STC 22288a",
"STC 22289",
"STC 22290",
"STC 22291",
"STC 22292",
"STC 22293",
"STC 22294",
"STC 22295",
"STC 22296",
"STC 22297",
"STC 22298",
"STC 22299",
"STC 22300",
"STC 22301",
"STC 22302",
"STC 22303",
"STC 22304",
"STC 22305",
"STC 22306",
"STC 22307",
"STC 22308",
"STC 22309",
"STC 22310",
"STC 22311",
"STC 22312",
"STC 22313",
"STC 22314",
"STC 22315",
"STC 22316",
"STC 22317",
"STC 22318",
"STC 22319",
"STC 22320",
"STC 22321",
"STC 22322",
"STC 22323",
"STC 22324",
"STC 22325",
"STC 22325a",
"STC 22326",
"STC 22327",
"STC 22328",
"STC 22329",
"STC 22330",
"STC 22331",
"STC 22332",
"STC 22334",
"STC 22335",
"STC 22336",
"STC 26101",
"STC 22337",
"STC 22338",
"STC 22339",
"STC 26099",
"STC 26100",
"STC 21006",
"STC 21006a",
"STC 11075"
]

Sample dictionary of holdings-bib ID pairs

holdingsToBibDictionary={
"158300": "164478",
"230236":"128729"
}

Script to generate Islandora records from finding aid xml

from lxml import etree
from collections import OrderedDict
import codecs
import copy
import io
import json
import re
import sys
import csv

csvF=open("islandoraRecord.csv","w",newline='')

fieldnames=["title","id","parent_id","field_resource_type","field_model","field_member_of","field_weight","field_identifier","field_linked_agent","field_creator","field_edtf_date","field_place_published","field_extent","field_rights","field_subject","field_note","field_classification","field_page_opening","field_contents","field_catalog_link","field_finding_aid_link","field_created_published","field_genre","field_iconclass_headings","field_bindings_features","field_bindings_terms","field_transcription","field_digital_image_type","field_microfilm_call_number","field_microfilm_reduction_ratio","field_microfilm_length","field_credit","field_sponsored_by","field_bib_id","field_holdings_id","field_display_hints","file","url_alias"]
writer=csv.DictWriter(csvF,fieldnames=fieldnames)
writer.writeheader()

filename="findingAid"
tree = etree.parse(filename+'.xml')

for elem in tree.getiterator():
    if not (
        isinstance(elem, etree._Comment)
        or isinstance(elem, etree._ProcessingInstruction)
    ):
        elem.tag = etree.QName(elem).localname
etree.cleanup_namespaces(tree)
    
nodeList = tree.xpath('//c[@level="item"]')
for node in nodeList:

    callNumber = ""
    accessionNumber = ""
    displayTitle = ""
    titleCreator = ""
    titleAgents = []
    titleLocationCreated = ""
    titleLocationReceived = ""
    locationCreated = {}
    agentCreator = ""
    agentRecipient = ""
    displayDate = ""
    scopecontent = ""
    bioghist = ""
    physfacet = ""
    oddp = ""
    notes = ""

    #date
    dateSearch = node.xpath('did/unitdate')
    for date in dateSearch:
        displayDate = date.text

    #identifier
    identifierSearch = node.xpath('did/unitid')
    for identifier in identifierSearch:
        callNumber = identifier.text
        print(callNumber)

    #title
    titleSearch = node.xpath('did/unittitle')
    for title in titleSearch:
        displayTitle += "".join(title.itertext())

    #notes
    abstractSearch = node.xpath('scopecontent/p')
    for abstract in abstractSearch:
        scopecontent += " ".join(abstract.itertext())
        scopecontent = scopecontent.replace("\n"," ")

    #notes
    noteSearch = node.xpath('bioghist/p')
    for note in noteSearch:
        bioghist += "".join(note.itertext())
        bioghist = bioghist.replace("\n"," ")

    generalNoteSearch = node.xpath('did/physdesc/physfacet')
    for generalNote in generalNoteSearch:
        physfacet += "".join(generalNote.itertext())
    oddNoteSearch = node.xpath('odd/p')
    for oddNote in oddNoteSearch:
        oddp += "".join(oddNote.itertext())
        oddp = oddp.replace(" \n"," ")

    notes='{0} {1} {2} {3}'.format(scopecontent,bioghist,physfacet,oddp)
    notes.replace("  "," ")

    writer.writerow({"title":displayTitle,"id":"","parent_id":"","field_resource_type":"","field_model":"","field_member_of":"","field_weight":"","field_identifier":"","field_linked_agent":"","field_creator":"","field_edtf_date":"","field_place_published":"","field_extent":"","field_rights":"","field_subject":"","field_note":notes,"field_classification":callNumber,"field_page_opening":"","field_contents":"","field_catalog_link":"","field_finding_aid_link":"","field_created_published":displayDate,"field_genre":"","field_iconclass_headings":"","field_bindings_features":"","field_bindings_terms":"","field_transcription":"","field_digital_image_type":"","field_microfilm_call_number":"","field_microfilm_reduction_ratio":"","field_microfilm_length":"","field_credit":"","field_sponsored_by":"","field_bib_id":"","field_holdings_id":"","field_display_hints":"","file":"","url_alias":""})

Adding links to the catalog

Script to add links to the catalog using a CSV of link text and record IDs

import requests
import csv

headers = {'Authorization': "Token APIKeyGoesHere",'Content-Type': "application/xml"}
params = {"callback_email": "email@goeshere.com","mode": "append"}

with open('catalogLinks.csv') as links_file:
	links_reader = csv.DictReader(links_file)  
	for row in links_reader: 
		bib=row["bib id"]
		subU=row["856 $u"]
		subZ=row["856 $z"]
		URL="https://catalog.folger.edu/api/v1/record/"
		payload = r"""<record><controlfield tag="001">{0}</controlfield><datafield tag="856" ind1="4" ind2="1">
						<subfield code="u">{1}</subfield>
						<subfield code="z">{2}</subfield>
					</datafield></record>""".format(bib,subU,subZ)
		response = requests.request("POST", URL, data=payload, headers=headers, params=params)

Sample CSV file with link text and record IDs

bib id,856 $u,856 $z
255835,https://digitalcollections.folger.edu/img35779,Digital image(s) of Folger Shakespeare Library ART Box B924 no.2
255836,https://digitalcollections.folger.edu/img35817,Digital image(s) of Folger Shakespeare Library ART Box C875.6 no.1
255837,https://digitalcollections.folger.edu/img35770,Digital image(s) of Folger Shakespeare Library ART Box B919 no.17