Changes between Version 2 and Version 3 of Opal HowTo Import Data

Timestamp:

08/20/15 15:54:03 (9 years ago)

Author:

Richard Bramley

Comment:

--

Opal HowTo Import Data

@@ -5 +5 @@
 == Resources
 
-- [[http://wiki.obiba.org/display/OPALDOC/Identifiers+Mappings]]
-- [[https://wikis.bris.ac.uk/display/DSDEV/Upload+your+own+data+into+Opal]]
+- [[http://wiki.obiba.org/display/OPALDOC/Identifiers+Mappings|Identifiers Mapping]]
+- [[https://wikis.bris.ac.uk/display/DSDEV/Upload+your+own+data+into+Opal|Upload Data]]
+
+1. Create a project from `Projects > Add Project`
+2. Remember to select the data database.
+3. In the project `Files` tab, create 2 folders called `Dictionaries` and `Uploaded Data`.  This is just a suggestion.
+4. Select the `Dictionaries` folder and click the `Upload` button to upload the dictionary files.  (See the format in the `Upload data` resource above)
+5. In the `Uploaded Data` folder upload the data files.
+6. **NB**: It expects CSV files to have comma separators.  If the file is tab delimited, it requires the file to have a TSV extension.
+7. Go to the `Tables` tab in the project and select the `Add Table` button and select `Add/update tables from dictionary`.
+8. Browse for the dictionary file in the project dictionary folder and follow the dialogue.
+9. Then also in the `Tables` tab, click on the `Import` button.
+10. Select CSV format and click `Next`.
+11. Browse for the data file in the project files.
+12. Change the name of the table to the table that you want the data uploading into.
+13. **NB**: If the file is tab delimited, you need to change the delimiter to `\t` in the advanced settings.
+14. Click next and select the dictionary definition and click finish to import.
+15.  The data is loaded in a background task that can be viewed in the project `Tasks` tab.
 
 [[BackLinks]]