Web based family history software

This Help forum is for issues relates to the latest release (1.6.x). For issues related to beta or github version please use their own Help forum.
Before asking for help please read "How to request help" by clicking on that tab above here.

Question default value in notes ?

  • ofb
  • Topic Author
  • Visitor
  • Visitor
9 years 1 month ago #1 by ofb
default value in notes ? was created by ofb
Hi,

at first I'm sorry for my terrible English. Anyway I try to solve a problem.

Example:
www.ofb-aken.de/webtrees/individual.php?...I3824&ged=OFB%20Aken

The value "unvollständig" I would like to enter in each record. So I'm looking for a script or a mysql command for that.

"unvollständig" I found in my database in table xxx_name n_id N2 and n_id N49 (because I have two family trees). n_sort and n_full = "unvollständig".

Now should the value "unvollständig" writing in each record, in each existence and each new record.

What can I do?
Thanks for help.

Silvia

Please Log in or Create an account to join the conversation.

  • fisharebest
  • Away
  • Administrator
  • Administrator
More
9 years 1 month ago #2 by fisharebest
Replied by fisharebest on topic default value in notes ?
For each existing record. Easy.

UPDATE wt_individuals SET i_gedcom = CONCAT(i_gedcom, '\n1 NOTE @N49@);

Export to a GEDCOM file.
Import the GEDCOM file.

For each new record. Difficult. Are you a PHP programmer? Update the file edit_interface.php. Everywhere that an individual is created, add the line "1 NOTE @N49@"

Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net

Please Log in or Create an account to join the conversation.

  • ofb
  • Topic Author
  • Visitor
  • Visitor
9 years 1 month ago #3 by ofb
Replied by ofb on topic default value in notes ?
Thank you so much !

I will try it tonight.

I'm not a programmer unfortunately.

> Update the file edit_interface.php.

I have open the file in an editor. And now? In which line should I write "1 NOTE @N49@"

The modified file I can upload via FTP to my server. Than it should works?

Sorry for stupid questions. :)

Please Log in or Create an account to join the conversation.

  • fisharebest
  • Away
  • Administrator
  • Administrator
More
9 years 1 month ago #4 by fisharebest
Replied by fisharebest on topic default value in notes ?

I have open the file in an editor. And now? In which line should I write "1 NOTE @N49@"


It is not that simple.

You need to be a be a PHP programmer, and work out how to modify the code.

There is no simple instruction to give you.

Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net

Please Log in or Create an account to join the conversation.

  • ofb
  • Topic Author
  • Visitor
  • Visitor
9 years 1 month ago - 9 years 1 month ago #5 by ofb
Replied by ofb on topic default value in notes ?
Ok, thanks. But last try...

I would like to explain my problem.
If I put a new person in the family tree, the record is incomplete. There are no sources (or maybe only one), maybe I have only the birthday but not the day of death and so on. After searching in church register I find some new information. I put it in the family tree and anytime the record is complete. Than I delete "unvollständig" ("incomplete").

Maybe my way is only too complicated. I need any array what I can use as a place holder. It can be also the postal code 99999 or "XXX" in adress or something like that.
But the problem is the same probably. Because for each existing and each new record.

Any ideas how to solve?
Last edit: 9 years 1 month ago by ofb.

Please Log in or Create an account to join the conversation.

More
9 years 1 month ago - 9 years 1 month ago #6 by Jackie
Replied by Jackie on topic default value in notes ?

ofb wrote: Ok, thanks. But last try...

I would like to explain my problem.
If I put a new person in the family tree, the record is incomplete. There are no sources (or maybe only one), maybe I have only the birthday but not the day of death and so on. After searching in church register I find some new information. I put it in the family tree and anytime the record is complete. Than I delete "unvollständig" ("incomplete").

Maybe my way is only too complicated. I need any array what I can use as a place holder. It can be also the postal code 99999 or "XXX" in adress or something like that.
But the problem is the same probably. Because for each existing and each new record.

Any ideas how to solve?


Hello ofb,
My understanding of what you are trying to explain, is exactly what the tag "Research task" does. Did you try it? Does it correspond to what you want?

EDIT: Research task = Forschungsaufgabe
Last edit: 9 years 1 month ago by Jackie.

