Hi, I have an FM database from which I would like to export a ready-to-use aba file (a banking file listing transactions to be made from an account). The database is a list of purchases for which payments need to be made and lists names, BSBs, account numbers and transaction amounts.
An aba file is just a UTF8 text file with a single Descriptive Record line with basic account info and processing date info, followed by each transaction on a separate line. Finally a single summary line appears that lists among other things the number of transactions.
I've set up a single field for each of these elements, called abaDescriptiveRecordLine in a grand leading summary, abaRecordLine (body)and abaFileTotalRecordLine (trailing grand summary) respectively, and they all work perfectly - onscreen the report is impeccable.
However, I'm at a loss as to how to persuade FileMaker to export the XML the same way ie:
Can someone point where to start with an XML template?
Many thanks in advance