The sermonupload.pl program is a sample batch upload tool for SermonAudio released under the GPL. Currently it is very basic, designed to meet my immediate needs to do batch uploads. You are welcome to enhance this program to meet your needs (and I can merge your changes back into my program so everyone can use them). The only current documentation is in the source code for this program. Formal HTML documentation might be prepared after the development settles down.
To use this, you will have to install SOAP::Lite and LWP from Perl's CPAN module. (You probably already have LWP installed if you have cpan working.) How you do this on various platforms depends on your Perl distribution and your platform.
October, 2008: Minor fixed version uploaded with a fix of a minor bug.
Extending this code to interface with almost any database or flat file format would be fairly trivial, if you already have your sermons in some sort of file format. But if you don't, and you're collecting data, some sort of online web interface might be easier. It would be trivial to make this program read records from MySQL or some other Perl::DBI enabled database.
If you prefer using a graphical user interface to enter your data, use your spreadsheet! Put your sermon data into a spreadsheet, then export it in CSV format. sermonupload.pl will read the standard Comma Separated Values (CSV) file format which all spreadsheets (and most databases) can export. (The comments in the program explain how to use this feature.) The spreadsheet must have its columns in the order that the program expects, so I have provided a sample.
Sample spreadsheets:
Note that (1) CSV support requires the Perl module Text::CSV to be installed. If it is not, you will have to comment out the CSV support in the program to get it to run. (2) Perl's Text::CSV will process either "full" CSV (all fields quoted whether they need to be or not) or "partial" CSV (only fields with embedded commas are quoted). I tested the CSV generated by both OpenOffice Calc and MS Excel (Mac 2004 version), and sermonupload.pl seems to like the CSV that either program exports, but your mileage may vary.
Contact me by e-mail or go to my web site for more information.