Maconomy Workspace Client Help

SD_GL_Introduction to Data Exchange

Data Exchange lets you import and export financial data so that you can integrate Maconomy with third-party products, such as payroll systems.

Data Exchange workspaces are all part of the Import of G/L Data add-on module, and are relevant only if you are using that module.

Data Exchange has two parts: Import and Export. The Data Agents workspace is used in both parts; the other workspaces are used by either the Import or Export part.

Data Exchange Module
Import Workspaces Export Workspaces
Data Agents
Import Modes Conversion Groups
Conversion Tables Conversion Rules
Import Data Export Data
Show Imported Files Show Exported Files
Show Imported Data Show Exported Data

Overview of Process

Before you can perform an import or an export using this module, follow these steps:
  1. Identify the source or recipient of your data.
  2. Get the data specification from the source or recipient, usually a third-party vendor.
  3. Use the Format Specification module to build the formats and forms according to the specifications, or

    Import the formats created in another system into Maconomy, using an import program supplied by Maconomy.

  4. Create one or more data agents and associate the import and export formats with the data agents.
  5. Create import modes and conversion rules and associate them with the data agents.
  6. Perform the actual import and export in the Import Data and Export Data workspaces.
  7. View the imported or exported data in the Show Imported Files, Show Imported Data, Show Exported Files, and Show Exported Data workspaces.

You only need to perform steps 1 through 5 once.

Using SQL and RGL Reports

You can also use SQL and RGL reports for importing and exporting data in Maconomy. There are, however, some advantages to using the Data Exchange module:

  • Entries that you exported using the Data Exchange module are marked as exported, so that you cannot export the same entry twice by mistake. You can review exported entries in the Show G/L Entries workspace.
  • Entries that you imported using the Data Exchange module cannot be imported twice by mistake, provided that the person who imports the data uses unique file numbers.
  • The Show Imported Data workspace provides error-checking and error-correcting functionality.