|
View:
New views
20 Messages
—
Rating Filter:
Alert me
|
|
|
no report specifiedHaving a bit of an issue here. Regardless of what report i choose from any module, I get either an ODS or ODT file with the words "no report specified" in it. I checked for errors, but there are none in any logs. Foes anyone know where to start looking in order to track this down? I running PHP 5.2.10 and updated my perp install 20 minutes ago from SVN. Any help would be appreciated, thanks.
Dan
|
|
|
Re: no report specifiedOn 11-Aug-09, at 11:25 AM, Dan Jankowski wrote: > Having a bit of an issue here. Regardless of what report i choose > from any module, I get either an ODS or ODT file with the words "no > report specified" in it. I checked for errors, but there are none in > any logs. I see this most commonly when the session times out before clicking 'Generate report', but this is not what's happening for you. The other case is when the template file cannot be found. What's your language preference set to? Nathan Gray nathan at goarctic dot com ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Perp-developers mailing list Perp-developers@... https://lists.sourceforge.net/lists/listinfo/perp-developers |
|
|
Re: no report specifiedEnglish / US It is actually the only language i have installed for egroupware via the setup. Also, when I go to open the ODS/ODT file, I am actually asked to convert/import it into OO. It is basically downloading as a plain text ascii file with an odt/ods extension instead...Thoughts? UPDATE: Was snooping around and found 'where' the "no report specified' comes from: perp_api/inc/class.ui_perp_report.inc.php - line 148 |
|
|
Re: no report specifiedOn 11-Aug-09, at 12:51 PM, Dan Jankowski wrote: > > > Nathan Gray wrote: >> >> What's your language preference set to? >> > > English / US > > It is actually the only language i have installed for egroupware via > the > setup. Also, when I go to open the ODS/ODT file, I am actually > asked to > convert/import it into OO. It is basically downloading as a plain > text > ascii file with an odt/ods extension instead...Thoughts? Weird. If there's anything more than "no report specified" in it, please send me one. Do the reports come with a filename like no_report.odt, or do they have a more fitting file name? Nathan Gray nathan at goarctic dot com ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Perp-developers mailing list Perp-developers@... https://lists.sourceforge.net/lists/listinfo/perp-developers |
|
|
Re: no report specifiedThe report name varies based on the module and report i choose. For example, if I try to report_invoice_report out of the AR module, I get a downloaded file named 'invoice.odt'. I used to get one with the invoice number in the filename. If I try to run report_general_ledger_listing out of GL, I get a file named 'general_ledger_listing.odt' (Attached) general_ledger_listing.odt UPDATE: somehow something changed and these files are actually EMPTY now. Not even a 'no report specified' message. Now I am confused. UPDATE2: The empty files above were generated with FireFox 3.0.13 as my client. The new one (below) was generated with Midori 0.1.9 as my web client. (attached). so Midori files have the 'no report specified' message, and Firefox reports are blank. invoice.odt |
|
|
Re: no report specifiedOn 11-Aug-09, at 1:43 PM, Dan Jankowski wrote: > > > Nathan Gray wrote: >> >> Weird. If there's anything more than "no report specified" in it, >> please send me one. >> Do the reports come with a filename like no_report.odt, or do they >> have a more fitting file name? >> > > The report name varies based on the module and report i choose. For > example, if I try to report_invoice_report out of the AR module, I > get a > downloaded file named 'invoice.odt'. I used to get one with the > invoice > number in the filename. If I try to run > report_general_ledger_listing out > of GL, I get a file named 'general_ledger_listing.odt' (Both > Attached) > > http://www.nabble.com/file/p24924232/invoice.odt invoice.odt > http://www.nabble.com/file/p24924232/general_ledger_listing.odt > general_ledger_listing.odt > > UPDATE: somehow something changed and these files are actually > EMPTY now. > Not even a 'no report specified' message. Now I am confused. > > UPDATE2: The empty files above were generated with FireFox 3.0.13 as > my > client. The new (below) where generated with Midori 0.1.9 as my web > client. > http://www.nabble.com/file/p24924232/invoice.odt invoice.odt Those are actually text files with an odt extension, so something is going awry in the generation process. Not quite sure where. What is your report file type preference set to? It might be worth checking to make sure that the default is set to ODT, and save it, even if it looks OK. Nathan Gray nathan at goarctic dot com ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Perp-developers mailing list Perp-developers@... https://lists.sourceforge.net/lists/listinfo/perp-developers |
|
|
Re: no report specifiedI did try that already in a moment of desperation. Even tried changing it to something else, saving, and changing it back, saving, no dice. Is there a way I turn on some sort of trace/debug to help pinpoint the problem? Dan |
|
|
Re: no report specifiedOn 11-Aug-09, at 2:15 PM, Dan Jankowski wrote: >> ... report file type preference set to?... > > I did try that already in a moment of desperation. Even tried > changing it > to something else, saving, and changing it back, saving, no dice. > Is there > a way I turn on some sort of trace/debug to help pinpoint the problem? You can try, but I suspect the problem is in a different area. First check the egw log (Admin -> View error log). I don't know if you checked that one; it gets forgotten. You can un-comment the _debug_array(...); die(); at the bottom of each report class. You won't get a file, but you can check that it's getting the right data. You can also try /perp_api/inc/class.perp_report.inc.php, line 318, set tbsdebug = 1. Again, you won't get a report, but you can see a little what's going on. Don't try them both at the same time, the first stops the second. Failing anything interesting there, the only thing I can think of is to step through perp_report->display() and see what goes awry. Nathan Gray nathan at goarctic dot com ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Perp-developers mailing list Perp-developers@... https://lists.sourceforge.net/lists/listinfo/perp-developers |
|
|
Re: no report specifiedAny ideas as to what area? I will do my best and report my findings...if any |
|
|
Re: no report specifiedI got a blank page - 0 for 1 No errors to report, and all data looks like it is there and correct. - 0 for 2 Again, No errors to report, and all data looks like it is there and correct. In fact, it looked almost identical to the previous troubleshooting step results, but with a few extra super headers - 0 for 3 Seems like the data is there and available, but it just refuses to output it in OO formats. Now I am lost. I can get you the outputs if you want them.... |
|
|
Re: no report specifiedOn 11-Aug-09, at 5:04 PM, Dan Jankowski wrote: > ...No errors to report, ... - 0 for 3 > > Seems like the data is there and available, but it just refuses to > output it > in OO formats. Now I am lost. I can get you the outputs if you want > them.... Can you check your temp directory, and see if the file is there? You can find the file name by adding this to class.perp_report.inc.php, line 392: echo $file; See if the file is there, and what's in it. This is most strange, as it works here, and I assume everywhere else, or I'd here about it. Nathan Gray nathan at goarctic dot com ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Perp-developers mailing list Perp-developers@... https://lists.sourceforge.net/lists/listinfo/perp-developers |
|
|
Re: no report specifiedAdded that code. The results are not so encouraging. The first line of the .ODT (which we know now is really a text file for me) was: /opt/egroupware/tmp/6fe97198ee0f46c7703b31e177320503.odt The file did not exist in that directory. I did see all my sessions there however, so we can at least eliminate directory permissions as being the problem. Furthermore, I tried an old custom report that i know doesn't (and never did) work right, and I got an empty file named 'no_report.odt' which means that at least some the code is working on my system. Everything was working fine untill i upgraded from PHP 5.1.6 to 5.2.10. Nothing else on the system changed other than that. Is there a php mod that changed between those 5.1 and 5.2 that I now need that I didn't before? Output of yum list installed '*php*' php.i386 5.2.10-1.el4.remi installed php-bcmath.i386 5.2.10-1.el4.remi installed php-cli.i386 5.2.10-1.el4.remi installed php-common.i386 5.2.10-1.el4.remi installed php-gd.i386 5.2.10-1.el4.remi installed php-imap.i386 5.2.10-1.el4.remi installed php-ldap.i386 5.2.10-1.el4.remi installed php-mbstring.i386 5.2.10-1.el4.remi installed php-mysql.i386 5.2.10-1.el4.remi installed php-pdo.i386 5.2.10-1.el4.remi installed php-pear.noarch 1:1.8.1-1.el4.remi installed php-pear-Auth-SASL.noarch 1.0.3-1.el4.remi installed php-pear-DB.noarch 1.7.13-2.el4.remi installed php-pear-HTTP.noarch 1.4.1-3.el4.remi installed php-pear-HTTP-Request.noarch 1.4.3-2.el4.remi installed php-pear-Mail.noarch 1.1.14-3.el4.remi installed php-pear-Net-SMTP.noarch 1.2.8-5.el4.centos installed php-pear-Net-Socket.noarch 1.0.9-2.el4.remi installed php-pear-Net-URL.noarch 1.0.15-2.el4.remi installed php-pear-XML-Beautifier.noarch 1.2.0-2.el4.remi installed php-pear-XML-Parser.noarch 1.3.2-2.el4.remi installed php-pear-XML-RSS.noarch 0.9.10-6.el4.remi installed php-pear-XML-Serializer.noarch 0.18.0-5.el4.remi installed php-pecl-zip.i386 1.8.10-2.el4.1 installed php-xml.i386 5.2.10-1.el4.remi installed php-xmlrpc.i386 5.2.10-1.el4.remi installed |
|
|
Re: no report specifiedOn 12-Aug-09, at 9:10 AM, Dan Jankowski wrote: > > > Nathan Gray wrote: >> >> Can you check your temp directory, and see if the file is there? >> You can find the file name by adding this to >> class.perp_report.inc.php, line 392: >> echo $file; >> >> See if the file is there, and what's in it. >> >> This is most strange, as it works here, and I assume everywhere else, >> or I'd here about it. >> > > Added that code. The results are not so encouraging. The first > line of the > .ODT (which we know now is really a text file for me) was: > > /opt/egroupware/tmp/6fe97198ee0f46c7703b31e177320503.odt > > The file did not exist in that directory. Try adding die(); after that and check again. Could be the file gets cleaned. There may also be a directory with the same name, without the extension. > Everything was working fine untill i upgraded from PHP 5.1.6 to > 5.2.10. > Nothing else on the system changed other than that. Is there a php > mod that > changed between those 5.1 and 5.2 that I now need that I didn't > before? Quite possibly. Under Admin -> pERP -> Site config, try the other method for 'Zip Method'. Let me know any differences. Nathan Gray nathan at goarctic dot com ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Perp-developers mailing list Perp-developers@... https://lists.sourceforge.net/lists/listinfo/perp-developers |
|
|
Re: no report specifiedAdded die(); and got the following /opt/egroupware/tmp/83c58fbc133f677e24d6288006f4562f.odtChecked for the file and it was there. opened it up, and it "SEEMED" blank. Then I remembered that you can open .ODT files with an archive manager. When I did, I found out that it was actually populated with data (content.xml had all my data in it), and images...so...... I changed the setting from php to shell, clicked save, then save again (to make sure the binaries were saved), logged out of egroupware and back in, ran an invoice report. /opt/egroupware/tmp/ec083d3fc8df0238ddb9d2b5399be28f.odtFile was there, and PERFECT. Went ahead and backed out the echo and die code and ran a report. Everything is fine. Now, I just need to configure the template to send the file with the invoice number as a suffix prior to extension. CONCLUSION: With PHP 5.2.10 (at least on my system), The shell setting for zip must be used to properly create OpenOffice documents. Thanks for your help. Dan. UPDATE: I still get the 'no report specified' from Midori. This is most likely a problem with Midori/Webkit rather than pERP, but wanted you to be aware. UPDATE2: Same results in webkit enabled Epiphany as in Midori....so it is a webkit issue. |
|
|
Re: no report specified.
Hi Dan / Nathan, With adding the invoice number to the file name, this is something I have thought about doing for a while, and actually thought I would like to have the customer name as well. Reading you post about it made me motivated enough to do something. So, I got me php guru to have a crack at it, and happy happy joy joy, he has succeeded. The file name I produce now, is in the form of "invoice-[invoice#]-[org_name].odt". I've uploaded the 2 files that were changed to achieve this. class.perp_report.inc.php tinyDoc.class.php Regards John
|
|
|
Re: no report specifiedDan Jankowski wrote:
> Now, I just need to configure the template to send the > file with the invoice number as a suffix prior to extension. On 12-Aug-09, at 8:01 PM, constant wrote: > ... > With adding the invoice number to the file name, this is something I > have > thought about doing for a while, and actually thought I would like > to have > the customer name as well. Reading you post about it made me > motivated > enough to do something. > > So, I got me php guru to have a crack at it, and happy happy joy > joy, he has > succeeded. > > The file name I produce now, is in the form of > "invoice-[invoice#]-[org_name].odt". > > I've uploaded the 2 files that were changed to achieve this. Bet you guys didn't know that this _used_ to happen, for almost every report. ;-) It got broken when we updated the report generating engine. :-( John, your fix only fixes things for invoices, not all the other reports. Your PHP guru did find the source of the problem, so I was able to finally fix this for all (SVN r 3842). Thank you / him for finding it, I'm so glad to have that working. I know it's a little thing, but I think it's one of those little things that really adds polish. The best place to change the filename for one report (invoice) is in the report class file. For AR invoices, this is in perp_ar/inc/report/ class.invoice_report.inc.php, line 83. Nathan Gray nathan at goarctic dot com ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Perp-developers mailing list Perp-developers@... https://lists.sourceforge.net/lists/listinfo/perp-developers |
|
|
Re: no report specified.
Hi Nathan, Glad to hear we've been some help. Don't know if my guy is actually a guru, but he works full time as a php programmer, and he's always been able to get done what I want. Plus he's a real nice guy, so I sing his praises whenever I can. If I update, will I have to change the file name format again? Don't mind, just looking for a heads up. Regards John
|
|
|
Re: no report specifiedOn 13-Aug-09, at 3:32 PM, constant wrote: > ... > If I update, will I have to change the file name format again? > Don't mind, > just looking for a heads up. If you're talking about updating to 3842, yes, but you'll have to change it in a different place (see previous post for directions). Subsequent updates should not require any changes, unless I change that particular line. In that case, SVN will let you know. Nathan Gray nathan at goarctic dot com ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Perp-developers mailing list Perp-developers@... https://lists.sourceforge.net/lists/listinfo/perp-developers |
|
|
Re: no report specified.
Is it related to this issue: http://www.nabble.com/Post-invoice-action-to21465189.html#a21465189 Regards John
|
|
|
Re: no report specifiedOn 13-Aug-09, at 4:08 PM, constant wrote: > > . > Is it related to this issue: > > http://www.nabble.com/Post-invoice-action-to21465189.html#a21465189 No, separate issue. Nathan Gray nathan at goarctic dot com ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Perp-developers mailing list Perp-developers@... https://lists.sourceforge.net/lists/listinfo/perp-developers |
| Free embeddable forum powered by Nabble | Forum Help |