Tag Archives: http://schemas.google.com/blogger/2008/kind#post

The only political post on this blog for 2008

Writing on the eve of the New Hampshire primaries and after the Saturday evening debates:

I was really interested to hear from the Republican candidates (all white guys pushing or over 60) that the Republican party was looking to continue the legacy of either George Bush or Ronald Reagan. How is that going to improve things?

I thought Obama really nailed it when he replied to a hostile question about Iraq, (and I’m paraphrasing) “Unlike the Bush administration, We will actually go after the people who were responsible for 9/11, and we will withdraw from Iraq, a nation that was not responsible for 9/11.” What a concept.

I thought Hilary Clinton, citing “35 years of experience in Washington” was a little over the top. Being first lady? Taking a run at health care reform, but ultimately failing? Carpet-bagging to be a Senator in New York? And what about the 13 years before she came with Bill to Washington….how does that count as Washington experience?

More than one Republican candidate called Islamic terrorism the existential threat of our age. Um…guys….how about climate change and peak oil? Neither party seemed to place this at the top of their priority list. (Maybe they are still mad at Al Gore). (And maybe they don’t make any connection about our insatiable thirst for oil and our relationship with the middle east…) Nor did they place the health care crisis at the the top of the list. Republicans are mostly concerned about illegal immigration, even as they hire firms who employ undocumented immigrants to do their landscaping.

The republican party is decamped to Planet Bunny. Look to Ronald Reagan. Stay cozy with all their business buddies. (Let’s bail out the banks while we’re at it). Build a wall across the Mexican border. Stay in Iraq…forever. No change for the health-care system…it is working fine.

Five Trends in 2008 affecting Non-Profits

Price of Energy Rising

The price of energy is starting to be felt. Meals-On-Wheels will be more costly to deliver, and any agency that runs a shuttle or transports goods or people will be dealing with a permanent increase fuel costs.

Web Commerce Comes of Age for Non-Profits

After receiving a newsletter from my local cross-country skiing association, I was pleased to be able to go online and quickly renew my yearly membership, and order an updated map (which now I’m not sure I needed), and order a couple of skiing hats. I also paid for a family membership instead of my usual individual membership. So, with virtually no live-intervention I “up-selled” myself from a single membership of $35.00 to a total expenditure of almost $100. More importantly, I felt great doing it. I didn’t feel as if I was responding to pressure from a phone salesperson. The take-away here is that organizations that allow frictionless interaction with their members will profit in 2008. Those organizations that make it difficult to give them money will miss out on revenue opportunities.

Scandals Affect Large Non-Profits

Red Cross, Smithsonian, United Way, and other large non-profits have substantial work to do to re-earn the trust of their donors and constituents. The Non-Profit Quarterly, the New York Times, and other outlets documented the wretched excesses of their boards and executives. The era of autopilot donations to such organizations is over. We need board members and staff who are committed to the agency mission, and that see service as something other than just another notch on the resume.

Recession Spillover: Donors

With discretionary funds drying up, individual donors will pick and choose where they donate (see above). In our household we practice “zero-based” giving and we re-evaluate our donations every year. First come organizations from which we receive a product (public radio, public television, trail and bicycling groups). Next come health-care and welfare agencies in our local community; breast-care, rape crisis, homeless shelter. We have long stopped giving to national groups.

Recession Spillover: Clients

It is going to be tougher for the middle class to stay in the middle. Rising energy costs, rising health-care costs, the mortgage lending meltdown; there is substantial financial pressure on the 99% of the American population who didn’t have their taxes cut. So what is this environment like for people already on the margins? We saw in our local area that some homeless shelters were managing double their previous year’s case-load. Food shelves had fewer donations and double-digit increases in people looking for help.
So, how can you position your organization to be more effective in 2008?

  • Update your web site to allow on-line payments with credit-cards and PayPal.
  • Create membership packages and products that allow you to effectively upsell your donors when they log on to donate. It takes as much effort to sell a $35.00 membership as it does to sell $125 or more membership+merchandise.
  • Provide a web-based project management system for board and staff to publish minutes, status reports and information for internal use. Board members and staff need to have a “frictionless” way of interacting, just as your donors and clients do.
  • Can all of your staff tele-commute when necessary? Could you obtain the services of top-notch talent via telecommuting or videoconferencing?

