*Custom Query Download Problem

Questions regarding use of any Version of Family Historian. Please ensure you have set your Version of Family Historian in your Profile
HowardRP
Gold
Posts: 28
Joined: 12 Jan 2006 14:54
Family Historian: V5

Custom Query Download Problem

Postby HowardRP » 05 Feb 2019 20:21

Started to dabble with downloading a few custom queries.
Two in particular I have a problem with.
Census Missing Years and
Kinsfolk Census To Do List.
Both downloaded OK and appeared in the query list,
but up popped when selected,
' File is not a valid Family Historian query file '
Am I doing something wrong or is there something missing?
Help much appreciated.

Regards .............Howard

User avatar
tatewise
Megastar
Posts: 15629
Joined: 25 May 2010 11:00
Family Historian: V6.2
Location: Torbay, Devon, UK
Contact:

Re: Custom Query Download Problem

Postby tatewise » 05 Feb 2019 21:11

I have updated those two Queries recently but using FH V6.2, so it is possible they use some feature of V6 that is not supported in V5 that your Profile says you are using.

Can you identify any downloaded Queries that do work OK?

It might then be possible to rectify the issue, but since I currently have no access to FH V5 it may be difficult.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

HowardRP
Gold
Posts: 28
Joined: 12 Jan 2006 14:54
Family Historian: V5

Re: Custom Query Download Problem

Postby HowardRP » 05 Feb 2019 21:44

These two queries do work -

Family Census Facts and
Census By Year Ancesters2

I also downloaded

Census By Year - CS2
(See forum post / Genera l/ FT Analyser information / valkriders post.

This gave the same result as the above which didn't work.

Regards .......H

User avatar
tatewise
Megastar
Posts: 15629
Joined: 25 May 2010 11:00
Family Historian: V6.2
Location: Torbay, Devon, UK
Contact:

Re: Custom Query Download Problem

Postby tatewise » 05 Feb 2019 22:49

I'm sorry but I cannot trace either Family Census Facts or Census By Year Ancesters2 anywhere on the FHUG website.
Where did you obtain them?
I suspect you may have written them yourself?

Please try Knowledge Base > Query:Individual ~ Age at Birth of First Child. Does that one work? It is encoded in ANSI.

It is starting to look as if any Query produced by FH V6 is incompatible with FH V5, probably because they are encoded in Unicode UTF-16 instead of ANSI.

So please try the following to prove my theory.
  1. Use Windows File Explorer to open C:\ProgramData\Calico Pie\Family Historian\Queries\Custom\
  2. Use Windows Notepad to open Kinsfolk Census To Do Table.fhq
  3. Use File > Save As
  4. In Save as type: use drop list to select All Files (*.*) instead of Text Documents (.txt)
  5. In Encoding: use drop list to select ANSI instead of Unicode
  6. Finally click Save
Now try the Query in FH.
Repeat that process for any others that do not work.
Ley me know what happens.
Some Queries may still not run satisfactorily if they use FH V6 new features.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

HowardRP
Gold
Posts: 28
Joined: 12 Jan 2006 14:54
Family Historian: V5

Re: Custom Query Download Problem

Postby HowardRP » 07 Feb 2019 18:52

Hi Mike

Family Census Facts or Census By Year Ancesters2
I'm not sure where they came from being truthful.
As you suggested I may have created the first (I've had it quite a while)
but the second was only downloaded on 31/01/19.
As far as I remember I got it from FHUG website.
It's a mystery but I will carry on looking!

I did download - Age at Birth of First Child and it did work.

I did try as you suggested to prove your theory by doing points 1 to 6,
and Kinsfolk Census To Do Table is now working.

I haven't tried the others yet, but I will let you know.

Appreciate your help.

Regards....Howard

User avatar
tatewise
Megastar
Posts: 15629
Joined: 25 May 2010 11:00
Family Historian: V6.2
Location: Torbay, Devon, UK
Contact:

Re: Custom Query Download Problem

Postby tatewise » 07 Feb 2019 19:57

All the evidence suggests that any Queries produced with FH V6 must be converted from Unicode to ANSI encoding prior to uploading to FHUG so they are FH V5 compatible, OR they must be tagged as being FHVersion6 specific.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

HowardRP
Gold
Posts: 28
Joined: 12 Jan 2006 14:54
Family Historian: V5

Re: Custom Query Download Problem

Postby HowardRP » 07 Feb 2019 22:41

Hi Mike
I think this is the missing download

https://www.fhug.org.uk/wiki/doku.php?i ... us_entries

There appears to be title differences and I assume that is why you couldn't find it.

On the download list................................Query: Individual - Ancestor missing census entries

On the individual download page........Census entries by year and ancestors

After hitting the download button ......Census by year ancestors2

Regards ...Howard

User avatar
tatewise
Megastar
Posts: 15629
Joined: 25 May 2010 11:00
Family Historian: V6.2
Location: Torbay, Devon, UK
Contact:

Re: Custom Query Download Problem

Postby tatewise » 07 Feb 2019 22:49

Excellent, I can confirm that is an old ANSI encoded Query and further supports my theory.
I try to adjust such inconsistently named downloads when I find them, so as to avoid the difficulty we had in locating that one.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

HowardRP
Gold
Posts: 28
Joined: 12 Jan 2006 14:54
Family Historian: V5

Re: Custom Query Download Problem

Postby HowardRP » 08 Feb 2019 19:57

Hi Mike

Just to finish off, the other query downloads are all now working,
after I followed the points 1 to 6 as previously suggested by yourself.

A very happy bunny and I appreciate your help.

Regards............Howard

User avatar
tatewise
Megastar
Posts: 15629
Joined: 25 May 2010 11:00
Family Historian: V6.2
Location: Torbay, Devon, UK
Contact:

Re: Custom Query Download Problem

Postby tatewise » 08 Feb 2019 20:02

Thanks for the feedback Howard.
If I can find time, I will go through the downloads and try to convert all to ANSI.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

User avatar
tatewise
Megastar
Posts: 15629
Joined: 25 May 2010 11:00
Family Historian: V6.2
Location: Torbay, Devon, UK
Contact:

Re: Custom Query Download Problem

Postby tatewise » 09 Feb 2019 21:57

I've gone through the Query downloads and hopefully converted all the Unicode ones to ANSI.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry


Return to “General Usage”

Who is online

Users browsing this forum: No registered users and 11 guests