Search found 19 matches

by Paulhbartosik
Fri Jan 17, 2020 10:39 pm
Forum: CloverDX Server
Topic: The SpreadsheetDataWriter does not work on CloverDX Server 5.5
Replies: 1
Views: 39

The SpreadsheetDataWriter does not work on CloverDX Server 5.5

Works fine on my local machine. However, it fails when we run it on the CloverDX Server. I have attached a simple graph that illustrates the problem. Run it locally. It will run fine. Copy it to the server and run it. It will fail. ------------------------------------------ Error details -----------...
by Paulhbartosik
Wed Dec 18, 2019 4:11 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Read in a line of text into each record
Replies: 4
Views: 463

Re: Read in a line of text into each record

Lukas,
This fixed the problem. Thank you for your help.
by Paulhbartosik
Thu Dec 12, 2019 6:31 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Read in a line of text into each record
Replies: 4
Views: 463

Re: Read in a line of text into each record - Please Help. Still failing

I have been banging away at this for a day. This has got to be something stupid that I am missing. My goal is to read a file that has newlines instead of NL/CR. This should be simple. Every line in the input file should come in as a single record. I will later parse these single records out. I can't...
by Paulhbartosik
Fri Dec 06, 2019 9:49 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: End User Front End for CloverDX Server
Replies: 2
Views: 312

Re: End User Front End for CloverDX Server

The new Data Services API now does everything I need. I can upload a file, process it, and hand the results back to the user.

I still have to write a front end, but it is now a hell of a lot easier.
by Paulhbartosik
Tue Dec 03, 2019 6:22 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: SOAP API Documentation
Replies: 1
Views: 99

SOAP API Documentation

Can someone point me to documentation on the SOAP API calls?

I can see info at:
http://server:port/clover/webservice?wsdl

Is there more complete documentation on using SOAP calls for accessing the CloverDX server?

Thank you for your help.
by Paulhbartosik
Fri Nov 01, 2019 8:34 pm
Forum: CloverDX Server
Topic: Can I get multiple returned files from Launch Services?
Replies: 7
Views: 3742

Re: Can I get multiple returned files from Launch Services? Found workaround

I eventually solved this problem by using email attachments instead of returning the files through Launch Service.

When the graph runs, it sends the output files out as email attachments.

-Paul
by Paulhbartosik
Mon Apr 29, 2019 7:06 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: End User Front End for CloverDX Server
Replies: 2
Views: 312

End User Front End for CloverDX Server

An anyone suggest a front-end that will allow end users to upload files and then execute CLoverDX graphs or jobflows?

We currently have a custom written Java application to do this, but I would like to replace it.

Thanks for any help,

-Paul
by Paulhbartosik
Mon Apr 08, 2019 5:58 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Read in a line of text into each record
Replies: 4
Views: 463

Read in a line of text into each record

This seems a simple question. Sorry if this has been answered elsewhere. I want to load lines of text from a flat file. The data is delimited, but is not clean. So, I want to load each line as a record, and then use some reformats to clean it up and parse it into fields. Can I do this with the Unive...
by Paulhbartosik
Mon Oct 01, 2018 2:15 pm
Forum: Cookbook
Topic: Pull Execution History from the http API
Replies: 1
Views: 1913

Pull Execution History from the http API

I wanted to get a listing of the job status for the last day's activity. This is a very simple graph, but it was difficult for me to get it to work. There were two challenges: 1. Getting the HTTP parameters correct. Remember that if you add parameters through the input mapping, you must delete them ...
by Paulhbartosik
Mon Jun 25, 2018 6:14 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Where do I find the XSD for executions_history? I am using 4.1.0.018
Replies: 1
Views: 966

Where do I find the XSD for executions_history? I am using 4.1.0.018

The documentation points me to CloverETL Server URL: http://[host]:[port]/clover/schemas/executions.xsd There is a file there, but it just points out to <xs:import namespace="http://cloveretl.com/server/data" schemaLocation="cs.xsd"/> Am I missing something? Does anyone have the ...
by Paulhbartosik
Tue Jan 16, 2018 9:35 pm
Forum: CloverDX Server
Topic: Can I get multiple returned files from Launch Services?
Replies: 7
Views: 3742

Re: Can I get multiple returned files from Launch Services?

Hi Paul, Launch Services are based on HTTP calls, which does not support more than one file downloaded at once. A solution to this would be zipping the files and sending that through the Launch Service. Regards, Thanks for the suggestion. Seems like a great idea. However, I cannot figure out how I ...
by Paulhbartosik
Wed Dec 27, 2017 9:52 pm
Forum: CloverDX Server
Topic: Can I get multiple returned files from Launch Services?
Replies: 7
Views: 3742

Re: Can I get multiple returned files from Launch Services?

Hi Paul, Launch Services are based on HTTP calls, which does not support more than one file downloaded at once. A solution to this would be zipping the files and sending that through the Launch Service. Regards, :oops: Of course that is perfect. I will just zip the files up and send them all as one...
by Paulhbartosik
Wed Dec 06, 2017 10:21 pm
Forum: CloverDX Server
Topic: Can I get multiple returned files from Launch Services?
Replies: 7
Views: 3742

Can I get multiple returned files from Launch Services?

All of the examples in default/graph/launch return only one file: an HTML file, a CSV or an XLS file. Can I return more than one file? At least, I would like to return HTML, so the user can see results and also return a csv file to the user in the same action. I cannot find a way to do this. If I se...
by Paulhbartosik
Wed Dec 06, 2017 2:56 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Using dictionary variable in the query
Replies: 5
Views: 4531

Parameters in Launch Services

Is this still true in the current version? I have many graphs that I set up with parameters. Most of those use the parameters in the where clause of SQL queries. If I want to convert these to Launch Services on my CloverETL server, do I have to convert all of those parameters to dictionary entries, ...
by Paulhbartosik
Tue Dec 05, 2017 9:14 pm
Forum: Cookbook
Topic: Generic Reformat to Trim all strings
Replies: 2
Views: 2287

Re: Generic Reformat to Trim all strings

Thanks for the suggestion. However, setting Trim to "true" did not seem to make any change in my data. The trailing spaces remain. Even if it did work, it would take a lot of time to set Trim to "true" for hundreds of fields in my metadata. I appreciate the comment about performa...