LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: jpstory

Hi All

I am trying to import a XML file but received an error due to a reserved character ":" in the top part of the XML file.

By manually replacing the ":" with a "_" I was able to import the file, but I need to import 100+ files daily.... is it possible to have a workaround for this manual step ?

-<publicExecutionReport xsi:schemaLocation="http://www.fpml.org/FpML-5/transparency ../../xmls/SDR/transparency/dtcc-ext.xsd" fpmlVersion="5-3" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://www.fpml.org/FpML-5/transparency" xmlns:dtcc="http://www.dtcc.com/ext">

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: jpstory

Bump

Please could someone take a look at this, thanks!

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ejones

I just discovered something that might be a solution. In the lal1 "XML Data" node, look in the Options tab. There is a property named SubstituteInvalidCharacters that you can set to true and it works. (Here is the test I tried, you can cut and paste the text below into LAE to see it)

node:Input_Static
bretype:lal1::Input Static
editor:sortkey=5581c76176c65b2a
output:@51ae0881326a4c48/=
prop:StaticData=<<EOX
<publicExecutionReport
xsi:schemaLocation="http://www.fpml.org/FpML-5/transparency ../../xmls/SDR/transparency/dtcc-ext.xsd"
fpmlVersion="5-3"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns="http://www.fpml.org/FpML-5/transparency"
xmlns:dtcc="http://www.dtcc.com/ext">
stuff
</publicExecutionReport>
EOX
editor:XY=160,160
end:Input_Static

node:XML_Data
bretype:lal1::XML Data
editor:sortkey=5581ca1965b30498
input:5581ca193cdf4c94/=Input_Static.51ae0881326a4c48
output:@51781d234c465db7/=
output:@522743291aa237ba/=
output:@522743281dab2bc6/=
prop:SubstituteInvalidCharacters=true
prop:XmlData=_RawData
prop:XmlDataParamType=Data Field
editor:XY=250,160
end:XML_Data