Categories
Business Geekery Job Hunting

Repost: Languages and Programming Tools

Originally posted May 3, 2007, now archived here.

For further explanation why this post exists, see Intro to Experience Dump. This is the section for programming tools, languages and such. As usual, I may be forgetting some that would fit here. Also, lest one get excited, just because I have laid hands on a language, perhaps written a “hello world” program with it, maybe compared its language and syntax on paper, that does not mean proficiency, or even familiarity. It’s merely indicative of a bit of added depth to my overall background. The only things I’d claim proficiency in are VB through 6.0, Wordbasic from Word 6.0, and perhaps VBA as applied to later versions of Word and Access.

Visual Basic 3.0 through 6.0
QuickBasic 4.5
Professional Devlopment System 7.1
Visual Basic for DOS
VBA
WordBasic
Visual Basic.NET
VBScript
JavaScript
PHP
J
Borland C++
Borland Delphi
MS Visual C++
C#
BASIC
Pascal
Cobol
HTML
Visual Interdev
Visual J++
Visual FoxPro
Rexx
MS-DOS batches
Perl

I think I’ve looked at other things like Python or Ruby, but I can’t remember exactly which, so I left them out of the list. I definitely played with, and helped a friend with, Perl. Guess I should add that. J is something I discovered a couple years back, downloaded and played with a bit. I find it fascinating to look at new languages.

The first six items on the list I supported for Microsoft to some degree or another. Officially in Word support we did not support macros, but that was my specialty and we tended to make exceptions to some degree. That carried over into automation of Word from VB programs, which later meant becoming familiar with VBA when Wordbasic was replaced. Right around the time I migrated from Word to VB support, the first Word macro virus hit. Because I’d shown you could do some mischievous things with macros, colleagues jokingly suggested I might have been the source. Flattering, in a twisted sort of way.

The interesting thing about supporting a programming product is that you get a huge range of exposure that you might not get coding a project, but you don’t get the intense depth in one area that coding a project that uses certain features might impart. You also learn how to find things out in support, which is extremely useful. I always emphasized when providing references that the candidate in question might not know a specific thing – there’s too much for anyone to know it all pat – but troubleshooting and research ability on top of the broader knowledge are a huge benefit. Sometimes it was depressing talking to software developers and realizing just how bad many were, yet they were making real money. Sometimes it was weird having limited knowledge about a customer’s question, compared to them, yet having enough knowledge, access to information, and alternate perspective to cut right to it and look like a miracle worker. Despite having started the call in a panic because you didn’t know much about X.

Then there were the obsolete products we supported for a time. The training was all about VB3 and then VB4. If someone called about the DOS versions of Basic or VB, it got really interesting. Even when it wasn’t someone doing something goofy like running QuickBasic from floppies on an ancient PC without a hard drive. (Perhaps the equivalent in Word support was when someone couldn’t make Word 6.0 run on a 286, where I congratulated them for getting Windows to run and could do nothing for them.) It helped that I had dabbled with BASIC off and on since I learned my first bits of it circa 1977.

Before I even got the job in Word support, I had bought and installed Borland’s C++ product, dabbled with it slightly, and eventually read a book and tried the code it taught. The Absolute Beginner’s Guide to C Programming or something like that; great book. I dabbled just as slightly with some of Microsoft’s versions. Most recently was trying to run and compile a component one of my partners wrote in VC++ to be used from Prometheus, our case/document management product.

Pascal and COBOL were classes in college. That and I dabbled with Delphi, which used a form of Pascal. What was weird was when I read the book Code Complete, it gave examples and comparisons in various languages, and Pascal always looked surprisingly familiar to me. It’s kind of like French from 7th, 8th and 9th grade. I can see or even hear French and it doesn’t sound alien to me the way another language other than English or German might. Years later, when I took German, I’d find myself needing the German word and inexplicably remembering the French word for something, and usually forgetting the German in the process. I’d have told you I’d forgotten it long ago, but there it was, bubbling up.

It’s hard not to have learned some HTML, or at least gotten comfortable looking at it, after having web sites for ten years. Still, I am not a wizard and like tools that make it easier. Thus so much of my work having been done in FrontPage, or using blogging software. Except that both, and especially blogging software, very much call for getting into the HTML, the PHP, the CSS; the alphabet soup of it all. I didn’t include CSS on the list and could have. For that matter, SQL could go on the list, and matters more than a lot of it.

I poked Rexx with a stick when I played with OS/2 Warp, having seen much discussion of it ahead of time among Team OS/2 denizens. I don’t remember anything, but I know I touched it and was naturally curious after hearing so much.

Whereas I did a lot with DOS batch files, which do count as a form of programming/macro language/tool. I still do. My most recent VB program was a quick utility to read a couple of fields from an Access database and write out a text file with traditional file I/O (rather than referencing FSO – File System Objects – and going beyond an EXE that would run fine after a straight copy to the target machine). The fields were original and current paths of archived documents. Restoring them called for a mass of copy commands using the two paths. Nothing fancy.

It’s funny; I could probably have gone ahead and done programming for a living. I’m better than I generally give myself credit for, and certainly more of a natural, but I tended to be surrounded by people who were prodigal by comparison. In a business started originally to write software, that was why I was the business guy, along with some testing, user interface work and such. I’m good at orchestrating the activities of other people, understanding requirements, and grasping a whole project. I’m good at debugging existing code. I’m good at making attractive and usable interfaces, or improving existing ones. Sometimes I think about it and it seems cool. Sometimes I think about it and it sounds onerous to have to maintain that level of concentration all day, each day. Which is not actually how it works, because that just isn’t possible, which is one reason why production of code isn’t as voluminously fast as some less technical types might anticipate. These days I think about it and worry about having to get up to speed on new tools.

