Clarity

  • Private Community

  • 1.  Need GEL for XOG from an Excel file

    Posted May 08, 2013 05:01 PM
    Hi All,

    I'm trying to prepare a process from which i need to XOG in the data from an Excel or .CSV file. when i try this i'm getting an error as

    "BPM-0704: An error occurred while executing custom script: org.apache.commons.jelly.JellyTagException: null:19:60: <soap:invoke> Failed to send a SOAP message generated to 'https://..."

    can any please help in this to overcome this?

    Regards
    Vinay


  • 2.  RE: Need GEL for XOG from an Excel file
    Best Answer

    Posted May 09, 2013 12:19 AM
    Check these -

    99247472
    11930974
    15436324
    15837435

    NJ


  • 3.  RE: Need GEL for XOG from an Excel file

    Posted May 09, 2013 08:21 AM
    Hi NJ,

    Thanks for that and that has been fixed. I'm working in an Ondemand server and i need help to know where and how to place the file in the server and refer the same for my process. I have place the excel file in my local machine and tried to refer the same. I got an error as "
    BPM-0704: An error occurred while executing custom script: org.apache.commons.jelly.JellyTagException: null:41:87: <file:readFile> C:\Users\vadivina\Documents\enpi\enpi (No such file or directory)" . Can any one please clarify / help me to overcome this.....


  • 4.  RE: Need GEL for XOG from an Excel file

    Posted May 09, 2013 08:42 AM
    If you are running a GEL script from within the Clarity application (in a process) then the GEL is executing on the BG server - all filesystems will be relative to that BG server.

    You can run GEL locally (on your PC) "outside of the Clarity application" and you will then be able to reference local filesystems ; however if you are processing files locally then you don't need to be using GEL at all ; you can use 'anything' that can build a SOAP message (i.e. the XML that you pass to XOG) from your data in the excel file and just can call the Clarity XOG service (no GEL involved at all).

    It is a bit unclear to me what you are trying to do though?


  • 5.  RE: Need GEL for XOG from an Excel file

    Posted May 09, 2013 08:50 AM
    Hi Dave,

    That was really fast. Let me explain you my requirement. I will get a "Tab delimited" file from another team. That needs to be stored in the Clarity Server. I need to prepare a process, which can read the file and
    prepare a XML template and then XOG it in the application. As i'm working in Ondemand server, i don't have any control in placing the file in the server. How to do this?


  • 6.  RE: Need GEL for XOG from an Excel file

    Posted May 09, 2013 09:07 AM
    Ok I am saying that you DON'T NEED to create a process / transfer files to the ondemand server. (You could, but I can't help you there since I have no experience with CA's ondemand platform).

    i.e.

    vadivu wrote:

    I will get a "Tab delimited" file from another team. That needs to be stored in the Clarity Server. I need to prepare a [s]process[s] [color=#ff0000]bit of code[color], which can read the file and
    prepare a XML template and then XOG it in the application.

    vadivu wrote:

    How to do this?
    How ever you like;
    [list]
    [*]you could build a VB macro in excel that interprets your data, formats the XML and calls XOG.
    [*]you could write a piece of code (in your favourite programming language) that parses the input file, builds the XML, calls XOG
    [*]you could do anything like that
    [list]
    (no Clarity processes / GEL involved at all).

    If you really believe that you do need to run this all from a Clarity process, then "yes" you need to get your file onto somewhere that the Clarity process can "see" - but, as I said above, I can't really help you there. :sad


  • 7.  RE: Need GEL for XOG from an Excel file

    Posted May 09, 2013 09:28 AM
    Thanks Dave. Actually the requirement is to automate the upload. Hence i can't go with VB Macros as that needs manual intrvention for every upload (i believe). Moreover the input file is going to be transferred to us via SFTP. Hence, they are not ready to use any macros before they share. Hence i need to go with the process only.

    Can anyone else please help me in this?.....


  • 8.  RE: Need GEL for XOG from an Excel file

    Posted May 09, 2013 09:46 AM

    vadivu wrote:

    Thanks Dave. Actually the requirement is to automate the upload. Hence i can't go with VB Macros as that needs manual intrvention for every upload (i believe). Moreover the input file is going to be transferred to us via SFTP. Hence, they are not ready to use any macros before they share. Hence i need to go with [s]the process[s] [color=#ff0000]some automated method, NOT necessarily a Clarity process[color].
    You are NOT restricted to a Clarity process as the control mechanism for an automated method and indeed this is giving you problems because of your ondemand service ; you can build "anything" automated on "any" of your systems in "any" technology that you have available.. which can then interface with your Clarity ondemand system via XOG.

    I think I've made the point enough times now, I'll stop! :grin:


  • 9.  Re: Need GEL for XOG from an Excel file

    Posted Mar 17, 2017 07:07 AM

    navzjoshi00 The links provided are now outdated.



  • 10.  Re: Need GEL for XOG from an Excel file