• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Webquery to get timesheet data from Harvest

Status
Not open for further replies.

vijay.mudivedu

New Member
Background:

We have a timesheet application Called Harvest.com. This web application helps in creating reports of timesheets of all employees in a format shown below.

This wonderful application also has an option to the Export data as an XLS file or CSV file. (Attached the excel file)

We download the reports in the excel format and generate reports. The problem is, this is a every day task and there at least 10-15 reports downloaded, copied, pasted and I would like to automate in such a way that the query is directly written into the excel and when refreshed there is a new data.

I tried using the Webquery, but the webquery just scrapes the data (which about 200 rows) from the portal, it doesn't generate the complete excel report (2000 rows).

Question:
Is there a way that I can run a web query to import the data when I refresh the page, so that complete excel data is brought in the format like in the attached spreadsheet, instead of just scraping the data from the portal?

NOTE: I am using Microsoft Excel MAC 2011
 

Attachments

  • Screenshot 2015-05-05 19.17.45.png
    Screenshot 2015-05-05 19.17.45.png
    87.1 KB · Views: 34
  • harvest_time_report_from20150418to20150501.xlsx
    48.2 KB · Views: 1
  • harvest_time_report_from20150418to20150501.xlsx
    48.2 KB · Views: 2
I've worked at companies that utilize a lot of ETLs to export data from different apps, including Harvest data. As for me, the most convenient solution is the Skyvia Query Excel add-in, which allows you to load custom reports automatically. There are just two steps to get it:

Create a free Skyvia account (if you haven't had an account yet) -> Install Skyvia Query Excel Add-in from Microsoft AppSource
 
Last edited by a moderator:
Status
Not open for further replies.
Back
Top