eGW, UTF-8 and pERP: problem with UTF-8

[PCSLists]

Michele, Nathan and all,

below are the report_purchase_order generated with var_dump($encodeData) and normally (without var_dump).

purchaseorder2.pdf (569 KB)
purchaseorder3.pdf (54.8 KB)

You can observe that the special chars are showed, but the report is wrong.
My public function $encodeData is the same as yours, including the changes.

Regards.

I’m sorry, I didn’t even know of the second one. I was talking about the first one and my patch should work for your special characters too.

Regards

[MicheleT-2]

PCS-Lists,

below are the report_purchase_order generated with var_dump($encodeData) and normally (without var_dump).

purchaseorder_vardump.pdf
purchaseorder.pdf

You can observe that the special chars are showed, but the report is wrong.
My public function $encodeData is the same as yours, including the changes.

As I said you before, printing special chars is a very distinct problem from that of your report looking wrong. We fixed the first one with that “dirty” (someday someone will develope a better one, but for now it works for our needs) patch applied to the encodeData() function.

Now we have to analyze the “strange” aspect of your report:

1. At the left top corner of your report there should be your company (or pERP default) logo. Did you remove it or what? Check it in Admin -> pERP -> Site Configuration.

2. That [company_address.n_fileas] on the top of your report is the place where should appear the name of your company, but it’s empty. Did you create the link between pERP and the EGW Addressbook contact that represents your company? Check it in Admin -> pERP -> Site Configuration.

3. That [order.their_contact.tel_work;noerr] in the summary box should be filled with the work phone of the pERP supplier chosen for your PO. Did you choose a pERP supplier for the PO? If so, is this pERP supplier linked to a corresponding EGW Addressbook contact? If so, do this EGW Addressbook contact have a work phone?

4. That [order.our_contact.tel_work] in the summary box should be filled with the work phone of the EGW account that you chose for the PO. This phone number should be preceded by the name of that account. Did you choose an EGW account for the PO? If so, check his work phone in EGW Addressbook.

5. That group of [16_ …] should be filled with data coming from rows of your PO, but the summary box says that the PO’s total is 0,00 so my question is: did you add some lines to your PO (at least one)?

Regards

[PCSLists]

1. At the left top corner of your report there should be your company (or pERP default) logo. Did you remove it or what? >Check it in Admin -> pERP -> Site Configuration.

Yes, I set url from my company logo, but is not appearing.

2. That [company_address.n_fileas] on the top of your report is the place where should appear the name of your >company, but it’s empty. Did you create the link between pERP and the EGW Addressbook contact that represents >your company? Check it in Admin -> pERP -> Site Configuration.

Sorry, it was my wrong. Now set correctly and working!

3. That [order.their_contact.tel_work;noerr] in the summary box should be filled with the work phone of the pERP >supplier chosen for your PO. Did you choose a pERP supplier for the PO? If so, is this pERP supplier linked to a >corresponding EGW Addressbook contact? If so, do this EGW Addressbook contact have a work phone?

Yes for all. I have supplier set and it has addressbook contact with work phone, but it’s not appearing.

4. That [order.our_contact.tel_work] in the summary box should be filled with the work phone of the EGW account that you chose for the PO. This phone number should be preceded by the name of that account. Did you choose an EGW account for the PO? If so, check his work phone in EGW Addressbook.

Sorry, I think did not understand. EGW account

5. That group of [16_ …] should be filled with data coming from rows of your PO, but the summary box says that the PO’s total is 0,00 so my question is: did you add some lines to your PO (at least one)?

Yes, my PO has one line. Below is the screenshot of PO. I hid the private informations.
purchaseorder_image.png (40.7 KB)

Regards

[ngegw]

I’m only getting one half of this discussion. Are you all on the
sourceforge mailing list? (nabble.com gets it wrong)

Easiest way to debug the data on your report is to look in the
appropriate php file
(/perp_ap/inc/report/class.purchase_order.inc.php) and put in the
commented out line “_debug_array($data); die()”. This will tell you
all the data that has been gathered for the report, and you can easily
figure out fields that are missing. You will not get a report until
this line is commented out again.

