Entering and Completing Items from a Spreadsheet, Full Procedure||Entering and Completing Items from a Spreadsheet, Full Procedure||Entering and Completing Items from a Spreadsheet, Full Procedure||Conference Paper||Cover Sheet||Mapping More Collections||Organizations that are Authors||Creative Commons License||Embargos

1. Log in to MD-SOAR.
2. Work through the spreadsheet in order. If you don't like the order, you can sort it differently, but you must provide Michelle with your differently sorted version by uploading it to Workast and work through it in order. She'll use it to check your work, and to know when you're running low on work.
3. Open the work and any websites which might provide information that can be copied and pasted. The spreadsheet is also an important information source.
4. Duplicate search to ensure that the item isn't already in ScholarWorks following the Duplicate Searching Procedure.
5. Find the collection to add the item to in column B of the spreadsheet. You can also use the links in the Collections Excel File to find it's proper name.  Once you've found the collection, click "new submission" 
6. For entering data, you can use this chart which tells what you what information to find, and where to put it when you find it.
7. Locate the

   Anchor
   Authors Authors

   Authors in your information sources. Copy and paste to enter them in ScholarWorks. The last name is entered in the last name field. The first name, middle name, and any suffixes are entered in the first name field, e.g. Last name: Abrams First name: Jasmine A. Authors must be given in the order they appear on the work. UMBC authors must be input using the ORCID form of their name. If any authors are organizations, companies, universities, etc. rather than a person, enter them in administration after completing the submission. Also enter et al in administration after completing the submission. If the item has more than 50 authors, do not enter them all. Instead, enter: 1. the first 4 authors. 2. All UMBC authors. 3. Copy and paste the full author list into the description field. 4. In administration enter et al. as the final author to indicate that the item has other authors.Look for any contributors or advisers in your information sources. Copy and paste to enter them, entering names as described in the previous step
8. Locate ORCIDs. Copy and paste to enter them in ScholarWorks. 
9. Copy and paste any contributors into ScholarWorks. Enter names as described above.
10. Copy and paste any advisers into ScholarWorks. Enter names as described above.
11. Locate the title in your information sources. Copy and paste to enter it. Check for problems with line breaks or with subscript or superscript, and unusual characters. Problems can sometimes be resolves by downloading, opening with Adobe Acrobrate, switching to edit mode, and copying from there.  If there are still character problems, search for the correct character in the unicode tables, here: https://unicode-table.com/en/. If you can't find it or it doesn't display correctly, search the web for the unicode character. If you find it, or something you can use in it's place, use what you find. When you find the character, copy and paste or find and replace it in the title. If you don't find the character, consider alternatives to use instead, and if you think of something, go with it, if not, ask Michelle.
12. If the title appears different elsewhere, or if two or more titles are listed in the titles column in the spreadsheet, enter the other form(s) of the title into Other title(s).
13. In your information sources, locate the date of issue and enter it.
14. Locate the publisher in your information sources, and enter it. A publisher provides services that add value to the work, such as peer review, copy editing, and proofreading. Note that pre-print services such as ArXiv and Semantic Scholar are not publishers because people simply self-submit their works and these sites add no value. Also, academic social media sites such as Research Gate and Academia.edu are not publishers, and national repositories such as PubMed are not publishers. Also, UMBC websites are not typically publishers. If you can't find a company or organization that is the publisher, and the item is a journal, magazine, or newspaper article, enter the name of the journal, magazine or article as the publisher.Usually a . Copy and paste to enter in ScholarWorks. If there is more than 1, additional ones are entered in adminstiration.
15. Locate the

    Anchor
    Citations Citations

    citation can be copied and paste from the publishers record. Look for a citation feature there, and once located, copy and paste into the Citation of original publication field. If you don't find a citation on the publisher's record, follow an example in this Quick Guide. When entering authors into a citation, note that only 3 should be included. If there are more than 3, only put the first author followed by et al, for example, "Rachel A. Bay et al."Locate any series name and number in your information sources, and enter them. . Copy and paste to enter it in ScholarWorks.
