~~~ Please read before posting. ~~~

Important: We need your Club Number at a minimum, and as many details as possible.
For further info please read This page before posting.

Request for Member Speech and Role Report (xlsx)

  • ewbrowning
  • ewbrowning's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 14
  • Thanks: 2

Request for Member Speech and Role Report (xlsx)

2 years 11 months ago
#88790
Under agenda based reports, only two reports have options to download data as an excel sheet. Member Role Report, and Member Speech Report, only have html options. I'd really love to see an option to download these in a flat table format (.csv or .xlsx) given the same basis options. The html reports are useful, but not easy for analysis (driving a progress chart for example, and appending new data).

I've several times had to paste the html into a spreadsheet, and cleverly work it into a table, but this is still very time consuming. I imagine the table having all the same fields, and column orders as the html report, but with each data element in a dedicated cell having carriage returns scrubbed from the text. Optionally, if manual and project are actually separate fields in the database, then keeping them that way in separate cells would also be helpful for analysis (given that some projects are in multiple paths).

Thank you much for your consideration, and all you do to support our clubs. Please let me know if we can make this happen.

Eric W. Browning
District 33 Webmaster
Secretary / Treasurer Club #1864
The following user(s) said Thank You: SteveTheTechie

Please Log in or Create an account to join the conversation.

  • SteveTheTechie
  • SteveTheTechie's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 11526
  • Thanks: 3050

Re: Request for Member Speech and Role Report (xlsx)

2 years 11 months ago - 2 years 11 months ago
#88798
I will consider it when I get around to doing more with reports.  It will not be anytime soon, though.

I have moved your suggestion to our Improvement Suggestions section to make sure I see it again in the future.
Last edit: 2 years 11 months ago by SteveTheTechie.
The following user(s) said Thank You: Pam, ewbrowning

Please Log in or Create an account to join the conversation.

  • DaveShehorn
  • DaveShehorn's Avatar
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 20
  • Thanks: 1

Re: Request for Member Speech and Role Report (xlsx)

11 months 4 days ago
#93655
If you are just collecting Pathways data, you can print the html to the screen, then cut-n-paste into an Excel sheet. With a little manipulation, you can work the sheet into the essential columns. I use this technique for quarterly VP-ED reports

Please Log in or Create an account to join the conversation.

Moderators: BrianPamrhtaylor3marc33NotLiablejgavinLcala305Jane Atkinsonpeterb323
Time to create page: 1.307 seconds