Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
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
Go
New
Search
Notify
Tools
Reply
  
[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, 2020Reply With QuoteReport 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: 2062 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport 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, 2020Reply With QuoteReport 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: 2062 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport 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, 2020Reply With QuoteReport This Post
  Powered by Social Strata  
 

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-2018 Information Builders, leaders in enterprise business intelligence.