Tagged: ,

Topic:   CSV Events and Facts Report  

This topic contains 3 replies, has 2 voices, and was last updated by macalter macalter 2 months, 1 week ago.

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #10360
    macalter
    macalter
    Participant

    466 posts

    Did a Report using Event = Burial; Place = convention I use for place of burial and received the results I wanted. Name (both maiden/married if applicable) displayed on separate lines as they do for the INDI record. However, when exporting to CSV, the only way then go to Excel then to PDF to put on my iPod, had problems with names.

    All the names that had multiples showed as one continuous name: Name, Married Name and possibly Hebrew Name. Sarah Smith (maiden) | Sarah Brown (married) | SaraBatSmith (Hebrew) showed fine on screen, as per her record.

    SarahSmithSarahBrownSaraBatSmith in the CSV export. Therefore, OpenOffice (aka free Excel) couldn’t figure out how to separate to 3 names. Possibly because the names are on 3 lines. But, to put Sarah Brown on its own line would mean not being able to manipulate her record.

    -----
    [updated: 01 Apr 2018]
    MacOS: 10.11.6  (El Capitan)
    Safari  11.1;  Firefox 59.0.2

    PHP 7.1 Fast CGI
    mySQL server: 5.1.56

    Kiwitrees:
    "The Royals 3.3.3 (03)" <royals.rbcsolutions.ca>

    "Rebbes of Ger 3.3.3 (03)" <private>

    "Uncle Ummie's Journal 3.3.3 (03)" <private>

    #10361
    kiwi
    kiwi
    Keymaster

    1656 posts

    Yes, all perfectly true.
    CSV does not have any ability to include formatting. The export is only there to provide a way to export a block of data. It may well require manual processing to fully utilise it in whatever software you choose.

    However OpenOffice Calc does a pretty good job of accepting content pasted from html. So try just selecting the parts of the on-screen display you want and copy/ paste that unchanged.

    Nigel
    My personal kiwitrees site is www.our-families.info
    #10373
    kiwi
    kiwi
    Keymaster

    1656 posts

    Just re-reading your query has reminded me that there is an alternative solution that might work better for you, as you indicated your ultimate goal was to create a PDF version to read in an iPod.

    Does your web browser have a “save as PDF” option when you go to print something? I know that (for Windows OS) Chrome does. Firefox doesn’t but Microsoft does include a PDF print driver that you can use. If yours (presumably still Apple) then there are free PDF writers that can be installed that would work.

    Using any of these, simply use your browser to print to PDF. For all of the reports that should produce a reasonable facsimile of the on-screen result direct to PDF for you.

    Attached is a small sample of the result based on your Place / Burial requirements.

    Nigel
    My personal kiwitrees site is www.our-families.info
    Attachments:
    #10375
    macalter
    macalter
    Participant

    466 posts

    Print to PDF was on Mac for ages. It’s the ONLY way I print as I refused a printer when purchasing my iMac in 2009 🙂 I just tried print PDF in landscape mode and it is an alternative. Will try that.

    (The landscape mode is to allow large print size — which on an iPod is needed!)

    -----
    [updated: 01 Apr 2018]
    MacOS: 10.11.6  (El Capitan)
    Safari  11.1;  Firefox 59.0.2

    PHP 7.1 Fast CGI
    mySQL server: 5.1.56

    Kiwitrees:
    "The Royals 3.3.3 (03)" <royals.rbcsolutions.ca>

    "Rebbes of Ger 3.3.3 (03)" <private>

    "Uncle Ummie's Journal 3.3.3 (03)" <private>

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.