Search found 106 matches

by British Kiwi
08 Jul 2022 10:56
Forum: Plugin Technical Support & Development
Topic: Country Summary Help
Replies: 42
Views: 4824

Re: Country Summary Help

As the Help for fhOutputResultSetColumn(...) says for the tblData parameter: "The table must be a simple indexed table." Your tblCountry now is a nested structure with country name keys, so it is not a simple table indexed by integer keys. It may be convenient to manage the data in such a...
by British Kiwi
08 Jul 2022 10:41
Forum: Plugin Technical Support & Development
Topic: Country Summary Help
Replies: 42
Views: 4824

Re: Country Summary Help

The result set column needs a simple flat table for each column. Personally I tend to require fhUtils and using the included createResultSet function. That way you can simply loop through your result table and push it over into an output set. The instructions for use are here: http://pluginstore.fa...
by British Kiwi
07 Jul 2022 12:59
Forum: Plugin Technical Support & Development
Topic: Country Summary Help
Replies: 42
Views: 4824

Re: Country Summary Help

Evening, me again! So I have managed to finish my plugin which includes burials, christenings, marriages etc. I need to fully test, but seems to work fine. After having a break (school holidays!) I decided to try using nested tables (if that is the right term). I think I have finally cracked it, kin...
by British Kiwi
22 Jun 2022 20:42
Forum: Plugin Technical Support & Development
Topic: Country Summary Help
Replies: 42
Views: 4824

Re: Country Summary Help

