Making an Ultima 6 Dialogue Spreadsheet (~8000 Rows)

Thursday, December 24, 2020 at 01:09 PM

A spreadsheet of Ultima 6 character Tholden's dialogue showing names, keywords, and responses on each row.

My Ultima VI Dialogue Spreadsheet open in the free DB Browser program.

I am trying to re-create Ultima VI in Blender and Unity using Playmaker for scripting and SimpleSQL for getting NPC responses from a SQL database. Above is a picture of the final view of Tholden's responses. I need to do this for all 200 characters.

Incidentally, about 40 women, 120 men, and the rest are gargoyles and such.

I therefore need the entire registry of NPC responses in a spreadsheet format. If I have to manually copy each response into the SQL tables using this page Ultima VI Transcript, then I will. But it would be easier to find an already-made spreadsheet in this format:

NAME | KEYWORD | RESPONSE

If I knew how to generate such a spreadsheet it would save me oodles of time. I'm prepared to do it all if I have to, but if anyone is interested in say, doing a character/town in a spreadsheet software (open office, excel) and sending a link, I can drop it into the SQL table for that town. It's very easy work but tedious... which suggests there has to be some way to automate it, but I don't know how to code (I use Playmaker), so any hints about this process would save time.

A spreadsheet of Ultima 6 character Ariana's dialogue showing names, keywords, and responses on each row.

Ariana's responses in the Ultima VI Dialogue Spreadsheet.

What would be cool is to get 200 people to copy over 1 character's responses from that wiki into a spreadsheet using the format and send it to me, but we would need some way to ensure people don't do the work others already did.

Update: I did it all manually, and I later also started learning to code in C# with help from ChatGPT and Github Copilot. As you can see from this devlog, I can do html and javascript now as well (with great assistance from ChatGPT. - 2024-09-07)

FM Towns Audio?

I am also wondering if anyone knows how to extract the FM Towns audio files. I have the FM Towns version but don't know how to extract them.
Here's another much later devlog about FM Towns.

This has a handy incomplete U6 transcript in .txt format, too.
Alternative Ultima VI Transcript on NotableUltima.

Here's the original fb UDIC post.

You've reached the end of this devlog entry.