LiveCode Forums.

Posted: **Thu Dec 05, 2013 9:31 am**

Hi,

I'm trying to import a xmlfile encoded in utf8 (checked by Notepad++) to a datagrid. Editing of the text can/will happen and then I want to save the datagrid back to a utf8 encoded xmlfile.

By using this line I got the characters to show up right in the datagrid:

Code: Select all

put uniDecode(uniEncode(tTitle, "UTF8")) into theDataA[i]["title"]

but I have never managed to get the output to be anything other than ANSI according to Notepad++, and if I try to open the saved file LC tells me "Input is not proper UTF-8, indicate encoding!". The code below is now stripped from all utf8 conversion since none of them worked. I have read the utf8 tutorial (/s/lessons/m/4067/l/20441-unicode) but I do not get it. So my question is, how do I get the datagrid to become utf8 and how do I get the data out to a utf8 encoded xml file?

Code: Select all

command uiExportData outputFile
   ## Export data to XML
   ## Get Data Grid Array
   put the dgData of group "mainGrid" into theDataA
   
   ## Get indexes in proper order
   put the dgIndexes of group "mainGrid" into theIndexes
   
   ## Prefix XML
   put "<?xml version='1.0' encoding='utf-8'?>" & cr into theXML
   put"<!DOCTYPE RUNDOWN>" & cr after theXML
   put"<RUNDOWN VERSION='1.0'>" & cr after theXML
   
   ## Loop through data, putting into XML format
   repeat for each item theIndex in theIndexes
      put tab & "<ENTRY>" & cr after theXML
      put tab & tab & "<ORDER>" & theDataA[theIndex]["order"] & "</ORDER>" & cr after theXML
      put tab & tab & "<TITLE>" & theDataA[theIndex]["title"] & "</TITLE>" & cr after theXML
      put tab & tab & "<CHANNEL>" & theDataA[theIndex]["ch"] & "</CHANNEL>" & cr after theXML
      put tab & tab & "<LAYER>" & theDataA[theIndex]["lay"] & "</LAYER>" & cr after theXML
      put tab & tab & "<TYPE>" & theDataA[theIndex]["type"] & "</TYPE>" & cr after theXML
      put tab & "</ENTRY>" & cr after theXML
   end repeat
   
   ## Close root XML tag
   put "</RUNDOWN>" after theXML
   put outputFile into tFileName
   
   ## Ensure the file extension is xml
   set the itemDel to "."
   if item 2 of tFileName is not "xml" then
      put "xml" into item 2 of tFileName
   end if
   put theXML into tFileContents
   put tFileContents into URL ("file:" & tFileName)
end uiExportData

Posted: **Fri Dec 06, 2013 3:19 am**

Hi Nicke,
Here is a start for when you save the file

Code: Select all

put unidecode(tFileContents,"utf8") into url ("binfile:"& tFileName)

But I have a feeling you may need more in here if it contains UTF8 text

Code: Select all

put tab & tab & "<ORDER>" & theDataA[theIndex]["order"] & "</ORDER>" & cr after theXML

Simon

Posted: **Fri Dec 06, 2013 7:21 pm**

Hi Simon,

I tried to save using the line you suggested:

Code: Select all

put unidecode(tFileContents,"utf8") into url ("binfile:"& tFileName)

But the outputted file is totally unreadable and according to Notepad++ still ANSI.

This is the content of tFileContents before the line above:

Code: Select all

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE RUNDOWN>
<RUNDOWN VERSION='1.0'>
	<ENTRY>
		<ORDER>1</ORDER>
		<TITLE>Detta är en 'konstig' "text"</TITLE>
		<CHANNEL>1</CHANNEL>
		<LAYER>1</LAYER>
		<TYPE>Media</TYPE>
	</ENTRY>
	<ENTRY>
		<ORDER>2</ORDER>
		<TITLE>"Funkar detta"</TITLE>
		<CHANNEL>1</CHANNEL>
		<LAYER>2</LAYER>
		<TYPE>CG</TYPE>
	</ENTRY>
</RUNDOWN>

and when I open the file in notepad++ it looks like this:

Code: Select all

ã¼¼æµ¸â¬æ•¶ç²æ½©ãµ®ã„§ã€®â€§æ¹¥æ½£æ¥¤æ®âœ½ç‘µâµ¦âœ¸ã¸¿ã°Šä¡äå¥”ä•åˆ ä¹•ä½„ä¹—à¨¾åˆ¼ä¹•ä½„ä¹—å˜ å‰…ä¥“ä¹âœ½â¸±âœ°à¨¾ã°‰ä¹…å‰”ã¹™à¤Šã°‰å‰ä•„ã¹’ã°±ä¼¯ä‘’å‰…à¨¾à¤‰å¼å‘‰ä•Œä¾ç‘¥æ…´î â²æ¹¥âœ æ½«ç®æ¥´â§âˆ æ•´ç‘¸ã°¢å¯å‘‰ä•Œà¨¾à¤‰äŒ¼ä…ˆä¹Žä±…ã„¾â¼¼ä¡ƒä¹ä•Žã¹Œà¤Šã°‰ä…Œä•™ã¹’ã°±ä°¯å¥å‰…à¨¾à¤‰å¼å™ã¹…æ•æ¥¤ã±¡å¯å™ã¹…à¤Šâ¼¼ä¹…å‰”ã¹™à¤Šä”¼å‘Žå¥’à¨¾à¤‰ä¼¼ä‘’å‰…ãˆ¾â¼¼å‰ä•„ã¹’à¤Šã°‰ä¥”ä±”ã¹…ä˜¢æ¹µæ…«â²æ•¤ç‘´â‰¡â¼¼ä¥”ä±”ã¹…à¤Šã°‰ä¡ƒä¹ä•Žã¹Œã°±äŒ¯ä…ˆä¹Žä±…à¨¾à¤‰ä°¼å¥å‰…ãˆ¾â¼¼ä…Œä•™ã¹’à¤Šã°‰å¥”ä•äŒ¾ã±‡å¯å™ã¹…à¤Šâ¼¼ä¹…å‰”ã¹™ã°Šåˆ¯ä¹•ä½„ä¹—

Any ideas?

Posted: **Fri Dec 06, 2013 7:43 pm**

Hi Nicke,
I got that info from here:
http://lessons.runrev.com/s/lessons/m/4 ... 41-unicode

Simon

LiveCode Forums.

Import utf8 XML to datagrid edit and save to utf8 xml

Import utf8 XML to datagrid edit and save to utf8 xml

Re: Import utf8 XML to datagrid edit and save to utf8 xml

Re: Import utf8 XML to datagrid edit and save to utf8 xml

Re: Import utf8 XML to datagrid edit and save to utf8 xml