Re: Access/Excel, etc. (was: Has anyone made a real conlang? )

Elyse Grasso wrote:

> I started my lexicon in one of the Linux-based Excel equivalents,
> decided it wasn't flexible enough to do what I wanted, and switched
> over to XML with perl script wrappers.
>
> The latest generation of the scripts sorts the lexicons into
> autogenerated html files 4 different ways: by conlang term (English
> alphabetical order), by word class, by keyword (English to conlang
> table), and by conlang term (conlang sorting order).
>
> I can't imagine trying to do that with a spreadsheet like Excel. A
> database like mysql (or Access) might work for the storage
> and sorting,
> though it still might need some perl for the conlang sorting order.
Hmm. Actually...I currently have a VBA macro/script/program[1] that takes my
dictionary data that is in Excel and generates the appendices for the
grammar document complete with formatting.  The appendices are:

Appendix A) Taraitola->english
Appendix B) English->Taraitola
Appendix C) People & Places

A&B are generated from the same entries, just formatted differently.  C is
generated from entries with the appropiate flag. :)

Now that you mention your own scripts, it occurs to me that I could have
another script generate HTML.  Thanks for the idea, I had been wondering how
to make publishing my data on the web easy and painless. :) Why didn't I
think of this before...

Iain

[1] Perspective on which term is appropiate may vary. :)