Yes, that is a great improvement but you can put local before the first use of each variable as you have done elsewhere like this: --[[ @Title: Country of Birth Summary Report @Type: Standard @Author: Melanie Marsh @Version: 0.2 @Keywords: Country, Birth, Death @LastUpdated: 21/06/2022 @Licence: Th...
by British Kiwi
22 Jun 2022 11:44
Forum: Plugin Technical Support & Development
Topic: Country Summary Help
Replies: 42
Views: 4824

Re: Country Summary Help

Mike, I am always happy for suggestions, best way to learn. I just didn't want to impose on all your time! I think I managed to incorporate all the changes. --[[ @Title: Country of Birth Summary Report @Type: Standard @Author: Melanie Marsh @Version: 0.2 @Keywords: Country, Birth, Death @LastUpdated...
by British Kiwi
22 Jun 2022 08:42
Forum: Plugin Technical Support & Development
Topic: Country Summary Help
Replies: 42
Views: 4824

Re: Country Summary Help

ColeValleyGirl wrote: ↑22 Jun 2022 08:19 If you use the </> icon above your post, you can format the code as code which makes it easier to read.
Great thanks. I wondered how that was happening. Thought the forum fairies were at work πŸ˜† Much clearer, thanks 😊
by British Kiwi
22 Jun 2022 07:28
Forum: Plugin Technical Support & Development
Topic: Country Summary Help
Replies: 42
Views: 4824

Re: Country Summary Help

Et voila! I'm next going to look at nested tables, or tidying up the inserting to the result tables. --[[ @Title: Country of Birth Summary Report @Type: Standard @Author: Melanie Marsh @Version: 0.2 @Keywords: Country, Birth, Death @LastUpdated: 21/06/2022 @Licence: This plugin is copyright (c) 2022...
by British Kiwi
21 Jun 2022 20:41
Forum: Plugin Technical Support & Development
Topic: Country Summary Help
Replies: 42
Views: 4824

Re: Country Summary Help

tatewise wrote: ↑21 Jun 2022 12:57 The Surname Summary Report plugin calls main() on the very last line of the script.
Oops, yes now I see it. I think in VBA you didn't have to have all the functions first. Thanks :)
by British Kiwi
21 Jun 2022 12:26
Forum: Plugin Technical Support & Development
Topic: Country Summary Help
Replies: 42
Views: 4824

Re: Country Summary Help

Yes I wasn't calling it and couldn't work out how or where to. The case sensitive I had consistent at one point and had the same result, so have fixed that. I've now managed to get it to work. I think my confusion was that I was trying to call the function before it read the functions so I wrote: ma...
by British Kiwi
21 Jun 2022 11:31
Forum: Plugin Technical Support & Development
Topic: Country Summary Help
Replies: 42
Views: 4824

Re: Country Summary Help

Thanks Mark and Helen. I will plow through those. I have tomorrow off so will sneak some reading time. I have managed to incorporate some of the tips and suggestions and it is looking better. However, for some reason I am having difficulties calling functions which is a little weird. I had a look at...
by British Kiwi
20 Jun 2022 22:05
Forum: Plugin Technical Support & Development
Topic: Country Summary Help
Replies: 42
Views: 4824

Re: Country Summary Help

Thanks to everyone that's helped. I was so pleased it output what I wanted. I wasn't too keen on the repetitive code so the tips from Mike and Mark I will try tonight. I like to try and stick to standard conventions but I haven't worked out what they are but your feedback should help. I'm back on th...
by British Kiwi
20 Jun 2022 12:00
Forum: Plugin Technical Support & Development
Topic: Country Summary Help
Replies: 42
Views: 4824

Re: Country Summary Help

Thanks. I realised how much I enjoy programming (not enough to go back to it though, although it was only ever part of my job), so this has been fun. So, I finally have a combined table, I think i need to add a few "local" added and need to declare some variables, but this is what I have: ...
by British Kiwi
20 Jun 2022 07:23
Forum: Plugin Technical Support & Development
Topic: Country Summary Help
Replies: 42
Views: 4824

Re: Country Summary Help

Okay I'll try that when I get home.

A table of tables sounds good too. Maybe I will continue how I'm going and then investigate the table of tables. I have found a lot of lua you tube videos which I might check out on the train. Maybe an FH expert might like to do one hint, hint πŸ˜‰
by British Kiwi
19 Jun 2022 23:02
Forum: Plugin Technical Support & Development
Topic: Country Summary Help
Replies: 42
Views: 4824

Re: Country Summary Help

Okay that makes sense. So the next trick is to put the two (or more) together. So would you loop through tblBirthCountry and then find the result in tblDeathCountry? And what happens if one country doesn't appear in both tables e g. I have a great aunt born in Crete and no one died there. Is it safe...
by British Kiwi
19 Jun 2022 21:01
Forum: Plugin Technical Support & Development
Topic: Country Summary Help
Replies: 42
Views: 4824

Re: Country Summary Help

Okay great, that makes sense. So let's say everyone has a birth place and a death place for ease. My final table is going to be: Country No of Births No of Deaths England 25 12 Scotland 12 10 Etc If I loop through each INDI and assign the country of birth and death to strBirthCountry and strDeathCou...
by British Kiwi
19 Jun 2022 11:59
Forum: Plugin Technical Support & Development
Topic: Country Summary Help
Replies: 42
Views: 4824

Re: Country Summary Help

Okay, so switched some of the syntax to: if (tblCountryOfBirths.strCountry == nil) then tblCountryOfBirths.strCountry = 1 else tblCountryOfBirths.strCountry = tblCountryOfBirths.strCountry + 1 end Code works without errors, however, now the results are just one record Country of Birth Count strCount...
by British Kiwi
19 Jun 2022 11:36
Forum: Plugin Technical Support & Development
Topic: Country Summary Help
Replies: 42
Views: 4824

Re: Country Summary Help

Thanks Mark, that helps a bit. I was stepping through, so could check the variables, but couldn't see the table.

I'm going to have a little play and then I will be back (though struggling to stay awake so if I disappear I've given up for the night!
by British Kiwi
19 Jun 2022 11:03
Forum: Plugin Technical Support & Development
Topic: Country Summary Help
Replies: 42
Views: 4824

Re: Country Summary Help

Thanks for that, I will see how I go with that. I found another topic through the help file all about Tables which is great evening reading :lol: The tip about TextPart has made my day! I was going in circles in a query until I found that function, and now you've made it much easier! Can I ask a que...
by British Kiwi
19 Jun 2022 10:38
Forum: Plugin Technical Support & Development
Topic: Country Summary Help
Replies: 42
Views: 4824

Country Summary Help

Good evening, from wintery Melbourne. I have been having a little play with adding some icons to my diagrams and decided I wanted to get a summary of what countries my ancestors were born and died in. After coming a little short in queries, I decided to finally jump into writing a plugin. I used to ...
by British Kiwi
25 Apr 2022 06:54
Forum: General Usage
Topic: Queries - missing sources for BMD
Replies: 5
Views: 946

Re: Queries - missing sources for BMD

Thanks Mike. I forgot about that plugin. Though I'm focusing on the french side of things so not sure how useful for that half of the tree will be. My laptop has survived so will try it tonight and see what it looks like.
by British Kiwi
24 Apr 2022 08:51
Forum: General Usage
Topic: Queries - missing sources for BMD
Replies: 5
Views: 946

Re: Queries - missing sources for BMD

Yes I suspect I need to include it in my workflow. It crossed my mind a while ago and now I'm reaping the cost if not doing it.

I have checked the plugin store but not recently. Though my laptop may have died so will have to wait! So annoying when I was on a roll!
by British Kiwi
23 Apr 2022 23:37
Forum: General Usage
Topic: Queries - missing sources for BMD
Replies: 5
Views: 946

Re: Queries - missing sources for BMD

I've been having another look today and for some reason the duplicate line I thought there was, is no longer there. It seems that my column/expression looks at the first source listed. So it looks for the query to do what I can do I need to ensure that any birth register sources are the first source...
by British Kiwi
23 Apr 2022 21:52
Forum: General Usage
Topic: Queries - missing sources for BMD
Replies: 5
Views: 946

Queries - missing sources for BMD

Good morning from chilly Melbourne Quick questions about queries (and not the end of the world if it can't be done) I have based a query on the missing census query to produce a list of people and whether they have a specific source for birth or death entries. Works quite well with one exception. Th...
by British Kiwi
23 Dec 2020 21:32
Forum: Ancestral Sources
Topic: Autotext query
Replies: 2
Views: 1723

Re: Autotext query

Thanks Mike for the reply. Yes I would be manually tweaking regardless. At least this will do most of the work for me.
by British Kiwi
23 Dec 2020 10:34
Forum: Ancestral Sources
Topic: Autotext query
Replies: 2
Views: 1723

Autotext query

Hi everyone Sorry if this has been repeated. Looks like I forgot to press submit, oops! I have cloned one of the birth templates to make a french birth civil register. For the majority of it, I have managed to adapt it, however, I have a few things I would like to do and am not too sure. For both pa...