Free ACT! by Sage video training.

Sage has a number of ACT! training videos that are useful for new users. While they don’t (and shouldn’t) replace the use of a good trainer, they can be complimentary and used for brushing up on some of the areas later. I thought I would post links to them here.

ACT! by Sage and ACT! Premium:
  • ACT! Workspace
  • Activities
  • Customization
  • Dashboard
  • Dashboard Designer
  • Finding Information
  • Groups & Companies
  • Handheld Link Installation or Handheld Contact
  • Importing Contacts
  • Mail Merge
  • Opportunities
  • Outlook Integration
  • Printing
  • Setting up E-mail
  • Setup Assistant
  • Sharing Databases
  • Synchronizing
  • Writing a Letter
  • ACT! features for ACT! for Web:

    GL Computing also offers full reseller training and Consultant training.

    Please contact us for for more information.

    Technorati Tags: ,,,

    Sharing ACT! – Network or Sync (Part 2)

    Synchronisation is done when users need remote access to the database. This means they will operate on a local copy and have the ability to send/receive any changes made with their copy to a master copy. They may have access to all the data, or maybe just a subset of the data that they need.

    Typically, the the times when you need to implement sync will be for uses like these:

    • Users who operate from remote offices or from home
    • Laptop users who need to work on the road
    • Hosting the main database with an external provider (possibly use Premium for Web) and syncing to a copy for better control of imports/exports and mail merges.
    • PDA or smart phone users with devices such as Blackberry, Pocket PC or iPhone

    It is important to note that these instructions will try to explain the different options to make it easier for you to make your selection. But while it is certainly possible for a user with enough time to set this up, you’ll nearly always get a better implementation set up in less time if you involve an ACT! Certified Consultant. See How to pick the right CRM consultant?

    PDA or Smart Phone users should use Handheld Contact as it is the most reliable solution. For some of it’s advantages, see: Why Handheld Contact for ACT! and PDAs

    For the other uses, ACT! has a built in sync. For this to be successful, you must make sure that every user is on the same exact build of ACT! (check the full build in Help | About) and, if using a sync server, that this is also of the same build. When a new update, patch or hot fix is released, you need to be sure to apply to all systems and sync server

    To set up sync, first you need to have set up the shared database on the LAN as per the previous Sharing ACT! – Network or Sync (Part 1)

    Then you determine what data is to be in each Subscriber (remote) database. You do this by creating sync sets as per ACT! KB 14072. You could use the same sync set for each remote user, or have different ones so each remote site only has the data it needs.

    Note all users’ My Records will always be sent to all the remote databases – and all their extended data (notes, histories, embedded or attached emails, sales ops, etc). If you need the extended data in My Records to be hidden from other users, please contact GL Computing for a security plug-in we developed to secure this data

    Next, you create the Remote databases (you need a separate database for each remote). This is done as per ACT! KB 14116

    Then you need to determine the way the remotes will connect to the master. There are three options:

    Application Sync

    • This is the only option available if you do not have a Premium version of ACT!
    • Synchronisation this way requires that ACT! on the system hosting the Publisher database is open and logged into the database in order to sync.
    • Set up is fairly easy as per: ACT! KB 15192
    • For remote database that don’t come in and connect on a LAN, have a look at the VPN link below
    • To sync without having the Publisher open and logged in, you will need to use ACT! Premium and one of the options below

    Network Sync

    • Uses a Network Sync server that runs as a service
    • Sync service means that you don’t need ACT! open and running on the Publisher database in order for Subscriber databases to sync with it.
    • Basic set up is the same as for Application Sync, but you use the Network Sync service, which you setup as per ACT! KB 22977
    • Normally, this is used for users who come into the office to sync, or who connect to the office LAN via VPN
    • It can also be configured to connect over the internet as per ACT! KB 17536 – if security is a major issue, this Sync server can be in a DMZ if your firewall has that ability.
  • Internet Sync

    • Uses a sync services that provides access via an IIS web server
    • This option has similar advantages to using the Network Sync service, but can be a bit more complex to set up. To do this, the instructions are as per ACT! KB 22978


    • Sometimes, with Application or Network sync, you may want to set up a VPN for added security or to make it easier to get past a firewall. If you don’t have a VPN system, you can use Hamachi® VPN as per ACT! KB 23333

    There is much more to sync when it comes to troubleshooting, understanding the sync panel and the sync logs. But the information in this post should hopefully give you the basics. Please add a comment if you think there’s anything extra that you’d like added.

    Sharing ACT! – Network or Sync (Part 1)

    A lot of users new to ACT!, especially those who don’t get the benefit of a consultant, seem confused between when to share on a network and when to sync… or, in fact, how to do either. So I thought I would attempt to explain the various options and include instructions on how to implement them.
    The first misconception some people have is that these functions can only be done with the “Premium” or “Workgroups” editions (depending on the version or country). This is wrong. The Premium version does have some additional options, but even the standard ACT! by Sage product can do both.
    As always, I recommend that users speak to a Certified Consultant before commencing your implementation, especially with database design and setting up synchronisation and learning how to get the most out of ACT!

    Setting up the database server:

    The usual place people need to start is with setting up ACT! on a “server” – that is, the machine that will host the ACT! database. In a small environment (< 5 users), this may be a user’s machine.
    Note: ACT! is a client/server product. That means the full application MUST be installed on system hosting the database locally.
    Usually, one of the questions a user will as is “What sort of server does ACT! need?” Well, that depends on a number of factors that you should provide to your consultant to determine this:
    • How many ACT! users will there be?
      • How many on the LAN
      • How many via Web (if any)
      • How many remote (if any)
    • Will you have a server?
      • If yes, will the server be dedicated to ACT! or shared with other services?
      • If shared with other services, what services and how busy are they?
    Once you have selected the machine to host the database, you need to install ACT!. I recommend doing it this way:
    • Perform a Selective restart with MSCONFIG as per ACT! KB 14499
    • Install ACT! from the CD
    • Update ACT! the latest patch for your version. You can download any patches from here
    • Restore from Selective Start-up Mode with MSCONFIG
    • Reboot
    • Open ACT! - Create, upgrade or Restore_As your database
    • Share the database as per ACT! KB 13878
    The most common error you might get is: "The database <Database name> could not be accessed. In order to access this database, check your network connection and verify that your database server is available. It may be necessary to disable any firewall software.” – To fix it, please follow the suggestions in that link.
    If you need to set up sync to share your data with remote users (external offices, laptops, smart phones), please see Part 2