Scott County Intranet

scacchicgardenSoftware and s/w Development

Dec 13, 2013 (3 years and 7 months ago)

85 views

Scott County
Intranet

…the content and data behind it

Scott County Iowa


Mitch Tollerud

Presentation and
Discussion


Please share your
own intranet
experiences



Intranets


XAMPP


MySQL


Scott County Iowa


Mitch Tollerud

Intranet


Not intended for public use


Less attention to “tidiness”
than Internet site


Resource minded


Testing environment


Internal DNS setup for
“intranet”


Scott County Iowa


Mitch Tollerud

Audience


Staff


Internal


Captive


Browser/OS Standards


All county browsers startup homepage
is http://intranet

Scott County Iowa


Mitch Tollerud

Directory


Employee directory


Name, title, department,
phone (internal extension
and outside line)


End date & reason


Photos


Birthday in database, but
not listed here

Scott County Iowa


Mitch Tollerud

Directory Future


Email


May grow to include voluntarily
submitted personal information


bulletin board


Facebook style status message

Scott County Iowa


Mitch Tollerud

Birthdays


Forecasts ten day birthday


Features “today” and
“weekend”


Updated from directory
database


Charter service

Scott County Iowa


Mitch Tollerud

Calendar


Newest Feature on intranet


Events, Holidays, Training,
Retirement parties…


Upcoming Events or Calendar Grid


“Add to Outlook” feature


Will combine departments for “master”
calendar view

Scott County Iowa


Mitch Tollerud


Scott County Iowa


Mitch Tollerud


Scott County Iowa


Mitch Tollerud

Daily Tidbits


Staff maintained pieces of information
updated weekly


Monday FSS


Tuesday Health Benefits (HR)


Wellness Wednesdays


Green Thursdays

Scott County Iowa


Mitch Tollerud

Features


Pre
-
created html or php
content chunks


Managed with start and end
date


Appear and disappear on
schedule

Scott County Iowa


Mitch Tollerud

PIP


Productivity Innovation Program


Improve the efficiency of operations,
safety, delivery of service and quality
of work life.


Every January proposals are reviewed
by a selection committee and up to
five employees are presented with
$250 saving bonds.

Scott County Iowa


Mitch Tollerud

Other


Streaming webcams


Weather (XML RSS)


Local lunch menus


Timesheet vs. Payday week


Code of Iowa


ISAC


Media Links (RSS)


Grant Info


Scott County Iowa


Mitch Tollerud

HR


Internal Job Openings


Forms


Benefits


Training


Employee Profile

Scott County Iowa


Mitch Tollerud

Committees


Web Team


Employee Recognition


Wellness


GIS


Green Team


United Way

Scott County Iowa


Mitch Tollerud

Employee Recognition


Employee of the
Quarter


Exemplifies the Scott
County
PRIDE

philosophy.


Participate in outside
endeavors contribute to
our community.

Scott County Iowa


Mitch Tollerud

United Way


All events


Committee members


Dessert Raffle


“Intrabay” Auction


Links to Campaign website and
materials

Scott County Iowa


Mitch Tollerud

Bulletin Board


Policy


Few restrictions


Types of items


Self submitted


Moderated


Can only delete


Limited to 2 months


Auto links

Scott County Iowa


Mitch Tollerud

Bulletin Board Future


Unmoderated


MySQL


Editable


Comments


Categories


Inter
-
departmental freecycling

Scott County Iowa


Mitch Tollerud

Social Networking


Self maintained employee profile


Status messages


Bulletin board notices and comments


Scott County Iowa


Mitch Tollerud

Migrate to Internet


“Can this be on the Internet?”


HR internal postings, policies,
benefits, union contracts, pay plan
and more.


FSS mail report


Some Committees


Transparency


Staff access from home


Scott County Iowa


Mitch Tollerud

Transparency


Scott County Sunshine Review Profile:


http://sunshinereview.org/index.php/Scott_C
ounty%2C_Iowa


Evaluation of Iowa Counties:


http://sunshinereview.org/index.php/Evaluati
on_of_Iowa_county_websites


What information should counties disclose
on their websites?


http://sunshinereview.org/index.php/County_
websites

Scott County Iowa


Mitch Tollerud

Flat Files


Has a place


Delimited (Tab)


Easily edit from Excel


Easily load, parse,
edit and display with
web scripting
language.

Scott County Iowa


Mitch Tollerud

XAMPP


http://www.apachefriends.org


Easy to install distribution for
developers to get into the world of
Apache.


Default configuration is not secure
enough for a production environment


Download


Install

Scott County Iowa


Mitch Tollerud

XAMPP Package


The distribution for Windows 98, NT, 2000,
2003, XP and Vista.


Apache, MySQL, PHP + PEAR, Perl,
mod_php, mod_perl, mod_ssl, OpenSSL,
phpMyAdmin, Webalizer, Mercury Mail
Transport System for Win32 and NetWare
Systems v3.32, Ming, JpGraph, FileZilla FTP
Server, mcrypt, eAccelerator, SQLite, and
WEB
-
DAV + mod_auth_mysql.

Scott County Iowa


Mitch Tollerud

Apache


The Apache HTTP Server, commonly
referred to as Apache is a web server.


notable for playing a key role in the initial
growth of the World Wide Web and in 2009
became the first web server to surpass the
100 million web site milestone


As of March 2009 Apache served over 46%
of all websites and over 66% of the million
busiest

Scott County Iowa


Mitch Tollerud

Perl


Scripting Language

Scott County Iowa


Mitch Tollerud

PHP


PHP is a general
-
purpose scripting
language that is especially suited for web
development.


PHP generally runs on a web server, taking
PHP code as its input and creating web
pages as output.


PHP can be deployed on most web servers,
many operating systems and platforms, and
can be used with many relational database
management systems.

Scott County Iowa


Mitch Tollerud

MySQL


MySQL is popular for web applications and
acts as the database component of the
LAMP software stack.


Its popularity for use with web applications
is closely tied to the popularity of PHP,
which is often combined with MySQL.


Flickr, Facebook, Wikipedia, Google
(though not for searches) and YouTube use
MySQL for its data storage and logging of
user data.

Scott County Iowa


Mitch Tollerud

PHPMyAdmin


phpMyAdmin is an open source tool written
in PHP


Intended to handle the administration of
MySQL over the World Wide Web.


Various tasks such as creating, modifying or
deleting databases, tables, fields or rows;
executing SQL statements; or managing
users and permissions

Scott County Iowa


Mitch Tollerud

PHP
-
MySQL Tutorial


http://www.hosting.
vt.edu/tutorials/php
mysql/

Scott County Iowa


Mitch Tollerud

WordPress


“WordPress

is a state
-
of
-
the
-
art
publishing platform with a focus on
aesthetics, web standards, and
usability. WordPress is both free and
priceless at the

same

time.”


Local


Move between hosted


local


http://wordpress.org

Scott County Iowa


Mitch Tollerud

WikiMedia


MediaWiki is a free software wiki package
written in PHP, originally for use on
Wikipedia.


Now used by several other projects and
wikis


Can install in local environment


http://www.wikimedia.org


http://www.mediawiki.org/wiki/MediaWiki


Scott County Iowa


Mitch Tollerud

Discussion


Scott County
Intranet

www.scottcountyiowa.com

mtollerud@scottcountyiowa.com