You can paste copied data from an external source document directly into a text or long-text field. The Paste Multiple button is designed to allow pasting into a repeating field and is enabled only when your focus is in a repeating field.

This button allows you to paste data from an external source document (e.g., a text file, word-processed file, spreadsheet) that is structured appropriately to fit into the target field. This means that, if the target field has subfields, the source document has values related to those subfields in the same order, separated by tabs.

• One possible use of this input option is that you have a legacy Finding Aid document for which you are creating a new collection record and want to paste rather than enter a list of Creators or Media Types or Subject terms from the source document. In this example, you are pasting rows of data from a source document into separate occurrences, each of which will be validated as it is pasted.

  If the target field is a controlled field, e.g., Media Types, first create authority records for these terms if they do not already exist since the validation will fail. For fields linked to an authority but that are not controlled, an information alert will be generated with the validation of each occurrence and you can decide whether to add the new terms to the authority.

• You can also use the option with container listing data that you might have in a spreadsheet or text document if you can organize the columns appropriately in that source document (with tab separators), to match the subfields in the applicable Inventory List worksheet, e.g.:

  

For example, the two lines below illustrate tab-separated data elements organized to map into the first four subfields of the repeating field shown above.

Title 1 adsfasfas adfadfadadsf     1900s     1     15 photographs Title 2 asfd ads ads fad afad ad fsadf ad a    Late 1800s     2     14 folders/papers

To perform the paste operation, click on an empty occurrence of your target (repeating) field and follow these steps:

Step 1.  In your source document, highlight the lines (or rows) and copy them into your Windows clipboard.

Step 2.  In the SKCA input form window, click the Paste Multiple button

Step 3.  In the new window that pops up, right-click to use the browser's Paste option or use ctrl-v.

Step 4.  Click the Paste button, which will close this popup window and copy the lines/rows into separate occurrences of the form, populating each subfield in order with the TAB-separated data from each line.

Tip.  If you are pasting from an .html document and encounter problem, first paste the lines/rows into Notepad or Word and also confirm that the data elements in a line/row are separated by a tab.