Senior Member
Join Date: Jul 2017
Posts: 347
|
I am in preparation for Dark Heresy Second Edition campaign, and the game system has many skills, traits, talents, items and etc. that I would like to have links to from my World Almanac articles. I prepared new custom categories for those and for things like home worlds, backgrounds and roles. Few hours of work to make it suit the format in the book, but in the end it looks awesome.
Unfortunately I don't see an obvious way to put bulk upload the data for those hundred of objects like skills and traits. Doing it by hand requires too much clicking, copy pasting and some actions have no shortcuts for. I type fast, but still it takes too much time for my taste. At work I work with CSV, XML and other file formats that can be used to exchange data (converting to those from Excel, the most enterprise tool ever ), and then upload via SQL scripts or whatever arcane means the system has. Is there a way to make bulk import of data into realm works after the "schema" has been prepared in Realm Works? |
#1 |
Junior Member
Join Date: Jul 2014
Posts: 24
|
Valyar,
Did you have any luck with this? If I'm understanding you correctly I'm trying to do something similar. In one of my realms I've created spells in the Mechanic Reference under Abilities. Now I want to copy those to a new realm. Doing a search in the forum I found this http://forums.wolflair.com/showthread.php?t=58504 but where he says Right-click and go to Assign to Views>Story Almanac, well that option is greyed out for my items in the Mechanic Reference. |
#2 |
Senior Member
Join Date: Jan 2016
Location: Adelaide, Australia
Posts: 2,293
|
Quote:
THIS should help explain is better. Realm Works - Community Links Realm Work and Hero Lab Videos Ream Works Facebook User Group CC3+ Facebook User Group D&D 5e Community Pack - Contributor General Hero Lab Support & Community Resources D&D 5e Community Pack - Install Instructions / D&D 5e Community Pack - Log Fault / D&D 5e Community Pack - Editor Knowledge Base Obsidian Obsidian TTRPG Tutorials |
|
#3 |
Senior Member
Join Date: Jan 2016
Location: Adelaide, Australia
Posts: 2,293
|
Quote:
Realm Works - Community Links Realm Work and Hero Lab Videos Ream Works Facebook User Group CC3+ Facebook User Group D&D 5e Community Pack - Contributor General Hero Lab Support & Community Resources D&D 5e Community Pack - Install Instructions / D&D 5e Community Pack - Log Fault / D&D 5e Community Pack - Editor Knowledge Base Obsidian Obsidian TTRPG Tutorials |
|
#4 |
Senior Member
Join Date: Mar 2013
Location: Greater London, UK
Posts: 2,625
|
Quote:
How you get the data in that format might still be an issue? |
|
#5 |
Senior Member
Join Date: Jul 2017
Posts: 347
|
I will try this tool this weekend if i steal some time. The main issue that I foresee in preparing the CSV will be removal of the end of line marks when copying from PDF
But for things like tables that can easily be edited, it will be golden. I am preparing to bulk import all weapons from Dark Heresy and hopefully this will do the trick. |
#6 |
Senior Member
Join Date: Dec 2013
Posts: 798
|
with editors like edit plus / notepad+ and others you can use regular expressions to replace all kinds of characters inlcuding special characters like new line ecetera.
Join the (unofficial) Realm-Works IRC Chat: #realm-works on the Rizon Network (https://wiki.rizon.net/index.php?title=Servers) -> Browser Client: https://kiwiirc.com/client/irc.rizon.net |
#7 |
Senior Member
Join Date: Jul 2017
Posts: 347
|
I would like to report that the bulk import operation via the mentioned CSV tool was flawless. Fabulous work, i am extremely happy.
Once the .csv was properly prepared with come copy-pase and macro magics in Note++ and Excel, the rest was just few clicks and manual sorting I attached some screenshots on the process, if someone is interested and has suggestion to reduce the "tools" that i use. 01 - Some raw data after copy-paste 02 - excel magics 03 - final csv 04 - mappings 05 - final result (only extra touch was adding the picture) |
#8 |
Senior Member
Join Date: Mar 2013
Location: Greater London, UK
Posts: 2,625
|
|
#9 |
|
|