1. Home
  2. Docs
  3. Plugin Settings
  4. Plugin


Plugin menu

Enable checkbox Hide plugin menu in admin panel to the plugin menu. All plugin features remain available. This is for developers who want to use WP Data Access features without using the plugin menu.

Panel cookies

Panel cookies are used to save settings like your currently selected database and search criteria. Panel cookies are cleared after one hour.

When set to Clear when switching panels, the plugin clears these cookies every time the user switches to another page. When set to Keep when switching panels, cookies are preserved when the user switches to another page.

Secret key and IV

Enter any prase to secure your remote database connection information. When set, all current remote database connections will be converted immediately.

Remote database connections

Edit or delete remote database connections.

More info about remote database connection management…

Shortcode wpdataaccess

Grant access to shortcode for posts and/or pages.

Shortcode wpdadiehard

Grant access to shortcode for posts and/or pages.

Shortcodes wpdadataforms and wpdadataprojects

Grant access to shortcode for posts and/or pages.

Debug mode

With debug enabled:

  • Data Forms displays debug messages in the browser console
  • Query information is added to Data Publisher responses
  • A button is added to the Data Projects main page to check project settings

Date format

Output format cannot be changed here. Please use the WordPress settings (Settings > General) page to change the output format.

Select a predefined input format or enter a custom one and adjust the placeholder.

Time format

Output format cannot be changed here. Please use the WordPress settings (Settings > General) page to change the output format.

Select a predefined input format or enter a custom one and adjust the placeholder.

Date/time test

Click on the button to test if your setting work before you save!

Set format

List format for data type set only

Was this article helpful to you? Yes No

9 Replies to “Plugin”

  1. I have been using your plugin with great joy!
    I have run into one issue I can’t seem to fix.

    In my database, dates are stored as a UNIX timestamp, and I was hoping to setup the table to show the date converted into something readable. Is this possible? I can for some reason not find it.

    A bonus question would be, can we do conditioned formating. Say if its a row has 1 in the database you display a checkmark picture or something 🙂

    Kind regards

    1. Hi Nickolai,

      >>> In my database, dates are stored as a UNIX timestamp
      Is this a MySQL date(time) column? Or is the date inserted into a varchar column? You cannot (re)format a date if it is stored in a varchar column. But you should be able to format your date field on the plugin settings page.

      Can you send me some screenshots? I’m interesed in your table structure and the layout of your data. You can use the contactform to send me your screenshots in private.


  2. Hi Peter,

    Your app is just about the perfect solution, however I was not able to find one solution.

    Is there a way to hook into your program to reformat the outputted data on the front-end table? For example, a price column is stored in my database as an int value of 10000, which means $100.00, and I would like it displayed like that. Is there a way to hook into your program, (PHP hook or JavaScript) so I can write a function with an input of 10000 from the DB returns $100.00 and displays that way in the front-end table? Thank you.

    1. Hi Cory,

      Yes, you can hook into the plugin! 🙂

      To reformat data with the Data Publisher, you can use function fnRowCallback in advanced settings. Here is an example:

      To reformat data with Data Projects, you can use filter wpda_column_default. Here is the (minimal) documentation:

      Let me know if you need help!

      Best regards,

      1. Thank you very much Peter, I’m on the right path now! Here are the solutions I came up with both have good results but I need a little more help with the Data Publisher for the different views.

        For the Data Publisher, here is a solution, however I have to continually map the column number (in this example 3). If I change the column placement or more importantly change it to the responsive view, this breaks. Is there a way to map it by name of the column instead of the number, or change the output for all views? Not sure if it’s possible, but I’d prefer a PHP hook solution for the Data Publisher:

        { “fnRowCallback”: “function(row, data, index) { var amount = data[3] / 100; var dollar = ‘$’ + amount.toFixed(2).toString(); jQuery(row).find(‘td:eq(3)’).html(dollar); }” }

        For the Data Projects I copied your example function, and added a little bit to it. (Note: in the example function you have a “$this” parameter that throws an error, did you mean for that to be “$self”?). Anyway, this function works for me:

        function my_column_default(
        ) {
        if ( ” !== $value ) {
        return $value;

        if ( ‘dutch’ === $column_name ) {
        return ‘NL-‘ . $item[ $column_name ];

        if ( ‘transaction_amount’ === $column_name ) {
        return ‘$’.number_format(($item[ $column_name ] / 100), 2, ‘.’, ”);
        add_filter( ‘wpda_column_default’ , ‘my_column_default’ , 10 , 8 );

        This is perfect! I’m not sure if this is the correct way to do it but it gives the right output. I was initially trying to use $value but it appeared empty when I did the console.log($value) output. This works so I’m happy with it. Thank you for all your help!

        1. Hi Cory,

          You are right, parameter $this needs to be $self. Thank you for reporting! I updated the code.

          The Data Publisher uses the column sequence number, not the column name. Right again! 🙂 This has a number of advantages, but I understand your need to use the column name. I added your comment to my to do list.

          Thank you for sharing your solution! 🙂

  3. I’ve moved my site from GoDaddy to SiteGround. Since the move my WPDA publications aren’t working… I’m not connecting to my remote database. I see that the Settings/Plugin/Secret Key and IV are not populated but I don’t know if they were at GoDaddy.

    Please help.

  4. Hi Mike,

    You can find your remote database connections in your options table, option name = wpda_remote_databases. Please be aware that these values are hashed. To make them available on your new server, you need to copy your old secret key and iv to your new server BEFORE you copy the wpda_remote_databases option. You can also just add the remote connection from the Data Explorer.

    Hope this helps,

Leave a Reply

Your email address will not be published.