Word Macros for manipulating transcripts created in Transana
Transana users have requested tools for manipulating Transana transcripts. While I have not yet had the time or resources to incorporate these into Transana, there is a set of macros for Microsoft Word that accomplish several useful tasks. You can get these macros by downloading the file Macros.txt and copying them into the Macro utility within Word.
To use the macros, the first step is to export your Transana transcript to a Rich Text Format document. To do that, load the transcript in Transana and choose File > Save Transcript As. This will export your Transana transcript to a Rich Text Format document you can load into Word and many other word processors.
The first part of your transcript might look like this:
¤<0>T: This is the core they started with, and they want it to look like that. I'm going to first flip it up. Watch what happens. Okay? Now I'm going to go back to where we started, and now I'm going to flip it down. Hmmm. What happens each time?
¤<19425>S: It's the same.
¤<20511>S: It's the, it goes to the same ¤<22485>[thing.]
Now, within Word, select Tools > Macro > Macros. If you have loaded the Macros.txt file correctly into Word, you should see several options. To run a macro, select it from the list and press the Run button.
ConvertTimeCodes_Milliseconds_hidedata
This macro will locate Transana time code data (eg. ¤<19425>) and will convert it to a human readable format accurate to the one-thousandth of the second, and will hide (but not remove) the Transana time code data. It is important to retain the time code data if you might want to re-import this transcript back into Transana at some later date, but people often don't want the time code data to appear in their document.
( 00:00:00 :000) T: This is the core they started with, and they want it to look like that. I'm going to first flip it up. Watch what happens. Okay? Now I'm going to go back to where we started, and now I'm going to flip it down. Hmmm. What happens each time?
(00:00:19:425) S: It's the same.
(00:00:20:511) S: It's the, it goes to the same (00:00:22:485) [thing.]
ConvertTimeCodes_Milliseconds_showdata
This macro will locate Transana time code data (eg. ¤<19425>) and will convert it to a human readable format accurate to the one-thousandth of the second. It will not hide the Transana time code data.
¤<0>( 00:00:00 :000) T: This is the core they started with, and they want it to look like that. I'm going to first flip it up. Watch what happens. Okay? Now I'm going to go back to where we started, and now I'm going to flip it down. Hmmm. What happens each time?
¤<19425>(00:00:19:425) S: It's the same.
¤<20511>(00:00:20:511) S: It's the, it goes to the same ¤<22485>(00:00:22:485) [thing.]
ConvertTimeCodes_seconds_hidedata
This macro will locate Transana time code data (eg. ¤<19425>) and will convert it to a human readable format accurate to the second, and will hide (but not remove) the Transana time code data. It is important to retain the time code data if you might want to re-import this transcript back into Transana at some later date, but people often don't want the time code data to appear in their document.
( 00:00:00 ) T: This is the core they started with, and they want it to look like that. I'm going to first flip it up. Watch what happens. Okay? Now I'm going to go back to where we started, and now I'm going to flip it down. Hmmm. What happens each time?
( 00:00:19 ) S: It's the same.
( 00:00:20 ) S: It's the, it goes to the same ( 00:00:22 ) [thing.]
ConvertTimeCodes_seconds_showdata
This macro will locate Transana time code data (eg. ¤<19425>) and will convert it to a human readable format accurate to the second. It will not hide the Transana time code data.
¤<0>( 00:00:00 ) T: This is the core they started with, and they want it to look like that. I'm going to first flip it up. Watch what happens. Okay? Now I'm going to go back to where we started, and now I'm going to flip it down. Hmmm. What happens each time?
¤<19425>( 00:00:19 ) S: It's the same.
¤<20511>( 00:00:20 ) S: It's the, it goes to the same ¤<22485>( 00:00:22 ) [thing.]
HideTimeCodes
This macro will hide all time code data from a transcript generated in Transana. The time code data is still in the document. It's just not visible in Word.
T: This is the core they started with, and they want it to look like that. I'm going to first flip it up. Watch what happens. Okay? Now I'm going to go back to where we started, and now I'm going to flip it down. Hmmm. What happens each time?
S: It's the same.
S: It's the, it goes to the same [thing.]
StripTimeCodeData
This macro will remove all time code data from a transcript generated in Transana. Please note that if you run this macro, then re-import your transcript into Transana, all time codes will be lost.
T: This is the core they started with, and they want it to look like that. I'm going to first flip it up. Watch what happens. Okay? Now I'm going to go back to where we started, and now I'm going to flip it down. Hmmm. What happens each time?
S: It's the same.
S: It's the, it goes to the same [thing.]
AutoTimeCode
In the article Analyzing Orphaned Transcript in Transana, Nicolas Sheon describes two methods for bringing text documents that lack underlying media file into Transana. One of these methods calls for creating a blank audio file and "auto-timecoding" the document to make its text usable in Transana.
This macro was created at Dr. Sheon's request to assist in that process. It inserts a time code between each word in a document, with an interval of 450 ms. between words. (You can easily change this interval by editing a single value in the Macro.)
¤<0> T:¤<450> This¤<900> is¤<1350> the¤<1800> core¤<2250> they¤<2700> started¤<3150> with,¤<3600> and¤<4050> they¤<4500> want¤<4950> it¤<5400> to¤<5850> look¤<6300> like¤<6750> that.¤<7200> I'm¤<7650> going¤<8100> to¤<8550> first¤<9000> flip¤<9450> it¤<9900> up.¤<10350> Watch¤<10800> what¤<11250> happens.¤<11700> Okay?¤<12150> Now¤<12600> I'm¤<13050> going¤<13500> to¤<13950> go¤<14400> back¤<14850> to¤<15300> where¤<15750> we¤<16200> started,¤<16650> and¤<17100> now¤<17550> I'm¤<18000> going¤<18450> to¤<18900> flip¤<19350> it¤<19800> down.¤<20250> Hmmm.¤<20700> What¤<21150> happens¤<21600> each¤<22050> time?¤<22500>
S:¤<22950> It's¤<23400> the¤<23850> same.
S:¤<24300> It's¤<24750> the,¤<25200> it¤<25650> goes¤<26100> to¤<26550> the¤<27000> same¤<27450> [thing.]
This macro is not recommended as a substitute for manually creating time codes in transcripts for which you have an underlying media file. It is simply not accurate enough to be useful.
|