Re: [Triplify-discussion] Triplify-discussion Digest, Vol 11, Issue 1

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

Dear triplify group,
 i notice a typo error in the code of today's first topic"

  1. help on triplify configuration error
...> look at the word 'distance' in this line, clearly it is spelt wrongly:
"Eg.distance AS 'disnace^^xsd:decimal',

just pointing it out in case
this spelling error may be significant in the problem cited by the author
Thushari Silva;

best regards to all
from Tim Gregory

On Sat, Nov 21, 2009 at 2:28 AM, <
tri...@li...> wrote:

> Send Triplify-discussion mailing list submissions to
>        tri...@li...
>
> To subscribe or unsubscribe via the World Wide Web, visit
>        https://lists.sourceforge.net/lists/listinfo/triplify-discussion
> or, via email, send a message with subject or body 'help' to
>        tri...@li...
>
> You can reach the person managing the list at
>        tri...@li...
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Triplify-discussion digest..."
>
>
> Today's Topics:
>
>   1. help on triplify configuration error (Thushari Silva)
>   2. Triplify 0.7 released (Sebastian Dietzold)
>   3. Update registry (Hendrik)
>   4. Re: Character encoding problems (postgreSQL) (Thomas Schandl)
>   5. Rewriting/redirection doesn't work (Davide Ceolin)
>   6. Re: Rewriting/redirection doesn't work (Eric Feliksik)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Fri, 23 Oct 2009 23:49:29 +0700
> From: Thushari Silva <atp...@gm...>
> Subject: [Triplify-discussion] help on triplify configuration error
> To: tri...@li...
> Message-ID:
>        <8a0...@ma...>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Dear Triplify Gurus,
>
> I am configuring triply for a web application which deals with publishing
> earthquake data as linked open data. The web application is currently
> running at localhost.
>
> this is the configuration 'config.inc' php file
>
>
> <?php
>
> $triplify['db']=mysql_connect('localhost','root','');
> mysql_select_db('sahana', $triplify['db']);
>
>
> $triplify['namespaces']=array(
>    'vocabulary'=>'http://localhost/vocabulary/',
>     'rdf'=>'http://www.w3.org/1999/02/22-rdf-syntax-ns#',
>    'rdfs'=>'http://www.w3.org/2000/01/rdf-schema#',
>    'owl'=>'http://www.w3.org/2002/07/owl#',
>    'foaf'=>'http://xmlns.com/foaf/0.1/',
>    'sioc'=>'http://rdfs.org/sioc/ns#',
>    'sioctypes'=>'http://rdfs.org/sioc/types#',
>    'dc'=>'http://purl.org/dc/elements/1.1/',
>    'dcterms'=>'http://purl.org/dc/terms/',
>    'skos'=>'http://www.w3.org/2004/02/skos/core#',
>    'tag'=>'http://www.holygoat.co.uk/owl/redwood/0.1/tags/',
>    'xsd'=>'http://www.w3.org/2001/XMLSchema#',
>    'update'=>'http://triplify.org/vocabulary/update#',
> );
>
>  $triplify['queries']=array(
>    'earthquake'=>array(
>        "SELECT E.eventID AS id,E.magnitude AS 'RichterMagnitude',
>                                E.date_time AS 'dc:date',
>                                E.latitude ,
>                                E.longitude ,
>                                E.depth AS 'depth^^xsd:decimal',
>                                E.region AS 'GeographicalRegion',
>                                Eg.distance AS 'disnace^^xsd:decimal',
>                                Eg.direction AS 'CompassBearingValue',
>                                Eg.pointlocation AS 'GeographicalRegion',
>         FROM earthquake E INNER JOIN earthquakegrp Eg ON(E.eventID
> =Eg.eventID)")
> );
>
>
>
> $triplify['license']='http://creativecommons.org/licenses/by/3.0/us/';
>
> /* Additional metadata
>  * You can add arbitrary metadata. The keys of the following array are
>  * properties, the values will be represented as respective property
> values.
>  */
> $triplify['metadata']=array(
>    'dc:title'=>'',
>    'dc:publisher'=>''
> );
>
> $triplify['register']=true;
>
> $triplify['TTL']=0;
>
>
> $triplify['cachedir']='cache/';
>
>
> $triplify['LinkedDataDepth']='2';
>
> /* Callback Functions
>  *
>  * Some of the columns of the Triplify queries will contain data, which has
> to
>  * be processed before exposed as RDF (literals). This configuration array
> maps
>  * column names to respective functions, which have to take the data value
> as a
>  * parameter and return it processed.
>  */
> $triplify['CallbackFunctions']=array(
> );
> ?>
>
> But during the execution of triplify with the URL :
> http://localhost/triplify/earthquake it generates some error like
>
> " Not Found
>
> The requested URL /triplify-0.6/earthquake was not found on this server. "
>
> What would be the reason for this. Any of you are aware of this ??
>
> Thanks & regards,
>
> Thushari
>
>  -- Thushari Silva
> -------------- next part --------------
> An HTML attachment was scrubbed...
>
> ------------------------------
>
> Message: 2
> Date: Fri, 30 Oct 2009 19:55:26 +0100 (CET)
> From: Sebastian Dietzold <die...@in...>
> Subject: [Triplify-discussion] Triplify 0.7 released
> To: tri...@li...
> Message-ID:
>        <alp...@yb...>
> Content-Type: text/plain; charset="utf-8"
>
>
> Hello List,
>
> We just released version 0.7 of the Triplify script, which includes the
> following feature enhancements and fixes:
>
> * Triplify can be used now as a tool for Extract-Tranform-Load (ETL)
>   cycles by calling it from the command line.
>
> * The default behavior for mapping URIs to SQL queries can be easily
>   extended now by using regular expressions to match request URL?s.
>
> * The default provenance namespaces was fixed
> * A error with two or more tables in a query (#2875711) was fixed
>
> The new feature are documented on triplify.org [1].
>
> Thanks to everybody contributing bug fixes or comments and code
> (especially S?ren Auer and Soren Roug)
>
> S.Dietzold
>
> [1] http://triplify.org/Documentation
>
> --
> Sebastian Dietzold - Department of Computer Science; University of Leipzig
> Tel/Fax: +49 341 97 323-66/-29 <tel:+49341973236629>
> http://bis.uni-leipzig.de/SebastianDietzold
>
> ------------------------------
>
> Message: 3
> Date: Sun, 1 Nov 2009 08:03:11 +0700
> From: Hendrik <jav...@gm...>
> Subject: [Triplify-discussion] Update registry
> To: tri...@li...
> Message-ID:
>        <2a7...@ma...>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Hi All,
> I tried to use triplfy to triplify my data into RDF.  I registered my
> domain
> and it worked well. However, when i added new queries in the configuration
> file, and i called my.domain/triplify/, there is nothing happened, the file
> only contain the old RDFs. Can we update the registered domain with
> reflects
> our updated data?
> Thank you.
> best regards,
> Hendrik
> -------------- next part --------------
> An HTML attachment was scrubbed...
>
> ------------------------------
>
> Message: 4
> Date: Thu, 12 Nov 2009 16:05:23 +0100
> From: Thomas Schandl <t.s...@se...>
> Subject: Re: [Triplify-discussion] Character encoding problems
>        (postgreSQL)
> To: tri...@li...
> Message-ID: <4AF...@se...>
> Content-Type: text/plain; charset=us-ascii; format=flowed
>
> Hello!
>
> As a follow up to my quoted mail below:
>
> I suspect that the root of the chararcter encoding problem I experienced
> might be triplify's use of ntriples:
> http://www.w3.org/2001/sw/RDFCore/ntriples/  (see Section 5 - Issues)
>
> So others might encounter the same problems when using triplify, because
> I didn't get correctly encoded triples out of it (even though the
> postgreSQL db was utf-8).
>
> BTW: I always wondered why in several places you say "triplify outputs
> RDF/N3, JSON or Linked Data".
> Is there any difference in how triplify outputs "rdf/n3" and "linked data"?
> I assume that the latter is simply triplify's rdf/n3 output after one
> takes care of content negotiation by himself - is this right?
>
> Also wouldn't it be better to say rdf/ntriples instead of rdf/n3?
> I know ntriples is a subset of n3, but it's easy to confuse which format
> is which anyway, so I prefer the most exact names.
>
> Best regards,
> Thomas
>
> Thomas Schandl schrieb:
> > Hello!
> >
> > I connect via PDO to a postgreSQL DB that is encoded in UTF-8
> >
> > When I open the files produced by triplify 0.4 one of my text editor
> > says they are UTF-8, the other one "ANSI as UTF-8". In any case there
> > are wrong encodings for umlauts and other special characters and I can
> > not convert them to a format without encoing errors.
> > I thought it must be PDO (which I don't have experience with) but I
> > found a comment that "pdo doesn't care about charsets" [1]
> >
> > Any ideas what the cause could be or what I could do to analyse the
> > situation?
> >
> > BTW:
> > To get 0.4 to work with postgreSQL I had to apply the small hack to the
> > triplify script proposed by Jun Zhao, namely substitue in line 120
> > WHERE 1
> > with
> > WHERE '1'
> >
> > I tried using triplify 0.5, but couldn't get it to work at all with
> > postgres (I intend to look into that and report in case there is any
> bug).
> >
> > Best regards,
> > Thomas
> >
> > [1] http://at.php.net/pdo
>
>
> --
> ** Die Zukunft des Internet: http://www.zukunftsweb.at/
>
> | Thomas Schandl, Semantic Web Company
> | Lerchenfelder Guertel 43, A - 1160 Wien, Austria
> | Tel +43/1/402 12 35 <tel:+4314021235> | Mob +43/680/120 78 77<tel:+436801207877>
>
> COMPANY INFORMATION
> | http://www.semantic-web.at/ | http://blog.semantic-web.at/
>
> PERSONAL INFORMATION
> | mailto:t.s...@se... | skype:comfycat
>
>
>
> ------------------------------
>
> Message: 5
> Date: Fri, 20 Nov 2009 15:59:50 +0100
> From: Davide Ceolin <dav...@gm...>
> Subject: [Triplify-discussion] Rewriting/redirection doesn't work
> To: tri...@li...
> Message-ID: <C15...@gm...>
> Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes
>
> Dear all,
>
> I am desperately looking for help. :)
> I have just installed Triplify and calling http:localhost/triplify
> everything works.
> The problem is that invoking http:localhost/triplify/query, the server
> doesn't understand the address and returns a "Not found" error.
> mod_rewrite is on, the .htaccess file is as I downloaded it. Also
> changing parameters in config.inc.php, nothing improves.
> Does anyone have an idea about the solution?
> Thank you in advance.
> Cheers,
>
> Davide
>
>
>
> ------------------------------
>
> Message: 6
> Date: Fri, 20 Nov 2009 16:28:45 +0100
> From: Eric Feliksik <fel...@gm...>
> Subject: Re: [Triplify-discussion] Rewriting/redirection doesn't work
> To: Davide Ceolin <dav...@gm...>
> Cc: tri...@li...
> Message-ID:
>        <d2e...@ma...>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Dear Davide.
>
> It is not clear how you configured your SQL query for the class 'query'
> (you
> only mention the URI http:localhost/triplify/query , which is a sloppy
> url!)
>
>
> Are you having an apache-generated 404 error, or an "Error 404. Resource
> not
> found" error as generated by Triplify? Be specific! In my case I got an
> apache-generated 404 error. What I did was the following:
>
> 1) replace line 22 of index.php:
> (in_array('mod_rewrite',
> apache_get_modules())?'':'index.php/');
>    with:
> (false && in_array('mod_rewrite',apache_get_modules())?'':'index.php/'); //
> mod_rewrite is installed, but somehow it's not used properly. Ignore it.
>
> 2) Try to access http://localhost/triplify/index.php/query
>
> If this works for you, you'll have to configure your mod_rewrite in order
> to
> get a nicer URL. Let me know how to do that, once you figured it out :-)
>
> Cheers,
> Eric
>
>
> On Fri, Nov 20, 2009 at 3:59 PM, Davide Ceolin <dav...@gm...
> >wrote:
>
> > Dear all,
> >
> > I am desperately looking for help. :)
> > I have just installed Triplify and calling http:localhost/triplify
> > everything works.
> > The problem is that invoking http:localhost/triplify/query, the server
> > doesn't understand the address and returns a "Not found" error.
> > mod_rewrite is on, the .htaccess file is as I downloaded it. Also
> > changing parameters in config.inc.php, nothing improves.
> > Does anyone have an idea about the solution?
> > Thank you in advance.
> > Cheers,
> >
> > Davide
> >
> >
> >
> ------------------------------------------------------------------------------
> > Let Crystal Reports handle the reporting - Free Crystal Reports 2008
> 30-Day
> > trial. Simplify your report design, integration and deployment - and
> focus
> > on
> > what you do best, core application coding. Discover what's new with
> > Crystal Reports now.  http://p.sf.net/sfu/bobj-july
> > _______________________________________________
> > Triplify-discussion mailing list
> > Tri...@li...
> > https://lists.sourceforge.net/lists/listinfo/triplify-discussion
> >
> -------------- next part --------------
> An HTML attachment was scrubbed...
>
> ------------------------------
>
>
> ------------------------------------------------------------------------------
> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
> trial. Simplify your report design, integration and deployment - and focus
> on
> what you do best, core application coding. Discover what's new with
> Crystal Reports now.  http://p.sf.net/sfu/bobj-july
>
> ------------------------------
>
> _______________________________________________
> Triplify-discussion mailing list
> Tri...@li...
> https://lists.sourceforge.net/lists/listinfo/triplify-discussion
>
>
> End of Triplify-discussion Digest, Vol 11, Issue 1
> **************************************************
>