topic Re: Enterprise Report Services for Alfresco 1.0 Preview Released in Alfresco Archive

Enterprise Report Services for Alfresco 1.0 Preview Released

turgayz — Wed, 04 Oct 2006 09:37:20 GMT

You can install and run the 1.0 Preview release of the "Enterprise Report Services for Alfresco" from the forge at http://forge.alfresco.com/projects/report-services/There is also a demo server running on http://vardar.no-ip.biz:8080/alfresco You can connect with user demo, password demo. There are

Re: Enterprise Report Services for Alfresco 1.0 Preview Released

turgayz — Tue, 10 Oct 2006 14:52:12 GMT

In the 1.0_RC1 release, new additions are:

- Bug fixes
- More than 1 report schedule can be added to a space.
- Report schedules added to a space can be updated/deleted.
- Initial Jasper Reports support.

Re: Enterprise Report Services for Alfresco 1.0 Preview Released

mdsahni — Wed, 18 Oct 2006 14:29:15 GMT

Hey,

We are quite interested in this reporting stuff, as our project consists of lot of data entry and then reporting that we would like to display through Alfresco. We are working on Pentaho, any plans to provide support for this in your work.

Thanx in advance.

Regards,
Deep

Re: Enterprise Report Services for Alfresco 1.0 Preview Released

turgayz — Thu, 19 Oct 2006 14:59:54 GMT

Hi Deep,
We don't have experience with Pentaho, so we may have a look at this possibility after we release 1.0 of Report Services.

Re: Enterprise Report Services for Alfresco 1.0 Preview Released

mdsahni — Fri, 20 Oct 2006 01:47:22 GMT

No problem man,

We selected Pentaho because we found it better than BIRT and Jasper in many ways. Anyways, when we start working on this, I'll keep you updated on our development, so that you can also gain and we can do this together.

Keep up the good work!!

Regards,
Deep

Re: Enterprise Report Services for Alfresco 1.0 Preview Released

fselendic — Fri, 20 Oct 2006 16:31:57 GMT

No problem man,

We selected Pentaho because we found it better than BIRT and Jasper in many ways. Anyways, when we start working on this, I'll keep you updated on our development, so that you can also gain and we can do this together.

Keep up the good work!!

Regards,
Deep

Count us in, we just started with Pentaho, after a looong (to long) time looking at it. So far, so good, however, the more, the merrier. Unfortunatelly, we probably won't have resources to help with possible integration until 2007.

Re: Enterprise Report Services for Alfresco 1.0 Preview Released

revnouz — Wed, 13 Dec 2006 11:39:57 GMT

where are the report definition files now?

btw, we are also looking at Pentaho

Re: Enterprise Report Services for Alfresco 1.0 Preview Released

revnouz — Thu, 14 Dec 2006 06:29:25 GMT

*bump*

Re: Enterprise Report Services for Alfresco 1.0 Preview Released

rdanner — Fri, 15 Dec 2006 03:21:44 GMT

*bump*

Have you seen pentaho's kettle product? Its an ETL tool. I am currently thinking about all the neat things we might be able to enable with a JCR source and destination or even alfresco foundation apis.

cool stuff - very interesting product

Re: Enterprise Report Services for Alfresco 1.0 Preview Released

senthil_chinnai — Fri, 02 Feb 2007 09:21:24 GMT

Hi I am not able to access the demo url.

Could you please share me some report definition files?

Thanks,
Senthil.

Re: Enterprise Report Services for Alfresco 1.0 Preview Released

snig — Thu, 17 Jun 2010 07:28:49 GMT

There is also a demo server running on http://vardar.no-ip.biz:8080/alfresco You can connect with user demo, password demo. There are some report definition files just under the Company Home space, which you can try to run reports. You can use the space called demoSpace for trial.

Is the demo server still valid?
I can open the URL, however, it does not accept user credentials demo/demo.

Any updates?

Re: Enterprise Report Services for Alfresco 1.0 Preview Released

rafaelscg — Wed, 07 Jul 2010 18:16:39 GMT

Hi,

Im trying to configuring the report extension with alfresco.

Alfresco Enterprise 3.2 and MySQL Database is used for this project. The zips of this project is download (1.0_RC2 for Alfresco 3.2 and 1.0_Preview).
By running Ant command alfresco.war was update with successfull. When i start alfresco server, i have this exception:

