More on the genealogy project

I spent some time last night following up on playing around with software for tracking my family’s history on our website. So far, things are actually looking fairly good — with the one caveat that I only have so much information in my head.

The first piece to the puzzle is GEDitCOM, a Mac OS X application that reads and writes standard GEDCOM files (I had no idea that there was a standard file for genealogy software before I started looking into all this). While it’s not the prettiest application in the world, it does appear to be very powerful, and I’m quite pleasantly surprised by the amount of information that the GEDCOM format supports.

Of course, I’m not sure why I’m surprised — I’m obviously not the first person to look into how to track all this information using a computer. I guess we all just like to think that we’re the first to come up with a good idea… ;)

The second piece is the web package I stumbled across the other day — PhpGedView. A set of PHP scripts, it was very easy to install and get up and running, all I had to do was copy the scripts into a directory on the webserver, tweak the permissions on two files and one directory, and I could log into the interface and start putting things together. Again, it’s not as pretty as it could be, but it does look like nearly (if not entirely) all of the functionality that I was looking for is there.

Once PhpGedView is installed, all you need to do is upload a standard GEDCOM file and PhpGedView parses it and creates the final website. Here’s the one spot where I ran into problems: each time I uploaded the GEDCOM file that GEDitCOM created, PhpGedView wasn’t able to parse it correctly, and I got a bunch of garbage data.

