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.
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.
Archipelago IS, LLC | Director, Business Analytics| www.archipelagois.com
303 S. Broadway, Suite 200-169 | Denver, Colorado 80209
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 .