• Resources
    • About Daminion
    • White Paper
    • Blog
    • Tutorials
    • FAQ
    • Documentation
    • Support
    • Whats New
    • ROI calculator
    • Partners
  • Resources
    • About Daminion
    • White Paper
    • Blog
    • Tutorials
    • FAQ
    • Documentation
    • Support
    • Whats New
    • ROI calculator
    • Partners
  • Features
    • Features list
    • Integrations
    • Feature Tour
    • Daminion vs. other solutions
    • Benefits for IT managers
  • Features
    • Features list
    • Integrations
    • Feature Tour
    • Daminion vs. other solutions
    • Benefits for IT managers
  • Case Studies
  • Pricing
  • Book a Demo
  • Home
  • Documentation
  • Importing files and metadata via a CSV file

Importing files and metadata via a CSV file

  • Not found
Categories
Accessing Daminion via the Internet
  • How to access Daminion remotely via the Internet
  • VPN
Asset Management
  • Adding a Watermark
  • Adding Ratings to Items
  • Assigning a Color Label
  • Flagging an Item
  • Full-screen View
  • Linking Items
  • Open Items in Windows Explorer
  • Printing images
  • Removing items from the catalog
  • Renaming Items
  • Setting a License Expiration Date
  • Shift the creation datetime of the image
  • Usage History
  • Using the Tray
  • Viewing and Editing Items in External Applications
  • Working with Collections
  • Working with the Folder Panel
Auto-tagging
  • How to Auto-Tag Your Photos
  • How to Enable Auto-Tagging in Daminion
  • How to Get Google Cloud Vision API Key
Data Security
  • Access Control on Files Level
  • Access Control on Folders Level
  • Backup and Restore Shared Catalogs
  • Grant or deny access to shared catalogs
  • How to schedule backups of Daminion server
  • Lock Import Settings
  • Roles Configurator
  • Tag Access Restriction
  • Turning off the UDP broadcasts
  • User Management
  • Version Control
Exporting
  • Creating a Contact Sheet in PDF
  • Customized Export Presets
  • Exporting Files
  • Exporting Tags to CSV File
  • Send Files by Email
  • Template Editor
File Formats
  • Adding an Unknown File Format
  • Adding support for 3D
  • Adding support for AutoCAD (DWG/DXF)
  • Adding support for Cineform Video
  • Adding support for STL
  • Supported Formats
File Storage Schemes for Daminion Server
  • Scheme A. Documents are Stored on a NAS or Remote Location. Daminion Server is Installed on a Server PC
  • Scheme B. Documents and Daminion Server are located on the same Computer
  • Scheme C. Documents and Daminion Server are Located on the Same Computer, but Documents are Stored in a Local Shared Folder
Frequently Asked Questions (FAQ)
  • Daminion Client Questions
  • Daminion Server Questions
  • Error messages
Importing
  • Adding an Unknown File Format
  • Automatic Folder Rescan
  • Automatic Folder Rescan Overview
  • Daminion Auto Import Folder
  • How to Migrate Metadata from Canto Cumulus to Daminion
  • Import to selected folder
  • Importing
  • Importing Local Catalogs
  • Rescan Folders Option
Installation
  • Installing Daminion Server
  • Installing Daminion Standalone (Client)
  • System Requirements
Integration with Other Systems
  • Daminion and Adobe Illustrator integration
  • Daminion and Adobe Premiere Pro integration
  • Daminion and InDesign integration
  • Daminion and Lightroom tagging integration
  • Daminion and Photoshop integration
  • Daminion Connector for Adobe
  • Daminion Connector for Microsoft Office: Functionality
  • Daminion Connector for MS Office: Activation
  • Face Recognition: Functionality
  • Face Recognition: Setup
  • Synology and Daminion
Licensing
  • Registering your Daminion License
List of Supported Tokens
  • List of Supported Tokens
Metadata
  • Automatic Synchronization
  • Daminion Server Metadata Preferences
  • How to Write Daminion Custom Tags with ExifTool
  • Importing files and metadata via a CSV file
  • Importing Metadata from Canto Cumulus into Daminion
Searching
  • Advanced Search
  • Finding images on the Internet
  • Quick Search
  • Searching with the Tags Panel
Setting up Daminion
  • Changing the Interface Language
  • Customizing the Browser
  • Customizing the Catalog Tags Panel
  • Customizing the Properties Panel
  • Customizing the Window Layout
  • Daminion Preferences Dialog
  • How to configure Daminion Server Service
  • How to migrate Daminion Server from one computer (PC1) to a new computer (PC2)
  • Main components of the Daminion workspace
  • Map View with GPS-Coordinates
  • Replication Settings
  • Server Administration Panel
