Export Adobe Audition markers

[MarthaF]

I've been using (gulp!) Adobe Audition v.3, and have a gazillion important files with markers. I learned that I can't export these from version 3, but I _can_ open them (and the markers are intact) with Adobe Audition CC (current edition). However, I want to use these files WITH markers in Audacity - but I can only export them as .csv files - and Audacity seems to require .txt files for import. I'm using Windows 10.

Suggestions, anyone?

[steve]

There's no direct way to import Adobe markers into Audacity, but if you could post a small example of the exported CSV, we may be able to devise a workaround.
See here for how to attach a file to a forum post: viewtopic.php?f=49&t=64936
I think the forum will allow ".csv", but if not, add ".txt" to the end of the file name.

[MarthaF]

Thanks for the quick reply (and for reading around my stupid typo in the Subject line!).

Below are three files:
1. the file I exported (this file has only a few Labels, others have many more) - but Audition won't let me import a .csv file
2. a screenshot of the.csv file as opened by LibreOffice Calc
3. a screenshot showing the info I need from those markers (made by opening the file in Adobe Audition).

I hope this makes sense!

[kozikowski]

Audacity doesn't use Markers as any video editor transplant discovers. Some Other Way must be found.

What's the Audition Creative Commons rental going for these days? You can't outright buy the license any more, right?

Koz

[MarthaF]

Koz, that's what I feared. My trouble is that I use the program in fits and starts - intensively for awhile, then rarely, then another intensive bout. I suppose I could consider renting it on a monthly basis when I DO need it, and otherwise using Audacity. But damn! That's hours and hours and hours and hours of HARD work, in my case! (What I do is divide field recordings into tracks, with NO space between - because sometimes I want to separate mid-sentence!)

But then - it's just possible that, since I've already divided the files that I've marked and need to divide - and Audacity DOES have some way of marking tracks, doesn't it? I could do the newer ones completely in Audacity.

[MarthaF]

Oops - STEVE - I missed your suggestion to send you the .csv file (which indeed is not allowed) by putting .txt at the end of the name, so here it is. I would love it if a work-around could be devised....

[steve]

I would love it if a work-around could be devised....

What are your spreadsheet skills like?

It appears to be completely possible to convert the CSV into Audacity labels using a spreadsheet (such as LibreOffice Calc, or MS Excel).
Unfortunately my spreadsheet skill are minimal and I would have to Google for every formula.
See these links about Audacity labels:
https://manual.audacityteam.org/man/label_tracks.html
https://manual.audacityteam.org/man/imp ... abels.html

and for reading around my stupid typo in the Subject line!

Fixed that for you

[MarthaF]

Thanks again, Steve - for fixing the stupid typo and for pointing me at the Audacity files that will help me convert these to Audaciity labels. It's not immediately clear to me what the file should look like when I'm done, but I'll play around and probably figure that out. (I could create some labels in an Audacity file, export THAT, and see what it looks like.)

Did I say Persistence is my middle name? Or, as my mother used to say, "DEE-ter-minded" (apparently that's how I read "Determined" as a young child).

[steve]

Some hints that I hope will help:

With a spreadsheet app, the CSV file needs to be imported using "tab" as the separator.
That will split each line into 6 columns.

From your example file, the first data line breaks down as:

1. Name:
   '86-6A(2) Madzhare #0 prelim dems
2. Start time (hh:mm:ss):
   0:00.000
3. Duration (hh:mm:ss):
   3:15.306
4. Time Format:
   decimal
5. Type:
   Track
6. Description:
   Not used

The "Name" field needs to be "quoted".
The "Start Time" needs to be converted to seconds.
You need to create a column for "End Time" (start + duration) in seconds.
and the other fields ignored / hidden.

For the labels, the order needs to be:
Start time -> End time -> Label text
where "->" means a tab space.

so the first data line becomes:

Code: Select all

0.000 195.306 "'86-6A(2) Madzhare #0 prelim dems"

[MarthaF]

Thanks again, Steve. I've spent most of the day "playing" with this - I added tracks to that file, manually: I took the times from a screenshot of the display from Audition (the end time became the same as the starting time for the next track). Then I exported those labelss, and looked at the resulting file in a text editor. I couldn't for the life of me figure out what the numbers meant - it never occurred to me that they'd be the time converted into SECONDS!

It seems that I have to re-upload the exported labels file if I save the file as .wav - right? That's a pain in the neck! But actually, once I've saved the tracks, there isn't much need to see them in the full file (though I have gotten used to being able to browse through the whole file and find just the part I need....)

I'm busy working out the work-around now - I may just have to make sure I've got updated track info for the approximately 300 files I've divided in Audition - and add Labels later if/when they're needed.

Thank you for taking so much time to help me.