Search found 10 matches

by Nismon8er
Tue Jun 15, 2021 8:24 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: The Java way of doing the Execute Shell Command and also the Send Email
Replies: 1
Views: 3324

The Java way of doing the Execute Shell Command and also the Send Email

Hello, Unfortunately I do not have access to Clover Server (reasons above my pay grade) so I was tasked with mimicking those actions in a CustomJavaComponent (or whatever this would be more suitable for). Pretty much on completion of specific graphs that I have, I need to execute a shell script. Thi...
by Nismon8er
Thu Jun 10, 2021 4:18 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Parameter from Dropdown List
Replies: 5
Views: 4111

Re: Parameter from Dropdown List

Hello, If you create a parameter with the Editor Type of “Enumeration”, you can then specify the allowed values and users will then be able to pick them from the list. To do this please follow the steps below: 1. Open the Parameter editor and create a new parameter/edit an existing one and click on...
by Nismon8er
Tue Jun 08, 2021 6:35 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: MysqlBulkWriter issue with multiline DB column
Replies: 2
Views: 3723

Re: MysqlBulkWriter issue with multiline DB column

Ended up solving this.

I still stripped out the "/n" but instead of replacing them with blank string "" I replaced them with a literal '/n' and let the MySQL Utility handle the line break.

Worked like a charm
by Nismon8er
Thu Jun 03, 2021 4:52 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: MysqlBulkWriter issue with multiline DB column
Replies: 2
Views: 3723

MysqlBulkWriter issue with multiline DB column

Hello, I have a TEXT column in a table and I have a flat file that is ^^ delimited. There are some situations where that data look something like this ^^1^^06/03/2021^^100.00^^This is a multiline not and it needs to remain as a multiline note^^1^^0^^ ^^1^^06/03/2021^^100.00^^This is a multiline not ...
by Nismon8er
Tue Jun 01, 2021 4:17 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Parameter from Dropdown List
Replies: 5
Views: 4111

Re: Parameter from Dropdown List

Hello, If you create a parameter with the Editor Type of “Enumeration”, you can then specify the allowed values and users will then be able to pick them from the list. To do this please follow the steps below: 1. Open the Parameter editor and create a new parameter/edit an existing one and click on...
by Nismon8er
Fri May 28, 2021 4:34 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Parameter from Dropdown List
Replies: 5
Views: 4111

Parameter from Dropdown List

Hello,

Is there a way to have a dropdown list of possible parameter values in the editor? I don't want there to be the possibility of people entering the wrong values when defining a specific parameter.

Thank you
by Nismon8er
Wed Apr 28, 2021 7:02 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Running replace function on entire flatfile
Replies: 1
Views: 3447

Running replace function on entire flatfile

I am running DBWriter -> Reformat -> StructuredDataWriter .... this works fine What I need to do after that is run FlatFileReader (on the resulting file from the StructuredDataWriter above) -> Reformat -> FlatFileWriter because I need to replace all instances of double single quotes '' to NULL but i...
by Nismon8er
Mon Apr 26, 2021 2:58 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: MySQLBulkWriter empty rows
Replies: 2
Views: 3904

Re: MySQLBulkWriter empty rows

So I figured it out..

There were some line breaks "\n" in one of my fields and for some reason that threw EVERYTHING off when the bulkwriter started working. I removed any "\n" using a Reformat and that fixed my issue.

Thank you!
by Nismon8er
Wed Apr 21, 2021 3:20 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: MySQLBulkWriter to return newly generated ids
Replies: 2
Views: 3946

MySQLBulkWriter to return newly generated ids

Is there any way to have MySQLBulkWriter to return the ids of the newly added records. So for example I have a table like so: | id | name | last | company | position | and I have a flat file that has data like so: ^^Joe^^Johnson^^Company ABC^^Manager^^ ^^Mike^^Mills^^Company 123^^Staff^^ ^^Dale^^Dwe...
by Nismon8er
Thu Apr 01, 2021 8:07 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: MySQLBulkWriter empty rows
Replies: 2
Views: 3904

MySQLBulkWriter empty rows

Hello, I have implemented the MySQLBulkWriter and it is working like a charm. My issue is that there are 713 records that are being read via DatabaseReader and when the MySQLBulkWriter writes to my other table it ends up adding 45 additional blank rows. When I use DatabaseWriter it works fine and on...

cron