![]() |
|
Welcome to DROID |
![]() |
![]() |
![]() |
DROID can export all open profiles (which are not currently running) to a CSV file. To
export a profile, press the Export
button, or select the File / Export
all... menu item. This shows the export dialog. The profiles you have open are listed
in the export window. If a profile is empty, or in the process of running, it is greyed out.
Select all the profiles you want to export into a single CSV file by checking the boxes next to
them. If any of your profiles have active filters, then
the results will also be filtered. Each profile can have different filters defined and enabled.
There are two possible ways of exporting the profiles.
When the "Use export template" checkbox is unchecked, you are presented with an option to select one or more columns that you wish to export, as shown below:
The following table describes the columns which can be exported from DROID.
Column Name | Description | Notes |
---|---|---|
ID | This is a unique number assigned to each file, folder or archival file processed by DROID. | |
PARENT_ID | This is the id of the archival file or folder in which this file is contained. | |
URI | Uniform Resource Identifier: This provides a standard, cross-platform way of describing where resources are located. URIs are described in more detail in "Information collected by DROID | |
FILE_PATH | The file system location of the resource being profiled, if the resource was directly in a file system. Some files are not on the file system - for example, files inside a zip file. In this case, the file paths are written relative to the parent file which exists on the file system. Such paths also include the type of archive as a prefix. | file paths are platform dependent (they are different on Windows and unix). DROID will write out file paths for the system on which it is currently running. This means that if you profile files on a unix machine, then export the profiles on a Windows machine, the file paths will be written out as if they were Windows file paths, and vice versa. |
NAME | The file name of the resource being profiled. | |
METHOD | This field gives the method by which a resource identification has been made. |
Possible values:
|
STATUS | This field gives the identification status of a resource. |
Possible values:
|
SIZE | The size in bytes of a file. | Only files have a size, folders do not have a size. However, some files can contain other files inside them, for example zip files. In this case, the zip file has a size (as it is a file), and so do the files inside it. The size reported in all cases is the uncompressed size of each file, as it would appear if extracted from the container file. |
TYPE | The type of the resource | DROID categorises the files and folders it profiles as being one of three types:
|
EXT | The file extension of the resource | Extension is the last part of a filename following a full stop. Only files have extensions, as they indicate the type of the file. Even if a folder has a full stop in its name, it will not be assigned an extension. |
LAST_MODIFIED | The date and time on which a resource was last modified. | |
EXTENSION_MISMATCH | Whether there is a mismatch between the extension of the resource and its identification by signature |
Possible values:
|
HASH | Hash is a fixed-size string of characters that is generated by running the contents of a file through a mathematical algorithm. DROID supports MD%, SHA1, SHA256 and SHA512 algorithms | If you have enabled hash generation in the preferences, then this column will contain the MD5, SHA1, SHA256 or SHA512 hash for each file and archival file processed. See "Detecting duplicate files" for more information on hashes. |
FORMAT_COUNT | The number of identifications made to the resource. | |
PUID | The PRONOM Unique Identifier of the resource, which identifies the format |
The PRONOM Unique IDentifier (PUID) identifies the precise file format of a profiled
file. When a resource has been identified, it is assigned a PUID. A unique
identifier exists for every file format that DROID can recognise, and these identifiers are
maintained in the PRONOM![]() |
MIME_TYPE | The mime type of the resource where known. |
The mime-type of an identified file format is a high level format identifier assigned by the
Internet Assigned Numbers![]() |
FORMAT_NAME |
The name of an identified file format, as listed in the PRONOM
![]() |
|
FORMAT_VERSION |
The version of an identified file format, as listed in the PRONOM
![]() |
If you have configured any export templates for use with DROID, the "Use export template" checkbox is enabled. Checking this checkbox shows you a view to select one of the configured templates to be used for export as shown below:
An export template is a simple text file, with a .template extension, which defines customisations of columns to be exported. Using a template, you can customise headers for the data columns, add new columns to the export, convert the data in a column to be uppercase / lowercase and change the order in which columns appear in the export. You can make an export template available to Droid by copying it into the ".droid6\export_templates" folder. You can customise the columns listed in the CSV Columns section.
An example template is shown below:
version 1.0
Identifier: $ID
LowerName: LCASE($NAME)
Language: "Simplified English"
Submitter:
The above template indicates:
Following table describes the operations currently supported by DROID for data modifications. These operations can be applied to data columns listed in the CSV Columns table.
Operation | Description |
---|---|
LCASE | Converts the data from specified column to lower case e.g. LCASE($TYPE) |
UCASE | Converts the data from specified column to upper case e.g. UCASE($FORMAT_NAME) |
Once you have selected the columns to export or selected a template that you wish to use, you can also select other options such as whether the values should be enclosed in quotes when exporting. You can also select whether the export should produce one row per file, or one row per format. When exporting one row per file, each row in the CSV file will represent a single file, folder or archival file profiled with DROID. If exporting one row per format, each row in the CSV file will be a single format identificaiton made by DROID. Since a file can be identified as being more than one possible format, this option will produce CSV files with multiple rows for the same file (but with different identifications for it).
The characters of the export will be encoded as UTF-8 by default. If you need to set this to the encoding used on your local machine instead, select 'Platform specific' instead.
When you are happy you want to export your profiles, press the Export profiles... button. This will bring up a standard file-save dialog, in which you can specify where you want your CSV file to be saved.
Welcome to DROID |
![]() |
![]() |
![]() |