Pixel Crushers Forum

Hello,
I am attempting to export dialogue keys & strings to excel and I am finding that the loc keys generated in excel are just called "Conversation/114/Entry/3/Dialogue Text"

So far through my own testing I was able to export the following line which is halfway for what I need:
Conversation/114/Entry/3/John/Dialogue Text

Ideally I would like this to have the speaker and the name of the file in the key:
<DialogueFileName>/114/Entry/3/<Speaker>/Dialogue Text

Any assistance on this is greatly appreciated!

Hi,

The Dialogue System has a lot of export options. What kind of export are you doing? Localization Export/Import? Export Database > CSV? i2 Localization export?

I am using the i2 Localization Export

Sorry for all the questions. I want to get a full understanding of what you're looking for.

What do you mean by "<DialogueFileName>"?

I appreciate you taking the time to narrow down the answer.

I am using <DialogueFileName> as a placeholder for whatever file name I intend on using in the Dialogue Database.

When I export the I2 to Excel I get "Conversation/114/Entry/3/..." ideally I'd like to take the name from the file (see image) and replace "Conversation" with the name of the file shown in the image. In this case it says "NewConversation4"

So the ideal outcome is that I get an entry in the Excel export that reads:
NewConversation4/114/Entry/3/John/Dialogue Text

It has the file name for later reference and the speaker's name (John) so I know who is speaking the dialogue at a glance.

If you use these settings:


The i2 term will be similar to what you're looking for. For example:

Dialogue System/Conversation/New Conversation 4/Entry/003/John/Dialogue Text

It does have "Dialogue System/Conversation" at the front, but is that an issue?

Thanks, I will try with those settings, however what about the other settings in the Actors, Conversations, Dialogue Entries, etc Drop-Downs?

These appear to have options that are related to what I am trying to do.

Also the outcome you showed would be perfect, the Prefix text wont be an issue.

Most people don't generally localize Conversation fields, since they localize the individual Dialogue Entry fields. What would you need for Conversations?

Would you need anything to be different for Actors?

Those drop down settings were my guesses at how to get the actor's name to appear in the loc key export. If they have no bearing on that outcome then can I safely uncheck them? Or are some still needed to properly export the EN dialogue as well?

Yes, you can leave all of the Conversation foldout's checkboxes unticked.

To get the Actor name into the dialogue entries' i2 terms, make sure Extra Entry Info is set to Actor.