Please Log in or Create an account to join the conversation.

More
9 years 1 month ago - 9 years 1 month ago #7 by Jackie
Replied by Jackie on topic Research tasks settings
Hello,

Here is an example of a « Research task » added to an individual file. (sorry for the mix of French and English, it is caused by my brain..)



Please note that you may add a block "Research task" on your "My Page" page. That block lists all "Research tasks" added in your family tree. Though, if you add a _TODO (GEDCOM tag for research task) to each individual in your tree, that block would need too much ressources from your server. I would not recommend it.
Attachments:
Last edit: 9 years 1 month ago by Jackie.

Please Log in or Create an account to join the conversation.

More
9 years 1 month ago - 9 years 1 month ago #8 by Jackie
Replied by Jackie on topic Research tasks settings
Hello,

Here is a screen capture of what the block _TODO looks like..

Attachments:
Last edit: 9 years 1 month ago by Jackie.

Please Log in or Create an account to join the conversation.

More
9 years 1 month ago - 9 years 1 month ago #9 by Jackie
Replied by Jackie on topic Research tasks settings
Hello,

Be sure to have the "Research task" in your "Fact or event" list.

Go to : Administration -> Family trees -> your family tree -> "Edit options" tab -> "Facts for individual records" section -> "All individual facts" list -> click on the icon and be sure the _TODO checkbox is ticked.




Attachments:
Last edit: 9 years 1 month ago by Jackie.

Please Log in or Create an account to join the conversation.

More
9 years 1 month ago - 9 years 1 month ago #10 by Jackie
Replied by Jackie on topic Research tasks settings
Hello,

Another setting that I would recommend is to put a privacy restriction on _TODO tag. I set it to "Show to members" in my own tree. I don't want public visitors to see those research tasks.

Go to : Administration -> Family tree -> your family tree -> Privacy tab -> Privacy restrictions section

Attachments:
Last edit: 9 years 1 month ago by Jackie.

Please Log in or Create an account to join the conversation.

  • ofb
  • Topic Author
  • Visitor
  • Visitor
9 years 1 month ago - 9 years 1 month ago #11 by ofb
Replied by ofb on topic default value in notes ?
Hello Jackie,

thanks for help!

I already use that tag (hidden, only for adminstrator). But I think it isn't perfect. Because I would like to use anything what I can sort. I mean a list like results from search or advanced search.

There are already about 5000 records and every day we collect a lot of new ones. That's why I'm looking for an easier solution.

I thought about the batch processing. That's a great instrument. I tried following:
search = 23 FEB 2015 (date of last change)
replace = 1 JAN 1999
So I can search in advanced search to 1999 and sort the results. Fine.
But is the record complete it shouldn't get the date 1999 again.

I also thought about an export to a another programm for example Gramps. There are a lot of marker. But when I export a new gedcom the old marker going to ruin of course. The solution could be a programm which is reading only the updated records during the import. I don't know that kind of programm.

webtrees is a really great programm. I'm so happy about it. If it has marker it would be perfect.
Last edit: 9 years 1 month ago by ofb.

Please Log in or Create an account to join the conversation.

More
9 years 1 month ago #12 by Jackie
Replied by Jackie on topic default value in notes ?

ofb wrote: Hello Jackie,

thanks for help!

I already use that tag (hidden, only for adminstrator). But I think it isn't perfect. Because I would like to use anything what I can sort. I mean a list like results from search or advanced search.

There are already about 5000 records and every day we collect a lot of new ones. That's why I'm looking for an easier solution.

I thought about the batch processing. That's a great instrument. I tried following:
search = 23 FEB 2015 (date of last change)
replace = 1 JAN 1999
So I can search in advanced search to 1999 and sort the results. Fine.
But is the record complete it shouldn't get the date 1999 again.

I also thought about an export to a another programm for example Gramps. There are a lot of marker. But when I export a new gedcom the old marker going to ruin of course. The solution could be a programm which is reading only the updated records during the import. I don't know that kind of programm.

webtrees is a really great programm. I'm so happy about it. If it has marker it would be perfect.


Hello,

Why can't you use "Advanced search" and filter "Research task"?

