Hi Justine, I usually get that error when the reader is getting confused with quotes. If you open a text editor, you can go to line 2 and column 409 of the file and see what is there. That's where the problem is.
If you paste the first few lines of data here I can help more. Regards, Steven Payne Inventory Control Coordinator -----Original Message----- From: Jacques Le Roux <[email protected]> Sent: October 24, 2021 9:53 PM To: [email protected] Subject: Re: Import Product Name "&" Hi Justine, This could be helpful: https://stackoverflow.com/questions/1091945/what-characters-do-i-need-to-escape-in-xml-documents#answer-1091953 HTH Jacques Le 24/10/2021 à 20:17, Justine Nowak a écrit : > Hi Steve, > > Just tried that and got the following error. > > The Following Errors Occurred: > > ERROR: parsing file: ERROR parsing Entity Xml file: > org.xml.sax.SAXException: A transaction error occurred reading > data<br/>org.xml.sax.SAXException: Fatal Error reading XML on line 2, > column 409<br/>org.xml.sax.SAXParseException; lineNumber: 2; columnNumber: > 409; Element type "Product" must be followed by either attribute > specifications, ">" or "/>". > > > Thanks, Justine > > On Sun, Oct 24, 2021 at 12:16 PM Steven Payne > <[email protected]> > wrote: > >> Hi Justine, >> >> You need to escape some of those characters. the "&" needs to be >> replaced with "&" >> >> Regards, >> Steve Payne >> >> On Sun, Oct 24, 2021 at 9:57 AM Justine Nowak <[email protected]> >> wrote: >> >>> Hello, >>> >>> I am trying to import our products into Ofbiz and some of our >>> products >> have >>> a "&" in the productName field. For example, "Gummy with Vitamins A & D". >>> >>> How do we get the system to allow this product to get created? >>> >>> The Following Errors Occurred: >>> >>> ERROR: parsing file: ERROR parsing Entity Xml file: >>> org.xml.sax.SAXException: A transaction error occurred reading >>> data<br/>org.xml.sax.SAXException: Fatal Error reading XML on line >>> 12, column 408<br/>org.xml.sax.SAXParseException; lineNumber: 12; >> columnNumber: >>> 408; The entity name must immediately follow the '&' in the entity >>> reference. >>> >>> >>> Thanks, Justine >>>
