Jump to content
Changes to the Jaspersoft community edition download ×

gautier

Members
  • Posts

    28
  • Joined

  • Last visited

 Content Type 

Profiles

Forum

Events

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Downloads

Everything posted by gautier

  1. Hi Got similar issue. It's not a bug on the installer. I was using SSH to install JasperReportsServer remotely. SSH does transmit your computer locale : so the installer won't use the server locale. Tying to setup server's local won't help. You need to change SSH configuration to not transmit your locale. Edit /etc/ssh/ssh_config and comment out SendEnv LANG LC_* (for Mac OS X) : The file to change is here /etc/ssh_config If the problem persists : (it depends on your OS installation)on your remote server Edit /etc/bash.bashrcetc/bash.bashrc and add these line at the bottom of the file # Helping postgres install export LANGUAGE=en_US.UTF-8 export LANG=en_US.UTF-8 export LC_ALL=en_US.UTF-8 All those settings will be applied once you will login again. Run the JasperReprotServer installer again and you should be fineHope this helps
  2. Hi Got similar issue. It's not a bug on the installer. I was using SSH to install JasperReportsServer remotely. SSH does transmit your computer locale : so the installer won't use the server locale. Tying to setup server's local won't help. You need to change SSH configuration to not transmit your locale. Edit /etc/ssh/ssh_config and comment out SendEnv LANG LC_* (for Mac OS X) : The file to change is here /etc/ssh_config If the problem persists : (it depends on your OS installation)on your remote server Edit /etc/bash.bashrcetc/bash.bashrc and add these line at the bottom of the file # Helping postgres install export LANGUAGE=en_US.UTF-8 export LANG=en_US.UTF-8 export LC_ALL=en_US.UTF-8 All those settings will be applied once you will login again. Run the JasperReprotServer installer again and you should be fineHope this helps
  3. Talend is Eclipse based and uses plugins to extend its capabilities. This means we can build a plugin to contain all of our components to make them easily installable. Benefits of building a plugin for Talend: Keep all your components togetherEasier to share and deliverSelf-containedEasier to centralize common resources (jar,images,..)Advanced customizations (javajet)Understand Plugins through Reverse EngineeringProbably the best way to understand how plugins work in Talend’s context is to open one of the existing plugins. You can find all the plugins in the folder: [JETL_INSTALL_DIR]/plugins One good example of a plugin for providing components is org.talend.designer.esb.components.rs.consumer_5.5.1.r118616 (name may change depending on your JETLversion). This plugin contains the tRestClient component. If you are curious you can also have a look to this folder: org.talend.designer.components.localprovider_5.5.1.r118616. It contains all the basic components of JETL. Talend Designer ESB Tooling REST Service consumer plug-in Browse the folder : You should see this structure: additional: contains javajet filescomponents: contains the components to be added to TOSMETA-INF: contains the MANIFEST.MForg: is the root package of java classes used to extend Talendplugin.properties: is a property file defining vendor and plugin nameplugin.xml: tells Eclipse what how to handle the plugin, what are the points of extension and which classes provide the extensionCreate a Plugin projectAs Talend doesn't expose Eclipse feature to build plugins so we’ll need to use a proper Eclipse instance to build one. Open an Eclipse instance (not JETL) Click on the menu File > New.. > Other Select Plug-in Project Configure the new project name and setting Configure Advanced plugin properties Id: Make sure to use a relevant Id, this will be used to reference your plugin from component’s xml configuration (as example to import a common jar stored in the plugin)Execution Environment: This should match the design Environment, so where TOS is installed. Anyway is always best to use the minimum java version needed for your custom code to run, especially if you will share the plugin (of course you will J)Activator Class: this class is very important, so choose a meaningful package name. We’ll need to work on it later on. You can also call this “MyOwnPlugin”.Uncheck “Create a plug-in using one of the templates Click Finish Import the Talend core pluginIn order to build a talend plugin we need to define some dependencies with talend plugins in our brand new one. To do so we need to have these plugins in our Eclipse. In Eclipse select from menu File > Import… In the Import From section select Directory and browse the plugins folder of TOS Click Next In the plugin selection you can use the field to filter for strings like “talend.core” Select the plugin: org.talend.core from the left area and click “Add” Click on Finish Create Java classes for Talend extension pointsActivator classThe Activator class was automatically generated from the wizard. We just need to add another method: Activator.getStatus(String message, Throwable e)public static IStatus getStatus(String message, Throwable e) { String msg = e.getMessage() != null ? e.getMessage() : message != null ? message : e.getClass().getName(); return new Status(4, getDefault().getBundle().getSymbolicName(), msg, e); }[/code]So at the end your class should look something like this: MyCustomPlugin.javapackage org.mycompany.talend.component;import org.eclipse.core.runtime.IStatus;import org.eclipse.core.runtime.Status;import org.eclipse.ui.plugin.AbstractUIPlugin;import org.osgi.framework.BundleContext;public class MyCustomPlugin extends AbstractUIPlugin { public static MyCustomPlugin getDefault() { return plugin; } // The plug-in ID public static final String PLUGIN_ID = "MyPluginProjectId"; //$NON-NLS-1$ // The shared instance private static MyCustomPlugin plugin; /** * The constructor */ public MyCustomPlugin() { } /* * (non-Javadoc) * * @see * org.eclipse.ui.plugin.AbstractUIPlugin#start(org.osgi.framework.BundleContext * ) */ public void start(BundleContext context) throws Exception { super.start(context); plugin = this; } /* * (non-Javadoc) * * @see * org.eclipse.ui.plugin.AbstractUIPlugin#stop(org.osgi.framework.BundleContext * ) */ public void stop(BundleContext context) throws Exception { plugin = null; super.stop(context); } public static IStatus getStatus(String message, Throwable e) { String msg = e.getMessage() != null ? e.getMessage() : message != null ? message : e.getClass().getName(); return new Status(4, getDefault().getBundle().getSymbolicName(), msg, e); }}[/code]Component ProviderThe main purpose of this class is to point eclipse platform to the location of our custom components within the plugin. It extends org.talend.core.model.components.AbstractComponentsProvider. This abstract class is part of the talend core plugin. In order to have your project build in eclipse you’ll need to add the jar [JETL_INSTALL_DIR]/plugins/org.talend.core_5.4.1.r111943.jar to the project’s BuildPath Below a simple implementation: MyCustomComponentsProvider.javapackage org.mycompany.talend.component;import java.io.File;import java.net.URL;import org.eclipse.core.runtime.FileLocator;import org.eclipse.core.runtime.Path;import org.talend.core.model.components.AbstractComponentsProvider;public class MyCustomComponentsProvider extends AbstractComponentsProvider{ private File providedLocation = null; protected File getExternalComponentsLocation() { if (this.providedLocation == null) { MyCustomPlugin plugin = MyCustomPlugin.getDefault(); try { URL url = FileLocator.find(plugin.getBundle(), new Path("components"), null); url = FileLocator.toFileURL(url); this.providedLocation = new File(url.getPath()); } catch (Exception e) { plugin.getLog().log(MyCustomPlugin.getStatus(null, e)); } } return this.providedLocation; } public String getFamilyTranslation(String paramString) { return null; }}[/code]Referencehttp://www.powerupbi.com/talend/componentCreation_1.html
  4. Both problems are linked. It is due to windows 2008 and the installer. Try to do the install in a folder like c:\jasper (with all permissions needed) Hope this helps, Guillaume
  5. You can use MDX queries on the top of XML-A Datasources in JasperReports. About your other requirements i suggest you to have a look at the pro edition. Here is a demo of this features : http://www.jaspersoft.com/user/register?destination=node%2F603 Hope this helps, Guillaume
  6. Hi, I wrote the tutorial mentionned by regw prior to this release and this tutorial is now outdated. The jasperserver 3.7 release fully support cascading input controls.(In all editions including Community, Pro and Enterprise) If you installed the samples you will find in /reports/samples a sample for cascading parameters. More infos could be found here : http://jasperforge.org/plugins/mwiki/index.php/Jasperserver/Cascading_input_controls Hope this helps, Guillaume Post Edited by gautier at 02/22/2010 18:40
  7. Here is a zip file with install instruction on it witch fixes the problem. Hope this helps, Guillaume
  8. Hello, The class com.jaspersoft.jasperserver.api.metadata.user.domain.User exists only on the server so if you try to compile your report only with iReport this will not work. Try to upload your report in the server and then run it from the server. Hope this helps, Guillaume Post Edited by gautier at 01/10/2010 05:45
  9. Well, that the port you specify on the connexion string : ie 8181 if your connexion is as follow : http://MyServer:8181/jasperserver/services/repository Hope this helps, Guillaume
  10. Hi, You can use the REPORT_LOCALE parameter in your reports and sets it to the language you wish to use Guillaume
  11. This feature is not supported by static text as they do not understand expresion. You must use text fields Guillaume Post Edited by gautier at 12/08/2009 14:55
  12. Hello Have you add the ressource on the repository as well ? (see step 4,5,6 from internationalize report) Guillaume
  13. Hi I can recommand you to use JNDI connexion as they close unused session better and then specify the character set In META-INF directory edit context.xml Qdd the folowing ressource : <Resource name="jdbc/yourbase" auth="Container" type="javax.sql.DataSource" maxActive="100" maxIdle="30" maxWait="10000" username="youruser" password="yourpassword" driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://127.0.0.1:3306/yourbase?useUnicode=true&characterEncoding=Latin-1"/> On the jasperserver repository create a JNDI with jdbc/yourbase as a reference Hope this helps, Guillaume Post Edited by gautier at 12/08/2009 09:53
  14. Hello, Here is a complete tutorial about localization. http://www.jaspersoft.com/jasperserver-and-ireport-internationalization The last part talk specifically about localizing reports Hope this helps Guillaume
  15. Hello In the sample folder of jasperserver you will find a sample called java-web-app-sample that contains webservice client and sample for browsing repository and running reports. Hope this helps Guillaume
  16. Hi, Q: Is it possible to bind a Domain with multiple data sources (for example two Oracle DBs)? R: You can use derived tables : - Create a derived table with the name of your secound database in the query (Select * From MYDB.MYTABLE ...) - If your credentials for your database connection allows you to do so. One other solution is to look at virtual database tools such as teiid : http://www.jboss.org/teiid Q: is it possible to create a multiple (cross)table-report in iReport? I mean two or more (cross-)tables, each with different queries on the same report? R: Yes, you can do it with iReport. You must create one 'dataset' per cross tables. Each dataset contain their own query and then you can create as many cross tables as you want in your report Q: When I export it to xls, I am not getting all the attributes on the same row, but after the 6. one always on the down part of the excel file. R: Have you setup the page size to actual size in the ad'hoc editor ?(see screenshot attached) Hope this helps, Guillaume Post Edited by gautier at 12/03/2009 08:50
  17. Hello In the scheduler you have an option to skip empty reports See screenshot Hope this helps Guillaume
  18. Hi, The root password of the bundled MySQL is : password Regards, Guillaume
  19. Hi, This file is availlable only for paying customers in the support portal. Send a message to sales@jaspersoft.com mentioning your company name and location so we could assign you a sales representative. Regards, Guillaume
  20. What is the character set of your database ? Maybie you should specify it in the connection string of your JDBC datasrouce
  21. Yes, it is exactly that. But as databases vendors have different syntaxes (ie LIMIT in MySQL) you had to put your formula in the SQLGenerator supported by your database engine. Of course the same formula name could be written for different SQLgenerators such as CONCAT formula. So your formula might be more or less database agnostic. Regards, Guillaume
  22. Can you try to create a aditional folder in ad'hoc component/topic and then copy your topic. Then try to edit it again ... It is really strange behavior ...
  23. Calculated fields doesn't support that kind of statements like this. You should create your custom formula in the calculated fields. Here is how to create this : Stop Jasperserver - Edit applicationContext-semanticLayer.xml (could be found in <jasperserver-install>jasperserverpro WEB-INF) - Find the SQLGenerator that matches the database engine used by the domain. For MySQL locate this line : <bean id="defaultSQLGenerator" class="com.jaspersoft.commons.semantic.dsimpl.SQLGenerator" scope="prototype"> Then add your formula in this bean : it should be represented like this : <entry key="MagicFunction"> <value> "your expression" </value> Note :use sqlArgs[0] for first value in your formula, then sqlArgs[1] for the second and so ... </entry> - save and restart server Now in domains : create a calculated field using your fomula : MagicFunction(field1,field2...) Here is a sample using if statement, you can try to adapt it on your case. To create the formula Comission (Field_Quotas,Field_base) : <entry key="Comission"> <value>"IF(" + sqlArgs[0] + " > 100," + sqlArgs[1] + "*1.33," + sqlArgs[1] + "*0.66)"</value> </entry> Regards, Guillaume Post Edited by gautier at 11/26/2009 18:56
  24. I hve tryed to reproduce the error in my server. - go in the repository in ad'hoc component / topics - select a topic then clic on the open in designer button - i made a simple modification (added one field) - save and this works ... do you use the standard evaluation copy ? what is your environement ?
×
×
  • Create New...