AnsweredAssumed Answered

Stop PDM from stripping <> characters

Question asked by Thys Coetzee on Jun 7, 2016
Latest reply on Jun 8, 2016 by Thys Coetzee

I have an XML file, an XML data card, all the attributes mapped and a nice SQL function that extracts a data set into a block of XML.

The data is written correctly between the database and the data card, leaving the nicely formed XML in place.

When the file attribute moves the block of XML from and edit field on the data card into the file schema, it wipes out the <> symbols and replaces them with &lt; and &gt; respectively, killing the XML schema.

The correct structureMessed up text

…             </TRNSaddress>

       </PPSdestination>

       <PPSDRAWINGS><PPSDRAWINGS>

  <PPSDRAWINGS>

    <Drwg_Number>116309</Drwg_Number>

    <Obj_RevisionNumber>0.01</Obj_RevisionNumber>

    <Obj_RevisionStamp>APPROVED FOR USE</Obj_RevisionStamp>

    <Drwg_L2>217 test part name</Drwg_L2>

    <Drwg_L3>217 test part BoM description</Drwg_L3>

  </PPSDRAWINGS>

  <PPSDRAWINGS>

    <Drwg_Number>116316</Drwg_Number>

    <Obj_RevisionNumber>0.01</Obj_RevisionNumber>

    <Obj_RevisionStamp>APPROVED FOR USE</Obj_RevisionStamp>

    <Drwg_L2>316 Obj_Name</Drwg_L2>

    <Drwg_L3>316 Obj_Description</Drwg_L3>

  </PPSDRAWINGS>

</PPSDRAWINGS></PPSDRAWINGS></PPStransmittal>

              </TRNSaddress>

       </PPSdestination>

       <PPSDRAWINGS>&lt;PPSDRAWINGS&gt;

  &lt;PPSDRAWINGS&gt;

    &lt;Drwg_Number&gt;116309&lt;/Drwg_Number&gt;

    &lt;Obj_RevisionNumber&gt;0.01&lt;/Obj_RevisionNumber&gt;

    &lt;Obj_RevisionStamp&gt;APPROVED FOR USE&lt;/Obj_RevisionStamp&gt;

    &lt;Drwg_L2&gt;217 test part name&lt;/Drwg_L2&gt;

    &lt;Drwg_L3&gt;217 test part BoM description&lt;/Drwg_L3&gt;

  &lt;/PPSDRAWINGS&gt;

  &lt;PPSDRAWINGS&gt;

    &lt;Drwg_Number&gt;116316&lt;/Drwg_Number&gt;

    &lt;Obj_RevisionNumber&gt;0.01&lt;/Obj_RevisionNumber&gt;

    &lt;Obj_RevisionStamp&gt;APPROVED FOR USE&lt;/Obj_RevisionStamp&gt;

    &lt;Drwg_L2&gt;316 Obj_Name&lt;/Drwg_L2&gt;

    &lt;Drwg_L3&gt;316 Obj_Description&lt;/Drwg_L3&gt;

  &lt;/PPSDRAWINGS&gt;

&lt;/PPSDRAWINGS&gt;</PPSDRAWINGS></PPStransmittal>

 

The red text is in a single edit field.  I want the edit field to leave my text alone-- noooo toucheee my stuffs!

Any help would be most gratefully received.

Regards,

Thys

Outcomes