Data load from a cloud-based CRM (Solve360)

[#1]

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.

[llauses243]

Hi,

This is my offer (see attach)

Good luck, Luis

[#3]

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?

[#4]

Can anybody help?

Thank you in advance! 🙂

[llauses243]

Hi,

see attach for alternatives

good luck, Luis

[#6]

Luis, did not you forget to add the attachment?

[llauses243]

Hi Girts,

sorry ...

Luis

[llauses243]

Girts, server no responding

Luis

try again via Quick Reply ...

[#9 · Accepted solution]

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 🙂

[chrisbrain]

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