Sage Timberline Office Connector

Write

Sage Timberline Office allows selected types of records and selected fields to be updated externally.  Office Connector Write puts this technology in your hands so that you can use Microsoft Excel to help you manage your Sage Timberline Office data.  With a designer license, you have the tools to build your own write-enabled solutions using the built-in wizards that guide you step-by-step.  Whether you build your own solution, use one of our existing solutions, or have a solution built for you, you are in control of what is written.  Before any data is written, you can preview the information and then after data is written, you have a complete audit trail!  Recap reports listing the details of what was written are generated every time you write data to Sage Timberline Office.

Example Applications

Owners of Office Connector Write use it to…

  • Create and Maintain Vendor Records
  • Update Contact Information
  • Spell-Check and Correct Data
  • Create and Maintain Employee Records
  • Update Misc Worksheet Amounts
  • Correct Data Entry Errors
  • Create and Maintain Customer Records
  • Update Notes and File Attachments
  • Maintain Custom Field Values
  • Create and Maintain Job Records
  • Update Pay Rates
  • Create and Update Budgets

Features

Feature Description
Easy Connection To access your Sage Timberline Office data there is no need for you to create data sources or build SQL queries.  Simply select your data folder from the list, supply your Sage Timberline Office operator ID and password and you’re ready to begin working with your Sage Timberline Office data in Excel.
Sample Solutions A set of over 10 report designs is included for you to use or to serve as starting points and educational resources.
Security Using Office Connector Administrator, you can decide which of your Sage Timberline Office operator IDs should have access to Office Connector Write.  This easy to use tool was designed to complement and enhance your existing Sage Timberline Office security.  If you have permission to write to your Sage Timberline Office database, you can ensure data integrity by approving specific write functions in the Approval Window.
Wizard Driven With a designer license, wizards guide you through the steps to create Excel formulas containing Office Connector functions.  As you progress through the wizard, Office Connector Write will identify the fields that can be written via the Sage Timberline Office ODBC driver.
Powerful Worksheet Function Office Connector Write adds the TSWRITE function to your workbooks.  Cells containing this function serve as instructions that map your Excel data to their intended target fields within Sage Timberline Office.
Online Help All Office Connector functions and tools are fully documented in online help that is quickly accessible from within Excel.

Licensing

Office Connector Write is licensed by the number of users who will need to use it concurrently.  Two types of licenses are offered which determine the features that are available to you.  Any number of licenses of each type can be purchased.

Feature Standard License Designer License
Send Data to Sage Timberline Office
Use Write Wizard to Create new Write Instructions