Arena: Counseling List Display

We have been using the ArenaChMS Counseling Module since the end of 2011, but I did not like the interface available. Add onto it that the people using the system are typically not very computer savy I knew we had to do something.

The admin who managed it was gathering together all the updates and putting them into an excel file which she emailed to everyone. Nobody was really reading it when it came in.

It was hard to track who was keeping up with a person and what the latest situations were.

There is no Active / Inactive status and no Delete.

So, I created a Report Grid From Query that acts as a module interface. It sorts by counseling status so as to display only active situations that are being monitored by the Pastoral Care staff.

Pastoral Care List

Pastoral Care List (Click image for larger version screen grab)

Download File: cust_CCJax_Counseling_List_Display.zip

Included in this attached zip file is an xml export of the page I use and SQL for creating the stored procedure. More details about setting up the page are included in that SQL file.

Because this page filters by counseling status you need to set those up and then include their id numbers in the proper places in the Stored Procedure. You will also need to edit the Stored procedure to let it know where your counseling page is and what tab you have set for Counseling in the Person Detail area. That is all explained inside.

Google Maps based Area Mapping Tool

I kludged together an online Google Map tool for our ministry staff this week.

After trying it out for a little bit I am putting it here on the community to help others and to improve it.

There is a live instance available at http://osministry.com/map/ and I included the files in a zip here: http://osministry.com/map/files/

CSVMap

The tool itself is just an html file relying on Javascript and the Google Maps API V3. It does not need an API key so it will work on any domain name without you having to register your own.

Included is a file called csv.php. I code in php, but since not everyone else does I kept all code in a separate file so you can easily make your own and just change the file name listed in the javascript.

This tool was really built for designing Area Maps for ArenaChMS, but a little adaptation will make it usable for other purposes.

You can click on different locations and it will gather together the coordinates of those locations into a textarea which is then exported out as a  csv file ready to be imported with the ImportArea.exe file that Arena Support can provide (I would rather point you to them for support on that).

New features I would like:

Importing a list of coordinates – I would like to be able to take a list of coordinates from either the CSV or from an Arena exported xls file and import them into the tool so that we can more easily edit shapes in the future.

Closing the shape – The Google API version of this tool (here) has a “Close PolyShape” button that would close the shape back on the original coordinates. I found that our ministry staff liked this feature even though it put an extra identical coordinate in the list. I would filter that last one out when creating the csv, but it does help to visually close the map for people.

Clean up the file – The index.html file is a mess. As I said, I kludged it from another tool and so I left a lot of the extra stuff in there as reference as I worked on features. At some point I really should get rid of all the stuff I set to “Display: none;” or commented out.

Giving credit where it is due, the original file I started with was from http://www.birdtheme.org/useful/v3tool.html

ArenaChMS users can discuss this tool in the community here.

VLAN PowerConnects for Ubiquiti Unifi

Our current WiFi setup is awful. We have geriatric Buffalo access points that are nearly 7 years old and then public WiFi using flaky Open-Mesh OM1P access points.

Our new network plan relies on Ubiquiti UniFi access plans and then use multiple SSIDs with VLAN tagging. Unfortunately our network is a little odd as well. I would like to be able to have the Public SSID be able to only access the internet while the password secured WiFi would allow access to internal servers for the staff.

Network Summary and Picture:

NetworkSwitches

Yes, we currently have 2 separate Internet connections. One to Comcast and one for our phones and connecting to our other campuses.

Our important servers are currently at the farthest point away from the internet so we need to make sure everything works out to them.

Our T1 connections use a firewall out at the provider, but our Comcast connection uses an old SonicWall.  It currently has no DHCP set up.

So, any suggestions? What would be an easy way of doing this?

Direct Link to Adobe Reader Standalone Installer

I get tired of redownloading Adobe Reader when doing a bunch of updates. I also get tired of the ambush software that Adobe keeps trying to slip in.

For this reason, I prefer to use and refer to the standalone installer at the Adobe FTP site. The link for Reader X is:
ftp://ftp.adobe.com/pub/adobe/reader/win/10.x/

And to the future me who comes looking for this note, You Are Welcome!

Digital Signage for Churches

I am using this post to collect together some information about digital signage. I will include references to resources.

I am considering the JW Image Rotator (free) and building a PHP backend to do an automated xml of a folder if images. Maybe someday write something more custom. @ckehayias wrote something similar in .Net.

@srushikhttp://getcu3er.com/ ($50) with custom built ASP backend that builds xml from images.

@dszp pointed to @crewNeckTech mentioning  http://www.drmretriever.com/ (not sure of cost).

@granata http://www.getsignboard.com/

Also from @granata (here) there is http://mediasignage.com and their free product.

More work and info to come

Volunteer Applications

Over the years we have required our volunteers to fill out applications. Not to long ago we started doing them online and now managing this process has been moved over to one of my tasks. To be honest, the system we have is a pain in the neck so I want to fix it up.

