The ACT! Scheduler

The ACT! Scheduler – Scheduled Sync

ACT! has included a handy little application called the ACT! Scheduler for quite a while now.  It gets installed automatically and is rarely used.  Up until the most recent versions, TrilogyCRM has not recommended using the ACT! Scheduler for your synchronization tasks.  Mainly because the scheduler did not notify the user of a failed sync.  We would have angry customers because they were assuming that the syncs were running every hour – when in fact the database had not synchronized for weeks.

The newest versions have the ability to setup email alerts. Woot Woot!  Follow the steps below to setup the scheduler.  If you will be setting up the email alerts – you will need to complete the email alerts FIRST.

 

Setting Up Email Alerts

  1. Click on Start button and find the ACT! Scheduler (located under the ACT!)
    Step1
  2. This will launch the Scheduler Settings Dialogue box.  Click Set Up E-Mail Alerts. Step2
  3. Your settings may vary but if you have a Gmail account (which I think everyone does at this point) the settings for Gmail are listed below.  If you have your own SMTP server you can enter your information.  Check with your Email Administrator for the settings.  This is not something that TrilogyCRM can support or assist with as we do not host your Email.   Once you enter the information you can click the Test Connection button and verify the settings are correct.
    SMTPSettingsForGMail

Setting up the ACT! Scheduler – Scheduled Sync

 

  1. Click on Start and find the ACT! Scheduler from the start menu. (Located under the ACT! Section)Step1
  2. Click on Create A Task
    Step2
  3. The next step is the most tricky for end users.  This step is asking you “Where is the database you would like to use to setup the scheduled task?”.  If you are a TrilogyCRM Hosting customer and followed the documentation – your database is located in the C:\ACTDATA folder.  Click the Browse button on the screen and “find” your database (PAD) file, highlight it and click OPEN.
    Step3
  4. Now – this is the really tricky step.  You have to enter your username and password.  This is your username and password that you use to access ACT!  Don’t say it… Yes you do have a username.  Everyone who uses ACT! has a username.  You may not have a password but the username is usually your First Name and your Last Name. (i.e. Chris Huffman)   If you don’t know this information, you will need to check with your administrator for assistance.  Once you have updated your username – click NEXT.
    Step4
  5. This window will allow you to select the type of Task to schedule.  For this Quick Tip we are scheduling a Database Synchronization (remote database only) – select this option from the drop down and click NEXT.
    Step5
  6. Set a Schedule – this window will allow you to setup the schedule on which the syncs will run.  We’ll define the suggested settings – but feel free to adjust to match your working pattern.  Select Hourly from the Occurs Column.  We work a normal business day so Starting at 8:00AM and ending at 5:00PM is fine (adjust this to end just AFTER you normally end your day).   Change the Every drop down to 1 hour.  You can see when the task will run from the “Task will run at” indicator.Tweak your settings and click NEXT
    Step6
  7. The final step is to set up the Send Notifications settings.  In order to send notifications you are required to FIRST setup the Email Alert Settings (detailed above).  If you did not setup the email settings – the Send e-mail notifications checkbox will be disabled.  If you did setup your SMTP server correctly – you can check the checkbox and enter the email address that you would like to have the notifications sent to.  Click the Send Teste E-Mail to ensure that your system is complete.   Click Finish.
    Step7

Congratulations! You have setup the ACT! Scheduler to automatically synchronize your database!  Now get back to work and let the scheduler handle the sync’ing for you.

 

ACT!V16 Service Pack 1

We’re announcing ACT!v16 Service Pack 1 (Hotfix 1) has been certified for TrilogyCRM hosting customers!  What does this mean for you?  We’ll if you are using ACT!v16 and hosting with TrilogyCRM – you will be required to run this update.

This Service Pack does contain a schema update.  That means:

  • Be sure you are an Act! Administrator.  You’ll be prompted to update the database when you open it after installing SP1.  Only Admins can update the database schema.
  • SP1 must be applied to the host & all remote databases to maintain synchronization
  • SP1 must be applied to the main database host and all network users to maintain connectivity via network share

Curious about what SP1 is all about?  Here are some FAQs – http://kb.swiftpage.com/app/answers/detail/a_id/37445

To apply Service Pack 1:

  1. Go to http://www.act.com/support/download-center/
  2. Click on the link for your version – Pro or Premium (If you aren’t sure of your version, open Act!.  Click Help, then About Act!.  Your version is listed there.)  All hosting customers are on the Premium version and should download ONLY the Premium files.ACTv16SP1UpdateDetail
  3. Download the SP1 Update specific to your version, saving it to a place you can easily find itACTv16SP1-Step2
  4. Browse to & double click the actprem16sp1_us_update.exe
  5. Click Run
  6. The install is unpacked
  7. Click Install

Install

Follow the prompts to install the Service Pack.   Once the service pack has been successfully installed – you can continue to download and install Hot Fix 1 (instructions below).


Applying Act! v16 SP1 HF1

To apply Hot Fix 1, download it from http://www.act.com/support/download-center/, following the same process as installing Service Pack 1.

  1. Download the ACT! Service Pack 1 Hotfix 1 file from the Download Center.ACTv16SP1HF1-Step1
  2. Run the Hotfix 1 file.
    ACTv16SP1HF1-Step2

 

ACTv16SP1-Step3

Now that you have upgraded to Service Pack 1 AND run the hot fix – it’s time to open your database and update the schema.   Open your database.  You SHOULD get a message indicating that the database needs to be upgraded and asking you if you want to backup your database.  It’s a good idea to backup your database but not completely necessary.  Since you are hosting – we have a way to recreate your database from the server should something happen. 

Click either yes or no and the database will upgrade to Service Pack 1 HF1.  Once the process completes you can check your version by going to Help – About ACT!.  You should see Act! Premium Version 16.1.207.0. Hot Fix 1
ACTv16SP1-Step4

If you run into any errors or issues installing the service pack our technical support team will be available to assist you.  Please initiate support by emailing support@TrilogyCRM.com and be as detailed as possible when explaining your issue.  Tech support is available for hosting customers who have attempted the installation and encounter errors.  If you prefer to have Tech Support process the update for you – additional billable support time will be incurred.