14:51:14,634  ERROR [web.context.ContextLoader] Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean wit
h name 'tr.biz.vardar.reporting.metadata.BirtDefinitionMetaDataExtractor' define
d in URL [jar:file:/C:/Alfresco/tomcat/webapps/alfresco/WEB-INF/lib/alfresco-rep
ort-engine.jar!/alfresco/extension/reporting-context.xml]: Error setting propert
y values; nested exception is org.springframework.beans.NotWritablePropertyExcep
tion: Invalid property 'dictionaryService' of bean class [tr.biz.vardar.reportin
g.metadata.BirtDefinitionMetaDataExtractor]: Bean property 'dictionaryService' i
s not writable or has an invalid setter method. Does the parameter type of the s
etter match the return type of the getter?
Caused by: org.springframework.beans.NotWritablePropertyException: Invalid prope
rty 'dictionaryService' of bean class [tr.biz.vardar.reporting.metadata.BirtDefi
nitionMetaDataExtractor]: Bean property 'dictionaryService' is not writable or h
as an invalid setter method. Does the parameter type of the setter match the ret
urn type of the getter?‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Can you have any idea what i have to do?

Best redargs

Re: Enterprise Report Services for Alfresco 1.0 Preview Released

rafaelscg — Wed, 07 Jul 2010 18:39:53 GMT

Actually i have this message before the Exception in last post:


15:36:32,403 User:System ERROR [vardar.reporting.ReportingSystem] class org.springframework.dao.InvalidDataAccessResourceUsageException—could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
07/07/2010 15:36:35 org.eclipse.birt.report.engine.api.impl.ReportEngine <init>FINE: ReportEngine created. EngineConfig: EngineConfig: org.eclipse.birt.report.engine.api.EngineConfig.scriptObjects={};BIRT_HOME=C:/tools/birt-runtime/ReportEngine;logLevel=FINE;PLATFORM_CONTEXT=org.eclipse.birt.core.framework.PlatformFileContext@198f08c;org.eclipse.birt.report.engine.api.EngineConfig.emitterConfigs=
{html=org.eclipse.birt.report.engine.api.HTMLEmitterConfig@1d88788};logDest=<nul
l>;
‍‍‍‍‍‍

Please, i really need to resolve this problem because for our new project, reports will be essencial.

Thanks

Re: Enterprise Report Services for Alfresco 1.0 Preview Released

rafaelscg — Wed, 28 Jul 2010 20:53:56 GMT

The problem of instalation is resolved.
But now i have other question/problem. I create webscript and this give XML response for report.
When i run the report on Eclipse IDE, everething works fine and i can see all datas what i want. But when i try to run the report from Alfresco (PDF or HTML), the PDF/HTML was created but without datas, only put the headers.

Anyone have ideas about this?

Thanks

Re: Enterprise Report Services for Alfresco 1.0 Preview Released

ati_dip1982 — Fri, 14 Jan 2011 10:26:43 GMT

*bump*

Have you seen pentaho's kettle product? Its an ETL tool. I am currently thinking about all the neat things we might be able to enable with a JCR source and destination or even alfresco foundation apis.

cool stuff - very interesting product

…
are you guys working on report defination for alfresco 3.4 community??

Re: Enterprise Report Services for Alfresco 1.0 Preview Released

n_pancholi87 — Mon, 21 Feb 2011 12:24:19 GMT

Hey…I am trying to integrate Alfresco with reporting tools using similar approach..

Facing an error regarding a jar file named "tr.biz.vardar.reporting.metadata.BirtDefinitionMetaDataExtractor"…

ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'tr.biz.vardar.reporting.metadata.BirtDefinitionMetaDataExtractor' defined in URL [jar:file:/home/nidhi/Download/alfresco%203.2/alfresco-community-tomcat-3.2/tomcat/webapps/alfresco/WEB-INF/lib/alfresco-report-engine.jar!/alfresco/extension/reporting-context.xml]: Error setting property values; nested exception is org.springframework.beans.NotWritablePropertyException: Invalid property 'dictionaryService' of bean class [tr.biz.vardar.reporting.metadata.BirtDefinitionMetaDataExtractor]: Bean property 'dictionaryService' is not writable or has an invalid setter method. Does the parameter type of the setter match the return type of the getter?
Caused by: org.springframework.beans.NotWritablePropertyException: Invalid property 'dictionaryService' of bean class [tr.biz.vardar.reporting.metadata.BirtDefinitionMetaDataExtractor]: Bean property 'dictionaryService' is not writable or has an invalid setter method. Does the parameter type of the setter match the return type of the getter?

Pls help..
I am using Alfresco 3.2

Re: Enterprise Report Services for Alfresco 1.0 Preview Released

otieno — Wed, 05 Oct 2011 07:06:43 GMT

Which credentials should i use cause demo,demo is not granting me access.
Regards

Re: Enterprise Report Services for Alfresco 1.0 Preview Released

gaurav_shirbhat — Mon, 08 Oct 2012 06:49:22 GMT

I am new to alfresco.
1. Reports in alfresco is created for content information. am i right?
2. weather report is generated automatically or we have to create reports.
3. please tell me how to create reports in alfresco.

Re: Enterprise Report Services for Alfresco 1.0 Preview Released

gaurav_shirbhat — Mon, 08 Oct 2012 10:22:43 GMT

please help me i am new to alfresco.
how to create ftl file in alfresco.