čtvrtek 7. srpna 2014

UTF8 tags in EXIF

When copying UTF8 tags in EXIF (e.g. comments created in Picasa) between files, use explicit charset specification:

for i in *JPG 
 do
  exiftool -iptc:codedcharacterset=utf8 -charset UTF8 \
           -overwrite_original -tagsfromfile=../"$i" "$i" 
done

Some tags are re-encoded as Latin (windows) by default, even without -L option. The -iptc switch makes the trick.

středa 29. ledna 2014

Import utf8-encoded csv file into Excel2011 for mac

Excel is not able to import accented characters from utf-8 encoded text (csv) file.

1. Use TextWrangler to open the file
2. Save is as UTF16-Little Endian
3. In Excel: import as Macintosh encoded file.