topic Data load from a cloud-based CRM (Solve360) in QlikView

Data load from a cloud-based CRM (Solve360)

Mon, 06 Sep 2010 17:08:53 GMT

Our company is using Solve360 (cloud-based CRM) for CRM as well as time reporting purposes. We would like to analize the reported work hours by a simple QV application. However, I cannot find out how could I load source data into QV automatically. I am Consultant with very basic programming/scripting skills, and I cannot solve the problem with the data load myself. So a help would be very welcome!

The Solve360 has an API with usage instructions, and the API allows to get time reporting data in XML format. So it seams that it should be technically possible to load the data into QV automatically.

One of the options provided by API is to get the XML sheet by a simple web link (e.g., https://secure.solve360.com/report/timetracking/?start=2009-08-02&end=2009-08-08), but then is asks also for a login and password. And I do not know how to put this link, login and password into my QV load script.

The another option is to use script like: curl -u '{userEmail}:{userApiToken}' -v -X GET -H 'Content-Type: application/xml' -o 'result.xml' -d '<request><start>2009-08-02</start><end>2009-08-08</end></request>' https://secure.solve360.com/report/timetracking/ - but I do not know how to use such type of script in QV.

Data load from a cloud-based CRM (Solve360)

llauses243 — Mon, 06 Sep 2010 19:04:02 GMT

Hi,

This is my offer (see attach)

Good luck, Luis

Data load from a cloud-based CRM (Solve360)

Mon, 06 Sep 2010 21:45:53 GMT

Thanks for the reply! However, the example does not work..

I changed login, API token, start and finish dates to correct values. But the QV file at opening gives out "Object doesn't support this property or method: 'bp.Application'" and stops at "bp.Application.v = str" in the script of "online (BU01)". And when I push the "command (BU02)", I get the following message:

Where could be the problem?

Data load from a cloud-based CRM (Solve360)

Tue, 07 Sep 2010 08:05:03 GMT

Can anybody help?

Thank you in advance! 🙂

Data load from a cloud-based CRM (Solve360)

llauses243 — Tue, 07 Sep 2010 09:19:24 GMT

Hi,

see attach for alternatives

good luck, Luis

Data load from a cloud-based CRM (Solve360)

Tue, 07 Sep 2010 09:53:09 GMT

Luis, did not you forget to add the attachment?

Data load from a cloud-based CRM (Solve360)

llauses243 — Tue, 07 Sep 2010 10:00:12 GMT

Hi Girts,

sorry ...

Luis

Data load from a cloud-based CRM (Solve360)

llauses243 — Tue, 07 Sep 2010 10:03:42 GMT

Girts, server no responding

Luis

try again via Quick Reply ...

Data load from a cloud-based CRM (Solve360)

Wed, 15 Sep 2010 20:43:38 GMT

Unfortunately, the solution proposed by Luis did not work. So finally I had to find answer myself 🙂 Maybe it will help somebody later. So, this was my solution:

1. Download Curl executable tool (exe file at ~400KB) that is made for windows, ssl enabled: http://www.paehl.com/open_source/?CURL_7.21.1

2. Make a butch file ("download_timerecords.bat") with the following script:

curl -u "Login:MyAPItoken" -k -v -X GET -H "Content-Type: application/xml" -o "timerecords.xml" -d "<request><start>2010-01-01</start><end>2013-12-31</end></request>" https://secure.solve360.com/report/timetracking/

Unfortunately, I did not have time to find good solution to let the batch process to check if ssl certificate provided by Solve360 site is reliable. So, -k attribute is added to the curl script. it allows avoid checking reliability of ssl certificate.

3. Put the curl.exe and my batch file in one folder. (Then running butch file will download timerecords data from Solve360 saving the data in "timerecords.xml" file in the same folder.)

4. Start my QV load script with the following command:

Execute download_timerecords.bat;

So now my QV data reload process automatically starts with downloading source data from Solve360 and loading it into my QV. So simple 🙂

Data load from a cloud-based CRM (Solve360)

chrisbrain — Sun, 15 May 2011 20:20:58 GMT

We are working on a Solve360 Connector for QVSource - Our API Connector for QlikView - The first release of the Solve360 Connector was released today:

http://www.qvsource.com/wiki/Solve360-Connector-For-QlikView.ashx