Welcome, Guest
Username: Password: Remember me
1. The "search..." box above searches the Docs & Forum Posts. The "Search" tab above just searches the Forum Posts. :side:
Please use these to search for your issue *before* creating a new message topic, as your issue may have been previously solved.
2. Please put your Club # and Club Web Address in your Forum Signature (best) OR in each post to get faster support from us.
Click here to edit your signature at the bottom of the Profile Information tab.
3. Our user and admin docs are available at: support.toastmastersclubs.org/doc "There's a doc for that!" ;)
4. There is an "Opt In" Feature for newly added members. The Opt In document explains the strikethrough member information. Click Here to View the Post
5. When posting a New Topic , please include all relevant details and be specific. When did your issue 1st occur? What operating system, browser, & browser version are you using? Did you refresh your browser cache? Are your cookies enabled? Lastly, a screen shot is often helpful.
6. Please abide by the Terms of Use . We are volunteers contributing our spare time. We are happy to assist you, so long as you are respectful and courteous.
7. We are always looking for new FreeToastHost Ambassadors to join our team and support fellow Toastmasters in their use of the FreeToastHost website system. If you are familiar with the system and have some interest, send a Send Us a Private Message.
  • Page:
  • 1

TOPIC:

Comprehensive CSV extract of Agendas 8 years 5 months ago #53409

  • Jeff Walters
  • Jeff Walters's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 19
  • Thank you received: 2
Hi

Any chance of a full CSV extract of the Agenda data for a date range - i.e. all the captured details (including Former Member names ).

I work with Excel 2013, and with Power Query / Power Pivot and Power View, you can create some quick data manipulations and reports / dashboards.

Providing a simple, but comprehensive CSV extract should take all pressure off further requests for the development of additional reports, or report reformatting.

The CSV could also be used to import into an Access database - for those more comfortable in Access.

It could even be used for an single agenda - if you wanted an highly customised layout, and you didn't want to fiddle with formatting within this system ...

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

Comprehensive CSV extract of Agendas 8 years 5 months ago #53414

  • SteveTheTechie
  • SteveTheTechie's Avatar
  • Offline
  • FreeToastHost Developer
  • FreeToastHost Developer
  • Posts: 13529
  • Thank you received: 3831
At some point I may add this... will not be until next year though. Also, would have to consider the possibility that people may want to re-import the info back into the system, which is harder to do than you may think. (import data has to be validated and cleaned up)
Regards,

Steve James, DTM
FreeToastHost System Developer
Officer Emeritus, Mindful Communicators (Club 1966, District 52) A President's Distinguished Club for each of the last 10 years.

>>> Please put your club number in your forum profile. CLICK here to edit your profile.

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

Comprehensive CSV extract of Agendas 8 years 5 months ago #53477

  • Jeff Walters
  • Jeff Walters's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 19
  • Thank you received: 2
Hi

>> would have to consider the possibility that people may want to re-import the info back into the system

That is a separate requirement, and more complex as you point out. Coding is very different, so I don't think they should be linked.

Don't overcomplicate the export request by thinking about imports .. :)


>> At some point I may add this... will not be until next year though

Pity - I thought this could be quick to do.

You have most of the elements already in place for a CSV export. You already do a role export to Excel and HTML. Data range selection is already there ... Would probably require a new SQL statement, and reuse of a lot of your existing code.



.
The following user(s) said Thank You: SteveTheTechie

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

Comprehensive CSV extract of Agendas 8 years 2 months ago #54571

  • HugeM
  • HugeM's Avatar
  • Offline
  • New Member
  • New Member
  • Posts: 3
  • Thank you received: 1
I have to agree that an agenda csv export would require very little effort to implement and provide a huge benefit to clubs that have already established their "brand" incorporating agenda format.
The existing agenda is great to be able to have members login and choose roles so no change there.
01174948 Yes Toastmasters
The following user(s) said Thank You: tedchuang

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

Comprehensive CSV extract of Agendas 6 years 8 months ago #63867

  • Jeff Walters
  • Jeff Walters's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 19
  • Thank you received: 2
Hi

>> At some point I may add this... will not be until next year though

I suggested this as an option nearly two years ago - so - has there been any movement on this?

I think it could add a lot of value to your system.

I am happy to help you test it if you have done some work on this.

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

  • Page:
  • 1
Moderators: Pamrhtaylor3jliumarc33NotLiabledeedubbleyooNSBPhyllis Kirouac
Time to create page: 0.065 seconds
Powered by Kunena Forum