Scott County Intranet

1
Scott County Intranet

• the content and data behind it

2
Presentation and Discussion

• Please share your own intranet experiences

• Intranets
• XAMPP
• MySQL

3
Intranet

• Not intended for public use
• Less attention to tidiness than Internet site
• Resource minded
• Testing environment
• Internal DNS setup for intranet

4
Audience

• Staff
• Internal
• Captive
• Browser/OS Standards
• All county browsers startup homepage is
  http//intranet

5
Directory

• Employee directory
• Name, title, department, phone (internal
  extension and outside line)
• End date reason
• Photos
• Birthday in database, but not listed here

6
Directory Future

• Email
• May grow to include voluntarily submitted
  personal information
• bulletin board
• Facebook style status message

7
Birthdays

• Forecasts ten day birthday
• Features today and weekend
• Updated from directory database
• Charter service

8
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

9
(No Transcript)
10
(No Transcript)
11
Daily Tidbits

• Staff maintained pieces of information updated
  weekly
• Monday FSS
• Tuesday Health Benefits (HR)
• Wellness Wednesdays
• Green Thursdays

12
Features

• Pre-created html or php content chunks
• Managed with start and end date
• Appear and disappear on schedule

13
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.

14
Other

• Streaming webcams
• Weather (XML RSS)
• Local lunch menus
• Timesheet vs. Payday week
• Code of Iowa
• ISAC
• Media Links (RSS)
• Grant Info

15
HR

• Internal Job Openings
• Forms
• Benefits
• Training
• Employee Profile

16
Committees

• Web Team
• Employee Recognition
• Wellness
• GIS
• Green Team
• United Way

17
Employee Recognition

• Employee of the Quarter
• Exemplifies the Scott County PRIDE philosophy.
• Participate in outside endeavors contribute to
  our community.

18
United Way

• All events
• Committee members
• Dessert Raffle
• Intrabay Auction
• Links to Campaign website and materials

19
Bulletin Board

• Policy
• Few restrictions
• Types of items
• Self submitted
• Moderated
• Can only delete
• Limited to 2 months
• Auto links

20
Bulletin Board Future

• Unmoderated
• MySQL
• Editable
• Comments
• Categories
• Inter-departmental freecycling

21
Social Networking

• Self maintained employee profile
• Status messages
• Bulletin board notices and comments

22
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

23
Transparency

• Scott County Sunshine Review Profile
• http//sunshinereview.org/index.php/Scott_County2
  C_Iowa
• Evaluation of Iowa Counties
• http//sunshinereview.org/index.php/Evaluation_of_
  Iowa_county_websites
• What information should counties disclose on
  their websites?
• http//sunshinereview.org/index.php/County_website
  s

24
Flat Files

• Has a place
• Delimited (Tab)
• Easily edit from Excel
• Easily load, parse, edit and display with web
  scripting language.

25
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

26
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.

27
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

28
Perl

• Scripting Language

29
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.

30
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.

31
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

32
PHP-MySQL Tutorial

• http//www.hosting.vt.edu/tutorials/phpmysql/

33
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

34
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

35
Discussion
36
Scott County Intranet

• www.scottcountyiowa.com
• mtollerud_at_scottcountyiowa.com