Jump to content


Photo

Creating a report of all photos & descriptions?

report media

  • Please log in to reply
1 reply to this topic

#1 katinka111

katinka111

    Member

  • Members
  • PipPip
  • 16 posts

Posted 30 October 2012 - 10:29 AM

I would like to create a report of all media/photos I have in my database. Is there a way to do this?

If so, is there a way to include all descriptions (the photo description, the PERSON (surname, given name), BIRTH, AND the 'media' NOTES within RM?) I usually don't specify all this in the photo properties (caption, description)

#2 TomH

TomH

    Advanced Member

  • Members
  • PipPipPip
  • 6084 posts

Posted 30 October 2012 - 11:47 AM

1. Reports > Lists > Multimedia List lists the path/filename of each media item and what it is tagged to but does not give the Caption, Description, birth date. There are no Media Notes that I know of (there is a Note field in the CitationTable but it is unused to the best of my knowledge).

2. The SQLite query described at http://sqlitetoolsfo...sers List Query may satisfy your need. The non-graphic version of it is also included in RMtrix .

Tom user of RM7550 FTM2017 Ancestry.ca FamilySearch.org FindMyPast.com
SQLite_Tools_For_Roots_Magic_in_PR_Celti wiki, exploiting the database in special ways >>> RMtrix-tiny.png app, a bundle of RootsMagic utilities.