Okay
  Public Ticket #3162509
Product features
Closed

Comments

  • Amol started the conversation

    Hello!

    I need to publish a directory of companies including their basic profile data (name, location, description, funding metrics, service metrics, etc.) all on separate pages (each company has their own dedicated profile page.  Not too dissimilar to Crunchbase where each company has their own profile page (e.g. https://www.crunchbase.com/organization/agrocenta).  I am currently aggregating all this company profile data in a database (e.g. MS Excel).  

    I'd like to know if WPdataTables can help me here - specifically, can I use WPdataTables to create separate pages from a single database (one page per row) and display data contained in that row?  

    My database has one row per company and I'd need a separate, dedicated page created per row.  e.g.:

    Row 1 contains all the profile data on company 1 and needs to be published to a dedicated page, its own profile page.

    Row 2 contains all the profile data on company 2 and needs to be published to a dedicated page, its own profile page.

    Is this feature available via WPdataTables (publishing individual rows to separate pages?  

    Thank you in advance!

  •  1,846
    Miloš replied


    Hi, Amol 

    Sorry for the late reply

    -

    Yes, i believe you should be able to achieve this by making dynamic SQL Queries with placeholders.

    For example, you could make an SQL Query for a table like this :

    SELECT * FROM my_table
    WHERE my_field = '%VAR1%'

    You can make a field/column that will hold all the Companies names;

    and then you can set different shortcode for each Company page.

    For example, for Company A,  you can set shortcode

    [ wpdatatable id=1 var1='Company A name' ]

    Then, page for company 2

    [ wpdatatable id=1 var1='Company B name' ]

    and so on.

    Let me know if that might work for you?

    And you can check more details on Making dynamic SQL Queries with placeholders here.

    -

    And i just wanted to point out that you can try wpDataTables before purchasing

     on our sandbox Demo sites ( you can find links for the main plugin Demo,  

    as well as add-on Demos, in my signature),

    and there is a 15-day money-back guarantee period, 

    so if you purchase the plugin, you can safely fully test it out, and if it doesn't fit your needs you can request and receive a refund in that period. ( same goes for all plugins and add-ons)

    Let me know if you have any additional questions. smile.png


    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