Your screenshot indicates that there is no contact within your
organisation for this purchase order. That should default to whomever
created the PO, and there is no option to leave it blank. I’m curious
about how this happened.

---

Return on Information:
Google Enterprise Search pays you back
Get the facts.
http://p.sf.net/sfu/google-dev2dev

---

Perp-developers mailing list
Perp-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers

[MicheleT-2]

1. At the left top corner of your report there should be your company (or pERP default) logo. Did you remove it or what? >Check it in Admin -> pERP -> Site Configuration.

Yes, I set url from my company logo, but is not appearing.

Check if it is an absolute path (i.e. /var/www/egroupware/phpgwapi/templates/default/images/yourlogo.png) and if you can see it on other pERP reports. If so check your template (perp_orders/inc/report/en/sales_order.odt) against last SVN (it should be 4044 for that one). Of course, if you have a personal (perp_orders/inc/report/default/sales_order.odt) or translated (perp_orders/inc/report/pt/sales_order.odt) version of the template, compare it with the english one.

3. That [order.their_contact.tel_work;noerr] in the summary box should be filled with the work phone of the pERP >supplier chosen for your PO. Did you choose a pERP supplier for the PO? If so, is this pERP supplier linked to a >corresponding EGW Addressbook contact? If so, do this EGW Addressbook contact have a work phone?

Yes for all. I have supplier set and it has addressbook contact with work phone, but it’s not appearing.

It appears on the screenshot of your PO so it’s not your fault. After the check suggested at point 1) compare perp_orders/inc/report/class.sales_order.inc.php with SVN (it should be 4036).

4. That [order.our_contact.tel_work] in the summary box should be filled with the work phone of the EGW account that you chose for the PO. This phone number should be preceded by the name of that account. Did you choose an EGW account for the PO? If so, check his work phone in EGW Addressbook.

Sorry, I think did not understand. EGW account

I mean EGW users accounts that you should have created in Admin -> Admin -> Users. At least one user should be assigned to one or more of the EGW users groups (Admin -> Admin -> Users groups) pERP needs (pERP groups and users).
Looking at the screenshot of your PO I can see that there is no user account after “Created By” and “Our Contact” labels. Did you remove them from the screenshot or what?

5. That group of [16_ …] should be filled with data coming from rows of your PO, but the summary box says that the PO’s total is 0,00 so my question is: did you add some lines to your PO (at least one)?

Yes, my PO has one line.

It seems all ok here. “Our code” and “Unit of measure” are empty but maybe they aren’t required. We need results from checks suggested at point 1) and 3).

Regards

[MicheleT-2]

I’m sorry, in my previous message I wrote about sales order instead of purchase order, so please change:

perp_orders/inc/report/en/sales_order.odt SVN(4044)
with
perp_ap/inc/report/en/purchase_order.odt SVN(4023)

perp_orders/inc/report/default/sales_order.odt
with
perp_ap/inc/report/default/purchase_order.odt

perp_orders/inc/report/pt/sales_order.odt
with
perp_ap/inc/report/pt/purchase_order.odt

perp_orders/inc/report/class.sales_order.inc.php SVN(4036)
with
perp_ap/inc/report/class.purchase_order.inc.php SVN(4023)

Regards

[MicheleT-2]

Hi Nathan,

I’m only getting one half of this discussion. Are you all on the
sourceforge mailing list? (nabble.com gets it wrong)

It’s me, I’ll subscribe asap.
Nathan, please check on nabble if you lost my other messages too.

Regards

[PCSLists]

Hi Nathan and Michele,

below is the _debug_array($data); die(); output for report_purchase_order, like Nathan suggested. You will observe that there are informations about “our tel work”, “supplier tel work” and about PO lines and totals. The informations are received by the arrays, but the report generated (pdf linked in a anterior post) not contains this same informations.

mozilla.pdf (61.9 KB)

What can we do? Help me please!!!

[ngegw]

Hi Nathan and Michele,

