Page 1 of 1

Exporting SQL Query to text file

Posted: Sun Oct 14, 2018 6:03 pm
by JohnBallard
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?



Re: Exporting SQL Query to text file

Posted: Sat Nov 17, 2018 12:13 pm
by JohnBallard
*** Bump ***

Re: Exporting SQL Query to text file

Posted: Tue Nov 20, 2018 9:08 am
by Nick Hunter
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.