Tech Friday: Amazon’s Web Services – Database

Every so often somebody makes a prediction which at the time seems plausible, but maybe somewhat out in front of things. They always with start with the word “Someday…” For example:

  • Someday, you will be able to go to a machine and withdraw money from your checking account.
  • Someday, there will be a little box that knows where it is at all times.
  • Someday we’ll all buy our computing power just like we buy electricity.

So it was interesting to see an announcement by Amazon yesterday about the Amazon SimpleDB database, a sort of do-it-yourself pennies per hour Oracle database. Well, maybe not Oracle, but a substantial database back end that can be used to host a major application. Actually, the SimpleDB appears to be primarily a querying component; for hosting a large dataset, Amazon offers S3, the Simple Storage Service.

Just a quick browse around shows support for C# and Ruby-on-Rails, among other development languages. In addition, Red Hat is offering Red Hat Enterprise servers as part of the Amazon offering. Their FAQ about “cloud computing” is located here.

This is something to keep an eye on, perhaps the next logical step after virtualization of existing servers in your machine room. Why have any servers at all? Why have a machine room?

Trixbox Appliance: New Baby


Just unwrapped the new baby here… a Trixbox appliance (the so-called “base” model for about $999) that comes without landline interface cards. In its base configuration it is suitable for those who want to implement a fully IP-based VoIP system. I’ll be adding hardware to this; an existing Sangoma A200 card which provides two landline connections. I’ll only be using one of the two connections to start. I couldn’t resist starting it up, and sorry, but contrary to all the assurances; the thing is noisy. Too noisy to have setting next to my desk. Damn.

The dual power-supply version that was demonstrated back in June sounded like a jet engine. Definitely that one is a unit for the server room, not deskside.

We had our first real snow that stuck today, about three inches. The Trixbox will be a great project on those cold winter days.

Looking Back: Database Development with Microsoft

Many careers require you to update or reinvent yourself on a regular basis. Expert programmers turn into beginners again every three years or so as their software tools, methodologies, and paradigms change.

So I certainly wasn’t surprised when after several months away from the Microsoft Visual FoxPro page I ran across an announcement from (April 2007 no less):

We are announcing today that there will be no VFP 10. VFP 9 will continue to be supported according to our existing policy with support through 2015. We will be releasing SP2 for Visual FoxPro 9 this summer as planned, providing fixes and additional support for Windows Vista.

The oddly-named FoxPro has had a good run. I started using it I think around 1988 when I first took a job at the University of Vermont in their Continuing Education division, setting up Novell networks and maintaing a couple of FoxPro applications that had been written over the previous couple of months. FoxPro really started out as a complier for dBase code. DBase was one of the first, if not the first relational database programs created to be used with desktop computers. DBase, an interpreted language, was slow and quirky, but if I recall, I actually got a couple applications going with it. Some years after dBase was created, Clipper came out. Clipper could compile dBase code into machine language which could then be run natively on the computer without an interpreter. Clipper had no user interface to speak of, you still had to do the development in dBase, then take the dBase files and run them through Clipper by running batch files.

FoxPro was developed by David Fulton as an improvement over Clipper. It included a user interface for development and allowed you to create one for the end-user. It was less expensive than dBase or Clipper and had terrific performance. I started with version 2.0 right after it had come out, and by the time they were up to version 3.0 they had a program to create sophisticated user interfaces with overlapping windows. The programs would work in both Windows and Unix, and at one point there was support for the Macintosh.

More on this ancient history is available on the FoxPro Wiki.

[pause to take unsolicited spam phone call in heavily accented English from Ravi via what must be a bad VoIP connection to solicit IT services]

Fox Software was bought by Microsoft in 1992. For awhile they maintained a DOS version, but they were keen on developing a version for Windows. This appeared to be before Access or SQL-Server had any major marketing traction. There were other desktop databases, and Microsoft may have felt that they needed to have a dog (er, fox) in that particlar fight. In particular, one competitor was Borland Paradox, which had a terrific user interface and query system. Borland was also competing with development tools and languages.

FoxPro-for-Windows, renamed Visual FoxPro, became a major development system for deploying desktop database applications. Paradox never made an effective transfer from DOS to Windows, although it still exists in the WordPerfect suite.