below is the _debug_array($data); die(); output for report_purchase_order,
like Nathan suggested. You will observe that there are informations about
"our tel work", “supplier tel work” and about PO lines and totals. The
informations are received by the arrays, …
[our_contact] =>
[their_contact] => Array
…
What can we do? Help me please!!!

I notice that the total and sub-total for this PO are to be displayed
as 0,00, but there is one line for 1006,76. Something strange there,
but probably not causing this issue. Might be an issue with how the
total and taxes are calculated.

You can see from your output that ‘our_contact’ is in fact empty.
Your debug shows that you have a shipping and billing address, but
’our_contact’ is blank.

I also noticed in your pdf that it changes font for some of the values
(see pay address). That’s weird, as the output should be simple text
with no font information.

Do all your orders lack the ‘Our Contact’? Can non-admins edit purchase orders?
At this point, I recommend manually editing your database (perp_order
table) and putting your contact ID (not account ID) into the
our_contact field of that record. Maybe that will help.

Nathan

---

This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon’s best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev

---

Perp-developers mailing list
Perp-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers

[PCSLists]

[quote=“Nathan Gray-7”]

I notice that the total and sub-total for this PO are to be displayed
as 0,00, but there is one line for 1006,76. Something strange there,
but probably not causing this issue. Might be an issue with how the
total and taxes are calculated.

Ok, and what can we do about it? I have no taxes to calculate.

You can see from your output that ‘our_contact’ is in fact empty.
Your debug shows that you have a shipping and billing address, but
’our_contact’ is blank.

It’s an old related problem (http://old.nabble.com/report_purchase_order-is-not-generating-td23370666i20.html#a24001686) and ‘our contact’ is set with a contact that I can’t change. Everytime I replace it by another in the list and save it returns to the anterior.

I also noticed in your pdf that it changes font for some of the values
(see pay address). That’s weird, as the output should be simple text
with no font information.

I changed some informations on pdf report only for hide particular customer issues.

Do all your orders lack the ‘Our Contact’? Can non-admins edit purchase orders?
At this point, I recommend manually editing your database (perp_order
table) and putting your contact ID (not account ID) into the
our_contact field of that record. Maybe that will help.

I added our contact ID on perp_purchase_order but the output is still the same. I think it’s related to the problem with ‘our contact’.

[ngegw]

…

Do all your orders lack the ‘Our Contact’?
Can non-admins edit purchase orders?
At this point, I recommend manually editing your database (perp_order
table) and putting your contact ID (not account ID) into the
our_contact field of that record. Maybe that will help.

I added our contact ID on perp_purchase_order but the output is still the
same. I think it’s related to the problem with ‘our contact’.

perp_purchase_order != perp_order

UPDATE perp_order SET our_contact_person = 1400 WHERE order_id = 16;

---

This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon’s best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev

---

Perp-developers mailing list
Perp-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers

[MicheleT-2]

It’s an old related problem (http://old.nabble.com/report_purchase_order-is-not-generating-td23370666i20.html#a24001686) and ‘our contact’ is set with a contact that I can’t change. Everytime I replace it by another in the list and save it returns to the anterior.

Sorry… just in case… do you press “Save” button (more times) until the “Purchase order saved” message appears on the top of the form?

Regards

[PCSLists]

perp_purchase_order != perp_order

UPDATE perp_order SET our_contact_person = 1400 WHERE order_id = 16;

Nathan,

the discussion is about problems on report_purchase_order. It’s a report of perp_ap, not of perp_orders. Michelle made a mistake, but corrected it up.

Regards

[PCSLists]

Nathan, Michele and all,

We was going on, but I not advanced from here and the problem persists.
The command above, wrote by Nathan…how can I use similar for perp_ap?
How can we continue from this.

Thanks and regards.

perp_purchase_order != perp_order

UPDATE perp_order SET our_contact_person = 1400 WHERE order_id = 16;

Nathan,

the discussion is about problems on report_purchase_order. It’s a report of perp_ap, not of perp_orders. Michelle made a mistake, but corrected it up.

Regards