The snippet of data you provided within your recent email appears to be part of a Microsoft Excel spreadsheet formatted file with some improperly truncated fields belonging to the Citizen Connection program. So it comes as no surprise that you are having difficulty reading that file.
There is no way that the Citizen Connection program is using an Excel spreadsheet to store its alphanumeric dataset. Service desk type programs normally use some type of SQL database server to store its data.
Excel excels with numerical data but not alphanumeric data, its storage and the many permutations of analysis you might require to uncover any patterns, trends or misnomers in numeric data. Also, Excel is a superb tool when utilizing a few numeric spreadsheets at a time, but when you begin to scale up the size of your numeric data, for instance with a government dataset, Excel begins to creak under the strain. Nevertheless, the Citizen Connection files are alphameric and not numeric thus must be using a SQL type server for storage
At this time I have no reason to believe anyone in the IT office is purposely trying to obfuscate the data to make your task of redacting any confidential info more difficult and time consuming and my task of importing the file more cumbersome. Perhaps that file originated from an intern in the IT office with shallow experience that may need a little more re-training on importing and exporting databases.
Kindly inform me of what type of database server the city is using to store the Citizen Connection data, and I will gladly forward the city a step by step instruction on how to export those files to a comma delimited CSV file format for easy reading by your office.
Thanks for your efforts;
On Wed, Feb 4, 2015 at 3:53 PM, Gutierrez, Theresa
> Good afternoon Mr. Nelan,
> I have received your records request in regards to the database for Citizen
> Connection. In reviewing the report pulled from out IT Dept., it will take
> more than 5 + hours to redact. This report is very difficult to read. I have
> attached the first 10 inputs of the report. Unfortunately, this is not a
> very “user friendly” report (but the only one we can pull). Please let me
> know if you would still like to continue with this request. My contact
> information is listed below.
> Theresa Gutierrez
> City Clerk’s Office
> City of Port Orange
> 1000 City Center Circle
> Port Orange, FL
> Ph: 386-506-5565
> Fax: 386-756-5290
- City Manager’s Weekly Update Feb. 6, 2015
- "There is no place at City Council for religious indoctrination"