Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [CASE OPENED] Data Quality Server 9.0.4 -- Reading XML File

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CASE OPENED] Data Quality Server 9.0.4 -- Reading XML File
 Login/Join
 
Member
posted
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,
 
Posts: 3 | Location: Virginia Beach, VA | Registered: March 11, 2020Report This Post
Virtuoso
posted Hide Post
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.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2128 | Location: Customer Support | Registered: April 12, 2005Report This Post
Member
posted Hide Post
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 < >.
 
Posts: 3 | Location: Virginia Beach, VA | Registered: March 11, 2020Report This Post
Virtuoso
posted Hide Post
Gotcha... That said you should open a case with techsupport


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2128 | Location: Customer Support | Registered: April 12, 2005Report This Post
Member
posted Hide Post
I will go ahead and do that. Thanks for the response!
 
Posts: 3 | Location: Virginia Beach, VA | Registered: March 11, 2020Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [CASE OPENED] Data Quality Server 9.0.4 -- Reading XML File

Copyright © 1996-2020 Information Builders