Question Re: Read Text file using Java Script in Product Lifecycle Management Q&A

Read Text file using Java Script

mohamed_dbouk — Wed, 28 May 2014 06:13:21 GMT

Hi,

I am trying to read a text file using Java Script within the webroot of MII as .HTML file. I have provided the path as below but where I am not able to open the file. Any clue to provide the relative path or any changes required on the below path ?

var FileOpener = new ActiveXObject("Scripting.FileSystemObject");

var FilePointer = FileOpener.OpenTextFile("E:\\usr\\sap\\MID\\J00\\j2ee\\cluster\\apps\\sap.com\\xapps~xmii~ear\\servlet_jsp\\XMII\\root\\CM\\OCTAL\\TestTV\\Test.txt", 1, true);

FileContents = FilePointer.ReadAll(); // we can use FilePointer.ReadAll() to read all the lines

The Error Log shows as :

Path not found

Regards,

Mohamed

Re: Read Text file using Java Script

RiaNinan — Wed, 28 May 2014 08:55:29 GMT

Hi Mohamed,

If you have the text file within webroot of MII, then you can think of using jQuery.get() for reading the content of the file.

You could try the below piece of code:

$.get( "http://<server>:<port>/XMII/CM/Default/Test.txt", function( data ) {

$( ".result" ).html(data);

alert(data);// The file content is available in this variable "data"

});

Hope this helps!

Regards,

Ria

Re: Read Text file using Java Script

mohamed_dbouk — Wed, 28 May 2014 10:43:06 GMT

Hi Ria,

Thanks for your reply.

I have added the code as above but its not recognising the $. Do you need to include any files?

Error Throws as :-

'$' is undefined

Code as below:-

<html>
<head>
<script language="javascript">
function Read()
{

$.get( "http://ops20mi1.nat.pet:50000/XMII/CM/Test/PP/Sheet/Dashboard/Television/Test.txt", function( data ) {
$(".result").html(data);
alert(data);
// The file content is available in this variable "data"
});

}
</script></head><body onLoad="Read()"></body></html>

Re: Read Text file using Java Script

RiaNinan — Wed, 28 May 2014 11:06:21 GMT

Hi Mohamed,

Sorry, I missed to mention that you would have to include jquery javascript library for using the jQuery.get().

You can download it from http://jquery.com/download/

Do let me know if you need more information.

Also I would like to know the version of MII you are using.

Regards,

Ria

Re: Read Text file using Java Script

Former Member — Thu, 29 May 2014 11:32:22 GMT

Hi Mohamed,

I tried above code after importing JQuery Library through script Tag. It worked for me . Pls check.

Note : You can place Jquery1.xx.xx.js file in the same folder where you saved this IRPT/HTML file.

<HTML>

<HEAD>

<TITLE>Your Title Here</TITLE>

<SCRIPT type="text/javascript" src="jquery-1.9.1.js"></SCRIPT>

function Read()

{

$.get( "http://ldcimfb.wdf.sap.corp:50100/XMII/CM/Regression_15.0/CrossTab.txt", function( data ) {

$(".result").html(data);

alert(data);

// The file content is available in this variable "data"

});

}

</script>

</HEAD>

</BODY>

</HTML>