Question Reports

Bogie wrote:

Would it be imaginable to integrate a report generator where SQL statements could be handed over with the respective result columns to be used for report output?
In that case you could test your SQL statements under mySQLadmin before and c&p it to the webtrees report generator.
That would open up many ways of individual reports only limited by your SQL knowledge and experience.

Take a look at the database model and you'll understand why you cannot simple pick the the required columns from various tables. I am not saying this is impossibe. It is just too difficult for the average webtrees administrator.

On the other hand I'd very much appreciate a custom module which can run SQL statements or stored procedures and display the result within webtrees. Like these www.webtrees.net/index.php/en/forum/9-re...issing-sources#88428

Sir Peter wrote:

Take a look at the database model and you'll understand why you cannot simple pick the the required columns from various tables. I am not saying this is impossibe. It is just too difficult for the average webtrees administrator.

Some of my examples further up contains SQL syntax from 2 or 3 joined tables. I'm using them for locating data inconsistencies or missing data. It might be too difficult for average users but RegEx is sophisticated, too and is supported anyway, even in the forum.

Sir Peter wrote:

On the other hand I'd very much appreciate a custom module which can run SQL statements or stored procedures and display the result within webtrees. Like these www.webtrees.net/index.php/en/forum/9-re...issing-sources#88428

Exactly, that points in the right direction.

Ken says: "PDF, .docx and .odt files. I prefer .docx ...".
PDFs are difficult to edit unless you purchase Adobe software. They're great if you don't want the recipient to edit your document.
.docx is a Microsoft morass.
I'm not familiar with .odt; I've never seen one in the wild.

What's worked well for me for many years is .rtf - Rich Text Format. It supports almost everything that .docx supports, and is readily generated by and read by the major systems Ken names.

Hope this helps,

-Ed.

Pdf et .odt
.docx m'oblige à pirater office...

Auf diese Ausgabemöglichkeiten warte ich schon eine ganze Weile. Dazu gehört auch eine Druckmöglichkeit bzw. PDF-Erstellung sowie die Übergabe an Word von Berichdas Personen-Modul zu nennen. ten und Erweiterungen.
Ich benötige die vorgenannten Funktionen recht häufig, wenn ich für Interessenten Auszüge aus meiner Datensammlung machen möchte.
Zur Abfrage, welche Berichte relevant sind, wäre an erster Stelle das Personenmodul zu nennen. Hier fehlt die Möglichkeit der Auswahl von Familiennamen (ggf. Gruppierung) und deren Export als Liste mit Familiennamen, Vornamen Geburts- und Todestag, Tauf- und Heiratstag, dazu die jeweiligen Orte. Es sollte jeweils eine Auswahl der einzelnen Datenbestandteile und ein Einfluss auf die Gestaltung möglich sein. Ebenfalls ist das Modul Statistiken in Gänze zu überarbeiten. Zum Beispiel fehlen Statistiken zu der Anzahl gestorbener Kinder, Totgeburten, Heiraten mit Heiratsalter, Anzahl der Witwen und Witwer, Berufestatistik und so weiter. Graphiken sollten mit Datenlisten und Legenden versehen und exportierbar sein.
Das sollte zunächst genügen (viel Arbeit).

It was a bit of a vanity but I did write one report. Plenty of Australians are interested in having convict ancestors. On my tree I added that as an OCCU fact. Then I wrote a report based on the ancestors of an individual, filtering where the occupation was convict. Voila, list of convict ancestors.

hermann wrote:

Ken, they have three products. I never used the very outdated Software "The Complete Genealogy Builder". I only use the really good "The Complete Genealogy Reporter (TCGR)". A special version of this software is offered as a SaS by MyHeritage. I'm using that software for many years and have produced three printed books and about 20 pdf books.

TCGR is supporting GEDCOM 5.5 and 5.5.1, but not GEDCOM-L, so there is no support for _LOC.

I would want TCGR to generate name indexes, place indexes and Mapping references. Does it do these things?

