nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

xml as a record not data source

lpurba

Hi all,
I was wondering if I can parse or do something to my data if the data is an xml.

Let say I have a table student with student_id, student_property fields.
The student_id id is a regular record, let say, 123, and student_property is an xml record, let say
<?xml version="1.0" encoding="UTF-8"?>
<name>
<firstname>John</firstname>
<lastname>Doe</lastname>
<dob>10/01/1919</dob>
</name>

Is there any way that I can display student_property not as an xml in my table? I know I can have xml as a data source, but I don't think this one can be considered as xml data source.

Regards,
-Laurent

Find more posts tagged with

Comments

Virgil Dodson

What makes you believe that this cannot be considered XML data source? If this is an XML source available through a file path or URL then the XML Data Source would work fine. I assume <name> is your repeating element in this simple example so you would select that as the 'table' mapping, and then select firstname, lastname, and dob as the 'column' mapping. For that point on, you work with the data set fields just like you would any other data source.

In 2.2, this XML could also come from a web service.

lpurba

Hi, thanks for your reply.
What if the xml source is not available thru file path or url? Since this xml is a record on the table, how can I make this available as data source.

Regards,
-Laurent

hewb

Have you tried to use data set computed column? You should be able to extract the student info from the xml using some javaScript code.

lpurba

Hi hewb,
Thanks for your reply.
Do you have any docs or link that I can look into?

-Laurent

Virgil Dodson

Hi Laurent, 
 
I created an example using the JavaScript similar to below and uploaded it to: 
<a class='bbc_url' href='http://www.birt-exchange.com/modules/wfdownloads/singlefile.php?cid=2&lid=197'>http://www.birt-exchange.com/modules/wfdownloads/singlefile.php?cid=2&lid=197</a> 
 
Virgil 
 
Javascript code to parse the XML: 
 
importPackage(Packages.org.apache.xerces.parsers); 
importPackage(Packages.org.xml.sax); 
importPackage(Packages.java.io); 
 
var parser = new DOMParser(); 
parser.parse(new InputSource(new StringReader(dataSetRow["student_property"]))); 
var nodelist = parser.getDocument().getElementsByTagName('firstname'); 
var entry = nodelist.item(0).getFirstChild().getNodeValue(); 
 
entry;

lpurba

Hi Virgil,
Thanks for the script. I am going to work on it.

Regards,
-Laurent

Pallavi Akhouri

Hi ,
 
I am working with open Text team .We are using I-hub to generate the report . Let suppose we have One report XYZ and we want to run this report in i potal after running report for particular scenerio we are getting more than 350 pages.
while extracting these report in excel there is limitation/error in I-hub server that we can extract only 200 pages so, download excel is not giving the exact transaction. So can anyone give the idea how we will exract actual report in .xls or it is I -hub limitation???

pricher

Hi Pallavi,
 
You can increase the page limit by increasing the value of the ALLOW_EXPORT_PAGE_LIMIT parameter in the iHub web.xml file. Depending on your version of iHub, this file is located in either 
 
<iHub Install>\modules\BIRTiHub\iHub\web\birtservice\WEB-INF (for iHub 16)
 
or 
 
<iHub Install>\modules\BIRTiHub\iHub\web\iportal\WEB-INF (for iHub 3.x)
 
After saving the file, you need to re-start iHub.
 
Hope this helps,
 
P.
 
PS: Next time, please post using a new topic.