I am new to the DQS program and having trouble getting the DQS to read a particular XML file. The XML is formatted like so:

{agn:Party id="Party_00000000"}
{agn:PartyTypeCode tc="01"}Employee{/agn:PartyTypeCode}
{agn:PartyKey}00000005{/agn:PartyKey}
{agn:Person id="Person_00000000"}
{agn:FirstName}Gxxx{/agn:FirstName}
{agn:MiddleName}L{/agn:MiddleName}
{agn:LastName}Hxxxxxx{/agn:LastName}
{agn:OLifEExtension}
{agn:OLifEExtension}
{ext:NetworkID}Gxxxx{/ext:NetworkID}
{/agn:OLifEExtension}
{/agn:OLifEExtension}
{/agn:Person}
{agn:EMailAddress id="EMailAddress_00000005"}
{agn:AddrLine}Gxxxxx@xxxxx.xxx{/agn:AddrLine}
{/agn:EMailAddress}
{agn:Employment id="Employment_00000005"}
{agn:OLifEExtension}
{agn:OLifEExtension}
{agn:OLifEExtension}
{ext:ManagerPartyID}00000000{/ext:ManagerPartyID}
{agn:EmploymentExt03}
{agn:EmploymentExt04}
{ext:PayGradeCode tc="F"}F{/ext:PayGradeCode}
{agn:EmploymentExt05}
{ext:LowestLevelVPPartyID}00000000{/ext:LowestLevelVPPartyID}
{/agn:EmploymentExt05}
{/agn:EmploymentExt04}
{/agn:EmploymentExt03}
{/agn:OLifEExtension}
{/agn:OLifEExtension}
{/agn:OLifEExtension}
{/agn:Employment}
{agn:OLifEExtension VendorCode=""}
{/agn:OLifEExtension}
{/agn:Party}

(Edit: I had to change the < > to { } because the excerpt was not showing up. The original file is enclosed with < >.)

The tags have a prefix "agn" or "ext". I have completed a plan with another XML file that does not have the prefixes and it reads and transforms it with no issues, but it seems like the prefixes cause the object to not read anything.

I have already tried the "Namespaces" section in the XML Reader object and that did not seem to work.

Any input would be greatly appreciated. Thank you.

This message has been edited. Last edited by: FP Mod Chuck,

Juhralyuh

First of all welcome to Focal Point!

I am by no means an expert with DQS and XML so I asked one of the tech support people to look at this post. His reaction was that your xml is an unusual looking document.
People usually use < > brackets, Not { } , which is what I’m seeing
Eg {agn:Party id="Party_00000000"}

That would be something you’d expect to see in a JSON file..

So the suggestion is to change the { } brackets to < > brackets and see if that helps. If not please open a case with techsupport.

quote:

Originally posted by FP Mod Chuck:
Juhralyuh

First of all welcome to Focal Point!

I am by no means an expert with DQS and XML so I asked one of the tech support people to look at this post. His reaction was that your xml is an unusual looking document.
People usually use < > brackets, Not { } , which is what I’m seeing
Eg {agn:Party id="Party_00000000"}

That would be something you’d expect to see in a JSON file..

So the suggestion is to change the { } brackets to < > brackets and see if that helps. If not please open a case with techsupport.

So sorry. I didn't put a note in my post that I had to change the < > to { } because the post was reading it as code therefore not showing up. The original file does have the tags enclosed with < >.

Gotcha... That said you should open a case with techsupport

I will go ahead and do that. Thanks for the response!