Siebel Open UI: December 2013

Monday 16 December 2013

Query Issue in Siebel Open UI 8.1.1.11

There is an issue with Siebel open UI 8.1.1.1 . When you query a record, OpenUI displays records. But you cannot drill-down or edit that record, even though you have all privileges.

steps to reproduce.
got to any list applet, Click on query, Press "Enter" try to drill-down. This drill-down works only if that record is current record.
or
Try to navigate by clicking next record, you cannot, you have to use next/previous button

Temporary Solution:
Instead of pressing enter click on "Go" Button.

Thursday 12 December 2013

Custom File Upload Applet Based On Class CSSSWEFRImpExp / CSSSWEFRImpExp Fails

We have an Import Button in an Applet, on clicking that button, a small popup applets comes and we can upload CSV which is to be imported in to parent applet. This functionality works well in HI mode. But this functionality fails in OpenUI.
Oracle support says this issues addressed in 8.1.1.11, but still I am getting error.

We can Implement this feature with some tricks.

lets create a button on applet and give method name as "FilePopup". And make sure that CanInvoke is true for this method.

function WebApplet_PreCanInvokeMethod (MethodName, &CanInvoke)
{
    if(MethodName == "FilePopup")
    {
            CanInvoke="TRUE";
            return (CancelOperation);
    }
    return (ContinueOperation);
}

Now open Applet Browser script.

Next step is creating an HTML file. Copy the below code and save it as "FileImport.htm"
in Webserver as well as siebel server. ( \Client\PUBLIC\ and \siebsrvr\WEBMASTER\ )

<html>
</head>
<script language="javascript" src="23030/scripts/3rdParty/jquery.js"></script>
<script>
$(document).ready(function(){

$("#filename").change(function(e) {
var ext = $("#filename").val().split(".").pop().toLowerCase();

if($.inArray(ext, ["csv"]) == -1) {
alert('Upload CSV');
return false;
}

if (e.target.files != undefined) {
var reader = new FileReader();
reader.onload = function(e) {
var csvval=e.target.result.split("\n");
var inputrad="";
for(var j=1;j<csvval.length-1;j++){
    var csvvalue=csvval[j].split(",");
    for(var i=0;i<csvvalue.length;i++)
    {
    var temp=csvvalue[i];
    if(inputrad==""){
        inputrad=temp+"";
    }else if(i!==0){
        inputrad=inputrad+","+temp+"";
    }else{
        inputrad=inputrad+""+temp;
    }


    }
    inputrad =inputrad+"|";
}

window.returnValue = inputrad;
return inputrad;
};
reader.readAsText(e.target.files.item(0));

}

});
$("#import").click(function(){
    self.close();
});
})
</script>
</head>
<body>
<input type="file" name="filename" id="filename">
    <div id="csvimporthint_1">
        <table border="1" id="csvimporthint">
        </table>
    </div>
<input type="button" id="import" value="import">

</body>
</html>

compile applet and run GenB script.
Click on Import button and test this functionality.

How to add custom JavaScript files in Siebel OpenUI 8.1.1.11

Siebel OpenUI 8.1.1.11 comes more more systematic way to manifest the custom JavaScript.
In the Administration level, we have options to add files as well as map those files with applets/views/Applications.

First we need to add our custom files in Manifest files

Now we can map those files with our Application /Applet