Dear TMS Users,

For those cataloging in TMS, here are some guidelines for copying and pasting text into the database for optimal display. While this example uses the Web Text field, these tips apply to all text entries and single-value text entries, such as Didactic Label, Exhibition History, Condition Description, Storage Requirements, etc. (fields that allow formatting like italics, bold, and indents).

How to Copy and Paste Text for Optimal Display

Paste as Plain Text - When copying text from another source (e.g., Google Docs or Word), always paste as plain text to remove any hidden formatting.

• On a Mac: Right-click and select “Paste and Match Style,” or use the shortcut  Command + Shift + V
• On a PC: Right-click and select “Paste as Plain Text,” or use the keyboard shortcut Ctrl + Shift + V

Respond to the Security Prompt

• When pasting into TMS, a pop-up will prompt you to re-paste the text for security purposes. Simply paste it again using the same plain text method described above.

Apply Formatting Within TMS

• After pasting, use the formatting icons at the top-right corner of the field to add italics, bold, or any other necessary formatting.

Adjust Paragraph Breaks

• If you’re copying text from a PDF, watch out for extra line breaks. PDF text often includes unnecessary breaks, as shown below. Use Delete or Backspace to merge lines into paragraphs for better readability.
• 

Why This Matters

When text is copied from external sources, it often includes hidden HTML formatting (even from plain documents like Google Docs or Word). These residual tags can conflict with the formatting on the web or in other outputs like Crystal Reports, causing display issues. By following these steps, you ensure clean and consistent data without distracting formatting changes everywhere it appears: the FAMSF website, in Crystal Reports, and within TMS itself.

Examples

Here is text copied and pasted from a Google Doc (without using paste as plain text).

Here is the same text entry in "edit source" mode, which you can see by clicking on the </> icon at the top right. When you use edit source to look at the text, you can see the hidden html formatting that was copied over from Google Docs. These tags can interfere with  display on the web and in Crystal Reports. 

Please note that CI recently cleaned up some existing formatting errors in the Web Text field that was affecting display on the website for around 100 records. These edits will be reflected on the web after the next website update, which is scheduled for the week of January 20. 

Thank you for helping to maintain the quality and consistency of our database content!

Best regards,

Kathleen Forrest

Collections Database Administrator

Fine Arts Museums of San Francisco 

de Young \ Legion of Honor

682 365 8457

[log in to unmask]

www.famsf.org

pronouns: she/her/hers