Have added Media Objects by hand to my GEDCOM file.
Tried to use the Add Media Tool.
It is not clear to me what I am supposed to fill in the Name and Titel for individuals and for families.
I assume the external file is the same as what I would enter to the GEDCOM file.
Received the following message when tried to use the tool to add xxx by hitting the button:
Notice: Undefined variable: m_titl in /home/meliza/WWW/phpGedView/addmedia.php on line 93
and same for m_file
The top link tells me that the file was updated, although no data was added to the file.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Gedcom INDI record ID - The ID (I0001) of the gedcom record you want the OBJE tags added too.
External File: - The path to the media file ie. ../media/surname.jpg or just surname.jpg
Extension: - This is the type of media file (ie JPEG, GIF, MOV etc)
_PRIM - This is a gedcom tag that specifies if the picture is the primary picture. In PGV this allows you to choose which picture is highlighted on the charts. Setting to Y means it is the highlighted picture. Setting to N will not show the pictiure on the charts. PGV will take the first media OBJE with a Y in the _PRIM tag or the the first image without a _PRIM tag.
Title: This is the human readable title for the file
Order: With this field you can order the media in a gedcom record if you want them to come up in a particular order
Gedcom File: the gedcom this media should be added to.
Follow are examples of fields filled out:
Gedcom INDI record ID: I1
External File: test.jpg
Extension: jpg
_PRIM: Y
Title: John Finlay at age 10
Order: 0
--John
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Sorry Meliza, I forgot to mention that you needed to drop the old pgv_media table from the database.
But, since it would be good to make this version compatible with older versions I have added some table update routines that check if you have an old table. I've posted another new addmedia.php script to the patch listed above.
--John
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Received the following messages without removing the file:
ERROR:Incorrect table definition; There can only be one auto column and it must be defined as a key
SQL:alter table pgv3_media ADD COLUMN m_id INT(11) NOT NULL auto_increment FIRST
ERROR:You have an error in your SQL syntax near 'AFTER m_order' at line 1
SQL:alter table pgv3_media CHANGE COLUMN m_name m_file varchar(255) NOT NULL AFTER m_order
When I try to add a file I receive the following red and blue messages:
ERROR:Incorrect table definition; There can only be one auto column and it must be defined as a key
SQL:alter table pgv3_media ADD COLUMN m_id INT(11) NOT NULL auto_increment FIRST
ERROR:Can't DROP 'm_indiname'. Check that column/key exists
SQL:alter table pgv3_media drop COLUMN m_indiname
ERROR:Unknown column 'm_file' in 'pgv3_media'
SQL:alter table pgv3_media CHANGE COLUMN m_file m_gedfile varchar(255) NOT NULL
ERROR:You have an error in your SQL syntax near 'AFTER m_order' at line 1
SQL:alter table pgv3_media CHANGE COLUMN m_name m_file varchar(255) NOT NULL AFTER m_order
Have added Media Objects by hand to my GEDCOM file.
Tried to use the Add Media Tool.
It is not clear to me what I am supposed to fill in the Name and Titel for individuals and for families.
I assume the external file is the same as what I would enter to the GEDCOM file.
Received the following message when tried to use the tool to add xxx by hitting the button:
Notice: Undefined variable: m_titl in /home/meliza/WWW/phpGedView/addmedia.php on line 93
and same for m_file
The top link tells me that the file was updated, although no data was added to the file.
Where can I find explanations on what to fill into the fields in order not to receive the messages on Undefined variables?
Hi Meliza,
I looked again at the Add Media Tool and found that it was not functional, so I updated it with a patch here:
http://sourceforge.net/tracker/index.php?func=detail&aid=893712&group_id=55456&atid=477081
The fields are:
Gedcom INDI record ID - The ID (I0001) of the gedcom record you want the OBJE tags added too.
External File: - The path to the media file ie. ../media/surname.jpg or just surname.jpg
Extension: - This is the type of media file (ie JPEG, GIF, MOV etc)
_PRIM - This is a gedcom tag that specifies if the picture is the primary picture. In PGV this allows you to choose which picture is highlighted on the charts. Setting to Y means it is the highlighted picture. Setting to N will not show the pictiure on the charts. PGV will take the first media OBJE with a Y in the _PRIM tag or the the first image without a _PRIM tag.
Title: This is the human readable title for the file
Order: With this field you can order the media in a gedcom record if you want them to come up in a particular order
Gedcom File: the gedcom this media should be added to.
Follow are examples of fields filled out:
Gedcom INDI record ID: I1
External File: test.jpg
Extension: jpg
_PRIM: Y
Title: John Finlay at age 10
Order: 0
--John
Add Media Tool
This file will add media OBJE tags to the gedcom TestPAF.GED.
ERROR:Unknown column 'm_gedfile' in 'where clause'
SQL:SELECT * FROM pgv3_media WHERE m_gedfile='TestPAF.GED' ORDER BY m_indi, m_order
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/meliza/WWW/phpGedView.3/addmedia.php on line 48
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/meliza/WWW/phpGedView.3/addmedia.php on line 49
Sorry Meliza, I forgot to mention that you needed to drop the old pgv_media table from the database.
But, since it would be good to make this version compatible with older versions I have added some table update routines that check if you have an old table. I've posted another new addmedia.php script to the patch listed above.
--John
Received the following messages without removing the file:
ERROR:Incorrect table definition; There can only be one auto column and it must be defined as a key
SQL:alter table pgv3_media ADD COLUMN m_id INT(11) NOT NULL auto_increment FIRST
ERROR:You have an error in your SQL syntax near 'AFTER m_order' at line 1
SQL:alter table pgv3_media CHANGE COLUMN m_name m_file varchar(255) NOT NULL AFTER m_order
ERROR:Key column 'm_id' doesn't exist in table
SQL:alter table pgv3_media ADD PRIMARY KEY(m_id)
When I try to add a file I receive the following red and blue messages:
ERROR:Incorrect table definition; There can only be one auto column and it must be defined as a key
SQL:alter table pgv3_media ADD COLUMN m_id INT(11) NOT NULL auto_increment FIRST
ERROR:Can't DROP 'm_indiname'. Check that column/key exists
SQL:alter table pgv3_media drop COLUMN m_indiname
ERROR:Unknown column 'm_file' in 'pgv3_media'
SQL:alter table pgv3_media CHANGE COLUMN m_file m_gedfile varchar(255) NOT NULL
ERROR:You have an error in your SQL syntax near 'AFTER m_order' at line 1
SQL:alter table pgv3_media CHANGE COLUMN m_name m_file varchar(255) NOT NULL AFTER m_order
ERROR:Key column 'm_id' doesn't exist in table
SQL:alter table pgv3_media ADD PRIMARY KEY(m_id)
Notice: Undefined index: m_id in /home/meliza/WWW/phpGedView.3/addmedia.php on line 51
Notice: Undefined index: m_file in /home/meliza/WWW/phpGedView.3/addmedia.php on line 53
Notice: Undefined index: m_file in /home/meliza/WWW/phpGedView.3/addmedia.php on line 55
and when I continue I receive:
Updating is dead status for INDI
&
Import Complete
In the Multimedia page I see:
Warning: getimagesize: Read error! in /home/meliza/WWW/phpGedView.3/medialist.php on line 89
An entry (without a thumbnail) is added to the Multimedia page. When I click on it I see:
Index of /~meliza/phpGedView.3/media