CSV metadata
If you chose the CSV metadata format, one CSV file, referencing several audio files, can be uploaded.
For historic reasons, it is expected that:
- First line of the CSV must be header,
- First cell of header must be named
Nom
ornom
,- Values in the
nom
cell must reference an audio filename without file extension, see example below, - These cells can not be empty, a value is mandatory,
- Values in the
- Fifth row is expected to be the caller phone number,
- These cells can be empty,
- Eight row must be the audio date and time,
- Valid date and time format are either UTC,
2019-06-09T11:14:56Z
or localized on your configuration's timezone,2019-06-09T13:14:56+02:00
, - These cells can not be empty, a value is mandatory.
- Valid date and time format are either UTC,
Examples
First example
Considering the following CSV metadata:
Nom,Session SVI,Application,NAS,Numero,Cause,Note,Date,Longueur,Competence,SDA de l'agent,Nom agent,Id agent,Dossier
a_first_audio,foobar,foobar,foobar,+33102030405,foobar,foobar,2019-07-01T12:34:56Z,foobar,foobar,foobar,foobar,foobar,foobar
a_second_audio,foobar,foobar,foobar,+33102030406,foobar,foobar,2019-07-01T12:35:56Z,foobar,foobar,foobar,foobar,foobar,foobar
a_third_audio,foobar,foobar,foobar,+33102030407,foobar,foobar,2019-07-01T12:36:56Z,foobar,foobar,foobar,foobar,foobar,foobar
It is therefore expected to upload, aside from this metadata file, three audio files
named a_first_audio.EXT
, a_second_audio.EXT
and a_third_audio.EXT
.
Second example
The minimum viable CSV would look something like:
Nom,foo,bar,foobar,Numero,barfoo,foofoo,Date
a_first_audio,,,,,,,2019-07-01T12:34:56Z
a_second_audio,,,,+33102030405,,,2019-07-01T12:34:56Z
- The first line does not have a phone number (it might be unknown)
- the second line has one
Table of content