View Single Post
Senior Member
Join Date: Mar 2013
Location: Greater London, UK
Posts: 2,368

Old August 6th, 2020, 06:07 AM
Originally Posted by mathematical Pi View Post
I have a question. I'm currently building a excel CSV file that wil randomly generate all kinds of intel for towns/cities. I want to take it a step further and have it also generate one or more item shops or other buildings in these towns.

I know I can use the import tool to load up my towns, but is there a way to have it create "sub-topics" at the same time?

for example if my csv looks like this:
Town name, some town data; Shop name; shop data

Could I get:

Topic: Town name (with the town data in correct snippets)
-- Subtopic Shop name (with the shop data in the correct snippets)
You can create a parent/child structure, but my tool doesn't allow the parents to have any other data associated with them.

At the bottom of the structure section there is a button "add parent". That is where you can choose one of the columns in your data to use as the name of a parent topic.
All rows of your data with the same name in the parent topic column will be made children of that single parent.

Note that you can also create a hierarchy of parents in that same area.

Also note that you need to be careful to choose a category type for the parents that is from the same type (Topics for World Almanac, or Articles for Mechanics Reference) as the category type your are creating all your topics/articles from. My tool has no way to know which category types are for the world almanac and which are for the mechanics reference.

Within my tool I haven't given any ability to add information to the parent topics other than just the name/prefix/suffix for the topic.


As an alternative, I think that the tool allows you to have a single import file contain more than one category of topics, so if you define your town category fields and your shop category fields (both without parents), then you will end up with all the data being imported in one go.

If you were to use the town name of the shop as a prefix, then it would help you sort them for manually dragging once they are in RW (holding shift or ctrl, I don't remember which, while dragging topics within RW will reassign parentage without a popup appearing each time).


Author of the Realm Works Import ( and Output tools (

Last edited by Farling; August 6th, 2020 at 06:14 AM.
Farling is offline   #561 Reply With Quote