FoxPro isn’t dead though. There is a conference happening in October, and as the announcement says, there will be support until 2015. Version 9.0 will receive some updates to help it integrate well with the dominant Microsoft dot-net technologies. For interactive querying and data manipulation, it remains a wonderful tool.

Access 2007 Deployment File Formats

Notes from the Access 2007 help file:

There are four standard file formats for Access 2007 deployed files:

  1. .accdb standard file format for Access 2007
  2. .accde compiled binary file. This strips the VBA source code from the file
  3. .accdc combined version of Access application file, and a digital signature associated with the file
  4. .accdr format for running an application in runtime mode.

More on signing and creating the .accdc file:

I love this:

Note: Although this feature is also known as “packaging,” it does not accomplish the same tasks as the Package Solution Wizard of the Access 2007 Developer Extensions. The feature described in this section packages an Access 2007 file and applies a digital signature to the package that helps indicate to users that the file is trustworthy.

So if I’ve got this right, I can use the Packaging Wizard (discussion from yesterday) to package and deploy an .accdc file which is a signed version of my access workstation file. Whew!

Ekiga, formerly known as Gnomemeeting, is a Linux based softphone/videophone. (A newer version is also available for Windows). They’ve thought of everything… STUN, H.323, SIP, a directory, NAT traversal, you name it.


I’m using version 2.03 that was in the stock installation of Ubuntu Feisty. After a couple hours of fiddling, (at least 30 minutes of which was finding out that my microphone was switched off…) I’ve been able to make test voice calls to what sounds like their Asterisk server. Looking around, it says they are up to about 2.09, and if you want it work full-screen, you have to compile from the source code.

Access 2007 Packaging an Application

Now that the Access 2007 runtime is available, it is time to start working with Access 2007 again for client deployments. The first order of business was to start up the Developer Extensions.

The Microsoft Access 2007 Developer Extensions are available as a free download from Microsoft.

By default these are installed in C:\Program Files\Microsoft Office\. I changed this to add a folder Acc2007DE so I could find them, but even then couldn’t figure out what was supposed to be happening.

Turns out that the Developer Extensions are are a COM add-in, consisting of:

Package Solution Wizard – this is similar to the older package wizard with Access 2003.

Save as Template – Allows you to save an existing database installaton as a template. Note that this is not the same as saving a database design as a template!

These appear under the round Microsoft Button in the upper left-hand corner of the Access Window.

(my screen shot programs don’t appear to be able to deal with the dropped-down menu, so you’ll need to use your imagination. )

In the following screens shots, click on the image to see a larger version.

If the Developer option does not appear under the button, do the following:
1. Click the button
2. Choose Access Options
3. Choose Add-ins
4. At the bottom of the screen choose Manage COM add-ins, then GO
5. You should get a screen showing the currently available add-ins. Like this:

Ok, so let’s try the Package Solution wizard. Here is the first screen.

I changed the destination folder to F:\Access Install Packages.

The Package Solution Wizard asks for several parameters. Since I usually install an Access application off of the C:\ root, I chose System Drive (All Users) for the location plus the folder name in the Root install folder, and thent the actual folder name uner the Install Folder. The actual install location will show up in the Example install location field.

You can use the third option under t he section regarding the Pre-installation requirements if you want to install the Access runtime on a computer which does not contain Access 2007. To include this in your setup, you’ll need to point to to a locall copy of Accessruntime.exe which you can download from the Microsoft web site.

Note under the Example Install Location, that the installed version of the program will have an .ACCDR extension, as opposed to the normal Access 2007 extension of .ACCDB.

The Acccess 2007 help files include a subset of subjects, called “Developer Reference”

Salesforce for nonprofits – Database Alternative

Salesforce is one of the most popular web-enabled databases, and it’s gaining adherants among nonprofits. Accessible from any browser, customizable in myriad ways — and available to nonprofits for no fee through the Salesforce.com Foundation (up to 10 seats) — it’s a powerful tool. But how can a database with a name like Salesforce be used by the nonprofit sector? This webinar will explore the functionality and community of Salesforce. We’ll look at how several nonprofits, from a group of more than 1500, use Salesforce to cultivate and recruit donors, manage their electronic communications, and more. If you are looking for a new CRM solution, or just want to know more about Salesforce, this webinar will be a great starting point.
Presented by Rob Jordan, Idealist Consulting

Register now at http://nten.org/webinars.