Second post in as many days sorry!
I'd like to set up a dashboard for excel 2011 on my mac.
I am aware that you can't follow the same approach as windows for excel
2011 on mac as this version doesn't not have 'import from web' option on
the get data function. I have followed the advice
here Using a Web Query to Load Tables in Excel 2011 for Mac - dummies.
I have created several text files, pasting links from other websites such
as yahoo finance that have successfully created a dashboard, but the
commcare link does not work- on occasions it does ask for my commcare
password, but regardless of this it just fills cell A1 with "JK"- bit
frustrating. Any advice would be great.
I have found the web query function to be very flakey in Excel for Mac. It used to work but doesn't any more. I have now given up trying to make it work having tried lots of options.
This is what I do now. I click the download button in commcarehq. This displays the data in my browser (Firefox). I then select File>Save page as...
Then I open it with Excel. Next I select the data, copy it and paste it into my dashboard workbook. This sounds a bit of a long process but it really doesn't take long and works every time.
Our dashboards are here: KYTS Dashboards - ColaLife
Best of luck
Simon
Hi,
Here is the query I use, and it's working for me :
WEB
1
https://www.commcarehq.org/a/blabla/reports/export/saved/download/e6ebc004baf988701cae26114bbcebd2/?group_export_id=9f88d856e0ec109a9a2c609e81c85ff8
Selection=EntirePage
Formatting=All
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
Replace the link https://www.commcarehq.org/a/... with the link copied from
CommCare.
Hope it'll help !
Michel.
···
Le samedi 5 novembre 2016 22:29:25 UTC+1, William Elson a écrit :
>
> Second post in as many days sorry!
>
> I'd like to set up a dashboard for excel 2011 on my mac.
>
> I am aware that you can't follow the same approach as windows for excel
> 2011 on mac as this version doesn't not have 'import from web' option on
> the get data function. I have followed the advice here
> http://www.dummies.com/software/microsoft-office-for-mac/excel-for-mac/using-a-web-query-to-load-tables-in-excel-2011-for-mac/.
> I have created several text files, pasting links from other websites such
> as yahoo finance that have successfully created a dashboard, but the
> commcare link does not work- on occasions it does ask for my commcare
> password, but regardless of this it just fills cell A1 with "JK"- bit
> frustrating. Any advice would be great.
>
>
>
And by the way, I put the whole thing in a.txt file unlike the guy that
wrote the advice you're following.
Michel
···
Le samedi 5 novembre 2016 22:29:25 UTC+1, William Elson a écrit :
>
> Second post in as many days sorry!
>
> I'd like to set up a dashboard for excel 2011 on my mac.
>
> I am aware that you can't follow the same approach as windows for excel
> 2011 on mac as this version doesn't not have 'import from web' option on
> the get data function. I have followed the advice here
> http://www.dummies.com/software/microsoft-office-for-mac/excel-for-mac/using-a-web-query-to-load-tables-in-excel-2011-for-mac/.
> I have created several text files, pasting links from other websites such
> as yahoo finance that have successfully created a dashboard, but the
> commcare link does not work- on occasions it does ask for my commcare
> password, but regardless of this it just fills cell A1 with "JK"- bit
> frustrating. Any advice would be great.
>
>
>
Many thanks Simon
I shall give that a go and have a look over the examples.
In reality its not so much the dashboard details that I am after I just
want a way to be able to auto refresh the data each morning with out having
to download it through the website each day. The report builder option
doesn't really provide me with what I'm after.
W
···
On Sunday, 6 November 2016 13:10:56 UTC-5, Simon Berry wrote:
>
> I have found the web query function to be very flakey in Excel for Mac. It
> used to work but doesn't any more. I have now given up trying to make it
> work having tried lots of options.
>
> This is what I do now. I click the download button in commcarehq. This
> displays the data in my browser (Firefox). I then select File>Save page
> as...
>
> Then I open it with Excel. Next I select the data, copy it and paste it
> into my dashboard workbook. This sounds a bit of a long process but it
> really doesn't take long and works every time.
>
> Our dashboards are here: http://colalife.org/dashboards
>
> Best of luck
>
> Simon
>
>