About Duffbert...

Duffbert's Random Musings is a weblog semi/sorta related to IBM/Lotus Notes & Domino software, but I don't let that be a limiting criteria. I'm Thomas Duff, and you can find out more about me here...

Email me!

Search This Site!

Google
Web
duffbert.com

Recent book reviews...

MiscLinks

Visitor Count...



View My Stats

« Book Review - Dixie Before Disney: 100 Years of Roadside Fun by Tim Hollis | Main| Why enterprises are moving to Google Apps, Gmail »

Request for council members' emails rife with difficulties

Category
From The Longmont Times-Call: Request for council members' emails rife with difficulties

The Times-Call submitted a Colorado Open Records Act request March 24 for all e-mails from each Longmont City Council member’s account, giving the city until April 4 — seven more days than the three required by law — to round up the messages.

Longmont city clerk Valeria Skitt said that when her office received the newspaper’s request, she planned to burn each council member’s e-mails to a disc. But that didn’t work with some accounts. So Skitt told council members that either they could forward their e-mails to the public inbox — at city.council@ci.longmont.co.us — or employees would do it for them if they provided passwords to their accounts.

Didn't work with some accounts?  Hmmm...

 Once the city finished the Times-Call’s open records request, how to get those files in a usable format also became an issue. Because the city uses Lotus Notes and because all the e-mails were sent to the public inbox, burning the messages to a disc wouldn’t do any good because the files wouldn’t be viewable on a computer without Lotus Notes.

The city can convert the e-mails to a text file, but doing so bogs down each e-mail with lines and lines of coding. Still, it was the only workable option, so the city gave the Times-Call a disc with the e-mails.

On that disc was one, 53-megabyte, 20,664-page document containing the text of the e-mails — a document the Times-Call still is combing through.

Let me get this straight...  They spent 11 business days fulfilling this request by sending counsil member emails to a public inbox, then still resorted to converting the emails to a large text file for final presentation????  And this is blamed on Notes?  

Let's see...  All documents, Select All, Print All Documents in View, Print to a PDF driver...

Am I missing something here???

Comments

Gravatar Image1 - i'd be happy to help these poor souls but my guess is the budget was eaten up by reams of paper.

Gravatar Image2 - i'd be happy to help these poor souls but my guess is the budget was eaten up by reams of paper.

Gravatar Image3 - Duff, it may not be as simple as ripping the messages to PDF. If the messages contain attachments, the Colorado FOIA law may require those attachments to be be included. There may be requirements in the law about how the request can be fulfilled.

Certainly there appears to be lots of room for improvement in what they did though, but hell hath no fury like an unjustified assumption.

Gravatar Image4 - "Because the city uses Lotus Notes and because all the e-mails were sent to the public inbox, burning the messages to a disc wouldn’t do any good because the files wouldn’t be viewable on a computer without Lotus Notes. "

Or, more property:

"Because the people involved are morons..."


Gravatar Image5 - @3... Fine.. even then, you could write an agent that would print those off. I've done that, and it took me far less than 11 business days.

@4... I like your interpretation better. Heck, they could have even downloaded a trial version of Notes, full-text indexed the dbs, and gone to town.

Of course it would have likely taken them 11 business days to find where to order or download one. :)

Gravatar Image6 - Duff, it may not be as simple as ripping the messages to PDF. If the messages contain attachments, the Colorado FOIA law may require those attachments to be be included. There may be requirements in the law about how the request can be fulfilled.<br /><br />Certainly there appears to be lots of room for improvement in what they did though, but hell hath no fury like an unjustified assumption.

Gravatar Image7 - First off, I apologize for the double posting. My bad.

Lemme ask you this Tom -- if the attachments are password protected, then what? Not the Notes message itself, but the Word or Excel document. Don't poo-poo it -- I've been there. It's not easy. I am not saying this is the situation here, but rather in the general case, this problem really is not as straight forward as it might seem.

Gravatar Image8 - OK... I'll give you that one. However, they forwarded emails to a different inbox, converted them to text, and then created a file. I don't see how that approach would solve any of the password-protected attachment issues. In addition, they admit that they lost original delivery dates in the process.

Either way, this sounds like a "solution" thought up by someone not terribly qualified or tech-savvy, and the public paid for it.

Gravatar Image9 - Sorry about double posting was on my cell.
They could have easily created a merged mail file copied all in there set to reader and left it on webmail with a FTI.

Gravatar Image10 - Or, just send them the NSF's, or a time-restricted replica.

Can't read it? Nope. Notes is available to ANYONE, FOR FREE TRIAL from developerworks. As long as the databases aren't encrypted, you can read them with any ID.

Say Warren, who had this exact conversation with a customer last week, regarding users moving onto new companies and wanting to take their mail with them.

Post A Comment

:-D:-o:-p:-x:-(:-):-\:angry::cool::cry::emb::grin::huh::laugh::lips::rolleyes:;-)