Sage 50 Exporter

Sage 50 Exporter

Sage 50 Exporter

Export data from Sage 50 Accounts and save to a variety of file formats, databases and websites.

Scheduling and filters can be defined and export settings saved allowing consistent export of Sage data.

Version # 27.0.0.2

Subscription: £130.00+VAT (per year)

Details

Details

WebXeL Exporter for Sage exports data from Sage Instant and Sage 50 Accounts and save the data to a variety of target formats. Filters can be defined and export settings saved, allowing consistent export of Sage Instant and Sage 50 Accounts data.

Export various types of data from Sage Instant and Sage 50 Accounts, including product images and use Windows Task Scheduler for a fully automated process.

Business Applications

Web Updates - Update web site prices, product details, stock levels and discounts, etc. directly from your Sage Instant and Sage 50 Accounts package.
Images - Resize and publish Sage Instant and Sage 50 Accounts product images directly to a web site or local folder, create thumbnails, resize and optimise for the web.
Databases - Filter and export Sage Instant and Sage 50 Accounts data directly to a database (Access, SQL Server, MySQL and ODBC) for, comparison, archive, financial analysis or use in other applications.
CSV/Spreadsheets - Filter and export Sage Instant and Sage 50 Accounts data to Excel spreadsheets or CSV format for financial analysis etc.
Mail Merge - Mail Merge Sage Instant and Sage 50 Accounts data directly to Microsoft Word to create emails, letters, labels etc.

Benefits

Benefits

Reduced Costs - export Sage 50 Accounts data directly to a web site or application and save valuable time on maintaining duplicate information.

Reduced Errors - exporting Sage 50 data, eliminates errors, keeps external data in sync and saves time maintaining manual management.

Staff Involvement - frees up this most valuable company resource.

Affordable - Order Exporter for Sage is excellent value for money.

Free Trial - 30 days un-restricted trial plus 30 days support.

Features

Features

Multiple Sage Accounts

Supports multiple Sage companies, Exporter can have as many export jobs defined and connecting to as many sage companies as you like.

Supports Data Filtering

You can define jobs to filter and export only specific data that matches the filter rules.

Relational Data

Define relationships between Sage tables to export data in a master/detail format.

Network Compatible

Exporter for Sage is fully network capable; it can connect to sage installations across a local area connection (LAN)

Export Target Formats

Sage Exporter can export data to the following locations;

  • Web URL(HTTP)*
  • Database (Access, SQL Server, MySQL and ODBC)
  • CSV Files
  • Excel Spreadsheets
  • XML Files
  • Word Mail Merge
  • Sage Order Importer

* A web developer may be required to set-up the web pages that receive exported data.

Sage Export Data

Sage Exporter can export the following data from Sage Instant and Sage 50 Accounts;

  • Audit Transactions
  • Product Invoice
  • Bank Accounts
  • Company Delivery Addresses
  • Country Codes
  • Currencies
  • Customer Delivery Addresses
  • Customer Price Lists
  • Customers
  • Departments
  • Fixed Asset Categories
  • Fixed Assets
  • Goods Despatched Notes
  • Goods Received Notes
  • Invoices
  • Invoice Items
  • Nominal Ledger
  • Product Categories
  • Product Price Lists
  • Product Transactions
  • Products
  • Purchase Orders
  • Purchase Order Items
  • Remittance Data
  • Sales Orders
  • Sales Order Items
  • Supplier Delivery Addresses
  • Suppliers
  • Tax Codes
  • Product Images
  • XML or CSV feed via HTTP Web Page**
  • MS Access Database
  • MS SQL Server
  • MySQL
  • CSV Files (Local & FTP)
  • Excel Spreadsheets

Screenshots

Screenshots

Sage Exporter - Interface

Sage Exporter - Interface

Sage Exporter - Sage Connection

Sage Exporter - Sage Connection

Sage Exporter - Job Export Options

Sage Exporter - Job Export Options

Sage Exporter - Job & Export Format

Job & Export Format

Sage Exporter - Select Sage Data to Export

Sage Exporter - Select Sage Data to Export

Sage Exporter - Select Field Export Options

Sage Exporter - Select Field Export Options

Sage Exporter - Exported Data Save & Format Options

Sage Exporter - Exported Data Save & Format Options

Sage Exporter - Job Detail Summary & Settings

Sage Exporter - Job Detail Summary & Settings

Sage Exporter - Exported Data Preview

Sage Exporter - Exported Data Preview

Sage Exporter - Exported File

Sage Exporter - Exported File

Sage Exporter - Exported File Data

Sage Exporter - Exported File Data

Click screenshots to view full size

Requirements

Developers

Sage Compatibility

Sage Instant Accounts Versions 15 onwards, Sage Line 50 Versions 10 onwards & Sage 50 Accounts Versions 2008 onwards including Sage 50 C & Sage 50 Cloud (Excluding Sage 50 USA & Canada).

Required Software

Windows-based PC running Microsoft Windows 8, 10 or Windows Server 2008 onwards.

Microsoft .NET Framework 4.5.2
(The WebXeL Order Importer for Sage software installer checks for installation when installing the program and allows you to download directly)

Developers

Developers

Sample Files

The sample files download contains sample files for web developers, and these provide examples of handling exported data and using it to update a database.

Currently included are samples using;

  • ASP VBScript
  • ASP.NET (Native .NET code VB)
  • ASP.NET (Native .NET code C#)
Download Sample Files