Clarity

Expand all | Collapse all

Writing file to a specific location using GEL script

  • 1.  Writing file to a specific location using GEL script

    Posted 08-21-2018 07:11 AM

    Hi,

     

    I am creating a process in CA PPM which fetches data from DB and writes it to a file. I am using the tag <file:writeFile delimiter="," fileName="xxxx.csv">. I see that the file is getting created in the BIN folder. Is there any way to change the destination or any attribute to specify the path where the file should get created?

     

    Thanks in advance,
    Abilash Muraleedharan



  • 2.  Re: Writing file to a specific location using GEL script

    Posted 08-21-2018 07:37 AM

    Hi Abilash, 

     

    Could you please check this one? Hopefully you might get some lead from here, as you are also trying to create a CSV file. 

     

    Gel Script: How to Generate a CSV 

     

    Hope that helps. 

     

    Cheers. 



  • 3.  Re: Writing file to a specific location using GEL script

    Posted 08-22-2018 03:09 AM

    Hi Abhisek,

    Thanks for the link, it was indeed useful. I am not sure it will be possible, but I am curious to know if the file can be written in other servers or any particular server(in case we have many servers having BG).

     

    Thanks,
    Abilash



  • 4.  Re: Writing file to a specific location using GEL script

    Posted 08-21-2018 07:37 AM

    Try providing the File name like this: <file:writeFile fileName="C:\filestore\processes\resourceData.csv" delimiter="," embedded="false">



  • 5.  Re: Writing file to a specific location using GEL script

    Posted 08-22-2018 03:07 AM

    Thanks Jeevan. That helped me.