Connector Adaptor Attache (version 7)

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

Also make sure you understand the concepts of:

• Connector Adaptors.
• Connector Routines.
• Attache system.https://www.theaccessgroup.com/en-au/our-brands/attache/

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.

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:

• https://myattache.attachesoftware.com/display/public/AAP/Location+of+Keystroke+Import+files
• https://myattache.attachesoftware.com/display/public/AAP/Creating+multiple+screen+layouts
• https://myattache.attachesoftware.com/pages/releaseview.action?pageId=3443477

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.