Author Archives: lkeyes70

One Book: Fixing Microsoft Access Anoyances

If I was allowed only one book about Microsoft Access, This is the one, Fixing Access Annoyances by Phil Michell and Evan Callahan. Just their discussion about Access’ workgroup security is worth the price of the book. They cover mostly Access 2000-2003, with a few notes regarding Access 97. The book includes a fair amount of VBA code, which can also be downloaded from their web site.

The book covers a lot of ground and includes internet resources. One of the best of these remains the community web site, UtterAccess.

Tricks with Trixbox

Trixbox is a pre-configured Asterisk PBX which allows you to create a comprehensive home or business phone system which multiple extensions, and multiple lines. The single TrixBox installation CD creates a Linux server with a web server, database backend, the Asterisk PBX, the Sugar CRM server application, and a set of web-based management tools to manage everything. While all the bits and pieces are available separately, Trixbox automates much of the setup.

Currently, my setup includes two IP phones that look like conventional desk phones. These plug into my local area network. Each has an IP assigned to it. Each is a small web server in itself, as they can be configured using a web browser. I’ve assigned extension 200 to my phone, and 201 to the second desk in the office (John).

When the two IP phones connect to the network and register with the Trixbox, they behave much like regular phone extensions in a corporate office. I can call from one to the other by dialing the three-digit extension. I can put a caller on hold, or I can “park” a call. I can set up a conference call.

Both extensions have voice mail. If an extension receives voice mail, then it flashes its lights to show that there is a message waiting. You can also have the Trixbox automatically forward voice mail to eMail, with the voice message as an attachment. After leaving myself a message from the 201 extension, I received the following message in my Outlook Inbox:


Dear Larry:

Just wanted to let you know you were just left a 0:09 long message (number 1) in mailbox 200 from John, on Wednesday, November 29, 2006 at 06:12:07 PM so you might want to check it when you get a chance. Thanks!

--Asterisk

The voice message was attached as a .WAV file. The names of Larry and John are automatically taken from the assigned names within the Asterisk configuration. I’m assuming you can customize this further…by digging into the configuration.

My outbound telephone connection provider Voicepulse provides a service which completes calls from my PBX to virtually any phone number in the world. Voicepulse accepts calls via the internet and then transfers them to the regular phone system. (see diagram). Voicepulse provides capacity for up to four simultaneous calls. Additional capacity can be added by buying additional “trunks”, which then would allow you to make higher numbers of simultaneous calls. What’s interesting about this is how scalable it is…you don’t need to run wires, or wait for the phone company to come to install additional lines.

Of course, I’m running this with very low volume; since I have a two phones, I can have a maximum of two simultaneous calls. Eventually there will be issues as far as internet bandwidth, and processor capacity. Right now I’m running my Trixbox on an old Dell Optiplex, with a 450Mhz processor.

Chron This Week

In the November 23rd edition of the Chronicle of Philanthropy

Fundraising

Big discussion about the how aggressive fund-raising techniques are alienating donors. Some donors get hacked off after being contacted by telephne on a monthly basis. Well, who wouldn’t?

Grants and Research

The MacArthur Foundation will spend 50 million dollars over five years to fund research into the effect of digital media and the internet on the education and social development of children.

Conferences

Recent non-profit tech conferences:

March 22-24 2006 in Seattle – Non-Profit Technology Conference

March 25 2006 in Seattle – Penguin Day, potential and challenges of using open source software

Effect of the election results

Nonprofit groups should expect no change in the efforts of the Seanate Finance Committee to tighten laws and regulations affecting nonprofit accountability and political involvment, since the views of the possible new Democratic chairman, Montana’s Sen. Max Baucus, seem to be similar to those of the outgoing one, Iowa’s Sen. Charles Grassley.

Unsticking a print job in Windows XP

I never understood why it takes so long to delete a print job that is stuck in a Windows XP print queue. Anyway over at Gizmo Grabowski’s web log, there is a multi-step process to recovering from a stuck print job.

1. On the taskbar, click Start, and then click Run.

2. Enter the following:

net stop spooler (and hit enter)

3. Delete all files in the following folder:

C:\Windows\System32\Spool\Printers

4. Once the spool files are deleted, start the spooler again:

net start spooler

Keeping our Youth in our State

Our local newspaper, the Gannett-owned Burlington Free Press ran an article today entitled Trying to Keep Them Down on the Farm. (Don’t know how long the link will last). There has been a lot of discussion lately about demographics of our state, and how we seem to be loosing our kids, and what will it take to keep them here. I wrote back:

