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 |
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 |
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 é > > 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 |
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 é > > > > 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 |
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 : _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
Free forum by Nabble | Edit this page |