Import CSV data

LinkedDataHub allows all the import components be created from a single dialogue, but we will go through the process in separate steps:

1. First, create a container for the data to be imported. This will be the import's target container
2. Upload a CSV file. Click on the Create button in the top left-hand corner and select File. This will open a new form.
3. Fill in the mandatory fields:

   Title

   File title

   Filename

   Click on Choose file and select a CSV file from your computer

   Title

   Document title

4. Once all the fields have been filled in, click Save
5. The browser will open your imported file
6. Create a mapping query that will transform the uploaded CSV to RDF. Click on the Create button in the top left-hand corner and select CONSTRUCT. This will open a new form.
7. Fill out the mandatory fields:

   Text

   SPARQL CONSTRUCT query string

   You will not be able to save the query if its syntax is not valid SPARQL 1.1.

   Title

   Query title

   Title

   Document title

8. Once all the fields have been filled in click Save. You can find this saved under Queries container in left navigation.
9. Click on the Create button at the top left-hand corner and select CSV import. This will open a new form.
10. Fill out the mandatory fields:

    File

    Start typing the name of your CSV file and select it from the typeahead.

    Query

    Select the corresponding mapping query using the typeahead.

    Target container

    Select the target container using the typeahead.

    Title

    Import title

    Title

    Document title

11. Click Save and you will be redirected the newly created import document.
12. Refresh the document after a couple of moments to see the import progress. In case of success, the amount of data imported will be displayed. In case of failure, constraint violation(s) or other import issues will be displayed.
13. Go back to the target container to see the newly imported data items.