Hi all,
I have my tree online and was looking for an easy way to list the changed families & people from the previous upload.
Thanks to the topic favourite SQL queries I'm using
--People changed since backup taken
SELECT People.[Description], People.[Change date]
FROM People
WHERE ( People.[Change date] > JDATE('01 jun 2009') )
ORDER BY People.[Change date]
Is there a way to output the result to a text file?
I know I can right click the results list in K&K and save to file but this has some unwanted data at the end of each line; plus it is quoted.
"[P514] Margaret ANSELL","12 Nov 2012","5117821","514"
I've taken to importing the file into Excel, playing with it and then copying the text into another file.
On a slightly similar vein.
Any way to create the output so it is clickable without having to link each person manually?
Best,
John
Exporting SQL Query to text file
Moderator: Nick Hunter
-
- Posts: 4
- Joined: Tue Mar 27, 2018 6:05 pm
Re: Exporting SQL Query to text file
*** Bump ***
-
- Posts: 669
- Joined: Sun Dec 18, 2005 9:36 am
- Location: SpanSoft, Scotland
- Contact:
Re: Exporting SQL Query to text file
Probably the best way to edit the text file output from the query results is to import it into Excel and delete the extra columns. The output is quoted so that it imports into Excel easily.
There is no way of adding a clickable link to each automatically.
There is no way of adding a clickable link to each automatically.