Search found 9 matches

by Nismon8er
Thu Jun 10, 2021 4:18 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Parameter from Dropdown List
Replies: 5
Views: 126

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: 1
Views: 24

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: 1
Views: 24

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: 126

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: 126

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: 133

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: 220

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: 194

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: 220

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