The RTS Advantage Data Export Tool allows you to extract data from
the Roundtable Software Advantage Accounting System. The program can export
to Access database files (MDB); Excel spreadsheet files (XLS); dBase format
files (DBF) as well as three text formats: comma-delimited (both TXT and
CSV), fixed field length and TAB delimited. Any of the text formats can
include field titles or not, as you prefer. Field titles can be customized
by the user when exporting to any format. Also, when exporting to the text
formats, you have the option to append or overwrite existing files.
The Data Export Tool allows you to export data from each Roundtable
Software Advantage module and from most of the files in the modules. You
cannot export key file data, notes or help data. In addition to the fields
from a file, the program allows you to include 5 additional standard fields
in your export: Current Record, Module Code, File Number, Today's Date
and Company Number.
If you want to export to a format that we don’t support directly, almost
any application should be able to read one of the available export formats,
such as dBase or comma-delimited. Refer to the documentation for that application
to determine which formats it can accept.
By using the Data Export Tool, you create a template file (*.XDF) which
contains the module, company and file you are exporting from as well as
the fields to be exported and your name for each field. These files are
created in the Advantage AUSER directory and should be added to your backups.
