Hi
I am very happy with the ease of implementation of WP Data Access – certainly in comparison with my previous db manager. I’m currently setting it up for a small charity (not yet live) and it has been very easy and intuitive. I’ve hit one stumbling block which is I can’t seem to download SQL code to import into code manager. I select the ones I want and hit download but I keep getting almost completely empty files:
EXAMPLE
—
— Code Manager table export
— Code IDs are not exported. New IDs are generated on import.
—
I guess I’m doing something wrong but can’t think what – probably something obvious. So any suggestions?
Many thanks and keep up the good work (excellent video btw, very easy to follow)
Mike Creighton
I don’t think you can do this with CSS. But you can do it with JavaScript:
– Open advanced settings
– Add option rowCallback
Here is an example which adds a $ in front of each column with 1: { "rowCallback": "function(row, data, index) { jQuery(row).find('td:eq(1)').text('$ ' + data[1]) }" }
Hi
I am very happy with the ease of implementation of WP Data Access – certainly in comparison with my previous db manager. I’m currently setting it up for a small charity (not yet live) and it has been very easy and intuitive. I’ve hit one stumbling block which is I can’t seem to download SQL code to import into code manager. I select the ones I want and hit download but I keep getting almost completely empty files:
EXAMPLE
—
— Code Manager table export
— Code IDs are not exported. New IDs are generated on import.
—
I guess I’m doing something wrong but can’t think what – probably something obvious. So any suggestions?
Many thanks and keep up the good work (excellent video btw, very easy to follow)
Mike Creighton
Hi Mike,
That was a bug! I fixed it right away.
Thank you for reporting! 🙂
Peter
ok !!!
But… what about format numbers (commas, decimals, negatives, etc…)?
ej.
6168068.465546 —> 6,168,068.46
-16.654 —> 16.65%
4990.00 –> $4,990.0
6168068.465546 —> 6,168 k
Saludos!
Hi Jonas,
I don’t think you can do this with CSS. But you can do it with JavaScript:
– Open advanced settings
– Add option rowCallback
Here is an example which adds a $ in front of each column with 1:
{ "rowCallback": "function(row, data, index) { jQuery(row).find('td:eq(1)').text('$ ' + data[1]) }" }
Advanced settings and options are explained here:
https://wpdataaccess.com/docs/documentation/data-publisher/advanced-settings/
The rowCallback option is explained here:
https://datatables.net/reference/option/rowCallback
Hope this helps,
Peter