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 or nom,
    • 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,
  • 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.

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