Web Client
  • Activating Web-Access
  • Commenting
  • Custom Tags in the Web client
  • Customizing the Web Client Interface
  • Customizing Thumbnail Captions: Web Client
  • Embedded links
  • Export Settings in Daminion Web Client
  • Export to PDF in Web Client
  • Favorites in Web Client
  • File Path Mapping Rules on macOS
  • Filtering and Searching in Web Client
  • Getting a key for Bing maps
  • Getting Started with Daminion Web Client
  • Import Tag Presets
  • Installing the Daminion Web Client Assistant
  • Login-free Access
  • Maps in the Web client
  • PDF Preview in Web Client
  • Shared collections
  • Tagging in Web Client
  • User Management in Web Client
  • Version Control in the Web Client
  • Video Preview
  • Waiting Room in the Web Client
  • Web Catalog Previews Troubleshooting
Working with Catalogs
  • Creating a new shared Catalog
  • How to import Media Pro catalog into Daminion
  • Understanding Catalogs
Working with Tags
  • Approved/Unapproved Tags
  • Assigning Tag Preset
  • Assigning Tags with the Tags Panel
  • Change Tag appearance mode in the Tags Panel
  • Changing People Names in People Tag
  • Copy Tags from One Item to Another
  • Creating a new Group-Tag with the Tags Panel
  • Creating Custom Tags
  • Creating new Tags with the Tags Panel
  • Creating, assigning and deleting Tags with the Properties Panel
  • Exporting and importing tag lists
  • Filtering Tags in the Tags Panel
  • Lock Tag Editing
  • Recently Assigned Tags
  • Using Assign Tags mode in the Tags Panel
  • Working with Synonyms
Working with Thumbnails
  • Accelerating preview of large images
  • Adding Custom Thumbnails
  • Compare Items
  • Customizing Thumbnail Captions
  • Rotating thumbnails
  • Thumbnail Grouping
  • Types of thumbnails

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 want to import it into Daminion.
For 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:

Many spreadsheet programs allow you to create CSV files. You can even use Windows Notepad to create this type of file – simply change the file extension from .TXT to .CSV.

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 file path of the data.

img-1

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.

Valid Delimiters:

You must use particular delimiters 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 a 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 CSV import in Daminion

On the File menu, click Import and then select CSV File. In the window that opens, select the CSV file you wish to import.

img-2

After you select the CSV file, the Daminion Import Dialog opens.

img-3

A CSV Delimiter:
Enter the delimiter used in the CSV file.

B Key Field:
Enter the row that contains the paths to the files.

C This file contains headers
Specify whether or not your CSV file contains a header row. If it doesn’t, select the appropriate row in Key Field (B).

D Encoding:
Select the correct encoding for your CSV file. If the wrong encoding is selected, it may lead to errors when converting some characters, e.g. umlauts.

E Key contains full file path/ Key contains the relative file path
Select the correct format of the source path information.
You may select either absolute or relative paths. If you select the relative path, you can select the source folder via the file browser.

F GThese areas show the parsing and search results. This allows you to check that you have used the correct settings, before the actual import.

After you click OK, you will need to match up the relevant field names.

img-4

On the left, you will see the field names used in the CSV, and on the right 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 Catalog after you click OK.

Save as PDF
Product
  • Pricing
  • Book a Demo
Resources
  • About Daminion
  • White Paper
  • Blog
  • Tutorials
  • FAQ
  • Documentation
  • Support
  • Whats New
  • Forum
  • Press-Materials
  • ROI calculator
Features
  • Features list
  • Feature Tour
  • Integrations
  • Daminion vs. other solutions
  • Benefits for IT managers
  • Privacy policy
  • Terms of service
Copyright © 2023 Daminion, Corp. All Rights Reserved
Book a Demo
We would love to show you Daminion in action
For more information see our Privacy Policy
Thank you for your interest in Daminion.
A Daminion expert will contact you to set up your demo.
Please fill out the form. Then, we will send the download link via email.
Thank you for choosing Daminion.
We sent you a download link via email.
Thank you for choosing Daminion.
We sent you a download link via email.
To receive the checklist, please provide us with your email address so we can send it to you.
For more information see our Privacy Policy
Thank you for your interest in Daminion.
Don't forget to check your spam folder in case it doesn't show up in your inbox. Thank you for your interest!