GL Computing’s Mike Lazarus has become the first Certified ACT! Genius at Experts-Exchange
Click image to see EE Profile or here to see PDF Certificate
Mike Lazarus, ACT! Evangelist of GL Computing - posting thoughts on ACT!, Sage, CRM and general IT
Also see:
GL Computing Web Site
Other Links About Mike Lazarus
LinkedIN ACT! Fanatics Group
GL Computing’s Mike Lazarus has become the first Certified ACT! Genius at Experts-Exchange
Click image to see EE Profile or here to see PDF Certificate
This is the official information from Sage. I will soon post an article on my opinions of the new version.
Update: Sage have release a day-0 Hotfix 1 … Any installs from now will get this update slipstreamed and there will be a download soon for the early birds. As soon as I find out what this fixes, I’ll let you know.
The Sage ACT! 2012 release is focused on a number of significant enhancements including Google® Integration, Scratchpad, Connected Services, Universal Search and much more. All this enables you to work and communicate more effectively, become more productive and efficient, and better serve your contacts. Click on one of the links below for more information on the specified topic.
Those who know me know that I love and support ACT!, but there are some issues with Sage that I believe need work.
There has been a discussion going on in the LinkedIN ACT! Fanatics Group for some time on how to find ACT! Consultants in international regions. The discussion can be seen here: Finding ACCs around the world...
There has been some good comments from Consultants, users and Sage staff. This has helped me to a few thoughts on what the problems are and I thought I would describe them here.
The first problem is regionalisation (at least the way Sage do it). This causes issues in the product design AND in the support of users and channel. While this does work in the ERP world, that Sage comes from and where every country/region needs different handling, it actually harms the proper selling and supporting of CRM.
ERP users (even in small multi-nationals) don't usually spread usage of their accounting system across country boarders. However, CRM users regularly do and even those based in one country will travel and want access to their data. There are many areas of the product that are designed with North American defaults that don't work as well for others – multi-currency, scheduling for different time zones, phone formatting and country codes to name a few.
From the support point of view (especially the channel support), this is left to the individual Regional Operating Companies ... and they simply don't have the resources or budget to provide this for Sage ACT! at the same level as North America. It is this area that has caused some regions (eg Asia) to drop ACT! altogether.
I offered to help Sage with training and support ACT! resellers in Asia, but was told they weren’t interested.
Sage has a corporate marketing team that directs all the OpCos about the logos, colours, etc ... they need to implement a similar method to ensure that ACT! (and probably other CRM solutions) have a similar global uniformity in dealing with their partners and users.
The second problem that is endemic across Sage is that those given responsibility for an area or project rarely (if ever) also have the necessary authority to make changes... and those with the authority rarely understand the product.
Over the past years, I have spoken to many staff who agree with many of these issues… but the regional staff tell me it’s corporate and those with global responsibilities tell me that decisions are made by the regions.
The third issue is the lack of public communication on ACT!'s road-map from management since David van Toor left. I highlighted this in this post: Better handling of rapidly updating environment (yet to get a response from Sage). If you haven't added a Kudo to that post, please do.
You'll see that I'm not the only one who sees some of these issues ... read this ZDNet article:
ZDNet - Sage Summit 2011: CRM at a Crossroads
This is a mostly positive article, but his conclusion that says corporate needs to "rejigger its thinking" in how they handle their CRM products is spot on.
Should anyone at Sage Group Inc. or the ACT! team wish to discuss any of these points, I’d be more than happy to talk and help to come up with a way to address them. Like you, my aim is to provide the best experience for users and partners with their investment in Sage ACT!
This documentation applies to Hot Fix 4 for Sage ACT! 2011 SP1 for the following versions:
| This hot fix requires that Sage ACT! 2011 Service Pack 1 (SP1) be installed. If you have not yet installed SP1, please do so before applying this hot fix. Instructions for downloading and installing SP1 are in the following Knowledgebase article: How To Download and Apply Sage ACT! 2011 Service Pack 1 (includes Hot Fix 1) Do not apply this hot fix to any other versions or builds of the software. To determine the version of the product you are using, select Help, then About ACT! from the ACT! main menu. |
Important: You must apply this hot fix to all machines that share the database – especially when using synchronization. This includes all machines that contain the Main Synchronization Database (Publisher), Main Remote Database (Subscriber), and machines that have the ACT! Network or ACT! Internet Sync Services installed. All machines must have this hotfix applied for synchronization to continue. Check installed version by going to Help and About Act!. Consult with your administrator before applying this in a sync environment.
Sage ACT! 2011 hot fixes are cumulative, so the latest hot fix will include the benefits of all earlier hot fixes for this version. It is not required to install earlier hot fixes prior to installing the latest hot fix.
Hot Fix 4 for Sage ACT! 2011 SP1 is designed to resolve the following issues:
Downloading the Hotfix:
Sage ACT! 2011 SP1 Hot Fix 4 (English)
Sage ACT! 2011 SP1 Hot Fix 4 (French)
More detailed information available from ACT! Knowledgebase KB27440
Regional road trips. No doubt you’ve, “been there, done that before” and experienced what a nightmare it can be to get any internet coverage. No matter what the reasons for our travels out of town may be, one thing is certain: We still need our connection to the big, busy world via our trusty iPhones or Blackberries – or in my case, both!
A short time ago, I had the pleasure of attending a friend’s birthday party on the Gold Coast of Queensland and spent 10 days there to catch up with some old friends.
I was based in Ormeau. For those who don’t know where this is, it is about 1 hour’s drive south of Brisbane (Australia’s third largest city) and is in Australian’s largest growing region.
I had a great time catching up with friends in Brisbane, Gold Coast and Sunshine Coast (North of Brisbane).
And of course, being me, I needed to have constant and regular access to my ACT! contacts, to email, and to various other office and on-line services and forums.
I was carrying an iPhone4 and a Blackberry Pearl (both with Handheld Contact) to give me the remote access I needed and hoped to find Wi-Fi connections where convenient to sync and to access my other information.
Now don’t get me wrong. Like most people, I love getting out of town and escaping the hustle and bustle, but coming from Sydney, I’m used to the comforts of being connected at anytime of the day or night. I’m used to having a 30Mbit connection and 3G/4G network coverage. That’s not the reality though for my regional friends as I discovered while on my road trip. Here’s what I discovered on my travels:
As frustrating as it was for me venturing out into this regional area...
...These frustrations are also being experienced in metropolitan areas of Australia!
There is “business park” in Brisbane itself (Australia’s third-largest capital city), that has virtually no broadband access at all …
Read that again if you need to, because the mind boggles. Even in a city like Brisbane, a business park doesn’t necessarily have broadband internet access. You can check out: Brisbane's NBN 'will transform people's lives' to get the lowdown on that story
Well, much in CRM is about mobility… and recently a lot of the press have jumped on the “trendy” technologies of cloud based computing – both for phone/tablet access and for general access.
For those of us who have been in the computing industry for long enough, we remember that the PC was originally viewed (by IBM) as little more than a slightly more intelligent “dumb terminal” to main-frame applications. Later, as the power of PCs increased, more of the data was stored locally and out of IT control. This lead to a gradual pull-back of control via networking, and then via various remote solutions.
To be honest, I’m not sure how to really define the differences of those … other than that they are buzz-words from different decades.
They are usually accessed via one or more of these methods:
I wrote an article a year ago on “Supporting Remote Users with ACT! by Sage”. In selecting the best method for a specific site, there are two questions you need to ask:
While SaaS/cloud offering will be suitable for many users, there are some questions that you need to ask to determine if it’s the best solution for you.
I feel certain that SaaS offerings will become more viable as time goes by, but right now I’m reminded of the line that for those on the bleeding edge of technology, that “a pioneer is frequently the guy with an arrow in his back!”
Re-posted, with permission from Ben Hamilton
This is a set of common issues we have seen when installing SQL 2008 (which is part of Sage ACT! 2011), especially when upgrading a previous version that used SQL 2005
The support staff in Sage Business Solutions Melbourne (bless ‘em) gave me a pointer that if “Microsoft .NET Framework 4 Client Profile” is installed it gives troubles. Therefore they suggested uninstalling it prior to commending an SQL 2008 install. I don’t know why or what but this was an important step. Note that just doing this still gave me a failed SQL install. I’d love to know more about the ‘why’ here. I’d also like to have been informed earlier instead of after me jumping up and down and making phone calls. But that’s a topic for another day. For now I’m very happy with their suggestion as it does appear to have contributed to a successful install, which is GOAL NUMBER ONE.
During the install you get the option to set which account the SQL Server Database Engine uses, instead of setting to NT AUTHORITY\SYSTEM as per Sage KB26994, leave it as the default. After the installation is complete you then go to services.msc and change it to Local System then.
As per Microsoft KB955666 you can’t use a ‘number’ or ‘pound’ (#) sign in the path name. Now I did NOT have a pound sign in the path, but there was a space in one of the folder names and a ‘plus’ sign (+). So taking to heart Microsoft's admonition, I copied the installer to a folder C:\SQL2008ExpR2\*.* and ran it from there.
Hope this helps someone short cut the time to resolve their SQL install.
Please add Comments with any other issues and resolutions you might find when installing SQL 2008 (especially when upgrading from SQL 2005)
Part 4 of The Seven Day Blogging Challenge - Share a photo I took this week and tell you about it.
I have thought about today’s Challenge post for a while and, with this blog being about ACT!, there was not much I could think of to take a picture that would be relevant.
So I’ve taken a screen shot of a menu that describes how proper use of ACT! will benefit you:
If you can’t find these functions in your copy of ACT!, I suggest you speak to your ACT! Certified Consultant. These are the people who do more that the break-fix support you might get from a vendor support contact.
A good ACC will take the time to understand your business and the workflow of your operations. They will then assist you in designing ACT! in the best possible way to achieve your goals using functions within the product or some of the many powerful add-ons that extend it’s use.
The ACC can then assist with planning and implementing your installation roll-out including importing your data, connecting to other systems and training your users and administrators to properly get the maximum benefit from the product.
An investment in a good Certified Consultant will generate a Return many times in better managing your contacts
When looking at the ACT! Certified Consultant list, you may find many in your area. So here is an article on how you should go about picking the right one for you: How to pick the right CRM consultant
Should you have any questions on this, please let me know by posting the comments here.
Part 3 of The Seven Day Blogging Challenge - Write a blog post on the same topic as one my most popular posts
Well, the most popular posts previously have been:
So I thought I would do another on mobile CRM with Sage ACT!.
I have always supported ACT! as a mobile product … both with sync to laptops and remote offices and with sync to PDAs and smartphones. Over the years, I have purchased new devices along this path to use, test and support other users:
I believe in the benefits of being able to access and enter my ACT! data wherever I am and understand the problems that mobile users have.
Since 2003, I have been using Handheld Contact. But I have still tested other products to be satisfied that no other product is better for me to switch to.
Despite ACT! for Palm being the best PDA/smartphone solution for ACT!, the ACT! developers have concentrated on products linking to the native address books and losing much of the functionality that real ACT! users should want. Without this, they may as well be using Outlook for their CRM.
They have had “ACT! Mobile Live” in beta and release for around three years and recently renamed it as “Sage Mobile for ACT!”. It still has many of the bugs and issues I reported in the first beta.
So I thought I’d let you know why I really don’t think users should consider it for their use.
There are a number of other bugs and functional omissions but as the challenge (as mentioned top of this post) is for a limited number of words, I’ll do a longer post on this later.
Considering Handheld Contact is only $50 more, I think the choice is a no-brainer
Part 2 of The Seven Day Blogging Challenge - Answer one question I think people visiting my blog may have.
Recently I have been trying to explain to users in a couple of forums why the feature they want might not be likely to make it into the product. For a couple of examples of this, see:
So I thought I might try and explain simply how I see the product management decision process. However, please note that I’m not actually privy to the process used by Sage (or any other company other than my own) and am only going by the experiences of what I’ve seen and heard.
Update: Members of the Sage team have confirmed that “this is directionally close” to the process as used
First, all the requests are split into two areas:
For each of these, a priority must be allocated. The priority would depend on a number of factors:
Then, for each, a time-frame and cost must be determined. For this, a specification document must be created with much thought being given to looking at all the possible scenarios, data types and values that are considered likely. This is done by consulting users and developers for their input.
Finally they can decide which to approve now, delay for a future version or discard. Obviously, the higher the priority, the higher the allowable cost would be for it to be approved.
So, in order to have the best chance of getting your requests addressed, you should try and put it in terms to answer as many of the points mentioned.
I would write more, but the challenge limits us to 400 words….
Twitter contact, Andrew Emmett, is doing a Seven Day Blogging Challenge. He challenged other bloggers to join him and I have decided to accept.
Here are the 7 topics that Andrew has challenged us to write about.
Starting Saturday I will write one blog post a day, each with 300 to 400 words about:
- What the purpose of my website is, who I am and why my blog is unique.
- Answer one question I think people visiting my blog may have.
- Write a blog post on the same topic as one my most popular posts.
- Share a photo I took this week and tell you about it.
- Embed a legal YouTube clip that I either found today or created myself. Then tell everyone about the clip and related information.
- Create a blog post on a subject I’ve never blogged about here before.
- Share hints or details of what I intend to write about in the future.
This experiment promises to be an interesting diversion for the norm and I do hope I can think of some useful and interesting items for you on each of these topics.
One of the opportunities this challenge presents to me is the requirement to write a piece every day and to make it a specific length. As those who read this blog would know, my posts tend to be of a technical nature and I haven’t thought about the length of each article or have a set time that I must post. I write when I think of something deserving of a post and as long as I need to properly explain each topic. I also tend to use the articles as a permanent knowledge base on items I get asked rather than the typical “web log” style of most blogs.
The general aim of this site is to help ACT! users, resellers and consultants get the most from the product. Unlike other ACT! related blogs, I have tried not to simply create content of a marketing or promotional nature. I love ACT! and have have dedicated the past 23 years to the product – but I also experience many of the frustrations that users feel when certain functions don’t operate as well as they should or where the Product Management and development teams have missed the mark and I try to warn users of these also. Hopefully, this “warts and all” approach helps us all use ACT! better and encourages Sage to continue to improve it.
Now that I’ve completed Part 1, I need to think of a question you might have for Part 2.
Any suggestions you might add to the comments area would be most welcome.
I'm sure this must be a question concerning every ACT! consultant/reseller ... but, which a number of them have asked my opinion on this, I've not seen any public discussion on it. I'd also be interested in the views of end-users as to what they believe would be fair.
The last time I was shown the figures, around 80% of install support incidents by Sage North America were not due to ACT! code, but were related to Microsoft issues - in the operating system, .Net Framework, SQL Server or Office. Note: If someone at Sage has a more current figure, please let me know
I’m not sure how long ago this happened, but I recently noticed that Sage Australia (and I assume similar in other regions) excludes many areas that fail from their install warranty. While the box says that install issues are covered under a 30-day warranty, it then refers you to the website for Getting Started Support – Free for 30 Days where you can see the majority of install issues that sometimes plague users are specifically exempted.
On one level, this is understandable, because it is sort of unfair that Sage should be responsible for supporting and repairing issues with products and components produced by Microsoft. On the other hand, it could be argued that Sage chose to use those technologies as a basis of the product and that they should provide that support.
The big problem that this raises is how should a Consultant/VAR handle this support? If you are installing a product that costs $300-500 and an OS, SQL or .Net issue requires 4-8 hours of work to resolve, how can you justify charging the user for this time?
Is a notice to users, in advance, that such a charge may be necessary the right choice? Would this tend to scare off some potential users?
Obviously this would be different for larger user sites where they would be more aware of the complexities of commercial software as well as being able to spread the cost over a larger number of seats.
As I’ve said, I’d really like the thoughts of users, resellers and even Sage staff on this topic. Please post any thoughts you might have to the comments as I think the sharing of ideas is likely to help everyone come to an amicable solution to this problem.
For the 3rd consecutive year, GL computing has earned a spot as a Top Expert in the 7th Annual Expert Awards.
From a competitive field of over 30,000 qualified experts worldwide, GL Computing has been awarded the:
From Experts-Exchange: “Thank you for sharing your unparalleled, inconceivable, and brilliant knowledge with the members of Experts Exchange, without you Experts Exchange would not be the #1 IT resource in the web.”
GL Computing has won the Titan Award in 2008, 2009 and is the only Experts-Exchange Certified ACT! Sage
It is truly gratifying to have received this award, along with those others I’ve been honoured with recently.
Sadly, I still get no acknowledgement from Sage for the effort I put in to support users - including over 9,400 posts to their own ACT! Community Site and hosting the ACT! Fanatics Group.
I would like to thank all the readers of this blog and hope you have enjoyed the information I have shared during 2010 and found it useful.
I’d especially like to thank:

These wonderful tributes encourage me to keep assisting users and resellers of ACT!
I thought I'd let you know that I won't be taking a break over this time, so feel free to post a comment here on the blog, to the ACT! Fanatics Group or the GL Computing Facebook Page should you have any questions I can help you with.
Please also feel free to post any suggestions for the types of content you’d like to see from me in the new year - your opinions are important to me.
I'd like to wish all of you and your families a safe, wonderful and successful new year.
Kindest Regards,
Mike Lazarus
ACT! Evangelist
My LinkedIN Profile
ACT! Fanatics Group
GL Computing Facebook Page
Last week, I was asked to look into a problem by an ACT! Consultant in Australia. They have a client in New Zealand who is experiencing the following problem.
On starting ACT!, they get the following error:
The string was not recognized as a valid datetime. There is a unknown word starting at index 5
That’s not too bad, as after clicking OK, everything seemed ok. However when they try to schedule an activity, they got this error:
Resolution of the dependancy failed, type = "ACT.ULAvailControl" name = "Exception message is: The current build operation (build key Build Key{Act.UL.AvailControl, null}; failed. The string was not recognised as a valid Date Time. There is a unknown word starting at index 5. (Strategy type BuildPlanStratefgy, index 3)
They contacted Sage Australia tech support and were told:
Please be advised that it is a Locale, Data/Time specific issue and has been identified as a known issue with the software version for New Zealand and Mexico and is under investigation. We should get a fix for it in Service Pack 1 which may be couple of months away. In the mean time, you can follow the below step to work around the issue –
Close and open database [File > Close] without closing ACT completely.
You will be able to access the date/time related features without any problem. If you have any questions, please feel free to reply to this email or call Support
Obviously, as this problem only happens in those countries, there is a problem with those who didn’t beta test it prior to release.
I wondered who might have seen this, so I posted a message about it to the ACT! Community Forums and the LinkedIN ACT! Fanatics Group … the answer came on the LinkedIN group from José Roberto dos Santos from Brazil. He said:
Change the Regional Settings in Windows Control Panel from "am" and "pm" to "AM" and "PM".
I am glad to report that this simple fix worked perfectly and I thought I’d post it here for others in those regions who have this error.
Normally I try to get this out during the beta period. But, for various reasons, I’ve only been able to get to this now.
Sage ACT! 2011 has added a whole swag of new functions, improvements in usability and fixes to issues. I’m going to try and cover the ones that I have found to be most useful. Unfortunately, a couple are only useful to those within North America… but such is the lack of ability of the regional offices to test the functions and respond.
For the full, public list, please refer to these ACT! Knowledgebase Articles:
Obviously, before you upgrade you should ensure your system, and any add-ons or plugins, support the new version or if they need an update as I suggested in the article: Upgrading ACT!, especially when you are using add-ons
One change worth noting first is the product name changes:
Other than ongoing improvements in stability and speed, the biggest new items are:
Smart Tasks allow you to schedule a series of common and connected steps. You can use the Smart Task templates that Sage ACT! provides* or create your own using the Smart Tasks Manager. Smart Tasks can be run manually or scheduled to run automatically.

Note: I think this feature is the one that should easily justify the upgrade for most users.
You should have a look at the ACT! 2011 Smart Tasks video on YouTube
Outlook Integration allows you to synchronize your activities and contacts between Sage ACT! Premium and Outlook. You can set synchronization options to determine what information is synchronized. Synchronization can be scheduled to run automatically or manually run at any time.
Note: I strongly suggest users be careful with using these options as I’ve found some odd behaviour. While some of the bugs have now been fixed with Hotfix 1 for Sage ACT! 2011, others are still problems. For example, the fact that it doesn’t sync the country code with phone numbers makes it useless for anyone who wants to call internationally or to use the numbers when travelling – this is the same as one of the bugs I identified in ACT! Mobile Live.
Sage Business Info Services for ACT!* (provided by Hoover's™) provides tools to access critical business information for your contacts and companies. With Sage Business Info Services for ACT!, you can:
Build a list of companies and people and then import these lists directly into your database. Access links from the contact and company Web Info tab. These links provide key information about your contacts' and companies' profile, financial details, company contacts, industry information, and company news. Subscribe to alerts to notify you when key changes occur for the contact or company.*Requires additional subscription.
Note: This service provides very limited benefit to those of us outside North America or United Kingdom as you can see from the Hoovers' Companies By Geography list
For some months, people have been asking about support for Office 2010 in ACT! by Sage with no information or direction from Sage itself.
Up until this point I had assumed that, like with many earlier versions, Sage would provide a patch for the currently available version of ACT!, but that it would be significantly improved with the next major release. Well, this was not the case.
Sage management had left everyone guessing till finally an announcement from Larry Ritter. In brief:
Let me address each of these points in turn:
There are two possible reasons for Sage’s decision not to provide a patch for users of ACT! 2010.
Either there were significant changes in the new Office version that produced major challenges to incorporate in the current code base, or Sage completely underestimated the faster uptake to Office 2010 compared with Office 2007 and didn’t foresee it would be an issue for enough of its user base.
Whatever the reason, Sage decided it was better value for their R&D dollars to concentrate on ACT! 2011
But why has it taken so long to provide this necessary information?
While I do applaud Sage for at least providing this bandaid fix, there are a few issues I have:
On a 64bit operating system, Office 2010 can be installed in either 32bit or 64bit, but ACT! 2011 will only support Office 2010 in 32bit mode.
I’m not sure of the reasons for this, but it is important to note that many products from Microsoft, Google and others are also limited in their Office 2010 support to 32bit.
I don’t see this as too much of a problem because the only real advantage of operating Office as a 64bit application is if you need to operate on huge (multi-gb) Excel or Word documents.
However, it is something that will be important for Sage and resellers to make users aware of, especially as I would think most pre-installed versions of Office on new systems would have been pre-installed as 64bit.
While it would have been nice for Sage to have patched ACT! 2010 for full support, there are obviously technical and/or business reasons for their decision not to do this. Certainly it gives justification for users to purchase the maintenance package each year.
What I fail to understand is why it took so long for Sage to inform the user-base of their decision and, more so, to provide the work-around to users caught out by this when they knew about it so long ago.
ACT! is a business tool and its users need timely communication from Sage in order to plan their own business projects. It seems that, since the days under David van Toor and Sam Hunter, ACT!’s management have been communicating in absentia.
What do you think?