Search found 134 matches

by cholastal
Wed Jan 22, 2020 10:53 am
Forum: CloverDX (formerly CloverETL) Support
Topic: Data Flow Diagrams (DFD) - Logic Export
Replies: 1
Views: 39

Re: Data Flow Diagrams (DFD) - Logic Export

Hi Alex, The details are being discussed with Jay via email but let me try to explain shortly. You can indeed export only the visual part of any job and you can also export an HTML representation of it which is more detailed, however, neither of these options let you manipulate the content of the jo...
by cholastal
Tue Dec 17, 2019 3:39 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Read in a line of text into each record
Replies: 4
Views: 479

Re: Read in a line of text into each record

Hi Paul, Yes, the devil is in the details. The issue was that you defined the "\n" as the field delimiter while you really need it as the record delimiter. That's why the parser complained about too many fields, etc. So you you need to set the record delimiter to "\n" and the fie...
by cholastal
Mon Dec 09, 2019 4:27 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: How to write custom aggregate function
Replies: 1
Views: 104

Re: How to write custom aggregate function

Hi, First of all, the open source engine is officially not supported and also discontinued, version 5.1.1 is the latest ever to be released. However, here are some hints. 1. Denormalizer is definitely a cleaner way in terms of not altering the source code. 2. If you need to re-use the Denormalizer a...
by cholastal
Fri Dec 06, 2019 10:56 am
Forum: CloverDX (formerly CloverETL) Support
Topic: How to handle "LF" character.
Replies: 10
Views: 312

Re: How to handle "LF" character.

Hi,

I just found out this is a feature of the metadata configuration as per the documentation. I must admit it's confusing and I didn't know about this feature either. On the other hand, it might be useful for certain corner cases.

Best regards.
by cholastal
Tue Dec 03, 2019 3:31 pm
Forum: CloverDX for Java Programmers
Topic: Importing Functions from a second Java file
Replies: 4
Views: 239

Re: Importing Functions from a second Java file

Hi rodrigofrb, I have reviewed your test project and here are my findings. The reason why you weren't able to import the CoolFunctions class is that in Java you cannot import types from an unnamed (default) package . This is the case when you put your *.java files directly into the trans folder. So,...
by cholastal
Tue Dec 03, 2019 12:40 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: How to handle "LF" character.
Replies: 10
Views: 312

Re: How to handle "LF" character.

Hi, I'm not sure if you're aware of that functionality but you can actually extract metadata from the input file . I did exactly that on your input file and it works flawlessly. Attached is an example graph that works with your file. You can test it in your environment and compare it to your graph. ...
by cholastal
Mon Dec 02, 2019 2:07 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: How to handle "LF" character.
Replies: 10
Views: 312

Re: How to handle "LF" character.

Okay, basically, if it's still the same error: "Unexpected record delimiter, probably record has too few fields.", it means there's a mismatch in the expected number of fields and the actual number of fields coming from the input file. Can you please attach an example input file that cause...
by cholastal
Fri Nov 29, 2019 4:34 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: How to handle "LF" character.
Replies: 10
Views: 312

Re: How to handle "LF" character.

Okay, this is a different error and is not related to the record delimiter (\r\n vs. \n) but the field delimiter. It appears the fields in the file are delimited by comma, whereas the default field delimiter is pipe |. I just realized I made a mistake in my previous explanation. The record delimiter...
by cholastal
Fri Nov 29, 2019 2:18 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: How to handle "LF" character.
Replies: 10
Views: 312

Re: How to handle "LF" character.

Hi, This is configurable on you metadata. You just need to open up the metadata editor (double click on the metadata name in the Outline window) and select \n as the record delimiter - this is the escape sequence for line feed (LF). You can do this either one by one for each field separately or you ...
by cholastal
Fri Sep 20, 2019 7:58 am
Forum: CloverDX (formerly CloverETL) Support
Topic: New to CloverDX
Replies: 1
Views: 204

Re: New to CloverDX

Hi, It is correct to output null values as empty strings because if there would be null written in the output file, it would be interpreted as a string containing value "null" when read. The null values are important only for programming/scripting languages such as CTL2 . Please note that ...
by cholastal
Tue Aug 06, 2019 2:13 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: How to pull input parameters from one jobflow to another
Replies: 6
Views: 535

Re: How to pull input parameters from one jobflow to another

Hi Mohamed,

This is unfortunately a known bug. However, it is fixed since version 5.2.0. So upgrading to 5.2.0 or newer will resolve this issue. I would recommend upgrading directly to version 5.3.

Best regards.
by cholastal
Tue Jul 09, 2019 4:04 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: putting files in a folder
Replies: 1
Views: 251

Re: putting files in a folder

Hi,

CloverDX Designer is fully drag&drop compatible so you can simply drop the files you need into the folder you like within the Navigator window on the left-hand side of the Designer. Alternatively you can obviously use <CTRL>+C & <CTRL>+V.

Hope this helps.
by cholastal
Mon Jun 24, 2019 2:27 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Best practices for shared/external subgraphs across sandboxes?
Replies: 1
Views: 286

Re: Best practices for shared/external subgraphs across sandboxes?

Hi Markus, I would definitely suggest to use the first approach. This is usually the right way to share a commonly re-usable parts. The situation with ambiguous ${PROJECT} parameter can be quite easily solved by passing the absolute path to the subgraph which can be dynamically generated in the call...
by cholastal
Mon Jun 03, 2019 3:12 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: How to write greek characters on MSsyl database?
Replies: 1
Views: 298

Re: How to write greek characters on MSsyl database?

Hi Peter, I'm actually not sure if you're using MySQL or MSSQL but that shouldn't really matter in this case. All sorts of components in CloverDX can use different charsets. So, please check if your DBOutputTable have UTF-8 set as well. Another option is that the database table is configured to use ...
by cholastal
Wed May 29, 2019 2:05 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Pass Record as function parameter
Replies: 2
Views: 350

Re: Pass Record as function parameter

Hi, Unfortunately, there is no CTL function to dynamically detect number of component ports. However, it is possible to work around this by using a SimpleCopy component . If you put this component behind your Reformat component, the code can be more generic and pass the output to only one record eve...