Erik (eriktrips) wrote,
Erik
eriktrips

  • Mood:

geek alert

lisagail will be happy that I've finally found something in my life to database: archived lj entries of course! why didn't I think of it before. the rather ridiculous non-existence of basic database functions on the lj site, plus a healthy fear that one day they might erase all my entries, has spurred me to download my whole journal month by month.

first I downloaded it in xml format just because, well, you know: all the cool kids are playing with xml these days and as I have never really learned it I spent two hours reading up on it on the web and discovering that FileMaker Pro will only read xml that it itself produced (unless one wants to go through one's xml files to make them conform to their grammar which would kind of defeat the purpose of downloading them in xml to begin with) and that firefox needs stylesheets at the very least to render your xml and I don't feel like drawing any up for lj xml and I don't know if firefox also needs a dtd to render it and I don't feel like drawing any up for lj xml AND there is of course no mention of dtd's anywhere on the livejournal site but that's not too surprising and so I gave up on the xml and just downloaded all of 2001 in comma separated text files.

which work wonderfully with FileMaker Pro as it turns out. in about five minutes I had all of 2001 in a labeled, searchable, sortable, printable database. I made 228 entries that year.

I could export this in xml now if I wanted to go on in that direction for fun but really do I need another learning project? is it clear why I never finish anything?

on to 2002!
Subscribe

  • chapter one is finished!

    The end of chapter one of UndiaGnosed is near. So near you could click and be right there. This entry was composed @Dreamwidth. Feel free to…

  • That took a long time

    So it took a little longer than I meant for it to but here is another section of the autobiography that will never end:…

  • Why the sky is blue is a political question.

    Why it is important to examine our own ideas before we can change the world around us. This entry was composed @Dreamwidth. Feel free to comment…

  • Post a new comment

    Error

    default userpic

    Your IP address will be recorded 

    When you submit the form an invisible reCAPTCHA check will be performed.
    You must follow the Privacy Policy and Google Terms of use.
  • 1 comment