{"id":2585,"date":"2015-04-16T01:11:57","date_gmt":"2015-04-16T01:11:57","guid":{"rendered":"https:\/\/esa.org\/history\/?p=2585"},"modified":"2015-04-16T01:11:57","modified_gmt":"2015-04-16T01:11:57","slug":"tablepress-documentation","status":"publish","type":"post","link":"https:\/\/esa.org\/history\/2015\/04\/tablepress-documentation\/","title":{"rendered":"TablePress"},"content":{"rendered":"

TablePress<\/a> and its associated extensions<\/a> are the WordPress plugins we use to manage data about ESA. We store the data in TablePress tables accessible from the WordPress dashboard and then insert entire tables or parts of tables into posts using shortcodes.
\nThe TablePress menu and options within WordPress are pretty self-explanatory, but if you run into problems or want to do something a bit complex, the FAQ<\/a> or Documentation<\/a> are very helpful.
\nBefore editing a table, make a backup by exporting the table. If you accidentally mess things up, you can just import your backup table and replace the one you messed up.<\/p>\n

Creating a table<\/h3>\n

Create a CSV table, import it [TablePress -> Import a Table (File Upload, Add as new table)], choose the appropriate options, and save it.<\/p>\n

Editing a table<\/h3>\n

Go to the list of All Tables and choose the table you want to edit. If the table is large, it may take some time to load. Chrome is faster than Firefox. Once the table loads, edit and save. Rows may be added from this interface, but they can also be appended using the following method.<\/p>\n

Appending many rows to a table<\/h3>\n

Create a CSV file with the same number and arrangement of columns as the table in TablePress. Do not include a header row. The file must be saved with both comma and quote delimiters, like \u201cText1\u201d, \u201cText2\u201d, \u201cText3\u201d. Excel does not do this<\/a>, so use LibreOffice or OpenOffice instead. Import the table [TablePress -> Import a Table (File Upload, Append rows to existing table)].<\/p>\n

Adding a table to a post or page<\/h3>\n

This is where shortcodes come in. All TablePress shortcodes take the form
\n[table id=<the-ID> \/]<\/code>
\nEvery table in TablePress has an ID number on the All Tables page. The Society Officers table ID is 2, so to insert it into a post, simply use the shortcode
\n[table id=2 \/]<\/code>
\nThe basic shortcode pastes the entire table into the post or page. Sometimes we only want some of the table. For example, on the president\u2019s post<\/a>, we only want to display the presidents from the Society Officers table. To do this, we filter the table by the word \u201cPres\u201d and only rows containing the word \u201cPres\u201d are included.
\n[table id=2 filter=\"Pres\" \/]<\/code>
\nIf you actually went to the behind the scenes for the president\u2019s post<\/a>, you\u2019d see that there are actually several more arguments for that table.
\n[table id=2 hide_columns=\"2,6,7\" datatables_buttons=\"colvis,copy,csv,excel,pdf,print\"<\/code> filter=\"Pres\" \/]<\/code>
\nThe hide_columns<\/code> argument allows you to hide columns. Simply select the number of the columns you do not wish to show.
\nThe [[datatables_buttons=\"colvis,copy,csv,excel,pdf,print\"]]<\/code> option causes the download buttons at the top of the table to appear and provides a column visibility filter for users.
\nThere are many other<\/a> shortcode options available. The important thing is to surround the shortcode with brackets, begin it with the table id, and remember that each argument takes the form argument=\"value\".<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"

TablePress and its associated extensions are the WordPress plugins we use to manage data about ESA. We store the data in TablePress tables accessible from the WordPress dashboard and then insert entire tables or parts of tables into posts using shortcodes. The TablePress menu and options within WordPress are pretty self-explanatory, but if you run into problems or want to…<\/p>\n","protected":false},"author":11105,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[178],"tags":[121],"class_list":["post-2585","post","type-post","status-publish","format-standard","hentry","category-documentation","tag-tables"],"_links":{"self":[{"href":"https:\/\/esa.org\/history\/wp-json\/wp\/v2\/posts\/2585","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/esa.org\/history\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/esa.org\/history\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/esa.org\/history\/wp-json\/wp\/v2\/users\/11105"}],"replies":[{"embeddable":true,"href":"https:\/\/esa.org\/history\/wp-json\/wp\/v2\/comments?post=2585"}],"version-history":[{"count":0,"href":"https:\/\/esa.org\/history\/wp-json\/wp\/v2\/posts\/2585\/revisions"}],"wp:attachment":[{"href":"https:\/\/esa.org\/history\/wp-json\/wp\/v2\/media?parent=2585"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/esa.org\/history\/wp-json\/wp\/v2\/categories?post=2585"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/esa.org\/history\/wp-json\/wp\/v2\/tags?post=2585"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}