Description

http://www.lmgmarketing.com.au/ - is now called http://www.ontapdata.com.au/ (Dec 2015) Market leaders in collecting and managing data for the liquor industry, and providing business intelligence to support our clients' business strategies.'

The OnTap Data / Liquor File is a master Product file containing the Products of over 400 Suppliers to the Australian Liquor Industry. The OnTap Data / Liquor File can be used as a price book in SwiftPOS, allowing the importing Barcodes/Products to the SwiftPOS Database using a simple Price Book Import process. In addition to this there is also an export interface (Scan Data Export) that can be used to export sales data in the OnTap Data / Liquor File Format. For more information  http://www.ontapdata.com.au/

The following are features of the OnTap Data / Liquor File

• Electronic Invoices - Allows Supplier Invoices to be delivered in an electronic format and imported into SwiftPOS.
• Price Book Import - Price Books can be used to import Products into a SwiftPOS database, removing the need to create records manually.
• Product Code Changes - An imported file can be used to quickly update Product Codes in the database.
• Promotion Import - Allows Product promotions from OnTap Data / Liquor File to be delivered in an electronic format and imported into SwiftPOS.
• Scan Data Export - The Scan Data Export is a custom export containing sales data for the OnTap Data / Liquor File interface.

To Be Considered

• OnTap was previously known as Liquor File in Task Manager

Pre-Requisites

1. In order to use the OnTap Data / Liquor File interface, register with OnTap Data / Liquor File and pay the appropriate fees. Download the DLL file from the OnTap Data website which is used to decrypt the Price Book. Note : The OnTap Data registration is PC specific so Price Book importing will need to be limited to one PC unless multiple registrations are obtained. To register and setup OnTap Data / Liquor File please follow these instructions:
    
1. Download the SdeDecrypt.zip file from http://www.liquorfile.com.au and extract the contents into the SwiftPOS installation directory, C:\Program Files\Samford Software\Main\.
2. Run SwiftPOS and expand the Suppliers menu Item, and select Supplier Electronic Trade v1.
3. Select Liquor File from the dropdown box then select the Price Book Folder either by using the open file dialog or manually entering the file path.
4. Select the Import Price Book button and the following registration will appear:
5. Enter a Venue Name into the first field then press the Set Name button.
6. Record the Customer ID that appears in the registration screen then contact OnTap Data to register for an Unlock Code.
7. When you receive the Unlock Code enter it into the appropriate field then press the Register button.
8. For importing Price Book information ...

Scan Data Export

Note : This has been replaced with the Export Scan Data in the End of Day process.

The Scan Data export is part of the OnTap Data / Liquor File interface and is used as a sales data export. The file that is created is a CSV file that uses the following naming convention: IIIDDMMYY.CSV (where III is the Venue ID).

Note : There are extended file naming options which can be configured in the Batch Reports screen, allowing the file naming convention above to be created.

The file should be exported to the same folder that is used for transferring data to OnTap Data / Liquor File. Contact OnTap Data Support with any issues you may have with the Export. The Scan Data export is run from the Custom Reports menu but is not run like a regular report. To run the Scan Data report select the export to CSV or TSV option. This will create the export file in the selected folder.

The following specification shows the file format for the Scan Data export.

Note : The VenueID field actually refers to the Scan Data Group Prefix for the selected Location Group (Venue). The reason for this is that the Location Group (Venue) ID's cannot be changed after they are created but the Scan Data Group Prefix can.

OnTap Data / Liquor File

Note : This has been replaced with the Export Scan Data in the End of Day process.

The stored procedure below allows you to export the Scan Data using an external application.

Related Topics

1. Suppliers