To include metadata when importing files from the local filesystem into IV you need to create a CSV file with the following columns (an example file is included at the end of this page):
|Column number||Column Name||Example data||Required?|
|0||Caller Name||none||Only header required|
|1||First Name||none||Only header required|
|4||Segment Start Time||01/01/2001 12:37:00|
|14||Full Name||Don Harry|
|38||Participant User ID||1|
|39||Segment ID||20050204-4024_7549712.wav||Required - see below|
Only data from columns 4,7,14,24,38,39 will be read. Everything else will be ignored.
Notes on column content:
- 0. Not read. The header (first row) must be: “Caller Name”
- 1. Not read. The header (first row) must be: “First Name”
- 4. start time of the call, dd/mm/yyyy hh:MM:ss – You will need to check the date format in a text editor as Excel has a habit of changing the format i.e. dropping the seconds componant. If not filled, the filesystem timestamp for the file will be used.
- 7. “Outgoing” or “Incoming”
- 14. full name of the local party
- 24. telephone number, including area code, or a name
- 38. unique ID of local party
- 39. unique ID for the recording – If this is not matched against a file name then no item will be imported
Columns 0 and 1 the header must be present on the first line. The header is ignored for the rest of the columns. No data is read from Columns 0 and 1.
For the rest of the columns the header is not required.
How the import process links lines in the .csv to recording files
The importer starts at a given path and will hunt through all subfolders for CSV files.
For each CSV file it finds, it will use column 39, the unique ID for the recording, to hunt for files containing that ID in the filename. It will look in the folder containing the CSV and any subfolders, and if it finds exactly one match the item will be processed. The files can be in any format and have any extension.
Example .csv file