Apologies to all on LDSOSS for the cross-post, but I don't see too many from this forum poking around there.
http://halcrow.us/~mhalcrow/callings_rb.tar.bz2 Allows bishopric members to play around with calling information via a web interface. parseMIS.rb is a module that parses memout.dat and orgout.dat, putting the data into the database that is initialized by init_database.rb. It's under src/web in LDSDPS: http://sourceforge.net/cvs/?group_id=100512 You'll have to twiddle with the location of the ldsdps.db database in the .rb/.rhtml scripts (paths are hardcoded for now). So to use: 1) Get memout.dat and orgout.dat from MIS; put them in the same directory as the scripts. 2) Install ruby, eruby, sqlite, sqlite-ruby; play with Apache httpd.conf. 3) Edit the .rb/.rhtml files; db = SQLite::Database.new( " /path/ldsdps.db", 0 ) 4) Run init_database.rb. 5) Run parseMem.rb. 6) Run parseOrg.rb. 7) Browse to index.rhtml. TODO: - Stop hardcoding; add a config file and/or standard locations (necessary for all of LDSDPS). - Implement code to add new members. - Make it pretty. - Optimize queries by hand. SQLite does no optimizations as far as I could tell (before manually adding indexes, it was downright miserable). - Write module to merge two ldsdps.db databases. - Write some report generators, for sacrament meeting announcements and what not. - Dynamically filter content in index.rhtml. For example, only view call records that are Approved but not yet Extended by clicking a box. - Clean the parser up. Anyone have the spec for memout.dat and orgout.dat? Original stuff that I wrote in the web extensions for LDSDPS is in the public domain. And, as always, patches welcome... Mike .___________________________________________________________________. Michael A. Halcrow Security Software Engineer, IBM Linux Technology Center GnuPG Fingerprint: 05B5 08A8 713A 64C1 D35D 2371 2D3C FDDA 3EB6 601D Pound for pound, the amoeba is the most vicious animal on earth.
pgpkC0AhRRzq0.pgp
Description: PGP signature
____________________ BYU Unix Users Group http://uug.byu.edu/ ___________________________________________________________________ List Info: http://uug.byu.edu/cgi-bin/mailman/listinfo/uug-list
