Exports / Imports

 

 

Description

 

This document provides an overview of the Export/Import features currently available and supported by SwiftPOS.

 


General Ledger Interfaces

 

INTERFACE WITH

DATA

ACTION

SETTINGS

VIA

FILE TYPE

REGO

COMMENTS

Adept

Sales

Export

...

FILE

CSV

Yes

Adept. Exports Sales data once Terminal Cash Offs have been saved and committed.

MS Dynamics GP

Chart of Accounts

Import

...

FILE

CSV

Yes

MS Dynamics GP

Sales
Stock Movements

Export

CSV

MYOB

Suppliers

Import

... 

File

TAB

Yes

MYOB

Sales
Stock Movements

Supplier Details
Supplier Invoices Terminal Cash Offs

Export

TXT

MYOB Account Right

Chart of Accounts

Import

... 

API

n/a

Yes

MYOB Account Right

Suppliers

Import/Sync

Sales
Stock Movements
Supplier Invoices
Terminal Cash Offs

Export

MYOB EXO

Supplier Invoices

Export

...

File

CSV

Yes

MYOB EXO

MYOB Greentree

Sales
Stock Movements
Supplier Invoices

Export

...

File

CSV

Yes

MYOB Greentree

Navision

Categories
Price Levels
Products

Import

...

File

To be continued ...

Yes

Navision

Sales

Export

CSV

Netsuite

Sales

Export

...

File

CSV

Yes

Netsuite

Oracle Financials

Sales
Stock Movements

Statistical Data

Purchase Data
Supplier Invoices

Export

...

File

CSV

Yes

Oracle Financials

Oz Biz

Sales
Supplier Invoices

Export

...

File

TXT

Yes

Oz Biz

SwiftPOS GL

Generic

Accounts

Import

...

File

TXT

 

 

Sales

Supplier Details

Supplier Invoices

Export

TXT

 

Supplier Details are exported as CREDITOR.CSV/TAB/TXT files.

MYOB Export (Retail Manager)

Sales

Supplier Details

Supplier Invoices

Export

...

File

TXT

 

 

Tally

Sales

Export

...

File

XML

Yes

Tally

Xero

Chart of Accounts

Import

...

API

n/a

Yes

Xero

Sales
Stock Movements

Supplier Invoices Terminal Cash Offs

Export

Xero Pro

Chart of Accounts

Import

...

API

n/a

Yes

Xero Pro similar to Xero, except it has the option of importing/mapping Tracking Categories and subsequently exporting these as part of the data exported to XERO.

Tracking Categories

Import

Sales
Stock Movements
Supplier Invoices
Terminal Cash Offs

Export

 


Members

 

INTERFACE WITH

DATA

ACTION

SETTINGS

VIA

FILE TYPE

REGO

COMMENTS

PC EASY

Members

Export

...

File

CSV

 

 

SwiftPOS

Account Balances

Import

...

File

CSV

 

 

Member Images

Export/Import

...

File

Selectable

 

 

Turbo

Members

Export

...

File

 

 

 

 


Products

 

INTERFACE WITH

DATA

ACTION

SETTINGS

VIA

FILE TYPE

REGO

COMMENTS

ALM

For more information ...

Bottlemart

For more information ...

CAS LP1

Scale PLU Data

Export

...

File

XLS

 

Exports changed Product pricing to Scale Link Pro

HLW

Price Book

Import

...

File

TXT

 

Imports SwiftPOS Price Book TXT files. Namely, TMPB_CATEGORY.txt, TMPB_GROUP.txt, TMPB_MANUFACTURER.txt, TMPB_MASTERGROUP.txt, TMPB_PRODUCT.txt, TMPB_PROMOTION.txt, TMPB_SUPPLIER.txt and TMPB_SUPPLIERITEM.txt

Specials/Promotions

Import

 

File

TXT

 

Imports a SwiftPOS Price Book TXT file. Namely, TMPB_PROMOTION.txt

IBA

For more information ...

ILG

Price Book

Download & Import

...

FTP/Web

CSV/XML

 

