SQUIZZ.com
Loading interface, please wait...
Interface taking a long time to load?
Check your internet connection is up, and you're using the latest app/browser version.

Connector Adaptor Attache (version 7)

Learn how to configure the Connector's Attaché adaptor to import and export data from the Access Attaché business system for versions 7 and higher to Ecommerce platforms

The Connector's Attaché adaptor supports connecting to the Attache's accounting system software, which is developed by The Access Group.

Topics

  1. Prerequisites
  2. Overview of Data Connectivity
  3. Attaché Setup
  4. Adaptor Settings Configuration

Prerequisites

Please make sure you have read through the Get Started/Overview before continuing down this document.

Also make sure you understand the concepts of:

Overview of Data Connectivity

The adaptor utilises the ODBC (Open Database Connectivity) data source to obtain and export data from an Attache system. It uses Attache's built in KFI(Key File Import) functionality to import sales orders back into Attache. The KFI utility relies on the Squizz.com screen template and user being set up in Attache to correctly import data from the connector into Attache.

Attache adaptor system diagram

Attaché Setup

To allow the adaptor to talk to a Attaché installation, the following needs to be setup within the Attaché installation:

Sales Order Import Setup

For the Connector's Attaché adaptor to be able to import sales orders into the Attaché system, within the Attaché system an "order" screen needs to be configured that matches the structure of the order data saved by the Attaché adaptor. Attaché uses the same screens as users within the software to import sales orders through its KFI (Keystroke File Import) feature. The contents of the sales order file generated by the adaptor contains the key stroke commands to act like a user keying in an order within the Attaché system. To set this up follow these steps:

  1. Download the ORDEXSQI.SPF file to the computer where the Access Attaché client application is installed. This file contains the Attaché screen layout configuration for allowing users to key in orders.
  2. Open the Access Attaché client application.
  3. Type in the user ID and password of either a supervisor or administrator user.
  4. Select the Attaché company file where data is being imported to.
  5. In the Attaché application's menu, click on the Setup menu item
  6. Under the Screen Designers section, click on the Orders link.
  7. Click on the Create button
  8. Find and select the ORDEXSQI.SPF file previously downloaded in step 1.
  9. Click on the Save button
  10. Click on the File menu item
  11. Click on the Switch Users sub menu item
  12. Type in the User ID and password of the user who will be used to import sales orders with.
  13. From the Navigation menu, click on the Customers menu item.
  14. Click on the Orders item
  15. Click on the Create button
  16. Click on the Screen button.
  17. Select the screen that was previously added to Attaché in step 9. This screen will now be saved as the user's default screen, that also can be used by the KFI imports to import sales orders with this user.
  18. Click on the Cancel button to cancel creating the order.
  19. Open up a File Explorer application
  20. Navigate the directory where the Attaché company-file base directory exists, for example: C:/path-to-attache/attachebi/company-name/
  21. Navigate to the directory of the user

References:

Adaptor Settings Configuration

Below are all the settings within the adaptor's General Settings window that enable connectivity between the adaptor, the Attaché system's database, and its KFI data import functionality.

Setting Description
Attache ODBC Data Source Name Name of the ODBC data source that has been configured in WIndows to read and write data from the Attaché system's database.
Attache ODBC Data Source User ID Name of the user to connect with when obtaining data from the Attaché system's ODBC data source.
Attache ODBC Data Source User Password Password to connect with with when obtaining data from the Attaché system's ODBC data source.
Attache Database Table Name Prefix Set a value that can then be placed within data export SQL queries before the table names in queries, to correctly query the Attache underlying database through an ODBC connection.