VO-BB - 20 YEARS OLD!

[Deirdre]

This most excellent method courtesy of Peter Bishop.

Vox Studio requires the following format (from their manual on-line):

Filename for prompt 1 (no extension) (CR/LF)
Short annotation or title for prompt 1 (CR/LF)
Text of prompt 1 on as many lines as needed (CR/LF)(CR/LF)
Filename for prompt 2 (no extension here) (CR/LF)
Short annotation or title for prompt 2 (CR/LF)
Text of prompt 2 on as many lines as needed (CR/LF)(CR/LF) etc.

The double (CR/LF) marks the end of one entry and the start of the next.

You've got a two column xls file - 1. prompt name - 2. text
First problem is that your .xls file is only giving the title and the text, so any conversion will leave you a field short. The first thing to do is to add a filename column in front of the prompt name column to give you three columns in total. If your filename needs to be the same as the prompt name, just copy over the text so both columns are the same.
So you end up with a three column xls file - 1. name 2. name 3. text

If you do a "save as" and select CSV (comma delimited) you should end up with a text file in the format:
name1, name1, text1, (CR/LF)
name2, name2, text2, (CR/LF)
etc.

Open the resulting .csv file in Word. You can then do a search and replace on the "," character and replace it with a CR/LF (enter as "^p" in the replace field), and end up with exactly the right format. Save the result as a straight text file (not a Word doc), and it should be just fine.

The only thing that may mess you up is a "," in the text field which will also be replaced. Just scan through the xls before you do this to see if it's going to be a problem (replace as required). The other caveat is that if the filename needs to be different from the given title. If you need just a sequential numbering scheme for the filename, then that's easily done with an n+1 routine on column 1.
_________________
DBCooperVO.com
IMDB

[Lizden]

Hey all!
Sorry I was so late in responding to this....I was out

Here is a .pdf set of instructions that I have that might also be helpful...with pictures & everything

How to Create a VoxStudio script file from Excel
_________________
Liz de Nesnera O.A.V. ~ Livin' The VO Dream!
English/French Bilingual VO w/ ISDN
HireLiz.com / liz@hireliz.com

[Lizden]

As an FYI...this unwieldy way of setting up scripts in VoxStudio is why I now use Word2WAV to record/split/name my files and just use VoxStudio to convert them.

Word2WAV imports both WORD & .xls scripts easily/on its own without any of the finickiness of Vox Studio's system.

FWIW:
My process is:
Record in Word2WAV
Edit in SoundForge
Convert in VoxStudio.



_________________
Liz de Nesnera O.A.V. ~ Livin' The VO Dream!
English/French Bilingual VO w/ ISDN
HireLiz.com / liz@hireliz.com

[Diane Maggipinto]

I just followed Liz's instructions to convert a large xls file to script format for Vox Studio. Most excellent!

The only correction I have is with #18:
18. Type Begin Script then hit the Return/Enter Key twice

Actually, there should be just one blank line between "Begin Script" and the first filename.

Thanks a ton, Liz!

Cha cha cha.
_________________
sitting at #8, though not as present as I'd like to be. Hello!

www.d3voiceworks.com