Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Freshbooks

Has anyone used QlikView with Freshbooks time tracking data?

9 Replies
ngulliver
Valued Contributor III

Re: Freshbooks

Hi, Debbie.

I haven't used it myself but I'm aware that you can download data from Freshbooks as a .csv or excel spreadsheet. You can use this as a source for your QlikView app.

If you are looking to extract the time data I would recommend contacting Freshbooks directly to find out the best method of extracting time data

Regards,

Neil

Not applicable

Re: Freshbooks

so it would have to be a manual process then?

Debbie Pyykkonen

Archipelago IS, LLC | Director, Business Analytics| www.archipelagois.com

303 S. Broadway, Suite 200-169 | Denver, Colorado 80209

Twitter | LinkedIn | Facebook |

(: 303-304-6425 | *: dpyykkonen@archipelagois.com

Check out our Workshops and Events!

Download QlikView for FREE!

ngulliver
Valued Contributor III

Re: Freshbooks

Not necessarily.

If Freshbooks can automate the delivery of data to a spreadsheet, you could schedule a QlikView app in a QlikView server to pick this up.

It really does depend on Freshbooks being able to regularly produce the data. Contact them on their website and see what they can do for you.

Regards,

Neil

Not applicable

Re: Freshbooks

Hi, In Qlikview we can load the data from html pages or excel files on the share point site.

So you don't need download the excel files from freshbooks and we can directly load the excel file urls into qlikview.

Not applicable

Re: Freshbooks

dathu.qv,

Freshbooks does not allow QlikView to pull the data directly.  I reached out to them already.  If using Sharepoint, you would still have to have Freshbooks export the files to Sharepoint.

Or am I not understanding your response?

Not applicable

Re: Freshbooks

Generally in sharepoint we create the folder and add the excel files to those folder. If we want load the data from share point excel files, we don't need to download to files into disk.

As per your comments, we can't directly load the excel files from freshbooks. So we need to create the bat file to download the excel files into disk location after that we can load those files into qlikview.

1. Create the bat file to download the files from freshbooks into disk.

2. call this bat file in the qlikview script

3. Load the files into Qlikview reports.

Not applicable

Re: Freshbooks

Thank you

Unfortunately I am looking for a timekeeping product, besides SFDC, that has direct connect with QV. I don’t want to have to deal with the extra steps. Back to searching for a simple time keeping SaaS product that QV can pull data from rather than pushing it out to QV.

Debbie Pyykkonen

Archipelago IS, LLC | Director, Business Analytics| www.archipelagois.com

303 S. Broadway, Suite 200-169 | Denver, Colorado 80209

Twitter | LinkedIn | Facebook |

(: 303-304-6425 | *: dpyykkonen@archipelagois.com

Check out our Workshops and Events!

Download QlikView for FREE!

MVP
MVP

Re: Freshbooks

Hi Debbie,

I believe you can connect to Freshbooks with QVSource.  For more information on this product please see:

http://www.quickintelligence.co.uk/qvsource/

Chris Brain may be able to offer some assistance on this also.

Steve

chrisbrain
Valued Contributor

Re: Freshbooks

Hi Debbie, I had a quick look at the Freshbooks API docs and I think the QVSource General Web Connector should be able to pull the data directly into QlikView. If you would like to explore this approach feel free to ping me directly .

Community Browser