Search found 7 matches

by cassydeb
Fri Feb 26, 2016 12:33 am
Forum: CloverDX (formerly CloverETL) Support
Topic: [DBOutputTable] Problem with date format (ORA-01847)
Replies: 2
Views: 3461

Re: [DBOutputTable] Problem with date format (ORA-01847)

I don't know if it's a problem with oracle native jdbc driver, or missing jar for i18n, or NLS parameters (that I don't even know where to set up in CloverETL)... Is it just possible to get a working sample which play with different date format (with and without type convertion) "dd/MM/yyyy&quo...
by cassydeb
Wed Feb 17, 2016 8:55 am
Forum: CloverDX (formerly CloverETL) Support
Topic: [DBOutputTable] Problem with date format (ORA-01847)
Replies: 2
Views: 3461

[DBOutputTable] Problem with date format (ORA-01847)

Hi, This is my .csv file "PRIMARY_KEY_1";"13/02/16";"USER1";"17/02/16";"USER2" And its metadata: <Field name="PRIMARY_KEY" nullable="false" type="string"/> <Field name="USER_CREATE" type="string"/> <F...
by cassydeb
Wed Feb 17, 2016 4:36 am
Forum: CloverDX (formerly CloverETL) Support
Topic: Community Edition -> DBOutputTable and Oracle Upserting
Replies: 5
Views: 5386

Re: Community Edition -> DBOutputTable and Oracle Upserting

In a .csv file I have a field "DATE_CREATE" containing a date "17/02/16". For this field, I set in the metadata, type: "date" and format: "dd/MM/yy" like this: <Field format="dd/MM/yy" name="DATE_CREATE" type="date"/> I don't unde...
by cassydeb
Wed Feb 17, 2016 12:51 am
Forum: CloverDX (formerly CloverETL) Support
Topic: Try to Update record, Insert if not found
Replies: 7
Views: 8960

Re: Try to Update record, Insert if not found

I understand the problem...In these screenshots there is no information about transformation. Thanks to this post: http://forum.cloveretl.com/viewtopic.php?f=4&t=6500&p=9954&hilit=upsert#p9954 I have to transform data in DBJoin to get ouput data as input data. $out.0.* = $in.0.*; in tran...
by cassydeb
Mon Feb 15, 2016 11:13 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: [ParallelReader] How to skip first source row of .csv (header with fields)?
Replies: 1
Views: 1990

[ParallelReader] How to skip first source row of .csv (header with fields)?

Hi, With UniversalDataReader there is a property "Number of skipped records" so we can easily remove header with fields name of a csv file. How to do this with ParallelReader? Thanks for your help! (To moderator: Due to this policy, your post may not appear immediately but may take a day (...
by cassydeb
Mon Feb 15, 2016 11:01 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Try to Update record, Insert if not found
Replies: 7
Views: 8960

Re: Try to Update record, Insert if not found

Thank you. But I still have a problem with update. When I debug the edge between DBJoin and DBOutputTable (update) and view data, it's the data of the table (Port 0 joined records)...So it try to update data with data already in table not the data of the .csv file! It's maybe a problem with "Fi...
by cassydeb
Tue Feb 02, 2016 8:11 am
Forum: CloverDX (formerly CloverETL) Support
Topic: Try to Update record, Insert if not found
Replies: 7
Views: 8960

Re: Try to Update record, Insert if not found

hi,
I don't see join type = Inner join in DBJoin component, can you attach a .grf please?
Thanks for your help.

cron