[Gvsig_english] gvSIG and external tables, font-encoding etc.

[Wolfgang Qual]

Good morning everyone.
I will continue to report about my little (serious!) problems regarding german umlauts and modifiying attribute tables in gvSIG.
My table contains values like '2344_TÄ' and I would like to replace that '_TÄ' with 'tae'. 
The strange thing is that it is _possible_ to select these values using the filter function with the expression [column_name] like '%_TÄ'; all those values are selected - wonderful.
However, when trying to replace the questioned values using the field calculator, gvSIG fails: nothing is replaced. It is only possible to replace the umlauts manually. I do not understand this (reaction of gvSIG).
Therefore, I would be most grateful for some comments or _any_ ideas on how to solve this. BTW, do you have the same problem with the spanish 'ñ'?

Best regards,
Wolfgang

----8<------

-------- Original-Nachricht --------
> Datum: Thu, 2 Apr 2009 13:50:47 +0200
> Von: Wolfgang Qual <wolfgang.qual at gmx.net>
> An: Users list <gvsig_internacional at runas.cap.gva.es>
> Betreff: [Gvsig_english] gvSIG and external tables, font-encoding etc.

> Hi list,
> I have some remarks/questions on external tables and font-encoding
> regarding 
> gvSIG 1.1.2 and the coming versions of gvSIG.
> 
> * currently, it is not possible to edit external tables that were imported
> from csv. It seems, as if only dbf-files can be edited in gvSIG. You might
> say: well, do this conversion within openoffice. Right. But on my
> computer, I 
> only have openoffice 2.3 installed (the official computer of my office) -
> and 
> this version of calc is not able to write me a dbf-file. It simply
> crashes. 
> This strange behaviour is reported as a bug in calc. I can also convert
> this 
> file in excel (currently, excel is still available..), but there, I do not
> have any possibility to modify/set the font encoding. 
> * Font-encoding: I do not know, which font-encoding gvSIG accepts. I
> imported 
> a dbf-file that was created in Excel. This table has some values (text)
> which 
> needs to be processed. To be more precise: I need to convert substrings 
> like 'ae' into Ä (german umlaut). I found the function (replace) in the
> field 
> calculator of gvSIG. But this will not create an 'Ä' but only a
> square-shaped 
> character - I think that the font-encoding is the reason for this.
> 
> Therefore, I would be really happy, if you could answer me the following 
> questions:
> 
> * how do you work with csv-files in gvSIG: is it really true that only dbf
> can 
> be edited? Which software are you using to save files as dbf? 
> * which font-encoding is used within gvSIG? Or: which encoding do you use
> when 
> exporting a file from openoffice into a different format?
> * will there be a possiblity to edit tables derived from csv/txt in gvSIG?
> 
> Best regards,
> Wolfgang
> 
> _______________________________________________
> Gvsig_internacional mailing list
> Gvsig_internacional at runas.cap.gva.es
> http://runas.cap.gva.es/mailman/listinfo/gvsig_internacional

-- 
Psssst! Schon vom neuen GMX MultiMessenger gehört? Der kann`s mit allen: http://www.gmx.net/de/go/multimessenger01