I’ll start by showing what we have.

Yes, we use Survey Monkey to manage this form (please do not submit it, that would really bother the very busy lady who does the work of receiving and following up on them). The results are cut and pasted into a doc, exported to PDF, and stored as a part of that person’s profile in our database (we use Arena). Paper based copies have been pulled out of their filing cabinets and scanned in order keep us consistent.

The information is this form is used to provide information about a person so they can be evaluated for a serving position, have background checks run, and references to call.

Now for what we want.

  • We want something that is easily submitted and received
  • Required fields
  • Easily edited in the future
  • I would really like an integrated module for Arena that does all of this, but we are not set to coding that yet and it might be worth knowing more about what we really want before we do.

As a long time web geek I almost said “Hey, I’ll code that right up.” but I don’t have that kind of time available anymore. I do about a half dozen jobs and have an infant at home. Instead I said “I’ll look into seeing what other people are doing and we can move forward from there.

so, . . .

What are YOU doing?

Other churches must be dealing with this same issue. We want to know what you are doing. Do you do volunteer applications? do you do them online? do you have a special workflow?

Public Wave: Monitoring your Church’s internet usage internally

Trying out another public wave. This one is on Monitoring the internet access of the church network.

Join in!

Monitoring your Church’s internet usage internally

Currently I am mirroring the outbound port of the last switch on our network and sending all of that data to a machine with two NICs. One simply gulps on the network firehose and the other allows me to RDP in.

I monitor the traffic with WireShark using the statistic options with IPv4 conversations, I/O, and HTTP requests.

There has got to be a better way to have ongoing monitoring on a tight budget.

Any questions or suggestions?

Trying a public Google Wave

I am trying out the Public Wave option using public@a.gwave.com with this post, but you will still need a Google Wave Account to join in.

This is a wave asking questions about Open-Mesh.

I am using the Wavr Plugin for Wordpress to embed the wave, but you can go directly to it here: The Open-Mesh Wave.

Continue reading ‘Trying a public Google Wave’

Tool: Wireless Keyboard & Touchpad

As a way to share tools I use regularly with others and find out tools that other IT people are using. So, I am going to start off with a tool I keep on hand and use at odd situations.

Wireless Keyboard & Touchpad

Logitech® Cordless MediaBoard Keyboard for PlayStation®3
or the
Logitech Cordless MediaBoard Pro Wireless Keyboard

The one pictured above is just the cordless mediaboard, but it is currently more expensive that the MediaBoard Pro and harder to find. It was originally bought to use with a media center PC attached to a big LCD TV, but plans changed and I put it into regular use at the church.

Some Points about the Hardware:

The USB dongle is the same size as a standard thumbdrive

There was no way to attach the dongle to the keyboard for storage so I superglued a magnet in a place underneath where the dongle could be held out of the way.

The keyboard feels flimsy and cheap, but it holds up pretty well.

They say the reach is 30 feet, however I plugged it into a computer and then walked out of the house and down the road probably 50 feet before the characters went goofy. This was through a standard exterior wall that had hardy board siding added onto it, and hardy board does a lot of damage to readio signals.

There is no software to install and windows recognizes it instantly. Macs will, of course, pop up the dialog to ask you to hit the key next to shift so it can be identified as a non-Mac keyboard but it works just fine.

The keyboard uses 2 AA batteries. I love this since it means that when I pull it out for use I can just take 2 AAs with me and not worry about the condition of the rechargeable integrated batteries that some remote keyboards use.

Uses:

Obviously it is good for presentations done by people who don’t like using an air mouse and do like a touchpad.

It also works well when assisting someone with a presentation. It is nice to be able to quickly plug into someone’s laptop so that if they do have problems during a presentation you are ready as a helper.

It works well in your lap when at a distance from the screen, but I would not use it as my daily desk keyboard. It isn’t comfortable enough for that position and duration.

We keep it as an emergency USB keyboard in my office. Since nobody wants it at their desk it isn’t going to go into circulation. I used it in the server room when a keyboard cord to the KVM had been knocked loose and the server came up without recognizing the KVM’s keyboard. It was easy to get into place without dealing with a cord, and the mouse was integrated.

And of course, it is good for pranks. Especially if you set up some good shortcut keys in advance.

Some Additional Stuff:

I need a keyboard and touchpad setup for a kiosk going into the bookstore. There isn’t enough room for a mouse on the ledge, and it seems too cumbersome, so I was looking at the Adesso Slim touch Desktop Keyboard. It is currently $37 at buy.com, but if you have any suggestions I would be glad to hear them.

Linux Command Line – SSH and Telnet

I just grabbed this from an old forum post of mine. It was originally written in 2002 or so, but I wanted to post it here as one of my reference items since this blog is where I come to find that stuff anyway.

This covers typical Linux commands used in web hosting.

Continue reading ‘Linux Command Line – SSH and Telnet’