topic How I did alfresco-buisness reporitng in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/how-i-did-alfresco-buisness-reporitng/m-p/282427#M235557 <HTML><HEAD></HEAD><BODY><SPAN>Hi </SPAN><BR /><SPAN>After repeated trial and try I am now able to install ABR (Alfresco Business Reporting). The installation instruction given in the </SPAN><BR /><SPAN>&lt;url&gt; </SPAN><A href="http://code.google.com/p/alfresco-business-reporting/wiki/Home#Installation" rel="nofollow noopener noreferrer">http://code.google.com/p/alfresco-business-reporting/wiki/Home#Installation</A><SPAN> &lt;/url&gt;</SPAN><BR /><SPAN>&lt;url&gt;</SPAN><A href="https://code.google.com/p/alfresco-business-reporting/wiki/AdvancedInstallation#Configure_JNDI_in_Tomcat" rel="nofollow noopener noreferrer">https://code.google.com/p/alfresco-business-reporting/wiki/AdvancedInstallation#Configure_JNDI_in_Tomcat</A><SPAN> &lt;/url&gt; </SPAN><BR /><SPAN>are good and should be must refered, but it misses the point of where to keep the jar file "alfresco-business-reporting-share-0.8.0.1.jar". Now since I know how and where I did keep the jar and amp installation, I thought I will post it so that new comers like me can benift</SPAN><BR /><BR /><BR /><SPAN>This is done for alfresco 4.2.c (which has java 7) </SPAN><BR /><SPAN>(a) Install AMP </SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />java -jar /opt/alfresco/bin/alfresco-mmt.jar install /home/urname/Downloads/ABR/alfresco-business-reporting-explorer-0.8.0.1.amp&nbsp; /opt/alfresco/tomcat/webapps/share.war -verbose <SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>(b) copy the the jar file ie "alfresco-business-reporting-share-0.8.0.1.jar"&nbsp; to </SPAN><BR /><SPAN>&nbsp; &lt;b&gt; /opt/alfresco/tomcat/shared/lib/ &lt;/b&gt;</SPAN><BR /><BR /><SPAN>© create DB as given instruction in &lt;url&gt; </SPAN><A href="http://code.google.com/p/alfresco-business-reporting/wiki/Home#Create_your_Reporting_database" rel="nofollow noopener noreferrer">http://code.google.com/p/alfresco-business-reporting/wiki/Home#Create_your_Reporting_database</A><SPAN>&lt;/url&gt;</SPAN><BR /><SPAN>(d) For Alfresco CE 4.2.c , create&nbsp; alfresco.xml&nbsp; in "/opt/alfresco/tomcat/conf/Catalina/localhost/" with the following lines</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />&lt;?xml version="1.0" encoding="UTF-8"?&gt;<BR />&lt;Context&gt;<BR />&nbsp; &lt;Resource name="jdbc/alfrescoReporting" auth="Container"&nbsp;&nbsp;&nbsp; defaultTransactionIsolation="-1" defaultAutoCommit="false"&nbsp;&nbsp;&nbsp;&nbsp; maxActive="15" maxIdle="3" initialSize="1" <BR />&nbsp;&nbsp;&nbsp; username="alfresco" password="alfresco"&nbsp; url="jdbc:mysql://localhost:3306/alfrescoreporting"&nbsp; driverClassName="org.gjt.mm.mysql.Driver"&nbsp;&nbsp; type="javax.sql.DataSource" /&gt;<BR /> &lt;/Context&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>(e) Edit alfresco-global.properties </SPAN><BR /><BR /></BODY></HTML> Thu, 23 May 2013 08:54:33 GMT bisana 2013-05-23T08:54:33Z How I did alfresco-buisness reporitng https://connect.hyland.com/t5/alfresco-archive/how-i-did-alfresco-buisness-reporitng/m-p/282427#M235557 Hi After repeated trial and try I am now able to install ABR (Alfresco Business Reporting). The installation instruction given in the &lt;url&gt; http://code.google.com/p/alfresco-business-reporting/wiki/Home#Installation &lt;/url&gt;&lt;url&gt;https://code.google.com/p/alfresco-business-reporting/w Thu, 23 May 2013 08:54:33 GMT https://connect.hyland.com/t5/alfresco-archive/how-i-did-alfresco-buisness-reporitng/m-p/282427#M235557 bisana 2013-05-23T08:54:33Z Re: How I did alfresco-buisness reporitng https://connect.hyland.com/t5/alfresco-archive/how-i-did-alfresco-buisness-reporitng/m-p/282428#M235558 <HTML><HEAD></HEAD><BODY><SPAN>Hi, thanks for this post. Was your Alfresco installed with Postgresql or MySQL?</SPAN><BR /><BR /><SPAN>Also, the directory /tomcat/shared/lib doesn't exist on my installation so I created it and then put the .jar file in there, but on the UI I still do not see any additional features , such as execute the harvest. What am I supposed to see?</SPAN><BR /><BR /><SPAN>Thanks</SPAN></BODY></HTML> Tue, 20 Aug 2013 20:09:00 GMT https://connect.hyland.com/t5/alfresco-archive/how-i-did-alfresco-buisness-reporitng/m-p/282428#M235558 yuhuayang 2013-08-20T20:09:00Z