Create a Catalogue from file

Prerequisite

In order to successfully create a new catalogue from a file, RDMP accept only specific files formats: flat file (*.csv, *.txt) or Excel (*.xls).

Flat files are easier to load than Excel

It is key that the file loaded doesn’t already exist as a catalogue in RDMP. If the new catalogue is specific to a project please rename the file in relevance with the topic, before starting this process.

This process is sensitive to failure due to:

Column type incompatibility
Fields size capacity
…

RDMP system tries its best to cover the errors which can occur at any point of the loading process. Please refer to section - When something goes wrong… of this page for help.

Steps

Step 1: (‎30/‎03/‎2020 08:32:06) User left click on "Catalogues (button)" in "Hom"

Version:1.0 StartHTML:000000284 EndHTML:000001191 StartFragment:000000879 EndFragment:000001147 StartSelection:000000879 EndSelection:000001143 SourceURL:mhtml:file://C:\Users\MGuignardduff\OneDrive - University of Dundee\Desktop\RDMP instructions\Recording_20200330_0854.mht

Step 1: (‎30/‎03/‎2020 08:32:06) User left click on "Catalogues (button)" in "Hom"

Step 1 screenshot.

Previous Next

Step 2: (‎30/‎03/‎2020 08:32:08) User left click on "Catalogues (button)" in "Hom"

Step 2 screenshot.

Previous Next

Step 3: (‎30/‎03/‎2020 08:32:09) User right click on "\ (text)" in "Hom"

Step 3 screenshot.

Previous Next

Step 4: (‎30/‎03/‎2020 08:32:11) User left click on "New Catalogue From File (menu item)"

Step 4 screenshot.

Previous Next

Step 5: (‎30/‎03/‎2020 08:32:12) User left click on "Create Catalogue By Importing A File (window)" in "Cre"

Step 5 screenshot.

Previous Next

Step 6: (‎30/‎03/‎2020 08:32:14) User left click on "Browse... (button)" in "Cre"

Step 6 screenshot.

Previous Next

Step 7: (‎30/‎03/‎2020 08:32:16) User left double click on "SMR01 - Hospital Admissions_2.csv (list item)" in "Ope"

Step 7 screenshot.

Previous Next

Step 8: (‎30/‎03/‎2020 08:32:19) User left click on "Open (button)" in "Cre"

Step 8 screenshot.

Previous Next

Step 9: (‎30/‎03/‎2020 08:32:20) User mouse drag start on "RDMP_DataExport (list item)"

Step 9 screenshot.

Previous Next

Step 10: (‎30/‎03/‎2020 08:32:21) User mouse drag end on "RDMP_Catalogue (list item)"

Step 10 screenshot.

Previous Next

Step 11: (‎30/‎03/‎2020 08:32:22) User left click on "Confirm Database (button)" in "Cre"

Step 11 screenshot.

Previous Next

Step 12: (‎30/‎03/‎2020 08:32:25) User left click on "Execute (button)" in "Cre"