When dotnet came out, none of us were doing Visual Basic support anymore. That meant we wouldn’t receive the customary training and were on our own. While I and others checked it out on our own to some degree, which was frustrating when it took forever to figure out how to do the equivalent of Form2.Show and other simple things that were the beauty of VB, it wasn’t the same. So I organized a couple of day long sessions at my office. A bunch of us gathered around several computers and banged away at it, getting pointers from anyone who knew more about or was faster to figure out a given thing. It was excellent. We also had some partial training material from within Microsoft to look at. Other than that and playing with it (and C#) a bit before and after, I’ve not used dotnet. Code I’ve maintained or worked on has continued to be in VB6. There was no reason to change that.

Oh, forgot VBA. I’ve used it directly and through automation in MS Office products. I’ve also looked at the VBA kit that came with MSDN, and in at least one non-Microsoft application. I seem to recall that having been Lotus WordPro, and the app-specific commands having seemed rather obscure even by Word VBA standards. One of my partners created an Access-based application using VBA, a custom billing program, for a groundskeeping business. I helped with it some, and was primary contact for the customer. Actually, I ended up doing most of the support, debugging and testing. It seemed best to use Access directly, because of the convenience of generating reports as invoices. It was so shaky (mainly prone to collapse under the slightest bad data) that a real program in VB might have been better and not much more time-consuming. We ended up charging what the customer was willing to pay, which was about a third of what it was “worth” by the hour, yet still very real money. The partner had nothing else doing at the time. At any rate, that was a big education in Access VBA.

There you have it. This will sort of overlap one of the remaining sections, in which I list and discuss software I was involved in creating (or attempting to create) on at some level. I believe all that’s left is that and a partially redundant collation of server-based software. Then it’s on to other things.

Experience Posts (links to reposts):

Intro to Experience Dump
Hardware Experience
OS Experience
Word Processing Experience
Spreadsheets and Accounting
Graphics and Presentations
Database and RDBMS
Dictation Software
Communications, Internet, PDA, Blogging
Legal Industry Software
Backup and Compression Software
Miscellaneous Software
Security, Spam, Malware…
Call Center and Tech Support Tools
Languages and Programming Tools
Server Software
Software Creation

Employment and College
Experiences and Accomplishments Scratchpad

Categories
Business Geekery Job Hunting

Repost: Call Center and Tech Support Tools

Originally posted April 29, 2007, now archived here.

For further explanation why this post exists, see Intro to Experience Dump. This is the section for call center and tech support related software. As usual, I may be forgetting some that would fit here…

Aspect call center monitoring
Microsoft PSS Workbench
Clarify Compass
Wadle
MSDN
Technet
Escalation Assistant
Web Response Tracker
Web Coach
Training Evaluation
V-BeGone
Regclean

The first four items were a part of doing Microsoft support and, later, being a technical supervisor. MSDN and Technet were tools we also used at times, and sort of indirectly support the use of.

Escalation Assistant was a program I wrote, used in VB support, to gather the appropriate information about a case – ensuring that people did indeed gather as well as include all of it – before escalating to second level support. It would format the details and put it all on the clipboard to paste into Compass. The people handling escalations were very appreciative.

I helped pioneer “web response” online support by the VB team. Initially I volunteered to do web responses between calls, during one of the rare times when we were adequately staffed. One Monday, the second level contact at Microsoft assigned me all the web responses the weekend guy had summarily escalated because he’d not had time to do them, effectively choosing me to do web responses, rather than phone support, full time. Since I loved writing responses and hated taking calls, that was fantastic.

We ended up with a team of people doing them, me in the lead. I supervised the creation of a program for tracking the web responses we did. In fact, it was Dale’s mother who wrote the program and worked with me on getting it just right.

When I became a supervisor (“technical development lead,” TDL for short) and phased out of doing web responses, one of my jobs was “coaching.” That is, listening to people and giving them feedback on their support calls. How do you do that with written responses? How do you randomize it? I wrote a little program to randomly select a case to read, for a selected support tech, during a specified time period.

Finally, as TDL I ended up in charge of training, which turned out to be one of those things I do best (which really is a specific application of a more general trait). Not the training, though I’m good at that too, once I get past the terror of speaking to a group, but planning, orchestrating, and changing the details as circumstances dictate. I did a few parts myself, but for most of it I lined up others with the appropriate strengths.

It had been traditional for the trainees to fill out paper evaluation forms. I supervised and tested the creation of a program to gather the same data, which put it into a more useful format.

You know, it just occured to me to wonder where one might mention things like making Regedit dance and sing, or using sysinfo, dxdiag, or whatever. That reminded me of Regclean, which I seem to recall was originated by someone on the VB (or perhaps developer support more generally) team at Microsoft as a way to cleanup obsolete registrations of OCX files and such. That in turn reminded me of a utility called V-BeGone, written by one of my colleagues. We used it to have people comprehensively get the OCX and OCA files specific to Visual Basic (as it existed at the time) out of the way without affecting third party controls.

Some of this overlaps with one of the two remaining categories of software I have for entries such as this. One is stuff I wrote, managed, or was otherwise involved in. The other, overlapping other categories, is server software. Then I’m done with the list-centric part and can consider moving to the more task or accomplishment or “what I liked doing” part, which some of the above has also overlapped. Correction! Three remaining categories. How can I mention doing VB support and not have a category for programming and related software and tools? Silly me.

Experience Posts (links to reposts):

Intro to Experience Dump
Hardware Experience
OS Experience
Word Processing Experience
Spreadsheets and Accounting
Graphics and Presentations
Database and RDBMS
Dictation Software
Communications, Internet, PDA, Blogging
Legal Industry Software
Backup and Compression Software
Miscellaneous Software
Security, Spam, Malware…
Call Center and Tech Support Tools
Languages and Programming Tools
Server Software
Software Creation

Employment and College
Experiences and Accomplishments Scratchpad

Categories
Business Geekery Job Hunting

Repost: Security, Spam, Malware…

Originally posted April 29, 2007, now archived here.

For further explanation why this post exists, see Intro to Experience Dump. This is the section for security, antivirus, anti-malware (adware/spyware), and related software. As usual, I may be forgetting some that would fit here…

Sybari Antigen & Spam Manager
Norton Antivirus/Internet Security
Norton Antispam
Thunderbyte Antivirus
McAfee
Ad-Aware
Spybot Search & Destroy
Ewido
MS AntiSpyware
CWShredder
Trend Micro Housecall
ZoneAlarm
KEYKatcher

Not a lot to say here. I’ve done outrageous amounts of malware cleanup, with a lot of it being done or completed manually, above and beyond any of these tools. I selected and rolled out Sybari Antigen to the big client, after I finally convinced them they needed at least that level of protection, then two years later we renewed to include the integrated Spam Manager feature. Antigen was never anything but stellar. Spam Manager worked superlatively until a point roughly coinciding with Microsoft’s purchase of the company (of which they’d been a customer after lab testing showed them to be hands down the best), but that may be coincidence.

KEYKatcher is the odd item here. I helped the owner of the large client purchase and learn how to use the unit. It was for seeing what one of his kids was doing online, or so he said. What made this interesting was the first one I got failed in a fascinating way. I ended up working with the owner of the company that makes them, trying to figure it out before sending it back so he could study it, because it was unique. It’s a device (it could have gone in the hardware section that goes between the computer and keyboard to log keystrokes, which can then be dumped into Notepad or any word processor, triggered by typing the right code.

It’s not security-related software, but the most useful thing I ever did, after eliminating e-mail as a virus source, was to roll out Firefox and get as many people as possible to use it unless a crucial site absolutely required Internet Explorer. The malware cleanups became primarily for those who insisted on using IE or, coincidentally or not, had a third-party nagware screensaver installed.

Experience Posts (links to reposts):

Intro to Experience Dump
Hardware Experience
OS Experience
Word Processing Experience
Spreadsheets and Accounting
Graphics and Presentations
Database and RDBMS
Dictation Software
Communications, Internet, PDA, Blogging
Legal Industry Software
Backup and Compression Software
Miscellaneous Software
Security, Spam, Malware…
Call Center and Tech Support Tools
Languages and Programming Tools
Server Software
Software Creation

Employment and College
Experiences and Accomplishments Scratchpad

Categories
Business Geekery Job Hunting

Repost: Miscellaneous Software

Originally posted April 26, 2007, now archived here.

For further explanation why this post exists, see Intro to Experience Dump. This is the section for a few odds and ends of industry-specific (other than legal), hard to classify or one of a kind software. I may be forgetting some that would fit here…

Dental practice software – a couple of them
Restaurant menu creation software (may have been MenuMaker)
UPS Worldship
wINDEX
Grammatik
Lotus Organizer
MS Project
Brother’s Keeper
Family Tree Maker
WavePad
Lyris (music program)
iTunes
Winamp
Nero Wave Editor
Automap Streets
Google Earth
Lantastic
Norton Utilities
PC Tools
Norton Ghost
FMS (Franchisee Management System) for PDA (Property Damage Appraisers)
ADP automotive estimating software
Mitchell’s estimating software

The dental stuff is from free advice to my dentist, and a look at her new system when she got it, and evaluation of dental software for another dentist my partner didn’t quite manage to land as a small client. I’m not counting the quick showing off of their new (a few years ago) wireless data entry system my doctor showed me, which I also read about. Very cool, and now they’re going completely paperless as far as patient charts.

The menu software was on a machine I replaced for a restaurant owner, so I installed it on the new one and got to play with it a little.

I’ve encountered UPS Worldship in a couple of places. While in one I mainly just installed and configured it, in another it was a major troubleshooting exercise in the office in the client’s warehouse when it wouldn’t work properly.

wINDEX was an old DOS program for creating book indexes. I got to play with that years ago when a friend was contributing to her family’s income by doing indexes, which frequently used to be farmed out to people like her working from home.

I bought Grammatik as part of a package along with WordStar 5.0, and found it a highly entertaining early effort at grammar-checking. Considering how long ago that was, and that grammar checking still doesn’t work, almost but not quite to the point of uselessness, it was a surprisingly good effort. Ironically, a grammar checker is most needed by someone who can’t write, but people who can’t write have a harder time knowing when the software is being silly and ought to be ignored.

Lotus Organizer wasn’t, IIRC, also an e-mail program like Outlook, but more of a standalone calendar an PIM. I liked it a lot, though never used it heavily myself.

If I recall correctly, the main reasons I ever looked at MS Project were curiosity, and because a customer was trying to use OLE (COM) automation of it from a VB program. Come to think of it, I may also have helped my brother-in-law, who had actual uses for it.

Brother’s Keeper for DOS and Family Tree Maker are my dabbles with genealogy software, mainly the former. One of my colleagues in VB support was trying to write his own, which I thought was cool, and got some help from me. I still use Brother’s Keeper, and only recently learned that it still exists as a product and now has a well-regarded Windows version.

Naturally I have used or played with or helped with various music and sound players, creators and editors. I find that kind of thing especially cool, which makes me eager to see my brother get the computer and gear he needs to do his own basic recording, editing, and music CD creation.

I love maps! I used to buy and hang wall maps in my room. I love atlases and globes. Google Earth has mostly superceded it, but I was a huge fan of Microsoft’s Automap Streets. I’ve owned a couple different versions, dating back to when I had a discount available.

Lantastic should probably have gone under the online and communications part of things, and may yet fall under a partially duplicative server and networking post. I knew it inside-out when I did support Tranti POS systems. On one level it made sense to use an off-the-shelf network solution to link the machines. It ended up being a problem, as there were just enough issues with it to create bad situations over which they had no control. If your 50 ohm terminator was bad, we could replace that. If something funky with Lantastic or the environment made one of your drivethru order station stay in an “off” state when the rest of the system registered an “on” state… that was ugly.

Which also leads me to note that besides legal software, other specialty or oddball software not included here is the above, timeclocks, accounting-related, call center software, and things I wrote or was involved in creating.

Aw heck, I’m going to add a couple of orphans to the list before I’m done. I’ve used at least a couple of incarnations of Norton Utilities. I used to swear by PC Tools. I think I used at least two versions of that, also. There may have been other such utilities. Certainly other utilities, anyway, including some things Microsoft eventually incorporated into the OS, or things too obscure to mention, like disk copying software. Ooh, make that three things. I’ve also fought with Norton Ghost. Which should probably have gone in a different section; I just happened to remember it now. There’s just been too much for me to remember it all. This is meant to be a “mostly” overview, making clear the scope and range of experience, not an exhaustive list. I also have no plans to include games anywhere, though getting some of those to work at times has given me some of my best challenges.

Update May 7, 2007 – Added FMS, which I mentioned in passing under databases, then forgot to include here (or under accounting, which would also be valid). Also added the two automotive estimating software packages I have supported. Amazing I’d forget them. There were some other utilities used in the same office, like one for dialing a service with salvage yard pricing and parts availability, but they were less significant and I don’t remember their names.

Experience Posts (links to reposts):

Intro to Experience Dump
Hardware Experience
OS Experience
Word Processing Experience
Spreadsheets and Accounting
Graphics and Presentations
Database and RDBMS
Dictation Software
Communications, Internet, PDA, Blogging
Legal Industry Software
Backup and Compression Software
Miscellaneous Software
Security, Spam, Malware…
Call Center and Tech Support Tools
Languages and Programming Tools
Server Software
Software Creation

Employment and College
Experiences and Accomplishments Scratchpad

Categories
Business Geekery Job Hunting

Repost: Backup and Compression Software

Originally posted April 20, 2007, now archived here.

For further explanation why this post exists, see Intro to Experience Dump. This is the section for backup, compression and associated or related software. It was going to be the various backup software only, then I realized that burning a CD and using something like Winzip are related things, and it would reduce the size of the “and other utilities” category. I may be forgetting some that would fit here, but you get the idea…

Microsoft Backup
ARCserve
Retrospect
Veritas Backup Exec
Stomp PC Backup
PKZip
Winzip
NERO Burning ROM
Adaptec/Roxio
Stacker

Stomp and my first look at Retrospect were help with evaluations or troubleshooting by my partner for someone he had as a personal client without putting them through the business. The big client used ARCserve from way back, original under Novell. Later they switched to Veritas backup Exec, which I liked even better and which, at least at the time, had a reputation as best of its kind. The people we outsourced their upgrade to last fall completely ignored the presence of the infinitely superior Backup Exec, replacing it with Retrospect, now an EMC product, which gave me some experience fighting with it and trying to puzzle out how anybody could have created such an obscure maze of unusability.

I used to be able to make PKZip dance and sing, and even resisted Winzip for a while. Eventually I bought five Winzip licenses to reward them for being so good and useful. I don’t recall ever using a Winzip competitor, but I did do a support call once with a guy who told me his product competed with them.

NERO is my favorite CD burning software. I found it entertaining when Microsoft adopted Roxio as the native software for XP and made sure NERO as packaged with CD burners wouldn’t work. The archiving and CD burning computer at the big client still has Adaptec software, which works just fine. That machine has a fancy SCSI Plextor burner in it, which added over $200 to the cost of the machine back when ordinary CDRWs had already fallen below $100.

Putting Stacker into this list is a bit of a stretch, but I did use it heavily in its heyday, and was entertained by the whole Doublsespace/Drivespace thing. I never used Stacker or anything similar again after it killed my original 60 MB MFM drive, which was cannibalized out of my Packard-Bell 286 to build my original 386. I still have the corpse of the 286, the 386, which probably still runs, the MFM drive, the MFM controller, and I think I may have bought a replacement MFM controller in case that was ever the problem. I had a grand scheme of making the 286 work again, as original equipment as possible, as a “museum piece” of sorts. Heck, I still have the Color Computer 3, which as far as I know is primarily afflicted by partial failure of the external floppy drive. I loaned it to my brother for a while, circa 1989 or 1990, and he had fun but it wouldn’t write to disks. Ah, the other problem was it stopped sending a video signal to my old 13″ black and white TV, which apparently had more to do with the TV or the splitter box than with the computer. But I digress.

Experience Posts (links to reposts):

Intro to Experience Dump
Hardware Experience
OS Experience
Word Processing Experience
Spreadsheets and Accounting
Graphics and Presentations
Database and RDBMS
Dictation Software
Communications, Internet, PDA, Blogging
Legal Industry Software
Backup and Compression Software
Miscellaneous Software
Security, Spam, Malware…
Call Center and Tech Support Tools
Languages and Programming Tools
Server Software
Software Creation

Employment and College
Experiences and Accomplishments Scratchpad

Categories
Business Geekery Job Hunting

Repost: Legal Industry Software

Originally posted April 18, 2007, now archived here.

For further explanation why this post exists, see Intro to Experience Dump. This is the section for legal industry software. It’s less likely I am forgetting things than in some other sections, but it remains possible.

West Publications Premise
West Publications LawDesk
Lexis-Nexis
Loislaw
Shepard’s Citations
Couch on Insurance
Wintitle
FRED.net
Winlaw
Prometheus
Amicus Attorney
Legal Files
AbacusLaw
Lawyer’s Diary PC Edition
Turbolaw

Naturally I’ve worked with the legal research and associated software, mainly Premise 3.72 and 4.0. I helped with evaluation of Lexis-Nexis and Loislaw research.

Wintitle and FRED.net are associated with real estate practice.

Lawyer’s Diary PC edition incorporates and expands upon the content of the annual bound Lawyer’s Diary. Most people prefer the book, but some are avid about the extra features in the (rather oddly designed, IMHO) software. They make it such a pleasure to update a network installation, I look forward eagerly to doing so twice a year, much as I look forward to root canals and such.

I once had lunch with the guys behind Turbolaw. It’s a package centering around templates and automation of Word and Excel to populate the appropriate forms you’d file in certain types of cases, like family law (divorce) and worker’s comp. One attorney needed it. I noticed the name of the company was Promethean Software, and I mentioned to them that we were working on law firm software named, or at least codenamed, Prometheus, so their name caught my eye. That led to a lunch meeting up in Fitchburg between a few of them, me, and my partner who was primarily responsible for Prometheus, and the name. At first, on the phone, one of them thought the name was no big deal. Later they asked us not to use it, to avoid confusion. Oddly enough, despite some of us not having cared for ‘Prometheus,” and people jokingly referring to it as “Promiscuous,” we never did come up with a catchier name. We showed them some printouts of screens as it stood then, and talked about what it would do. They were terrified by it, because had we wanted, our product could easily have incorporated the functionality of their less comprehensive but more specialized product. There was some discussion of sending them a beta to play with when it was ready, and doing joint marketing of the two products. That would have been a huge boost. Subsequently my partner stopped working on it for a while, then started over from scratch.

Which brings me to the whole case/document manager thing. We did some evaluation of products in the genre, which is part of what led to Prometheus, as we thought we could do it better. Which when the iron was hot might have been true.

Winlaw was the reason we even knew about such things. Winlaw was software by a company named The Counsell Group, or TCG, which eventually dotcommed itself into being Breakaway Solutions and then defunct. The big client hired TCG to create Winlaw, as apparently nothing available “off the shelf’ at the time would do. TCG had plans to make a version for wider sale, and even trademarked the name Winlaw to reserve it for legal software purposes. It’s a great name, especially when you consider it dates back to the days of prefixing software names with “Win” being all the rage.

There were problems. Mainly the problem was that it was a VB3 app using a shared Access 1.0 database as the backend. Access data was never meant to be shared by 40 – 50 users. It locked. A lot. To the point of being down something like 45 minutes per day per user.

We were hired to fix it. The client settled with the original vendor and got full and unfettered ownership of the code for the purpose. We improved performance, ported it to VB5 and later VB6, migrated them to SQL Server as the real way to eliminate any locking, and had it stable since the beginning of 1999. Subsequently we added a utility to enforce data gathering about each case at the time it closed. I improved the user interface, made it so some defaults could be set, made it so searching could be done for exact or “like” (wildcard) matches, and that sort of thing. I also discovered and fixed a longstanding bug in the original code, whereby it could and did, fortunately rarely, overwrite a document with a new document of the same not-quite-random name. I also wrote a separate utility that could copy all the documents for a case to a specified location, or archive them, which was the same except for deleting the documents from the server if it copied them successfully.

My partner got it the majority of the way done, then decided it would be far better to write an all new program. We would offer the client a version specific to them to satisfy the project requirements, but also be able to market a generic release to other firms. That was Prometheus. The first incarnation of it, largely complete, was used by a couple people in a small firm. They stopped using it only because it was overly oriented toward the types of cases the big firm handled, and was overkill for them. When I pushed for a more complete version because we had someone else wanting to use it, who would test it more effectively, my partner quickly created a new (admittedly improved) but similarly undercooked version of Prometheus. I managed to clean up some loose ends and make it installable, so we had six people using it for a couple years. The main problem ended up being that it couldn’t handle PDF files, and I couldn’t rapidly enough make it do so.

It remains kind of cool, but simple compared to most of the case/document/practice management software out there. I had wanted to put out a basic version, even just as freeware/shareware, just as basic document management for anyone. That never happened, but it might.

Besides Winlaw and Prometheus, I have actually supported Amicus Attorney, which didn’t impress me. I’ve played with Abacus, and possibly others I’m forgetting. Legal Files is the excellent, if somewhat complicated, product the big client is moving to from Winlaw. I helped them decide on it. I’ve played with a demo version and worked with the sales and development people there on migrating data and documents from Winlaw.

Have I forgotten any legal-oriented software? Probably. I didn’t forget Juris and its associated apps, which are under spreadsheets and accounting. Other software, like Quicken, isn’t legal-specific and I dealt with in other than law firm environments. If anything comes to mind, I’ll update.

Experience Posts (links to reposts):

Intro to Experience Dump
Hardware Experience
OS Experience
Word Processing Experience
Spreadsheets and Accounting
Graphics and Presentations
Database and RDBMS
Dictation Software
Communications, Internet, PDA, Blogging
Legal Industry Software
Backup and Compression Software
Miscellaneous Software
Security, Spam, Malware…
Call Center and Tech Support Tools
Languages and Programming Tools
Server Software
Software Creation

Employment and College
Experiences and Accomplishments Scratchpad

Categories
Business Geekery Job Hunting

Repost: Communications, Internet, Handheld and Blogging

Originally posted April 17, 2007, now archived here.

For further explanation why this post exists, see Intro to Experience Dump. This is the communications and internet related section. It probably leaves off various modem dialing software I’ve forgotten, but remains a long list covering a ton of ground. I considered breaking it down further, but what the heck. In no particular order (actually, I’m attempting to group things logically), the list as best I can remember…

Blue Wave offline reader
Wildcat!
Procomm
Various modem software
Various fax software

Outlook
Outlook Express
Thunderbird
MS Mail
Exchange client
Lotus cc:Mail
Lotus Notes
Eudora

Exchange Server
Ipswitch Mail Server
Internet Information Server
NSlookup

Internet Explorer
Lynx
Firefox
Safari
Netscape Navigator
AOL software

FTP Explorer
Cute FTP
Filezilla

Webex
PC Anywhere
Remote Desktop Connection

FrontPage
w.bloggar
pMachine
Wordpress
Expression Engine
Movable Type
phpBB

Blackberry software
Various Palm and other PDA/cell phone utilities
Microsoft phone software

AOL Instant Messenger
MSN Messenger
Yahoo Messenger
Google Chat

Arrow mailing list software
Lyris List Manager
Mailman

Wow! You got that all? Basically it’s miscellaneous early stuff, e-mail clients (dedicated or multipurpose), server stuff and utilities, web browsers, FTP clients, remoting tools, blogging tools and web page editors, handheld and phone stuff, and chat software. Added later, it includes mailing list software too. There are undoubtedly things I don’t remember, even apart from what’s covered under “various…” whatever entries. For instance, I know I used DNS tools on the same dedicated server that had Ipswitch mail, but I couldn’t tell you what that was called. I’ve used other utilities of that sort, and also you wonder when is it networking and when is it internet or communications related. Now for some details and history, which promises to be somewhat lengthy.

I wanted to get a modem for my Color Computers, but it would have plugged into the same funky slot used for the overpriced external floppy drive, making it kind of hard to run the computer at the same time I connected to one of the numerous local BBS numbers the anomalous (and short-lived) clueful guy at Radio Shack gave me. My first modem went in my first 386 instead. As I recall, that was 1200 baud, followed shortly by a 2400 my mother got me for Christmas. I knew a guy who ran a BBS in Boston named Tangent. I became addicted to that, which already included people I knew. He got UUCP feeds of newsgroups, including the VB and Robert Jordan ones at my request, and of course was on Fidonet. I checked out other boards, but mainly that was home.

Through that, my very first internet e-mail address ever was @tangent.shore.net, before he got a domain. Unrealized by me at the time, my second e-mail address was @microsoft.com, via Microsoft Mail, through which we were directly on their mail system, even though we were outsourced. Ultimately Tangent got a domain, vader.com, so my first non-work, non-subdomained e-mail address was there, using the same alias I use for blogging. I posted a lot on the comp.lang.basic.visual.misc newsgroup, in the heyday of a guy named Jens Balchen, along with some other regulars. Probably a little weird to work all day supporting VB, then post free answers for people, but I’m a geek. I specialized in setup wizard and app distribution, and in automation of Word from VB apps, so I tended to latch onto those posts. My very first web browsing was through the BBS, too, via the Lynx text browser.

In a way, the first killer e-mail and newsgroup app for me was Blue Wave. Even on a dialing plan that made Boston free, occupying the phone line ad nauseum wasn’t always a Good Thing. An offline reader was perfect, and it was a great program. I wrote in praise of Blue Wave in a team newsletter I published (and ended up writing most of) when I was in Word support. Somewhere I probably still have floppies full of QWK packets I saved for future reference, though I eventually recycled many such floppies for other uses.

I never ran a BBS myself, but I got a copy of Wildcat and played with it wistfully, which helped me understand the sysop side of things even better. By the time I might have been thinking of hosting a BBS, I got on the internet proper. My first ISP was a fly by night named Nexus, and my first e-mail address via my very own ISP was @nexuswww.com. That company closed without notice and walked away with about five months I had prepaid. I turned to a more stable outfit then, ICI, and was with them or their successors from… that must have been 1996… until early 2004, and then for another year or two as a backup ISP for work, and finally I am still with them on an e-mail account only basis, eleven years later.

But I think this qualifies as digression, even as detailed and history-recounting as I mean for these posts to be.

The e-mail clients are almost self-explanatory. When I was at Corporate Software/Stream, we used cc:Mail internally, and eventually that switched to Lotus Notes Mail. We used Lotus Notes all along, for other things. I was at the periphery of some actual Notes database work one of my colleagues did, though I don’t recall doing that myself. Nobody liked Notes mail. We also used MS Mail, while we were still directly on Microsoft’s mail system. Eventually that was pulled. Then later still, when customers expected to e-mail us things @microsoft.com, we again got Microsoft addresses, routed through and administered by the Mail and Exchange support team. I believe that was when we used Exchange client. I know I used it at some point.

I’ve used Outlook Express extensively, Outlook some, and tried Thunderbird a couple of times. I helped someone with Eudora. I’ve supported Outlook extensively, mainly 98 and 2003.

As mentioned, Ipswitch (IMail) was both what I used for webmail at one time, and what I administered for a year on a dedicated server. Later I got the big client on the internet, via four channels of a T-1 that was otherwise used for phone service, and setup e-mail to go through their proxy server to Exchange. I installed and administered Exchange 5.5, IIS, proxy server, set them up to use Outlook Web Access. Later I got other clients online through DSL, and one of them on Exchange under Small Business Server 2003. I’ve recently done some of the administration of Exchange 2003 for the big client.

I mentioned Lynx. Naturally I’ve used IE. I preferentially use Firefox. I swear I remember using Safari once, can’t remember exactly where, and think it must have been on the Apple laptop of a graphic designer/marketing person I worked with on the big client’s web site design. Which means I’ve used more than just the two Macs eons ago I mentioned under hardware. I don’t think I have used Opera, but I could possibly have tried that or other browsers. Oh! I have used Netscape Navigator, come to think of it (he exclaims, scrolling up to add it to the list, which just wasn’t big enough already). I’ve actually supported AOL hands-on for people, which is why that is on the list. Always exciting.

I am a command line FTP person going way back. I still resort to it sometimes, depending what I’m doing and whether there is a decent client handy. To do something like upload every file for a new WordPress install efficiently, you want something like Filezilla. Not FTP Explorer, which tends to “forget” files if you have it do an upload that includes files in subdirectories. For one or a few files, command prompt works great. At least, it does if you’ve long since learned all the basic commands and can whip them out and employ them any time.

I’ve used PC Anywhere off and on since 1993. Host was loaded on the primary workstation POS on the Tranti systems, and we could call in using PC Anywhere Remote. That was used more from home, given the limited PC resources we had available at the office.
I also used it to administer a dedicated server, and in helping with computer support for my father’s business.

With Webex, on the other hand, I have only been on the receiving end, working with Juris support on a major problem that after tens of hours of my time turned out to be an obscure file version mismatch. It’s cool. As is remote desktop connection, which I’ve employed recently, enabling me to do almost everything from home that I’d have gone on site for before.

I created my first personal web site in 1996 or 1997, and have maintained a business site since 1997. While I’ve naturally learned some HTML and such over the years, I always found FrontPage handy. Even if I’m using blog software, it can be handy for prototyping or comparing color combinations.

Obviously I blog. I’ve used Blogger, which isn’t listed, and the other blogging systems that are. I most recommend WordPress or Expression Engine. This is the item that particularly made me wonder if I should divide this up, as I could mention details about my blogging experience. However, what that really means is that I should tout things like running Carnival of the Capitalists in a later section that doesn’t center around a software/online tool list and elaboration thereon. I added phpBB to the bog list because a while back I made an extensive but ultimately unsuccessful attempt to help another blogger fix problems with it.

Did you know Microsoft once made phones, and voicemail software used on your computer in conjunction with them? Yup! I bought that system sometime after moving to Quincy and ran it on my old Pentium 200, which I replaced in 1999 with a P3 500, which wasted no time in frying completely – worst computer failure I’ve ever had, personally, and maybe the worst I’ve encountered at all – and being replaced by the P3 1000 I am typing at now. I’d still have it if the phone portion hadn’t died. It was pretty cool. At one point I figured out how to get WAV files of people’s messages out of temporary files to keep them for posterity.

I’ve helped various people with cell phone synchronization, and done a lot of installing Palm desktop software and helping people with it. It was years ago I first supported a Blackberry. One attorney bought a used Blackberry and got the service such that she could have e-mails forward out to it if she left her computer and Outlook running. I filtered it so she’d get only the most important stuff. It may have been that experience that led me to get a Blackberry myself last year. Price probably didn’t hurt. Luckily mine is direct, not relying on slinging e-mail back out from my computer as it arrives. I synchronize my Outlook tasks and calendar, and my Outlook Express contacts. Addiction is a terrible thing.

I’ve used the various chat programs, speaking of addictive. I’ve actually broken the habit long since. It was too easy to be interrupted by people you might not have wanted to know you were at your computer. I later started an AIM account specifically for support, then never used it. I think such a thing has potential, so we’ll see.

One of my friends and former colleagues discovered that MSN Messenger exposed an object model through which it could be automated with VB code. To a degree, anyway. I recently made the same discovery about iTunes. I was whipping together a simple program to automate restoration of archived documents (batch file does the work, but the software builds the batch file, rather than a lot of copy, paste, edit, replace trickery), so it would take me a few hours rather than, say, twenty. I briefly tossed in code to launch iTunes and start playing the default list, just for the sake of curiosity. Anyway, I helped a little with the MSN automation, and trying to fix it once Microsoft broke it by changing the object model drastically. That was helpful of them, and I don’t believe we ever succeeded.

Finally, there are mailing lists. I have run a mailing list for former colleagues in Visual Basic support for upwards of seven years. For a while I ran one for former Access support people, and one for job hunting, to share both positions available and wanted, share advice on resumes, etc. I forget what tool I was using on the original web host, where e-mail was Ipswitch IMail. Later I had an overpriced 64k partial T-1 connection in the office. I checked out Lyris, but it was Linux-oriented and wasn’t going to work for me. I found an excellent, easy to use list software called Arrow and ran that on an old P90 with NT, right in the office. Eventually I ended up using Mailman, associated with the web hosting. I use the same thing for the Carnival of the Capitalists mailing list.

I guess that’s it. I still wonder if maybe I ought have divided this section into smaller bits. Or perhaps explained it less. And this doesn’t count whatever I’ve forgotten…

Experience Posts (links to reposts):

Intro to Experience Dump
Hardware Experience
OS Experience
Word Processing Experience
Spreadsheets and Accounting
Graphics and Presentations
Database and RDBMS
Dictation Software
Communications, Internet, PDA, Blogging
Legal Industry Software
Backup and Compression Software
Miscellaneous Software
Security, Spam, Malware…
Call Center and Tech Support Tools
Languages and Programming Tools
Server Software
Software Creation

Employment and College
Experiences and Accomplishments Scratchpad

Categories
Business Geekery Job Hunting

Repost: Dictation Software (and a ton of history)

Originally posted April 13, 2007, now archived here.

For further explanation why this post exists, see Intro to Experience Dump. This is the dictation related section. This is a short category. In no particular order, the list as best I can remember…

Dragon Naturally Speaking
IBM Via Voice
L&H Voice Express
Phillips handheld dictation/transcription software

There may have been other software that would fit this category, but these are the big three voice recognition products, plus the one digital device and its associated software I am currently supporting.

Voice recognition software is of special interest to me dating back to 1984 or 1985. For my major we had to take two computer science classes, plus a “data processing” class that fell under the Management Science department rather than the Math department. At the time, the class was a relatively basic “all about computers.” Which was pretty weird, because most management students were taking a very similar computer class offered just for them by the computer science people, then taking BASIC. A semester or two after I took it, they got PCs, courtesy of a donation from Shaw’s Supermarkets in thanks for a big study done for them by the marketing students, and the class changed completely. They taught segments on Lotus 1-2-3, some word processor, I believe some other packaged software, and some elementary RPG (Report Program Generator) stuff. Which I might not have known, but I actually helped a couple of classmates with their work for that class, even though I had never taken it or learned the stuff myself. Classic me. When I took the class, we had a great professor named George Ladino, who not long after left to work in “high tech.” Which seemed to me the thing I might want to do, but I thought I’d always be behind the curve and never have adequate qualifications, connections or whatever. Heh.

Given my terror of speaking before a group such as a class, it is particularly notable that he required us each to do a presentation to the class on an assigned topic. Mine was voice recognition. After all, computers were getting all advanced and stuff by then, so why should Scotty have to settle for quaintly typing. Talking your computer down from the ledge had to be right around the corner.

That was how I learned about Ray Kurzweil, the work he was doing, along with the work IBM was doing, and how tricky an exercise it was. The fascinating subject helped ease the pain of public speaking, to the extent that was possible.

Flash forward to 1998. Well, sometime before then, really, when I first saw Dragon being promoted at computer shows and thought here was the eventual result of all that early work on voice recognition. In 1998, though, when we first connected with the big client, they’d been dabbling with voice software. Several of the attorneys had Pentium 200 machines, for which they’d seriously overpaid, with Windows 95 and awful no-name sound cards, on the idea they would dictate using IBM Via Voice. Between the hardware, the state of the software at the time, and the natural dragging of heels that never stopped, that didn’t go over so well.

They were still interested in the idea. At least, the more tech savvy people were, though the owner, who never participated until recently, had been partially behind the original push. He dreamed of paperlessness from way back, before it was remotely as possible as now. It’s a schizophrenic dichotomy, bouncing between grand vision and revulsion at spending to even get part way there.

It was the desire of some to dictate using voice recognition software, and the clear failure of the earlier software and hardware at the task, that prompted them even to think about starting to replace computers in 1999. There were computers that were obsolete in 1999, the last of which was not retired once and for all until November 2006. The last retiree was replaced by a machine that had been new in 1999 and was obsolete in 2006, but hey…

In early 1999 we purchased Dragon Naturally Speaking Preferred 3.0, and the corresponding current versions of IBM Via Voice and Lernout & Hauspie Voice Express. We and a couple of the lawyers tested them. Dragon won, no contest. It wasn’t even close. As I recall, IBM was the next best option. Varying numbers of people have used Dragon ever since; 3.0, 4.0, 5.0, 8.0 and now 9.0, which is as astonishingly good as the reviews say it is. If I didn’t type so fast, I would want to use it. Sometimes I think about it even so. It’s been one of the things I’ve supported all this time, though it’s required minimal support. Usually the problem is that sound quality goes and there are ways to test and only so many things it can be. Headsets and microphones die or get frayed cables. Sound cards die, if rarely, and these days the sound is usually integrated into the motherboard and is both adequate and stable. User profiles get corrupt and new ones have to be created, much as it sucks to lose all the training you’ve done. That kind of thing. Windows Sound Recorder can give an idea how the hardware is working. It’s so big now that installation can be fun, and the hardware needs are great. Dragon 9.0 won’t run on Vista, so you have to download a major update. That’s how I came to support Vista without having actually used it myself yet.

Who knew that a tiny category list would generate so much commentary and history.

Experience Posts (links to reposts):

Intro to Experience Dump
Hardware Experience
OS Experience
Word Processing Experience
Spreadsheets and Accounting
Graphics and Presentations
Database and RDBMS
Dictation Software
Communications, Internet, PDA, Blogging
Legal Industry Software
Backup and Compression Software
Miscellaneous Software
Security, Spam, Malware…
Call Center and Tech Support Tools
Languages and Programming Tools
Server Software
Software Creation

Employment and College
Experiences and Accomplishments Scratchpad

Categories
Business Geekery Job Hunting

Repost: Database and RDBMS

Originally posted April 13, 2007, now archived here.

For further explanation why this post exists, see Intro to Experience Dump. This is the database/RDBMS (relational database management system… or is it software?) related section. It’s particularly important to see the initial commentary/caveats following the list, for this category. In no particular order, the list as best I can remember…

PC File
Paradox
Access
MSDE
Microsoft SQL Server
Sybase SQL Server
MySQL
DB2
Oracle
bTrieve
dBase
FoxPro
Lotus Approach
Microsoft Query

Some of the above items are there because I have direct and even extensive experience. Others are there because I supported the use of the product or database format programatically, mainly from Visual Basic, and had some degree of associated training. So, for instance, the presence of Oracle or DB2 on the list does not imply I could jump into a hardcore DBA job with one of those products. I have also left out some of the incidental data sources that can be used programatically or with Word mail merges, including Word, Excel, and text formats, be they CSV, tab separated, or fixed field width.

I believe my first database experience was with PC File, by shareware pioneer Jim Button’s ButtonWare. It was used circa 1990/1991 on my 286 to administer and print mailing labels from the Arisia database as it existed at the time.

When I worked at Tranti Systems, I got a taste of Paradox, which was a hot skill half the people there seemed to be trying to learn at the time in hopes of getting better jobs.

Later I worked with people who supported Microsoft Access, and have used most versions of it myself. Because of the limitations of SQL Server 6.5, I use Access with attached SQL tables for administrative ease. I’ve supported and trained clients in using it the same way to query their data in both SQL Server (Winlaw) and bTrieve (Juris Classic). I helped my partner create a custom billing “program” in Access (at the time and for the desired results it seemed easier than VB with an Access backend). I also helped him to a lesser extent with a similar but less complex Access database/app for tracking employee vacation time. The lack of something just like Access was for me the main failing of earlier versions of Star/Open Office.

My main server database experience has been with Microsoft SQL Server, from the standpoint of having installed, reinstalled, configured, administered, etc. Besides having accessed, or helped others access, data on it programatically or via other front ends.

MySQL I know manly from blogs, and having gotten into the admin tools to do queries, export data, even do mass cleanups.

MSDE is sort of where Access intersects SQL Server. I used that for distributing at a test site a beta version of a case/document management software, codenamed Prometheus, that will likely never be completed. At least not in its intended form. Personally, I could use it to manage my own documents, and have thought about releasing a shareware version, or open-sourcing the code as it stands. I also supported MSDE as used by the newer, Windows versions of Juris until the 2 GB size limit became a factor.

bTrieve used to be an inexplicably popular backend for applications. Besides supporting the use of it with VB, it was used in Juris Classic and a program called FMS (Franchisee Management System) by Property Damage Appraisers, both of which I’ve supported. I believe it was used in some aspect of Tranti Systems 2100. Or something at the company; I clearly remember it being around, if not any specific unpleasant experiences with it.

I worked with people who supported FoxPro, so got a little exposure that way and through VB/Fox interactions calls. More recently, I dealt with Fox in the form of a couple of FoxPro-based applications, one more raw than the other. One was a custom order entry system. I did a little brief support of it, helped migrate the server side from Novell to Windows 2003, and helped make sure it ran after the workstations were upgraded to XP. The other was Wintitle, a program used in real estate closings, in which the Fox aspect was mainly useful in understanding its peculiarities.

In VB support I was never what you would call a “database person.” I got by. Similar to my emphasis on good user interface design, my big thing is proper relational database design. It’s surprising how often you run into poor design, even from people who are supposed to be experts. It’s one of those little things that stick out like a sore thumb to me, bothering me all out of proportion. I’ve never been as clear as could be on the distinctions between different join statements, but if you name your tables and fields funny, if you aren’t clear on your one to many foreign keys, and your many to many linking tables, that sort of thing, I will notice.

Let’s see, what’s next? Probably e-mail, communications and internet-related software. Then it gets weird; utilities, specialty stuff, small categories. Which stands to entail less listing and more narrating. Not that the above wasn’t excess narrating…

Experience Posts (links to reposts):

Intro to Experience Dump
Hardware Experience
OS Experience
Word Processing Experience
Spreadsheets and Accounting
Graphics and Presentations
Database and RDBMS
Dictation Software
Communications, Internet, PDA, Blogging
Legal Industry Software
Backup and Compression Software
Miscellaneous Software
Security, Spam, Malware…
Call Center and Tech Support Tools
Languages and Programming Tools
Server Software
Software Creation

Employment and College
Experiences and Accomplishments Scratchpad

Categories
Business Geekery Job Hunting

Repost: Graphics & Presentations

Originally posted April 12, 2007, now archived here.

For further explanation why this post exists, see Intro to Experience Dump. This is the graphics and presentations related section. In no particular order, the list as best I can remember…

PowerPoint
Corel Draw
Jasc Paint Shop Pro
Microangelo
Adobe Illustrator
Microsoft PhotoDraw
Microsoft Photo Editor
Microsoft Paint
Visio
AutoCAD
Ulead PhotoExpress or PhotoStyler
Graphics portion of DeskMate on Color Computer 3
Jasc Animation Shop
The Print Shop

There are ones I can’t remember, like a particular 3D graphics program I played with back when computers could barely handle it, and a cheesy early CAD software. There are others besides the Ulead software that were bundled with scanners. There’s the built-in graphics features in Word, which were my other specialty besides macros when I supported the product. I created a detailed training handout on the drawing tools in Word just before I transferred to VB support.

Then in VB support, I eventually ended up doing the segment of training covering graphics. Speaking of which, there’s the icon editor that came with Visual Basic, which did what it needed to do but couldn’t compare to Microangelo. I know I’ve looked at the presentation and graphics software with other suites, like OpenOffice, but by now that almost goes without saying. Also speaking of VB, I wrote a goofy little program called KidPaint that also isn’t listed. Never thoughts I’d see the day one of my own kids could play with it.

For someone who can’t really draw, I love my graphics software. When I was in Word support, eventually it was mostly so rote that I would talk to people while doodling in Windows Paintbrush. Anything remotely interesting I saved, so I have a stack of floppies somewhere with all that.

While I wrote this up, I remembered that I’ve used Microsoft Publisher. One of the first PC softwares I ever used was a thing called IMSI Publisher. So are those to go under presentations, or under word processing? And what about Adobe Acrobat, the full version? Distinctions, distinctions…

Update 5/8/07 – Added The Print Shop. How could I get this Broderbund software that was once ubiquitous?

Experience Posts (links to reposts):

Intro to Experience Dump
Hardware Experience
OS Experience
Word Processing Experience
Spreadsheets and Accounting
Graphics and Presentations
Database and RDBMS
Dictation Software
Communications, Internet, PDA, Blogging
Legal Industry Software
Backup and Compression Software
Miscellaneous Software
Security, Spam, Malware…
Call Center and Tech Support Tools
Languages and Programming Tools
Server Software
Software Creation

Employment and College
Experiences and Accomplishments Scratchpad

Categories
Business Geekery Job Hunting

Repost: Spreadsheets and Accounting

Originally posted April 11, 2007, now archived here.

For further explanation why this post exists, see Intro to Experience Dump. This is the spreadsheets, bookkeeping, tax and accounting related section. In no particular order, the list as best I can remember…

Excel
Lotus 1-2-3
Quattro Pro
Multiplan
Quicken
MS Money
Quickbooks
Peachtree
Juris Classic and Next Generation
Juris Management Console and various utilities
Juris Time Sheet
Juris Expense Sheet
VisiCalc
DAC Easy Rapid Tax
Star Office
OpenOffice
First Choice
TimeForce Qqest time clock
Tranti time clock
XTreme Time Minder

There are probably others I’m forgetting. Some of the above were various versions. The funny thing is, I’ve done support for programmers who were working on accounting software packages, but not ever used the ones in question myself.

I’ve ended up using Excel regularly.

The Juris products are peculiar to law firms, where I have supported them, including a big migration from the “classic” DOS version using BTrieve data to a 32-bit version for MSDE or SQL Server. Which reminds me, I still need to get the classic edition running locally on the bookkeeper’s computer so she can access historical data if needed. The server it had been on crashed for good a while back.

With my accounting degree, you’d think there’d be a bigger emphasis on this stuff, but not really.

Not sure what’s next. Might be graphics and presentations. Might be communications. Might be database. The sure thing is it won’t be tonight. I never expected even to go this far today.

Update:
Added the two timeclock systems and the timekeeping software I used internally. For the Timeforce Qquest, I actually set it up, isolated the timekeeping machine on a separate network with the bookkeeper’s computer, helped figure out how to use it, and later fixed a polling problem. For Tranti I wrote documentation for the standalone timeclock, and supported the timeclock software integrated with the POS system. I wrote Time Minder for entering time and categorizing activity based mainly on the wishes of our large client, but such that it could also be used for any client and internal timekeeping. In an earlier, completely different version I had a stop/pause/resume/start measuring function I thought was cool but wasn’t as needed or useful as expected.

Experience Posts (links to reposts):

Intro to Experience Dump
Hardware Experience
OS Experience
Word Processing Experience
Spreadsheets and Accounting
Graphics and Presentations
Database and RDBMS
Dictation Software
Communications, Internet, PDA, Blogging
Legal Industry Software
Backup and Compression Software
Miscellaneous Software
Security, Spam, Malware…
Call Center and Tech Support Tools
Languages and Programming Tools
Server Software
Software Creation

Employment and College
Experiences and Accomplishments Scratchpad

Categories
Business Geekery Job Hunting

Repost: Word Processing Experience Dump

Originally posted April 11, 2007, now archived here.

For further explanation why this post exists, see Intro to Experience Dump. This is the word processing and combined packages that revolve around word processing section. In no particular order, the list as best I can remember…

Every version of MS Word, including providing Microsoft support of 1.0, 1.1, 2.0 and 6.0
WordStar 5.0 and 2000
WordPerfect 5.0
Lotus Ami Pro/Word Pro (about three versions)
PFS First Choice
Spinnaker 8-in-1
Star Office
OpenOffice
IBM word processing software for OS/2 (bundled, forget the name)
Ashton-Tate MultiMate
Volkswriter, for Color Computer 2
EZ Word
AbiWord
MS Works
DeskMate, for Color Computer 3, if I have the name right.
602Text

There are probably ones I’ve forgotten. This doesn’t count some bundled or simple text editors and word processors, like DOS edit, Notepad, UED, Write, or WordPad. I may have played with a more recent version of WordPerfect. I probably played with whatever was bundled with at least Red Hat Linux and KDE. These days it’s gotten to where a word processor is pretty much a word processor, and it’s lucky Microsoft can charge any amount for Word.

Volkswriter is the one I used on my Color Computer 2 and loved so much. When it died and I bought a Color Computer 3, I was irked to learn my good word processor wouldn’t run on the newer machine. I still have stuff I wrote in Volkswriter, on ancient 5 1/4″ floppies, among my old computer-related detritus and treasures.

Once I got a PC, I used First Choice for a while, then I bought WordStar 5.0 through DAK and fell in love. My roommate installed WordPerfect 5.0 and I toyed with it, but it was too hard to use. I seem to recall that I stumbled upon pressing F3 twice to get information on how to do anything. I probably developed a lot of my unexpected typing speed using WordStar, and could probably get back into the old shortcut keys (which mapped logically to menus!) in minutes. Not that I would want to go back to something little more than ASCII in nature when modern word processors exist.

I played with Word 2.0, but at the same time I got Ami Pro, I think it was 3.0, and it seemed much better. Around the time I was using Ami Pro at home, I was using MultiMate at work, on an early IBM PC with something like a 5 MB hard drive. Yeesh.

It was ironic that I landed the support job that turned out to be for Microsoft Word – they didn’t tell us until after we were hired – with a resume created in Ami Pro. Once I got a load of Word 6.0, the latest release and reason for the support hiring, Ami Pro no longer seemed superior. Apart from being lighter on resources. I did support of Word 6.0, 2.0 and 1.x, specializing in Word macros (before VBA), for over a year before moving into VB support. This experience worked out great for my eventual stint supporting law firms, even if they didn’t always take full advantage.

That about covers it. Next up I guess will be spreadsheets plus tax, accounting and bookkeeping related software. Talk about bringing back memories; I had forgotten until doing all this thinking about what I have used that I did indeed lay hands on VisiCalc at one time.

Experience Posts (links to reposts):

Intro to Experience Dump
Hardware Experience
OS Experience
Word Processing Experience
Spreadsheets and Accounting
Graphics and Presentations
Database and RDBMS
Dictation Software
Communications, Internet, PDA, Blogging
Legal Industry Software
Backup and Compression Software
Miscellaneous Software
Security, Spam, Malware…
Call Center and Tech Support Tools
Languages and Programming Tools
Server Software
Software Creation

Employment and College
Experiences and Accomplishments Scratchpad

Categories
Business Geekery Job Hunting

Repost: OS Experience Dump

Originally posted April 11, 2007, now archived here.

For further explanation why this post exists, see Intro to Experience Dump. This is the operating systems (OS) and environments section, which will be shorter and include less extended commentary that the hardware section. In no particular order, the list as best I can remember…

Every version of Windows from 3.0 on, and NT from 3.51 on.
At least four Linux versions: Red Hat, Mandrake, Corel and Ubuntu.
OS/2 Warp 3.0
Macintosh circa early nineties
Most versions of MS-DOS, particularly 3.3, 5.0 and 6.x
OS-9 for TRS-80
AS/400
Tranti Systems EZ-DOS
An older version of Novell

This is includes things I have supported as well as touched, so it is possible for me to have supported the use of, consequences or. or interactions with an OS without having used it personally.

Some things I experienced more intensively than others. When I started working at Corporate Software, I was nicknamed “The DOS Guy” by my colleagues. Even then, before Windows 95 released, when we were using Windows 3.11, there were people hired to do support who were utterly lost in anything but the Windows GUI. And not always much better off there.

By comparison, I used to load ansi.sys and create colorful batch file menus using escape codes. The first time I ever saw Windows, I thought it was a bit goofy and wasn’t sure I saw the point. What got me using it was the apps it would run.

I used to hang out on a BBS run by an OS/2 fanatic. I even read the Team OS/2 newsgroup (or it may have been a Fidonet thing) regularly with great interest, despite having never used it. When OS/2 Warp 3.0 hit, I bought it and used it for a while. It was pretty cool. IBM missed a slight window of opportunity to shake up the industry. I found it started crashing after a while, which I blamed more on the hardware I installed it onto than on OS/2. I put it on a 386. When I got Windows 95, it went on a 486. Surprise! It seemed more stable. It also helped that I got Microsoft apps support training on Windows 95 just before it was released. I never looked back, but always felt bad that OS/2 didn’t fare better. It could have, to the degree it was a matter of business decisions.

The OS category properly gets into server elements, but I should probably cover that separately. Take something like Windows 2003 Server SBE; you’re setting up a server and dealing with its OS, but also Exchange at the same time. Then again, this reminded me I forgot the Novell server I dealt with, and while that’s networking, it’s also the OS running the computer, so I added it.

Okay, next it’ll be word processors and combined packages that featured a word processor.

Experience Posts (links to reposts):

Intro to Experience Dump
Hardware Experience
OS Experience
Word Processing Experience
Spreadsheets and Accounting
Graphics and Presentations
Database and RDBMS
Dictation Software
Communications, Internet, PDA, Blogging
Legal Industry Software
Backup and Compression Software
Miscellaneous Software
Security, Spam, Malware…
Call Center and Tech Support Tools
Languages and Programming Tools
Server Software
Software Creation

Employment and College
Experiences and Accomplishments Scratchpad

Categories
Business Geekery Job Hunting

Repost: Hardware Experience Dump

Originally posted April 11, 2007, now archived here.

For further explanation why this post exists, see Intro to Experience Dump. Despite my emphasis there on sofware, this is about hardware; mainly computers, but also other items.

System 36 Terminals
Data General Cyber System Terminals
AS/400
Early TRS-80, Color Computer 2, Color Computer 3
Commodore 64
Tandy Pocket Computer
Original IBM PC through approximately current PCs and servers, including building, rebuilding and upgrading many 286 through Pentium level machines.
Various laptop/notebook computers.
Older Apple Macintosh
Terminal Server thin clients
Tranti 2100 PC-based restaurant POS System
To a much lesser extent, non-PC Tranti 29 and 105 systems
Many different printers, local or networked, various brands, types including daisywheel, dot matrix, thermal, ink jet, and laser.
Various Blackberry, cell phone and PDA devices.
Various scanners, copiers, faxes, and multifunction devices.
HP Digital Sender 9200
Various hubs, routers and switches.
Digital cameras and webcams.
Many monitors, monochrome through LCD.
TimeForce Qqest time clock
Tranti time clock

Probably things I’ve forgotten, and certainly things that seem silly to list. Internal peripherals, for instance. I’ve played with an external modem or two, but why would I mention dozens of of internal ones? The format of the above also doesn’t leave room to mention having dealt with RAID arrays, as well as plain old IDE drives implicit when mentioning PCs, and newfangled SATA drives.

Some commentary and explanation on the list, though…

Cyber System was in use at Massachusetts state colleges at the time, along with newfangled DEC VAX machines at Bridgewater that I didn’t get to use. It was what I used for BASIC, which was too boring to bear because I’d already self-taught too much, for Pascal, and for COBOL.

System 36 was at The Renovator’s Supply, running mainly inventory software written in RPG (Report Program Generator), which was a hot coding skill to have at the time. I used to teach other people how to use it, and how to make it dance and sing. I got my first taste of e-mail on that system. That job was where I got my first, unofficial, experience doing PC support, and using PCs in a work environment when I helped in HR and compiled material safety data sheets. I seem to recall they actually upgraded to a 400 before I left. I had more direct experience with a 400 recently, figuring out last year how to access my client’s old system and searching for documents they unexpectedly needed. That was an instance of my almost intuitive communing with computers coming in handy.

The Pocket Computer was the first computer I owned (as opposed to the first computer I played with – unless I am forgetting something earlier – and learned my first bits of BASIC on, a friend’s TRS-80 in 1977). I got it for Christmas 1983. It had a big 1k of bubble memory and could be programmed in a shortcut variant of BASIC. For instance, the letter “i” used in place of “input.” I programmed it to take inputs and return present and future value interest factors. I still have it, and as far as I know it would work fine if i finally got around to replacing the batteries. I also still have my scientific calculator that has “20. 7” saved in its memory. I had more fun playing with that corrupt non-number. For instance, 20. 7 * 2 isn’t the same as 20. 7 + 20. 7, and 20. 7 – 20. 7 is not 0. However, I never trusted that calculator to be accurate again, once it generated the bogus number.

I bought my first PC in 1988, right after I finally finished college. It was an overpriced Packard-Bell 286, very solid, with 1 MB RAM, a 60 MB MFM hard drive (as opposed to IDE) in the days when 20 MB was still normal, and an EGA monitor. You booted it and got a message at the top center of the screen “Welcome to the Packard-Bell Computing World,” with a C:\> prompt below. DOS 3.3… those were the days.

In 1992, my “uncle” Henry taught me how to build computers and we upgraded the 283 to a 386. From there I never looked back. He picked up some software and batch file pointers from me, and we had a lot of fun messing around with stuff and going to computer shows. When I discovered “online” in 1993, I never could get him hooked on it. I wonder what he’d make of the internet as we now know it.

My Mac experience is extremely limited. A friend I worked with in the early days of Arisia on marketing materials, program books and T-shirts had a Mac and laser printer at home. I wrote. She opined and co-wrote. I proofed and edited. She did graphics and layout. I had such a good feel for it that she considered my opinion on layout and graphics to be valid, which she didn’t consider the case with pretty much anyone else. We had a lot of fun. I didn’t lay hands on the computer too much; mainly watched her use Aldus and Adobe products and “admired” the tiny black and white screen. She worked at Cigna, where they had far better Macs. We went there one weekend and I played with one Mac while she worked at another. I promptly made it blow up. Heh.

Tranti Systems was my first support job. The 2100 was a new PC-based POS system for fast food restaurants. They were basically 286 PCs, 386 once parts for 286 became too expensive or hard to get, with a proprietary add-in card. They ran a modified version of MS-DOS, a file manager/utility program associated with that, called EZ-DOS, the POS software, and Lantastic. I learned my first stuff about networking there, and at one time was something of an expert with Lantastic. I did a lot of testing and breaking things, anticipating what would later be real world problems.

Mostly it was callback phone support and a ton of overtime carrying a pager, but I also did other things. That included a trip to North Carolina to do the training and help install systems in two Taco Bells. Oddly, I enjoyed the training, at the same time I was terrified speaking in front of groups of people. I also enjoyed customizing register keys, which involved a custom macro language built in for the purpose.

The company also made an electronic timeclock system, a natural extension of POS timeclock functionality. I created documentation for that product. Which involved using MultiMate word processing software on an ancient IBM PC, which was the main kind of computer they had there. That was where I got most of my retro experience, with the oldest PC machines and versions of DOS prior to the 3.3 that might otherwise have remained my earliest. It was pretty bad. They also had I believe it was a Nixdorf mainframe, for which a few of the old PCs doubled as terminals.

I think that’s enough embellishment of the “hardware” part of this exercise. I do want to finish it someday, after all. The kind of thing all the above leaves out is the adventures in getting early soundcards and CD-ROM drives to work at all, meaning a lot of cursing and/or praying. I figure it goes without saying that building and working on so many computers implies a lot of that.

Next up, operating systems…

Update:
Added the two timeclocks.

Experience Posts (links to reposts):

Intro to Experience Dump
Hardware Experience
OS Experience
Word Processing Experience
Spreadsheets and Accounting
Graphics and Presentations
Database and RDBMS
Dictation Software
Communications, Internet, PDA, Blogging
Legal Industry Software
Backup and Compression Software
Miscellaneous Software
Security, Spam, Malware…
Call Center and Tech Support Tools
Languages and Programming Tools
Server Software
Software Creation

Employment and College
Experiences and Accomplishments Scratchpad

Categories
Business Geekery Job Hunting

Repost: Intro to Experience Dump

Originally posted April 10, 2007, now archived here.

Once upon a time, after I got my first PC, I used to list all the software I had used. The idea was to show off that I was computer semi-literate, had laid hands upon Lotus 1-2-3, and of course should be hired for accounting-related work for which knowing Lotus 1-2-3 was increasingly mandatory.

I never did get that accounting job. However, I did almost get a combined cost accounting and “design a computerized cost accounting and quality control system” job, which didn’t exist but was inspired by my resume, that would have been slightly over my head at the time, but a fun challenge. More fun than commuting to Lowell from the South Shore would have been. I’d gotten a 96 average in a cost accounting class that had easily a 50% dropout and failure rate; thus that element of the almost job.

Ultimately, though, the practice of listing that stuff, and emphasizing computer mad skillz, got me technical support work. Even then the list was starting to get too long, and it’s long since to the point where you’d shorthand some and leave the rest unstated.

Heck, I haven’t even created a resume since 1997. I’ve done a few fits and starts of “if I needed one, what would it say,” but that was the last full-fledged one, and it was for internal consumption, so might not fully count. In which case, my last general resume was written in 1994. Using Ami Pro. I guess it really is worth taking stock. As I mentioned the other day, I am in a unique window in which I could leave being self-employed, or keep it entirely on the side, and go for a “real job.” Or a mix of part-time stuff that might include “real job” elements. I recently saw a paid tech blogger at a commercial site not know something so elementary that it made me wonder why I’m not doing something like that.

At any rate, this doesn’t pretend to be a resume. It doesn’t pretend to be short. It’s an info dump for my benefit, and if you’re curious enough to go through the list, or want to compare notes or add comments on your experiences or computer/software/work history, then cool.

Each of these posts will at least link back to this one by way of explanation. They will be subject to update if I think of things I might have forgotten. I might have them link each other. They’ll be categorized, but my categories might seem a bit vague or odd in places. Oh well. Since I’m dividing it all up, perhaps I’ll add more commentary than the original list format might have implied. For what it’s worth, the things I have listed so far run to four pages in Word. At 14 points, since I like a good view of what I am typing, so it’s not really as long as it sounds.

Of course, if I want this to be a complete exercise, I’ll need to talk about more than the technology list dump. It’s also about what I have done, what I enjoy doing, and what I prefer to avoid. I’ll undoubtedly get to that.

So, here goes…

Experience Posts (links to reposts):

Intro to Experience Dump
Hardware Experience
OS Experience
Word Processing Experience
Spreadsheets and Accounting
Graphics and Presentations
Database and RDBMS
Dictation Software
Communications, Internet, PDA, Blogging
Legal Industry Software
Backup and Compression Software
Miscellaneous Software
Security, Spam, Malware…
Call Center and Tech Support Tools
Languages and Programming Tools
Server Software
Software Creation

Employment and College
Experiences and Accomplishments Scratchpad

Categories
blogging Geekery Job Hunting

Reposts Galore

I am about to repost a bunch of posts I did about my various experience, mainly listing different software, etc. I had used over time, with sometimes excessive elaboration about the circumstances. This is potentially useful to me for reference, and since migrating the blog to WordPress and archiving most of it still in Expression Engine broke the archives somewhat, I thought I would bring them to the fore.

I’ll make this post sticky for a while, so it’s clearer what’s going on, as the posts will ultimately appear in the same order published, with the oldest first. Here goes…

Categories
Food & Cooking Pictures

A-Peeling

Sadie is fascinated with cooking, so I’ve started showing her things, and figured I’d try having her peel carrots for what ended up being an ill-fated beef stew. Valerie’s participation was the obligatory me too. They did better than I’d expected. Biggest problem was Sadie’s incomprehansion of “finished” when enough had been peeled.

Categories
Pictures

Sadie Meets Basketball

Categories
Pictures

My Mother and Older Brother

Categories
Pictures

Alicia

My youngest niece, who is two years older than Sadie.