Language:


Routines - Exports

The Exports routine allows you to export information from your Standard ERP to tab-delimited text files on your hard disk. This information is then available for use in other programs, such as word processors, spreadsheets, database programs etc. You can often also import the information into other Standard ERP databases or Companies using the 'Automatic' and 'Manual file search' Import routines in the System module.

To begin exporting, click the [Routines] button in the Navigation Centre and then the [Exports] button in the 'Routines' window. Alternatively you can use the Ctrl-E (Windows and Linux) or ⌘-E (Mac OS X) keyboard shortcut at any time (even if the Navigation Centre is hidden). The 'Exports' list window is then opened, listing the Exports that you can produce from the active module. The options in this list window vary according to the active module: the majority of Exports are in the Integration module, as shown in the illustration below:

Double-click the option that you need in the list: a specification window will then appear, where you can decide the contents of the exported text file. Click [Run] and a 'Save File' dialogue box will appear, where you can name the file and determine where it is to be saved. If you are exporting with the intention of importing into another Standard ERP database or Company using the 'Automatic' and 'Manual file search' Import routines, do not name the file with two leading minus signs/hyphens (e.g. --Data.txt). Information will not be imported from files named in this way.

To gain access to the Integration module, you must log in as a Global User or Person whose Access Group explicitly grants full access to that module.

By default, text files exported from a Standard ERP database will contain Unicode characters. You can change this by specifying a Default Export Codepage in the Local Machine setting in the User Settings module.

As well as exporting information to text files, you can also use the Exports routine to back up your Standard ERP database. For full details of how to do this, please refer to the Backing Up page. For security reasons, the 'Company Text Backup' and 'Database Text Backup' exports do not produce text files as mentioned above but encrypted files that can only be read by another copy of Standard ERP.

Note that you can also print all Standard ERP reports to disk as text files. This, in combination with the Exports routine, makes it very easy to retrieve information from Standard ERP for use with other applications.

Individual Export Functions

Please click the links for details about the individual export functions in the following modules:
Go back to: