Using Sheet2RDF

Sheet2RDF comes both as a command line tool and as a Semantic Turkey extension. If you want to use Sheet2RDF without installing Semantic Turkey, you can then use it from command-line interface (CLI distribution).

Specific instructions for the ST extension can be found on its dedicated page while here we provide in-detail instructions for the CLI utility.

Which version to choose?

The user-interface of the ST extension allows for more interactive guidance towards the generation of the PEARL file, which will drive in turn the production of the triples from the spreadsheet content. However, there are a few scenarios where using the CLI might be preferable:

Running Sheet2RDF from command line

To run a triplification process from command line you need to create a .properties file containing the system and process configuration. The following properties are available:

A very simple way to start using Sheet2RDF in command line mode is by trying the CLI demo distribution.

Command line interface demo

A simple demo of the command line usage can be downloaded here This demo triplifies the content of an excel file representing a sample of the Agrovoc thesaurus.

To use the demo, follow the steps below:

  1. Download the zip archive containing the demo
  2. Unpack it into a directory
  3. Launch the executable sheet2rdf.bat or sheet2rdf.sh (depending on the operating system)
  4. Once the test is completed you will find the .rdf output file in the same directory where you have unpacked the archive Sheet2RDF_CLI_demo.zip.

This demo uses the configuration parameter specified in the s2rdfProperties.properties file. This is the file content:

			 
#properties needed to make Sheet2RDF work from command line

#path of the datasheet file to triplify
datasheetFile=AgrovocSample.xlsx

#input rdf file with background knowledge to enrich with triples generated by Sheet2RDF (optional, if not provided the output file will be created and populated from scratch)
#inputRdfFile=input.rdf

#output rdf file. If commented, Sheet2RDF will write directly over the input file (in this case, inputFile must be specified, otherwise default name output.rdf will be assigned to this parameter)
outputRdfFile=output.rdf

#type of model (available choise SKOSXL, SKOS or OWL, default SKOSXL)
modelType=SKOSXL

#model base URI
baseUri=http://baseuri.org

#name of the skosScheme to which the concept will belong (if it's dealing with a skos thesaurus)
skosInScheme=main

#the directory used by the triple management to store the model (optional, default 'repDir')
repositoryDir=repDir

#directory to store CODA bundles
bundlesFolder=bundles

#cache directory of felix (optional, default 'felix')
felixCache=felix