Hey Asa,<div><br></div><div>I don't think this process could be best served with something like a google spreadsheet. <meta charset="utf-8">This would not be something you could simply pull off the shelf software and integrate without a lot of customization -- and that's what SAG is proposing. I think you could find a local development team in the SF Bay area who would be be able to do the same thing SAG lists but with open source software (Django, web2py, rails, jquery, postgresql, etc) however they'd need to be contracted to write and support the result which could come out to be less amounts of dough. At least it would be something that could be picked up by another third party for support should it need to be.</div>
<div><br></div><div>As a resident of Berkeley I'd prefer see a more opened solution than the "Business Process Model Leader because we say we are" route that SAG recommends. The nearly $1M to provide publicly-accessible "Knowledge Base" on the last page floored me! When did open government become so expensive?</div>
<div><br></div><div>Thanks for keeping us in the loop and look forward to hearing about the new proposal.</div><div><br></div><div>--<br> Kurt Grutzmacher -=- <a href="mailto:grutz@jingojango.net" target="_blank">grutz@jingojango.net</a><br>
<br><br><div class="gmail_quote">On Thu, Mar 24, 2011 at 2:49 PM, Asa Dodsworth <span dir="ltr"><<a href="mailto:moped45@gmail.com">moped45@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div class="gmail_quote">The Rent Boards Budget and Personnel Committee meeting will be presented the proposal from web methods for building a new RTS(Rent Tracking System) Database, <a href="http://www.softwareag.com/Corporate/products/wm/default.asp" target="_blank">http://www.softwareag.com/Corporate/products/wm/default.asp</a> after this meeting I will be able to email the group their proposal..</div>
<div class="gmail_quote">their tentative date for the meeting is Monday the 28th</div><div class="gmail_quote"><br></div><div class="gmail_quote">ATTN: Attached is a City Report report issued June 29, 2009, commissioned by the City of Berkeley's IT Supervising Systems Analyst Keith Skinner, and produced by Software AG, WebMethods Report. <span style="border-collapse:collapse;color:rgb(34, 34, 34);font-family:arial, sans-serif;font-size:13px"><a href="https://mail.google.com/mail/?ui=2&ik=b4fe5909ee&view=att&th=12ee9d416d13db7f&attid=0.1&disp=safe&realattid=f_glo1muzo0&zw" style="color:rgb(53, 66, 88)" target="_blank">software doc 2.pdf (<i>application/pdf</i>) 7866K</a> (they had to send it to me with Gmail because the city server wouldn't allow them to upload a 7.8MB file) they'd probably save tons of money by migrating there email accounts to <a href="http://sites.google.com" target="_blank">sites.google.com</a></span></div>
<div class="gmail_quote"><ul><li>the report projects the total costs at $307K, but I believe it has been tentatively negotiated down to $200K.. </li><li>I'm not familiar with these kinda things but this looks ridiculous to me. In my naivete I imagine this could be handled by a google spreadsheet and and account access controlled database viewer with a page view template... Security of the information being handled by paper and pdf back ups of important documents etc.</li>
<ul><li>one valuable feature would be to have a comment section for each account with the rent board/program ex: such as this landlord has been delinquent before. This can't be that complicated, this has got to be basic billing and customer service software.</li>
</ul></ul></div><div class="gmail_quote"><br></div><div class="gmail_quote"><span style="border-collapse:collapse;color:rgb(34, 34, 34);font-family:arial, sans-serif;font-size:13px"><font size="4"><i>This is the feedback i've gotten so far</i></font></span><span style="border-collapse:collapse;color:rgb(34, 34, 34);font-family:arial, sans-serif;font-size:13px"><br>
</span><ul style="border-collapse:collapse;color:rgb(34, 34, 34);font-family:arial, sans-serif;font-size:13px"><li style="margin-left:15px">Open Source Software suggestions: </li><ul><li style="margin-left:15px">
a robust database like MySQL or PostgreSQL will take care of keeping track of access control and replication of other databases (provided you can take SQL dumps, otherwise it'll have to be the same software).</li><ul>
<li style="margin-left:15px"><span style="border-collapse:collapse;color:rgb(34, 34, 34);font-family:arial, sans-serif;font-size:13px">PostgreSQL (if some/all of the information is not for public consumption or security is otherwise </span><span style="border-collapse:collapse;color:rgb(34, 34, 34);font-family:arial, sans-serif;font-size:12px">a concern) or SQLite</span></li>
</ul><li style="margin-left:15px"><font color="#222222" face="arial, sans-serif"><span style="border-collapse:collapse;font-size:12px">front end viewer like</span></font> PHPMyAdmin (a very insecure, but functional PHP app --just don't make it public on the internet), or a Django project (the built-in admin console has a very simple Create/Read/Update/Delete functionality for each row.</li>
</ul><li style="margin-left:15px">requests for more info: <br></li><ul><li style="margin-left:15px">RFP<br></li><div class="im"><li style="margin-left:15px">numbers of fields and records, <br></li><li style="margin-left:15px">
bandwidth requirements, <br></li><li style="margin-left:15px">administrative roles,</li><li style="margin-left:15px">platform information such as <br></li></div><ul><li style="margin-left:15px">type of host(s)<br></li>
<li style="margin-left:15px">operating systems</li></ul></ul></ul></div>
</blockquote></div><br></div>