Programmatically add new table

Hi Tobias,

Thanks for your response. Let me explain what I want exactly.

I want to have weekly box office stats e.g. http://www.imdb.com/chart/. Now each movie data is fetched programmatically. These movie data should be inserted into a tablepress table row. The resulting table will be inserted into a post as a shortcode and published.

Pseudo code:

function add_tablepress_table($data) {
$table_name = 'week of 23 August 2013';
$table_desc = 'Box Office result for week of 23 August 2013';

$table_id = tablepress_insert_table($table_name, $table_desc, $default_table_options);
foreach($data as $row) {
$table_id->set_row($row['movie_rank'], $row['movie_name'], $row['weekend'], $row['gross'])
}

return $table_id;
}

This $table_id will be used to insert into a post. Does that make sense?

Hi Tobias,

In that case, it will be almost a complete rework of what is already available in your plugin. Moreover the tables won’t be only added programmatically. Existing data will be added programmatically and new data will be loaded normally using the UI.

If you could kindly give a code snippet to add a new table with default table options, I can do the rest of adding rows. I’ve checked how table data is stored as post content. The only thing that bothers me is inserting the metadata “_tablepress_table_options” and “_tablepress_table_visibility”.

Even that can be done, but I always try to use native plugin functions because it will take care of inserting other required metadata.

Thanks,
Prasenjit.

Nevermind Tobias. I switched to Footable plugin. That suits my requirements better than yours. Keep up the good work. You’ve created an excellent plugin.