Re: Users - Users - Webtools Import error when content containsAl

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

Re: Users - Users - Webtools Import error when content containsAl

oceatoon
Hi Al and Ray

I confirm that even the file import doesn't work for us on Sequoia 0.8 when well formated xml files are imported. we found that only hexa versions of accent caracters go through which would mean we'd have to transform our imported data.

could you guys tell if it works for you ?
with é or even é

Thanks for the help
Tibor




 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: Users - Users - Webtools Import error when content containsAl

Ray Barlow
Tibor,

I've tested against the latest SVN only, don't have Sequoia loaded or to
hand but I don't think there have been any major changes in this area to
the SVN version. Also as I said last time I had this working over a year
and a half ago so it really is more likely something about your set up
rather than a Sequoia bug.

The attached file imports fine for me using both methods i.e. import
from file or copy and paste into the text box and import from there.

When using the file import method it will fail if the character encoding
for the *FILE* is not correct. You must check this as it depends on how
you create the file as to what the encoding is. You can use jEdit as I
mentioned before or I just looked in Eclipse and found it at the bottom
of the "Edit" menu under "Set Encoding" on version 3.1.2, make sure the
encoding is UTF-8.

When reading Excel files and creating entity ready XML files from them I
do remember having to play with the file creation routine to make sure
it created the file with the correct encoding. Something like:
  outstream = new FileOutputStream(filename);
  out = new OutputStreamWriter(outstream, "UTF-8");
but this bit depends on how you create your XML file though so you'd
need to investigate that further.

Ray



tibor katelbach wrote:

> Hi Al and Ray
>
> I confirm that even the file import doesn't work for us on Sequoia 0.8
> when well formated xml files are imported. we found that only hexa
> versions of accent caracters go through which would mean we'd have to
> transform our imported data.
>
> could you guys tell if it works for you ?
> with é or even é
>
> Thanks for the help
> Tibor
>
>
>
>------------------------------------------------------------------------
>
>
>_______________________________________________
>Users mailing list
>[hidden email]
>http://lists.ofbiz.org/mailman/listinfo/users
>

<?xml version="1.0" encoding="UTF-8"?>
<entity-engine-xml>

<Product productId="1001007" productName="Whoozit Water Matéé"/>

</entity-engine-xml>

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: Users - Users - Webtools Import error when content containsAl

BJ Freeman
In reply to this post by oceatoon
Not sure if you language setting may have something to do with this.
just a thought.

tibor katelbach sent the following on 3/28/06 12:23 AM:

> Hi Al and Ray
>
> I confirm that even the file import doesn't work for us on Sequoia 0.8 when
> well formated xml files are imported. we found that only hexa versions of
> accent caracters go through which would mean we'd have to transform our
> imported data.
>
> could you guys tell if it works for you ?
> with é or even &eacute;
>
> Thanks for the help
> Tibor
>
>
>
> ------------------------------------------------------------------------
>
>  
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users
 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: Users - Users - Webtools Import error whencontent containsAl

Jacques Le Roux
Administrator
In a french settings Ray's file is read differently suiving reader used :
NotePad & IE6 & MS Visual Studio .Net give (the last one seems to use HTML also)
:

<?xml version="1.0" encoding="UTF-8"?>
<entity-engine-xml>

<Product productId="1001007" productName="Whoozit Water Matéé"/>

</entity-engine-xml>

But UltraEdit and WordPAD

<?xml version="1.0" encoding="UTF-8"?>
<entity-engine-xml>

<Product productId="1001007" productName="Whoozit Water Matéé"/>

</entity-engine-xml>

And UltraEdit in mode Hexa give

C3 et A9 for "é"

So be carefull, there is something special here, sorry have no time to
investigate more...

Jacques


----- Original Message -----
From: "BJ Freeman" <[hidden email]>
To: "OFBiz Users / Usage Discussion" <[hidden email]>
Sent: Tuesday, March 28, 2006 1:05 PM
Subject: Re: [OFBiz] Users - Users - Webtools Import error whencontent
containsAl


> Not sure if you language setting may have something to do with this.
> just a thought.
>
> tibor katelbach sent the following on 3/28/06 12:23 AM:
> > Hi Al and Ray
> >
> > I confirm that even the file import doesn't work for us on Sequoia 0.8 when
> > well formated xml files are imported. we found that only hexa versions of
> > accent caracters go through which would mean we'd have to transform our
> > imported data.
> >
> > could you guys tell if it works for you ?
> > with é or even &eacute;
> >
> > Thanks for the help
> > Tibor
> >
> >
> >
> > ------------------------------------------------------------------------
> >
> >
> > _______________________________________________
> > Users mailing list
> > [hidden email]
> > http://lists.ofbiz.org/mailman/listinfo/users
>
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: Users - Users - Webtools Import error whencontent containsAl

oceatoon
Thanks for your patients
it was in fact an editor utf-8 setting that we kept on trying , but wasn't working
as you perseveared  so did we, and it finally worked,  go figure why???
but I'll have to force import excel data to utf-8 for sure , I'll try your technique Ray and I'm open for anybodies
advice on this.

Anyway
Great thanks for the responses
Tibor

On 3/28/06, Jacques Le Roux <[hidden email]> wrote:
In a french settings Ray's file is read differently suiving reader used :
NotePad & IE6 & MS Visual Studio .Net give (the last one seems to use HTML also)
:

<?xml version="1.0" encoding="UTF-8"?>
<entity-engine-xml>

<Product productId="1001007" productName="Whoozit Water Matéé"/>

</entity-engine-xml>

But UltraEdit and WordPAD

<?xml version="1.0" encoding="UTF-8"?>
<entity-engine-xml>

<Product productId="1001007" productName="Whoozit Water Matéé"/>

</entity-engine-xml>

And UltraEdit in mode Hexa give

C3 et A9 for "é"

So be carefull, there is something special here, sorry have no time to
investigate more...

Jacques


----- Original Message -----
From: "BJ Freeman" <[hidden email]>
To: "OFBiz Users / Usage Discussion" <[hidden email]>
Sent: Tuesday, March 28, 2006 1:05 PM
Subject: Re: [OFBiz] Users - Users - Webtools Import error whencontent
containsAl


> Not sure if you language setting may have something to do with this.
> just a thought.
>
> tibor katelbach sent the following on 3/28/06 12:23 AM:
> > Hi Al and Ray
> >
> > I confirm that even the file import doesn't work for us on Sequoia 0.8 when
> > well formated xml files are imported. we found that only hexa versions of
> > accent caracters go through which would mean we'd have to transform our
> > imported data.
> >
> > could you guys tell if it works for you ?
> > with é or even &eacute;
> >
> > Thanks for the help
> > Tibor
> >
> >
> >
> > ------------------------------------------------------------------------
> >
> >
> > _______________________________________________
> > Users mailing list
> > [hidden email]
> > http://lists.ofbiz.org/mailman/listinfo/users
>
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users


_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users


 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users