automatic input in many records

[Appelmus 0]

Hello!
In over 7000 records are very many married couples where the marriage field is empty. Is there an automated way to put a capital Y in the empty marriage field or do I have to do it all by hand?

[theKiwi 0]

You could do this in phpMyAdmin pretty easily I think - open up the tng_families table , and run a query on it of the form

update tng_families set marrdate = "Y" where marrdate = ""

or something like that (Not sure that's correct syntax. You can probably also do it in a Report in TNG Admin.

Make a backup of that table first!

Roger

[Appelmus 0]

Thank you very much, I will try! 

[Rob Roy 0]

Appelmus, let us know if it works.  Would save me a lot of work as well.

[Rob Severijns 0]

Appelmus,

This could lead to potential conflicts with mods that calulate with dates like Age at marriage or Age at event made by @Michel KIRSCH

Not enttrely sure about that though.

Rob

[theKiwi 0]

1 hour ago, Rob Severijns said:

This could lead to potential conflicts with mods that calulate with dates like Age at marriage or Age at event made by @Michel KIRSCH

Not enttrely sure about that though.

I'm pretty sure Y is a valid entry in the Date field of an event, so any Mods that try and do calculations on the date field are already accounting for the possible presence of Y anyhow. It would depend what value is expected in the marrdatetr field. In my database for people who I've given a death date of "?", their marrdatetr is 000-00-00 which is an invalid date, so will be ignored.

Roger

[Appelmus 0]

Hello!
The solution that thekiwi has formulated works. Thanks again for that.
My experience in detail:
I opened the database of my test site with phpMyadim and selected the tng_families there. The partial database was displayed. In the upper menu bar I selected SQL and selected UPDATE from the various options in the input window. I then copied the query into the input window.
Everything else is self-explanatory.

 

PS

Also works on the live website

[Michel KIRSCH 0]

On 1/21/2022 at 8:30 PM, Rob Severijns said:

This could lead to potential conflicts with mods that calulate with dates

No problem for me.

Michel