Open Journal Systems (OJS)

OJS is a journal management system. More information can be found at:
http://pkp.sfu.ca/ojs/

Open Journal Systems configuration

This is an initial version which extracts just basic information about authors and articles.


<?php
$cfg=parse_ini_file('../config.inc.php');

$triplify['namespaces']=array(
    'vocabulary'=>'http://triplify.org/vocabulary/ojs/',
    '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/',
    'dc'=>'http://purl.org/dc/elements/1.1/',
    'xsd'=>'http://www.w3.org/2001/XMLSchema#',
);

$triplify['queries']=array(
    'author'=>"SELECT author_id,a.article_id AS 'sioc:creator_of',first_name AS 'foaf:firstName',middle_name,
            last_name AS 'foaf:family_name',affiliation,country,
            SHA(CONCAT('mailto:',email)) AS 'foaf:mbox_sha1sum',url AS 'foaf:homepage'
        FROM article_authors aa INNER JOIN articles a ON(aa.article_id=a.article_id AND status=3)",
    'article'=>"SELECT a.article_id AS id,title.setting_value title,abstract.setting_value abstract,keywords.setting_value keywords
        FROM articles a
            INNER JOIN article_settings title ON(a.article_id=title.article_id AND title.setting_name='title')
            INNER JOIN article_settings abstract ON(a.article_id=abstract.article_id AND abstract.setting_name='abstract')
            INNER JOIN article_settings keywords ON(a.article_id=keywords.article_id AND keywords.setting_name='subject')
        WHERE status=3",
);

$triplify['objectProperties']=array(
    'sioc:creator_of'=>'article',
);

$triplify['classMap']=array(
    'author'=>'foaf:person'
);

$triplify['TTL']=0;

$triplify['db']=new PDO($cfg['driver'].':host='.$cfg['host'].';dbname='.$cfg['name'],$cfg['username'],$cfg['password']);

?>

There are no files on this page. [Display files/form]

There is no comment on this page. [Display comments/form]

Information

Last Modification: 2008-03-16 02:09:02 by Soeren Auer