Difference between revisions of "Preparing a dialog for recording"

Latest revision as of 18:40, 24 October 2010

(this article is based on the investigations of Kaldir II and KingEtzel)

For specific information about voiceover, file conventions, integration see here: Voice-Over

Introduction

When you successfully have created dialogs in your toolset, you may want to send it out to voiceactors for recording at a certain point.

You could do that by writing all dialogs in a textprocessor like MS Word and just send them those documents. However, you would have to copy and paste the whole tree of lines into the toolset one by one, in order to get even the text work ingame. On the other hand you could type your whole dialog stuff in the toolset, but then - lacking a native export function - you would have to copy and paste again to get it into a form, where voiceactors can read your dialog.

Below we describe a way of creating the dialog inside of the toolset and then, by using little SQL queries, export not only the lines but also their corresponding LineIDs so that the voiceactor can not only match the format convention, but also the naming convention for the files themselves. The only thing for you left to do is putting those recorded files into the right folder and everything should work. No need for you to rename thousands of files manually to put them into the module/game!

Creating the Dialog Script

First of all, you need Microsoft SQL Server Management Studio Express to be installed: http://www.microsoft.com/downloads/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

Install and run it. The first time it starts, it should find your Dragon Age database (BWDATOOLSET). Just click OK.

Remember to start the tool with administrator privileges, if necessary. Otherwise you won't be granted permission to access the database.

Click on "New query" at the upper Left. Enter the text below into the right pane. Find the String ID from any line of your conversation inside the toolset, and substitute it where the #### is:

  SELECT [StringID],[ModuleResRefVersionID]
    FROM [bw_dragonage_content].[dbo].[t_StringText]
    WHERE StringID = ####

Click the "! Execute" button. This will find the ID number of your dialogue, shown in the bottom pane under the query panel.

Copy the text below, select the entire text of your first query, and paste over it. (Or if you prefer, you can press the "New Query" button again.) Right click on the dialogue ID number in the result pane and copy/paste -- or just type it in where the #### is in this query:

  Declare @ResID INT
  Set @ResID = #####
  SELECT A1.StringID, A2.SPEAKER, A1.Text
     FROM bw_dragonage_content.dbo.t_StringText A1, bw_dragonage_content.dbo.t_ConversationLine A2
     WHERE A1.StringID = A2.TextStringID AND A1.ModuleResRefVersionID = @ResID AND A2.ModuleResRefVersionID = @ResID

Press the "! Execute" button again. This will give you a list consisting of the LineIDs in the column 1, the speaker tag (blank is the OWNER) in column 2, and the spoken words in column 3. You can now mark everything and save it into CSV and reopen it with Excel. Or you can select all the lines up to the PLAYER lines and paste to your editing program of choice, etc.

Now you can send the script to your voiceactors and you have minimized unneccessary work!