Page 1 of 1
How to link Google Excel Sheet
Posted: Fri Sep 16, 2022 1:04 am
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?
Re: How to link Google Excel Sheet
Posted: Fri Sep 16, 2022 9:05 am
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.
Re: How to link Google Excel Sheet
Posted: Sat Sep 17, 2022 11:07 am
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?
Re: How to link Google Excel Sheet
Posted: Sat Sep 17, 2022 11:31 am
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.
Re: How to link Google Excel Sheet
Posted: Sat Sep 17, 2022 12:13 pm
by SBSun
Thank you very much! The answer was so helpful.
Finally, I wonder if this is only possible at runtime
Re: How to link Google Excel Sheet
Posted: Sat Sep 17, 2022 2:49 pm
by Tony Li
Hi,
The DialogueDatabase asset is a regular ScriptableObject asset, so your editor scripts can modify it at design time, too.