Openbravo Issue Tracking System - Java Client POS
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0007926Java Client POS(No Category)public2009-03-04 06:552014-04-02 09:03
Reporterronny_g 
Assigned Toadrianromero 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS10OS VersionVista
Product Version 
Target Version2.30Fixed in Version 
Regression date
Regression introduced by commit
Regression level
Review Assigned To
OBNetwork customer
Support ticket
Regression introduced in release
Summary0007926: Customer Name field cannot contain '&' symbol.
DescriptionAdded a new customer called 'A & Z Holdings' and saved record. No problem, accepted it okay. Left shop. Wasn't until printing ticket the next day that we get and error and garbled text on ticket.

Error
Warning: Cannot print invoice
com.openbravo.pos.printer.TicketPrinterException:
Invalid XML file. Analisis error.

org.xml.sax.SAXParseException:
The entity name must immediately follow the '&' in the entity reference.
Steps To Reproduce
Proposed SolutionIf for some reason '&' symbol cannot be used in the Name field for a Customer, have script check the field when saving the Customer, not later when printing.

Many Thanks.
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-03-04 06:55ronny_gNew Issue
2009-03-04 06:55ronny_gAssigned To => adrianromero
2009-03-04 06:56ronny_gIssue Monitored: ronny_g
2009-03-04 19:07adrianromeroStatusnew => scheduled
2009-03-04 19:20adrianromeroTarget Version => 2.30
2009-03-19 00:16hgbotCheckin
2009-03-19 00:16hgbotNote Added: 0014790
2009-03-19 00:16hgbotStatusscheduled => resolved
2009-03-19 00:16hgbotResolutionopen => fixed
2009-03-19 00:18adrianromeroNote Added: 0014791
2009-03-19 01:33ronny_gNote Added: 0014795
2009-03-19 01:33ronny_gIssue End Monitor: ronny_g
2009-04-27 17:30ronny_gStatusresolved => new
2009-04-27 17:30ronny_gResolutionfixed => open
2009-04-27 17:30ronny_gNote Added: 0015810
2009-04-27 17:48tostinniNote Added: 0015813
2009-04-29 09:35adrianromeroStatusnew => acknowledged
2009-04-29 09:35adrianromeroStatusacknowledged => scheduled
2009-04-29 09:35adrianromerofix_in_branch => pi
2009-04-29 09:35adrianromeroTarget Version2.30 => 2.40
2009-04-29 09:35adrianromerofix_in_branchpi =>
2009-04-29 16:56tostinniNote Added: 0015931
2009-05-06 17:37adrianromeroTarget Version2.40 => 2.30
2009-05-06 17:47adrianromeroNote Added: 0016110
2009-05-06 17:47hgbotCheckin
2009-05-06 17:47hgbotNote Added: 0016111
2009-05-06 17:47hgbotStatusscheduled => resolved
2009-05-06 17:47hgbotResolutionopen => fixed
2011-06-03 11:01dalsasuaAssigned Toadrianromero => dalsasua
2011-06-03 12:21dalsasuaAssigned Todalsasua => adrianromero
2012-11-07 09:40priyamCategory01 - General => (No Category)
2014-04-02 09:03plujanNote Added: 0065976
2014-04-02 09:03plujanStatusresolved => closed

Notes
(0014790)
hgbot   
2009-03-19 00:16   
Repository: openbravopos
Revision: 531
Author: adrianromero
Date: 2009-03-19 00:16:48 +0100 (Thu, 19 Mar 2009)

Fixes issue 0007926: Customer Name field cannot contain '&' symbol.

---
U trunk/src-pos/com/openbravo/pos/customers/CustomerInfo.java
U trunk/src-pos/com/openbravo/pos/templates/Printer.CustomerPaid.xml
U trunk/src-pos/com/openbravo/pos/templates/Printer.Ticket.xml
U trunk/src-pos/com/openbravo/pos/templates/Printer.TicketPreview.xml
---

https://dev.openbravo.com/websvn/openbravopos/?rev=531&sc=1 [^]
(0014791)
adrianromero   
2009-03-19 00:18   
Default templates has been fixed but in custom receipt templates you have to replace ticket.getCustomer().getName() by ticket.getCustomer().printName()
(0014795)
ronny_g   
2009-03-19 01:33   
Excellent. Works well. Thanks.
(0015810)
ronny_g   
2009-04-27 17:30   
Issue has appeared again.

Getting error:
com.openbravo.pos.printer.TicketPrinterException:
Analysis error. Invalid XML file.

org.xml.sax.SAXParseException:
The entity name must immediately follow the '&' in the entity reference.

Reported here:
http://forge.openbravo.com/plugins/espforum/view.php?group_id=101&forumid=434922&topicid=6993978 [^]
(0015813)
tostinni   
2009-04-27 17:48   
I also have this problem in another screen.
Make a sale to this customer "A & Z ...", then go to the "edit sales" screen, find the sale and try to edit it, you can't. No error appears, the sale just couldn't be edited.

Thanks a lot.
(0015931)
tostinni   
2009-04-29 16:56   
Hi Adrian,
I see you updated the status of this issue to target it for the 2.40 release. I understand this won't meet 2.30 but do you have any clue to give us on how to correct this in order to try to develop a patch and submit it here ?
(0016110)
adrianromero   
2009-05-06 17:47   
To fix this in your database you have to modify the resources

Printer.Ticket
Printer.TicketPreview
Printer.CustomerPaid

and replace

${ticket.getCustomer().getName()}

by

${ticket.getCustomer().printName()}
(0016111)
hgbot   
2009-05-06 17:47   
Repository: openbravopos
Revision: 621
Author: adrianromero
Date: 2009-05-06 17:47:25 +0200 (Wed, 06 May 2009)

Fixes issue 0007926: Customer Name field cannot contain '&' symbol.

---
U trunk/locales/pos_messages.properties
U trunk/sampledb/derby/openbravopos-database/db.lck
U trunk/sampledb/derby/openbravopos-database/log/log.ctrl
U trunk/sampledb/derby/openbravopos-database/log/log5.dat
U trunk/sampledb/derby/openbravopos-database/log/logmirror.ctrl
U trunk/sampledb/derby/openbravopos-database/seg0/c4a0.dat
U trunk/sampledb/derby/openbravopos-database/seg0/cc80.dat
U trunk/sampledb/derby/openbravopos-database/seg0/cc91.dat
---

https://dev.openbravo.com/websvn/openbravopos/?rev=621&sc=1 [^]
(0065976)
plujan   
2014-04-02 09:03   
Closed as it was in Resolved for too long