You can subscribe to this list here.
2008 |
Jan
|
Feb
|
Mar
(1) |
Apr
(5) |
May
|
Jun
(1) |
Jul
(1) |
Aug
(2) |
Sep
|
Oct
|
Nov
|
Dec
|
---|---|---|---|---|---|---|---|---|---|---|---|---|
2009 |
Jan
|
Feb
(9) |
Mar
|
Apr
(11) |
May
|
Jun
(10) |
Jul
(12) |
Aug
(1) |
Sep
(6) |
Oct
(5) |
Nov
(14) |
Dec
(4) |
2010 |
Jan
(3) |
Feb
|
Mar
(1) |
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
2011 |
Jan
|
Feb
(1) |
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
From: Bob F. <za...@sm...> - 2011-02-23 10:31:50
|
Hello everybody, I recently discovered the Triplify Update Vocabulary [1] and thereby I had a look at its deployment in the Triplify update logs [2]. I especially like the coarse and fine grained fragmentation of the update logs. Generally, it reminds me a bit to the Simple Update Protocol [3], which also aggregates update notifications as digests and clients can poll them to receive the complete update of subscriptions as needed. However, I'm a bit curious about that I probably have to traverse always the whole fragmentation structure of the update log to reach references of resource update descriptions (which are available at its finest grained fragmentation e.g., [4]). I guess, it would also make sense to direct include at least a reference to a list with references to all resource update descriptions in that specific period of time (or whatever kind of fragmentation is deployed with the update log). What do you think about this issue? Otherwise, it might probably a bit expensive, if clients always have to traverse the whole fragmentation structure to reach the references of the resource update descriptions. Cheers, Bob [1] http://triplify.org/vocabulary/update [2] http://triplify.org/triplify/update/ [3] http://code.google.com/p/simpleupdateprotocol/ [4] http://triplify.org/triplify/update/2011/02/08/23/45/47 |
From: Philipp F. <fri...@in...> - 2010-03-05 13:58:48
|
Hi all, we just released version 0.8 [1] of the Triplify script. We made some additions and bug fixes the most important of which are: * New Feature: Semantic Pingback [2] - XML-RPC service, X-Pingback header and export of registered pingbacks * Fix: Cache ID is now generated using the server name, port and request URI * Fix: Added a 404 Resource not Found error message * Fix: New config option to disable the use of mod_rewrite (for cases, where the module is available, but not configured) * Fix: Removed hard-coded MySQL settings to allow e.g. PostgreSQL servers (#2899948) * Fix: Duplicate triples in some cases (#2833620) * Fix: 404 when URI with query was requested (e.g. json output, #2631600) Thanks to everybody contributing bug fixes or comments (especially Eric Feliksik). On behalf of the AKSW team [3] Philipp Frischmuth [1] https://sourceforge.net/projects/triplify/files/ [2] http://aksw.org/Projects/SemanticPingBack/ [3] http://aksw.org -- Philipp Frischmuth - Department of Computer Science; Universität Leipzig Tel/Fax: +49 341 97 323-68/-29 http://bis.uni-leipzig.de/PhilippFrischmuth |
From: Joss W. <jo...@jo...> - 2010-01-24 08:37:10
|
Hello, Just to let the list know that as part of the JISCPress project, we've written a Triplify config file for WordPress Multi-User and a plugin for WPMU that posts Triplify data to the Talis Platform, RDF store. More details towards the bottom of this page: http://jiscpress.blogs.lincoln.ac.uk/2009/12/16/the-jiscpress-prototype-demonstrator-platform/ Specifically, the plugin and config file are here: http://wordpress.org/extend/plugins/wpmu-talis-triple-uploader/ Joss |
From: Sören A. <au...@in...> - 2010-01-21 11:14:41
|
On 21.01.2010 10:10, Pierre-Antoine Champin wrote: > You may be interested in having a look at We did ;-) - e.g. it is referenced in the related work section of our report on LESS [1]. Indeed the aims of T4R and LESS are very similar. However, LESS focuses also on sharing and collaboration on templates and it is very much aligned with the Linked Data paradigm (e.g. LESS dynamically dereferences additional resources). We were actually thinking about supporting different template languages (in addition to our LeTL) at a later stage and T4R might be an interesting candidate. --Sören [1] http://www.informatik.uni-leipzig.de/~auer/publication/semtem.pdf |
From: Sören A. <au...@in...> - 2010-01-20 17:48:15
|
Hi all, On behalf of the AKSW research group [1] and Netresearch GmbH [2] I'm very pleased to announce LESS - an end-to-end approach for the syndication and use of linked data based on the definition of visualization templates for linked data resources and SPARQL query results. Such syndication templates are edited, published and shared by using LESS' collaborative Web platform. Templates for common types of entities can then be combined with specific, linked data resources or SPARQL query results and integrated into a wide range of applications, such as personal homepages, blogs/wikis, mobile widgets etc. LESS and further information and documentation can be found at: http://less.aksw.org Particular thanks go to Raphael Doering (Netresearch) who performed most of the development work and to Sebastian Dietzold (AKSW) for contributing in various ways. Cheers, Sören Auer [1] http://aksw.org [2] http://netresearch.de -- -------------------------------------------------------------- Sören Auer, AKSW/Computer Science Dept., University of Leipzig http://www.informatik.uni-leipzig.de/~auer, Skype: soerenauer |
From: Femke R. <fem...@ca...> - 2009-12-16 02:35:32
|
Hello all, I'm trying to get triplify up and running and have struck a problem I've spent some time on trying to resolve. I'd greatly appreciate any help in resolving this problem. The PDO connection to a postgresql db works (I get "PDO connection object created"), but I get a triplify generated "Error 404 Resource not found!" exception. My query in the config file looks like this: $triplify['queries']=array('building'=>"SELECT buildingfootprints.name AS facilities:Building FROM buildingfootprints", ); My URL is this: http://localhost:8080/triplify/index.php/building/Geography Looking at the php code in the index, the exception occurs when $exists is not set to true following this if statement: if(substr($key,0,1)=='/' && preg_match($key,$path)) What I don't understand is why does this line checks for a '/' in the key value of $triplify['queries'], which is assigned the value of 'building' from the config file? Second, if I insert a line of code to set $exists=true after this, I get a "Problem loading page, File not found" error, stating that "Firefox can't find the file at http://localhost:8080/triplify/index.php/building/Geography" In terms of system configuration, I'm running it on Fedora, Apache HTTP server, Postgresql DB, Firefox browser. The .htaccess file is in place. Thanks in advance, femke Dr. Femke Reitsma Senior Lecturer Geography, University of Canterbury Private Bag 4800, Christchurch, New Zealand +64 3 364 2987 ext 4180 | www.femker.org This email may be confidential and subject to legal privilege, it may not reflect the views of the University of Canterbury, and it is not guaranteed to be virus free. If you are not an intended recipient, please notify the sender immediately and erase all copies of the message and any attachments. Please refer to http://www.canterbury.ac.nz/emaildisclaimer for more information. |
From: Sebastian D. <die...@in...> - 2009-12-15 18:40:35
|
quote Alex Bilbie (15.12.2009): Hi Alex, I will commit your code asap and release it as 0.7.1 ... SD > Date: Tue, 15 Dec 2009 17:44:36 > From: Alex Bilbie <al...@al...> > To: tri...@li... > Subject: [Triplify-discussion] Proposed change for cache filenames > > Hi there, > > For our work developing http://jiscpress.org/ we've written a Triplify configuration script for > the Wordpress Multi-User platform and an accompanying plugin which upload blog triples to the > Talis Platform however we've hit a road block. > > Basically the plugin relies on Triplify caching the triples however currently Triplify gives the > filename of each cache and MD5 of $_SERVER['REQUEST_URI'] (which in our instance will always be > an MD5 of "/triplify/") and so all blog's triples will have the same filename. > > Can I propose that line 53 of index.php be changed from: > > Line 53: $cacheFile=$triplify['cachedir'].md5($_SERVER['REQUEST_URI']); > > to: > > Line 52: $url = $_SERVER["SERVER_NAME"].":".$_SERVER["SERVER_PORT"].$_SERVER["REQUEST_URI"]; > Line 53: $cacheFile=$triplify['cachedir'].md5($url); > > This will mean that we get unique cache filenames for each blog: > http://rim-11-09.jiscpress.org/triplify = 8e711c553d6c8967a7118b16817f578f > http://greenict-09-09.jiscpress.org/triplify = 8dc498f5f567ed021630f4699a69dd75 > etc... > > Many thanks, > > Alex Bilbie > > -- Sebastian Dietzold - Department of Computer Science; University of Leipzig Tel/Fax: +49 341 97 323-66/-29 http://bis.uni-leipzig.de/SebastianDietzold |
From: Alex B. <al...@al...> - 2009-12-15 17:04:04
|
Hi there, For our work developing http://jiscpress.org/ we've written a Triplify configuration script for the Wordpress Multi-User platform and an accompanying plugin which upload blog triples to the Talis Platform however we've hit a road block. Basically the plugin relies on Triplify caching the triples however currently Triplify gives the filename of each cache and MD5 of $_SERVER['REQUEST_URI'] (which in our instance will always be an MD5 of "/triplify/") and so all blog's triples will have the same filename. Can I propose that line 53 of index.php be changed from: Line 53: $cacheFile=$triplify['cachedir'].md5($_SERVER['REQUEST_URI']); to: Line 52: $url = $_SERVER["SERVER_NAME"].":".$_SERVER["SERVER_PORT"].$_SERVER["REQUEST_URI"]; Line 53: $cacheFile=$triplify['cachedir'].md5($url); This will mean that we get unique cache filenames for each blog: http://rim-11-09.jiscpress.org/triplify = 8e711c553d6c8967a7118b16817f578f http://greenict-09-09.jiscpress.org/triplify = 8dc498f5f567ed021630f4699a69dd75 etc... Many thanks, Alex Bilbie |
From: Sören A. <au...@in...> - 2009-12-03 19:42:05
|
OKCon, now in its fifth year, is the interdisciplinary conference that brings together individuals from across the open knowledge spectrum for a day of presentations and workshops. Open knowledge (http://opendefinition.org) promises significant social and economic benefits in a wide range of areas from governance to science, culture to technology. Opening up access to content and data can radically increase access and reuse, improving transparency, fostering innovation and increasing societal welfare. In addition to high profile initiatives such as Wikipedia, OpenStreetMap and the Human Genome Project, there is enormous growth among open knowledge projects and communities at all levels. Moreover, in the last year, many governments across the world have begun opening up their data. And it doesn't stop there. In academia, open access to both publications and data has been gathering momentum, and similar calls to open up learning materials have been heard in education. Furthermore, this gathering flood of open data and content is the creator and driver of massive technological change. How can we make this data available, how can we connect it together, how can we use it collaborate and share our work? * where: London, UK * when: Saturday 24th April, 2010 * www: http://www.okfn.org/okcon/ * last year: http://www.okfn.org/okcon/2009/ * cfp: http://www.okfn.org/okcon/cfp/ (deadline: Jan 31st 2010) * hashtag: #okcon2010 TOPICS We welcome proposals on any aspect of creating, publishing or reusing content or data that is open in accordance with http://opendefinition.org. Topics include but are not limited to: Technology * Semantic Web and Linked Data in relation to open knowledge * Platforms, methods and tools for creating, sharing and curating open knowledge * Light-weight, adaptive interaction models * Open, decentralized social network applications * Open geospatial data Law, Society and Democracy * Open Licensing, Legal Tools and the Public Domain * Open government data and content (public sector information) * Open knowledge and international development * Opening up access to the law Culture and Education * Open educational tools and resources * Business models for open content * Incentive and rewards open-knowledge contributors * Open textbooks * Public domain digitisation initiatives Science and Research * Opening up scientific data * Supporting scientific workflows with open knowledge models * Open models for scientific innovation, funding and publication * Tools for analysing and visualizing open data * Open knowledge in the humanities IMPORTANT DATES * Submission deadline: January 31st 2010 * Notification of acceptance: March 1st * Camera-ready papers due: March 31st * OKCon: April 24th 2010 SUBMISSION DETAIL We are accepting three types of submissions: 1. Full papers of 5-10 pages describing novel strategies, tools, services or best-practices related to open knowledge, 2. Extended talk abstracts of 2-4 pages focusing on novel ideas, ongoing work and upcoming research challenges. 3. Proposals for short talks and demonstrations OKCon will implement an open submission and reviewing process. To make a submission visit: * http://www.okfn.org/okcon/submit/ Depending on the assessment of the submissions by the programme committee and external reviewers, submissions will be accepted either as full, short or lightning/poster presentations. Proceedings of OKCON will be published at http://ceur-ws.org. If you want your submission to be included in the conference proceedings you have to prepare a manuscript of your submission according to the LNCS Style. |
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: > <alpine.DEB.2.00.0910301953110.10754@ybpnyubfg.ybpnyqbznva> > 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 > ************************************************** > |
From: Olivier B. <oli...@it...> - 2009-11-23 07:25:43
|
Hi. Le dimanche 22 novembre 2009 à 09:45 +0100, Sören Auer a écrit : > Olivier Berger wrote: > > My idea is that maybe it would be possible to add another (optional) > > parameter in the mapping definition to better support this case, by > > naming explicitely the id columns of the particular query should it be > > different than "id". > > Yes, this is already possible, but not yet documented: you can provide > the name of the id column as key of the queries array, i.e.: > > $queries=array( > 'user'=>array( > 'uid'=>'SELECT uid,name AS 'foaf:firstname' FROM demo' > ), > ... > ); > > Hope that helps, Sure. In the case of joins between tables, the 'table.column' syntax may also be used for the id naming. It'd be great to add that to the docs. Thanks alot. Best regards, -- Olivier BERGER <oli...@it...> http://www-public.it-sudparis.eu/~berger_o/ - OpenPGP-Id: 1024D/6B829EEC Ingénieur Recherche - Dept INF Institut TELECOM, SudParis (http://www.it-sudparis.eu/), Evry (France) |
From: Eric F. <fel...@gm...> - 2009-11-22 18:54:06
|
The fix I suggested in the other thread (unfortunately it's not in the archives yet, so I can't link it) solves your problem: Change line 143 of index.php from: if(($cols && $cols!='*') || $group) to: if($cols || $group) Cheers, Eric On Sun, Nov 22, 2009 at 8:24 AM, Olivier Berger <oli...@it...> wrote: > Hi. > > In addition to the ticket already filed on SF about MySQL specifics, > there's also a problem in the way the SQL queries of the mapping will be > supported : > > If one has a table whose identifier is not named "id", then using some > simple SQL query in the form of this (in the mapping definition) won't > work on accessing /user/123 like URIs : > SELECT user_id AS id, name AS "foaf:name" FROM users WHERE email IS NOT NULL > > There's an error reported by the postgres server on AND id because no > column named id was found. The addition of "AND id = 123" or likes by > the triplify engine won't work with PostgreSQL. > > I found that one has to use such a construct in the queries to make it > work : > SELECT id, name AS "foaf:name" FROM (SELECT user_id AS id, name FROM users WHERE email IS NOT NULL) users WHERE id IS NOT NULL > (where the last WHERE id IS NOT NULL is because of the AND concatenation issue reported yesterday) > > This works but seems overkill. > > My idea is that maybe it would be possible to add another (optional) > parameter in the mapping definition to better support this case, by > naming explicitely the id columns of the particular query should it be > different than "id". > > Any comments ? > > -- > Olivier BERGER <oli...@it...> > http://www-public.it-sudparis.eu/~berger_o/ - OpenPGP-Id: 1024D/6B829EEC > Ingénieur Recherche - Dept INF > Institut TELECOM, SudParis (http://www.it-sudparis.eu/), Evry (France) > > > ------------------------------------------------------------------------------ > 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 > |
From: Eric F. <fel...@gm...> - 2009-11-22 18:42:43
|
ACTION: request a URL http://localhost/triplify/index.php/academicstaff/John+Doe on triplify 0.7, with $triplify['LinkedDataDepth']==2 BEHAVIOUR: The request returns no data on 'John Doe' (only license-part and provenance meta-data). EXPECTED BEHAVIOR: The request returns the license-part, all data on "John Doe", and metadata. FIX: Change line 143 of index.php (which was introduced in v0.5) from: if(($cols && $cols!='*') || $group) to: if($cols || $group) If you now request http://localhost/triplify/index.php/academicstaff/John+Doe , then $id is specified ('John Doe'), so line 142 sets $cols='*'. Line 144 cleverly builds a nested query: $query="SELECT $cols FROM ($query) t WHERE '1'".$group; which results in: SELECT * FROM (SELECT name AS id, name AS 'foaf:name', office AS 'vocabulary:office', position AS 'vocabulary:position', email AS 'foaf:mbox', CONCAT('tel:',phone) AS 'foaf:phone' FROM academicStaff) t WHERE '1' AND id='John Doe' Notice the WHERE trick Davide suggested is then applied in line 144, and the "AND id='John Doe'" part is appended by line 152. The result is now as expected: All triples with John Doe as subject are returned. Cheers, Eric On Sat, Nov 21, 2009 at 9:09 PM, Davide Ceolin <dav...@gm...> wrote: > > Hi all, > maybe I found a bug: invoking > http://localhost/index.php/user/1 > I received this output: > > <http://localhost/triplify/index.php/user/1> <http://www.w3.org/2000/01/rdf-schema#comment> "Generated by Triplify V0.7 (http://Triplify.org)" . > <http://localhost/triplify/index.php/user/1> <http://creativecommons.org/ns#license> <http://creativecommons.org/licenses/by/3.0/us/> . > <> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://purl.org/net/provenance/ns#DataItem> . > <> <http://purl.org/net/provenance/ns#createdBy> _:x2 . > _:x2 <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://purl.org/net/provenance/ns#DataCreation> . > _:x2 <http://purl.org/net/provenance/ns#performedAt> "2009-11-21T20:38:46+01:00"^^<http://www.w3.org/2001/XMLSchema#dateTime> . > _:x2 <http://purl.org/net/provenance/ns#performedBy> _:x1 . > _:x2 <http://purl.org/net/provenance/ns#usedData> _:x3 . > > [...] > > This meant that I could not see the data, although $triplify['LinkedDataDepth']='2'; . > > This was because the query produced by index.php was something like: > > SELECT id,name AS 'foaf:firstname', SHA(CONCAT('mailto:',email)) AS 'foaf:mbox_sha1sum' FROM demo AND id='1' > > Therefore I changed line 159 in: > > $query=$query." WHERE 1".($id?' AND '.(is_numeric($qid)?'id':$qid).'='.$this->dbQuote(urldecode($id)):''). > (preg_match('/^[A-Za-z0-9: ,]+?$/',$_GET['t-order'])?' ORDER BY '.$_GET['t-order']:''). > ($start||$erg?' LIMIT '.($start?$start.','.($erg?$erg:20):$erg):''); > > and now the result is: > > <http://localhost/triplify/index.php/user/1> <http://www.w3.org/2000/01/rdf-schema#comment> "Generated by Triplify V0.7 (http://Triplify.org)" . > <http://localhost/triplify/index.php/user/1> <http://creativecommons.org/ns#license> <http://creativecommons.org/licenses/by/3.0/us/> . > <http://localhost/triplify/index.php/user/1> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://xmlns.com/foaf/0.1/person> . > <http://localhost/triplify/index.php/user/1> <http://xmlns.com/foaf/0.1/firstname> "davide" . > <http://localhost/triplify/index.php/user/1> <http://xmlns.com/foaf/0.1/mbox_sha1sum> "047529160d1b5e60d0d83ddd58c77c5b5bc40c28" . > <> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://purl.org/net/provenance/ns#DataItem> . > <> <http://purl.org/net/provenance/ns#createdBy> _:x2 . > _:x2 <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://purl.org/net/provenance/ns#DataCreation> . > _:x2 <http://purl.org/net/provenance/ns#performedAt> "2009-11-21T20:38:46+01:00"^^<http://www.w3.org/2001/XMLSchema#dateTime> . > _:x2 <http://purl.org/net/provenance/ns#performedBy> _:x1 . > _:x2 <http://purl.org/net/provenance/ns#usedData> _:x3 . > > [...] > > I don't know whether it is the right place where to put " WHERE 1" since I could not check all backsides. > > 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 > |
From: Sören A. <au...@in...> - 2009-11-22 09:02:26
|
Olivier Berger wrote: > My idea is that maybe it would be possible to add another (optional) > parameter in the mapping definition to better support this case, by > naming explicitely the id columns of the particular query should it be > different than "id". Yes, this is already possible, but not yet documented: you can provide the name of the id column as key of the queries array, i.e.: $queries=array( 'user'=>array( 'uid'=>'SELECT uid,name AS 'foaf:firstname' FROM demo' ), ... ); Hope that helps, Sören -- -------------------------------------------------------------- Sören Auer, AKSW/Computer Science Dept., University of Leipzig http://www.informatik.uni-leipzig.de/~auer, Skype: soerenauer |
From: Olivier B. <oli...@it...> - 2009-11-22 07:24:27
|
Hi. In addition to the ticket already filed on SF about MySQL specifics, there's also a problem in the way the SQL queries of the mapping will be supported : If one has a table whose identifier is not named "id", then using some simple SQL query in the form of this (in the mapping definition) won't work on accessing /user/123 like URIs : SELECT user_id AS id, name AS "foaf:name" FROM users WHERE email IS NOT NULL There's an error reported by the postgres server on AND id because no column named id was found. The addition of "AND id = 123" or likes by the triplify engine won't work with PostgreSQL. I found that one has to use such a construct in the queries to make it work : SELECT id, name AS "foaf:name" FROM (SELECT user_id AS id, name FROM users WHERE email IS NOT NULL) users WHERE id IS NOT NULL (where the last WHERE id IS NOT NULL is because of the AND concatenation issue reported yesterday) This works but seems overkill. My idea is that maybe it would be possible to add another (optional) parameter in the mapping definition to better support this case, by naming explicitely the id columns of the particular query should it be different than "id". Any comments ? -- Olivier BERGER <oli...@it...> http://www-public.it-sudparis.eu/~berger_o/ - OpenPGP-Id: 1024D/6B829EEC Ingénieur Recherche - Dept INF Institut TELECOM, SudParis (http://www.it-sudparis.eu/), Evry (France) |
From: Olivier B. <oli...@it...> - 2009-11-22 07:13:00
|
Le samedi 21 novembre 2009 à 21:09 +0100, Davide Ceolin a écrit : SNIP > This was because the query produced by index.php was something like: > SELECT id,name AS 'foaf:firstname', SHA(CONCAT('mailto:',email)) AS 'foaf:mbox_sha1sum' FROM demo AND id='1' SNIP > [...] > I don't know whether it is the right place where to put " WHERE 1" > since I could not check all backsides. I've found similar issues, and solved them by systematically adding something like WHERE id IS NOT NULL in the queries definition in the mappings. Definitely, there might be a check in the content of the user-provided mapping to see if there are WHERE filters before using AND, IMHO. Hope this helps. Best regards, -- Olivier BERGER <oli...@it...> http://www-public.it-sudparis.eu/~berger_o/ - OpenPGP-Id: 1024D/6B829EEC Ingénieur Recherche - Dept INF Institut TELECOM, SudParis (http://www.it-sudparis.eu/), Evry (France) |
From: Davide C. <dav...@gm...> - 2009-11-21 20:09:28
|
Hi all, maybe I found a bug: invoking http://localhost/index.php/user/1 I received this output: <http://localhost/triplify/index.php/user/1> <http://www.w3.org/2000/01/rdf-schema#comment > "Generated by Triplify V0.7 (http://Triplify.org)" . <http://localhost/triplify/index.php/user/1> <http://creativecommons.org/ns#license > <http://creativecommons.org/licenses/by/3.0/us/> . <> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://purl.org/net/provenance/ns#DataItem > . <> <http://purl.org/net/provenance/ns#createdBy> _:x2 . _:x2 <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://purl.org/net/provenance/ns#DataCreation > . _:x2 <http://purl.org/net/provenance/ns#performedAt> "2009-11-21T20:38:46+01:00"^^<http://www.w3.org/2001/ XMLSchema#dateTime> . _:x2 <http://purl.org/net/provenance/ns#performedBy> _:x1 . _:x2 <http://purl.org/net/provenance/ns#usedData> _:x3 . [...] This meant that I could not see the data, although $triplify['LinkedDataDepth']='2'; . This was because the query produced by index.php was something like: SELECT id,name AS 'foaf:firstname', SHA(CONCAT('mailto:',email)) AS 'foaf:mbox_sha1sum' FROM demo AND id='1' Therefore I changed line 159 in: $query=$query." WHERE 1".($id?' AND '.(is_numeric($qid)?'id': $qid).'='.$this->dbQuote(urldecode($id)):''). (preg_match('/^[A-Za- z0-9: ,]+?$/',$_GET['t-order'])?' ORDER BY '.$_GET['t-order']:''). ($start||$erg?' LIMIT '.($start?$start.','.($erg?$erg:20):$erg):''); and now the result is: <http://localhost/triplify/index.php/user/1> <http://www.w3.org/2000/01/rdf-schema#comment > "Generated by Triplify V0.7 (http://Triplify.org)" . <http://localhost/triplify/index.php/user/1> <http://creativecommons.org/ns#license > <http://creativecommons.org/licenses/by/3.0/us/> . <http://localhost/triplify/index.php/user/1> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type > <http://xmlns.com/foaf/0.1/person> . <http://localhost/triplify/index.php/user/1> <http://xmlns.com/foaf/0.1/firstname > "davide" . <http://localhost/triplify/index.php/user/1> <http://xmlns.com/foaf/0.1/mbox_sha1sum > "047529160d1b5e60d0d83ddd58c77c5b5bc40c28" . <> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://purl.org/net/provenance/ns#DataItem > . <> <http://purl.org/net/provenance/ns#createdBy> _:x2 . _:x2 <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://purl.org/net/provenance/ns#DataCreation > . _:x2 <http://purl.org/net/provenance/ns#performedAt> "2009-11-21T20:38:46+01:00"^^<http://www.w3.org/2001/ XMLSchema#dateTime> . _:x2 <http://purl.org/net/provenance/ns#performedBy> _:x1 . _:x2 <http://purl.org/net/provenance/ns#usedData> _:x3 . [...] I don't know whether it is the right place where to put " WHERE 1" since I could not check all backsides. Cheers, Davide |
From: Eric F. <fel...@gm...> - 2009-11-20 17:24:15
|
Hey Davide, As I suspected, your mapping doesn't work properly: first you got an Apache error, now it's a Triplify error. (Not very obvious, but the error msg is generated by line 43 of index.php of Triplify 0.7). That means the situation is actually better now. If you replace that line by: echo("<h1>Error 404</h1>Resource not found: class '$class' !"); Triplify will tell you WHAT resource it didn't find, which should help you out. I know it's not easy, I'm struggling myself! However, you actually didn't specify on what exact URL you got the "Error 404: Resource not found!" message, which means I not only have to think about the possible reasons Triplify is giving this error message, but people I also have to speculate about what your exact URL request was (That sucks! Also for you, because now I'll enjoy my weekend :-) ) I hope it was http://localhost/triplify/index.php/user<http://localhost/triplify/index.php/query>. Is your error now "Resource not found: class 'user'!" ? Good luck. Regards, Eric On Fri, Nov 20, 2009 at 5:10 PM, Davide Ceolin <dav...@gm...>wrote: > Dear Eric, > > thank you for your response. > > I have two simple queries (for the moment I only want to make it work and > "query" was a fake name), which are: > > $triplify['queries']=array( > 'user'=>"SELECT id,name AS 'foaf:firstname', SHA(CONCAT('mailto:',email))<%27,email%29%29>AS 'foaf:mbox_sha1sum' FROM demo", > 'user2'=>"SELECT id,name AS 'foaf:firstname' FROM demo", > ); > > but the problem are not them, because they work (calling > http://localhost/triplify) <http://localhost/triplify%29>. The problem is > accessing one class or one instance (also setting > properly $triplify['LinkedDataDepth']): > > when I leave index.php as it is the error received is: > > Not Found > > The requested URL /triplify/user was not found on this server. > > While disabling mod_rewrite as you suggested, the error reported is: > > Error 404Resource not found! > Do you have any other idea? > > Thank you again. > Cheers, > > Davide > > Il giorno 20/nov/09, alle ore 16:28, Eric Feliksik ha scritto: > > 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 >> > > > |
From: Davide C. <dav...@gm...> - 2009-11-20 16:11:12
|
Dear Eric, thank you for your response. I have two simple queries (for the moment I only want to make it work and "query" was a fake name), which are: $triplify['queries']=array( 'user'=>"SELECT id,name AS 'foaf:firstname', SHA(CONCAT('mailto:',email)) AS 'foaf:mbox_sha1sum' FROM demo", 'user2'=>"SELECT id,name AS 'foaf:firstname' FROM demo", ); but the problem are not them, because they work (calling http://localhost/triplify) . The problem is accessing one class or one instance (also setting properly $triplify['LinkedDataDepth']): when I leave index.php as it is the error received is: Not Found The requested URL /triplify/user was not found on this server. While disabling mod_rewrite as you suggested, the error reported is: Error 404 Resource not found! Do you have any other idea? Thank you again. Cheers, Davide Il giorno 20/nov/09, alle ore 16:28, Eric Feliksik ha scritto: > 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 > |
From: Eric F. <fel...@gm...> - 2009-11-20 15:28:58
|
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 > |
From: Davide C. <dav...@gm...> - 2009-11-20 15:00:08
|
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 |
From: Thomas S. <t.s...@se...> - 2009-11-12 15:23:44
|
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 | Mob +43/680/120 78 77 COMPANY INFORMATION | http://www.semantic-web.at/ | http://blog.semantic-web.at/ PERSONAL INFORMATION | mailto:t.s...@se... | skype:comfycat |
From: Hendrik <jav...@gm...> - 2009-11-01 01:03:21
|
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 |
From: Sebastian D. <die...@in...> - 2009-10-30 18:55:45
|
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 http://bis.uni-leipzig.de/SebastianDietzold |
From: Thushari S. <atp...@gm...> - 2009-10-23 16:49:39
|
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 |