You can import data into Daminion from a CSV file.
This is especially useful when you need to transfer data from another database application into Daminion. Alternatively you might have kept your metadata in an Excel spreadsheet and now you want to import this information into Daminion.
To enable a trouble-free import from CSV, you need to follow a few formatting rules, which will be covered in detail later.
Creating the CSV file:
There are many spreadsheet programs that allow you to create CSV files. You can even use the Windows Notepad to create this type of file. Simply change the extension in your filename to .CSV instead of .TXT.
Content of a CSV file:
A CSV file always contains a header row with the names of the fields or tags, that need to be imported as metadata and always begins with the filepath of the data.
In the example above, the images called IMG-01.jpg to IMG-03.jpg will be imported from the given path. Additionally, the Keywords and Copyright tags are attached.
Particular delimiters need to be used to enable Daminion to separate the individual tags and field names.
You may use the following delimiters:
Semicolon [;] Comma [,] Tab [TAB] Individual tags are separated by comma [,] or semicolon [;] and the backslash character [\] is used to create a hierarchy.
For example: “Attractions\Castles” will create a tag called “Attractions” and a second tag called “Castles” as a sublevel tag to the “Attractions” tag.
Please ensure that you always specify the correct delimiter. They must be consistent within each CSV file.
Starting the CSV import in Daminion
Click on the “Import” option of the “File” menu and then select “CSV File...”. Select the CSV file you wish to import in the window that opens.
After selecting the CSV file, the Daminion Import Dialog will open.
This file contains headers
Here you specify if your CSV file contains a header row. If it doesn’t, you will need to select the appropriate row in B “Key Field”.
Select the correct encoding of your CSV file. If the wrong encoding is selected it may lead to the errors when converting some characters, e.g. umlauts.
Key contains full filepath/ Key contains relative file path
Select here the correct format of the source path information.
You may select either absolute or relative paths. If you select the “relative path” option, you can select the source folder via file browser.
After you click OK you will need to match up the relevant field names.
On the left side you will see the field names used in the CSV, and on the right side the related fields to be populated in Daminion. The key field “Filepath” will not be allocated here as it only contains the path information to the source data.
The information from the CSV file will be imported into the Daminion Catalogue after clicking on the “OK” button.