UPDATE problem
HELP! after upgrading to version 1.0.3 - March 14, 2017, some reports are no longer working.
Page (and the preview report) return HTTP ERROR 500.
I already made the re-upload, deactivated and reactivated the plugin but nothing changes.
I also tried to create a new report.
Obviously, before the update, these simple reports were working fine..
n.b. page in error: admin-ajax.php
Put variables in rows
When I use a variable (in excel file), the report writes it once, I would need to repeat it for each row in the table, something like ${myvariable.all}
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.
These errors are probably because of some bad variable name in the template. I have tried to generate reports with ID 1 and 2 and they are working. Reports 3, 4, 5 are not working. Also I tried to see template of the report with ID 3 from this link:
But when I click on it I got the message that page doesn't exists: "Spiacente, ma la pagina richiesta non esiste. Forse fare una ricerca potrebbe aiutare.". Are you sure you have the template on this address?
These reports worked for you in version 1.0.2 or you created them now?
hello Milos, you're absolutely right, the association with the template it was wrong, even though I have no idea why ... these are reports that already existed from the previous version. Thus, Reports 3 and 4 now work perfectly :)).
The problem now remains only on report number 5 (sounds like the Mambo ...),, the .xlsx file exists but the report does not work, with the same error.
Have you also an idea on how to solve the problem with variables in rows?
The issue with Report with ID 5 is probably because of some wrong name of the column or variable. Can you check if the names are same as column original headers - Link. Please note that they are case sensitive. If that is not the case I will login and take a look a little more closer what is happening.
Unfortunately it is not possible to use variables in this way like ${myvariable.all}. Only way to use it is as a single value like ${myvariable}.
yes, maybe it's time that you take a look, the names are right, the problem is that the Report Builder does not accept XLSX file, or have problems with Generation logic: single file.
I tried to flank the report 6 that generates a docx on the same wpdatatable and it works.
Generally it does not work with any report template .xlsx
From WordPress 4.7.2 there is a one bug by WordPress (they said they will fix in the next update) when you try to upload Excel or CSV file. So when I try to add a new template I got this message "Questo tipo di file non è consentito per questioni di sicurezza.". Please go in wp-config.php file of your WordPress and add this line at the and of page:
define('ALLOW_UNFILTERED_UPLOADS', true);
Until then I am not able to upload the template. When you do that please notify me so I could test Report with ID 5.
Can you check do you have installed PHP ZIP Archive on your server. Probably that is the reason why it's not working. You can contact your Host provider to install it for you or you can install it by your own. All reports that are working are ZIP with multiple files for each row except this with ID 5 that is Single file report?
Hi Milos, I have not quite clear what you say. "All reports that are working are ZIP with multiple files for each row." This to me means that php zip is available ...
ID5 is a single file .xlsx report, How could it be php zip not enabled, if the single report does not use php zip?
SUMMARY
ID 1 - ID 2 - 3 ID - ID 4, which are DOCX "ZIP files with multiple files for each row", all work
ID 5 That is Single report file (XLSX NO ZIP), does not work.
ID 6 That is Single report files (DOCX NO ZIP) works fine.
XLS does not work with either "ZIP with multiple files for each row" and "Single File"
I'm not able to give solutions but, for me, it is clear that the .xls / .xlsx files do not work.
Yes I enabled debugging mode, but now I turned it off. The error that I am getting when I am trying to download report from ID 5:
Fatal error: Class 'PHPExcel_Worksheet_HeaderFooter' not found in /web/htdocs/www.zconsulting.it/home/mediazione/wp-content/plugins/wpdatatables/lib/phpExcel/PHPExcel/Worksheet.php on line 348
Report with ID 6 is using the same table as Report with ID 5? So probably the issue is in the template. This is the error when there is something wrong with the template. Can you try to create a new one from scratch?
Yes, Report with ID 6 is using the same table as Report with ID 5.
I created a new .xlsx file with only one field but the problem remains. With the same installation of excel I also saved as .doc but the result is the same. I use Excel 2010 and Excel 2016 Could you put an excel file made by you? Report Builder ID 5 wpdatatable id 12 field: ${stato.all}
It is fixed now. Some files from PHPExcel lib are not uploaded probably when you were uploading wpDataTables plugin. I have added these two files and now downloading report is working. Sorry we needed so much time to investigate this issue.
Milos, you are the best! I had imagined that the fault was mine. many apologize for the time that I did miss you, sometimes cuteftp has some problems with the files and warns me that one or more files already exist (but this is untrue). I must investigate the other debugging alerts.
Good morning,
UPDATE problem HELP! after upgrading to version 1.0.3 - March 14, 2017, some reports are no longer working. Page (and the preview report) return HTTP ERROR 500. I already made the re-upload, deactivated and reactivated the plugin but nothing changes. I also tried to create a new report. Obviously, before the update, these simple reports were working fine..
n.b. page in error: admin-ajax.php
Put variables in rows When I use a variable (in excel file), the report writes it once, I would need to repeat it for each row in the table, something like ${myvariable.all}
Hi Axelmet,
Thank you for the purchase.
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 Axelmet,
These errors are probably because of some bad variable name in the template. I have tried to generate reports with ID 1 and 2 and they are working. Reports 3, 4, 5 are not working. Also I tried to see template of the report with ID 3 from this link:
http://www.zconsulting.it/mediazione/wp-content/uploads/2017/02/Lettera-convocazione-istante.docx
But when I click on it I got the message that page doesn't exists: "Spiacente, ma la pagina richiesta non esiste. Forse fare una ricerca potrebbe aiutare.". Are you sure you have the template on this address?
These reports worked for you in version 1.0.2 or you created them now?
hello Milos, you're absolutely right, the association with the template it was wrong, even though I have no idea why ... these are reports that already existed from the previous version. Thus, Reports 3 and 4 now work perfectly :)).
The problem now remains only on report number 5 (sounds like the Mambo ...),, the .xlsx file exists but the report does not work, with the same error.
Have you also an idea on how to solve the problem with variables in rows?
Hi Axelmet,
The issue with Report with ID 5 is probably because of some wrong name of the column or variable. Can you check if the names are same as column original headers - Link. Please note that they are case sensitive. If that is not the case I will login and take a look a little more closer what is happening.
Unfortunately it is not possible to use variables in this way like ${myvariable.all}. Only way to use it is as a single value like ${myvariable}.
Thanks.
yes, maybe it's time that you take a look, the names are right, the problem is that the Report Builder does not accept XLSX file, or have problems with Generation logic: single file.
I tried to flank the report 6 that generates a docx on the same wpdatatable and it works.
Generally it does not work with any report template .xlsx
I'm demoralizing :(
thank you
Hi Axelmet,
From WordPress 4.7.2 there is a one bug by WordPress (they said they will fix in the next update) when you try to upload Excel or CSV file. So when I try to add a new template I got this message "Questo tipo di file non è consentito per questioni di sicurezza.". Please go in wp-config.php file of your WordPress and add this line at the and of page:
define('ALLOW_UNFILTERED_UPLOADS', true);Until then I am not able to upload the template. When you do that please notify me so I could test Report with ID 5.
I added the line to the config, though I always loaded .xlsx template with no problems
Hi Axelmet,
Sorry for delayed reply.
Can you check do you have installed PHP ZIP Archive on your server. Probably that is the reason why it's not working. You can contact your Host provider to install it for you or you can install it by your own. All reports that are working are ZIP with multiple files for each row except this with ID 5 that is Single file report?
Hi Milos, I have not quite clear what you say.
"All reports that are working are ZIP with multiple files for each row." This to me means that php zip is available ...
ID5 is a single file .xlsx report, How could it be php zip not enabled, if the single report does not use php zip?
SUMMARYXLS does not work with either "ZIP with multiple files for each row" and "Single File"
I'm not able to give solutions but, for me, it is clear that the .xls / .xlsx files do not work.
I hope to have written properly
Thanks
Hi Axelmet,
Yes I enabled debugging mode, but now I turned it off. The error that I am getting when I am trying to download report from ID 5:
Fatal error: Class 'PHPExcel_Worksheet_HeaderFooter' not found in /web/htdocs/www.zconsulting.it/home/mediazione/wp-content/plugins/wpdatatables/lib/phpExcel/PHPExcel/Worksheet.php on line 348
Report with ID 6 is using the same table as Report with ID 5? So probably the issue is in the template. This is the error when there is something wrong with the template. Can you try to create a new one from scratch?
Hi Milos,
Yes, Report with ID 6 is using the same table as Report with ID 5.
I created a new .xlsx file with only one field but the problem remains.
With the same installation of excel I also saved as .doc but the result is the same.
I use Excel 2010 and Excel 2016
Could you put an excel file made by you?
Report Builder ID 5
wpdatatable id 12
field: ${stato.all}
you can modify it freely
tanks
Hi Axelmet,
It is fixed now. Some files from PHPExcel lib are not uploaded probably when you were uploading wpDataTables plugin. I have added these two files and now downloading report is working. Sorry we needed so much time to investigate this issue.
Milos, you are the best!
I had imagined that the fault was mine.
many apologize for the time that I did miss you, sometimes cuteftp has some problems with the files and warns me that one or more files already exist (but this is untrue).
I must investigate the other debugging alerts.
Thanks again
Hi Axelmet,
No problem, you are welcome
We'd greatly appreciate it if you could take a minute and leave a review on CodeCanyon on this link. Thanks!
I can not! due to a fault on CodeCanyon (attach)
Hi Axelmet,
Thank you for your great review. Gravity form integration is something that we are working on