Posts

Wanted list records that had people born in Ontario before 1918. Could only think to produce a find list.

Advance Search:
Date of birth = before 01 Jan 1918
Place: Ontario, Canada

Results when exported to CSV, it didn’t produce results that would open “properly”. I was not able to pick the delimiters that would produce columns.

When I opened in Excel, selected line 2 and copied to email page. It pasted (one continuous line)

Copied line to an email page (text only) which also didn’t produce useful results.

When I did a Quick Look in the Mac Finder (file on desktop),I saw column 1 was the “problem” part. I contained Name, Mother, Father which should be 3 fields and labels. Instead they’re combined into one filed including labels.

----- [updated: 31Dec2022] MacOS: 10.15.7  (Catalina) Safari   14.1.2;  Firefox 108.0.1 (64-bit);  108.0.1462.54 (Official build) (x86_64)

Alter-Drukarsh connections | The Garelick: 3.3.11b - PHP 8.0 FastCGI - mySQL 8.

Hi

This is a known (and previously discussed) limitation of the CSV output. It cannot easily change the output of what is primarily a web display format. Values “hidden” on the web page will always be there in the output, because the CSV will always be just the table cells from the underlying html.

The output from any of the search pages uses the same display as the “Lists”, and that is designed to provide the maximum amount of data, despite the limited amount of space. To do otherwise always results in at least some dissatisfaction as each persons expectations vary. Hence give everyone everything, is the general approach.

However, I can give you two possible solutions, neither perfect, but both better than what you have:

• Using the same Advanced Search, copy / paste the output directly from the displayed web page into Excel. This (I find) does transfer only the displayed content, not the hidden parts. One caution – I don’t actually have a MS Excel, only LibreOffice Calc, so results for you might be different.
• Use Reports > Facts and Events instead of Search. Enter BIRT as the fact; 1918 as the “Year to”; and Ontario, Canada as the place. This should give a similar result, but with less ‘extra’ data. It has the same CSV output option.

Nigel
My personal kiwitrees site is www.our-families.info

For the Father: and Mother: I got creative. To the CSV, added “;” in front of both. Saved CSV. Opened to Import and did Search/Replace for the “;Father:_ (space) replaced with “”. Did same for Mother.

The manual labour is now the Names. Maiden/Married or Last/Alternate. Will have to manually do those. Or may get creative?????

As it happens, all the information is usable for the purpose I want it. Once the Ontario Archives re-open (Covid-19), will be able to use to find births and/or deaths. Although sadly our dear government decided 96 years is too short between releases so changed to 104 years (births). Those 5 years will make a difference. (Ancestry is behind by 3 years but will be used to)

----- [updated: 31Dec2022] MacOS: 10.15.7  (Catalina) Safari   14.1.2;  Firefox 108.0.1 (64-bit);  108.0.1462.54 (Official build) (x86_64)

Alter-Drukarsh connections | The Garelick: 3.3.11b - PHP 8.0 FastCGI - mySQL 8.