Converts downloaded/Imported files into SwiftPOS Price Book TXT files. Namely, TMPB_CATEGORY.txt, TMPB_GROUP.txt, TMPB_MANUFACTURER.txt, TMPB_MASTERGROUP.txt, TMPB_PRODUCT.txt, TMPB_PROMOTION.txt, TMPB_SUPPLIER.txt and TMPB_SUPPLIERITEM.txt

Import

Specials/Promotions

Download

...

File

XML

 

 For more information ...

Import

...

LMG

Bottlemart

Specials/Promotions

Export

...

File

CSV

 

 

 

Price Book

Import

...

DAT

 

 

Specials/Promotions

Import

n/a

CSV

 

 

Metcash/ALM & IBA

IBA

Mix n Match

XML

 

 




Price Book

Download & Import

...

Web

XML

 

Downloads and Imports an iba_product_promotions.xml file from the IBA Web portal and converts it into SwiftPOS Price Book TXT files. These are then imported into the Matched  Products and/or New Products tabs. From here they can be reviewed and committed (saved) into SwiftPOS. Namely, TMPB_CATEGORY.txt, TMPB_GROUP.txt, TMPB_MANUFACTURER.txt, TMPB_MASTERGROUP.txt, TMPB_PRODUCT.txt, TMPB_PROMOTION.txt, TMPB_SUPPLIER.txt and TMPB_SUPPLIERITEM.txt

Import

...

File

 

Imports an iba_product_promotions.xml file and converts it into SwiftPOS Price Book TXT files, which are then imported into the Matched  Products and/or New Products tabs. From here they can be reviewed and committed (saved) into SwiftPOS. Namely, TMPB_CATEGORY.txt, TMPB_GROUP.txt, TMPB_MANUFACTURER.txt, TMPB_MASTERGROUP.txt, TMPB_PRODUCT.txt, TMPB_PROMOTION.txt, TMPB_SUPPLIER.txt and TMPB_SUPPLIERITEM.txt

Specials/Promotions

Import

...

WEB

XML

 

Imports a downloaded iba_product_promotions.xml that may or may not contain Promotions and converts it into a SwiftPOS Price Book TXT file. Once converted it will then be imported. Namely, TMPB_PROMOTION.txt

Metcash/ALM

Price Book

Import

...

API

XML

Yes

Advanced Host Integration. Imports a Metcash Host/Product XML file. The v7 file is downloaded via Metcash Retail Web Services API and replaces the former v5 XML file.

Specials/Promotions

Import Food

...

File

DAT

 

 

Import Liquor (ALM)

File

DAT

 

 

Ontap Data (TM - Liquor File)

 

Mix n Match

Import

n/a

File

XML

 

 

Price Book

Import

...

File

ZIP

 

 

Standard

Specials/Promotions

Import

n/a

File

TXT

 

 

Sunrise

Mix n Match

Import

n/a

File

CSV

 

 

SwiftPOS

Mix n Match

Import

n/a

File

XML

 

 

Export

n/a

File

XML

 

 

Price Book

Generic

Import

...

File

TXT

 

Imports SwiftPOS Price Book TXT files. Namely, TMPB_CATEGORY.txt, TMPB_GROUP.txt, TMPB_MANUFACTURER.txt, TMPB_MASTERGROUP.txt, TMPB_PRODUCT.txt, TMPB_PROMOTION.txt, TMPB_SUPPLIER.txt and TMPB_SUPPLIERITEM.txt

Export

...

File

TXT

 

Exports SwiftPOS Price Book TXT files. Namely, TMPB_CATEGORY.txt, TMPB_GROUP.txt, TMPB_MANUFACTURER.txt, TMPB_MASTERGROUP.txt, TMPB_PRODUCT.txt, TMPB_PROMOTION.txt, TMPB_SUPPLIER.txt and TMPB_SUPPLIERITEM.txt

Generic (XLS)

Import

...

File

XLSX

 

 

Liquor File

Import

...

File

CSV

 

 

Product Images

Export/Import

...

File

Selectable

 

 

Scale PLU Data

Export

...

File

TXT

 

 

UCB

Mix n Match

Import

n/a

File

CSV

 

 

Wedderburn SAM

Scale PLU Data

Export

...

File

TXT

 

 

Wedderburn WEDGE

Scale PLU Data

Export

...

File

TXT

 

 

 