16. Locate the publishers DOI on their record and enter it as an identifier.
17. Copy and paste the publisher's record URL into the external link field. This can also be the URL for the work on a lab or departmental page, or from another source.
18. In type of work, select the appropriate type. It is text for articles.
19. In format, enter the format(s) of work from the spreadsheet. 
20. In extent, indicate the length of the item. For articles it's the number of pages. 
21. In language, select English (United States).
22. Click next.
23. Copy and paste the abstract from your information sources in the abstract box. An abstract is a summary of the work, so a summary can be put in the place of an abstract. Check for problems with line breaks or with subscript or superscript, and unusual characters. Problems can sometimes be resolves by downloading, opening with Adobe Acrobrate, switching to edit mode, and copying from there.  If there are still character problems, search for the correct character in the unicode tables, here: https://unicode-table.com/en/. If you can't find it or it doesn't display correctly, search the web for the unicode character. If you find it, or something you can use in it's place, use what you find. When you find the character, copy and paste or find and replace it in the title. If you don't find the character, consider alternatives to use instead, and if you think of something, go with it, if not, ask Michelle.

24. Anchor
    Link-Only Link-Only

    If the item is link-only, copy Copy and paste keywords or subjects from your information sources in the keyword box one at a time. If there are no keywords in your information sources, find a few in the abstract that indicate what the work is about and enter them. When loading a pdf, entering keywords isn't necessary as the full text will be searchable. If the work is from a UMBC lab, always add a lab keyword, starting the keyword with UMBC (e.g UMBC High Performance Computing Facility). If the work is a student work produced for a class, always add the class as a keyword, starting the keyword with UMBC..Put any information on  into ScholarWorks.
25. Copy funding agencies, grants, etc. in into the sponsor field.
26. Put Copy and paste any additional rights statements in the rights field . removing the standard one that appears by default.

27. Anchor
    Conference-paper Conference-paper

    In the description field, include copy and paste anything given on the spreadsheet. Also add conference information if the work is a conference paper. If there is more than 1 value, enter additional values in adminstration.
28. Click next.

29. Anchor
    Cover-sheet Cover-sheet

    If column C in the spreadsheet indicates that you should submit a PDF, fill in and add a cover sheet to the work.  To add the cover sheet to the PDF, in Acrobat click “Combine Files.” Then click “Add Files” and find and add the coversheet. Click “Add files” again, and find and add the work. Click the bright blue “Combine” button. Save the new file named “binder1”using the original file name of the work and overwrite it.  Then upload into ScholarWorks.
30. Click next.
31. Check your work. Records must include all of the above information, and should be without any errors at all. Ensure that everything given in column J, publisher's requirements, is included in the metadata and on the coversheet. 
32. Click next.
33. If column L indicates if the item is on a Creative Commons license, select Creative Commons license, then choose the options to best match the information given in column L. If there is nothing in column L, choose no Creative Commons License. 
34. Click next.
35. Click I grant the license.
36. Click "Complete Submission".
37. Highlight the item you just completed in the spreadsheet so that you've entered it.

...

Anchor
Mapping-collections Mapping-collections

Map to the additional collections and add additional collections to the metadata 

1. Find each additional collection on the collections speadsheet and open it. Click "Item Mapper." Using the item mapper search box, search for the item. Locate the item in the search results list and click the box next to it. Click "Map Selected Items"
2. After the items are mapped to all the additional collections, go to the Edit Item Metadata screen.
3. Enter each additional collection into a new dc.relation.ispartof field by going to the top, selecting dc.relation.ispartof, and entering the additional collection into the value field (copy and paste from the collections speadsheet) then clicking "Add New Metadata". 
4. When you've finished with the metadata, be sure to click "update".

...

1. On the Edit Item Metadata screen, add a rights statement  to the metadata that states "Access to this item will begin on date."

2. When you've finished with the metadata, be sure to click "update".

3. Click on "Item Status"
4. click "Authorizations".
5. Find the bitstream with the file name on it. Check the box next to it. Scroll to the bottom and click "Delete Selected."
6. Find the bitstream with the file name on it again. Use the "create new bitstream" button next to t it to create a new bitstream.
7. Select "Read"
8. In Select a group, Select "anonymous"
9. In the start date field, fill in the date after the embargo ends.
10. Click "save".

...