VO-BB - 19 YEARS OLD! Forum Index VO-BB - 19 YEARS OLD!
Where A.I. is a four-letter word.
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

The Bish Formula for converting XLS files for Vox Studio

 
Post new topic   Reply to topic    VO-BB - 19 YEARS OLD! Forum Index -> Research and Development
View previous topic :: View next topic  
Author Message
Deirdre
Czarina Emeritus


Joined: 10 Nov 2004
Posts: 13016
Location: East Jesus, Maine

PostPosted: Fri Jan 15, 2010 8:18 am    Post subject: The Bish Formula for converting XLS files for Vox Studio Reply with quote

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
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Lizden
A Zillion


Joined: 04 Dec 2006
Posts: 8856
Location: The dark recesses of my mind

PostPosted: Fri Jan 15, 2010 1:20 pm    Post subject: Reply with quote

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

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

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
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Lizden
A Zillion


Joined: 04 Dec 2006
Posts: 8856
Location: The dark recesses of my mind

PostPosted: Fri Jan 15, 2010 3:09 pm    Post subject: Reply with quote

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.


Laugh
_________________
Liz de Nesnera O.A.V. ~ Livin' The VO Dream!
English/French Bilingual VO w/ ISDN
HireLiz.com / liz@hireliz.com
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Diane Maggipinto
Spreading Snark Worldwide


Joined: 03 Mar 2006
Posts: 6679
Location: saul lay seetee youtee

PostPosted: Thu May 20, 2010 12:21 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic    VO-BB - 19 YEARS OLD! Forum Index -> Research and Development All times are GMT - 7 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group