Language:


Introduction to Exports in the System Module

The 'Exports' functions allow you to export information from your Standard ERP database to tab-delimited text files from where you can incorporate it in word processing programs for mailmerge, in spreadsheets for further statistical analysis or in page make-up programs for incorporation in publicity material or published reports. Alternatively and depending on which Export option you choose, you can often import the information into other Standard ERP databases or Companies using the 'Automatic' and 'Manual file search' Import functions in the System module. Remember that you can also print reports to disk, so most of the information that is stored in a Standard ERP database is available to other applications via the medium of the text file.

The 'Exports' functions in the System module also include the routines that you should use regularly to back up your Standard ERP database. The data in your database will be exported to a separate back-up file. Unlike the other Export routines, those that create back-up files will not export to tab-delimited text files but instead will encrypt the information so that the back-up files cannot be read by other applications.

To begin exporting, click the [Routines] button in the Navigation Centre. A list of routines appears: click the [Exports] button in the list of routines to open the 'Exports' list illustrated below. You can also use the Ctrl-E (Windows) or ⌘-E (macOS) keyboard shortcuts to open the 'Exports' list.

Double-click the item in the list that you need: a specification window will then appear, where you can decide the contents of the exported 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 the information 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.

There are also some Export functions relevant to the System module in the Integration module. To use these functions, you must log in as a Global User or Person whose Access Group explicitly grants full access to the Integration module. Change to the Integration module, and then proceed as described in the previous paragraph.

Please follow the links below for details about each export function:

Go back to: