Move works from Zotero to a Spreadsheet

Using Notepad:

1. Sets that are all being loaded into the same collection can be combined. Multiple My Library files can be combined by copying everything from the first <record> tag to the last </record> tag, and pasting it into another My Library file after the <records> tag. Note that sets can also be combined in Excel later by adding the contents of one spreadsheet to another.

2. Find and replaced all instances of </author> with ||</author>

3. Find and replaced all instances of </keyword> with ||</keyword>

4. Use EditX to transform the xml using this XSLT file:

5. Open the file in Notepad do the following

   1. Find all instances of &#xD; and replace with nothing

   2. Find all instances of </notes> and replace with </dc.identifier.citation>

   3. Find all instances of ### and replace with </notes><dc.identifier.citation>

6. Open a blank Excel spreadsheet. If you don’t see the developer tab, go to file, options, customize ribbon, and under main tabs, select the developer tab. Go to Developer, import, and select your XML file. Click ok. Ensure the next box say $A$A, then click ok.

7. Check for any missing URLs in the dc.description.uri column and fill in any that are missing with publisher’s URL. If unpublished, give the URL where the work is available..

Troubleshooting:

• If there’s an error in an EXML document, you can open it in Microsoft Edge and it will identify the element with the error. You can then open the xml in Notepad and find that element.

• If importing into Excel goes wrong, there is likely a duplicate element in the XML.

Processing

Note that any element that needs be repeated should have the values separated by ||

• All files that go with a set should be collected in a pdf folder for that set with coversheets added and any spaces in the file name removed, and the file names input in the filename column for the work that they go with on the spreadsheet.

• dc.description.uri contains the link to the work

• dc.rights should be changed to the appropriate rights note or CC lic

• dc.rights.uri should be the link to a cc lic when applicable

• dc.title.alternative contains alt titles if applicable

• Note that all dates need to be in the YEAR-MO-DA format. Do NOT NOT NOT attempt to achieve this by changing the cell’s format to date. If you do this, all dates will have to manually corrected in Notepad and it will be a horrible, tedious task.