Jump to content
TNG Community
Paul Barrett

Custom Media Collections

Recommended Posts

Paul Barrett

Just been reading the wiki help on Media Collections because I want to divide my documents up into smaller groups such as births, death, marriages, census etc.

There's a field on the "Add Collection" screen called "Export As:" that defaults to "PHOTO"

2017-08-09_17-07-48.png

What's the purpose of this field please?

 

Regards

 

Payl

Share this post


Link to post
Share on other sites
stores

The Help file explains it as..

Export as

When you export a GEDCOM file that includes media, the file will contain a line for each item indicating what type of media it is. This should be a single word in uppercase. For example, a photo will be exported with the type "PHOTO". If you are creating a new Collection called "Newspapers", you may want to put "NEWSPAPER" in this field.

Share this post


Link to post
Share on other sites
Paul Barrett
17 minutes ago, stores said:

The Help file explains it as..

Export as

When you export a GEDCOM file that includes media, the file will contain a line for each item indicating what type of media it is. This should be a single word in uppercase. For example, a photo will be exported with the type "PHOTO". If you are creating a new Collection called "Newspapers", you may want to put "NEWSPAPER" in this field.

Thank you!

I added it to the Wiki

Share this post


Link to post
Share on other sites
Ken Roy

Paul,

I added the following note to what you added to the wiki article

Note that if you are exporting a GEDCOM to be imported into a genealogy desktop program that only recognizes PHOTO as the media type, you may want to leave the Export As value as PHOTO.  See Export Media For Desktop

Since this field was added to TNG to allow control of how the media collection is exported.  Some desktop programs only recognize PHOTO as a media type.

 

Share this post


Link to post
Share on other sites
Paul Barrett
1 hour ago, Ken Roy said:

Paul,

I added the following note to what you added to the wiki article

Note that if you are exporting a GEDCOM to be imported into a genealogy desktop program that only recognizes PHOTO as the media type, you may want to leave the Export As value as PHOTO.  See Export Media For Desktop

Since this field was added to TNG to allow control of how the media collection is exported.  Some desktop programs only recognize PHOTO as a media type.

 

Thanks Ken

So if you are gedcomming out of and into TNG you would want to export as the custom collection type but for other programs you would need to check what they accept and adjust the settings accordingly?

 

Paul

Share this post


Link to post
Share on other sites
theKiwi
5 hours ago, Ken Roy said:

Paul,

I added the following note to what you added to the wiki article

Note that if you are exporting a GEDCOM to be imported into a genealogy desktop program that only recognizes PHOTO as the media type, you may want to leave the Export As value as PHOTO.  See Export Media For Desktop

Since this field was added to TNG to allow control of how the media collection is exported.  Some desktop programs only recognize PHOTO as a media type.

 

I think that most software would support PHOTO and "DOCUMENT" - some use those two exactly, but for reasons I don't understand Reunion for Macintosh uses "PHOTO DOCUMENT" when it exports a document to a GEDCOM file. I don't know if others support "PHOTO DOCUMENT" or it's just Reunion (and TNG).

Roger

Share this post


Link to post
Share on other sites
theKiwi
4 hours ago, Paul Barrett said:

So if you are gedcomming out of and into TNG you would want to export as the custom collection type but for other programs you would need to check what they accept and adjust the settings accordingly?

Why are you using GEDCOM to move stuff in and out of TNG - if it's from one TNG site to another you should move backups of, or the actual database tables?

Roger

Share this post


Link to post
Share on other sites
Paul Barrett
On 10/08/2017 at 0:32 AM, theKiwi said:

Why are you using GEDCOM to move stuff in and out of TNG - if it's from one TNG site to another you should move backups of, or the actual database tables?

Roger

I'm not.  I was thinking about doing it as a solution to the issue of changing all existing People IDs from I to P but the potential  enormity of the task made be back off.

Paul

Share this post


Link to post
Share on other sites
jayat1familytree

Paul,

ONLY do this on a test database first from phpmyadmin


these are all the  tng_tables that have references to Person ID  (11 tables)

tng_associations.personID
tng_branches.personID
tng_children.personID
dna_links.personID
dna_tests.personID
tng_events.personID
tng_medialinks.personID
tng_mostwanted.personID
tng_people.personID
tng_temp_events.personID
tng_users.personID

replace the "tablename" with one table at a time for each of these to change all instances if personID beginning with I to begin with P

SELECT tng_tablename,personID,  
REPLACE(personID,'I','P')   
FROM tng_tablename   
WHERE personID LIKE 'I%';

 

like this

SELECT tng_people,personID,  
REPLACE(personID,'I','P')   
FROM tng_people 
WHERE personID LIKE 'I%';

repeat for each table one at a time


then need to do the same for each table with persfamID (3 tables)


tng_branchlinks.persfamID
tng_citations.persfamID
tng_notelinks.persfamID


SELECT tng_tablename,persfamID,  
REPLACE(persfamID,'I','P')   
FROM tng_tablename   
WHERE persfamID LIKE 'I%';


Last two fields in the tng_families table
tng_families.husband
tng_families.wife

SELECT tng_families,husband,  
REPLACE(husband,'I','P')   
FROM tng_families   
WHERE husband LIKE 'I%';

SELECT tng_families,wife,  
REPLACE(wife,'I','P')   
FROM tng_families   
WHERE wife LIKE 'I%';

hope that helps.

Jay

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×