List of bookings?

[Bo LandbergerParticipant]

Hi,
I would like to be able to get a list of bookings instead of
having the calendar, or as an option.
Also to be able to output all bookings with details to Excel, csv etc.

BR
Bosse

[supportKeymaster]

Hi Bosse,

Currently listing appointments in a list or export them is not supported. We will add these features in the future.

[Bo LandbergerParticipant]

Hi,
Can you supply the sql query for getting this info or
tell me which tables I can find the info?
//Bosse

[supportKeymaster]

The appointment is a sort of post type named “birs_appointment”. You can use the WP functions like get_posts and get_post_meta to get appointments and their info. As with other post types, they are all stored in the wp_post and wp_postmeta tables.

[AlexParticipant]

in fact… i create a list by touching the core (UGLY THING) here :
view/calendat/imp.php – line67 if you put (which would be great for next release…) : ‘show_ui’ => true,

Then you can re-register (lol) the post type in function.php for example :

add_action( 'init', 'custom_rdvs' );
function custom_rdvs() {
	$labels = array(
			...
	);
	$args = array(
		'labels'        => $labels,
		'description'   => '',		
		    'public' => false,
            'show_ui' => true,
            'capability_type' => 'post',
            'publicly_queryable' => false,
            'exclude_from_search' => true,
            //'show_in_menu' => 'birchschedule_schedule',
            'hierarchical' => false,
            'show_in_nav_menus' => true,
            'menu_position' => 5,	            
            'supports' => array('author', 'custom-fields'),            
            'can_export'    => true,		
	);
	

register_post_type( 'birs_appointment', $args );	

}

Which permit you to list appointments (and keep the calendar as well)…

[Author]

Posts