You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Justine Nowak <co...@gmail.com> on 2021/10/24 16:56:35 UTC
Import Product Name "&"
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
RE: Import Product Name "&"
Posted by Steven Payne <st...@acsinc.ca>.
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 <ja...@les7arts.com>
Sent: October 24, 2021 9:53 PM
To: user@ofbiz.apache.org
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
> <st...@gmail.com>
> 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 <co...@gmail.com>
>> 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
>>>
Re: Import Product Name "&"
Posted by Jacques Le Roux <ja...@les7arts.com>.
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 <st...@gmail.com>
> 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 <co...@gmail.com>
>> 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
>>>
Re: Import Product Name "&"
Posted by Justine Nowak <co...@gmail.com>.
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 <st...@gmail.com>
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 <co...@gmail.com>
> 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
> >
>
Re: Import Product Name "&"
Posted by Steven Payne <st...@gmail.com>.
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 <co...@gmail.com> 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
>