|
From: <tig...@gm...> - 2009-11-26 12:35:13
|
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 > ************************************************** > |