The public hand-wringing about keeping our youth (Monday Nov 27th) seems to miss a couple of points.

I grew up in Montpelier from the age of 2, and attended the Montpelier public schools. By the time I graduated from high school, the last thing I wanted to do was to join the 50% of my college-bound classmates to attend UVM. I was desperate to get out of Dodge. After seeing some of the rest of the country and the world, I was happy to return to Vermont where I’ve now been for almost twenty years.

Secondly, most businesses in Vermont are small, and small businesses can be attractive to young people who want to make a difference in their work life. However, when a small business wants to hire, and is expected to provide health insurance for employees, that can be a $12,000-$15,000 up-front cost for an employee with a family. Uncoupling of health insurance from employment would be the single most effective job creation strategy for our state.

Thirdly, young people like to work in growing industries, in a creative environment. Much of the rest of the country, and progressive countries in Europe and Asia have decided that broadband internet and wireless are essential business infrastructure and that environmental technology and mitigation of global warming are areas of growth. Sadly, led by the Free Press editorial board, and our governor, public opinion in Vermont has written off renewable power, and our state and leaders continue to be obsessed with multi-million dollar traffic projects (Circ highway, Bennington bypass) which will be obsolete within fifty years. And broadband expansion? We’ve left that to Verizon, who is attempting to sell its holdings in rural New England, and to bankrupt out-of-state cable companies.

To put this in a little more context:

1. Verizon is running around Albany New York installing fiber cable to homes. The cost for a triple play (cable, telephone, and internet access) will be equivalent to what I’m paying for cable broadband alone. (no TV….mind you, just broadband). At the same time they have publicly stated that they are minimizing their investment in New England, and indeed they are attempting to sell their landline telephone lines in Maine, New Hamshire and Vermont. Almost anyone in VT who can get broadband can get it only from a single provider. Forget broadband wireless.

2. Anything other than highways in Vermont gets short shrift. The “Circ”, a ring road around the city of Burlington was proposed 30 years ago.

3. Wind projects, which are suitable on a maximum of 5% of the ridgeline in Vermont, and which could provide between 10% and 20% of our electricity have been discouraged by the local media and our governor. Land preservation has also been discouraged by the governor, even though the wilderness areas are a tiny fraction of the land area in Vermont. At the moment we actually get over 50% of our energy from renewables; hydropower from Quebec, and biomass (wood chips). The balance comes from a nuclear energy plant in the southern part of the state and from gas-fired turbines and out-of-state power. The Quebec hydro contracts are due to expire in 2012, and the projected 30-year life of the nuclear plant is due to expire shortly thereafter.

Trixbox/Asterisk PBX

After hours and hours and hours of troubleshooting. I have finally managed to get my Trixbox software PBX to use the Voicepulse service for outbound calling. Kudos to the Voicepulse tech support folks who patiently called back each day for five days. A test call to my mother-in-law sounded fine…better than calls made through the hardware interface to my second land-line.

The problem appears to be the router, a DLink DI-604 router which is admittedly a low cost router, and frankly, one that has worked well for videoconferencing, which is, arguably even more complex than routing voice over IP. But, when I finally eliminated it from the chain of boxes on the way to my cable modem, indeed I was able to connect. So, now, I’m running on an older Linksys BEFSX41. I have the Trixbox in the DMZ of the Linksys router.

So, reviewing: My problem had nothing to do with Comcast. It had nothing to do with the change from Adelphia to Comcast last week. It had nothing to do with Trixbox. It was the router.

Now, there are a couple other outstanding issues. Currently, the hardware connection to the landline doesn’t work any more since my latest reinstall. I think this is a configuration problem. I’m also trying to get inbound service from Voicepulse, but they don’t provide phone numbers in my local calling area.

As part of my troubleshooting, I installed a scratch Asterisk install on a Ubuntu Linux box. Ubuntu is the up and coming distribution these days, and I like it a lot. It is available in various flavors, including a server, LAMP server, Desktop, Educational Desktop version, Education Server version as a terminal server, and several others. Configuring Ubuntu is a snap when the GUI front end is installed, less so when you are mucking about on the command line.

Trixbox uses Cent-Os which is a derivative of Red Hat.

With both distrubutions it helps to be able to use a remote login via SSH. With Ubuntu, I had to install a server to allow this…Cent-Os includes it as part of the base installation. I also installed Webmin, which is a web-based management package, again which allows you to perform the most common system server maintenance from a web browser.

The PBX is nowhere near production yet. I’ve got bits and pieces that work sometimes, but not others, and getting everything to work together seems to be a ways off. I need to set this aside for a few days, and go back to my “day job”.

