Two suggestions:
One: drop the excel idea right now or you'll find out its not the right solution at a later time. Use LDAP instead. Then right a CGI (as you really don't need Mod-Perl) for all kinds of queries and an admin view for a maintainer to maintain it. Two: ask your spreadsheet maintainer to save the sheet in CSV (Comma Seperated Value) format someplace where a CGI can access it. Say www:/home/directory/list.csv Then use Samba and on the maintainer's windows machine have a network mapped drive, where this file will be saved as, say z:\list.csv, where z: is mapped to \\www\directory Then use Text::CSV.pm perl package to access this list.csv You are done....go home now.. PS: you might have to convert the '\r\n' to '\n' as samba does not change the line break symbols as it moves it from Windows to Unix. Cheers... On Thu, 29 Nov 2001, Ian wrote: > > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > In the wide and wonderful world of Microsoft and Linux, I'm in the > need of an interesting soloution. > > I'm presenting this to the list because I've ran out of good ideas. > > The campus phone system has a 911 database that is in Microsoft Excel > format, and they want to be able to take that information, and show > it on a webpage, either via a search form, or in one big table. The > problem is, they want to do it dynamically...the web server needs to > yank it down from a samba share (or ftp), parse it, show it, and > terminate. > > I'm really **really** new at anything perl wise...so I haven't the > foggiest clue as to where I should start. > > I've finally gotten Apache/Mod Perl/Mod SSL installed, and working > properly. Are there any modules for pulling information from an > excel sheet? How about modules that keep the overworked admin from > insanity? > > Ian > > > - ---- > - From RFC 1925: "(3) With sufficient thrust, pigs fly just fine. > However, this is not necessarily a good idea. It is hard to be sure > where they are going to land, and it could be dangerous sitting under > them as they fly overhead." > > > -----BEGIN PGP SIGNATURE----- > Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com> > > iQA/AwUBPAa3NHRiiq+WL4fKEQKsRACgutpROPjPllax3Nvfat2R7YERlSQAn35Q > 0vwYEFLgdzsz4Dfu98dUJzBy > =Qs9B > -----END PGP SIGNATURE----- > > -- ------------------------------------------------------------------------- Medi Montaseri [EMAIL PROTECTED] Unix Distributed Systems Engineer HTTP://www.CyberShell.com CyberShell Engineering -------------------------------------------------------------------------