The only reason I can think of to not being able to use "Research task" in "Advanced search" is that would put a lot of pressure on your server. BUT, it is feasible, and it will give you the same kind of results (sortable) as any other "Advanced search".

By the way, each column of Research tasks' block is sortable just by clicking on the label. Did you know? Of course, you would need to be more inventive in the text column and not only write the word "incomplete".

Attachments:

Please Log in or Create an account to join the conversation.

  • ofb
  • Topic Author
  • Visitor
  • Visitor
9 years 1 month ago #13 by ofb
Replied by ofb on topic default value in notes ?
Hello Jackie,

thanks for help again.

Of course I can use advanced search + research task. The result would be fine. But in this case I have to put the marker "incomplete" by hand. It needs time and maybe I forget it. Apart from that we are three user they work at that family tree. All of us are forgetful. :)

A guy from a german forum told me something about a Trigger. I have no idea how to use but it seems to be a good way.

CREATE TRIGGER <trigger_name>
{AFTER} {INSERT}
ON <table_name>

and so on....

Please Log in or Create an account to join the conversation.

  • bertkoor
  • Away
  • Platinum Member
  • Platinum Member
  • Greetings from Utrecht, Holland
More
9 years 1 month ago #14 by bertkoor
Replied by bertkoor on topic default value in notes ?
By definition research is never totally complete.
So why bother recording that in the database.
You have what you have, maybe more will follow, maybe not.
I'd put a disclaimer at the page footer, much easier!

stamboom.BertKoor.nl runs on webtrees v1.7.13

Please Log in or Create an account to join the conversation.

  • ofb
  • Topic Author
  • Visitor
  • Visitor
9 years 1 month ago - 9 years 1 month ago #15 by ofb
Replied by ofb on topic default value in notes ?
Hi bertkoor,

I agree. In general you're right.

We work on a bit special family tree. It's not really for a family. It's a family tree for a place. (How to explain in English?) In that family tree should be all persons they lived for example in Berlin Germany from 1650 to 1900. Only an example! Because Berlin is too big for that. So we interpret church register and other primary sources. Every event (birth, wedding, death) should have a source.

Look...
ofb.genealogy.net/

and
ofb.genealogy.net/duehringshof/

This one I created in webtrees.

ofb.genealogy.net/famreport.php?ofb=dueh...HLOFF&modus=&lang=de

Two events have a source and birth source is missing yet. So the record is incomplete and I need to search again.

Of course we can work without that "incomplete" (or every other marker) but it would be a lot easier.
Last edit: 9 years 1 month ago by ofb.

Please Log in or Create an account to join the conversation.

  • thomas52
  • Offline
  • Premium Member
  • Premium Member
  • Western North Carolina
More
9 years 1 month ago #16 by thomas52
Replied by thomas52 on topic default value in notes ?
Would not "Research Task" & enter "Incomplete" suffice?

"Failure is an amazing teacher." (L'échec est un professeur extraordinaire.)

Please Log in or Create an account to join the conversation.

  • ofb
  • Topic Author
  • Visitor
  • Visitor
9 years 1 month ago #17 by ofb
Replied by ofb on topic default value in notes ?
It would be suffice absolutly.
But it would be an asset when that value is writing _automaticly_ in the record. Every time when I create a new record. That's my only question here.
Maybe too difficult but I don't give up quickly. ;)

Please Log in or Create an account to join the conversation.

More
9 years 1 month ago - 9 years 1 month ago #18 by Jackie
Replied by Jackie on topic default value in notes ?

ofb wrote: It would be suffice absolutly.
But it would be an asset when that value is writing _automaticly_ in the record. Every time when I create a new record. That's my only question here.
Maybe too difficult but I don't give up quickly. ;)


Hello,

Then, Greg's answers #2 and #4 above are the solution

You need to modify the code.

For each existing record. Easy. ;-)

UPDATE wt_individuals SET i_gedcom = CONCAT(i_gedcom, '\n1 NOTE @N49@);

Export to a GEDCOM file.
Import the GEDCOM file.

For each new record. Difficult. Are you a PHP programmer? Update the file edit_interface.php. Everywhere that an individual is created, add the line "1 NOTE @N49@"

Last edit: 9 years 1 month ago by Jackie.

Please Log in or Create an account to join the conversation.

Powered by Kunena Forum
}