1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.
  2. If you're looking for the LostCousins site please click the logo in the top left corner - these forums are for existing LostCousins members only.
  3. This is the LostCousins Forum. If you were looking for the LostCousins website simply click the logo at the top left.
  4. Coronavirus Corner - a place to share your hopes, dreams, and frustrations.
  5. Only registered members can see all the forums - if you've received an invitation to join (it'll be on your My Summary page) please register NOW!

Copying your ancestors to a spreadsheet

Discussion in 'Useful features you may have missed.....' started by peter, May 17, 2015.

  1. peter

    peter Administrator Staff Member

    On your My Ancestors page there is a link near the top which reads Show more detail. This displays a text-only version of the page that includes additional information (maiden names and baptism dates, where entered), but more importantly it's easier to copy-and-paste into a spreadsheet.

    If you press Ctrl-A to select the contents of the page, then Ctrl-C to copy them, you can paste them into a blank spreadsheet using Ctrl-V.

    Once you have the data in a spreadsheet you can sort it in any way you want.
     
    • Thanks! Thanks! x 1
  2. Alexander Bisset

    Alexander Bisset Administrator Staff Member

    With a little tweak this could be changed to include "Export details" which would create and allow saved a CSV of the data which could be loaded into a spreadsheet with less effort for the non technical for whom the mysteries of CTRL-A, CTRL-C, CTRL-V are sometimes a challenge.
     
  3. peter

    peter Administrator Staff Member

    Thanks - I did consider that, but as I'm also one of the technically-challenged I didn't know what to tweak or how to tweak it.

    Also, if one of those non-technical users runs into problems (such as not being able to find the file they've just saved - a very common problem in my experience) they'll come to me - whereas if they go down the keyboard route they'll probably just try again, rather than asking for my help. The tip about copying and pasting the data to a spreadsheet has been on the site for 10 years without anyone asking for my help, perhaps because anyone who knows how to use a spreadsheet also knows how to cut and paste.
     
  4. Alexander Bisset

    Alexander Bisset Administrator Staff Member

    Yes that's the difference between an active and passive feature. Users don't tend to notice passive features, ie: something baked into Windows vs a button they can actively click. Hence despite instructions, which most steadfastly forget to read even when they are emailing for help, users will tend to plod on not knowing such a feature exists, because it was passively there in the background and they didn't bother to read about it.

    It's prompting about these sorts of things in forum and newsletter will tend to get comments along the lines of "oh I didn't know you could do that". Which is of course a cue to slap forehead in despair that despite instructions being there for 10 years users STILL didn't read them. Which is of course why you chose the title of this forum article :)
     
  5. Alexander Bisset

    Alexander Bisset Administrator Staff Member

    BTW the usual way of producing a CSV from a database is a select along the lines of...

    select field1 || ',' || field2 || ',' || field3 || ',' || field4 as output_line from table_or_view

    Note that depending on version of SQL it might be + rather than || for concatenation.

    Edit: Actually just noted that for MySQL the syntax is...

    select concat_ws(',', field1, field2, field3, field4) as output_line from table_or_view
     
  6. peter

    peter Administrator Staff Member

    I'd already written an article for the newsletter about the new features - and although copying the data to a spreadsheet isn't new I've just added a note explaining how to do it.
    Thanks - that bit I can handle, but it's saving the data as a file that I see as the challenge (especially where to save it). For now I'd rather rely on the copy-and-paste solution since it is general purpose (someone who learns how to do it for one web page can apply their newly-learned skill to other pages).
     
  7. Alexander Bisset

    Alexander Bisset Administrator Staff Member

    All you need to do is to create a file that the browser offers to download for the user. There are instructions for PHP here.

    Users saving a downloaded file is also a VERY general purpose skill just as basic as cutting and pasting data. It is certainly possible to use a computer without ever knowing you could cut n' paste data, I've seen many users retype stuff when they could have cut n paste. However it is scarcely possible to use a computer without saving and loading files. So I simply don't buy the suggestion that users could learn a cut n paste skill but can't learn to save a file.
     
  8. peter

    peter Administrator Staff Member

    Thanks - the newsletter has gone out now, so I'll wait and see if anyone runs into problems.
     

Share This Page