stasp
-
Posts
229 -
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 stasp
-
Issue:[toc on_off::hide=1] Currently, in JasperReports Server v4.5.0 and prior, there is no direct way to copy resources (reports, dashboards, input controls, etc) from one organization to another organization on the same level. This feature is planned to be implemented for future releases, but at the moment you cannot directly do this neither via Repository UI, nor using Import/Export utility. Resolution:For example you have reports in organization_1 (default organization) and you need to copy reports from here to a new organization (lets call it org_2) on the same level. What you need to do is: 1. In organization_1 create a new folder, for example ToCopy. You will need to copy all resources as one folder in order to have all resource references to be updated automatically. If you do not do this, resources (like reports, input controls, dashboards, etc.) will point to other resources (like report query, bundles, images, input controls) in organization_1 even after you copy everything into org_2. For most resources you'll still be able to update the references manually, however it may get a real nightmare for large number of resources. Also, some references, like input controls on Dashboards, cannot be manually updated at all, and you'll need to create dashboard from scratches. This is way you need to copy all resources in one operation as one folder. 2. Put all folders you want have in org_2 into this ToCopy folder. Make sure to cut and paste all the folders into this one, NOT copy and paste. This will ensure that all the references of resources are updated to the new location. You can restore folder structure later as it was. 3. Log in as superuser. Copy this ToCopy folder into Folder Template directory of organization one level above (for organization_1 it will be root organization) 4. Create a new org_2 on the same level as organization_1. It should have all resources which you copied to Folder Template, and all references should be updated automatically. Limitations:A workaround proposed here requires user to create a new organization. It is good when you need to create a new organization with resources from an existing organization. However if you already have an organization with pre-existing structure and resources, and you just need, for example, to copy a couple of new reports into this org, this article will not be much helpful. Ref. Case #00024466 -- 13:23, 1 March 2012 (UTC)
-
General idea: add custom decoratorNote: this article assumes you have already implemented .jsp for custom decorator. You can check .jsp files under /WEB-INF/decorators folder for examples. The idea is to add another decorator selected when for example a parameter meter=true is in the URL. Problem:If you try adding new decorator in decorators.xml by adding the following lines: <decorator name="custom_dec" page="custom_decorator.jsp"> <pattern>**d_parameter=true</pattern></decorator> the parameter in URL is simply ignored. Resolution:Option 1:Any parameters defined in decorators.xml are indeed ignored. The problem is hidden in ConfigDecoratorMapper class. The best solution is to customize the class to recognize parameters defined in decorators.xml. To do this you'll need to get JasperReports Server sources, modify the class and re-compile the project. The ConfigDecoratorMapper.java can be found in: /jasperreports-server-4.2.0-src/jasperserver-repo/opensymphony/sitemesh/2.2.1-JasperSoft/sitemesh-2.2.1-JasperSoft-src.zip archive in the source distribution. In this archive you can find ConfigDecoratorMapper.java file under /sitemesh-2.2.1/src/java/com/opensymphony/module/sitemesh/mapper/ folder. Option 2:The simpler solution is to define one more parameter and use it in the URL along with parameter defined in decorators.xml. Here's what you basically need to do: add your custom decorator in decorators.xml as follows: <decorator name="custom_dec" page="custom_decorator.jsp"> <pattern>**d_parameter=true</pattern></decorator> open sitemesh.xml file and find mapper class='com.opensymphony.module.sitemesh.mapper.ParameterDecoratorMapper' in this class set your own decorator.parameter value (for example value="custom_decorator"). Also set parameter.name value to "cxs"save the changes and restart the serverin the URL string add &custom_decorator=custom_dec&d_parameter=true In this last step you define which decorator to use and make sure that decorator condition is "true". Ref. Case #00022550 -- 15:01, 23 December 2011 (UTC)
-
Hi, Probably the first thing to do is to double check if the schema is correct for the .csv that's not being imported Regards, Stas P
-
Hi, JasperETL is based on TOS (Talend Open Studio), therefor the component creation is the same for both products. So you may want to take a look at this guide at TOS wiki: http://www.talendforge.org/wiki/doku.php?id=component_creation HTH Stas P
-
I believe tMap should suit your needs. You'll just need to (manually) change the value of required fields in output table. This can be achieved by adding simple expressions. You may want to check the JasperETL Guide from the "Docs" section for tMap examples. HTH Stas P
-
Hi, This is quite unusual error. Please try using and see if it fixes the issue. Also, you may try to re-download the installer - probably the download was incomplete; however in this case there would most likely be an error unzipping the archive. Stas P.
-
Hi Robert, If it's still relevant: Goal of this component is to use a Jasper xml file (jrxml) to produce report. tJasperOutput receives data from another (any input) component. In general, it fills a temp csv file with the data from the input rows. In the end it launch the csv + JRXML transformation => pdf xls or whatever output depending on the JRXML. Parameters are: - the tmp file path (directory field) - the jrxml file (file field) - the schema from the input Also, keep in mind .jrxml compatibility with different version of jasperreports library: Jasper xml files created with latest releases can cause issues when trying to launch with older versions of JasperETL. This compatibility is well tracked on the Talendforge: http://www.talendforge.org/exchange/tos/extension_view.php?eid=159 HTH Stas
-
Hi, It wasn't specifically tested, but JasperETL should work fine with Windows 7 as well. The only thing you should do is to use (one of) the latest Java releases. Stas
-
Hi, Doesn't tWebServiceInput suite your needs? It calls the defined method from the invoked webservice, and returns the class as defined, based on the given parameters.
-
JasperETL is not specifically designed for support of Data Quality features, although you are able to organize the data the way you need during the ETL process. However JasperETL is completely based on Talend Open Studio, so you may want to consider Talend Data Quality Hope this helps Stas
-
If the xml file is correct, this can be an encoding problem. You may want to check this article, or just google search for "Content is not allowed in prolog"
-
So what is the question? Is it possible with JasperETL - yes, absolutely. Other questions will depend Post Edited by stasp at 05/24/2010 13:37
-
Hi Venkat, Basically you can split input row into separate outputs with a tMap component and then merge them with a tUnite component the way you need. You can find more info about how to use these components in the Components guide, which you can find in the Docs section Cheers, Stas
-
Hi Shivali, CDC is not supported by JasperETL. If you are looking for this feature you may want to check Talend Integration Suite, but it's not a Community Edition product. By the way, the last available version of JETL is 3.2.3, not 3.7 (you probably mistook with JasperReports/JasperServer :) ) Best regards, Stas
-
You can put a tLogCatcher+tFileInputDelimited in the job, it will catch the exception and output them into a file. Actually, there is a pretty interesting example of implemented job on Talendforge (it's the same as JasperETL), which includes logging as well. You may want to take a look: http://www.talendforge.org/exchange/tos/extension_view.php?eid=156
-
From your description, you should be able to do that without any licensing. The CE version is distributed under GNU GENERAL PUBLIC LICENSE, a copy of which you can find within the product folder (it's called license.txt)
-
Hi, Before starting TOS, insert the following line into the .ini file you are using (I guess it's JasperETL-linux-gtk-x86_64): -Dorg.eclipse.swt.browser.XULRunnerPath=/usr/lib/xulrunner-1.9/ This should help Regards, Stas Post Edited by stasp at 04/02/2010 10:55
-
Hi, So what is it you want to know exactly? Is it possible with JasperETL? - Yes, it is. The product was designed for exactly this kind of tasks. How to do it? - Well, it depends on where do transfer your data from (other database server, xml, csv, xls, etc.) and on the structure of your data. Regards, Stas
-
Hi Sampath, I'm not sure if there some kind of table comparing JasperETL with other ETL products, at least I don't know about any. I guess I can parcel out the following advantages: - it's free - it's quite easy to start with and to understand the funtionality. - it's based on Talend OS (http://www.talendforge.org/), and therefor has strong community support and good documentation (including vivid starting tutorials) I cannot really compare JasperETLs features with other ETL products Hope this helps Stas
-
There are two ways you can follow to export the external jar files: 1) Use tLibraryload component to load the jar file at the begininig of job. for example: tLibraryLoad | tJava(on tJava, use the external API) 2) Create custom routine, import the external jar file by clicking on the rouinte name and edting the routine libraries, and then call this routine in the job Hope this helps. Stas
-
Hi Amit, As you can see from the error, there is a problem with your MySQL synthax. THere is no way to solve the issue without looking at the SQL and probably the whole job. Try to check what can be wrong with the SQL synthax by checking with the SQL manuals. If you cannot solve the issue you may want to export and attach the job here so I can try and test it. Cheers, Stas
-
Changing the permission should actually do the trick. Just try something like: chmod u+x ./JasperETL-All-r12707-V2.3.2/JasperETL-macosx-carbon.app/Contents/MacOS/JasperETL-macosx-carbon
-
I tested this and it works fine. From the top of my head I can only suggest few things to try: 1) Probably you are using an old version, try to use the latest and see if it changes anything. 2) Probably (just a guess) this is a locale problem. What happens if you try to use English locale? HTH Stas
-
Hi, First of all, make sure your mysql is running. If it is running an you cannot connect, try to set: String of connection: jdbc:mysql://:3306/test Leave the Server line blank. Also make sure that database Login, Password and Database name are correct. Regards, Stas
-
Jasperserver is not created for runnnig exported ETL jobs. You will need to get Taleand Integration Suite Enterprise Edition and integrate it with JasperServer. Regards, Stas
