How to link Google Excel Sheet

Announcements, support questions, and discussion for the Dialogue System.
Post Reply
SBSun
Posts: 46
Joined: Thu Sep 08, 2022 6:39 pm

How to link Google Excel Sheet

Post by SBSun »

As in the picture, String Data is written in Key, Value format.

In Dialogue Database -> Conversations , is it possible to generate the sheet data by importing the sheet data as a script rather than manually typing the dialogue text of each node?

And I want to disable the Fade In/Out function of the UI, so I modified the Show and Hide Animation of the Custom UI Prefab, but the Hide performs the Fade Out function unchanged. Do you know why?
Attachments
2.PNG
2.PNG (70.5 KiB) Viewed 402 times
1.PNG
1.PNG (26.18 KiB) Viewed 404 times
User avatar
Tony Li
Posts: 21972
Joined: Thu Jul 18, 2013 1:27 pm

Re: How to link Google Excel Sheet

Post by Tony Li »

The Dialogue System provides many different import/export options to choose from. Excel is not a good format for writing dialogue. However, if you want to use Excel for some linear conversations, the Dialogue System does support it. See Excel Import in the Import/Export documentation.

To remove the UI's fade in/out animation:

1. Inspect the dialogue UI's Dialogue Panel. Remove the Animator component. Clear the UI Panel component's Show Animation Trigger and Hide Animation Trigger fields.

2. Inspect the dialogue UI's subtitle panel(s) and menu panel(s). Remove the Animator component. Clear the Standard UI Subtitle/Menu Panel component's Show Animation Trigger and Hide Animation Trigger fields.
SBSun
Posts: 46
Joined: Thu Sep 08, 2022 6:39 pm

Re: How to link Google Excel Sheet

Post by SBSun »

Thank you for answer!

I've found that importing an Excel file is only effective for linear conversations.

So, is there any way to configure Dialogue Database with script?

I am currently working with an Excel file like the picture above, and I want to import the data and apply it to Actor and Dialogue Test.

Is there a way to create a Dialog Entry with a Script?
User avatar
Tony Li
Posts: 21972
Joined: Thu Jul 18, 2013 1:27 pm

Re: How to link Google Excel Sheet

Post by Tony Li »

Yes. You can use this process at design time or runtime to create conversations in C#.

Or, if you put your data in Chat Mapper XML or articy:draft XML format (e.g., using Chat Mapper or articy:draft applications) or some other formats, you can use the runtime or design time import code.
SBSun
Posts: 46
Joined: Thu Sep 08, 2022 6:39 pm

Re: How to link Google Excel Sheet

Post by SBSun »

Thank you very much! The answer was so helpful.

Finally, I wonder if this is only possible at runtime
User avatar
Tony Li
Posts: 21972
Joined: Thu Jul 18, 2013 1:27 pm

Re: How to link Google Excel Sheet

Post by Tony Li »

Hi,

The DialogueDatabase asset is a regular ScriptableObject asset, so your editor scripts can modify it at design time, too.
Post Reply