No report specified

[Dan_Jankowski]

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. 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

[Nathan_Gray-2]

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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers

[Dan_Jankowski]

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?

UPDATE: Was snooping around and found ‘where’ the "no report specified’ comes from:
perp_api/inc/class.ui_perp_report.inc.php - line 148

[Nathan_Gray-2]

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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers

[Dan_Jankowski]

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’ (Attached)

general_ledger_listing.odt (150 KB)

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 (19 Bytes)

[Nathan_Gray-2]

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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers

[Dan_Jankowski]

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.

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?

Dan

[Nathan_Gray-2]

… 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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers

[Dan_Jankowski]

You can try, but I suspect the problem is in a different area.

Any ideas as to what 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.

I will do my best and report my findings…if any

[Dan_Jankowski]

First check the egw log (Admin -> View error log). I don’t know if
you checked that one; it gets forgotten.

I got a blank page - 0 for 1

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.

No errors to report, and all data looks like it is there and correct. - 0 for 2

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.

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…

[Nathan_Gray-2]

…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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers

[Dan_Jankowski]

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. 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

[Nathan_Gray-2]

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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers

[Dan_Jankowski]

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.

Added die(); and got the following

/opt/egroupware/tmp/83c58fbc133f677e24d6288006f4562f.odt

Checked 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…

Quite possibly. Under Admin -> pERP -> Site config, try the other
method for ‘Zip Method’.
Let me know any differences.

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.odt

File 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.

[constant]

.
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 (14.9 KB)
tinyDoc.class.php (34.6 KB)

Regards
John

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.

Added die(); and got the following

/opt/egroupware/tmp/83c58fbc133f677e24d6288006f4562f.odt

Checked 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…

Quite possibly. Under Admin -> pERP -> Site config, try the other
method for ‘Zip Method’.
Let me know any differences.

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.odt

File 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.

[Nathan_Gray-2]

Dan Jankowski wrote:

Now, I just need to configure the template to send the
file with the invoice number as a suffix prior to extension.

…
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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers

[constant]

.
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

Dan 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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers

[Nathan_Gray-2]

…
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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers

[constant]

.
Is it related to this issue:

http://www.nabble.com/Post-invoice-action-to21465189.html#a21465189

Regards
John

.
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

Dan 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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers

[Nathan_Gray-2]

.
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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers