[April]

Here’s a simple workaround I made if anyone needs it.

UPDATE wp_postmeta SET meta_value = 'yes' WHERE meta_key = '_tribe_ticket_show_description'

[April]

The SQL query I initially wrote works, but it updates meta keys we don’t want to update (it also appears on Woo Orders table and so on). So I wanted to update the meta value only for products with this meta key.

So this is a working solution if anyone needs it.

UPDATE wp_postmeta, wp_posts
SET wp_postmeta.meta_value = 'META VALUE GOES HERE'
WHERE wp_posts.ID = wp_postmeta.post_id and wp_postmeta.meta_key = '_tribe_tickets_meta' and wp_posts.post_type = "product"

It would be nice if you would consider adding this option to plugin options in the upcoming versions.

[April]

Thanks for clarifying the process. From what you’re saying, if fieldsets are being copied to tribe_tickets_meta -> meta_value , then it would be possible to populate the meta_value column via SQL query. Something like:
UPDATE wp_postmeta SET meta_value = 'a:4:{i:0;a:5:{s:4:"type";s:4:"text";s:8:"required";s:2:"on";s:5:"label";s:10:"First Name";s:4:"slug";s:10:"first-name";s:5:"extra";a:0:{}}i:1;a:5:{s:4:"type";s:4:"text";s:8:"required";s:2:"on";s:5:"label";s:9:"Last Name";s:4:"slug";s:9:"last-name";s:5:"extra";a:0:{}}i:2;a:5:{s:4:"type";s:4:"text";s:8:"required";s:0:"";s:5:"label";s:5:"Email";s:4:"slug";s:5:"email";s:5:"extra";a:0:{}}i:3;a:5:{s:4:"type";s:8:"checkbox";s:8:"required";s:0:"";s:5:"label";s:7:"Options";s:4:"slug";s:7:"options";s:5:"extra";a:1:{s:7:"options";a:4:{i:0;s:138:"($30.00) I would like to RENT a textbook. A textbook is mailed out to your after registration. A textbook is returned on the day of class.";i:1;s:195:"($20.00) I would like an Electronic PDF 70 page workbook to use in preparation for class. Although it is a summarized version of the textbook, this document will adequately prepare you for class.";i:2;s:99:"($75.00) I would like to BUY a brand NEW textbook. A textbook is shipped to you after registration.";i:3;s:94:"($55.00) I would like to BUY a USED textbook. A textbook is shipped to you after registration.";}}}}' WHERE meta_key = '_tribe_tickets_meta'

(value copied from a ticked id with active fieldset)..but this particular example doesn’t work unfortunately. Since we currently have 4300 tickets, each requiring a ticket fieldset, I would appreciate some help with this query, even if it falls outside of the scope of forum support.

At this point, there is absolutely no use of TEC importer if we can’t handle this process in bulk.

[April]

This reply is private.

[April]

This reply is private.

[April]

Worked! Thanks!

[April]

That’s quite a disappointment, to be honest. I don’t see a reason to use CSV imports if I have to edit every single event manually to assign ticket fields to a ticket. As I can see, Ticket Fieldsets also have an ID(Iassume they are also post types), wouldn’t be logical to map the ID of the Ticket Fieldset to a Ticket or Event during the CSV import?

[April]

Hi Patricia,

that doesn’t solve it I’m afraid. The output is weird now and shortcode is echoed on a places where it shouldn’t be. Please have a look where it echoes and where it’s placed in the backend.

Here are the functions I made for shortcode purposes.

/********************************************************************
Add eventdate shortcode
********************************************************************/
function shortcode_eventdate() {
  return tribe_get_start_date(null, false, 'F j, Y - g:i a');
}
add_shortcode('eventdate', 'shortcode_eventdate');

/********************************************************************
Add eventvenue shortcode
********************************************************************/
function shortcode_eventvenue() {
  return tribe_get_venue( $postID );
}
add_shortcode('eventvenue', 'shortcode_eventvenue');

/********************************************************************
Add eventtitle shortcode
********************************************************************/
function shortcode_eventtitle() {
  return the_title_attribute();
}
add_shortcode('eventtitle', 'shortcode_eventtitle');

/********************************************************************
Add eventcategory shortcode
********************************************************************/
function shortcode_eventcategory() {
  return tribe_get_event_taxonomy(
      get_the_id(), array(
				'before'       => '',
				'sep'          => ', ',
				'after'        => '',
				'label'        => null, // An appropriate plural/singular label will be provided
				'label_before' => '<dt>',
				'label_after'  => '</dt>',
				'wrap_before'  => '<dd class="tribe-events-event-categories">',
				'wrap_after'   => '</dd>',
			)
      );
}
add_shortcode('eventcategory', 'shortcode_eventcategory');

/********************************************************************
Add eventstarttime shortcode
********************************************************************/
function shortcode_eventstarttime() {
  return tribe_get_start_date($post, false, $format = 'g:i a' );
}
add_shortcode('eventstarttime', 'shortcode_eventstarttime');

/********************************************************************
Add eventendtime shortcode
********************************************************************/
function shortcode_eventendtime() {
  return tribe_get_end_date($post, false, $format = 'g:i a' );
}
add_shortcode('eventendtime', 'shortcode_eventendtime');

add_filter( 'tribe_events_excerpt_allow_shortcode', '__return_true' );

Note that I’ve changed the the_title_attribute() per your suggestion. Any other ideas?

[Author]

Posts