I've created a new test site (http://test.devcloud.guru) with no plugins other than wpDataTables (v 1.7.1) and Report Builder for wpDataTables (v 1.0.3)
I've created a new wpDataTable using MySQL of "SELECT user_login, user_email FROM wp_users"
I've created a new report based on the above table along with the following Word template:
Test Report – single report with all data ${wpDataTable.row} ${user_login} (${user_email}) ${/wpDataTable.row} End.
The report runs but the output is simply the same as the template, I.E. no ${} fields have been replaced with data.
N.B. I had to downgrade wpDataTables from v2 to v1.7.1 in order for the report builder to pick up the table I created - I presume this is correct and is simply that the report builder isn't yet compatible with v2?
Report Builder 1.0.3 is not compatible with version of wpDataTables 2.0 but we'll release new version that is compatible with 2.0 tomorrow. After that it takes at least 48 hours to be approved by Envato team.
About your issue please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check PRIVATE so nobody can see it except us.
We were really busy with creating Report Builder 1.1 that is compatible with wpDataTables 2.0. We pushed it today on CodeCanyon and it needs 24-48 hours to be approved by Envato team.
It seems that there is a bug when try to use this form with column that have _ (underscore) in column header:
You can try to use this template from the attachment. Just create the table in .docx file and place in it variables. You can find example on your website.
Probably tomorrow you'll be able to download Report Builder 1.1 from CodeCanyon. If you have any more questions don't hesitate to ask.
Thanks Milos - I will look again over the weekend then and see whether it's available and then try producing the report again. Thanks for the feedback / template.
Just had notification from CodeCanyon that the new version was there so wiped everything out and installed wpDataTables 2.0 plus latest ReportBuilder (1.1).
The table now shows up but I can no longer progress to the next screen ... I.E. I click the Next button (it registers the click with an animation) but still stops on that screen.
NB. Just in case, I've also changed the query I'm using so that it doesn't return underscores in the field name but no difference.
"The table now shows up but I can no longer progress to the next screen ... I.E. I click the Next button (it registers the click with an animation) but still stops on that screen."
- You are talking about Report Builder wizard or wpDataTables? I checked RB wizard and it seems that is working for me. Next button is going on the next step.
"NB. Just in case, I've also changed the query I'm using so that it doesn't return underscores in the field name but no difference."
Could you try to clear browser cache and to see does it work then? You can do that by clicking CTRL+F5 while you are on Report Wizard Page. You've updated the plugin and probably the old script is still loaded.
Doh - I should have tried that Milos - sorry ! Yes, that got me past the "Next" issue :)
However, the original issue is still there - if you log on to the site you will see two reports with two templates, one with underscores and one without. Neither report will extract data .... just can't figure out why :(
We are not working during the weekends. I tried to login with credentials that you've provided me before but I couldn't. Can you provide me again your credentials so I can take a look at the issue?
I guess that I found the issue. I am using Ubuntu 16.04 and for creating template I've use LibreOffice Writer and report was not working. Then my colleague created template with Word on Mac Book and Report was working fine. I have added that template to your report with ID 1 and it's called template3-1.docx. You can check that report is working.
What software did you use to create template? Can you try to use something else and see does it work then?
Aha! Yes, I can confirm the report works with the template you've posted. I created my templates with Word 2016 - I will try a couple of things (using Word 2013 and then using Word 2016 but in compatibility mode) and see what happens. Will post back my results shortly ...
Word 2016 - saving as "Word 2003 compatible" Error 500 when trying to download/produce the report.
Wordpad - saving as "Office Open XML Document": Produces report however, loading back in to Wordpad is fine but Word 2016 fails. (NB. Word 2016 loads the original Wordpad file - it's only after it's gone through the plugin that it can't open it any more)
Definitely some capability issues to work on by the looks of it :(
I will try and find a Word 2003 install and try that ...
Ok, as I was going through testing I decided to double check just a normal Word 2016 document - it worked fine!
It looks like I've found the original issue - if you simply hit enter at the end of each line when you are creating the template it works fine and pulls in data. However, if you use shift-enter (in order to keep the text in the same paragraph) it doesn't. I.E. the attached shows a picture of my template with the paragraph marks - the top section didn't work but the bottom section did.
[Update] It seems that as long as the ${wpDataTable.row} & ${/wpDataTable.row} statements are in separate paragraphs then anything between is handled correctly.
I've created a new test site (http://test.devcloud.guru) with no plugins other than wpDataTables (v 1.7.1) and Report Builder for wpDataTables (v 1.0.3)
I've created a new wpDataTable using MySQL of "SELECT user_login, user_email FROM wp_users"
I've created a new report based on the above table along with the following Word template:
Test Report – single report with all data
${wpDataTable.row}
${user_login} (${user_email})
${/wpDataTable.row}
End.
The report runs but the output is simply the same as the template, I.E. no ${} fields have been replaced with data.
Can you tell me what I'm doing stupid please? :)
N.B. I had to downgrade wpDataTables from v2 to v1.7.1 in order for the report builder to pick up the table I created - I presume this is correct and is simply that the report builder isn't yet compatible with v2?
Hi Steve,
Thank you for the purchase.
Report Builder 1.0.3 is not compatible with version of wpDataTables 2.0 but we'll release new version that is compatible with 2.0 tomorrow. After that it takes at least 48 hours to be approved by Envato team.
About your issue please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check PRIVATE so nobody can see it except us.
Hi Steve,
Sorry for delayed reply.
We were really busy with creating Report Builder 1.1 that is compatible with wpDataTables 2.0. We pushed it today on CodeCanyon and it needs 24-48 hours to be approved by Envato team.
It seems that there is a bug when try to use this form with column that have _ (underscore) in column header:
${wpDataTable.row}
Column1: ${column1.all}
Column2: ${column2.all}
…
${/wpDataTable.row}
You can try to use this template from the attachment. Just create the table in .docx file and place in it variables. You can find example on your website.
Probably tomorrow you'll be able to download Report Builder 1.1 from CodeCanyon. If you have any more questions don't hesitate to ask.
Thanks Milos - I will look again over the weekend then and see whether it's available and then try producing the report again. Thanks for the feedback / template.
Just had notification from CodeCanyon that the new version was there so wiped everything out and installed wpDataTables 2.0 plus latest ReportBuilder (1.1).
The table now shows up but I can no longer progress to the next screen ... I.E. I click the Next button (it registers the click with an animation) but still stops on that screen.
NB. Just in case, I've also changed the query I'm using so that it doesn't return underscores in the field name but no difference.
Any thoughts?
Hi Steve,
"The table now shows up but I can no longer progress to the next screen ... I.E. I click the Next button (it registers the click with an animation) but still stops on that screen."
- You are talking about Report Builder wizard or wpDataTables? I checked RB wizard and it seems that is working for me. Next button is going on the next step.
"NB. Just in case, I've also changed the query I'm using so that it doesn't return underscores in the field name but no difference."
- You've created a template with form like this:
${wpDataTable.row}
Column1: ${column1.all}
Column2: ${column2.all}
…
${/wpDataTable.row}
Or you added variable in the table in .docx file?
Sorry but still getting the same problem with the Next button (when trying to create a report). I'm using Chrome browser btw.
Would you mind watching the video below and seeing if you can spot anything I'm doing wrong?
https://cloud.familycliff.co.uk/s/I0QJFDuLgLCzI7C
NB. Obviously at this point I haven't even uploaded a template so it's nothing to do with that I suspect :)
Hi Steve,
Could you try to clear browser cache and to see does it work then? You can do that by clicking CTRL+F5 while you are on Report Wizard Page. You've updated the plugin and probably the old script is still loaded.
Doh - I should have tried that Milos - sorry ! Yes, that got me past the "Next" issue :)
However, the original issue is still there - if you log on to the site you will see two reports with two templates, one with underscores and one without. Neither report will extract data .... just can't figure out why :(
Hi Steve,
Sorry for delayed.
We are not working during the weekends. I tried to login with credentials that you've provided me before but I couldn't. Can you provide me again your credentials so I can take a look at the issue?
Hi Steve,
I will debug this issue today, and come back to you when I resolve it.
Hi Steve,
I guess that I found the issue. I am using Ubuntu 16.04 and for creating template I've use LibreOffice Writer and report was not working. Then my colleague created template with Word on Mac Book and Report was working fine. I have added that template to your report with ID 1 and it's called template3-1.docx. You can check that report is working.
What software did you use to create template? Can you try to use something else and see does it work then?
Aha! Yes, I can confirm the report works with the template you've posted. I created my templates with Word 2016 - I will try a couple of things (using Word 2013 and then using Word 2016 but in compatibility mode) and see what happens. Will post back my results shortly ...
Scenarios tested so far:
Word 2016 - saving as "Word 2003 compatible"
Error 500 when trying to download/produce the report.
Wordpad - saving as "Office Open XML Document":
Produces report however, loading back in to Wordpad is fine but Word 2016 fails.
(NB. Word 2016 loads the original Wordpad file - it's only after it's gone through the plugin that it can't open it any more)
Definitely some capability issues to work on by the looks of it :(
I will try and find a Word 2003 install and try that ...
Ok, as I was going through testing I decided to double check just a normal Word 2016 document - it worked fine!
It looks like I've found the original issue - if you simply hit enter at the end of each line when you are creating the template it works fine and pulls in data. However, if you use shift-enter (in order to keep the text in the same paragraph) it doesn't. I.E. the attached shows a picture of my template with the paragraph marks - the top section didn't work but the bottom section did.
[Update]
It seems that as long as the ${wpDataTable.row} & ${/wpDataTable.row} statements are in separate paragraphs then anything between is handled correctly.
Hi Steve,
I am glad that you have resolved the issue. This explanation helps me as well
Thank you.
We'd greatly appreciate it if you could take a minute and leave a review on CodeCanyon on this link. Thanks!