Latest Topics

Transfer Mysql database

Thu, 19 Aug 2010 14:29:59 +0000

Hello,

I am in the process of transferring data and contacts onto a Mysql database.

I have had some help and am trying to get a software solution.

So main features would be to migrate large amounts of data and contacts every day. The migration would be done manually.

Thanks for the help.

JasperETL-All-r35442-V3.2.3 install on Mac 10.6 (

Thu, 12 Aug 2010 20:56:31 +0000

I've downloaded the package and unzipped. When I try to run it I get a "You can't open the application because it may be damaged or incomplete. I'm not running rosetta. Will this build run without rosetta, or is it required.

How can I get a build that will run?

JasperETL : Connection Issues to Oracle (10/11)

Mon, 09 Aug 2010 18:43:29 +0000

I cannot seem to make a connection to Oracle 10 or 11.

Example (Using Oracle SID connection)

a. Create a new connection.

b. Enter necessary elements like SID, port, userid/password etc.

c. Click 'Check' (as indicated on top of the dialog box).

Nothing happens here. Wait and wait but nothing happens.

I noticed after a while the cursor goes to the 'Null' field on the dialog box.

Click finish. Nothing happens.

Please advice.

Thanks.

Dynamic destinations in tMap (schema and number)

Mon, 09 Aug 2010 06:25:52 +0000

Hello,

I am currently working on a project designed to be a generic ETL process for CSV files. I already used JasperETL to load data from such a file, but i noticed i need to specify a schema for input files. Also on the tMap component i need to specify destinations and their schemas.

Is there some way to do this dynamically? The ideea of the application is to use a configuration file that will tell everything: destinations, each field in the CSV along with it's type and some validation to be applied, and it's destination. The problem is this is designed to be extremely generic, so i don't know the schema for the input file or for the destinations (or even the number of destinations) before run-time.

Is there some way this can be implemented using JasperETL?

How to change a composite key?

Mon, 09 Aug 2010 00:46:44 +0000

Hi,

I have three tables: A, B and AB and the key of table AB is a composite key of table A and table B.
How can I change an composite key between two tables?

I tried with tMap, but I need to link the key that I want to change, then I can't indicate what key will be the new value...

Thanks a lot

How to create custom components?

Wed, 28 Jul 2010 12:01:29 +0000

Dear All.

I need to create a new custom component for my product so other jasperETL users can use to import and export data from my system (same as the sugar CRM componant for example), i searched the internet for a refrance helping creating custom component and i didnt find anything useful can anyone help me find any resource to get me start building such a component ?

thanks and best regards,

Razi AL-Qasem

Post Edited by razi.alqasem@gmail.com at 07/28/2010 12:02

Post Edited by razi.alqasem@gmail.com at 07/28/2010 12:03

Post Edited by razi.alqasem@gmail.com at 07/29/2010 07:48

Source code for JasperETL

Sun, 18 Jul 2010 21:26:42 +0000

I've just tried to checkout source code for JasperETL and found the specified directory is empty.

http://jasperforge.org/svn/repos/jasperetl/

Is JasperETL an open source project or is it actually an closed source project?

Information about JasperETL

Tue, 13 Jul 2010 13:55:36 +0000

Hello,

I want to know which interfaces JasperETL (Open Source) supported... BAPI, ODBC, OLE DB, OLE DB FOR OLAP?

And which Datasource is supported? MS Office, Flat Files, Data form internet??

I have foud a document:

JasperETL 3.2.1 Components Reference Guide

The wrote components there are for the Open Source Edition or for the professional? Where can i get information about the components for the Open Source edtion?

i am happy about every information :)

Thank you

Post Edited by lauramoser at 07/13/2010 13:56

Export Data in JasperServer

Tue, 13 Jul 2010 09:47:00 +0000

Hello,

I have not many experience in this topic, so sorry my question...

I want to export an csv file in my JasperServer. Or have i to import the file from ETL in JasperServer?

Please help me!

Thank you

JasperETL 3.2.3 does not start on Ubuntu 10.04

Mon, 12 Jul 2010 11:01:52 +0000

I copied the content of the tarball.

Obviously it is not intented to work in a place like /usr/local/...

So I unpacked in my home. From there I get the login panel, I enter some e-mail in the local connection,

I cannot copy the demo project, so I try to make a new one. Which I could define, but when I say open after defining, I get a dialogbox with a title "JasperETL-linux-gtk-x86" and no content that lasts for ever ...

=> same tarball works on windows, but this doesn't help for me.

Anybody experienced the same issue ?

Log file attached.

Post Edited by pkienner at 07/12/2010 11:02

Post Edited by pkienner at 07/12/2010 11:06