Add WordPress media library to table columns

The plugin allows you to assign the WordPress media library screen to specific database columns. The plugin will treat these columns as media column everywhere throughout the plugin, including list tables, data entry forms, Data Publisher pages and Data Project pages.

 

How to define media columns

  • Navigate to: WP Data Access >  Data Explorer > Manage > Settings
  • Click on Column Media Types
  • Use the listbox to define the column media types (leave blank for non media columns)
  • Click on Save Table Settings

The column is now associated with the WordPress media library throughout the plugin. The WordPress media library will be added to this column for all your:

  • List tables
  • Data entry forms
  • Data Publisher pages
  • Data Project pages

NOTES

  • The association with the WordPress media library will only work within the plugin!
  • Version 2.5.1 allowed to define media columns in the Data Publisher and Data Projects tools as well. From version 2.6.0. previous settings are still available but can no longer be changed. Please transfer your media columns to your table settings as described above.

Supported types of media columns

  • Image (all image files in the WordPress media library)
  • Attachment (all files in the WordPress media library)

Media type Image

Within list tables as well as data entry forms image columns are converted to their associated media. The plugin reads the associated media data from your WordPress media library and adds the image to your list table or data entry form. Data entry forms also provide the necessary functionality to upload, select and remove images to and from your WordPress media library.

Media type Attachment

Attachment columns are handled like image columns. An attachment however is shown as a link to the associated file.

Multiple and single media columns

The plugin supports multiple as well as single media columns:

  • NUMBER columns are handled as single media columns
  • VARCHAR columns are handled as multiple media columns

Single media columns can only save only one media id. Multiple media columns can save as many media id’s as you like. The width of your char column determines the maximum number of id’s that can be stored. Make sure your column is wide enough!

Column format examples

  • column “bike_photo bigint(20) unsigned” can store one image or attachment
  • column “bike_attachments varchar(200)” can store multiple images or attachments untill there is no more space left

Need more media types?

Let me know if you need additional media columns to handle specific situations. I’ll be glad to add them.

Was this article helpful to you? Yes No