Clarity

Expand all | Collapse all

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

navzjoshi0002-02-2016 06:21 AM

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

    Broadcom Employee
    Posted 02-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 K 1 version


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

    Posted 02-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)

    Former Employee
    Posted 02-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 07-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 04-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 05-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 09-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 09-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 11-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 11-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 11-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 11-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 09-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 09-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 09-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 09-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.