Importing transcripts with timecode from json files

Gerard_La Foneria

Hi all,
Some of you working with interviews are probably already using automatic transcription tools outside of Dédalo. We’re aware that version 6 includes an import tool, but it doesn’t support all formats.
Is there any possibility to import transcripts — including timecodes — from JSON files or other formats into Dédalo?
Best,

Alex

Gerard_La Foneria We’re aware that version 6 includes an import tool, but it doesn’t support all formats

Import tool is configured to import from CSV files ONLY, and the import options are described here. Why CSV? because is standard, and easy to use for users, you can use any spreadsheet app to create, edit, modify, etc. easily.

For import time codes you can read the definition here. Basically you can use in the transcription text this format:

[TC_hh:mm:ss.ms_TC]

[TC_00:01:25.627_TC] My transcription text of.....

In the column of the transcription text as rsc36.

BUT

You can use the work API to connect and set the data in JSON format, as explained here, (but we need more detail and explanations in documentation right now) or you can create a tool to get as set data as explained here.

I hope is clear.

Best

Gerard_La Foneria

Hi,

what I made was to transform JSON transcription (including TCs) to TXT, through a Python script.

With the resulting TXT file, I simply copied and pasted the content into rsc36, and the TC format automatically linked the text to the video.

If this solution is helpful for anyone, please feel free to contact me for the script.

@Alex: Is there any dedicated place or recommended way to share scripts like this here in the community?

Alex

Hi Great!

Solutions like that are super nice... 😉

Gerard_La Foneria @Alex: Is there any dedicated place or recommended way to share scripts like this here in the community?

You can add your code here, enclosing it in three apostrophes and adding the language, like :

``` python
my super code
```

Best