RE: [S-R] Re: Member Village Index
- Helens's Database,
I need to learn to read the oldest message first instead of the other way
I looked at the database. It is in Microsoft Excel. Resorting the list by
village name is not a problem.
The way to sort the list by village may be done by the following steps:
1. Download each of the family surname sections and copy each section into
a single MS-Excel file.
2. You will need to change the spreadsheet properties to remove the "read
3. Using the "Data Sort" option in MS-Excel, resort the entire database
based on the second column which contains the village name.
4. The file is now sorted by village name. If you want to go one step
further you could also include a secondary sort by either the surname or by
the person submitting the surname. My choice would be: Primary sort on the
village name and secondary sort on the Surname. That will then give you a
list that has all of the villages in alphabetical order with all of the
surnames in order from that particular village name.
From: SLOVAK-ROOTS@yahoogroups.com [mailto:SLOVAK-ROOTS@yahoogroups.com] On
Behalf Of Bill Tarkulich
Sent: Thursday, February 04, 2010 1:59 PM
Subject: Re: [S-R] Re: Member Village Index
This would work if it was sorted by village name.
It's sorted by the wrong criteria, as far as I'm concerned.
On Thu, February 4, 2010 1:55 pm, John wrote:
> Helene Cincebeaux web site: http://slovakpride.
> --- In SLOVAK-ROOTS@ <mailto:SLOVAK-ROOTS%40yahoogroups.com>
yahoogroups.com, "Bill Tarkulich" <bill.tarkulich@...>
>> What's the link?
>> Seems like a pretty fundamental thing.
>> If you can gain agreement that Helene will keep it up, I'd be thrilled
>> link to it.
>> On Thu, February 4, 2010 1:08 pm, John wrote:
>> >>>> I don't recall Slovak-Roots having an index of villages that
>> >>>> members are searching in. Is it possible to set such an index up?
>> >>>> <<<
>> > Why reinvent the wheel? That's exactly what Helene Cincebeaux has set
>> > ------------------------------------
>> > To visit your group on the web, go to:
>> > http://groups. <http://groups.yahoo.com/group/SLOVAK-ROOTS/>
>> > To unsubscribe from this group, go to
>> > http://www.yahoogro <http://www.yahoogroups.com/group/SLOVAK-ROOTS>
ups.com/group/SLOVAK-ROOTS -or- send blank email
>> > SLOVAK-ROOTS-unsubscribe@...! Groups Links
>> Bill Tarkulich
>> http://www.iabsi. <http://www.iabsi.com> com
> To visit your group on the web, go to:
> http://groups. <http://groups.yahoo.com/group/SLOVAK-ROOTS/>
> To unsubscribe from this group, go to
> http://www.yahoogro <http://www.yahoogroups.com/group/SLOVAK-ROOTS>
ups.com/group/SLOVAK-ROOTS -or- send blank email to
> SLOVAK-ROOTS- <mailto:SLOVAK-ROOTS-unsubscribe%40yahoogroups.comYahoo>
firstname.lastname@example.orgYahoo! Groups Links
http://www.iabsi. <http://www.iabsi.com> com
[Non-text portions of this message have been removed]
- Dear Frank, Michael, David, et al.:
Thank you for your comments! I should probably mention a little bit about m background. Like the broad multitudes of people doing genealogical research, I am both new to it and have yet to cross over to non-web sources (although a LDS trip is in my near future). I came to it predominantly because my grandfather had a falling out with his family and refused to speak of any of them in his lifetime. Similarly, my wife's great-grandfather dropped his surname in favor of the generic "Nelson" after arriving in the States. So we're both interested in trying to figure out where we come from. I think this is fairly common for most novices, so I hope I can offer that prospective as we talk about designing a database useful to a wide range of people.
Speaking of the database, not to toot my own horn, but I am something of an amateur Excel ninja as that falls in with my other hobbies of fantasy baseball and political campaigns. So I think I can also offer some perspective on the mechanics of designing an offline databases. Unfortunately, my knowledge of online databases, coding, and general web forms is limited to Google docs, and even for these I lack a thorough knowledge base.
Regarding the surname accents, I can see where this may not be useful. My thinking was that as a novice I often see Stupaks, Sztupaks, Stupakovas, and half a dozen other versions with various accents. Are these people related to my branch of Stupaks? Michael was kind enough to provide me with some insights, but I think this probably trips up many novices. That's where I thought the "proper" accents and surname dates could help one track the changes over time, but this may not work well for a database.
Similarly with dates of residence I was hoping to allow people to track how a surname moves into and out of a village over time. This may also be something that might be a poor use of a general database and better task for individuals to undertake.
As for village names, I think it would be easy enough to add twenty or thirty columns for village names, enabling someone to search for any temporal or linguistic variety of the village name. Then this would be easily searchable by end users (Ctrl-F) or perhaps via sortable tabs along the top header bar. While all this is a time intensive task, we do possess the benefit of having a finite number of villages and a fairly good selection of online resources with which to provide all the prior names. Provided that we agree on a format (e.g. Plavnica (YYYY-YYYY)) then I think this work could be subdivided among a number of volunteers without falling solely on the shoulders of a moderator.
Speaking of moderators ... I have to agree that a solo moderator is better for consistency, but if we are using a drop down scrollable form field then there is little to no opportunity for an end user to input anything into the the database that does not correspond to the conventions we decide to use. That helps eliminate 99% of the consistency issue and enables us to have multiple moderators. Multiple moderators also help extend the longevity of the project as it would not be beholden to the interests and/or time of any one individual, and new moderators can be added as old ones cease participating.
As for hosting, I would recommend trying out Google Docs. It has the capability of creating a form that auto-populates a spreadsheet. Unfortunately, it is not very sophisticated and I doubt that we would be able to continually update the drop down scrollable form fields on the form with new villages added to the database. Further, I think we would have to enter all villages/surnames by hand (and this is not a task that could be outsourced to several volunteers). The other big drawback with Google Docs is that I have never found a way to update the form without screwing everything else up. So perhaps I'm convincing myself not to use Google Docs, but it does have two big benefits: it's free and it's designed for multiple moderators. Perhaps the Google Docs system is a good way to try out some of our ideas while those who know more about online systems investigate possible hosting / coding solutions?
I feel there is more issues people have raised, but I don't want to extend this reply too long lest it diminish it's usefulness.