|
The information in this release is the most basic information to create SEPA file, but you may need to add more information.
To do this, there is need to know VBA programming, just use the Excel built-in XML tool.
There are 2 options: incorporate information into the header or insert information for each DD.$.
Then simply display the XML source of the page (either via the Developer tab or by right-clicking on an already mapped cell). And then you drag the xml table to the cell to be linked to connect the information.
Key information used for this work
About SDD xml files (French pdf): http://www.europeanpaymentscouncil.eu/index.cfm/sepa-direct-debit/iso-20022-message-standards/
About Excel, xml and SEPA (English): http://pixcels.nl/sepa-direct-debits-from-Excel/
To test your XML files (English): http://xmlvalidator.new-studio.org/
http://www.mobilefish.com/services/sepa_xml_validation/sepa_xml_validation.php
|
Add header information