Thursday 2 May 2013

How to Upload File to Pentaho server

1) Create a java servelet to upload file
 
2)write its suppoting JSP files

3) paste the class file at following path
biserver-ce-4.8.0-stable/biserver-ce/tomcat/webapps/webapps/FileUploadServletExample/WEB-INF/classes/net/codejava/upload/

4)paste JSP file on
biserver-ce-4.8.0-stable/biserver-ce/tomcat/webapps/webapps/FileUploadServletExample/upload.jsp

5) go to web.xml

biserver-ce-4.8.0-stable/biserver-ce/tomcat/webapps/pentaho/WEB-INF/web.xml

enter following code in web.xml


<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
    xmlns="http://java.sun.com/xml/ns/javaee"
    xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"
    xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
        http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"
    id="WebApp_ID" version="2.5">
  <display-name>FileUploadServletExample1</display-name>
  
  <servlet>
    <display-name>FileUploadServlet</display-name>
    <servlet-name>FileUploadServlet</servlet-name>
    <servlet-class>net.codejava.upload.FileUploadServlet</servlet-class>
  </servlet>
  
  <servlet-mapping>
    <servlet-name>FileUploadServlet</servlet-name>
    <url-pattern>/uploadFile</url-pattern>
  </servlet-mapping>
    
  <welcome-file-list>
    <welcome-file>upload.jsp</welcome-file>
  </welcome-file-list>
</web-app>

Now get Uploaded file from 
../biserver-ce-4.8.0-stable/biserver-ce/tomcat/webapps/webapps/FileUploadServletExample/upload folder



6)Now create transformation which take file as input from specified location
i.e
./biserver-ce-4.8.0-stable/biserver-ce/tomcat/webapps/webapps/FileUploadServletExample/upload/foo.xls

7)create xaxtion file to run ur transformation or Job

8)publish that xaction to the biserver

9)Now create a html link on upload .jsp to run that xaction file on click

10) Now dump that transformed file to the same loaction

11)create a html link for that xls file in uplaod.jsp

12)download the transformed file using link

for help mail me:-
spectrumon@gmail.com

Or Download zip file where all done   :)  :)

<a href="https://docs.google.com/file/d/0B_j1hJxesvxdMGh5Y3ZwS1pXQTA/edit?usp=sharingl">Download All done</a>






No comments:

Post a Comment