3305 Main Street Ste 019 Vancouver, WA 98663

Import

The Sage 300 Construction and Real Estate Office Connector from Event 1 Software allows you to connect to your Sage data to from within Excel spreadsheets.

Office Connector

Import


Watch Video

Attend Webinar

10-Day Evaluation

Buy Now

Download

Sage 300 Construction and Real Estate allows selected types of records and transactions to be imported from properly formatted text files.  Office Connector Import puts this technology in your hands by removing the complexities associated with formatting your data according to the precise rules in Sage 300 Construction and Real Estate.  You have the freedom to organize your data in Excel how you wish and Office Connector Import collects your data and assembles it into the desired import files.  There is no need to modify or adapt the layout of your report to accommodate the file formats required by Sage 300 Construction and Real Estate.  Once the Office Connector Import functions have been added to a report, you can use that report over and over again to quickly create import files.  You will not lose time recreating and/or reformatting the information to produce import files each time!

Example Applications

Owners of Office Connector Import use it for…

  • Estimates
  • Budgets
  • Purchase Orders
  • Change Orders
  • General Ledger Adjustments
  • Time Entry
  • Importing Credit Card Purchases
  • Recurring Invoices
  • Importing Cleared Checks

Features

Feature Description
Saving Import Files When you are ready to create an import file, simply click a button and let Office Connector Import do the rest!  There is no need to rearrange or reformat your worksheets or to save your workbook in a different format.  Office Connector Import collects the data it requires based on the instructions within the workbook and then assembles your import file in the correct format.
Sample Solutions A set of over 10 report designs is included for you to use or to serve as starting points and educational resources. Read more...
Macro Support Creating an import file is only the first step in getting your data into Sage 300 Construction and Real Estate.  Next, the file must be imported using one of the import functions in Sage 300 Construction and Real Estate.  To make this a more streamlined process, you can record a macro in Sage 300 Construction and Real Estate that includes the steps needed to import your file.  Then, just give Office Connector Import the name of your macro and let it run the macro for you when it creates the import file.
Online Help All Office Connector functions and tools are fully documented in online help that is quickly accessible from within Excel.

Licensing

Office Connector Import is licensed separately for each type of import file that you plan to create.  There is no restriction on the number of users who can utilize a license at one time.  The types of import files that can be licensed include:

  • Accounts Payable – Invoices
  • Accounts Receivable – Invoices
  • Cash Management – Cleared Checks
  • Equipment Cost – Entries
  • General Ledger – Budgets
  • General Ledger – Entries
  • Job Cost – Commitments & COs
  • Job Cost – Direct Costs
  • Job Cost – Estimates
  • Job Cost - Misc Worksheets *
  • Payroll – Time
  • Property Management – Charges
  • Property Management – Payments

* Import function is provided by a separate program that is installed with Office Connector Import. Sage 300 Construction and Real Estate 9.5 or higher is required for this feature.

Designer

With an Office Connector Import Designer license, you can add import capability to your own Excel worksheets by following the steps in the easy-to-use wizard.

The import wizard makes it easy to import data to your Sage 300 Construction and Real Estate database.

& Watch this two-minute video demonstrating Office Connector Import Designer

Supported Platforms

 Click here for information about supported operating systems, versions of Excel, and versions of Sage 300 Construction and Real Estate.