DR800 Icons for desktop files

[Iñigo]

Hi there,

EDIT: Look message #4

[message specially targeted to Matthijs or Gertjan ;-]

DR800 does not accept an icon entry in .desktop files to specify the image for the applications. F.e. Osmo.desktop:

[Desktop Entry]
Name=Osmo
Comment=Personal organizer
Exec=/media/mmcblk0p1/Programs/_osmo/bin/osmo
Icon=/media/mmcblk0p1/Programs/_osmo/share/pixmaps/osmo.png
Type=Application
Encoding=UTF-8

I've tried to manually add the image data to the global.db thumbnails table, but although the images are properly inserted, CTB doesn't show them.

Please, look at the sample lua script attached to this message.
It parses .desktop files on SD/Programs, and store the specified icon image as .png data into the proper DB rows for every .desktop file with a valid icon entry.

Does DR800 use a predefined default icon for .desktop files or am I doing something wrong?

If this is the case, could iRex people extend .desktop files to understand "Icon", please?

Thanks in advance,
Iñigo

[Mackx]

Hi Iñigo,

I experimented with SQLite2009Pro (Freeware version) and added two png files to the shortcut. On my DR1000 (with first R2 beta) it shows the correct thumbnail in the SD Card view. (Although its name is still Osmo.desktop and not the name specified in the desktop file.)
I opened the global.db file and searched for the Osmo.desktop file in file_metadata-table. I used its file_id and added a new row in the thumbnails-table with the same file_id. I created two thumbnails of size 60x60 and 120x120 with gimp and added them to the new row as well.
So the mechanism seems to work, I suspect the lua script still does something wrong (or maybe something changed in the 2nd beta that breaks the mechanism).

[Iñigo]

Hi,

yes, it was a problem with the lua code.

The problem here is how to escape the images data before inserting into the BLOB field.
Similar code in python works ok, as you can use sqlite3.Binary(img_data).

In fact, there is a bug in ldbi, the sqlite3 bindings for lua I'm using, conn:escape don't escape the binary data properly.

So I'm now waiting here...
The idea is to make this lua script work in order to be able to do it from inside the DR.

Stay tunned ;-)

EDIT: btw, it works even with images of any size, but obviously we should use proper sizes, 60x60 for small and 120x120 for medium

EDIT2: I've included the sample python script.
Mount your DR device in your Linux computer and run as:
# python icons.py <path_to_your_DR_mount_point>
f.e.
# python icons.py /media/DR800
Eject device and that's all.

EDIT3: added a screenshot

[Iñigo]

Working icons.lua script and some nice screenshots attached.

Note that currently released lua package, v1, contains a bug in ldbi.sqlite so this script won't work by now. I'll post a new lua package once I finish some helper tools.