This content has been marked as final. Show 8 replies
You need to explain this more.
Is this going to be in a fixed directory with dynamic file names, or also dynamic directories?
Is this going to be a recurring batch job, or is this user triggered?
What kind of record will be created?
Where does the file come from?
If you give us more context, we might be able to come up with a solution.
Alright..It s goin to be dynamic directories,user triggered.For example, if it is an excel file with multiple records/lines, siebel should be able to read those records and convert them into service requests.
Also the answer to "Where does the file come from?".It depends on the user(from where he selects it)
It looks like the attachment functionality of Siebel is of no use here.
The only thing might be the archiving of the Excel sheets, but it will not help you to create the SRs.
It's important to know where the Excel comes from, as that might give an opportunity for another solution.
Does the Excel sheet come from a third party, or is it generated by an internal system/person?
It's possible to add VB script to an Excel sheet that can connect to Siebel and create the SRs based on the contents of the sheet.
You can also create a custom button that will prompt the user for the file:
How to prompt for File Browse in Web Client Application? [ID 534068.1]
From what I understand, you would like to read an excel file and create SRs from them. This can be done automatically if you are going to have a standard path and file name by using RCRs or it can be done by user intervention.
The following link will point you in the correct direction:
However, note that this will work only if the Siebel Server you have is Windows based. In case, you are not having a windows siebel server, then you will have to do the process by user intervention wherein you will have to write the code on the Browser script of the applet. In browser script, the COMCreateObject is to be replaced with ActiveXObject.
If you are using COM object from server code, ensure that Excel is installed on the siebel server and the file is accessible from the siebel server. In the ActiveXObject usage, Excel needs to be present on user's system.
Hope this helps.