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?
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)
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!
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 :
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.
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 | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia 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