This example shows how to map a simple CSV file (original csv from wikipedia) into the Vehicle Sales Ontology (VSO) that extends GoodRelations vocabulary. See the comments in the template file for the details of the mapping. The final output can be seen in cars.ttl.
The following command can be used to import the contents of the CSV file into the Stardog database mydb:
stardog-admin virtual import --format sms2 mydb cars_mappings.sms cars.csv
Mappings can be ommitted from the virtual import command for delimited files and the mappings will be generated automatically. Both source files with and without a header row can be imported without mappings. For those without a header row, IRIs will be generated using the index of the columns. See the comments in the cars_autogenerate.properties file for a description of the needed properties for automatic mappings generation. The final output for an import with generated mappings can be seen in cars_autogenerate.ttl.
The following command can be used to import the contents of the CSV file using automatically generated mappings into
the Stardog database mydb:
stardog-admin virtual import mydb cars_autogenerate.properties cars.csv