GNOME.org
 

Re: [Tracker] Problem with Mime type of PPSX file

Hello,

Updated the 'shared-mime-info' package to 0.71 version, now the actual mime type is returned by 
'g_file_info_get_content_type()' and also in the properties of the document the actual mime type is shown.

Thanks,
Murugappan N.

-----Original Message-----
From: tracker-list-bounces gnome org [mailto:tracker-list-bounces gnome org] On Behalf Of ext 
tracker-list-request gnome org
Sent: Thursday, August 26, 2010 4:10 PM
To: tracker-list gnome org
Subject: tracker-list Digest, Vol 54, Issue 18

Send tracker-list mailing list submissions to
        tracker-list gnome org

To subscribe or unsubscribe via the World Wide Web, visit
        http://mail.gnome.org/mailman/listinfo/tracker-list
or, via email, send a message with subject or body 'help' to
        tracker-list-request gnome org

You can reach the person managing the list at
        tracker-list-owner gnome org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of tracker-list digest..."


Today's Topics:

   1. Re:  some files not indexed (Martyn Russell)
   2. Re:  sparql: Could not run update,        constraint failed
      (database corruption?) (Mildred Ki'Lya)
   3. Re:  search by words in file names (Tshepang Lekhonkhobe)
   4. Re:  search by words in file names (Aleksander Morgado)
   5.  Problem with Mime type of PPSX file
      (murugappan nataraj nokia com)


----------------------------------------------------------------------

Message: 1
Date: Wed, 25 Aug 2010 14:20:42 +0100
From: Martyn Russell <martyn lanedo com>
To: Mildred Ki'Lya <ml mildred593 gmail com>
Cc: tracker-list gnome org
Subject: Re: [Tracker] some files not indexed
Message-ID: <4C7518AA 6040007 lanedo com>
Content-Type: text/plain; charset=UTF-8; format=flowed

On 25/08/10 09:44, Mildred Ki'Lya wrote:

On 2010-08-25 10:13, Mildred Ki'Lya wrote:

Yesterday, I restarted Tracker, it replayed the journal and the
filesystem miner took a long time to index everything again (it seems).
I don't understand why it missed some files. I don't have anything in
the tracker-extract or tracker-miner-fs log and raised the kernel limit
for inotify.



Errata: there are log messages.
Strangely enough, the tail -f on the log file didn't display the
messages when they happened. Now that I just cat the log file, I can see
them. A lot of error are about wrong sparql syntax and errors in queries.

I have to test the queries my extractor generates, is there a way to
execute long sparql queries easily? tracker-sparql takes the query from
the command line, but I'm not sure my shell will accept, can it take
commands from the standard input ?


Yes, tracker-sparql -f <file-with-sparql-in-it>
See tracker-sparql --help or man tracker-sparql for more details.

-- 
Regards,
Martyn


------------------------------

Message: 2
Date: Wed, 25 Aug 2010 16:04:43 +0200
From: Mildred Ki'Lya <ml mildred593 gmail com>
To: tracker-list gnome org
Subject: Re: [Tracker] sparql: Could not run update,    constraint failed
        (database corruption?)
Message-ID: <4C7522FB 7070604 gmail com>
Content-Type: text/plain; charset="utf-8"

I could fix the database apparently:

$ sqlite3 ~/.cache/tracker/meta.db
SQLite version 3.6.22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> DELETE FROM "nco:EmailAddress"
   ...> WHERE "nco:emailAddress" = "bob company tld";
sqlite> .q


And now it works.

My theory about the problem is that the nco:EmailAddress existed but
wasn't referenced anywhere. It should have been garbage collected. And
thus, when I want to assign this email address to an existing
nco:Contact, tracker tried to create a new nco:EmailAddress even though
it already existed.

In the SQLite database, the nco:EmailAddress table is as follows:

    CREATE TABLE "nco:EmailAddress" (
      ID INTEGER NOT NULL PRIMARY KEY,
      "nco:emailAddress" TEXT UNIQUE,
      "nco:emailAddress:graph" INTEGER);

The nco:emailAddress is set to UNIQUE. SQLite complained and Tracker
failed to complete the transaction.


It seems my database is full of these quirks, is there a way to run a
garbage collector on it?

It seems it's just a matter of running the following request on each of
the ontology tables:

    DELETE FROM "nco:EmailAddress"
    WHERE ID NOT IN (SELECT ID FROM Resource);


Can someone confirm this ?
Anyway, it worked for my email addresses.


Mildred

-- 
Mildred Ki'Lya
?????????? ???????????????????? ??????????
? Jabber, GoogleTalk: <mildred jabber fr>
? Website: <http://ki.lya.online.fr>           GPG ID: 9A7D 2E2B
? Fingerprint: 197C A7E6 645B 4299 6D37 684B 6F9D A8D6 9A7D 2E2B
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 0x9A7D2E2B.asc
Type: application/pgp-keys
Size: 10035 bytes
Desc: not available
URL: <http://mail.gnome.org/archives/tracker-list/attachments/20100825/bb8d0fa4/attachment.bin>

------------------------------

Message: 3
Date: Wed, 25 Aug 2010 17:07:58 +0200
From: Tshepang Lekhonkhobe <tshepang gmail com>
To: Thibaud Hulin <hulin thibaud gmail com>
Cc: tracker-list gnome org
Subject: Re: [Tracker] search by words in file names
Message-ID:
        <AANLkTi=D=qpp1F9GL7Avvr9bvydCD-ONSHVfK-RDN3Ja mail gmail com>
Content-Type: text/plain; charset=UTF-8

On Wed, Aug 25, 2010 at 12:54, Thibaud Hulin <hulin thibaud gmail com> wrote:

Hi,
Thanks for this excellent work with tracker.
I'm testing the 0.8.15 version with ubuntu lucid with tracker-search, but I
can't find documents like I want. For example, I'm looking for
"hamster-applet.txt".
When I type "hamster", I found my file.
When I type "applet", I don't found my file.
My bloc-notes is organized with files.txt, so it's important for me to
access to them by name files.
I have too tags in my notes, just a line with "{{tag>gnome applet }}", but
it would be probably more complicate to access them with this way that with
name files.
Best regards,
Thibaud.


It's a missing feature and I don't know what it will take for Tracker
devs to realise it's important enough to add. The difficulty has to do
with some limitations of FTS, which someone else suggested a
workaround for using regexps (but I can't find a link to that).


-- 
blog: http://tshepang.tumblr.com


------------------------------

Message: 4
Date: Wed, 25 Aug 2010 17:20:03 +0200
From: Aleksander Morgado <aleksander lanedo com>
To: Tshepang Lekhonkhobe <tshepang gmail com>
Cc: tracker-list gnome org
Subject: Re: [Tracker] search by words in file names
Message-ID: <1282749603 1921 1 camel currupipi-ubuntu>
Content-Type: text/plain; charset="UTF-8"



Thanks for this excellent work with tracker.
I'm testing the 0.8.15 version with ubuntu lucid with tracker-search, but I
can't find documents like I want. For example, I'm looking for
"hamster-applet.txt".
When I type "hamster", I found my file.
When I type "applet", I don't found my file.
My bloc-notes is organized with files.txt, so it's important for me to
access to them by name files.
I have too tags in my notes, just a line with "{{tag>gnome applet }}", but
it would be probably more complicate to access them with this way that with
name files.
Best regards,
Thibaud.


It's a missing feature and I don't know what it will take for Tracker
devs to realise it's important enough to add. The difficulty has to do
with some limitations of FTS, which someone else suggested a
workaround for using regexps (but I can't find a link to that).




We actually already realized that it's quite important to have
non-prefix FTS searches, but the implementation is far from trivial, so
probably not happening soon... :-/

-- 
Aleksander



------------------------------

Message: 5
Date: Thu, 26 Aug 2010 12:38:31 +0200
From: <murugappan nataraj nokia com>
To: <tracker-list gnome org>
Subject: [Tracker] Problem with Mime type of PPSX file
Message-ID:
        <B4D9C3E13918644D8A7F22D8F47154B12D5DAA9D76 NOK-EUMSG-03 mgdnok nokia com>
        
Content-Type: text/plain; charset="us-ascii"

Hello,

I'm working on implementing the tracker plug-in for 'PPSX' file.  I'm facing the following problem can anyone 
please provide some suggestion:

The actual MIME type for PPSX file is 
"application/vnd.openxmlformats-officedocument.presentationml.slideshow".

*       In Tracker the mime type for PPSX file is returned as "application/zip" by 
'g_file_info_get_content_type()' API instead of the actual mime type
*       Even in the Properties of the document, the mime type is shown as "application/zip" (right click on 
the file and selecting the 'Properties' to see the mime type)

Attaching a sample PPSX file.

Thank you Aleksander for providing the mailing list id.

Thanks,
Murugappan N.



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.gnome.org/archives/tracker-list/attachments/20100826/20fe8f93/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Presentation1.ppsx
Type: application/vnd.openxmlformats-officedocument.presentationml.slideshow
Size: 133597 bytes
Desc: Presentation1.ppsx
URL: <http://mail.gnome.org/archives/tracker-list/attachments/20100826/20fe8f93/attachment.bin>

------------------------------

_______________________________________________
tracker-list mailing list
tracker-list gnome org
http://mail.gnome.org/mailman/listinfo/tracker-list


End of tracker-list Digest, Vol 54, Issue 18
********************************************
[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]