AnsweredAssumed Answered

XML newbie - can this be done?

Question asked by praxiscreative on May 24, 2015
Latest reply on May 28, 2015 by Menno

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