WordPress.org

Forums

My Calendar
Output for Mapping (6 posts)

  1. Phil
    Member
    Posted 1 year ago #

    I'm trying to output a list of events and locations for import into Excel so I can map them all. I have produced a template to output to a page but line breaks are inserted.
    Is there any way I can output in a single line per event format so I can read into Excel?
    I have the latest My Calendar version.

    http://wordpress.org/plugins/my-calendar/

  2. Joe Dolson
    Member
    Plugin Author

    Posted 1 year ago #

    What is the nature of the template you've produced? Is it a custom shortcode?

  3. Phil
    Member
    Posted 1 year ago #

    Joe - sorry for the delay in replying, but here is the code I use:

    my_calendar_upcoming before="0" after="150" category=" " type="event" template="{link_title}, {category}, {location}, {shortdesc}, {postcode}"]

    This produces the output ok but on multiple lines in the page. Some way of outputting as one line for easy reading into Excel would be handy.

    Also, a similar routine or template for outputting all the calendar locations as a list with their address and post code would be handy if possible.

    Thanks

  4. Joe Dolson
    Member
    Plugin Author

    Posted 1 year ago #

    There is a shortcode for outputting all locations; it's accessible via [my_calendar_show_locations datatype="" template=""] -- it's documented on the Help page. It's not going to be in a CSV or Excel friendly format either, however. I don't have anything like that right now, although you can always export directly from your database in a CSV format.

  5. Phil
    Member
    Posted 1 year ago #

    Joe - thanks for the suggestion re locations.

    As for the output of events (my original query) I guess the best way of getting the events data in the right format would be to export from the database? Or have you any better suggestion from within WordPress?
    Thanks

  6. Joe Dolson
    Member
    Plugin Author

    Posted 1 year ago #

    For now, I'd suggest going with the database export to get a CSV or Excel format.

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • My Calendar
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic