Re: SAGE Accounting Data Files
Geoff Barnard
I've just spotted this thread. I don't know if it was supposed to
relate to Delphi ONLY?
The data in SAGE files (.DTA for Line 50, .REL in Line 100) is not
encrypted, and can be read by 'normal' programs. I have certainly
written programs to get data out of both versions, and even to put data
back in, without in the case of Line 50 using and SDK.
Of course, some parts of files are easier to make sense of than others.
The main ledgers are not a big problem, but to get anywhere with the
transactions you need to work out the details of the various linked
lists within the detail files (HEADER, SPLITS and USAGE).
I use 'C', and create a record buffer structure to read the data into.
The data types work OK with this, i.e. null term char data, number
formats - the one complexity is that dates are stored as an integer
offset from a base date.
Putting data back in is more complex, as you need to be mindfull of the
integrity of the overall accounting system else there's no point.
Putting transactions in is best done creating a CSV file for SAGE to
import using the existing process.
At the end of the day, it all depends on what data you want out, and
what you want to do with it?
Geoff - www.data-sage.co.uk
not not but net.