Sales

 

INTERFACE WITH

DATA

ACTION

SETTINGS

VIA

FILE TYPE

REGO

COMMENTS

ASTUTE

Sales

Export

...

FILE/FTP

CSV

 

 

BART

Sales

Export

... 

URL

 

 

 

Bottlemart

Sales

Export

...

File

CSV

 

 

Deputy Rostering

Sales

Export

...

File

CSV

 

 

Event Analysis

Sales

Export

...

File

CSV

 

 

IBA

Sales

Export

...

File

XML

 

 

IGT

Sales

Export

...

File

CSV

 

 

MyLocalFoodie

Sales

Export

n/a

File

CSV

 

 

Ontap Data (TM - Liquor File)

Sales

Export

...

File

CSV

 

 

Venetian

Sales

Export

...

WEB

 

 

 

 


Suppliers

 

INTERFACE WITH

DATA

ACTION

SETTINGS

VIA

FILE TYPE

REGO

COMMENTS

Accounts Flow

Invoices

Download / Import

...

WEB

n/a

Yes

Available to sites with a Rego > Software Enhancement date of 20 Sep 2018 or more recent. For more information ...

ALM

For more information ...

BIDVEST

Invoices

Import

...

File

TXT

 

Opens File Explorer to select a Bidvest Invoice TXT file to import. The file is a pipe (|) delimited TXT file provided by Bidvest.

Cooking The Books

Invoices

Import

 

 

 

 

 For more information ...

Purchase Orders

Export

 

 

 

 

 For more information ...

HLW

Purchase Orders

Export

 

File

CSV

 

 

ILG

Invoices

Download

...

FTP

INV

 

 

Import

File

INV

 

Imports an ILG Invoice INV file. The file is downloaded from ILG via FTP.

Purchase Orders

Export

...

FTP

 

 

 

Liquid Speciality Beverages

Invoices

Import

n/a

File

CSV

 

Import using the Liquid Mix (CSV) option. The file is provided by Liquid. For more information go to www.liquidsb.com.au.

Metcash/ALM

Invoices

Download & Import

...

WEB

XML

Yes

Advanced eTrade or Advanced Host Integration. Downloads and Imports selected Metcash Food (v7) (also known as Metcash Grocery v7 Invoice importing and replaces the former Metcash Grocery v5 DAT file) OR Liqour Invoices (v8) (also known as ALM Liquor Invoice importing and replaces the former ALM Liquor v5 DAT file) in the form of XML files. Imports a downloaded Metcash Food Invoice v7 XML file. .

Import Food

Import Liquor (ALM)

Purchase Orders

Export Food

...

WEB

XML

Yes

Advanced eTrade or Advanced Host Integration. Exports Grocery and Liquor (ALM) Purchase Orders.

Export Liquor

PDT Receipts (QuickFuel)

Invoices

Import

...

File

TXT

 

Imports a PDT Receipts (Quickfuel) TXT file. The file is downloaded from the PDT.

Purchase Plus

Invoices

Download / Import

...

URL

n/a

Yes

Advanced eTrade. Downloads/Imports a Purchase Plus Invoice XML file.

SwiftPOS

Invoices

Import

...

File

CSV

 

Imports a SwiftPOS Generic Invoice CSV file. The file is generated using SwiftPOS PDA software.

Import

...

INV

 

Import a SwiftPOS Generic Invoice INV file. The file can be manually generated using the SwiftPOS Supplier Invoice File Format (INV).

Import

...

XML

 

Imports a SwiftPOS Generic Invoice XML file. This is generally used for Warehouse round tripping. The file can be manually generated using the SwiftPOS Supplier Invoice File Format (XML). For more information ...

Import

...

File

XML

 

Imports a SwiftPOS generated XML Supplier Invoice (*.xml) file. Contact SwiftPOS Support to request the format required.

Purchase Orders

Export

n/a

File

CSV

 

Exports an authorised SwiftPOS Purchase Order CSV file.

Export

n/a

File

XML

 

Exports an authorised SwiftPOS Purchase Order XML file.

Export

n/a

File

XLSX

 

Exports an authorised SwiftPOS Purchase Order XLSX file.

 


Related Topics

 

  1. General