Rich

Thank you, Charles!

I entered this into the Advanced Options:

{
????“loadingRecords”: “Loading the Diary Entries…”,
????“processing”: “Loading the Diary Entries…”
}

When the page loads, it still says just “Processing…”

If I add the word “language”: before the code as you did, I get a “Parse error on Line 1” error message.

I’m sorry for the confusion on this, Peter. I didn’t notice that when I updated the free version (WP Data Access) that it was DEACTIVATED in my site because I have the Premium version (WP Data Access Premium) installed and activated. So I initially updated something that was not an active plugin.

I would be happy to test and confirm that this works on the free version, but when I click to deactivate the Premium Version I get a warning message saying, “…Deactivating or uninstalling the plugin will automatically disable the license…” Consequently I am hesitant to do that.

I’m also not sure about just activating the free version, when the Premium version is also active.

Your advice would be appreciated.

IT WORKS!

On THIS PAGE there are 7 tables. I can use wpdataaccess pub_id=”1″ in all of them now, and the page properly displays.

A note on the update…
Make sure people know they need to update the WP Data Access Premium plugin. I first updated only the basic “WP Data Access” plugin and this update did not work. It was not until I updated the PREMIUM version of the plugin that everything worked OK.

Nicely done!

Peter, have you made any progress on the multiple table display on a single page issue?

I’m using your plugin extensively now in THIS SITE, and it is working very well. I am so glad I found this!

The site where I’m using your plugin would be a good beta test site. I can easily set up a test page and try out the code there, with different filters in the various tables.

If you have concerns about the new code causing unanticipated problems, I have a couple other low-traffic domains where we could try it. They are also WordPress sites.

Thanks again for your wonderful plugin!

Thanks again for a very informative answer.

For now I made seven tables, all the same, for handling those pages where multiple tables appear on the same page. That was the maximum number I needed for a multiple item page. The code I used was this:

<h2 id=”barrels”>BARRELS & CANS</h2>
[wpdataaccess pub_id=”1″ filter_field_name=”sub_category” filter_field_value=”barrels”]

<h2 id=”boats”>BOATS</h2>
[wpdataaccess pub_id=”2″ filter_field_name=”sub_category” filter_field_value=”boats”]

If you go to THIS PAGE, you can see how I implemented it.

If you can come up with an easier way, I’ll be your beta tester.

• This reply was modified 2 years, 1 month ago by Rich.
• This reply was modified 2 years, 1 month ago by Rich.

I got the html table formatting figured out! I did some digging in the Code Manager and found the right codes to use to make my tables look the way I want them to look.

THIS PAGE will show you the result.

I think I know how to solve the multiple tables on the same page problem. That’s next on my research time line.

Absolutely LOVE this plugin!

Peter, I appreciate your fast response, and on a weekend no less!

Your answer has solved SOME of my issues, but not all. The static filters feature is going to save me TONS of work!

However, I still need help with:

• How to set the header background and font colors
• How to set the border width and color

My understanding of CSS is a bit too limited to be able to figure this out on my own.

I also have a new issue that I had not anticipated. On several pages in this site, I display multiple tables using different “WHERE” sql commands. However, if I attempt to place two instances of a table on the page with different static filters, I get this error message:

“DataTables warning: table id=3d_projects1 – Cannot reinitialise DataTable. For more information about this error, please see https://datatables.net/tn/3.&#8221;

I have gone to the URL and read the page, but the info presented there is a bit beyond my level of understanding. Can I place multiple instances of the same table on a page, or will I need to generate a few extra tables for this?

I absolutely love this plugin! Once I get these details figured out, I’ll be in business!

Thanks again, Stephen. I must say, you are very responsive on this plugin. That is a good thing. I understand how things work now and I really like this plugin.

I have my fingers crossed that you can write the code for appending data to an existing table, as we are discussing in the other thread.

Stephen,

Your question is a very good one.

My Great-Grandfather’s diary project is a collaborative effort between myself, my two brothers, and my sister. We have divided the work flow so that we each have certain years of diary entries we are going to transcribe from the diary pages into text. With 9,000+ entries, that’s a lot of typing for each of us!

They don’t know how to work in the WordPress back end. But they all know how to use a spreadsheet and have the software to do it. That’s why I suggested it would be easier to make all these entries in a spreadsheet.

If we had the option to append data to an existing table, I could import their diary entries into the table as they finish them.

I hope that gives you a better understanding of our specific project.

Rich Melvin

Stephen,

Thanks again for the prompt reply. You will be happy to hear that I found the problem.

When I originally set up this table, the search function was NOT turned on in the admin interface. Later, after the table had been built, I set the search to “ON” in the admin interface. However the shortcode on the page contained the parameter “search=”0”. When I changed that to read “search=”1″ the search window appeared and the search worked. The full shortcode now reads:

[tablesome table_id=”1809″ search=”1″ hide_table_header=”0″ sorting=”0″ filters=”0″ page_limit=”15”]

If I have interpreted this problem correctly, if you make a change in the back end after a table has been built, as I did with the search function, the shortcode has to be re-copied and re-inserted into the page. The plugin does not automatically make the change. That is not clear in the instructions.

Thanks for the reply, Stephen. This would make Tablesome much more useful to people who are going to use the plug-in to display a large amount of data, entered over a period of time. In my case, entering the data (approx. 9,000 entries!) in a spreadsheet for a later import is much easier than trying to enter it directly in Tablesome.

Good luck on the code-writing. I will look for this update down the road somewhere.

The way the fixed first column works right now is to lock it in place horizontally. As someone scrolls horizontally in a table, the first column remains in place. However, it will move vertically if a user scrolls the table vertically.

I wanted the first column to remain in place VERTICALLY, so as a user scrolled a table vertically, the first column would remain in place at the left.

I know this is an unusual way to do this, but I have an unusual application for the table. It will have only two columns (three if this new first column option comes to be) but it will have about 8,000 rows. You can see a testing page for this project HERE.

I now see how it works and it is not what I thought it was. I won’t need this feature.