It's nether CGI-App, nor open source, but have a look at Article Manager (http://www.interactivetools.com/products/articlemanager/) It should meet most of your requirements, other than the fact it isn't issue-based - new stories in each category simple get added to the top (if you choose to order by date). All it requires is Perl -- no external modules and no database -- and it's only $299.
Dan -----Original Message----- From: Geoffrey G. Hankerson [mailto:[EMAIL PROTECTED] Sent: Wednesday, 23 March 2005 08:13 To: [email protected] Subject: [cgiapp] Advice on new project I am in need of a system to manage the creation and editing newsletters. Newsletter example done by hand in html is here: http://www.hamline.edu/law/alumni/news/index.shtml Here are the requirements - Add, edit and remove stories consisting of a title, body and optional photo - "categories" of stories which correspond to a page (see tabs along top in example above - categories would be highlights, events, news, class notes and opportunities) - Multiple issues of a newsletter with archives - muliple kinds of newsletters for different audiences - web based editing interface - doesn't have to be slick - user authentication, and management - muliple presentations: ascii text, html and rss Available resources: Apache 1.37 Perl 5.8.1 via cgi interface (no mod-perl) Sqlite (no Mysql or Postgres) Ability to install modules in my home directory as needed (I'm not the sys admin) Several popular modules already install CGI.pm, CGIApp, DBI, DBD:SQlite, On the surface this doesnlt seem that hard to do I can create a Sqlite Database with tables for these entities: Newsletters Issues stories users (all the approprate join tables) Then I can use CGI:App, DBI, and HTML:Template to make stich all the pieces together. Maybe I could use XSLT as the presentation layer My questions are: 1. It seems I am reinventing the wheel. Krang in particular seems it may be a good fit, but I haven't access to MySQL or mod-Perl. Can I run Krang via CGI interface and SQLite? Is there another good option? 2. If I do write the app myself what are your suggestions based on my requirements. Thank you --------------------------------------------------------------------- Web Archive: http://www.mail-archive.com/[email protected]/ http://marc.theaimsgroup.com/?l=cgiapp&r=1&w=2 To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- Web Archive: http://www.mail-archive.com/[email protected]/ http://marc.theaimsgroup.com/?l=cgiapp&r=1&w=2 To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
