Okay
  Public Ticket #3820456
Compatability of wpdatables with portfolio plugin
Open

Comments

  • MR S Ravisangar started the conversation

    I have many tables i have set up in wpdatatables pro version and I wish to go with a wordpress portfolio plugin that can work with my tables in wpdatatables so that I it can take the specified info from my tables so i don't have to do the same work in both plugins.  Is there one that you know of?

  •  1,877
    Miloš replied

    Hello,

    I am sorry to disappoint you, but we don't have a native integration with any portfolio Plugin.

    I am not familiar with how portfolio Plugins are used exactly and where their data is stored, but I presume that, as most WP Plugins, they probably have data stored in multiple SQL tables int the WP database.

    In order to pull data like that, you can try two ways for our tables :



    1. Custom SQL Queries :

    As the custom posts/fields, are a part of the WordPress database;

    pulling this data can only be done through MySQL query-based tables.

    Please note: Using this plugin feature requires at least a basic knowledge of SQL. It is assumed that you can create the table in some MySQL data manager (e.g., PHPMyAdmin, MySQL Workbench), and prepare a SQL query that will return the data you need. 

    A good way to achieve this can be experimenting using our WPDB SQL Query Constructor tool.

     

    You can also try this other SQL Query helper Tool,

    Create a MySQL-query-based table by querying a database,

    that one has a wider range of all tables you can choose from your Database outside of WPDB.

     

    - Please note: this tool is not an ultimate query generator. It simply constructs a suggestion of a query. We are constantly working to improve it, but SQL is such a complicated and flexible language that full automation for constructing queries is next to impossible. 

    Consequently, the more complicated the query, the higher is the probability that it will not return exactly what you need. So, you will often need to play around with the resulting query.

     

    Please be advised that writing custom SQL Queries or debugging Queries does not fall under what our support covers.

    You can check out this official page of WP codex,  for help with writing custom Queries.

     

    If you manage to get a Query working  directly in your PHPMyAdmin ( or any other DB management Tool) to return the resulting Table as needed in the Database;

    You can then first try the same Query in our table.

    If our Table doesn't return it exactly as needed - our Plugin is not the same as a Database management Tool, it is running all our Queries through a PHP & SQL Parser.

    If that happens, you can prepare a MySQL view directly in your Database (which will return the data that you need, call it e.g. “view1” and then build a wpDataTables based on a simple query like "SELECT * FROM view1″.

     

     If you need help with that, you can see our video, where we show an example of using an SQL View in our plugin.

     

     

    2. We also have the WP Post builder integration.
    You can try making a WP Posts table and try to configure it to filter only the portfolio Plugin's data.
    You will need to somehow check if that plugin has specific post category, tag, etc and to configure the filtering options in our WP Post table accordingly, so it only shows the data you need.

    I hope that helps.


    If you wish to see a future native integration with a specific portfolio plugin:

    Please feel free to search on our suggestions page

     to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there,  and as more people vote, the feature will move higher on the priority list.

    You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;

    and our newsletter, so you're informed about new features, bug fixes, freebies, etc.

    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables