Focal Point
[CLOSED] Reading an XML file from an UNIX app server

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/5737005395

November 11, 2010, 01:39 PM
SunithaKathi
[CLOSED] Reading an XML file from an UNIX app server
I am new to the concept of reading xml files from an external server.I need help in acheiving the following functionality

I have few xml files on a production app server which is a unix server.

I am trying to read one of the xml's from a particular path on the app server.

This is the code i used.

FILEDEF 255700101 DISK apps/global/pol/ir/xml/255700101.xml
TABLE FILE 2557001021
PRINT
XML.COL COL.COL COL1.COL COL2.COL
END
-EXIT


But it does not allow me to read the files.

But am able to read the xml's if i place them in a reporting or any other LAN location.Any suggestion or help on this is greatly appreciated

This message has been edited. Last edited by: Kerry,


WebFOCUS 7.6
Windows, All Outputs
November 13, 2010, 05:11 AM
Waz
Your FILEDEF is relative and not absolute.

As the FILEDEF will start from the temporary directory created for you agent, the file will not exist.

Also have you create a Master File for this XML file ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

November 15, 2010, 12:06 AM
SunithaKathi
Thank you very much for your reply Waz.

Yes I did create a master file for the XML.

How can we read an XML which is in on the application server with the meta data being there for it on the reporting server?

Please help me with this regard.


WebFOCUS 7.6
Windows, All Outputs
November 15, 2010, 01:13 PM
dbeagan
Try this:
FILEDEF 255700101 DISK &APPROOT../global/pol/ir/xml/255700101.xml  



WebFOCUS 8.2.06