bobbysmith007

I am not sure that I have ever fully debugged the async data part of things. It definitely would be nice to be able to have it handle automatically chunking and pulling the data at reasonable rate.

One thing I have done to resolve this without ajax data is to manually page the data by some reasonable metric (eg: only show records entered in the last 6 months) and then to have buttons rendered on the DBTE page that allow you to change the paging parameters.

I think there is an example in the examples folder:
https://github.com/AccelerationNet/wp-db-table-editor/blob/master/examples/paging.php
https://github.com/AccelerationNet/wp-db-table-editor/blob/master/examples/payment-paging.js

Sorry for the late reply, I guess I missed the notification on this.

The answer is to set the ‘id’ attribute of each table to something different. By Default it uses the value of “table” as the table id, but since you have defined three with the same table and none have an id, each one overwrites the previous.

Cheers,

Yes. By default you can filter the table many ways. You can have separate tables that use different where clauses. Also at the top of each column is a filter that will remove non matching entries.

Use the sql paramater to add_db_table and adda where clause:

Something like this:

  $sql =<<<SQL
     SELECT * FROM event_registrations 
     WHERE name='Only This One'
     ORDER BY date_entered DESC
SQL;
  add_db_table_editor(array(
    'title'=>'Event Registrations',
    'table'=>'event_registrations',
    'sql'=> $sql
  ));

You probably should start with the readme file and the examples included in the examples directory

Cheers,

>IMPORTANT: The only problem is that possibly I found a bug – with the large table the row “NEW” is missing and at the console there is a message (which seems is related):

>Couldnt find a column: id defaulting to noedit

If the new row is missing it is because you dont have edit permissions, or there is no id column specified. The table MUST have a single column unique id in order for the plugin to work. By default it assumes the column name is id, however you can set it to one of the other columns as long as it is unique. What I tend to do is just add a new id auto_increment column to any table missing one, even if its only use is for this plugin.

SlickGrid is the underlying project used for table rendering, and I have found it to be a pretty dang good implementation!

Howdy, thanks for your review, this plugin was definitely written by a full time programmer for programmers.

I have added manual pagination based on date ranges / years, etc, by changing what query is used, based on query string parameters. There are some examples of this in “examples/paging.php”.

At one point I started working on ajax data feeds to allow continuous scrolling of “unlimited” data with it being loaded as needed. I dont remember what the outcome of that work was, but it never came to full fruition. Looking through the code for async_data might yield more information.

Glad you find this plugin useful

1.6.4 should be the version number with this fixed up

I applied a patch which sets noedit to true on the client if it fails the editcap check on the server. That should hopefully take care of it.

I am looking into this, but am actually running into the opposite problem right now. The read capability which *used* to be used to see if a user can access the user_profile page is now not seeming to work. So its possible that an update needs to be made.

I havnt used this plugin extensively in read only mode, so its possible mistakes were made.

What are you expecting from what part of that config. The only column marked as not editable is “E_ID”? Is that inappropriately editable?

Is it that users without edit_others_posts are able to edit?

Glad you figured it out.

I updated the parameters information to hopefully be a little more clear (though my changes dont help too much). Those and most options give the default value ( in this case its edit_others_posts). Perhaps you are unaware of cap / capability as a standard wordpress term: https://codex.www.ads-software.com/Roles_and_Capabilities. Since these are not enumerable (they can be customized) and are a standard part of wordpress, it didnt make sense to try an list them all.

Most of the options do not have an enumerable list of possible values, but are customizable eg: “what function name do you want to call” cannot be filled in with anything meaningful because its whatever custom function name you write. Others are boolean flags. I have tried to add an example value for each option. Feel free to request more assistance if you need.

If you need more specific help please do let me know.

There are examples in both the README and the examples directory.

https://github.com/AccelerationNet/wp-db-table-editor/blob/master/README.md
https://github.com/AccelerationNet/wp-db-table-editor/blob/master/examples

If you are looking for a specific example please let me know, but I think most of the things you would need to do in those places (but perhaps not obviously labeled).

Alright, I just posted version 1.6.1 which creates a form and posts it instead of using a GET request. It seems to work for me and should resolve this issue.

Perfect glad you like it and find it useful!

I recently switched the CSV export from calculating the export server side to calculating the excerpt client side. So basically it is going to request a URL with every id from the table in it (?action=wp_ajax_dbte_export_csv&ids=1,2,3,4,5… so if that string gets long you can exceed the server/browsers URL / url param limit.

Apache supports an 8000 char limit by default, perhaps the browser is blocking it.

Maybe look here:
https://stackoverflow.com/questions/7724270/max-size-of-url-parameters-in-get

—-

Its possible that I need to run the export as a post instead of an ajax request if the url parameter string is too long.

You might try experimenting with changing the Definition of DBTableEditor.exportCSV to try posting to that URL instead of redirecting. I probably wont get to this today. But if you cannot get it resolved, I might be able to help soon.