Converting Swedish Payment files from XML to flat txt files

Hi
The Swedish banking system is changing from traditional flat files to XML files. The system we use imports flat files, and has no functions to interpret XML files,

I enclose an example of a XML file, which we need to interpret and modify to fit the old flat file layout,

There are several types of file, not certain at this stage which is the one to use...

I also include a XSD-file that I got from the bank, if that helps,

best regards,
Per-Olof

not sure the files where attached, I will try again,

Hi Per-Olof,

XML is a tricky and complex format. For your purpose you have to split the read into separate processing steps. I´ve created a simple example for you, please have a look to the attachment.
In the First step you read the XML header data. In the next step you read the details and so on.

Please note: This works as long in your XML file just one “Notification” appears and all data refers to this one.

 
 

Thanks,

I have a year to solve it, since they are changing to the new format in early 2024!

best

Per-Olof