Other AddOnStores GOLDMINE | OUTLOOK   HOME | BLOG | FEEDBACK | HELP
AddOnStore for ACT!
Search
Browse AddOns by: View producst listed by Category View products for specific Industries Alphabetical listing of Products Products listed alphabetical by Manufacturer   Buy ACT! Add Ons here
 

Command Tool — $39

Command Tool puts you in command!

Command Tool lets you create a "command file" of commands that let you:

  • Export a Lookup or Query to CSV (text) format
  • Create a multi-column report in HTML
  • Do automated Lookup / Edit-Replace operations
  • Create one-click lookups relative to today's Date
  • Add Notes to Lookup

A command creation wizards leads you through the steps of creating the command file.

Command Tool

Build up your own library of useful automation commands

One click Export of your contact data

Command Tool is a simple tool for exporting ACT! Contact data. It is useful for a lookup or query based export that needs to be performed on a regular basis or with a particular well defined format.

It can output either text or HTML format. The text format is compatible with Excel and the HTML format can be used for simple contact list reports.

ACT! does not need to be running to run Command Tool, and it easy to set it up to run unattended using the Windows Task Scheduler.

The command lines are saved in a text file, and Command Tool reads and executes the lines in that file when it runs. Here is a simple example of a command file.

command file: Export CEOs.txt

! Here is a sample of the Command Tool command file...
Database=C:\My Documents\ACT\Database\ACT5demo.dbf
Lookup=Title,ceo,replace
Columns=Company,Contact,City,Title,Email
Output=c:\temp\CEOs.csv

Translated into English, this command file, when executed by Command Tool will:

1. Open ACT5Demo
2. Do a Lookup on Title = CEO
3. Sets the fields to export to Company,Contact,City,Title,Email
4. Write the Lookup into the Output file CEOs.csv

which will result in the following output:

output file: CEOs.csv

Company,Contact,City,Title,Email
CH Gourmet Imports,Chris Huffman,New York,CEO,ch@ch.com
Elliott's Department Stores,Homer Elliott,Raleigh,CEO,
Kwik-e-mart,Danese Bouvier,San Francisco,CEO,
Trader Depot,Sanjiv Skinner,Los Angeles,CEO,
Cordoba Coffee Shops,John Lew,Irving,CEO,Lew@cordobacs.com,Pacific Cafe Company,Shirley Brightwell,San Francisco,CEO,

or, if you choose HTML output:

Company

Contact

City

CH Gourmet Imports

Chris Huffman

New York

Elliott's Department Stores

Homer Elliott

Raleigh

Kwik-e-mart

Danese Bouvier

San Francisco

Trader Depot

Sanjiv Skinner

Los Angeles

Cordoba Coffee Shops

Mr. John Lew

Irving

Pacific Cafe Company

Shirley Brightwell

San Francisco

Query using Today's date!

Command Tool can also do lookups and queries relative to today's date. If you want to create a report that outputs today's leads in a nice HTML format, use the commands:

command file: TodaysLeads.txt

! Here is a sample of the Command Tool command file...
Database=C:\My Documents\ACT\Database\ACT5demo.dbf
Query=("Create Date" = "Today()")
Columns=Company,Contact,Title,Phone,Email
HTMLOutput=c:\temp\todaysleads.htm

Command Tool also supports the use of ThisMonth() and LastMonth() in Queries and Lookups. And, with Today(), you can add and subtract so you can do queries that cover date ranges like Today()-7 to Today().

Extensions to Command Language

Newly added features now make Command Tool more than an Export utility. We've recently added these new comands:

  • Set Fields -- a batch version of Edit/Replace
  • Copy Fields
  • Swap Fields
  • AppLookup -- Create a Lookup in ACT!
  • Launch -- run external program with contact fields as parameters

We had a customer that was using our Sales Automation Mania. He wanted a way to add new leads to campaigns based on what they had indicated as interests. (You add a contact to a campaign in SAM by setting a contact field to "Start".)

So, we added a "Set" command that could set a field value for a Lookup.

command file: SetCampaign.txt

! Add new leads to Widgets Campaign...
Database=C:\My Documents\ACT\Database\ACT5demo.dbf
Query=("ID/Status"="New Lead") AND ("Wants Widgets"="YES")
AND ("Widget_Stage" BLANK)Set=ID/Status=In Widget Campaign;Widget_Stage=Start

Then it dawned on us that if we could actually have it create a Lookup in ACT! itself, you could use the date substitution as a "Super Saved Query" tool. So, we added that too.

command file: LookupMyNewLeads.txt

Database=C:\My Documents\Contacts.dbf;username/password
Query=("Create Date" = "Today()") AND ("Record Creator" = "<your name>")AppLookup=

This command file will do something you can't do in ACT! without use of Lookup By Example. It will lookup all the contacts created today by you.

Northwoods Software Corp.

Other Products by Northwoods Software Corporation

Command Tool — Lets you create a “command file” of commands that let you: export a lookup or query to text format, create reports in HTML, do automated lookup/edit-replace operations, create one-click lookups relative to today’s date and add notes to a lookup. FREE TRIAL
Do Not Call — Match your Do Not Call lists with your ACT! database. FREE TRIAL
Duplinator — Find and merge those pesky Duplicates. FREE TRIAL
ExportPro — ACT! to Access Converter.
Export Sales Info — Export Sales Info. FREE TRIAL
Mail Merge — Helps you create HTML templates and send them quickly to as many ACT! contacts as you need to. Don't struggle with limited Merge tools. FREE TRIAL
Side Lookup — A mini standalone version of ACT! that lets you view Contact data in another database without closing current database or lookup. FREE TRIAL
Web Prospect — Enter contact information received from your Web site directly into ACT! without re-typing. FREE TRIAL

Technical Support Information
NORTHWOODS SOFTWARE CORPORATION

TOP

 

 


$39 -

1 user

FREE Downloads

 

  • Free TRIAL
    Command Tool
    Limited to 30 days
    —1.3 MB
  • Intro VIDEO
    Take five minutes to see Command Tool in action... right on your PC without installing anything*
  • User's Guide

*

MAY REQUIRE WINDOWS MEDIA PLAYER
Download here

 

ACT! Compatibility

 

Ver. 5.x/2000

YES

Ver. 6.x

YES

 

System Requirements

 

  • Pentium or equivalent recommended
  • Windows 2000/98/95/NT
  • 32 MB RAM or as required by OS
  • 4 MB of available hard disk space to install the program.
 

 


AddOnStore
CONTACT US
 1-800-806-5288
Copyright © 2011 SJR Productions, Inc.
All brands and product names are trademarks or registered trademarks
of their respective companies.

 
AddOnStore   AddOnStore
     

 

 

 

 

 

 

 

Purchase Options

BACK  

   
  • Please note: This product must be registered with the manufacturer within 30 days. Complete instructions will be provided in your email receipt once your purchase has been completed.

TO BUY — click the BUY image or call 800-806-5288

Command Tool

   

DOWNLOAD

1 User

$ 39 (US)

BUY 

   

All products have a 30-Day Money-Back Guarantee unless otherwise noted. All returned products are subject to a 10% restocking fee.

 
   

View Shopping Cart

   

BACK