Events – Move Description to Note #events #notes

This script moves the entire contents of event descriptions of a selected fact type to the Note for that event. If there is already content in the Note, the Description value is appended as a new paragraph.

To select a Fact Type, you must use a SQLite manager that supports SQLite run-time variables, such as SQLite Expert Personal (SQLiteSpy does not). When the query is run, a box will pop out prompting for the entry of the Fact Type’s abbreviation. This is the label as seen in the Edit Person screen. By entering the wildcard character (%), all Fact Types having the Description enabled will be processed.

— adapted from Events – Move Short Note to Description

One Reply to “Events – Move Description to Note #events #notes

  1. When I run this I get an error. Here is the message

    cannot start a transaction within a transaction SQL Statement: — EventDescriptionToNote-Move.sql /* 2016-05-08 Tom Holden ve3meo — adapted from EventNoteToDescription-Move.sql Moves content from Event Description (Details) to Event Note.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.