Turns out that the solution is fairly simple, and ties into an age-old issue between Mac and PC file formats. Mac systems use a different character to signify the end of a line than PC (DOS/*NIX) systems do, and when the scripts tried to import the GEDCOM file, they saw it as one really really really long line. I was able to get around this by running the file through BBEdit and switching the line break style, I’m sure there are many utilities to do just that floating around the ‘net for people who don’t have BBEdit.

Once I got that figured out, the import went smoothly, and as a result, the first version of our family tree is up. It’s very bare-bones at the moment (though not as bare-bones as it looks at first — just click around and experiment a bit to move around the tree), but mom promised to send me copies of the family’s “history box”. Once I get that and pop more information in, the tree will look a lot less sparse than it does at the moment.

Even better, though, is that PhpGedView does handle one of the bigger items on my wishlist — user accounts with editing ability. I’ll need to put together a simple “user’s manual/how-to”, but this will allow other people in the family to add and edit information to the database. Once changes are made, I can then download the updated GEDCOM file from PhpGedView to my computer, re-import it into GEDitCOM, and keep all the information synced between my personal workspace and the website. Not bad at all!

Every few years of my life, the genealogy bug has bit me — now that it has again, it’s great that I’ve got the technology at my fingertips to be able to store and present it like this.

Now, mom — about that box… ;)

iTunes: “I Was Walking” by Poems for Laila from the album On a Wednesday (2002, 2:50).

Brain Drain

There’s an excellent (as in must-read) article in the Washington Monthly looking at how the Bush administrations policies are driving creative talent away from America.

As other nations become more attractive to mobile immigrant talent, America is becoming less so. A recent study by the National Science Board found that the U.S. government issued 74,000 visas for immigrants to work in science and technology in 2002, down from 166,000 in 2001–an astonishing drop of 55 percent. This is matched by similar, though smaller-scale, declines in other categories of talented immigrants, from finance experts to entertainers. Part of this contraction is derived from what we hope are short-term security concerns–as federal agencies have restricted visas from certain countries after September 11. More disturbingly, we find indications that fewer educated foreigners are choosing to come to the United States. For instance, most of the decline in science and technology immigrants in the National Science Board study was due to a drop in applications.

[…]

…I’m convinced that the biggest reason has to do with the changed political and policy landscape in Washington. In the 1990s, the federal government focused on expanding America’s human capital and interconnectedness to the world–crafting international trade agreements, investing in cutting edge R&D, subsidizing higher education and public access to the Internet, and encouraging immigration. But in the last three years, the government’s attention and resources have shifted to older sectors of the economy, with tariff protection and subsidies to extractive industries. Meanwhile, Washington has stunned scientists across the world with its disregard for consensus scientific views when those views conflict with the interests of favored sectors (as has been the case with the issue of global climate change). Most of all, in the wake of 9/11, Washington has inspired the fury of the world, especially of its educated classes, with its my-way-or-the-highway foreign policy. In effect, for the first time in our history, we’re saying to highly mobile and very finicky global talent, “You don’t belong here.”

(via Tom Negrino)

Why gay marriage should not be legalized

[Update:]{.underline}

When I originally found this piece, it was uncredited, and so I posted it as I found it. Thanks to Suchita for pointing me to the original source: the Gator Gay Straight Alliance at the Univeristy of Florida.

  1. Homosexuality is not natural, much like eyeglasses, polyester, and birth control.
  2. Heterosexual marriages are valid becasue they produce children. Infertile couples and old people can’t legally get married because the world needs more children.
  3. Obviously, gay parents will raise gay children, since straight parents only raise straight children.
  4. Straight marriage will be less meaningful if Gay marriage is allowed, since Britney Spears’ 55-hour just-for-fun marriage was meaningful.
  5. Heterosexual marriage has been around a long time and hasn’t changed at all; women are property, blacks can’t marry whites, and divorce is illegal.
  6. Gay marriage should be decided by people, not the courts, because the majority-elected legislatures, not courts, have historically protected the rights of the minorities.
  7. Gay marriage is not supported by religion. In a theocracy like ours, the values of one religion are imposed on the entire counrty. That’s why we have only one religion in America.
  8. Gay marriage will encourage people to be gay, in the same way that hanging around tall people will make you tall.
  9. Legalizing gay marriage will open the door to all kinds of crazy behavior. People may even wish to marry their pets because a dog has legal standing and can sign a marriage contract.
  10. Children can never suceed without a male and a female role model at home. That’s why single parents are forbidden to raise children.
  11. Gay marriage will change the foundation of society. Heterosexual marriage has been around for a long time, and we could never adapt to new social norms because we haven’t adapted to things like cars or longer lifespans.
  12. Civil unions, providing most of the same benefits as marriage with a different name are better, because a “seperate but equal” institution is always constitutional. Seperate schools for African-Americans worked just as well as seperate marriages for gays and lesbians will.

Not the best I’ve ever read, but not terrible, and has its amusing moments. Its heart is in the right place, though.

(via Something Positive)

Duck! The food’s shooting back!

You will never lose betting on human stupidity.

A man and his wife ducked behind a refrigerator when bullets began exploding in their oven, authorities say.

Capt. Craig Kohlbeck of the Brown County Sheriff’s Department said the husband had put the ammunition and three handguns in the oven before the couple left on a vacation.

He told officers he thought the items would be safe there in case someone broke into the home while they were away.

After returning from their trip Tuesday, the wife turned on the oven to prepare dinner and the bullets ignited, Kohlbeck said.

No one was hurt.

Of course, as amusing as this is, I can see it happening. At one point many years ago, mom decided that she’d store some of her unused Tupperware in the oven. Later on, Dad decided to cook.

After she had to get new Tupperware, mom decided that there were better places to store it.

;)

(via Prairie)

iPhotoToGallery

Adding photos to my family photo gallery, the old way:

  1. Choose the photos I want to send to the gallery in iPhoto.
  2. Export the photos to a folder on my hard drive.
  3. Copy the photos to a folder on the webserver.
  4. Log into the Gallery software on the website.
  5. Navigate to the album I want to add the photos to.
  6. Choose Add photos….
  7. Enter the URL of the directory I just copied the photos into.
  8. Upload.
  9. Done.

Adding photos to my family photo gallery with iPhotoToGallery:

  1. Choose the photos I want to send to the gallery in iPhoto.
  2. In iPhoto, choose File > Export…, then click on the Gallery tab.
  3. Choose the album I want to upload the photos to (or create a new album).
  4. Click Export.
  5. Done.

Very, very nice.

(via Forwarding Address: OS X)

iTunes: “New Style Baby, A (’91)” by Pink Stanly Ford from the album Technomancer (1996, 6:47).

Heaven and Hell

From Neil Gaiman, after admitting that while he is equally at home on Macs or Windows computers, he is still primarily a PC user

When I tell Mac people this, they smile their secret smile. They know that after we die, we go to a special place, and that those who used Macs will be raised on high, where they can sip their cappucinos and look down and see the virus-infected writhings and screamings of those who used PCs, as the damned Windows users are forever bombarded with boiling projectile vomit from the thousand-foot high screaming thing that used to be Bill Gates.

But I’m sure even the damned people down in the mud will be laughing up whatever’s left of their sleeves at those of us who secretly like fountain pens best.

iTunes: “They’re Coming to Take Me Away” by Lard from the album Last Temptation of Reid, The (1990, 8:28).

Barry Manilow listens to Underworld?!?

I never would have guessed this.

I was poking around on the iTunes Music Store, and started looking at some of the Celebrity Playlists — essentially “mix tapes” (only there’s no tape involved) assembled by famous people. I saw Barry Manilow listed, and had to know.

Two tracks immediately jumped out at me — favorites of mine, and not at all what I expected to see.

First, Underworld’s “Born Slippy/NUXX“. Underworld is one of my favorite modern electronica acts, and while most people know them for “Cowgirl” off of the Hackers soundtrack, they’ve done a lot of other excellent work, including this track (also featured on the Trainspotting soundtrack). Driving rhythms, inscrutable lyrics, and lots of electronic bleeps and bloops — good stuff. ;)

Even better, though, was seeing the Peter Gabriel/Kate Bush collaboration “Don’t Give Up” off of Peter’s album ‘So‘. Where many people would rank “In Your Eyes” (also featured on the Say Anything soundtrack) as their favorite song of his, “Don’t Give Up” has always been my personal pick. Beautiful, haunting, and full of hope for the future, this song is one that often helps me get through some of the rougher times in life. It also has one of the best videos I’ve ever seen — good enough that I remember it clearly, though I only ever saw it once, in a hotel in Italy during one of my trips to Europe. Just Peter and Kate embracing each other against a sunrise, standing on a platform that revolved so that each was facing the camera as they sang their lines. Very simple, and very effective, much like the song itself.

Good to know that Barry’s got better taste in music than I’d expect.

Free music is good

One free iTMS song!

I got my first free song from the iTMS today, thanks to the current promotion with Pepsi!

I’d been keeping an eye out for eligible bottles, but today was the first day I’d actually seen them. I picked one up on the way to work, popped the cap, and won right off the bat! Not bad at all — even with one out of three bottles being a “winner,” I hadn’t expected to find a good one right away.

Figuring out what to get wasn’t terribly difficult, either. Ever since I started listening to the CD I got from Kev and Emily at their wedding, I’d been convinced that I knew the Dolly Parton song “Travelin’ Prayer”, only I remembered it being a man singing it rather than a woman. While looking up songs on the iTMS for the previous post, though, I figured it out — she’s doing a cover of Billy Joel’s song “Travelin’ Prayer” off of his Piano Man album.

I knew I’d heard that somewhere before!

Soundtrack to a wedding

One of the many nice things that came of Kev and Emily’s wedding was their interpretation of the Alaskan “potlatch” tradition, in which the hosts of a large gathering pass out small thank-you gifts to the people who attended. During the wedding reception, they passed out CDs they had made with a selection of songs special to the two of them.

Here are the songs that they chose to represent them at this point in their life:

  1. Billie Holiday: All of Me
  2. Bob Marley and the Wailers: Sugar, Sugar
  3. Crosby, Stills and Nash: Helplessly Hoping
  4. Dolly Parton: Travelin’ Prayer
  5. Lauryn Hill: Can’t Take My Eyes Off of You
  6. Joni Mitchell: A Case of You
  7. Edgar Meyer and Joshua Bell: Short Trip Home
  8. Nanci Griffith: If Wishes Were Changes
  9. Jimmy Cliff: Sitting in Limbo
  10. Tracy Chapman: The Promise
  11. John Prine: Angel from Montgomery
  12. Robin Dale Ford: Where I Am Bound
  13. Super Bass: Blue Monk
  14. Bob Dylan: Shelter From the Storm
  15. Nickel Creek: When You Come Back Down
  16. Arlo Guthrie: Darkest Hour

Genealogy software wishlist

Okay, so here’s what I wish I had available in a software package. Any mad coders out there feel like putting it together? ;) (This has been submitted to the LazyWeb.)

  • A web-driven genealogy software package (PHP/Perl/Python with a database backend?).
  • One page per family member, able to display (at minimum, though not all items would necessarily exist for every page):
    • Links to immediate family members (one degree of seperation: parents, siblings, spouses, children).
    • Vital statistics (birth, marriage, divorce, death). This could be expanded to include christening, baptism, etc. for situations where such dates are recorded.
    • Biographical and/or historical information — stories, memories, etc.
    • Pictures.
    • Contact info for still-living members.
  • User registration.
  • Logged-in users would be able to easily edit any individual page on the tree to add memories, stories, information, etc. (Wiki-style ‘edit this page’ links?).
  • Logged-in users should also be able to create new pages for family members not already in the tree. New pages should follow a template to ensure that a consistent look-and-feel is maintained as much as possible.
  • Wiki-like ease in adding pages and linking pages together. IE, one of the things I really like about the Wiki concept is how easy it is to (in this concept) let the tree grow. When creating my page, all I had to do was add WikiWords for my relatives, and I could then jump to and create/edit their pages. Functionality such as this is far easier than having to log into a central database and create new records for each new entry and then have to go back and edit all pages that would link to the new entry.
    • I’m still not sure how to best work around the issue with multiple family members with the same name.
  • Administrators should be able to review and approve/disapprove new users, get a list of recent changes, possibly approve/disapprove page edits before incorporation (this is optional, I think).
  • HTML output should be clean, standards-compliant, using CSS for styling, etc.
  • RSS/XML/Atom feeds of recently changed/added pages (preferably with an option to subscribe to either ‘minimal’ feeds listing only changed pages, ‘short’ feeds listing the edited page and the changes, and ‘full’ feeds listing the edited pages and the full text with changes marked in some way).
  • (This might be pipe dream territory) A dynamically-generated (Java? DHTML?) overview of the tree or branches of the tree. I’m visualizing being able to start with a simple tree of one nuclear family. Lines leading away from members would indicate further information along the branch. Clicking on a member (parent, spouse, child, etc.) would “slide” the display to that member’s nuclear family. “Zoom out” would allow more branches to be viewed (and would need a “Zoom in” control to return to a single-family view. “Detail” links on each member would lead to the individual member’s page (which would have a “View tree” link to switch to the dynamic tree view).
  • Possibly more as I come up with it.

If I had the time, I’d start diving heavily into PHP (or Perl, or Python)/MySQL and start attempting to build this myself. However, I don’t have the time, and something tells me that this might be complex enough to be fairly overwhelming as a first project.

If this software existed, I’d gladly pay for it (hopefully it would be within my price range, of course). At the moment, if anyone feels up to attempting to code it together, I’d gladly beta test!

So how crazy am I? How does this feature wish list sound? Is there already something out there on the ‘net that might cover some or all of this (aside from Wiki, which I’m already exploring) that I haven’t found yet?

Questions, comments, and words of wisdom are, as always, appreciated.

Update: Hot damn — PhpGedView just might be it!