Enthusiasm Score as of November 20th

Well, it is close to the day of Thanksgiving, and I suppose I should be grateful for all of the wonderful Microsoft software and hardware that I’ve been using for the past year or so. An update on things written about lately, with scores from 1-10, where 10 is the greatest.

Microsoft Office 2007
The components of this comprise the the usual suspects:

  • OutLook 2007
  • Word 2007
  • Excel 2007
  • Access 2007
  • OneNote 2007

After using Word 2007, OutLook 2007 and OneNote 2007 for several months now, through the beta 2 Technical Refresh, I can say for sure that the winner is OneNote. OutLook remains a bloated pig, and in Word, the interface changes are radical enough that the more attractive page output does not necessarily justify the so-called ribbon interface. I’ve tried….really, I’ve tried to like the ribbon, but frankly there is a substantial learning curve there, which is going to be difficult to get people over. Score overall Office 2007 [5], Individual apps: OneNote [10], Outlook [3], Word [5]. I’m reserving judgement on Access…since there is no Access runtime available. I’m looking forward to improvements in the Access security model, which is seriously screwed up with workgroup security in version 2003.

Desktop Search: X1 [10]. A superb product with great support. Microsoft Desktop Search, by comparison, appears to be a typical version 1 from Microsoft. I had to remove it because it would periodically take over my machine and render it useless. It would be nice if OutLook didn’t have a permanent band under the toolbar that reminds me that I need to install MDS.

Desktop Video Conferencing: SightSpeed [10] No serious Microsoft alternative. Microsoft keeps talking about how they are now going to play in the unified messaging space…but they’ll be late to the party. Maybe in two years, when they have version 3?

Operating System: Windows Vista Enterprise [4]. I used the first betas of these but when trying to install the RTM version, I managed to clobber my boot record, and crashed my workstation. I know…they say don’t beta test on a production machine, but how are you supposed to know how a new product integrates with your lifestyle if you don’t use it in context with your daily work? I didn’t mind Vista, and of course new machines will have it pre-installed, but I don’t think it is worth worrying about upgrades. In contrast, people should consider upgrades to Windows XP Service Pack 2, the latest and greatest Windows XP. It appears to be relatively stable, and secure.

The main hope with Vista is that finally you’ll be able to run more software without administrator rights on the desktop. And, I hope, be able to permanently disallow any changes to services. The idea that a spammer can download a worm or Trojan and actually run this on your machine without your knowledge is ridiculous…and it needs to be stopped by the operating system…Sorry Symantec and Trend.

Internet Explorer 7 [3] Finally they have tabs! I prefer Firefox. [10]

Development Tools:
All over the map. I like the Visual Studio 2005 Express editions. [10] I just wish I had more time to play with them. For database work in a Microsoft world, Access is ascendant…with SQL-Server on the back end. Access can’t compare to Visual FoxPro, but with third party support for VFP fading fast, and a commitment by Microsoft for only a final set of libraries to integrate VFP with the .NET technologies of Visual Studio, VFP is a tough call for any new development.

For web development, I’m still using Dreamweaver and the Macromedia Studio 8 suite. [7] I’ve got two applications in production that use ColdFusion as the middleware. [5] And I think Contribute, at about $75.00 a pop…is the best thing for people who need to update an existing web site on a regular basis. [8] It will be interesting to see how Adobe integrates the Macromedia applications…right now they have a confusing conglomeration with a lot of overlap.

On the Linux side, there are interesting things to look forward to: Eclipse, a newly open sourced Java, Ruby, Rails, PHP, and the solid mySQL and PostgresSQL back end databases.

I wish Microsoft would get back to writing software. What’s with MSNBC? What’s with the XBox? Why do they feel that they have to have a finger in every pie? They should focus on the office suite, a decent set of operating systems, and development tools.

Heads-up re RSS aggregator

Goggle offered an upgrade to their blog software, and like an idiot I did it. Everything broke. It seems to have broken the RSS feeds, the graphics location, the archives, and the home button which goes back to the top of the main blog.

The feed problem is fixed by resetting your RSS feed reader, ie. deleting the feed in your RSS feeder in reimporting it from the main blog. Archives work now. And I’m about this far from going to WordPress.

Now that feeds can include ads, I’m wondering how long it will be before even RSS feeds will look like the dog’s breakfast, as do many blogs. The latest innovation I have noticed is two columns of AdSense ads. There is almost no more room for copy. And is anyone actually making any money on these stupid ads?