Events Manager: question about how excerpt is stored in database

  • Resolved dynamon

    (@dynamon)


    12 years, 5 months ago

    Hi,
    In the event entry/edit form, there is a section called Excerpt. How are these data stored in the database? I have a script to extract event data from the database and generate a list of events into a document. Currently I use the Contents (‘post_content’ in the ‘wp_em_events’) but some of the data are too long for our list and so we want to use the data in the Excerpt field instead.

    In the ‘wp_em_events’ table, I can not find the column called excerpt. Your Where are they stored and how are they linked to each event?

    I am aware that you provide the placeholder called #_EVENTEXCERPT but this, if I understand correctly, is a shortened version of the context and it is not suitable for our event list document as most important event details are towards the end of the context.

    thanks for your help in advance.

    https://www.ads-software.com/extend/plugins/events-manager/

Viewing 5 replies - 1 through 5 (of 5 total)

  • this might help you out – https://www.ads-software.com/support/topic/plugin-events-manager-limiting-text-for-event-manager-without-using?replies=13

    Thread Starter dynamon

    (@dynamon)

    Hi, aglonwl
    Thank you for your fast response. I appreciate it.

    In fact, my script runs totally independent of wordpress. The program is not written as a part of my wordpress installation and uses SQL SELECT to extract the necessary data, which will then be reformatted to generate the document so I would like to know where to find the data in the database.

    Also limiting the number of words in the context would not help because for example our typical event post content looks like:

    “We are pleased to announce the fantastic xxx trio is back at TheFantasticVenue with personA on piano, personB on bass, personC on sax. this is a fantastic opportunity to see bla bla…. It is going to be a busy night and so booking is highly recommended. Call 0123455678 or book online https://www.fantasticvenue.com/booking …. “

    And in the Excerpt field for this event we would have something like this:
    “xxxTrio with personA(piano), personB(bass) and personC(sax).
    Booking – phone 0123455678 or online fantasticvenue.com/booking”

    When I open an existing event edit form, I can see the same Excerpt data showing up on the form, so the Excerpt data must be stored somewhere in the database and linked to each of the post. I looked through the database but I have not found it anywhere…

    Thanks,

    Plugin Author Marcus (aka @msykes)

    (@netweblogic)

    the post_excerpt is stored in wp_posts, the post_id is the link in the wp_em_events table

    Thread Starter dynamon

    (@dynamon)

    Hi, Marcus
    Found them there now. Thanks for your help.

    Thread Starter dynamon

    (@dynamon)

    Hi, Marcus
    Found them there now. Thanks for your help.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Events Manager: question about how excerpt is stored in database’ is closed to new replies.