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:

 

abaDescriptiveRecordLine

abaRecordLine

abaRecordLine

abaRecordLine

...

abaFileTotalRecordLine


Can someone point where to start with an XML template?


Many thanks in advance

Outcomes