I am attempting to create a test table and chart with your plugin and have had a problem with the table constructor. I am hoping WPDatatables can replace Tablepress on my site as it claims to be able to generate tables from data stored in Custom post types. It sounded so good......but things not looking promising right now.
I select the Post type I want to include in the table.
The problem is with the post properties list which then populated with only some of the post properties from the Custom post type.
I have created custom post types using WP-Types Toolset and have created 11 fields within the Post type in question but only 2 of the 11 show up in the list in Table constructor...and not the ones I want to run the test I am doing to evaluate your plugin
I cannot find any differences between the fields that have been included and those that have not.
I attach the list of fields from the post type "Ranking Data" and the list from Table constructor (scrolled down to the bottom). The test I am trying to run is on the property ranking-data.meta.wpcf-overall-score.
I tried generating the table with a different property: ranking-data.meta.wpcf-rank and then editing the query that is generated to refer instead to ranking-data.meta.wpcf-overall-score but this did not return any results despite data being stored against that field.
I also tried running a test on a different post type selecting properties that I know have content but got "no results were found" when I tried to generate the table.
I have around 700 rows of data if that is at all relevant.
In your database in table ranking-data do you have ranking-data.meta.wpcf-overall-score column? Can you enter you database via phpMyAdmin or any other database administration tool that you are using and see do you have that 11 columns in that table? Are you sure that WP-Types Toolset is storing that column in ranking-data table?
I don't currently have access to the database by virtue of how my site is being hosted... I contact my hosting providers to get this but it will take time.
I realise it doesn't answer your question directly but I am using WPAllimport and WPAllexport and when I run an export on the Relevant post type - "ranking data" I get all WPCF fields associated with Ranking data as per the attachment and no others.
Can you try with 4th option "I want to construct a table based on data from existing MySQL DB tables" where you can see all tables and columns from that tables that are located in database?
Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials just check PRIVATE so nobody can see it except us.
If you take a look at our documentation you can see that wpDataTables Constructor is just a helper:
"Please note that MySQL query constructor is not an ‘ultimate generator’, it should be consider a helper that constructs a suggestion of a query trying to ‘guess’ what you want. We constantly work on improving it, but SQL is such a complicated and flexible language that full automation for constructing queries is hardly possible. So the more complicated your request is, the higher is the chance that it will not return exactly what you need. Play around with the resulting query to achieve better results."
It is very hard to find universal solution for Custom Post types because they are not always in same tables in database. The best solution to write MySQL query by your own and try to execute it in phpMyAdmin or any other database system administration tool and see does it returns data that you want. If you are not skillful with MySQL query and we will create this query and table for you. Just please describe us exactly what you want to fetch from database, what columns you want to show in tables and do you want to have some condition in that query.
Also please provide me credentials of your database just mark PRIVATE so nobody can see it except us.
I have changed the fields in the Custom Post type, adding a bunch of fields. I noticed that all new fields appeared in the table constructor so I created a new field to replace the one that was not appearing... I tried the constructor again.. no luck but then I thought to add content to a test post in that field... and hey Presto!! the new field appeared in constructor ... YAY!!!... so I am dumping the old field and going with the new one. I have yet to create a table but will get back to you if I have problems with that.
I am attempting to create a test table and chart with your plugin and have had a problem with the table constructor. I am hoping WPDatatables can replace Tablepress on my site as it claims to be able to generate tables from data stored in Custom post types. It sounded so good......but things not looking promising right now.
I select the Post type I want to include in the table.
The problem is with the post properties list which then populated with only some of the post properties from the Custom post type.
I have created custom post types using WP-Types Toolset and have created 11 fields within the Post type in question but only 2 of the 11 show up in the list in Table constructor...and not the ones I want to run the test I am doing to evaluate your plugin
I cannot find any differences between the fields that have been included and those that have not.
I attach the list of fields from the post type "Ranking Data" and the list from Table constructor (scrolled down to the bottom). The test I am trying to run is on the property ranking-data.meta.wpcf-overall-score.
I tried generating the table with a different property: ranking-data.meta.wpcf-rank and then editing the query that is generated to refer instead to ranking-data.meta.wpcf-overall-score but this did not return any results despite data being stored against that field.
I also tried running a test on a different post type selecting properties that I know have content but got "no results were found" when I tried to generate the table.
I have around 700 rows of data if that is at all relevant.
Can anyone please suggest a solution?
Cheers
Peter
Hi peterveebee,
Thank you for your purchase.
In your database in table ranking-data do you have ranking-data.meta.wpcf-overall-score column? Can you enter you database via phpMyAdmin or any other database administration tool that you are using and see do you have that 11 columns in that table? Are you sure that WP-Types Toolset is storing that column in ranking-data table?
Milos
I don't currently have access to the database by virtue of how my site is being hosted... I contact my hosting providers to get this but it will take time.
I realise it doesn't answer your question directly but I am using WPAllimport and WPAllexport and when I run an export on the Relevant post type - "ranking data" I get all WPCF fields associated with Ranking data as per the attachment and no others.
Cheers
Peter
Hi peterveebee,
Can you try with 4th option "I want to construct a table based on data from existing MySQL DB tables" where you can see all tables and columns from that tables that are located in database?
Milos
I cannot find any wpcf custom posts or properties in that table.... unless I am looking in the wrong place
Peter
Hi peterveebee,
Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials just check PRIVATE so nobody can see it except us.
Hi peterveebee,
If you take a look at our documentation you can see that wpDataTables Constructor is just a helper:
"Please note that MySQL query constructor is not an ‘ultimate generator’, it should be consider a helper that constructs a suggestion of a query trying to ‘guess’ what you want. We constantly work on improving it, but SQL is such a complicated and flexible language that full automation for constructing queries is hardly possible. So the more complicated your request is, the higher is the chance that it will not return exactly what you need. Play around with the resulting query to achieve better results."
It is very hard to find universal solution for Custom Post types because they are not always in same tables in database. The best solution to write MySQL query by your own and try to execute it in phpMyAdmin or any other database system administration tool and see does it returns data that you want. If you are not skillful with MySQL query and we will create this query and table for you. Just please describe us exactly what you want to fetch from database, what columns you want to show in tables and do you want to have some condition in that query.
Also please provide me credentials of your database just mark PRIVATE so nobody can see it except us.
Hi Peter,
Ok, just send us and link of your database when you are ready.
Milos
I have changed the fields in the Custom Post type, adding a bunch of fields. I noticed that all new fields appeared in the table constructor so I created a new field to replace the one that was not appearing... I tried the constructor again.. no luck but then I thought to add content to a test post in that field... and hey Presto!! the new field appeared in constructor ... YAY!!!... so I am dumping the old field and going with the new one. I have yet to create a table but will get back to you if I have problems with that.
Cheers
Peter
Hi Peter,
I am glad that you are making progress. Get back to us if you need any further help.