On Thu, 10 May 2012 21:17:53 GMT,
Ea...@bellsouth.net (J. Hugh
Sullivan) wrote in soc.genealogy.computing:
>On Thu, 10 May 2012 14:47:29 -0400, Denis Beauregard
><denis.b-at-f...@fr.invalid> wrote:
>
>>Le Wed, 09 May 2012 18:17:45 GMT,
Ea...@bellsouth.net (J. Hugh
>>Sullivan) écrivait dans soc.genealogy.computing:
>>
>>>...do people with 50,000 names, plus or minus, keep everything
>>>consistent?
>>>
>>>Is County always Co., is every state 2 capital letters, has the
>>>superfluous comma between city and state been removed - and I could go
>>>on.
>>>
>>>Keeping all that straight with only 7,000 names is tough but seems to
>>>me that not using consistent standards results in sloppy work.
>>
>>I would say it depends at least on the purpose and the tools you
>>have.
>>
>>The purpose : standardization will improve the quality of the product
>>if distribute it (as a commercial site or database or to a family
>>society, etc.).
>
>No one has my data base - I think I'm just trying to satisfy myself
>and it turned out to be a lot of work. I need to pass it before very
>long but I want to pass it to someone as serious as I am.
>
>I don't understand the purpose of coding when the proper word would
>seem to suffice.
My database was a text, without columns. So I couldn't have the same
effect as a typical database or spreadsheet, that is a column for
the place, one for the area, etc. Moreover, I wanted to extract data
by area (counties or states when I was looking at state archives),
and this means the 1st part of the code must be the top level area.
Most people will use place, county, state, country, not the opposite.
Also, in this project, I needed to isolate items as words separated
by spaces, which meant no space inside the place item.
>>Today, I am transfering every thing to a libreoffice set of files.
>>I still have codes for places (while they are different). I check if
>>the code is correct, but also the format of dates (help to find
>>some mistakes), the sequences of dates (must be born then married),
>>etc.
>
>What about a child born before marriage?
I have a code for that. Actually, I have 2 possibilities : 1 is
to use a special code to tag them, the other (I use) is to identify
them when checking for mistakes. But I keep the special code to see
it when looking at my data.
>Have you used MS Word? If so are you really satisfied with
>libreoffice? Is it absolutely compatible? Does it have drop down menus
>like 2003 or the stupid ribbon like 2010?
It is not (and likely will never) be absolutely compatible. I had
Office 97 on my computer for years (I switched from Win 98 to 7 last
year because my old computer couldn't work anymore). I found that
Office 97 was not compatible in Win7 with some other software I had
(Forte Agent) and I prefered to install OOO then LibreOffice for this
purpose. I tried another computer where MS Office 2010 was already
installed and could never start Forte Agent (email client) in that
computer, so I presume FA has some problem with any MS Office
version, at least on Win Vista and 7.
Nonetheless, I read from time to time complex Word files with LO and
sometimes, a complex structure will cause some issue (but it is not
common). Format can be different (I had to correct the margins when I
installed LO to print CD covers).
I found something amazing : I have Excel xls files (not xlsx) and I
may save it from LO, then read it from MS Excel, and when reading it
back, it says there is a link to another file (which is false). Or
one file couldn't be read back with OOO 3.3 but was readable with
OOO 2.4 and LO 3.4.
Behaviour is different. It has the menus, not the ribbon (I don't
like it). But if you drag and drop, Excel will detect not empty
cells (not OOO/LO), while if you cut and paste, OOO/LO will and
Excel won't !!! Some macros are not yet available in LO like in
Excel.
I used for years this sequence:
=INDEX([conversions.xls]Feuil1!$B$1:$B$1007;EQUIV(D30;[conversions.xls]Feuil1!$A$1:$A$1007;0);1)
Using a couple/individual number as a reference, I could import
from another file some information. For example, I had 4 columns and
I import parents for a series of individuals using the parent's number
as the reference. It won't work in LO. I can't use a column as an
argument (I need to define it from line 1 to 65000 for example,
instead of a whole column). If importing from another file, it can
idle (i.e. freeze). If importing from the same file, I have to repeat
the process because the lines are relative, i.e. if you copy the
formula from line 1 to line 10, the imported element will be moved
from say 1:5000 to 10:5009. So you have to adapt to the different
behaviour.
I have to chose between Forte Agent (all 15 years of emails with
data) or MS Office. I have now very few programs that have no Linux
equivalent so I may jump to Linux at some time (when it will have
the bug fix that said we have to mount/unmount CDs, USB etc. that
are removable media).