I'm using DocParser to parse invoices and enter the data into MySQL. I was wondering if I could write the data directly to the table(s) used by wpDataTables. This would complete the automation and give me an interface to the data.
That depends on how the data is stored in the database. If it's stored in a simple table, you would be able to call the database table with a simple query like:
SELECT * FROM docParserTable
So, you'd be creating an SQL query-based table that can be edited if the table contains a unique auto-increment column, which would be used as the editing value column in wpDataTables.
I'm using DocParser to parse invoices and enter the data into MySQL. I was wondering if I could write the data directly to the table(s) used by wpDataTables. This would complete the automation and give me an interface to the data.
Hello Rick.
Thank you for reaching out to us.
That depends on how the data is stored in the database. If it's stored in a simple table, you would be able to call the database table with a simple query like:
SELECT * FROM docParserTableSo, you'd be creating an SQL query-based table that can be edited if the table contains a unique auto-increment column, which would be used as the editing value column in wpDataTables.
Kind Regards,
Aleksandar Vuković
aleksandar.vukovic@tmsproducts.io
Rate my support
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