Clarity

 View Only
Expand all | Collapse all

Tech Tip: How to Enable Jaspersoft Scheduled Report Output to FTP (On Premise Only)

navzjoshi00

navzjoshi00Feb 02, 2016 06:21 AM

  • 1.  Tech Tip: How to Enable Jaspersoft Scheduled Report Output to FTP (On Premise Only)

    Broadcom Employee
    Posted Feb 01, 2016 04:55 PM
      |   view attached

    By default, when Jaspersoft server is installed with Clarity PPM, you will not be able to schedule the reports' output to be exported to FTP. This option is disabled by default.

    The only available option by default is Output to Repository:

     

     

    However, for On Premise customers, it is possible to enable back the option to export to FTP.

     

    To do this, you have to follow the steps below:

     

    1. Connect to your Jaspersoft server and open the following file with a text editor:
    $JSTomcat\webapps\reportservice\WEB-INF\jsp\modules\reportScheduling\tab.output.jsp

     

    2. Find and uncomment the section that refers to Output to FTP (ftpServerOutput). 
    If you're on PPM 14.3 it's located at line 396.
    If you're on PPM 14.2 it's located at line 367.

    To uncomment, you have to remove the following symbols:

    <!--
    -->

    Quick example:

    <!--
    <li id="ftpServerOutput" class="leaf">
    […….]
    </ul>
    </li> -->
    

    has to become:

    <li id="ftpServerOutput" class="leaf">
    […….]
    </ul>
    </li>
    

    You may also uncomment the testConnection button for the ftp, which comes just after the ftpServerOutput section in the file.  These are including the comment in the tag itself, see below how to uncomment it:

     

    <!--fieldset id="testConnection" class="group inputSet">
    […] 
      </fieldset-->
    

    has to become:

    <fieldset id="testConnection" class="group inputSet">
    […] 
      </fieldset>
    

    For more information on how exactly to do it, please refer to the attached file.

     

    3. Once you uncomment the sections, please save the file and restart the Tomcat service. Repeat for all the servers in Jaspersoft cluster. This will enable the Output to FTP.

     

     

    Once you have enabled the Output to FTP with the steps above,to schedule the report, please do the following:


    1. Connect to PPM - go to Advanced Reporting
    2. Select a report, right-click to Schedule
    3. Click Create Schedule
    4. Go to Output Options

    You will now have the following option to fill in and use (and you also have a Test Connection button to ensure it will work):

     

    You may schedule your reports and find the output in the FTP directory of your choice.

     

     

    Hope this helps.

     

     

     

    Kind Regards

     

    Nika Hadzhikidi
    CA Technologies
    Principal Support Engineer

    Attachment(s)

    zip
    tab.output.jsp.zip   3 KB 1 version


  • 2.  Re: Tech Tip: How to Enable Jaspersoft Scheduled Report Output to FTP (On Premise Only)

    Posted Feb 02, 2016 06:21 AM

    Thanks for sharing this, Nika

     

    Regards

    NJ



  • 3.  Re: Tech Tip: How to Enable Jaspersoft Scheduled Report Output to FTP (On Premise Only)

     
    Posted Feb 02, 2016 01:30 PM

    Thanks for the tip Nika!

    NIKA HADZHIKIDI wrote:

     

    By default, when Jaspersoft server is installed with Clarity PPM, you will not be able to schedule the reports' output to be exported to FTP. This option is disabled by default.

    The only available option by default is Output to Repository:

     

     

    However, for On Premise customers, it is possible to enable back the option to export to FTP.

     

    To do this, you have to follow the steps below:

     

    1. Connect to your Jaspersoft server and open the following file with a text editor:
    $JSTomcat\webapps\reportservice\WEB-INF\jsp\modules\reportScheduling\tab.output.jsp

     

    2. Find and uncomment the section that refers to Output to FTP (ftpServerOutput). 
    If you're on PPM 14.3 it's located at line 396.
    If you're on PPM 14.2 it's located at line 367.

    To uncomment, you have to remove the following symbols:

    <!--
    -->

    Quick example:

    1. <!-- 
    2. <li id="ftpServerOutput" class="leaf"> 
    3. […….] 
    4. </ul> 
    5. </li> --> 

    has to become:

    1. <li id="ftpServerOutput" class="leaf"> 
    2. […….] 
    3. </ul> 
    4. </li> 

    You may also uncomment the testConnection button for the ftp, which comes just after the ftpServerOutput section in the file.  These are including the comment in the tag itself, see below how to uncomment it:

     

    1. <!--fieldset id="testConnection" class="group inputSet"> 
    2. […]  
    3.   </fieldset--> 

    has to become:

    1. <fieldset id="testConnection" class="group inputSet"> 
    2. […]  
    3.   </fieldset> 

    For more information on how exactly to do it, please refer to the attached file.

     

    3. Once you uncomment the sections, please save the file and restart the Tomcat service. Repeat for all the servers in Jaspersoft cluster. This will enable the Output to FTP.

     

     

    Once you have enabled the Output to FTP with the steps above,to schedule the report, please do the following:


    1. Connect to PPM - go to Advanced Reporting
    2. Select a report, right-click to Schedule
    3. Click Create Schedule
    4. Go to Output Options

    You will now have the following option to fill in and use (and you also have a Test Connection button to ensure it will work):

     

    You may schedule your reports and find the output in the FTP directory of your choice.

     

     

    Hope this helps.

     

     

     

    Kind Regards

     

    Nika Hadzhikidi
    CA Technologies
    Principal Support Engineer



  • 4.  Re: Tech Tip: How to Enable Jaspersoft Scheduled Report Output to FTP (On Premise Only)

    Posted Jul 12, 2016 10:51 AM

    Hi All,

                FYI - Steps to enable the option to export to FTP for On Premise customers, are no longer valid for Jaspersoft v6.2.1. This is because Jaspersoft has changed the way they used to handle this in previous versions vs Jaspersoft v6.2.1.

     

    Thank You!!

    Namita Mishra



  • 5.  Re: Tech Tip: How to Enable Jaspersoft Scheduled Report Output to FTP (On Premise Only)

    Posted Apr 25, 2017 10:53 PM

    What would be new steps in this case?



  • 6.  Re: Tech Tip: How to Enable Jaspersoft Scheduled Report Output to FTP (On Premise Only)

    Posted May 10, 2017 05:37 PM

    We are 6.1.5 so we had no trouble enabling this option. And we wanted to switched-on Output to File System and not FTP. Learned that there are 2 file which requires change.

    1) tab.output.jsp ($JSTomcat\webapps\reportservice\WEB-INF\jsp\modules\reportScheduling\)

    Uncommented two tag similar to explained above. (        <li id="fileSystemOutput" class="leaf"> and     <li id="ftpServerOutput" class="leaf">)

    2) applicationContext.xml ($JSTomcat\webapps\reportservice\WEB-INF\WEB-INF\)

    <property name="enableSaveToHostFS" value="true"/>



  • 7.  Re: Tech Tip: How to Enable Jaspersoft Scheduled Report Output to FTP (On Premise Only)

    Posted Sep 06, 2017 11:39 AM

    Hi Nika,

     

    We are in version 6.2.1 and the above instructions are no longer working as this file  tab.output.jsp ($JSTomcat\webapps\reportservice\WEB-INF\jsp\modules\reportScheduling\) is no longer there.

     

    Can you please tell me what are the new instructions for the same?



  • 8.  Re: Tech Tip: How to Enable Jaspersoft Scheduled Report Output to FTP (On Premise Only)

    Broadcom Employee
    Posted Sep 07, 2017 08:54 AM

    Hi Venu

                FYI - Steps to enable the option to export to FTP for On Premise customers, are no longer valid for Jaspersoft v6.2.1. This is because Jaspersoft has changed the way they used to handle this in previous versions vs Jaspersoft v6.2.1.

     

    Regards

    Suman Pramanik 



  • 9.  Re: Tech Tip: How to Enable Jaspersoft Scheduled Report Output to FTP (On Premise Only)

    Posted Nov 15, 2017 09:45 AM

    What is the steps for JS6.2.1(Clarity 15.3)?

     

    Thanks,

    Shiva



  • 10.  Re: Tech Tip: How to Enable Jaspersoft Scheduled Report Output to FTP (On Premise Only)

    Broadcom Employee
    Posted Nov 15, 2017 09:53 AM

    There are no available steps to enable the export to FTP on 6.2.1. as the Jaspersoft design have changed. I strongly advise raising an idea here in the Ideas section so this gets reviewed and considered to be included in the product. Currently there are important files impacted so the risk is high to apply any changes. This is why we decided to no longer recommend it.



  • 11.  Re: Tech Tip: How to Enable Jaspersoft Scheduled Report Output to FTP (On Premise Only)

    Posted Nov 15, 2017 09:06 PM

    Is there any option to have default output folder inside the JS repository? 



  • 12.  Re: Tech Tip: How to Enable Jaspersoft Scheduled Report Output to FTP (On Premise Only)

    Posted Nov 16, 2017 08:52 AM

    you can use the REST API or Import option to use this functionality in the backend, however you will not be able to see the output folder in the UI



  • 13.  RE: Re: Tech Tip: How to Enable Jaspersoft Scheduled Report Output to FTP (On Premise Only)

    Posted Sep 21, 2020 09:27 AM
    Hi There,

    I verified the documentation from Tibco JasperSoft for our current Clarity 15.6 with JS 7 release, and it states that " enableSaveToHostFS " is still the right place to enable file system export from scheduler.

    Nevertheless enabling the flag ("true") does not change anything in the UI (after restart of JS) ...

    Does somebody know how to activate Scheduler File System Output (on premise)?

    Best regards!
    Sebastian

    ------------------------------
    PPM specialist
    -
    ------------------------------



  • 14.  RE: Re: Tech Tip: How to Enable Jaspersoft Scheduled Report Output to FTP (On Premise Only)

    Broadcom Employee
    Posted Sep 21, 2020 09:30 AM
    Hi Sebastian

    Raise a case and we will be able to provide you a solution. If you have raised share the case number

    ------------------------------
    Thanks & Regards
    Suman Pramanik
    Sr. Principal Support Engineer | Customer Success & Support, Enterprise Software Division
    Broadcom
    ------------------------------



  • 15.  RE: Re: Tech Tip: How to Enable Jaspersoft Scheduled Report Output to FTP (On Premise Only)

    Posted Sep 21, 2020 10:51 AM
    Hi Suman,

    many thanks, I will do.


    Best regards,
    Sebastian

    ------------------------------
    PPM specialist
    -
    ------------------------------



  • 16.  RE: Re: Tech Tip: How to Enable Jaspersoft Scheduled Report Output to FTP (On Premise Only)

    Posted Sep 24, 2020 02:36 PM
    Looking for this functionality to be able to store output on server file system instead of repository. I know oob jasper provides this option.

    Can someone help if you know how to enable this one?

    Thanks in advance.


  • 17.  RE: Re: Tech Tip: How to Enable Jaspersoft Scheduled Report Output to FTP (On Premise Only)

    Posted Jun 12, 2023 10:39 AM

    Hello, I need to uncheck the option "Output To Repository" by default in Clarity jaspersoft 8.1.1 version On Premise, do you know if it's possible ? regarding this article "https://community.jaspersoft.com/wiki/disable-tibco-jasperreports-server-scheduler-output-repository-option", I updated the code in chunk.3223.js file located in apache-tomcat-9.0.68/webapps/reportservice/scripts/_chunks but it does not work. Thanks for your help ! Regards,

    <input id="scheduler_outputToRepository" type="checkbox" name="outputToRepository">

    to

    <input id="scheduler_outputToRepository" type="checkbox" name="outputToRepository" disabled>




  • 18.  RE: Re: Tech Tip: How to Enable Jaspersoft Scheduled Report Output to FTP (On Premise Only)

    Posted Jul 18, 2023 03:15 AM
    Edited by Uwe Kerntopf Jul 18, 2023 03:16 AM

    One of my customers is also requesting this standard functionality. Broadcom is denying it due to security reasons. 
    This argument may be valid for SaaS customers but not for On Premise customers. Because these customers are responsible for their security by themselves.
    For JS 7.1 Broadcom provided a solution. 2 files had to be changed/replaced. scheduler.js in .<TOMCAT>/webapps/<REPORTSERVICE>/optimized-scripts/schedulerPro and applicationContext.xml in <TOMCAT>/webapps/<REPORTSERVICE>/WEB-INF.

    I'm happy to see that somebodý else is requesting this standard functionality back, the argument so long also was, that I'm the only one ...



    ------------------------------
    Senior Technical Consultant
    Fujitsu Technology Solutions GmbH
    Germany
    ------------------------------