Yes, you have to select a person (proband) in your tree. The report is tailored for that person. It contains (as you choose): blood-related persons, indirect persons (relatives by marriage), connected persons (godmother, ...), and not connected persons (if you like complete documentation of your tree). For all those persons in the report, several name indexes can be produced. TCGR produces a chapter with maps for the locations. You can provide images of old maps. TCGR produces a report of locations (based on PLAC). You can add one image and text describing each location. If you have a NOTE for a location record (_LOC), you have to copy manually that text to a TCGR configuration file. You can write your own introduction to each chapter.

So for this thread about "webtrees Reports": It would be great if it would be possible to have at the end a webtrees report producing a printed book. The important concept for that is

• select a proband and the persons to be included in the report (ancestors, descendants, blood-related, indirect, connected, not connected), sort and filter them
• provide specialized report chapters (introduction, statistics, an overview about ancestors and descendants, narrative report for all persons, printable tree diagrams, report on locations, dates, name indexes)
• provide cross reference numbers for all the persons in a report (used in all chapters)
• support all webtrees languages
• allow the user to add a custom introduction to each chapter/report (text and images) like an HTML block or a story

Hello, I have to say that this is a great function. If this module is implemented,
it will really be a great design.
I am already looking forward to the function of this module.
I hope this module can support Chinese and prevent exported PDFs. Chinese is gibberish.

Dear xiao, to develop such a module would be an enormous task. 

Have you seen the custom module:  ExportFamilyBook  from Thorsten Oest?    

edsch wrote:

Ken says: "PDF, .docx and .odt files. I prefer .docx ...".
PDFs are difficult to edit unless you purchase Adobe software. They're great if you don't want the recipient to edit your document.
.docx is a Microsoft morass.
I'm not familiar with .odt; I've never seen one in the wild.

What's worked well for me for many years is .rtf - Rich Text Format. It supports almost everything that .docx supports, and is readily generated by and read by the major systems Ken names.

Hope this helps,

-Ed.

Sorry it took me a while to respond to this.

1) PDF: You don’t need to purchase Adobe to work with PDF files. MS-Word will edit them, Their are cheaper 3rd party programs too! PDF is non-proprietary!
2) .docx can be read by other 3rd part software as well, is well supported in most environments, I use it a lot at home.
3) .odt is an OpenOffice Document file. These documents are typically created using programs like Apache OpenOffice Writer and LibreOffice Writer, word processors comparable to Microsoft Word and Google Docs. ODT files are similar to file formats created using Word, such as DOCX and DOC. They contain formatted text, images, links, and page information used for document creation and printing.

I’m not a fan of .rtf files because they are an old format and support for them in the publishing world is non-existent! The self publisher I have worked with in the past does not take .rtf but will take .pdf, .docx and .odt files

hermann wrote:

Dear xiao, to develop such a module would be an enormous task. 

Have you seen the custom module:  ExportFamilyBook  from Thorsten Oest?    

Hello, "ExportFamilyBook" is really a very professional module.
I'm very ashamed that I don't have any knowledge about tex format files.

The report module is out of date imo. Lists are the way. In lists can be generated as different output. Imo there should not be anything we can do with list. Just some fields to choose from which data we want in the list. Missing data is one I really miss.
Carmen made a good report. Just missing a output choice. Nigel made a lot of lists for view. I doubt  Any of kt users missed one or used report module.
A huge list with alot of chosen fields could be made as batch too. Just my 5cent

I understand your point and agree that we can do many things with lists. But I want to share my findings with relatives that don't want to or even cannot use a tool like webtrees. The threshold is much too high. For them I have a few pdf reports that are easy to distribute.

.odt format is the default for FREE LibreOffice and OpenOffice. What those who don't like paying for Microsoft use I've used it since going Mocrosoft-free in 2009. Although I do save in Microsoft formats by default to be compatible with others.

One member of my site produced a 600+ PDF report of his family tree. Can't remember name of format but it numbers the generations 1., 1.1, 1.1.1 etc. and splits into generations. I've seen a tree-builder site in that format. It does give a good view of who's who if done right (he repeated stuff too often so got confused).

I'd like to print simple Individual, Family reports with option of tags to use. And, export to CSV option.