By the beginning of September of 2023 I had become quite frustrated about the time that I had been wasting because my Lenovo desktop computer, on which I had keyed in the great bulk of the entries in the 1948 Project (introduced here), was intolerably slow. The biggest problem was that the system would quite often lock up for as long as ten or fifteen minutes. During these periods the disk light was on continuously. I had tried to determine the cause by examining the output available in Windows’ Task Manager, but I had no luck. I had also asked the Greek Squad to look into it. The agent signed on to my system, deleted a lot of temporary files. That seemed to help for a day or two. However, it reverted to its previous behavior shortly thereafter.
Another problem was its connection with the Cox modem/router. The connection would be lost for no apparent reason, and it was often difficult to recover. A few years earlier I attached a modem that I had previously purchased to a USB port. That did not seem to help much
So, in desperation I decided to purchase a new box. I did some research on the Internet. The new systems seemed to have much faster processors than my Lenovo desktop. The hard drives were in most cases a little smaller, but that did not concern me much. The amount used on the Lenovo was far less than the capacity of any of the available machines.
I had had pretty good experiences during my last two computer difficulties (outlined here) with the Geek Squad people at the Best Buy store in Manchester, CT, which was about a thirty-minute drive from my house. I therefore decided to buy one there.
I cashed in the points on my Bank of America Mastercard for a Best Buy gift card in excess of $300. The units at Best Buy started at about $600 unless I was willing to settle for an obsolete model that ran Windows 10 or an “open box.” I decided to put a new system on order shortly after I received the gift card in the mail.
Unless I did not mind making several trips to the store, I figured that the easiest way was to order it online and pick it up at the store. Before I did so I had an electronic chat with one of Best Buys sales agents. I told him which model (an Asus) I was interested in, but I also expressed my concern about the difficulty of migrating the programs that I used. I specifically emphasized that the one that I was most worried about was Outlook, Microsoft’s email product. The agent assured me that the Geek Squad people at the store could help me with that. That convinced me to put the system on order. It was scheduled to be at the store on Friday, September 21. I actually received an email that it had arrived a day early. I had a big project to work on over the next few days, and so I planned on picking it up on Monday.
I had a long and strange electronic chat with agents from Best Buy on Friday. When I explained my concern about Outlook I was transferred to a different agent who allegedly specialized in this. A little later I was transferred again. This agent assured me that the Geek Squad would do the entire migration for me and made an appointment for me for 3:20 in the afternoon on Monday.
I left for Best Buy at 2:30 on Monday and arrived at 3. I had no trouble obtaining the new computer. I had brought with me a bag that contained the Lenovo that I had been using as well as a very old external hard drive for which I had lost the power cord. I intended to ask the Geek Squad people after they had migrated the programs and data if there was any way extract the files that were on the external drive onto something usable.
The Geek Squad guy was very friendly, but he said that they only did data, not programs. This was very upsetting to me. The only reason that I had purchased the machine from Best Buy was for the help that I expected to receive. Migrating the data was no challenge if you had a large external hard drive, and I did. I was so upset about the lies (or maybe misunderstandings) that I left Best Buy without remembering to ask about the hard drive. As I drove out of the parking lot I was so concerned about what should be my next step in making the system in my trunk operational that I almost ran a red light and caused a serious accident. The rest of the drive home was uneventful.
Plan Z: In my research I had come across a company name Zinstall (website here) that markets a downloadable program called WinWin that the website claimed was able to transfer all of one’s programs and files from any Windows computer to a new Windows 11 computer. It cost $129 plus tax.
On the evening of Wednesday September 272 I started an electronic chat with someone named Paul from Zinstall. He assured me that they installed software, called WinWin, that could transfer all the programs, but it was possible that Microsoft would demand proof of ownership in the form of a serial number or program key. A little more research convinced me that this was quite unlikely. Besides, I could not see an alternative. So, I purchased the software. I received the following email:
Thank you for choosing Zinstall.
A. DOWNLOAD LINKS 1. CLICK THE FOLLOWING LINK to download the SOFTWARE: (link) 2. You should download and run the software on BOTH computers: OLD and NEW. 3. IMPORTANT: before taking any further steps, you should carefully read the USER GUIDE. CLICK THE FOLLOWING LINK to download the user guide: (link)
B. ACTIVATION INFORMATION: Below is your Zinstall license activation key serial number. You will need to supply this information when prompted by the software. Serial number: WNPV-XXRR-BJDK-VJK6-USOP-I2XP-LGXO-6UEV-74 Registered email: Mike@Wavada.org
C. SUPPORT AND SERVICE We are glad to assist you with your transfer. 1. SUPPORT QUESTIONS & TROUBLESHOOTING: For any support questions or assistance, CLICK THE FOLLOWING LINK: (link) where you will find answers and solutions for your questions, as well as options to contact the Support Team. 2. If you require TECHNICAL ASSISTANCE, please submit the “Support Case Form” and run the Diagnostic Tool on both computers (old and new). Both the Form and the Diagnostic tool are available at the link above.
D. FULL SERVICE – REMOTE ASSISTANCE: IF you prefer the convenience of having an expert tech perform the whole transfer for you, you have the option of a Full Remote Service add-on. It is available here at a discounted “bundle” price: (link).
E. BEST PRACTICES: HOW TO PERFORM A MIGRATION? Before starting the migration process: 1. Make sure you have a backup of your computers. 2. Save all open files and close all running applications. 3. Completely uninstall all Internet Security Suites, Firewalls, and Antivirus on both computers – OLD and NEW. 4. You don’t need to purchase any special cables or external hardware to do the transfer. If your computers are connected to a home network, you don’t need to do anything – Zinstall will use the network for the transfer. Otherwise, you can just use a regular network (aka Ethernet) cable – you probably already have one – to connect the computers directly. Here is what it looks like: (link). 5. While wireless is usable as well, if you have an option to use Ethernet – use it. Wireless is inherently slower, and may be interrupted by network disconnects. 6. The migration process requires “Administrator” user privileges.
IMPORTANT: The transfer may continue for a very long time – DO NOT INTERRUPT the process, even if it seems that nothing is happening for a while. REMEMBER: Once started, the migration process is completed unattended – you are not required to stay near the computers, and may leave it for the night to complete.
One thing that had not previously been clear was that I needed to connect the two computers via an Ethernet cable if they were not already on a network. I thought that it would be sufficient that both used wi-fi. I had been planning on sending the data through the modem/router from Cox Cable.
I asked Sue if she knew if we had an Ethernet cable. She said that she had at one time put all of the miscellaneous cables in a big plastic tub. I naturally asked where it was. She said that she didn’t remember. I was not surprised. I made a mental note to drive to Target on Thursday morning to purchase one. Target’s website offered a seven-foot cable for $10, and they seemed to be in stock..
In one of my dreams that night, however, I had a revelation that there might be one in the north end of our basement near the AS/400 that I brought home in the summer of 2014 after we closed TSI’s office in East Windsor.
When I awakened in the morning I hastened downstairs and discovered that there were indeed two Ethernet cables in a snake’s nest of cables near the computer. I wrested one away and without too much difficulty I was able to connect the two black boxes on my desk. When the yellow lights appeared in the sockets for both, I rejoiced. I had saved $10!
The migration: The instructions sited above were thorough and instructive. As someone who wrote such instructions for users of his code for thirty-five years, I have one quibble. Users expect the written instructions to be in the order in which they are to be executed. In this document some of the most important pieces of information are near the end. I admit that I never read sections B, D, and E until I started writing this account on Friday.
I downloaded the WinWin software to my old system, Lenovo. I found the executable file in the Download folder and ran it. According to the instructions I should have run it as administrator, but I didn’t. The program churned for a few minutes and then asked me whether this was the old computer or the new one. After I selected “old” it told me to do the same thing on my new computer Asus.
I had planned to use the same display on both computers.3 So, at this point I needed to detach it from Lenovo and insert it into Asus. This turned out to be a much bigger pain than I thought that it would be. In the first place the lighting in that area of the office was not good.4 The head of the cable was held in place by two screws. No screw driver was needed, but it took longer than I remembered to screw and unscrew them with my fingers.
After I attached the display I turned on Asus for the first time. It came up rather quickly. Among other things it asked for a PIN. I used the same one that Sue and I use for the garage door opener. It invited me to take a tour of Windows 11, but I postponed that adventure until some undisclosed point in the future.
Instead I selected the Edge icon on the desktop, downloaded the WinWin executable again, found it in the Download folder, and ran it. The same window came up, and, when asked, I said that this was the new computer. The program then searched for the old computer. This was the moment of truth, or I should probably call it the first moment of truth.
It was not to be. The screen displayed a sad message (#324) that indicated that it could not find the old computer. The likely cause, it said, was either that the two boxes were not connected or that security software on one of the boxes was preventing the connection.
I checked the back of both computers. The Ethernet cables seemed to be securely attached. I then uncabled the display from Asus and reattached it to Lenovo. By coincidence almost as soon as I could see the display again a window appeared for the Webroot program that the Geek Squad had installed. It had options to end three types of security. I did so. Consequences be damned.
I then sent to the support team at Zinstall an email explaining the situation and identifying the error message number. I received two identical “high importance”messages one minute apart: “Hello Michael Wavada, This is an acknowledgment we have received your email. We will contact you soon. Best regards, Zinstall support team”
I would have preferred something more specific than the word “soon”, even if it was “within the next 24 hours”. I felt that Zinstall recognized the urgency of the problem, and I could expect an email with specific instructions within the next five minutes, or five hours, or maybe five days. I stayed at Lenovo’s keyboard4 and won game after game of two-suited Spider Solitaire while intermittently checking the Inbox in Outlook. At about noon I fixed myself a ham sandwich and ate it in front of my desk while I kept my eye on the Inbox.
I almost always took a nap after lunch. Mine on that day was a rather short one, and I rushed back to check the Inbox as soon as I was awake. No dice.
At 1:47PM I sent a short missive to Zinstall support: “How long is soon? It has now been over four hours.” Nearly an hour later I was about to send another email when this showed up in the Inbox. It was signed by Sam R.
Thank you for contacting us.
You have Webroot still active on the old computer.
Please disable Webroot firewall on the old computer (or simply remove Webroot from the old computer), and run Zinstall again on both.
Please let us know how we can assist further!
I replied as soon as I could: “I believe that I disabled it before running Zinstall. I tried to delete the folder named Webroot, and it said that I need permission from SYSTEM to do so. I do not know how to do that. Actually I seem to have two copies of Webroot. One in Program Files, and one in Program Files x(86). The Geek Squad installed them.”
Sam R. must have been horrified about what I had attempted. He wrote back rather quickly.:
You should not delete folders directly; instead, you can typically right click on the Webroot icon in system tray (bottom right corner, near the clock) and select “Shut down” or “Exit”.
Or, to uninstall it, go to the list of installed programs and select Webroot there.
Alternatively, if you cannot get rid of Webroot, another alternative is to use Zinstall with a USB external drive instead of network.
Do you happen to have a USB hard drive available?
I did have an external drive with a great deal of storage, and it was within two feet of my right hand. Nowhere in the emails or the online instructions booklet was there any mention of this option. Maybe that could be plan Z2 if we could not get past the security issue. In the process of disabling Webroot in the way that he described I noticed that the system clock was off by more than two hours. While I was in the same system tray I also found a Malware icon. There was no option to disable it. I select “Quit” instead. Both icons disappeared from the tray.
Uncertain whether Sam R. would still be working, at 5:04PM I sent the following message to describe what I had done since receiving his (her? their?) last email:
I tried this twice. On the first try I received the same message as before even though Webroot was not listed in the Apps. The second time I removed Webroot again (the system had rebooted on its own) and Malware Bytes from the Apps in the lower right corner. This time the program on the new box found the old box, but it warned that I was using a wireless connection that might be slow or fail. The lights for the Ethernet ports are on on both machines. Is there a way to verify the connection? I do not have a network (other than the Cox Cable modem/router). I just ran a cable between the machines.
Later I became convinced that Lenovo had not, in fact, rebooted on its own. I was pretty sure that the AC cable had been jostled loose while I was moving the display cable back and forth between the two boxes.
I decided to try it again, and I was cautiously optimistic. However, the email sent at 6PM told a different story: “It is now showing message #11. This is SO FRUSTRATING!” Message #11 said that my account had reached the limit on the number of tries. I did not receive an answer on Thursday.
I was poor company all evening. I was close to giving up on Zinstall, but I had no alternative at this point. I began to consider contacting American Express to tell them not to pay for the service. I went to bed at about 9PM, which was quite early for me.
On Friday morning I was pleasantly surprised to receive an email from Sam R. The time stamp was 4:14AM.
Thank you for the update, it’s great that the connection issue is solved now that Webroot is removed!
Regarding wireless, you do not have a huge amount of data on the old computer, so you can transfer via wireless as well.
As long as the wireless network is not abnormally slow, it will complete just as well.
Note also that you can use the old computer while the transfer is in progress, if needed – just press the Windows key on your keyboard to get to your apps / desktop.
Please let us know how we can assist further!
I asked him about error #11. He said that that had been cleared. I did not respond to his comment about being able to use the old computer. Once the process started, I intended to monitor it on the new computer. I had no intention of touching any of the cables once the migration was under way. He probably did not remember that I was switching the display from one machine to the other.
Before I ran the WinWin program on Lenovo I made certain that neither security program was in the system tray. When I moved the display’s cable, I was very careful not to jostle the AC cable on Lenovo. I then checked to see that both Ethernet lights were on.
At about 8:20 (I know because I always awaken Sue at 8:30) I initiated the WinWin program on Asus. This time it found Lenovo, and it did not present the warning message about using a wireless connection. It must have been using the Ethernet cable.
The process took about three hours. I used part of the time to go through the papers that had been accumulating on my desk for a few months. That was a worthwhile activity. I found a year-old credit from Costco for $1.48 and the paperwork for applying for a discount on the real estate tax levied by Enfield. I also found my hanging file for income tax for 2019. I had no idea why it was out of the filing cabinet.
I was very impressed with the window that displayed the various steps in which the program was engaged. It also showed two percentage bar graphs that indicated the portion of the step being executed and the total process that had been completed. At the bottom were statistics about things like the rate of data transfer and the size of the files that had been copied.
When it was finally finished, it congratulated me on a successful migration. I have seen many such messages before, but this was the first time that I really thought that we had accomplished something important together—I mean the program, the computers, the cabling, Sam R., and I.
I restarted the system as directed. It came back up rather quickly, and I entered the PIN. The desktop looked almost the same as it had before. The program tray was missing two icons. One was definitely for Spider Solitaire. I purchased a new copy for Asus, for $0, and it popped back up in the program tray. The other one might have been for a program that I had downloaded to convert YouTube videos to MP3 or MP4 files.
Outlook. etc.: It was time for the second moment of truth. With some trepidation I clicked on the blue Outlook icon. Microsoft somehow recognized me and asked me to key in the password associated with the account associated with my email address. I found it on my password list. Microsoft approved it and immediately installed updates to the software. I then needed to key in the passwords for my two email accounts. I got the Cox one on the first trick, but I made a mistake on the one for Wavada.org. Once I got it right all the emails that I had received from both accounts showed up after the next Send/Receive.
Everything seemed to be there, and I liked the new look and feel of the software.
Problems: After one day’s use I had encountered only three problems. As I mentioned, I had left one program open on Lenovo. It took me less than five minutes to bring the Asus version up to date. At one point while I was surfing in Firefox Windows11 interrupted and reported that it needed to restart. I had no choice but to let it. It came right back up, but I lost about an hour’s worth of work in WordPress. I don’t know why it had not been saved, but I will need to be more careful about updating these long blog entries more regularly.
The strangest problem was encountered using the editor of posts in WordPress in Firefox. Below is the screen for editing a blog entry in Chrome. This is also how it looked in Firefox on Windows 10:
Contrast this with the same screen on Firefox.
I don’t know if this was a problem in Windows 11 or WordPress. I planned to install a new version of WordPress soon. I later learned that it was neither. The slide bars in Windows 11 were much smaller. Sometimes they were nearly invisible.
Performance: The new box is lightning fast, and so far it has never locked up.
1. The technical experts at law enforcement agencies on television often extract files from hard drives that survived plane crashes, arson, floods, and the like. Surely the agents of the internationally renowned Geek Squad had similar tools at their disposal.
2. I ordinarily played bridge on Wednesday evenings, but the game on 9/27 was canceled because only three pairs planned to intend.
3. Sue thought I might be able to use a gigantic display that she had squirreled away in the three-season porch. I was thoroughly skeptical even before I learned that it had no cable.
4. I did NOT need my cataracts removed. That will probably come some day, but not before my subsequent appointment with the retina specialist on October 18.
This entry, like the process that it describes, is absurdly long. In fact, it is much longer than it looks because it has links to a large number of documents that have more details. I don’t expect anyone to read this entry. I did it out of a combination of determination to leave nothing out and a sense of catharsis.
I really loved my job as webmaster for District 25 and all of the other functions that I had added (as described here). The only aspect of it that I found tiresome was the assembling of photos for the Winners Boards. I had decided unilaterally that I would no longer do that in 2020, but I was still enthusiastic about everything else that I did.
The pandemic struck New England in March of 2020. The game that I loved that involved card tables, chairs, playing cards, bidding boxes, human beings, and conversation vanished almost overnight. Some people enjoyed, or at least tolerated, playing on the Internet, but I did not like it at all. It did not seem like bridge to me.
At first I enjoyed my new life of leisure. As I described here, I started walking a lot, occasionally traversing as much as ten miles per day. I also read books much more frequently than I had previously, and I invented a method for the people who had played together in Simsbury to describe what they were doing in the new world of isolation. I discovered that a very large number of operas were available free on YouTube. I downloaded a free program, MP3Studio, to make mp3 files that I could download to my mp3 player. So, I could carry forty or fifty operas in my pocket.
In June of 2020 my schedule changed dramatically. I undertook the gargantuan 1948 Project that is described here. From that point on I sat in front of the computer for several hours per day writing and researching, and the more time that I spent on the project the larger that it grew.
In the summer of 2021 my friend and boss in District 25, Bob Bertoni, died after a long and debilitating illness. At that point almost all of the people with whom I had enjoyed working for so many years were no longer involved in the district’s leadership. Moreover, the ACBL had taken strong measures to promote online play as an alternative to real bridge. It seemed almost certain to me that the game that I knew was doomed.
The Hartford Bridge Club tentatively reopened in the summer of 2021, and Sally Kirtley and I figured out a way to schedule games of the Simsbury Bridge Club. However, no tournaments were held in New England except the poorly attended sectional in December sponsored by the Eastern Mass Bridge Association (EMBA). At the time I was a member of both the district’s Executive Committee and the Tournament Scheduling Committee. Both held occasional Zoom meetings. I wrote this about the decision-making:
I have been on the scheduling committee for a few years, but two crucial online meetings were held in the winter on Wednesday evening, the one time that I am committed to play at a very small club. Evidently a lot of decisions about the three tournaments in 2022 were made at those meetings or at the one in May, during which I was in Europe.
In the last quarter of 2021 I notified the Executive Committee that I intended to resign my positions tied to the webmaster job at the end of 2022. I modeled my decision on this with how Helen Pawlowski handled the termination of her long tenure as the district’s tournament manager. She had given a year’s notice that she was leaving. A committee was promptly formed, people applied for the job, Sally Kirtley was chosen, and Helen showed her the ropes at several tournaments.
After I resigned not much happened for several months. When I had started in 2013, absolutely nothing was documented in writing. By contrast, I had already produced on NEBridge.org about forty web pages that documented everything that I did in every area. Thereafter, I spent an enormous amount of time making sure that each of these pages was up to date. They can all be reached from here.
The oldest email that I could find about the subject of the transition was dated November 30, 2021. In It Curtis Barton, the president, asked me, “Do you have a candidate to replace you?”
The one thing that I did not want to do was to become an active participant in the search for my replacement(s). I thought that it was incumbent upon the people who would be running the district going forward to determine which of those functions was still important and to find people who were willing and able to perform them. I did not want to prejudice this effort with my own ideas.
I felt that I had done everything that I could to smooth the process. When I was chosen to be the webmaster, Bob Bertoni had assumed the responsibility of finding someone for the job, mostly because he was the only person who knew how the site worked, and there was no documentation whatsoever. In the intervening years had thoroughly documented how my various functions were performed.
So, on December 31 I sent the following reply with four attachments.
As promised, I have produced and attached documents that outline the duties of four functions that I currently perform: • Webmaster • Database Manager • Email Manager (MailChimp) • Bulletin Editor (printed, online, and Day 1).
Someone needs to decide on who, if anyone, should perform these functions in 2023 and following. The Database Manager and Email Manager are not official positions.
I am not sure if the Communications Committee still officially exists, but I formerly set the agenda for and presided over its meetings.
I also have been composing a high percentage of the emails used to promote tournaments. Whoever assumes that function in 2023 and following will need to work with the Database Manager on the selection criteria to be used and the Email Manager on the format to be used for text and images.
At some point Gary Peterson, who was a Tournament Director for the ACBL, expressed an interest in becoming the webmaster. He negotiated with Curtis about how he would be compensated for his efforts. I was not privy to those exchanges. My assumption was that he would be responsible only for maintaining the website. I suspect that Curtis expected him to do much more than that. It is also possible that Curtis only glanced at my write-up.
In April of 2022 I sent all the members of the Executive Committee an email that detailed open issues in areas that I was involved. I attached to this email a spreadsheet that served as the index to the documentation pages.
It has been a long time since I made a report, but I have been keeping a list of developments and issues.
Website: 1) I removed four items from the main menu in the left column that appears on every page of the site. Three of them I moved to the “Archive” tab: District Director Info, District Director Report, and Learn from the Experts. The other one was a link to the ACBL’s Partnership Desk, which the ACBL’s webmaster told me is no longer supported.
2) There are three issues. The Tournament Location option is a custom program that uses a list of the district’s tournaments to create a map. For a while it was broken, but Megahertz fixed it. I removed Cromwell and Sturbridge. I added Providence and Marlborough. I left Mansfield and Hyannis on, but added notes that they were canceled for 2022. This will need to be maintained (using the “Clubs” option in the admin section) when the 2023 schedule is set.
The second issue is the banner, which currently says “Exciting New Event Schedules for 0-2500 –Click Here for Tournaments”. It links the NEBridge.org calendar. I don’t know how to change it. Bob always did this. We should probably be highlighting Providence. After that, I don’t know.
The third issue involves reports from the Regional Director. The DD reports had their own custom option. Should I add the RD reports to this program (and bring it back from the Archive)? Should I create a new tab for RD reports? They are now emailed to members; posting them on the website is less critical than it was ten years ago.
3) The list of winners of NABC and NABC+ events has not been updated since 2019. The source of data was lists provided by the DD. I have not received any such lists since December 2019. What should the policy be for the future?
4) I have decided not to post Winners Boards (photos) for the 2022 tournaments. It is a lot of work, and I won’t be attending one of the three events. If someone else wants to take the photos of winners and solicit photos from the ones that were missed, I will post them. However, I don’t want to do this if the percentage of missing photos is high.
I also decided not to award the Best in Class prizes in 2022. With only three events, all in the eastern half of the district, it did not seem worthwhile to me.
5) Someone should check the conditions of contest on the website. I don’t think that the first five documents on the Conditions of Contest tab have been checked in a long time.
Database: 1) A decision should be made about whether the MySQL database, which I maintain on both my iPower account and my local server, will be used in 2023. If not, a suitable substitute to be used as the basis for emails should be found. The current database includes all ACBL members–active and inactive, living and dead–since 2014. It also contains pretty good records of who attended D25 and NABC tournaments since then. It also has a history of achievement of ranks of D25 members and points by month of everyone.
2) In the past I have received .LZH files from Keith Wells at the ACBL to use as the basis for the attendance (at tournaments) table. He did not respond to my last request. Does anyone know if he still works for the ACBL? If not, from whom could I get these files. I used the attendance tables both for targeted emails and for the attendance breakdowns after tournaments.
Email: I currently create the emails by using a text editor on my PC to write HTML statements. I then use the “Code your own” method to paste the code into MailChimp. As I was writing up the documentation for this process it occurred to me that it will probably be very difficult to find someone is who is both willing and able to do this. MailChimp has a lot of templates for emailing that would presumably be much easier to use, but I have never investigated them because I already knew how to make the emails look exactly as I wanted them to.
If templates are used exclusively, it will affect Sue Miguel’s emails. She sends me an email that looks the way she wants it. I extract the HTML from it and then post it using the “Code your own” method.
Bulletins: I was told that there will be neither a printed nor an online bulletin for the Gala. Eventually decisions should be made about the other two tournaments in 2022.
Documentation: I have documented almost everything that I do in “pages” on NEBridge.org. I have created a spreadsheet that serves as an index to these pages. I have attached a pdf of it to this document. I am confident that by later in the year it will be complete and as accurate as I can make it. I suspect that the person or persons who do these tasks will want to simplify the processes, but whatever process is used, it should be documented, and I think that the format that I chose is optimal, since anyone can see the most current version.
The starting page is 342. It can be accessed with the URL NEBridge.org/pages/342. All pages can be reached from there, but if you want to look at a particular page, the easiest way is to key in NEBridge.org/pages/ppp in your browser, where ppp is the three-digit page number on the spreadsheet for the index.
Communications Committee: I think that consideration should be given to restarting the CommComm in 2023 or maybe sooner. I am willing to serve on it, but I don’t want to be chairman in 2023.
Two regional bridge tournaments in New England in 2021 had been canceled because of the pandemic. The Presidential Regional that was scheduled for February 2022 was also canceled because no suitable site in the southwestern part of the district was available. A new event, which was called the Gala, was scheduled for late May, which was the time that my wife Sue and I had planned to take a cruise in Europe1. We had deliberately chosen the second half of May because, in all the years that I had been going to tournaments, the district had never held an event then.
Meanwhile Curtis was trying to figure out if, as an ACBL Employee, Gary would be allowed to be both webmaster for the district. Curtis finally determined that he could. In early July he asked me to set up a Zoom meeting with Gary, Peter Marcus2, and himself. I told him that I had no idea how to set up a Zoom meeting, and that I was very busy at the time.
The second half of July was dominated by the Summer NABC that was held in Providence. Curtis decided that he needed two people to replace me. He offered one of the jobs to Gary in this email sent on August 10.
The other candidate wasn’t interested. That puts you (Gary) back where you’ve been – my choice for NEBC Database and NEBridge.org Webmaster. If you accept the position we will discuss compensation (Mike gets free plays and some other stuff – not too valuable for you) on a per tournament basis.
I suggest you contact Mike for his write-ups on the efforts. If you accept I will also begin the search for a Communications lead to supplement (not replace) existing efforts.
Communications Lead:
• Voting member of the TSC • Cannot be an ACBL employee • Essentially a volunteer position; may, in the future be compensated with free plays or similar consideration. • This primarily a marketing function with technical considerations as agreed with the NEBC Database/NEBridge.org Webmaster • Coordinates the electronic aspects of tournament advertising and execution • Works with the Database/Webmaster • Edits the Tournament Bulletin as required • May use MailChimp email system to create messages as required.
NEBC Database/NEBridge.org Webmaster • Does not and cannot be a voting member of any NEBC Committee • Can be an ACBL employee • This is a compensated position on a “per tournament” basis • Maintains the NEBC website • Maintains the NEBridge.org database • Works with the Communications Lead and Tournament Coordinator to maintain Calendar
This was by far the longest communication that I had ever received from Curtis. It appeared that some progress was being made. The fact that he was conflating the webmaster and database jobs was, of course, disconcerting. The webmaster job had gotten easier over the years. The database job was quite another matter.
This missive pretty much confirmed my notion that no one wanted to revive the Communication Committee. The “as required” appellation applied to the bulletin position was also ominous.
An email from Peter asserted about the database that “It might be work, it might cost money, but I think we really don’t want to abandon it.” Nobody ventured a different opinion. The question then became where the database would be kept. I did not want other people with administrative authority to sign on to Wavada.org.
I am not sure that my next contribution was helpful, but I did not want anyone to claim that I was not forthcoming about the difficulties.
Now that I think about it, iPower is not a critical element. Assuming that two copies of the database (one live and one for testing/backup/disaster recovery) are used, what are needed are two installations of WAMP (Windows, Apache, MySQL, php) or the equivalent. I used iPower for the live version because I already was using its server for other projects on my personal website, and there was a lot of capacity. WAMP is available as a free download for windows-based computers. iPower uses a UNIX version of the three products, but they do not charge extra for MySQL and php.
Mark Oettinger, the newly elected (sort of) vice-president of the district, suggested that Sue Miguel could do some of the work of the Communications Lead. No one objected.
Gary officially accepted the job of webmaster and indicated that he and I might be able to meet together at the Ocean State Regional in Warwick, RI, (documented here) scheduled for the end of the month. I responded with the following:
I have created a user profile for you for the admin section of NEBridge.org. The user ID is GaryP. After I send this email, I will send the password in a separate email.
I will be in Warwick for all five days. I will be attending the meetings of the Tournament Scheduling Committee and the Executive Committee. I will have the other evenings free. I will be pretty busy until then.
I have documented almost everything that I do on numbered pages (the ones that have the green menu on the left) within the NEBridge.org website. The starting page for all communications functions is #342. The starting page for webmaster functions is #85. The full URL’s are https://nebridge.org/pages/342/ and https://nebridge.org/pages/85/, respectively. The easiest way to get to them is to go to NEBridge.org, click on “Tournament Results” and change the /3/ to the page that you want. I have attached a spreadsheet that has all the page numbers.
There are wysiwyg tools for editing the numbered web page. It is also possible to enter HTML code. I resort to the latter when the former doesn’t provide what I want. The concepts are pretty straightforward. When I started in 2013 there was no documentation, and Bob Bertoni’s training session only lasted thirty minutes.
I am looking forward to meeting you in Warwick.
I introduced myself to Gary when I played in the side game, but I never met with him in the evening. I did meet Steve Ackerman, a player from Vermont. Mark Oettinger had recommended that I get him involved in the transition. I sent him essentially the same email.
In September Curtis sent Gary and me a short email asking whether I could teach them to use MailChimp. I did not envision either of them using it much, but here is what I responded.
MailChimp is not hard. I will set up a user ID for NEBPres and for NEBWeb. I will send the passwords in a separate email. The steps for using MailChimp are documented on NEBridge.org. I will provide training if necessary. I know nothing about using Zoom for training.
The big issue is what is going to happen to the MySQL database that is used for, among other things, populating the lists on MailChimp. The database currently resides on an iPower server on which I have leased space for about ten years. I am willing to give the php scripts that I have written to maintain the files to the district, but the database and the scripts somehow need to be copied to a server owned or leased by the district. That is unlikely to be an easy task. However, there is a great deal of other stuff on my website on iPower, and I don’t really want anyone else to have read/write access to it.
The other big issue is that Keith Wells, who is now a contractor for not an employee of the ACBL, has not answered any of my emails in five months. His last one said that he was still the person that I should contact in order to obtain the .LZH files used by the scripts that update the attendance table. On the advice of Tim Hill I sent an email in September to tournaments@acbl.org. The unsigned response, with a cc to Keith, said that Keith was still “at the ACBL”.
So, I have been unable to maintain the attendance table by my usual methods. Someone needs to decide whether it is still necessary for the district to maintain the attendance table, on which I formerly recorded who attended each regional and sectional in New England and each NABC. If not, it might not be worth the effort to continue using the MySQL database to keep a comprehensive roster of players, their advancement, their attendance, and a few other things. In that case the whole emailing strategy may need to be rethought. Maybe it could be done with spreadsheets or some other method. To my knowledge no other district goes to so much trouble to target emails.
It is possible to update the attendance table without the LZH files. The alternative method uses the “Master Point Winners” report in the posted results on the ACBL tournament schedule. However, 1) It is both kludgy and very time-consuming because there are no ACBL numbers, and 2) there is no way that I know of to account for people who earned no points at the tournament. So, I have been reluctant to resort to that method.
I am doing what I can to help the transition, but I don’t want to be the one who makes important decisions that affect how the mailings are done in 2023 and following.
The first sentence was a mistake. The way that new user profiles are created in MailChimp is to “invite” other people through an option in MailChimp. They then are sent an email from MailChimp that explains how new users can create their own profiles.
As of this writing in June of 2023, I have still not been able to gain access to the LZH files.
Shortly thereafter someone brought up the possibility of using the Pianola software that a third party had customized for the ACBL When the product was introduced several years earlier, I had looked into this and shared my low opinion of it with the members of the Executive Committee. I repeated those points for Curtis and Gary.
Addendum: The ACBL allows direct but very limited access to its active player database for emails, but there are several limitations that render this approach less effective in targeting. I have not investigated this approach recently, but the limitations that I remember are:
1) You must use Pianola. My understanding is that it does not support images, tables, font changes, and other tricks that I sometimes have used within messages. Both Sue and I use a lot of embedded images.
2) You can only access the records for a limited number of districts/units.
3) The format is, to say the least, unimaginative. It is black on grey.
4) I am uncertain of how much targeting can be done. I seriously doubt that one can target (as I did for NAP) based on the May 6 ACBL roster. I also feel certain that targeting based on attendance or zip code (Cape, for instance) is not possible.
5) The rate charged U126 is four times what we paid, and the last time I looked that rate is still available.
6) Access to the database can only be for the purpose of emailing. If you want to use it for some other purpose, you must keep your own files somehow.
7) I am not sure that Pianola has all the reporting tools that MailChimp offers. People who have complained to me about not receiving an email are sometimes surprised that MailChimp knows whether each email was delivered, whether it was opened, and whether any links were clicked on.
8) A small number of people have provided me, but not the ACBL with their email addresses.
9) I think that if someone unsubscribes on Pianola, they can no longer be reached. MailChimp has the same rule, but because we have lots of lists, we can control the effect. For example, if a club manager unsubscribed to the recent club mailing, he/she would still receive emails about tournaments, letters from the president, surveys, and other types of emails. On the other hand Pianola does support attachments, and MailChimp doesn’t. I have not found this to be much of a limitation, but if we did not have a website on which to post the attachment so that we could link to it, it would be.
Nobody mentioned Pianola for quite a while after that. Somehow someone got the idea that I would host the database for the district. On October 28 I wrote the following to Curtis:
I don’t host the database now. I pay $200 per year to iPower to host it. I know very little about hosting databases. The district could get an account with iPower or some other hosting service that supports MySQL and php and has a way to import databases and programming files. I contracted with iPower a long time ago. I don’t remember why I picked them.
I will help with migrating the database and the scripts over. I don’t really want to support the php scripts, but if you cannot find anyone who knows php, well … I would have to think about it.
If you are really asking me if I would agree to set up user ID’s for others on my iPower account, the answer is no. I have a great deal of other stuff on my account, and I have spent hundreds of hours on it.
So, the first decision is whether it is worth the effort to maintain a relational database. If the district cannot find a reliable source for getting the lzh files, I would be inclined to doubt it. The roster files, which are the source for most of my selections, can easily be downloaded from ACBL.org and then opened in Excel. Someone who is a wiz at spreadsheets could probably do the selections from the spreadsheets. The uploads to MailChimp require csv files, and spreadsheets could–after some slicing and dicing–be saved as csv files for that purpose.
When the above issue has been addressed, one other remains: How many lists on MailChimp will be used and reused? I suggest at least one for presidential communications, one for regional tournaments, one for NAP/GNT, one for clubs, and one for I/N. We now have a very large number of lists–one for every email (as Bob recommended). This has been feasible because the database has a field to flag players who have unsubscribed. I never select these people for any mailing promoting a tournament. Without that field I would need to reuse lists, as I sometimes do now for other types of emails.
If you decide to reuse the lists, you should add fields for masterpoints and rank description so that you can “segment” the lists as required for the email. This is the way that I handled the five emails promoting the 2022 NAP. The only problem is that someone would need to decide whether people who unsubscribed in response to those emails should also be unsubscribed from one of the other lists.
Curtis put the burden on Gary and Steve with a short reply: “We need someone to host our data base, and we need that someone now. You guys are the experts. Figure out what we need to do, and let’s get it done. “
Gary said that he was not a database engineer, but he was an “Excel weenie.” Steve set up a Dropbox for me and asked me to put the database and the php scripts in it. It took me most of a day to do this because a great deal of what is on Wavada.org is related to my blogs, journals, and other projects. Even after I culled those out, the remainder barely fit in the Dropbox, and the company that sponsored it kept sending me emails that I should upgrade my subscription.
Not much else happened until I wrote up the following summary on November 28:
General: All of the tasks have been documented on pages of NEBridge.org. The appearance of a few MailChimp screens has changed, but the work flow has not. All the documentation pages can be reached from https://nebridge.org/pages/342/.
Webmaster: I have given the credentials for the email redirecting to Gary Peterson. I have also set the emails for webmaster to redirect to his email account.
Action item: The ad on NEBridge.org for the ACBL online regional was still there today.
Database: Peter said that LZH files should now be available from ACBL somehow. If so, it is still probably a good idea to keep up the database if someone can learn how to maintain it. Those files can help with both targeted mailings and analysis of attendance at tournaments.
Action item: I will communicate with Peter about how to get the LZH files from the ACBL. When I do, I plan to upload all of the files for D25 sectionals and regionals in 2022 as well as the Providence NABC. I will then submit attendance reports for the Providence and Southbridge regionals and the Providence NABC to the Executive Committee members via email.
The current database is MySQL. The scripting language php is used for maintenance and reporting. I will create a copy of the database, the php scripts (including the Javascript and CSS), and a file of the SQL statements that I have used for lists and other purposes. I will then send them to wherever the new home is. I will also help with the migration as much as I can.
Action items: If the database is to be continued, 1) Who will maintain it and use SQL to select lists for mailings? 2) Where will the data and programs be stored? The system can actually be run on any Windows or Unix computer that has the free download WAMP or XAMP, but I chose to run it somewhere that provided support, which I have used four or five times per year. 3) Will the person who manages the database also manage MailChimp?
MailChimp: Policy decisions need to be made about how many lists will be used. The issue is how to handle “unsubscribes”. If a person unsubscribes from one list, should they simultaneously be unsubscribed from all? This will not happen automatically on MailChimp, but there is an “OK to email?” field on the database. The “actives” view of the players table, which I often used for selections for email lists, eliminates players with an N in this field or any other disqualifying information.
Action items: Who will manage the site? What will the workflow for new emails be? Will there be any reporting?
Email composition: Sue Miguel.
Bulletin Editor: I have copies of all the ones that I have done. I can send in odt or word format.
Action items: Is this worth doing? Who will do it? Will we resume using online bulletins?
This email generated a lengthy thread of responses. Curtis established the parameters:
Mike has done his usual great job in laying out the tasks ahead. I will take the Bulletin Editor3 task for Southbridge 2 (Mike: please send me the last Bulletin in Word format, please.)
Who will take on the rest of the effort? Please advise soonest.
I sent a copy of the Bulletin that I had created for the Optical Regional in 2022 to Curtis.
Curtis sent the following to Steve Ackerman and Neil Montague, who had expressed some interest in handling the emails:
We need a Mailchimp email expert (or maybe two!) to do the email parts of Mike’s current job. You both are great candidates for this. Any interest? Note: this will, in effect, make you a part of Sue’s marketing campaigns. It’s fun.4
Neil told Curtis that someone would need to show him how MailChimp worked. I invited him to create his own account and wrote:
MailChimp is not difficult. I have documented everything that I do in it on the NEBridge.org website, and the MailChimp site has very good FAQ’s and support when one needs it. I figured it out with no training whatever.
The bigger issue is whether to continue using the MySQL database as the source for creation of lists, and, if so, where it will reside.
Curtis wrote that Neil would officially become the MailChimp person and that Sue Miguel would compose the emails. Steve attempted to address the database issue.
As far as the database goes, I’ve taken a look at the LZH files that ACBLScor uses to update its database. Unfortunately, it only ACBL numbers and Points, not names and addresses. We would need more information than that to maintain the database. Another option is Pianola. I understand they are pricey, but it might be possible to work out a deal with them. https://www.pianola.net
I could not let that go unanswered.
I use four sources of information for the database: 1) Once a month (on about the 7th) I download the entire ACBL roster, which has almost all the census information on all active ACBL members; 2) The ACBL sends Webmaster@NEBridge.org a list of the players who advanced in rank during the previous month; 3) The LZH files for attendance at tournaments; 4) Individual maintenance when I learn something such as a nickname, a new email address, or an unsubscribe. Here is what I have for each player:
I described the problems with using the ACBL’s program that uses Pianola on a previous email. I will look for it and resend it if necessary.
This exchange generated an overly optimistic assessment by Mark Oettinger that showed praise on all the participants. No emails were exchanged in December except one from Curtis that asked me how much I would charge to continue to send out the emails “for one more month”. I said that I would certainly continue to do it if it was necessary. In actuality I sent out all of the emails in the first five months of 2023.
In January Neil wrote this to me: “I think I am supposed to send out the e-mails to the district via MailChimp. I have an account but since I’ve never really used it before, some quick help from you would be appreciated.” Neil was referring to the computer-generated emails sent by BridgeFinesse.com to players who had advanced in rank. I explained to him that he did not need to get involved in this process.
On February 11 Curtis notified me and the other participants that there would be a Zoom meeting to discuss the succession issues. He then wrote that Peter would send the invitation. At some point it was changed to an in-person meeting at the Presidential Regional in Southbridge. That gathering was never canceled, but it did not happen.
An email that I received from Sue Miguel got my goat. Here is what I sent to everyone on the Executive Committee.
In November of 2021 I gave notice that I did not want to be involved in precisely this type of thing–promotion of online gold point events, which I am convinced will be the death of regional tournaments. I have not seen one inch of progress in removing this responsibility.
I will send this out, but I AM PLEADING that the district relieve me of this responsibility. It makes me furious to be promoting this sort of thing.
Curtis sent me an email that said that Sue should have sent the email to Neil instead of me. I sent out this email and several more over the course of the next few months.
Neil sent me an email on March 8 concerning an email that he had received from Paul Harris, the president of EMBA. He wanted to know the details of the district’s contract with MailChimp. I answered the inquiry with the following.
MailChimp charges D25 by the number of emails sent. Back in 2015 or 2016 Bob Bertoni negotiated the purchase of 2 million email credits for $2500 in a “pay as you go” plan. We had to purchase that many to get that rate. At the time we had no limits on the number of lists or the total number of contacts. We have about ninety lists (but they won’t let us create any new ones) and a very large number of contacts. In the old days I built a new list for each version of each email, and I had roughly seven or eight versions for each tournament.
808,020 credits remain. I am not sure that MailChimp still allows pay-as-you-go plans. It appears to me that it now sells four or five tiers of plans that require a monthly fee based on the total number of contacts. Each has other limitations as well.
In my opinion MailChimp’s best feature is that it allows you to “code your own” emails in HTML. It is much more time-consuming to do it that way, but you can–with a few small exceptions–make the email look exactly the way that you want it to. Of course, you have to be familiar with HTML and how email clients (as opposed to browsers) interpret various tags. The only thing that I have never been able to do is to get Outlook to show correctly a caption for an image.
Without the “code your own’ feature I do not know how anyone will be able to create the kind of emails that Sue Miguel likes to send. She creates the emails using a program on her Mac and sends me the finished product. I extract the HTML and make a few changes to fit MailChimp’s requirements.
By the way, MailChimp is now owned by Intuit, the QuickBooks company.
I know nothing about Constant Contact.
I have been promised that I will not be required to send any more emails, but the meeting that was scheduled for Southbridge to determine who would do it and (more importantly) how was never held. Then there was supposed to be a Zoom meeting about it, but it never occurred either. At this point I do not know whose responsibility it is to find a way to continue. I am pretty sure that Curtis does not want to hear any more about it.
Another Zoom meeting was scheduled for March 30 at 8 p.m. Peter sent out the following email at 6:56 a.m. on that day to the people scheduled to attend the 8:00 meeting and a few people from the Connecticut Bridge Association (CBA).
I just attended a webinar (not sure if any of you did, but I did see Ken there) about their new marketing program, sending out emails, and using Pianola. I don’t know enough to know if this is any good, but, unlike a lot of what ACBL does, it actually looked at least presentable.
One obvious benefit is an immediate access to ACBL data (email addresses, masterpoint holdings, etc.) without having to update them ourselves. A downside, to the extent we do it, is that it doesn’t seem to include information about tournaments attended though they said that could be added.
The tools for developing emails did seem reasonable and it does have the ability to include attachments, like a flyer.
Obviously, one issue is cost. I know, when Bob Bertoni investigated this, we ran from Pianola because of cost. They addressed this and said they are cheaper than MailChimp (what they compared themselves to), though they talked about buying 10K or 25K Mailchimp credits. If I remember correctly, D25 bought something like 250K, which was an upfront cost (almost like a capital cost, buying new equipment) and then it lasts for years.
Anyway, I do not have the technical expertise to make comparisons. So, my questions are
1) They recorded the webinar and are offering a masterclass in developing emails/marketing next Tuesday (for about an hour). I will forward the link to the recording and the masterclass if anyone wants to hear it or sign up for the class. I will not sign up, I don’t have the background to make an informed decision.
2) Where are we with MailChimp credits, i.e., are they about to run out or do we have years to go?
3) They are setting up credits for each unit and district and accounts to send emails will be done individually, i.e., a unit or district says who should have access and they will get their own login, not done with everyone in one organization sharing the login. But, is there any rationale to considering setting up credits for the units and district to share, as a way of lowering costs, particularly for smaller units?
I am not looking for answers, since I wouldn’t know how to evaluate them, just asking questions. We can discuss more tomorrow on the ZOOM call.
Will send out the info from them when I get it.
I watched the webinar later, but I wanted to provide answers to Peter’s questions before the Zoom meeting.
I could not attend the webinar because of a medical appointment. Incidentally, the message announcing the webinar was composed using the new tools. The last word or two of every line on the message was cut off when I opened it in Outlook. I tried changing the width of the window, but it did not help.
D25 bought 2 million credits from MailChimp. Over 800,000 still remain. Attachments, especially ones with images, use up a lot of band width. Requiring links rather than attachments is the main reason that MailChimp delivery is so fast.
I have never used Pianola, but I know where I ran into problems with MailChimp. Some of my questions are:
1) How are unsubscribes handled? If someone unsubscribes to an email sent by one user will other users still be able to reach them?
2) To which districts would we be allowed to send email?
3) Can pre-formatted emails like Sue’s be sent or must they be redone in Pianola’s tools?
Curtis took notes at the 8:00 meeting and sent them to the participants. I have posted them here. It is worth discussing his three “Takeaways”.
“Peter will transfer Mike’s data to a new source.” In fact, I sent an up-to-date copy of the database to Steve. Peter had nothing to do with it.
“Henceforth we will use Mike’s data from Peter’s source for emails and the like.” It was not until May that Steve’s copy of the database was available. In actual fact, the audience that I had been using on MailChimp was still used through the end of June. However, Neil did successfully process a couple of Sue Miguel’s emails in May and June.
“Peter and Steve will attend the Pianola Master Class to determine whether we can easily port the current system and data to that (ACBL) system.” I don’t think that anyone involved in the transition process ever attended the Pianola Master Class.
Peter, with whom I had a bizarre contretemps (described here) earlier in the year, recognized the crux of the problem in a friendly email:
I understand that Mike, who has been so good to do all this for us since forever, and had announced his departure as of the beginning of 2023, is still involved and really, really “wants out.”
If we need help to actually move this to final migration, I think we should consider actually getting a professional in this kind of work to help/do it for us. Even if this group has the skill (and I don’t), finding the time can be a much bigger problem, and, if we have to pay for it, so be it. We could speak first to Megahertz5, to hire them, and, failing that, find someone who could get it done. I don’t think their geography matters though, unlike the ACBL, I would suggest we don’t save money by using IT contractors from Poland.
Curtis favored a different approach:
Here’s what we can do to get Mike OUT of the loop, at least formally.
1) Neil: if you can take Mike’s stuff for storage, please do so.
2) Gary/Steve/Neil: please discuss this among yourselves, and determine whether we should take Peter’s suggestion and hire Megahertz to set things up. Let me know what you decide, and I’ll get it approved.
Then let’s finish this.
Steve immediately reported that he had a copy of the database, and he would find a place to put it. His email on May 3 listed the progress that he had made.
I have uploaded Mike’s database to a server on google as I had some issues attempting to sign up at Oracle.
I’ve created user accounts for everyone on this list. To log in, use your username portion of your email, and the number you enter into the bridgemates (so no letters).
I have updated the masterpoints based on the April version of the MP file available to ACBLScor. I understand that in the past we were able to get a more complete database listing from ACBL, but I don’t know who to contact for that.
Neil & Gary, let me know if you need help generating the queries to populate your mailchimp lists.
A few thing that he wrote were not quite accurate. Here is what I replied:
On your MyACBL page do you have a tab called “Member Rosters”? It should be right below “Ribbon”. If not, I think that either Curtis or Mark Aquino can designate you to have access to that feature from the ACBL.
A new roster will come out on 5/7 or maybe 5/8 since 5/7 is a Sunday. I have a list of email addresses that have unsubscribed in the last year or so. The “OK to email” field for all of them should be set to N. Should I send this to you, or is there some way that I can do it?
After I sent another email for Sue, a player replied with a request to change her email address. I forwarded it to Steve. He replied with some good questions.
Does the normal procedure include asking the player to make sure they also update their email with ACBL? I suspect that when I update next week from the roster this email address may be incorrect if the player doesn’t also notify ACBL.
In addition, I updated the player database to flag not to email the addresses you sent me. However, I found about 20% of the addresses were not in our database. I’m assuming these addresses may not be active ACBL members, or they are for some other list than D25? I’m attaching them for your review.
I was happy to respond to this. It indicated that someone was finally getting into the nitty gritty of the database.
When they give me a new address I also change the “email source” to Player. I should have told you this. My program for processing the the new roster does not change the email address unless the email source is ACBL.
Either the addresses were changed, or the players were added to the database after I sent it to you, most likely the latter. So, after the database is next updated, the update of the “ok to email?” field should be run again. Should I change the email that receives messages about unsubscribes to some other account? I received notice of one more yesterday.
This is only important if a different audience is used for a future email. As long as the audience that I have been using is employed, the fact that they unsubscribed from that audience will prevent them from getting any more emails.
A few days later I sent the following to all of the people involved in the transition.
1. A new roster came out over the weekend. Is there a plan for updating Steve’s copy of the database?
2. One more player has unsubscribed, carl_palmer@yahoo.com. Should I change the owner of all of the audiences (Mailchimp word for mailing lists) so that someone else gets the emails that indicate such changes?
3. Neil, when Sue has another email to send out, do you want to try to do it? NAP qualifiers and Nashua will probably be promoted soon. Since we have not gotten access to the .LZH files, they can all be sent from the audience that I have been using (2209_Southbridge_D3_D24_D25) for the last year, but a new selection should be made from the database to update it. Then already defined “segments” of the audience can be used in the definition of the mailing. If necessary, it is easy to define new segments. That audience includes fields for rank description, masterpoints, and district.
4. I have a folder of files with SQL statements that I have used in the past. I would be happy to share it.
Neil said that he would try to send out Sue’s next email, which arrived in my Inbox that same day. Most of my subsequent conversations were with Neil, who had told me that he was very familiar with SQL and had extracted HTML from emails.
Sue has just sent me an email that she wants sent to potential players in Flight B of the NAP.
I will forward it to you. It contains formatted text and an image with a link on it. It does not have a width, but I always set the width to 600px. The link she provided should work, but the image must be uploaded to MailChimp. Sue does not like her emails to have the masthead, but this one is signed by Peter Marcus. So, I would add the masthead at the top. I have enclosed an HTML file that has the width and masthead set. You should be able to paste the text (after removing the instructions in red) into the HTML file. Then find the image (<img) tag and whatever divs or spans are around it. After the physical image (which I get by using Prt Scr and then cropping in an image editor) has been saved as a file and uploaded to MailChimp. The “src=” in the image tag must be changed to the URL on MalChimp. An alternative is to ask Sue to send you the image in a jpg and then upload it.
I almost forgot: the image tag has style=”float: right” in it. Since Microsoft Outlook does not recognize that, I always add align=”right”, which it does recognize. Incidentally, the width in the HTML is set in a table because that was the only way that I could get Outlook to recognize a fixed width.
This is all described in the instructions in detail with pictures on NEBridge.org. The instructions begin on https://nebridge.org/pages/345/. You may very well be able to do all of this using one of MailChimp’s many templates. I have never tried that.
This afternoon I updated the audience (2209_Southbridge_D3_D24_D25) with the data from the latest roster. The SQL statement that I used was:
select familiar_name, last_name, email, name_town_key, rank_desc, masterpoints, district from actives where district in(3,24,25) and ytdpoints >= 1 order by last_name, first_name
It will be necessary to define a segment of the audience that is limited to records in which the district is 25 and masterpoints are less than 2800 or 2900. The limit is 2500, but the check is made against the database as of last August. It would be tricky to get that because there might be people who were not on that roster (late with dues or other reason) but are now eligible. It seems better to annoy people like me who are not actually eligible than to miss some who are.
I should be in most of the day.
Neil, who was still gainfully employed, said that he would work on it over the weekend. He did. He wanted to do the project from scratch, which began by making sure the list (“audience” in MailChimp) was up to date. I was happy to explain MailChimp’s concepts of audiences and segments.
In olden days I created audiences for each email. That made sense when other people (president, I/N director, and district director) were also using MailChimp. If they unsubscribed because of one of their emails, I did not want them to have automatically unsubscribed from mine. In addition I was sometimes using MailChimp for other purposes than event promotion (emails to clubs and for the Best-in-class competition). Furthermore, I also sent to people who had attended New England or NABC events, and the selection was too complicated for segments.
In the last year all of the emails have been composed by Sue, I no longer have access to the tournament attendance data, I did not contact the clubs, and I stopped doing the Best in Class. So, I have been using the 2209 audience for every event. It includes all active players in D3. D24, and D25, and I have updated it every month with the SQL statement that I sent to you. I had previously added the masterpoints, rank description, and district fields so that I could use simple segments to select from this audience for emails for both regional tournaments and Grass Roots qualifiers.
Peter is still, at least in theory, working on getting access from the ACBL to the LZH files again. If we had them, we could update the attendance table as before. This would allow us both to send emails to more people with some likelihood of attending and to evaluate our tournaments better. It would, however, necessitate recycling some of our previous audiences, of which there are 89. MailChimp no longer allows us to create new audiences.
I sent the following to Steve and Neil:
All the “unsubscribes” that I sent to Steve had unsubscribed from the 2209 … audience that I have been using for the last year. When I updated the audience last Monday I selected from the actives view, which excludes anyone with N in the OK to email field. It would not matter for the current email project because they would all be excluded by MailChimp anyway. It is not possible (as far as I know) to send an email in MailChimp to someone who has unsubscribed from the audience used in the campaign.
I got the list of unsubscribes by taking the “export” function in the audience section of MailChimp. It sent to my download folder a zip file that contained three csv files: subscribers, unsubscribeds, and cleaned. The last had email addresses that had repeatedly bounced back. These files all have a large number of fields. I deleted all of the columns except the email address from the unsubscribed file and sent it to Steve. Since I have been using this audience for many emails, and I have previously run this procedure to change the ok to email fields, I am sure that a good number of those on the unsubscribed file already had the ok to email field set to N.
My phone number is 860 930 8784. I am scheduled to play bridge at the Hartford BC on Saturday. I will leave my house at noon and return a little before 5. I have no plans for Sunday, but I wake up early in the morning and then take naps during the day.
I was actually a little excited about Neil taking on this project. It would have been much better if I had been next to him when he did it, as I usually was when I installed a new AdDept system at a client’s. He wasted a lot of time trying to clean up the HTML that had been generated by the software product that Sue used, and some of the things that he did made it worse. He sent me a test copy and an email with the following questions.
I think I have completed the work necessary to send out Sue’s e-mail but I have a few questions:
(1) I thought I put the code into centering the image at the top but it’s not centered. My HTML experience is minimal and from a few years ago, although I did successfully embed the link that Sue wanted in the image. The instructions talk about having text appear when someone is using an e-mail client that doesn’t support images, but when I did it, the text always appeared which isn’t what we want. Do I need to worry about this? If so, let me know what to change.
(2) I followed your instructions of pasting your e-mail into Outlook and saving the source and pasting that into Mailchimp. There are a lot of tags that probably don’t need to be there but probably some of them do. Should I not worry about this or should I eliminate the ones that don’t really belong. As both you and the instructions mention, different e-mail clients require different tags so I can’t really go by how it looks on my machine.
(3) The next e-mail you receive is the test e-mail. I sent it to myself first and verified that I did the href tag correctly (I have experience doing that as we convert statutory references in the law to links to the legislature’s web pages when the Massachusetts budget gets signed so I actually have done this before.
(4) Finally, can you verify that I did this all correctly? The segment should be fine and you shouldn’t have any trouble finding this new campaign.
I looked it over and then sent Neil what I had discovered.
1) The image at the top should be the banner, which was in the HTML that I sent you. It should NOT link to the flyer. The Chicago image should be where Sue placed it. I separated it out on its own line in the HTML editing screen. There is already a link around it. I am not sure if it works. You must change the src= on that image to that of the one that you used at the top. Don’t change any of the other attributes, but add align=”right”.
Also take out lines 8 and 9.
2) The tool that Sue uses inserts a lot of extraneous tags, but I never worry about them. I am worried about the extra line feeds. We need to figure out where they came from.
3) Make the above changes and send me another test. When I say that it looks OK, send a test to Sue.
Neil made some changes and sent me another test along with the following email.
I think I made all of the changes and I eliminated the “excess” html code – at least I think it is excess. I put <br> tags in to force line breaks in the right place. I’m getting three errors (code turns red) but it doesn’t seem to be causing a problem. If I remove the body tag, then the text only goes half way across the page. Please take a look. I also am sending you the test e-mail now.
His remark that “the text only goes halfway across the page” was a reaction to the code that set the width of the email to 600. I looked at the entire campaign more thoroughly this time. Here was my reply.
I had not checked the segment before. I noticed this morning that the total number selected was roughly twice what I expected. D25 has about 6,000 members. The audience also includes D3 and D24. Here is how it currently is defined:
2. From section: As it is,the replies will go to Gary (webmaster@nebridge.org). That should probably be changed to inchair, but Sue may want the replies to go to Peter. It is her call.
3. Subject section: I always have copied the subject from Sue’s emails and pasted it directly into the subject line. That would put it in all upper case. I don’t know if it would increase or decrease the number of people who open the email, but she gets to make decisions like this now.
4. Content: I removed the <html, <meta and the second <body tag. I put “Folks,” inside a <p tag.
On the second <img tag:
I removed align=center and replaced it with align=right. I know that was what she wanted because her original source said style=”float: right;”. I also replaced width=500 with width=400. I also added a ) at the end that she forgot.
After this I expected the test email to look like what Sue sent me, but it doesn’t. This is because you removed all of her <font tags.
You did a lot more work than was necessary. I am sorry that I did not describe this to you very well. Basically, Sue’s email was fine. It was not necessary to remove all of the extra stuff that her program puts in, and, in fact, those font statements were necessary to make it look the way that she wanted.
The only changes that I usually make are:
1) Start with my frame.html
2) Add the banner if necessary
3) Find all of her <img tags: upload the physical image or find the URL if it is already uploaded, change the src= parameter to the location on MailChimp, and add align=”right” if she used <style=”float: right”. By the way, it would make things easier if she sent the image as a .jpg file in addition to the one that is embedded in the message.
In this case the image itself is no longer showing up in my copy of the email that she sent. We may need to have her send it again. I decided to replicate the campaign you made, and show how I would have done the content. The campaign I created is titled 2023 Flight B GNT (Mike’s content). I hope that this makes things a little clearer. I do not understand why Sue’s original image is no longer showing up in the email that she originally sent. I would like to see what her image looked like in Outlook.
Neil replied in detail:
1. Sorry about that with the segment. I have added the criteria that the players have to be from district 25 and now there will be 5466 recipients which is about what you expect.
2. I’ll ask Sue who she wants the from to be. I guess Gary is the default but obviously we can put whatever we want in that box.
3. I’ll ask Sue whether she wants the subject in all upper case. I was taught that all upper case is “yelling” although it probably doesn’t make a difference whether it is all caps or not. I agree with you to defer to Sue on this.
4. There still were some red tags (errors) when I opened my version of this which you edited for me. However, I added a few more tags and close tags at the top and that seem to fix the problem without changing anything.
5. I added back the font tag towards the top. The font appearing on my computer is Helvetica 11 when I put the tab back and when I look at the original e-mail you sent me which was Sue’s e-mail. Yesterday, my version was sending it in Helvetica 10. As you know, fonts are at the mercy of what is on the users computer so what you are seeing might not match what I am seeing. I am looking at these in Chrome.
6. Your version of the e-mail is doing what some of my previous versions did which is only going half way across the page for the image at the top and all of the text. My version has the image at the top the same as yours but the text goes across the page entirely. I think that’s what we want, right? Your change to the Chicago image pushed it to the right and has the text wrap to the left. That’s not what came across in the original from you but I think it looks good your way. I guess I’ll find out how much Sue wants these e-mails to reflect “exactly” what she sends. Not sure what you mean when you say the image from her e-mail disappeared? So we can proceed one of two ways. First, I am sending you my updated campaign test e-mail. If that looks good to you, I will send it to Sue with the question for her from above. If it is still problematic, I guess we can use your version but I will ask Sue about the width issue since it looks weird only going half way across. If it is easier to talk, my phone number is 617-771-2527 if that is how you would like to next proceed. Looks like we’ll get this done today which is what I told Sue.
Our conversation ended with my reply:
3. I am virtually certain that Sue wants the subject in uppercase. When you talk with her, I would not mention about “yelling”. I was taught the same as you. I avoided all-upper case when I wrote emails or anything else. You also should probably ask her about the banner. She did not like it on the ones that she composed, but this one was mostly written by and signed by Peter.
4. The width of the email that I composed was 600 pixels, the standard size of an email window and also the size of the banner. If your window is wider than that, it might have seemed strange that everything everything wrapped at that spot. The 600 px setting was set in both the body and the table. Some email clients respect the one in the body, but Outlook only respects the table. So, if you closed the <body or <table at the top, it would be wider than 600, as it was in Outlook on the test you sent me.
5. On Outlook the font is now Calibri 11. On my version it was Arial 16, which was what was specified in Sue’s. Maybe my eyes were deceiving me, but this morning Sue’s original email had the word image001 where the second image was before. The computer on which her image was stored must have been down; the image is back now. It is smaller and has slightly different writing on it than the one whose URL I gave to you. If I had this to do over, I would try to use it or at least set the width to around 320.
What you sent me is, in my opinion, perfectly fine. You should see if Sue agrees.
Going forward (if you are still game) I advise using the method that I proposed in the replica. I can do one of her emails in about a half hour, and it always maintains her fonts and positions her images where she wants them. Sometimes in the middle of an email she likes to change the font size, color or even the font itself. The only mistake that I have made is failing to find an image that was down at the bottom of an email. If the src= parameter is not changed, it does not appear in the MailChimp version.
You also might want to investigate using a template. When I started, I had several years experience at writing emails in HTML, and I hated the restrictions of the templates.
A few security issues still remained, but the email went out on time. In a few days the security issues were resolved. I had to change the owner of the audience. That will probably need to be redone every time that a new audience is used, but since Neil has been designated as the owner of the account, that should not be difficult.
At the end of the Executive Committee meeting on June 24 in Nashua Neil button-holed me to assure me that he would handle Sue’s emails the way that I recommended. He seemed to enjoy telling me about how he had dealt with the issues. I did not voice my primary thought, which was, “Better you than me.”
After the email went out Neil asked me about the fourteen bounce-backs that were reported. I explained how MailChimp handles them:
The ones that have bounced will have a status of “cleaned”. I generally do not worry about them. They will no longer be sent emails by any campaigns in this audience. If you recycle an old audience for new emails and select them, they will be set to subscribed unless they were already unsubscribed or cleaned on the audience that you archived or deleted. If the first mailing bounces, they will be set to cleaned forever.
Just a reminder: the audience has one record per email address. The database has one record per ACBL number. A lot of players share email addresses.
There is a field on the players table called email_rejected. I have not kept this up, but if you wanted to, you could export the audience. One of the csv files in the zip that it produces will contain all of the cleaned ones. That could be used to make the database more accurate. However, if they later provide the ACBL with a new valid address, that one will appear after the next monthly update. The email_rejected fields are NOT currently automatically reset by the monthly update program. So, the email_rejected field would not be accurate.
The last issue (so far) was that Sue wanted an NEBridge account for TheFairyGOLDMother. I turned this request over to Gary Peterson, to whom I had provided the credentials for the software that redirected the emails. He had lost the password. I sent it to him again.
1. This trip did not come off as planned. However, I did go on a cruise, as is thoroughly documented here.
2. I am not sure why Peter Marcus, who was the principal tournament director for the district was involved at all. Perhaps Curtis thought that because Peter had worked for DEC, he would understand what I did.
3. No Bulletin was produced for the Presidential Regional, the tournament to which Curtis referred. I had produced the Bulletin for the Optical Regional in November. Thereafter the Bulletin, which cost to district $100 per tournament, was considered too expensive to continue after an informal email poll of members of the Tournament Scheduling Committee.
4. Over the years I sent out perhaps twenty email messages for Sue Miguel. I do not remember that any of those experiences was what I would call fun.
5. Megahertz Computer was Bob Bertoni’s company. In theory they supported the district’s website, but it was difficult to get them to respond to problems and questions.
In large measure this entry is based on and inspired by a set of recently discovered messages that I sent to my partner, Denise Bessette, about new projects that we were researching or working on. The first email was dated in late 1999. The last was in early 2001. The messages portrayed an exciting but scary time for both of us.
By the middle of the nineties it was evident to us that the way that TSI had been programming in the past fifteen years was becoming obsolete or was at least losing popularity. In 1992 Microsoft left IBM at the starting gate when it released Windows 3.1, the first version of its operating system that featured a graphical user interface (GUI) and was also stable enough that large corporations took it seriously. One could still make the argument that text-based software systems like the ones that we had developed were appropriate for many business tasks—in fact, most of the most important ones. However, if you did, you were probably dooming yourself to the fate of typewriter salesmen.
In fact, systems like AdDept and TSI’s other systems were branded by many of the magazines of the day as “legacy systems”. The emphasis of the new approach centered around the appearance of the screens, which now featured colors, images, text boxes, radio buttons, and varied fonts. They were certainly more interesting to look at than anything that we had produced. The mouse was the thing! The keyboard was only used when absolutely necessary. Whether they were as efficient or as easy to use was debatable, but, as I already noted, we were well aware of what had happened to the typewriter salesmen.
Another thing that happened during the middle of the nineties was the explosive growth of the Internet. All software developers wanted to be a part of it, but few were exactly sure how to approach it. I knew that we needed to figure out what aspect we should concentrate on, but it was not an easy decision to make. A few early participants made a lot of money, but an awful lot of ideas were catastrophic failures.
The Search for a GUI: I spent countless hours researching ways that we could provide a GUI for the AdDept system that did not involve a complete rewriting of the hundreds (and growing daily) of screens that we had already implemented. Every developer who worked on IBM midrange or mainframe systems must have been faced with the same problem. We all wanted a way to provide a system that looked modern but also took advantage of the thousands of lines of functioning code that had already been written.
I don’t know why, but IBM was not much help in this endeavor. Instead, in the late nineties IBM became a strong proponent of an object-oriented programming language developed by Sun Microsystems called Java. This was a startlingly new language. The first version was released in 1996.
I bought and read ten separate books that purported to teach Java programming. The structure of the language was consistent with the first principle of its design: “It must be simple, object-oriented, and familiar.” Well at least it was simple and object-oriented. The structure of the code was nothing like what I was accustomed to. Its main orientation was to a computer display, which it considered a set of objects, each with a set of properties and methods. That approached worked well enough for a screen, but how would it work for other things? After downloading the software development kit to my laptop and spending hundreds of hours mulling the contents of those books, I could do all of the exercises in every book, but I had not the slightest clue how to begin to code a system to manage any aspect of retail advertising. In fact I could not replicate even one screen of the AdDept system.
I did not completely discard the notion of using Java somehow, but if we did, we would definitely need some help. As I look back on this, maybe this is the reason why IBM was so crazy for Java.
The Spreadout Project: Users of TSI’s systems seldom complained about the look or feel of our data entry screens. Those screens would never have won any design awards, but the formats were completely consistent throughout the application, and everyone knew that they got the job done efficiently. Furthermore, they knew that TSI could implement requested changes rapidly and at moderate costs.
What they did not like much was the look of the reports, which was limited to one non-proportional font—Courier—with no images or even styles like italics or bolding. Many, if not most, of the people who used AdDept were quite good at making and manipulating spreadsheets. They were used to controlling the format of the output, and they liked the flexibility. For example, if they wanted someone to concentrate on one column or row, they could easily change the font, color, or style for just those cells.
Several clients asked us if it would be possible for us to produce an Excel spreadsheet as the output from designated programs in AdDept instead of or in addition to printed reports. I did not know if it would be possible, but I said that I would look into it. I dubbed this project “Spreadout”.
It was rather easy to produce an output file that contained the same rows and columns as the report, and we implemented that option in a large number of AdDept reports. The user could then download that file to their PC. That file could then be loaded into Excel with the rows and columns intact. However, the fields (or cells) in the file contained only text or numbers. It was not possible to download formulas for totaling or designate any kind of formatting. Furthermore, the process of downloading the file was not exactly speedy.
I tried to figure out what it would take to produce code that could provide files that could be opened in Excel with predetermined formulas and formatting. I found some documentation from Microsoft of the Excel files, but I never could concoct a way to provide what our customers asked for. Furthermore I never heard of anyone else who had accomplished this, and —believe me—I searched..
I did, however, managed to provide an alternative that proved popular to some clients. Almost all the AdDept customers used Hewlett-Packard printers that were accessible by the AS/400. HP sold books that documented the format for files in HP’s printer command languages, PCL 4, PCL 5, and PCL 6. I could then write code to produce spooled files that contained the output in exactly the format that the client specified. The downside was the considerable amount of coding required for each report, many times as much as it took to produce it in the Courier-only. It also required an extra step to send the output directly to the printer without being reformatted.
However, a few clients were so insistent about the need for a precise format that they were willing to pay the price. These reports were almost always the ones that they distributed to other departments or to higher-ups.
If anyone else ever did a project like this for the AS/400, I never heard of it. Unfortunately, I never figured out how it could be marketed as a stand-alone product usable with other AS/400 software.
As the new millennium approached, we—that is, Denise Bessette and I—felt that we needed to expand TSI’s horizons. In January of 2000 we flew to San Diego for IBM’s PartnerWorld conference in the hope of making contact with people who could advise us how to adapt to the need for modernization and the Internet. That enjoyable but frustrating experience has been described here.
On February 25, 2000, I took the time to write up in a fairly detailed manner how, given the inherent limitations of a small business like ours, TSI should to proceed in trying to develop a second line of business. Here is a portion of that memo:
General principles:
1. We should get the best people available to help us.
2. We should maintain AdDept as a dependable source of income. Whether we should invest a lot of time and/or money in enhancing and marketing AdDept is still to be determined.
3. We should try to leverage our assets better. Our income is too heavily dependent upon the number of hours put in by Mike and Denise.
4. We should assume that the economy will remain strong for another two years. On the other hand, we should avoid debt or at least large amounts of debt in case this assumption turns out to be false.
5. We should add new skills that are more marketable. That means learning some subset of Windows, object-oriented programming, and the internet. We should be thinking past the next project to the one after that if we can.
6. We should look for partners with skills and assets that complement ours.
7. We should not be deterred by the fact that some of these principles seem incompatible.
8. We need to act fast. Pursuing René2 cost us seven months. On the other hand we might have gone down some less profitable paths if she had been on board.
I think we should take the following steps as soon as possible.
1. Find out what it takes to get our existing clients to use AdDept for insertion orders. The following clients are not using AdDept for IO’s: Macy’s East, Neiman Marcus, Filene’s, Saks Fifth Avenue, and Hecht’s. I checked Herberger’s. They have ads through March 29, 2000, at least. Macy’s West is apparently starting. Gottschalks ran insertion orders yesterday. I don’t know about Meier & Frank, but I can take care of that on my trip.
2. Find out which advertising departments have access to the internet and would be willing to use it to check on insertion orders. I don’t think that this would be a problem with most of them. Unfortunately, we don’t really have anyone in the office who can do this for us.
3. Make an appointment with Ken Owen3 to run the idea of a clearinghouse for insertion orders by him. He may be very interested in working with us on it. I have quite a bit of respect for him. At the very least, he is smart and completely honest.
4. Run the clearinghouse idea by at least one of our clients. Why not schedule our trip to New York and run it by Tom, Chris, and whoever their ROP person is?4
5. Run the clearinghouse idea by at least one newspaper or someone who knows how newspapers think about these things today.
6. Start trying to package and market AdDept and/or AS/400 products and services. We need to maintain or enhance our cash position over the next six months.
7. We should find out what, if anything, the National Newspaper Association (NNA)5, the AAAA6, and AP AdSEND have done in this regard. The AP is a potential partner in this venture. I once had a copy of the NNA’s EDI spec7, but I seem to have thrown it out when we moved. I will see what I can find on the Internet.
Requirements for hiring a marketing/client services person:
1. He/she must be able to get along with Mike and Denise. This includes having a good work ethic. I think Doug barely met these qualifications.
2. Must be able to get along with the clients.
3. Must be willing to spend a lot of time on the phone.
4. Must be able to talk to decision-makers and occasionally presidents of corporations without looking foolish. Doug could do this, but his ability to identify the real decision-maker was just so-so. He was also almost always overly optimistic, but this might be necessary to offset my tendency to see the negative side of everything.
5. Must be able to refrain from overselling.
Pluses:
1. Intelligence. Determination can go a long way to overcome deficiencies in this categories, but I don’t think I want to try to explain things to someone any duller than Doug.
2. Retail experience.
3. Newspaper experience.
4. Other advertising experience.
5. Good business sense.
6. Sales experience.
7. Computer experience.
How to proceed.
1. We can run an ad in the Courant. There are almost as many classified ads for sales and marketing people there as for programmers. The only major retailer in the immediate area now is Ames, and they run no ROP. Therefore the chances of finding someone in Hartford who understands retail advertising are slim.
2. We can contact a headhunter. We don’t have to pay unless we find someone, but we will have to pay plenty if we do. It might be worth it if it speeds up the process.
3. We can advertise on the Internet. Does that cost money? If so, how much?
4. In interviews I think that we should consider dangling a carrot of a spinoff of a .com company for the insertion order clearinghouse. I am not exactly sure how to present this idea to someone. Maybe we could offer them a percentage of the new company with the understanding that we would try to sell it once it has become established.
In retrospective I find it impressive that I was able to earmark in advance so many important issues that TSI would face over the next few years. We made some mistakes, but we made a lot of good decisions.
A month later, on March 25, 2000, I mailed a letter to our contacts at all of the companies that used AdDept. I solicited their opinions on what TSI’s priorities should be in the new millennium. Here is a copy:
TSI is in the process of evaluating how best to allocate its resources over the course of the next year or so. Our highest priorities will remain providing excellent support for existing installations and responding to requests for custom programming from existing clients. However, there are a few additional projects that we are considering. We are very interested in learning what our existing clients think about them.
1. Menu maker: This is a fairly simple idea both in concept and in implementation. You would be provided with either a PC/Mac program or an AS/400 program that would allow you to create your own menus. The menus would reside in a separate library so that they would never get mixed up with the standard AdDept menus. You would provide the name for the menu and the heading text. For each option you that want to add, you would be allowed to select from a list of AdDept programs and menus. You could also enter your own command or an IBM command (e.g., WRKQRY). If you selected an AdDept menu or program, the description and the online help would be filled in for you, but you could override the text to make it say what you wanted.
2. GUI front end: Most software companies that market systems of a size comparable to AdDept have budgeted more than $1 million to “modernizing” their data entry screens to use a “graphical user interface” that is consistent with the methods used by Windows and Mac programs. It is now technically feasible to create a fairly nice GUI front end for AdDept for much less than that using products available from third party vendors. However, there is still a considerable capital outlay involved. We also estimate that it would take at least half of a man-year of labor. Furthermore, the PC or Mac would have to meet certain minimum requirements. Terminals would still use the green screens. TSI’s support regimen would be more difficult. The interactive programs would probably run slower on older AS/400’s. They may actually run faster on newer boxes.
3. Output to Excel: We believe that it is technically feasible (albeit difficult) to create a file from the AS/400 that is usable by Microsoft Excel with no intervening steps. It is a relatively straightforward task to download data files (or even spooled files) to spreadsheets today, but many intervening steps are required to get something presentable. TSI’s proposed method would allow you for each report that is eligible for this kind of treatment to designate (and permanently store) the formatting of the worksheet—report titles, column headings, “fit to page”, and most of the other values in “File, Page Setup.” You would also be allowed to designate fonts and sizes for the report title, the column headings, the body text, and each level of subtotals. The subtotal values would be formulas, not simple values. The same program could be used for data files that are produced by queries. The resulting worksheet could then be edited as needed. You can even edit, add, or delete lines in the worksheet. The subtotals will automatically be updated. Most simple reports could be reformatted to use the proposed program. It might be difficult or even impossible to generate some complex AdDept output using this approach.
4. Insertion order clearinghouse: We have long thought that the methods used for reserving newspaper space leave too much room for error and are overly labor-intensive, both for the advertiser and for the newspaper. The purpose of this project is to make the ordering process easier and to minimize the potential for miscommunication.
Instead of faxing the orders, the AS/400 would send them electronically to TSI. We would post them on a website. When the newspaper reps sign on, they would see all orders for them from all advertisers who are using this service. They would be able to add comments or questions and confirm them electronically with or without reservation numbers. They could also print the orders and, eventually, download them directly into their reservation systems. When you sign on, you would see all of your orders. It will be immediately obvious which ones have been confirmed, which have been read but not confirmed, and which have not been read yet.
What do you think of these ideas? Do you have any ideas of your own? We would greatly appreciate it if you would communicate your feedback to us at your earliest convenience. The last thing that we want to do is invest a lot of time and money in something that is of little or no perceived value to our clients.
I don’t recall receiving any substantive responses to this, but around this time Steve VeZain sent me a rather lengthy email that explained some of the priorities for Saks Inc. Our dealings with him and his company are detailed here.
Net.Data: At some point I became acquainted with an online forum called IGNITe/4007. This was a website where AS/400 developers could pose questions about using the AS/400 for applications for the web. Although some IBM experts participated, the forum was not run by IBM, but by a former IBMer named Bob Cancilla8, who worked for a company in Rochester, MN, the home of the AS/400.
Bob also wrote the book shown at left that explained how to use the AS/400 as an Internet server. IBM disdained the approach of its customers using a book written by someone who had actually gotten the AS/400 to function as an Internet server. Big Blue preferred that its customers spend hundreds of dollars on classes or thousands of dollars on consultants rather than $15 or $20 for a book. They also championed something called WebSphere to manage applications written in Java. During February and March of 2000 I had puzzled over the Redbook that documented this product. I was nearly ready to give up on the idea of using the AS/400 for anything related to the Internet until I found Bob’s book and website in April of 2000.
I purchased this excellent tome and followed most of Bob’s advice. I successfully configured TSI’s model 150 as an HTTP server to serve web pages to browsers and as an FTP server for exchanging data files. It was possible to use the AS/400 as an email server, but Bob advised against it. We elected to use AT&T for sending and receiving emails for our employees. We later configured our AS/400 to send outgoing emails through the SMTP (simple mail transfer protocol) server. Eventually IBM decided that it was a bad idea to have its own proprietary HTTP server and supported a version of the Apache server used by almost everyone else.
At that time the most popular scripting language for web-based applications was PERL. IBM never supported it on the AS/4009. Instead it provided its own language, which was called Net.Data (pronounced “Net Dot Data”). This was the only web language that could be used on the AS/400, and no other system in the history of the world ever used it. We obtained a copy of IBM’s handbook on Net.Data (posted online here), and I determined that we could probably use the language for what we wanted to do. Here is what I wrote about it at the time.
I signed on to the IGNITe400 website and registered as a member. It’s free. You can ask questions there. I looked at a few of them. Bob Cancilla himself answered some of the questions! I also looked at IBM’s Net.Data website. It is full of information.
I printed out a lot of documentation. I am now convinced that we can do what we want to do with HTTP server and Net.Data. This is exciting. Buying that book was a great idea. The links alone are worth the price. The biggest difficulty that I see will be working out the process of getting the orders from our customers and then from others.
… I have more than doubled my knowledge about the AS/400 and the internet in the last two days. Moreover, I think I could do it! I think that we should try it some time this coming week.
Net.Data was an interpreted language, just as BASIC was on the Datamaster and the System/36. The programs (which in web parlance were called scripts or macros) were not compiled into executable machine code. Changes to the scrips took effect as soon as the programmer made them. So, a developmental environment was a necessity. The time it took the processor to interpret the code and generate the HTML code that the browser could understand made all of the programs considerably slower than the compiled BASIC programs on the same machine. However, they were lightning fast compared to Java, the approach blessed by IBM.
So, I taught myself how to use Net.Data to deliver interactive scripts for a browser (at the time the main choices were Netscape Navigator, Internet Explorer, and whatever Apple called its browser before Safari). The language itself was relatively easy to understand, but programming for numerous constantly changing browsers was much different from programming for a very stable AS/400 and its 5250 user interface.
I also had to learn the Common Gateway Interface (CGI), which was the method of reading from and writing to files on the AS/400. This was totally different from what we were accustomed to. Our programs had always read the files a record at a time even after we switched to the AS/400’s relational database. With Net.Data it was necessary to execute an SQL statement that returned a set of data—rows (records) and columns (fields)—that was stored in an array (called a table in Net.Data). It was then necessary to loop through the rows of the array. I was already somewhat familiar with SQL, but I needed to learn how to use “joins” to do complicated selections.
I also needed to buy books on HTML and JavaScript. If I had realized before I started that I needed to learn all of this, I might have deemed that the project would require more time and effort than I could afford. However, by the time that I realized what I was up against, I had invested so much time that I was not about to abandon the project.
There was no syntax-checking of Net.Data macros, and, at first, there was no editor to help by color-coding the statements. So, when I ran into a problem, which happened quite frequently, I had to search elsewhere for help.
In researching for this blog, I found a pdf online for a Redbook (technical manual) that IBM published for people like me in 1997. It is posted here. Even a quick glance will make it clear that writing applications for the AS/400’s HTTP server would be a daunting task. For example, it contained this statement: “Net.Data Web macros combine things you already know such as HTML, SQL, and REXX with a simple macro language.” I did not know HTML at all, I knew only a little SQL, and to this day I have no idea what REXX was. Also, the Redbook neglected to mention that it was not really possible to write interactive programs without JavaScript.
I hung in there. Here is one of my last messages: “I feel a lot of pressure to work harder. I want this new project operational yesterday. It is going to be difficult at first. I want to get over the hump.”
I spent a lot of time in the IGNITe/400 forum. My best source of information was a guy from (I think) New Zealand, of all places. I never met him in person or even spoke with him on the phone. His name was Peter Connell, and he helped me through every difficult coding problem that I encountered. Not once was he stumped. By the time that I was well into the project, I was able to provide solutions to coding problems that others described.
TSI’s Internet Project: Even before Denise and I attended PartnerWorld, we had pretty much decided that our best shot at developing a successful Internet product would involve insertion orders, which is what newspapers and magazine call reservations that they receive from advertisers for ROP (display ads), inserts, polybags, or any other kind of advertising. TSI’s AdDept customers sent their reps at newspapers a schedule that listed all of the ads that they wanted to place for a specified period—usually a week. Most of them faxed this information to the papers. The rep at the paper examined the schedule. Sometimes questions required phone calls. Sometimes requests (such as designated positioning in the paper) could not be accommodated. Even after final approval the schedule was often changed by the advertiser before the ads ran, sometimes with very little advance notification.
Errors on both sides were not rare, and they could be quite costly. The newspaper often gave the retailer free ads to make up for the mistake. The advertiser’s loss might be much greater. In the nineties and early twenty-first century ads in newspapers were the primary vehicle for communicating with customers. Mistakes in the ads could cost the retailer thousands in sales, and they were embarrassing to the advertising department. Occasionally heads rolled.
In 2000 most retail advertisers faxed their schedules to the newspapers. If the line was not busy, the phones were rather reliable. However, what happened to the schedule after the fax machine received it? Was the printout legible? Did the rep ever get it, and, if so, what did he/she do with it. What assurance was there that the fax that the newspaper used to compose the paper was the final version?
We thought that the Internet might provide an opportunity to speed up this process and to improve its reliability. My first idea was to replace faxing with email. If the AS/400’s (free) SMTP server were installed, AdDept could compose and send to the newspaper an email that contained the schedule. Wouldn’t the newspaper rep immediately print the schedule? If so, how was this better than faxing? Doesn’t it just add another step? Besides, email is demonstrably less reliable than faxing. The worst that usually happens with faxing is that the output is blurry or even unreadable. Emails, in contrast, can be held up by any Internet Service Provider (ISP) that handles the message, and there could be dozens. So, the schedule might never make it to the rep’s inbox.
Eventually Denise and I settled on using FTP to send the schedule from the client’s AdDept system to TSI. Thereafter TSI’s AS/400 managed the whole process using a combination of BASIC programs and Net.Data macros. Details of the actual design are posted here.
After Denise and I agreed on the design, several details still needed to be settled:
Who will do the coding at TSI?
Who will pay for the service, the advertiser or the newspaper?
How much will we charge?
How will we market the product to our clients and their newspapers?
How can we entice advertisers that did not use AdDept to use this method for insertion orders?
Can we take advantage of the link established between TSI, the papers, and AdDept for other modules?
What will the product be named?
Will the project be part of TSI or a new financial entity?
The answer to #1 turned out to be Mike Wavada. I expected that I would eventually train Denise or one of the programmers so that they could at least support the existing code, but it never happened. It astounds me to report that this was a one-man coding job from day one, and no one else at TSI ever learned Net.Data. Hundreds of papers and most of the AdDept clients relied on it starting in 2002 and continuing through early 2014. Think about this: Between 2003 and 2012 I took six vacations in Europe and one cruise in the Caribbean. There were no serious incidents!
Questions 2-5 are addressed in the entry about marketing of AxN, which is posted here.
From the outset I was hoping that the nexus connecting newspapers and the retailers through TSI’s website could be used for other communications as well. The most obvious one was for the delivery of the files that contained the layouts of the ads. Nevertheless, I was reluctant to pursue this for several very good reasons. The first was that the Associated Press already had a huge head start with its very popular product called AdSEND10. There were also several other companies that offered similar services.
The other thing that gave me pause was the potential legal liability. It seemed to me that if we failed to deliver an ad correctly and/or promptly, we could easily be sued. A fundamental tenet of TSI’s operation had been to avoid any activity that might occasion a lawsuit. Throughout the first two decades of its operation, TSI had successfully avoided litigation. Also, we knew nothing about the process of sending ads electronically, and the AP already owned satellites that it used for this purpose. I also learned later that AdSEND had twelve dedicated T-1 lines, and one of TSI’s clients told me that that was not nearly enough. TSI eventually installed one T-1 line that easily handled the insertion order traffic generated by AxN.
An idea that I liked better was for the newspapers to transmit their invoices electronically through TSI’s servers to AdDept users. I even came up with a cool name for this: e-I-e-IO, which stood for electronic invoices and electronic insertion orders. My idea was to provide a program to feed the newspaper’s billing system with the information from the insertion order, and to feed the retailer’s AdDept system with the same information. I did a little research to see if one software system for billing or accounting was dominant in the newspaper industry and discovered that this was decidedly not the case. So, we would face the prospect of persuading one paper at a time, or, at best, one chain of papers at a time. Furthermore, someone else had already claimed the URL that I really wanted: eieio.com.
The name that I picked for the new product would still work if we came up with other ways for TSI to serve as a nexus between advertisers (A) and newspapers (N). It was AxN, which was pronounced “A cross N”. The A and the N were always portrayed in dark blue Times New Roman. The x was always in red Arial.
That leaves question #8. Denise was always in favor of making AxN a separate financial entity. However, we never found a way to extricate it from the rest of the business. We looked at the revenues separately, but we never even did a separate P&L for it.
1. René Conrad was TSI’s liaison with Kaufmann’s, the May Company’s division based in Pittsburgh. Both Denise and I had a very high opinion of her. When Doug Pease left TSI in 1999, we tried to hire René. Details of the AdDept installation at Kaufman’s are posted here. The unsuccessful pursuit of René is documented here.
2. Ken Owen is a friend and was a client. The latter role is explained here. By 1999 Ken’s business had drifted away from creating and placing ads for clients to software for the Internet. He gave us a little free advice, but the role for him that I envisioned did not materialize. I communicate via email with Ken every year on March 4, the holiday that we celebrate together—Exelauno Day.
3. Tom Caputo and Chris Pease were our key contacts at Lord & Taylor in Manhattan in those days. The history of the installation at L&T is recorded here.
4. I did contact the NNA, but nothing came of it. The person with whom I spoke was nice enough, but it became evident that trying to work with this organization would be extremely time-consuming and not the kind of thing that I was good at or enjoyed. Eventually I discovered that there were almost as many administrative systems for newspapers as there were newspapers. It appeared that there were no accepted standards.
5. The American Association of Advertising Agencies (AAAA—universally pronounced “four A’s”) published an annual list of software for ad agencies. For years TSI’s GrandAd system was on the list. I am not sure what I had in mind as an additional relationship. Perhaps I envisioned ad agencies that specialized in retailers might want to use AxN for insertion orders and would work with us to create an interface. Perhaps I thought that other software companies might add the interface to their products for ad agencies. Nothing like any of these things ever happened.
6. EDI is short for Electronic Data Interchange. It refers to an orderly setup that enables participant to exchange information electronically. When there are only two participants, it is usually just called an interface. “Specs”, which is short for specifications, refers to the documentation published and delivered to the participants and prospective participants.
7. I have no idea what the name of this group meant. At the time IBM was busy promoting the idea of e-business. IBM’s marketing director proclaimed at PartnerWorld that IBM “owned” the concept. So, that may explain why the e is not capitalized. I was surprised to find an article in Enterprise Systems Journal about IGNITe/400. It is posted here.
8. Bob Cancilla went back to IBM for a while and then became a consultant. His LinkedIn page is here. In 2018 he wrote about the thirtieth anniversary of the AS/400. It is posted here. The article explains some of the reasons why IBM treated the AS/400 division and its customers so shabbily almost from day one.
9. For some reason IBM repeatedly changed the name of the AS/400 to a bunch of things with the letter i appended. The operating system remained the same. Everyone at TSI, like most users, still called it the AS/400 even after the name changes.
10. In 2007 Vio Worldwide acquired “the assets” of AdSEND. The deal is described here. In 2010 Dubsat acquired Vio Worldwide. This transaction was reported here.
Even before I became a professional software developer, my friends and acquaintances often approached me with their ideas for computer programs. It started in the Army with Doc Malloy’s idea for a tennis game, continued through graduate school, and was nearly ever-present in my business life. It seemed peculiar to me that so many people seemed to imagine that I had a skill that they lacked but no idea how best to employ it.
In point of fact, the limiting factor in software development was almost always money. A new software system required a substantial investment to cover development and testing costs, as well as marketing expenses. Very seldom did the people who propose these project give any thought to helping to finance them. At least they never volunteered information about having a secret source of funds. They evidently thought that they should share in the imaginary profits because they provided the original idea. I sometimes told them, “ideas are a dime a dozen. Implementation is everything, and marketing brings it home.”
I had plenty of ideas of my own. A few of them, such as the idea of running several simultaneous “threads” for the cost accounting programs generated a bit of revenue for TSI. One of my ideas, the use of a butterfly-shaped website for insertion orders and emails for notifications, resulted in a very profitable product for TSI, AxN. The genesis of its design and the marketing concept that turned it into a financial winner is described here.
TSI’s clients also had a large number of ideas for programming, but they seldom expected us to work pro bono. I spent many hours researching and writing quotes for changes to our systems requested by our clients. I doubt that a month went by in which I failed to produce produce ten or twenty of them. I considered my most important responsibility at TSI to be providing a clear description of each requested project and assigning an appropriate cost figure.
Very seldom did someone approach me with a project that included funding. I can think of three times in forty years. Only one of these concerned software that we had already designed and coded. The person making the proposal was Gilbert Lorenzo1, who was one of the top bosses in the advertising department at Burdines, the Florida division of Federated Department Stores.
Gilbert telephoned TSI’s office in the early nineties. He had received one of our first mailings about AdDept, our administrative system for large retail advertising departments. He said that he would be in New England to meet with some people at Camex2, the company based in Boston that marketed a system for digitally producing page layouts for newspapers and large advertisers. He requested us to show him a demonstration of the AdDept system.
We reserved some time in a demonstration room at the elegant IBM office in Waltham, MA. We had a relationship with this office, but we had never done an AdDept demo there before. I arrived there as early as I could to get the system set up for my presentation. It was a very nice facility that always impressed potential clients.
The AdDept system in those days was fundamentally sound, but many “bells and whistles” were added on in the subsequent decade. In almost every case they were suggested by and paid for by one AdDept client or another.
The most impressive thing about the demos in the early years was the speed with which the programs moved from one screen to the next. Once the tables were set up, a user could define all aspects of a new ad to run in dozens of papers in just a minute or so. This always generated the biggest “Wow!”
In our discussion after the meeting Gilbert said that he liked what he saw. He might have even said that he wanted to buy the system. However, I did not hear from him again for several years. This was consistent with what always seemed to happen with Federated’s divisions, a phenomenon that is explored in more detail here.
Meanwhile Burdines was—unbeknownst to me—experiencing explosive growth. In 1991 alone the number of stores increased from twenty-seven to fifty-eight through the assimilation of two Federated divisions— the Maas Brothers and Jordan Marsh stores in Florida. More stores were added throughout the rest of the nineties. By the end of the decade Burdines dominated the department store market throughout the entire state.
The purpose of Gilbert’s second contact with TSI was to invite me to Huntsville, AL, the home of a software company with which he was working at the time. I don’t remember the name of the company. I do recall that two of the team assigned to this project formerly worked as software developers at Camex before DuPont purchased the company and changed its focus. One of them was Mike Rafferty3, whom I had met at Camex’s headquarters when our common customers had requested that an interface should be constructed between the two systems, a project that was described here.
The software company in Huntsville had a very impressive headquarters. As I understood it, the company’s primary customers were NASA and companies that worked with NASA. That was de rigueur in Huntsville.
Gilbert explained that he was working with Mike and the others to develop a comprehensive software system for the advertising department at Burdines, and he hoped and expected that the other Federated divisions would also use it. He wanted TSI (or at least me) to participate in the project, and he insisted that he had the funding for it.
Mike described their approach to the project. They intended to use a home-grown database that resided on a server, but most of the programs would reside on the individual “clients”—PC’s or Macs. When I told him that TSI’s programs were written in BASIC, he suggested that we consider converting them to use Microsoft’s Visual Basic.
Most of the discussion concerned the scope of the project. They were interested in integrating something like AdDept into the unitary structure that they envisioned. No one addressed how TSI would be integrated into the development process. Maybe they expected me to fill in some of the details or to volunteer to research how difficult it would be. Maybe they knew that we seldom backed down from a project just because it was difficult.
The atmosphere was cordial and positive. I remember that we all went out to lunch together, and I ordered a Monte Cristo sandwich. Nevertheless, this meeting made me very uncomfortable. On the one hand, the prospect of installing a version of the AdDept system into all the remaining Federated divisions was way beyond tantalizing. It would be a dream come true. What they suggested would undoubtedly a big job, but TSI had a talented group of programmers who were quite familiar with both the subject matter, and the way that I liked to approach big challenges.
On the other hand, from my perspective the way that this project was described was adorned with “red flags”.
I had already researched the possibility of using Visual Basic. It might have been possible to convert some of the programs, but there were no tools designed to help. It would certainly have taken TSI several years to produce a workable system. We would be discarding all of the tools that we used in favor or ones that we had never used and, to my knowledge, had never been used by anyone in a data-intensive situation. TSI’s programmers would certainly need a lot of training. We would probably need to hire skilled employees or at least consultants to achieve any degree of efficiency.
Their whole architecture was different from what we used. In the AdDept system the data and all the programs resided on the AS/400 server. The “client-server” approach that they proposed located the data on a server, but the program were all distributed to the PC and Mac clients. To me this sounded like an administrative nightmare. All changes—including emergency fixes—must be installed on all of the clients.
I considered the AS/400 integral to AdDept’s success, and so did our customers. The operating system code was built on the database rather than the other way around. That meant that the system itself could never be used for programs with the the huge requirements for memory, disk, and processing speed that design and creation of advertising layouts required. The AS/400 was definitely not designed for that. However, it was ideal for administrative systems like AdDept. It competently handled so many problems with which all-purpose operating systems constantly struggled.
I trusted IBM and the AS/400’s database. I knew how to get the latter to function efficiently, and IBM’s support was unmatched in the industry. The idea of converting to a home-grown database seemed just preposterous.
By the time of the meeting in Huntsville TSI had finally turned the corner. The AdDept product had a solid client base and a good number of prospects outside of Federated. How could we continue to pursue AdDept development for those companies—which was relatively certain to generate revenue and good will—while devoting a great deal of time and attention to the massive Federated project? It did not seem possible to me.
Gilbert had said that he had funding, but he never provided any details about who, how, or how much.
Something about the project sounded fishy to me. They were interested in my participation, but they never specified how. Did they want to buy TSI? No one mentioned anything like that. Did they want to hire some or all of us? Did they just want me to consult with them as to the system design? Or was there something else?
At the end of the meeting, Mike asked me what format TSI preferred for exchange of information. Both of the programmers were very surprised when I told them that our offices were connected to all of the clients’ AS/400s via phone lines. We used the AS/400’s built-in messaging and word processing. No one had ever asked us to communicate outside of that.4 I told them that TSI’s employees had PC’s, and the company had a few modems, but we mostly used the PC’s as terminals to the AS/400.
The group did not come to any agreement about how the project was to proceed. I had an impression that they thought that I (who was well into my fifth decade on the planet) was a fossil. I, on the other hand, thought that they, who had dealt almost exclusively with production of ads for newspapers, dramatically underestimated the difficulty of designing a single multi-user database that was capable of handling all aspects of scheduling and managing the financial aspects of all media. The planning and cost accounting modules were even more challenging.
After the meeting I had a little bit of private time with one of the principals of the software company. He asked me what I thought about the project. I told him that it was interesting, but I did not see the ROI (return on investment) for combining the two systems. I remember his exact words. “ROI. Oh, yeah, where’s the ROI?”
I did not hear from any of them again, and I did not press for inclusion in their project. In all honesty I had too many other things demanding my attention. After a year or two I sometimes wondered whether Gilbert had abandoned the project or had gone ahead with it. The answer, it turned out, was somewhere in between. I spent no time searching for information about the project, but little hints turned up occasionally.
Our liaison at Lord & Taylor, Tom Caputo, described to me his experience interviewing for a job in the advertising department at Bloomingdale’s, a Federated division in New York City. He asked the people there about their computer system. They showed him boxes that contained the software for the FedAd system, which Federated had sent them and told them to use. The people at Bloomies had never unsealed the boxes.
When I installed the AdDept system at Macy’s South5 in December of 2005, TSI’s liaison there was Amy Diehl. Her official title was “FedAd Coordinator.” By then I knew that FedAd was the culmination of the project begun by Gilbert Lorenzo more than a decade earlier.
I soon learned that the advertising department at Macy’s South was not actually using the FedAd system at all because the programmers had admitted that it could not handle the department’s planning process. Instead they had been using parts of a previous version called Assets for a few tasks. I was astounded to learn that the Assets system used a Microsoft Access database. They had sent a boy to do a man’s job! Federated Systems Group no longer supported it.
Later we heard that Macy’s East was using the FedAd system, which by then had been given a different name. At the time its advertising department was still using the Loan Room system that TSI had written and implemented for them in the early nineties. That meant that for years the details of every ad were being entered into at least two separate systems.
I even quoted a bizarre request from Macy’s systems people to write an interface between their system and AxN. I provided them with a quote, but nothing came of it.
In all of that time—more than two decades—I never heard anyone say anything good about FedAd. As far as I know it generated a great deal of expense and not a penny of revenue for the company. I only knew of one department that used it. TSI, in contrast, sold and installed thirty-five AdDept systems, each of which was customized to the needs of the individual departments.
On the other hand, I might have been able to carve out a career as the guru for Macy’s concerning administrative software for advertising. That would have certainly been something to crow about. After all, when the game was finally ended, Macy’s had all the marbles.
I doubt that they would have let me—and whatever portion of TSI was involved—participate from Enfield or East Windsor, and I doubt that they would have let us continue to perform or oversee work for their competitors. They might have allowed me to program for the AS/400—I saw several of them at the FSG data center in the Atlanta area. However, it was more likely the Gilbert would have required everyone in the process to use the same database. He seemed to be calling all the shots.
So, I probably would have had to sell my soul to Macy’s. I might have made a lot of money, but I think that I would have been miserable. Almost everyone in my acquaintance who had worked for one of our clients and then worked for Macy’s or a Federated division quit in the first few years and was openly bitter about the experience.
Finally, I must add that I suspect that there was a good possibility that the invitation to Huntsville was just a ruse to get me to expose the totality of the AdDept system to people who might be able to replicate it.
Epilogue: While researching the blog entry for TSI’s relationship with Federated Department Stores (posted here), I discovered that Val Walser’s LinkedIn page prominently features how she “directed development of a sophisticated, integrated software product” in the division run from Seattle. It must be referring to the system that Gilbert and Mike envisioned so many years earlier. I never heard anyone mention any other such system.
1. For some reason Gilbert Lorenzo has two LinkedIn pages. They are available here and here.
2. The Camex system was used by both of the first two AdDept users, Macy’s East, and the P.A. Bergner Co.
3. Mike Rafferty’s LinkedIn page is here. It did not provide much information about him when I discovered it in 2022.
4. Keep in mind that the Internet was in its infancy. At that time Microsoft had not yet completed its domination of the word processing and spreadsheet markets. Technical people used “message boards”, not email, for communication. AOL did not hit the web until 1997.
5. The installation at Macy’s South is described in detail here.
We installed at least part of the GrandAd system at all of the companies listed below. A few may have actually been Datamaster clients. My recollections of some installations are very dim. In a few I had little or no involvement
Although Keiler Advertising evidently had a famous red door in the twenty-first century, in the eighties the most famous red door in Hartford’s advertising community belonged to O’Neal & Prelle1 (O&P), the agency that was housed across the street from Bushnell Park in Hartford. Our negotiation was with Bill Ervin2, who was, I think, already the president of the agency.
We got this account because of a phone call from Paul Schrenker, the graduate student hired by our marketing company (described here). Paul called dozens of presidents of ad agencies. Bill responded that he was interested in our system. This was probably the only positive outcome from that endeavor.
I seem to remember that O&P bought a model 5364 from TSI. I do not remember doing any custom programming, but we almost always at least customized the invoices that they sent to clients.
I worked mostly with Liz Dickman, who was the bookkeeper. Of all of our agency liaisons, she was among the best to work with. She was able to do the reconciliations by herself more quickly than anyone else. I am not sure who drew the following beautiful schematic of the installation. It certainly is not my handiwork.
Here are my most vivid memories:
On one visit I had to carry something down to the basement. Halfway down the staircase I felt a stabbing pain in my right knee. It did not last, but it was the first time that I had felt pain there since I recovered from the operation in 1974, as described here.
If I was at O&P at lunch time, I generally bought a couple of tacos from one of the food trucks. I then sat alone on a bench in Bushnell Park and chowed down. One day while I sat with my legs crossed a starling popped up on my right shoe, which was about six inches off the ground. He perched there for at least a minute or two to see if I would reward him for his clever trick. When I failed to do so, he flew away.
I recall Liz informing me that she planned to take the CPA exam as a flyer. She said that she did not study for it, or at least not much. She was legitimately shocked when she later learned that she had passed. Perhaps it dawned on her that she was suddenly overqualified for her job. They made her a vice-president.
The installation really went downhill after Liz departed. The guy who operated the computer called TSI and asked for some training. We scheduled a day for him at our office in East Windsor. He was shocked when we billed O&P for it. Evidently either no one told him that TSI had a contract with O&P that clearly designated how much free training (plenty) they received, or someone gave him some bad advice. O&P didn’t pay the bill, and shortly thereafter the agency announced its liquidation.
I am pretty sure that we sold a model 5364 to Eric Tulin Inc.4 of Hartford, CT. It might have been TSI’s developmental system. I can remember spending a few days at the office on Hamilton St. The primary operator was a guy, but I don’t remember too much about him. I must have met with Eric as well, but I don’t remember the occasion.
The agency was not very large at the time. I don’t think that they had more than five or six employees.
I recall even less about Knorr Marketing5, which was (and still is) located in Traverse City, MI, which is in the northwest part of Michigan’s lower peninsula. The agency, which must have already purchased a S/36, called TSI one day out of the blue.
We sent them some materials, and even though they had never sen a demo, they purchased some portion of the GrandAd system. We sent Kate Behart to do the installation and training. Because we used almost exactly the same system for our record-keeping, Kate knew the accounting and job costing portions of the system. So, I assume that we did not install the media portion.
Kate must have done a good job. We hardly ever heard from them, but Knorr Marketing sent us a Christmas card for many years.
Another mystery GrandAd client for me was Brannigan-DeMarco of New York. They purchased their hardware from IBM. Sue took care of this account. I am not sure how much of the GrandAd system they used.
Sue worked closely with Angela Vaccaro, who was the primary operator of the system. She called for support every few months. Sue always took care of her problems.
Similarly, I know very little about Sullivan & Brownell6 of Randolph,VT. Sue handled everything about this account, too. She visited them occasionally. Sue did not need much of an excuse to schedule a trip to Vermont. She has always loved the whole state.
The only thing that I recall about the account was the fact that the media director was a Black woman. That would not ordinarily be even a little surprising, but this was, after all Vermont. In 1990 there were a grand total of 1,951 Black people in the state, including exactly zero lawyers and judges. In fact, only eleven Black people in total lived in Randolph.
Sue told me that the media director and her husband had a farm in the vicinity. Sue told me that she might have stayed overnight there once or twice.
Using a chain saw the husband carved a fox out of a tree trunk and gave it to Sue. It sat placidly on guard out in the grass just beyond the parking spaces of our office in Enfield for many years. In 2021 it wards off coyotes in our back yard. I took a photo of it. It has seen better days.
I handled most of TSI’s interactions with Knudsen-Moore (K-M), an advertising agency located in Stamford, CT. I thought of this as an important account because it finally gave us a toehold in the southeastern (wealthy) part of the state. I also thought that it was cool that one of our clients did business with both King Oscar and the WWE (then known as the WWF).
The audience for my demo was the seventy-two year-old7 bookkeeper whose name was Irene. I must have brought a PC, our 5364, and a terminal that we were evaluating for another client. Its screen was very large for the time. This became important because the bookkeeper had very bad vision. In fact, she later confided to me that the reason that she insisted that they choose TSI’s system was because of that terminal. Ordinarily my strikingly good looks are the deciding factor, but as I mentioned, her vision was poor.
It took us several months, for reasons that will soon be apparent, to get them up and running. During this period the agency changed hands not once, but twice. Its final name, which persists to May of 2021 was CDHM8.
The holdups for going live with the system were the balances in accounts payable and accounts receivable. The values in these accounts are generally positive for A/R and negative for A/P. If a vendor bills you $100, and you immediately bill the client with a 10 percent markup, A/P will have a transaction with a value of -100, and the entry in A/R will be +110. There will also be offsetting entries, of course. The point is that every company should be able to justify its A/P with a stack of unpaid bills from vendors and its A/R with a stack of open invoices sent to clients.
I entered in all of the open A/P and A/R into GrandAd. I printed a list of each with totals. The system’s totals did not agree with what Irene’s hand-written worksheets said were the current balances. Not only that; her balances, which were reflected in the company’s official general ledger, had the wrong sign! The A/P showed a positive balance, and the A/R showed a negative balance. According to these figures the agency’s vendors owed them money, and they were in debt to their clients!
Irene still insisted that her figures were right. I asked for a meeting with the president, Bill Hoag. The bookkeeper attended, as did a couple of other people. Their accountant was not present. I explained the situation with words similar to those of the previous paragraph. She insisted that her numbers were correct because she had checked every entry. She knew this because there was a little dot next to each figure. Much screaming ensued.
The lady had been using the “balance forward” method. After each transaction a new balance is calculated. This is OK, but at least monthly this balance must be checked against the list of invoices. She had NEVER done this. I later looked over her sheets. They were replete with errors. She simply could not read her own handwriting.
The irony of the situation did not strike me until much later. If someone had caught this egregious error earlier, we would not have won the contract. She recommended us solely because of the big screen on the terminal, remember?
How in the world could an agency with books in this deplorable condition be sold twice? I don’t know.
They asked the bookkeeper to retire. The guy that replaced her was, in some ways, worse.
I am pretty sure that his first name was George. I don’t remember his last name, but I do remember that he insisted that any communication to him include the title “Esq.” Now, I don’t pretend to know who gets to use that title, but I would be willing to bet that not many of them lived at the YMCA, which is where this character lived. George got into arguments with us all the time, and he was abusive to TSI’s employees.
For the first and only time, I finally called the agency’s president about George’s behavior. He said that he would look into it. He called me back less than hour later. He said that the guy had not been in all week, and he was now officially terminated.
The next week the president told me that they had hired a new person. I think that his name was Roger. He was very easy to work with, and he had the record-keeping straightened out in short order.
I drove to CHM an least half a dozen times. I never saw Vince or any other McMahon. It was a big disappointment.
Sue handled the account of Charmer Industries of the Astoria section of Queens. The company distributed wine and liquor products. This was probably a referral from Quique Rodriguez, an IBM rep with whom we had a good relationship.
Sue and I drove there on, as I remember it, a Sunday, carried their computer and printer into the building, and made sure that they were working. Then we drove back to Rockville. I found the whole drive within the city terrifying. I wanted to stop, get out of the car, and kiss the earth when we were back in Connecticut. I have been to NYC many times, but I have never driven inside the city limits.
Charmer had a lot of companies. One specialized in the design of point-of-sale products in bars and liquor stores. Over the years it went by a number of names, including ACC Marketing and the Sukon Group. These were the people who used our system.
Our final liaison in the nineties was Ed Wolfe. As I recall, the company later decided to purchase a small AS/400, the system that replaced the S/36. The AS/400 is described in some detail here. I took the train to New York a couple of times to help with the setup of the new system. Ed was a nice guy and a good client.
I have always thought of Doherty-Tzoumas of Springfield, MA, as a bizarre advertising agency. Dianne Doherty9 was the president. She was totally unsuited to running this agency or any other business. Her husband was a very prominent lawyer. I think that he must have set her up in this business, perhaps for tax reasons. I can only speculate.
Her partner, Marsha Tzoumas10, knew her way around advertising and the business world at least a little, and she was very nice. I felt a little sorry for her.
The agency certainly tried hard to succeed. It always seemed to be a beehive of activity. Quite a few employees had been hired. They liked to hold “focus groups”11 for their clients’ products or services, an idea that I had never previously encountered.
I worked with Marsha and the agency’s bookkeeper to set up the system, and for the most part it seemed to go rather smoothly. However, when we showed the reports for the first monthly closing to Dianne she was overwhelmed.
Dianne hired a financial consultant to help her run the business. He might have been the company’s accountant, but that is not my recollection. I was in a few meetings with him. Most of them were fine, but in one meeting we were discussing the general ledger. Dianne made a very peculiar request. She asked if there were just two or three accounts that she should concentrate on. The request was, in my opinion, absurd. There might be a few that she could pretty much ignore, but to try to focus on any small subset of a company’s books was unthinkable. Most small businesses fail, and there are many paths to failure.
Nevertheless, the consultant took the bait and named a few accounts. I can’t even remember which ones he chose. I assume that cash was one. It is generally a good idea to know how much cash you have. He probably also picked A/P and A/R.
At any rate I knew in that instant that this business was doomed. I was right. In 1991 we received a letter from Dianne’s husband Paul proclaiming that the business was being liquidated. It was the only such letter that we ever received from an ad agency. They owed us less than $100, and so we did not consider suing for it.
I remember that on one occasion Marsha mentioned that she was looking for a good book to read. I recommended Larry McMurtry’s Lonesome Dove. I wonder if she took my advice.
In 1987 Rossin Greenberg Seronick and Hill (RGS&H)12 was the hottest agency in Boston, MA. The president, Neal Hill13, was not an advertising guy. Although I never met any of the other three partners, I am sure that they all had a good deal of advertising experience.
The agency had enjoyed two years of explosive growth. It wanted a computerized system for word and data processing. Neal and Ernie Capobianco14, the director of finance, interviewed us and all of our principal competitors. Their choice of the GrandAd system was a real feather in our cap. We were confident that we could do a great job for them, and we hoped that it would open the Boston market, which we had previously never been able to crack, for us.
The holdup was the word processing element. Neal loved Wang’s approach to word processing, and he thought that DisplayWrite/36 (DW/36) was inferior. However, no ad agency software had ever been written for Wang’s operating system. In fact, I had never encountered anyone who used it for anything other WP.
When Neal told us that they had decided to use our system, he asked what we would recommend for word processing. I said that I was not an expert, but the future was in PC’s. Furthermore, if they planned to use the S/36 only for GrandAd, a 5362, which could support up to twenty-eight locally attached devices, would be more than sufficient.
My assessment turned out to be correct, but in 1987 buying PC’s with good word processing software (the most popular at the time was WordPerfect) and connecting them would have been a formidable task. Personal computers in those days were still really personal.
Neal insisted that one system should address all the needs. IBM persuaded Neal that a model 5360 with DW/36 would serve their needs.
In the meantime I received a phone call from a salesman at Wang. He wanted us to convert our software to run on Wang’s equipment. I informed him that this would be a monumental task, and, although we had dozens of successful installations on IBM hardware, we had absolutely no experience with Wang’s approach. He told me that if we agreed to convert, he had an agency lined up that would use our system. I asked him if he was referring to RGS&H. When he confirmed it, I told him that they had already signed a contract with us. This was news to him.
The system that IBM proposed included terminals for almost all of the employees. The ones with PC’s got 5250 emulation adapters. Our end of the installation went fine. We did a great deal of custom coding for them. They had spent a lot of money on the system, and they reasonably insisted that it do exactly what they wanted.
Then the bombshell exploded. Microsoft let the world know that Neal Hill had written a letter to them. In it he bragged that RGS&H had poached the copywriter and artist from the agency that had handled advertising for Lotus Development, which at that time was considered Microsoft’s biggest competitor. Microsoft had not yet assembled its Office package, and Lotus 123 and Approach were very popular applications. Neal said that RGS&H knew what Lotus was up to, or words to that effect. He also sent them two plane tickets from Seattle to Boston.
I could sympathize. Evidently no one checked Neal Hill’s work either.
This episode caused a major scandal that has been widely written about in legal, advertising, and business circles as well as in the local press. In fact, if you google the agency’s name you will get several pages of articles about it. There are so many that is very difficult to find any other information about the agency.
Neal resigned in December of 1987. Ernie was named as the interim president. Our system was fully functional by this time. Ivan Dunmire served as our liaison. He did an excellent job.
TSI indirectly got swept up in this brouhaha. The articles in the local press mentioned that RGS&H had recently purchased a computer system that was characterized either as a mainframe or as a system that was much too large for the company. So, despite the fact that the people who actually used our software appreciated greatly what we had done, we never had the good reference account in Boston that we had hoped for.
Here are some of my recollections of my experiences with RGS&H:
When I was driving Ernie to lunch one day he complained that my car smelled like tobacco smoke. It must have been Sue’s. Nobody previously had mentioned it. Evidently I was “nose blind” to it.
One of the two contenders for the most harrowing experience of my life (the other, getting caught in the Blizzard of ’77, is described here) occurred when driving back to Rockville. It was snowing lightly, and the traffic was moving at a fairly steady pace on the Mass Pike when I reached Exit #9 for I-84 near Sturbridge. To my surprise I-84 was nearly empty. There were no tracks in the road at all. I could clearly see the reflective markers on both sides of the road, and I used them for navigation. There really was no place to stop between Sturbridge and Rockville. The Celica and I passed no one, and we were only passed by one car traveling at perhaps 30 mph. A mile or so later I saw a car that had slid into the median; I assume that it was the one that had passed me. I did not consider stopping. When I finally reached the exit for Rockville, I had to guess where it was; the asphalt was covered with several inches of snow and there were no tire tracks. I did not think that my car would make it up the steep hills in Rockville, but it did. Sue was very worried; there were no cellphones in those days.
After we moved the office to Enfield in 1988, I usually drove to Springfield, took a Peter Pan bus to Boston, and walked a few blocks to the RGS’s offices. By that time “&H” had been dropped from the agency’s name.
I loved working with Ernie, Ivan, and the other people at the agency. There were no quarrels or misunderstandings.
I remember that I usually walked to McDonald’s for lunch and ate a Quarter-Pounder with Cheese and a Big Mac.
In the nineties Ivan called us a few times for support. By that time PC networks were becoming widespread, and people were touting the idea of “client-server” systems, a term that simply meant that the data was on one system used by everyone, but each person’s computer had its own set of programs. However, Ivan said that many of the people at the agency did not understand this. They thought that the term designated a system constructed to provide better service to the agency’s clients, and they wanted to know why RGS did not have one.
I tried to recruit Ivan to work for TSI, but he turned us down. I am not exactly sure what role he would have played at TSI, but I am pretty sure that he would have done a good job.
Our other installation in Boston, Rizzo Simons Cohn (RSC), was an even bigger fiasco. I was surprised to discover that Sue has almost completely repressed the memory of The Sign of the Three.
We had been contacted by a firm called Computer Detectives (CD). The guy on the phone told us that his company had been hired by the agency to find a computer system for them. It turned out that CD was a two-person company, the guy with whom we talked and his wife. His name was Larry Ponemon16. I don’t recall hers. We dealt almost exclusively with Larry.
Sue and I went to supper at a Chinese restaurant with them. The both ordered moo shu pork; this is the only thing that Sue remembered about them. They were very surprised when we told them that we had never really had a vacation.
We showed them the system, and they liked what they saw. We gave them a proposal for the GrandAd system running on a S/36 model 5363.
Larry called us to tell us that they had recommended our system to RSC, but the agency preferred to run its system on 3B2, a UNIX computer manufactured by AT&T. They asked us if we could convert our system to run on it.
We researched whether the S/36 version of Workstation Basic17 would work on a 3B2, and we were assured by the company that wrote and marketed it that it would. We told CD that we were pretty sure that it would, but we would need to adjust our quote to cover the conversion costs. We did so.
We then got to meet another consultant, who, among other things, sold and marketed AT&T computers. We told him that we were accustomed to working with IBM, and we trusted its commitment to support. If he sold the system to RSC, we wanted to know whom we would contact when we had problems or questions. He said that he was our contact. Remember that there were no cellphones, and this guy practically lived in his car. We would need to leave messages. The best that we could hope for was a beeper. Then we would need to depend on him to find someone who was willing and able help us. We were used to dialing 1-800-IBMSERV from anywhere. Someone ALWAYS answered.
The CD people were there at the meeting. They and the AT&T guy assured us that we and the agency’s users would get all the support that we needed.
We converted the software to work on Unix without an inordinate amount of difficulty. That, however, did not mean that it would efficiently do everything that RSC wanted in their environment. We knew nothing about how the operating system would perform when numerous users were working on the same files at the same time. Sue spent several days at RSC trying to get the system to work, but she ran into one roadblock after another, and no one was available to help her.
After a few weeks of this foolishness, the agency got fed up. CD had not disclosed to RSC, who had paid them handsomely to conduct the search, that they were being paid a “finder’s fee” both by us and by the AT&T guy. RSC had never voiced any preference for hardware; that was just a lie. Evidently they had told RSC quite a few whoppers, too. RSC sued CD, and Sue testified for the agency. AT&T took the hardware back and refunded at least part of the cost.
RSC reopened the software search. We submitted the same proposal that we had previously given to CD. Since we had already been paid for the UNIX version, we charged nothing for the GrandAd software or for the customizations. The other contender was a New York company (I can’t remember the name) against whom we often competed. Its software ran on UNIX.
I called the finance guy at RSC, Jonathan Ezrin18, and asked about their decision. He informed me that they had chosen the other vendor. I asked him what the basis for the decision was. He responded that mostly it was the cost. The answer astounded me. I asked him what the other software company had bid. It was about $10,000 higher than ours. I asked him how they could have considered this less than our bid. He said that to be fair they had included the cost of the software in our original proposal when making the comparison.
I assured him that we were not going to give that money back. I then told him frankly that theirs was the stupidest line of reasoning that I had ever heard, and I slammed down the phone.
RSC dissolved in 1990, less than a year after that phone call. I don’t know what happened to CD. I found no trace of them on the Internet, although Lavinia Harris has published a series of novels about a young couple who call themselves “computer detectives”.
I remember visiting Fern/Hanaway19 of Providence, RI, a few times. The agency had a System/36 that they had bought from IBM. I think that we installed one or two modules there, but I don’t remember which ones.
IBM must have told Arian & Lowe (A&L)20, an advertising agency of sorts in Chicago, IL, about TSI. Sue said that she went there once. She remembers that the floor of their office would have been good for dancing, but the only thing that she remembered about the company was that their main client was the Beef Board. They mostly produced point-of-sale posters and signage.
I installed some modules of the GrandAd system there and flew out for a couple of month ends. I remember several very strange occurrences.
The Director of Financial Operations for the agency was Neta Magnusson21. We generally had lunch together. She always had more than one martini. I could never have concentrated in the afternoon if I had imbibed a small fraction of what she downed. I stuck with Diet Coke or iced tea.
A&L used its S/36 model 5360 for word processing. One time when I was there working on the GrandAd system, they somehow lost some WP documents. A few people blamed me for this. I protested that I had not done anything to any documents. Fortunately I knew enough about how DW/36 worked that I could also demonstrate that I could not possibly have done anything.
I ordinarily stayed at a Holiday Inn that was a short distance from A&L. On one trip I had to stay an extra day. The Holiday Inn had no availability for that extra night, but they found me a place to stay and called a cab to take me there. The cab driver said that I definitely would not want to stay there. Instead, he took me to another place that was in a rather rough part of town. However, the room was OK, and it was only one night. I was, however, happy to be out of there the next morning.
The agency’s was in downtown Chicago. I had to take cabs back and forth to O’Hare. One time I somehow left my glasses in the cab. Believe it or not, the next time that I went to A&L I stopped at the taxi dispatcher. My glasses were in the Lost and Found box safe and sound.
One of the cab drivers spoke no English at all. His girlfriend sat in the front seat and translated for him.
Another cab driver picked me up at A&L. I wanted to go to O’Hare. He asked me for directions. I actually rode with a cab driver in Chicago who did not know how to get to the airport! Fortunately, this was one of my last trips to A&L; I could have given him instructions blindfolded.
The favorite expression of the system operator at A&L was “Have a good one!” I realized that this was cheerful and completely innocuous, but for some reason it really irritated me.
My favorite part of the trips to Chicago was the prospect of having an Italian beef sandwich, either at the airport or bought from a street vendor.
It seems appropriate to end with the bittersweet tale of Charnas Associates of Manchester, CT. TSI and IBM scheduled a presentation to the agency at the IBM office in Hartford. The presentation was scheduled to take two hours. I went to the office early and loaded our GrandAd demo system onto the 5360 at IBM. I also went over my notes for the presentation.
The turnout was unbelievable. Around twenty people showed up from the agency. I was always happy if we got one; I had done worse than that.
I had a lot of experience at this. The format varied by only a little. Someone from IBM acted as the host. He or she was always dressed impeccably and spoke glowingly about how wonderful IBM’s systems and support were and what a close working relationship IBM had with independent software developers like TSI. Then they turned it over to me.
Not this time. The IBMer went around to each and every person in the room and asked them what they would like the computer to do to help with their jobs. After each answer he would rush back to a whiteboard and add it to the list of items that were already on the board. The he would ask them to evaluate how important this was to them. He was hoping that they would attach a monetary value to it, but he was willing to settle for peace of mind or saving time. He dutifully recorded the values as well.
This went on for at least an hour and forty-five minutes. Then he spent a few minutes praising the System/36 before he let me talk for a couple of minutes. I could not possibly do my presentation in less than a half hour. So, I had to forget about my slides and my demo and try to talk about the big picture. The worst part was that damnable list on the whiteboard behind me. Needless to say, our software addressed less than half of the wish list. Of course no one suggested “Help us find which clients are unprofitable and why” or “Help us improve cash flow”.
I was so angry at the IBMer that I could have punched him. If I had not sworn after that fight in the fifth grade with Tom Guilfoyle that I would not engage in fisticuffs, I might have.
We followed up on this, but we never heard from Charnas.
A few years later in 1989 I was scheduled to give my first AS/400 demonstration of the AdDept system that I was still in the process of installing at Macy’s in New York. TSI did not own an AS/400 yet, and so I had made a backup tape at Macy’s. I planned to install Macy’s programs and data, dummy up the data so it was not recognizable, give the demo, and then erase the programs from the disk.
I never finished the first step. Something about the tape made the AS/400 system at IBM hang up. Commands could not even be entered at the system console. I worked with these incredibly reliable machines for twenty-six years. This was the only time that I saw something like this happen.
The IBM people were furious at me. They were certain that the problem occurred because our programs were written in BASIC. I calmly explained that the programs never got restored. Something happened during the restoring process.
Nobody from IBM attended my demo. I went to the demo room to do a song and dance with no accompaniment. Only one person was there, and she was not even one of our invitees. She identified herself as a media buyer at Charnas who had heard about the event from one of her clients. I explained how the GrandAd system worked and which agencies were using it.
She told me that Charnas had a S/36. She did not know the model. I asked her how big it was. “Oh, it’s big!”
She said that they used it only for word processing, and everyone hated it. That guy from the first demo had sold them a 5360 with no software except DisplayWrite36!
I don’t remember what happened after that too clearly. I am sure that I went to Charnas’s office in Manchester at least a few times in the early nineties. I think that I installed an abbreviated media system for them. Then I got heavily involved in the AdDept system.
Charnas apparently went out of business in July of 1992.
While I was looking for information about the agency I came across the book shown at the right. It was commissioned by Robert Bletchman, an attorney from Avon who died in 2008. His obituary is here.
There is only one copy of the book on this website. The title is How to Achieve the Release of Unidentified Flying Object Information from the United States Government.The first reader with $50 can claim it. Shipping is free!
The publication date for this book is in 1985. I am pretty sure that this effort antedated Art Bell’s Coast to Coast AM show on WTIC radio by approximately ten years.
1. O’Neal & Prelle went out of business in 2000.
2. Bill Ervin died suddenly in 2003. His obituary is here.
3. Liz Dickman is now the CEO of Integrated Physicians Management Services in East Hartford. Her LinkedIn page is here.
4. Eric Tulin Inc. changed names and ownership a few times before giving up the ghost in 1991.
6. In 2007, as reported here, Tom Brownell apparently transferred his client list to a group of his employees. They changed the name of the agency to 802 Creative Partners and moved the headquarters to Bethel, VT.
7. By coincidence 72 is my own age as I write this in May 2021. To be honest, if I tried to keep a manual ledger, I probably would not be able to read my handwriting either.
9. Dianne Doherty now goes by Dianne Fuller Doherty. She resides in Longmeadow, MA, in 2021. After the agency’s failure she devoted her life to helping other small businesses, especially those run by women, get started. Her story is described here.
10. Marsha Tzoumas is now known as Marsha Montori. In 2021 she is the Chief Marketing Officer at Six-Point Creative Works, an ad agency in Springfield. Her LinkedIn page is here.
11. I used focus groups in my short story (described here).
12. RGS&H went through five name change. Its final incarnation, GSOD, Inc. dissolved in 2007.
13. Neal Hill landed in Canada. His LinkedIn page is here.
14. Ernie Capobianco telephoned me in the early 1990’s. At the time he had just started working at Valentine-Radford, a big ad agency in Kansas City. He arranged for me to meet with some principals and the IT guy. I also visited Ernie’s apartment in Johnson County. I think that I caught him at a bad time. His LinkedIn page, which skips over his time at RGS&H, is here.
15. Ivan Dunmire lives in New York City. His LinkedIn page is here.
16. I think that Larry Ponemon now runs the Ponemon Institute, which has something to do with privacy, security, and computers. His page on the organization’s website is here.
17. Workstation Basic was designed to emulate the Datamaster version of BASIC running under DOS and later UNIX. More information is here.
18. Jonathan Ezrin apparently now lives in Plymouth, MA. He does not have a LinkedIn page.
19. Fern/Hanaway was dissolved in 1998.
20. It appears that in 1991 A&L was taken over by Daryl Travis. Various versions of Arian, Lowe and Travis (no Oxford comma) existed after that, but I think that the operation in Chicago did not survive for long. The Beef Board account represented a high percentage of its billings.
21. I think that in 2021 Neta Magnusson lives in Geneva, IL, a suburb on the west side of Chicago.