I want to include JMagallan in a PlugIn for our software, because a PivotTable is exactly what I want.
But I have two problems: I have no idea, how much effort it is to define an interface for our proprietary format, like an interface for SQL server or something similar. And how to do that is also mysterious for me at this time.
And I dont´t know how to start JMagallan, because if I try that, I always get errors before the software is really starting. Is there anyone, who can give me qualified informations?
Integrating JMagallanes to SQL Server or any other database system it’s an easy task. You just need to write the SQL query and the “Create report from SQL” wizard tool will help you create the necessaries XML files. In the docs section you can download a video that demonstrate the usage of this wizard (http://jmagallanes.sourceforge.net/en/docs.htm). If you have a more particular question you may contact us by mail.
For the second question we will need more information about the errors you get. If you didn’t try with the latest version, please download JMagallanes 1.0 standalone, uncompress it and try executing it. If you get an error in this procedure please post it.
Juan Ignacio Bassino
thanks for your fast reaction. As I described above, I don´thave an SQL Server, but something very different (we have a special "database"-similar file-format, which is for data-mining). I am wondering, how to make a interface for JMagallan to our file-format, and how to tell JMagallan, how the hierarchies of a dimension is defined.
If your database has JDBC connectivity, and can execute SQL, you just use it as if it were any other DDBB (for example, HSQL is file-based and has this features).
If it doesn’t, you may extend a new class from ReportDataSource that implements the data gathering as needed (see for example ExcelReportDataSource for an implementation of excel sources).
I tried to start "ReportViewerApp", but got the following message:
Exception in thread "main" SRC.com.calipso.reportgenerator.common.InfoException: Archivo no encontrado: ReportGeneratorConfiguration.properties, ./ReportGeneratorConfiguration.properties
Caused by: SRC.com.calipso.reportgenerator.common.InfoException: 372
... 2 more
Caused by: org.apache.commons.configuration.ConfigurationException: Cannot locate configuration source ReportGeneratorConfiguration.properties
... 3 more
I set the path to MISC/StandAloneApp, and got an error-window: The title is "582", the text is "583"
Set the path to the folder where the startup and jar files are located. There you will find the ReportGeneratorConfiguration, and the application will find the English translation file (the numbers "582" and "583" appear because those codes couldn’t be translated).
Juan I. Bassino,
I don´t find that really easy to get it started. I put all together in a eclipse-project, and then - for example for the StandAloneConfig: C:\Eclipse\workspace\JMagallanes\MISC\StandAloneConfig
I also exported in that directory the jar-file with ReportViewerApp as main-class, and copied the en.properties-file in that directory. But still I got that problem with not non-translatable codes.
In ReportGeneratorConfiguration.properties you should have a property like:
In that path the application looks for the language files. You should copy this directory from the standalone deploy files whit the en.properties file in it.
Also check that your working path is set to “C:\Eclipse\workspace\JMagallanes\MISC\StandAloneConfig” because there is your properties file.
Juan I. Bassino,
Log in to post a comment.
Sign up for the SourceForge newsletter:
You seem to have CSS turned off.
Please don't fill out this field.