Exporting SQL Query to text file
Posted: Sun Oct 14, 2018 6:03 pm
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
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