Lone Wolf Development Forums  

Go Back   Lone Wolf Development Forums > Realm Works Forums > Realm Works Discussion

Notices

Reply
 
Thread Tools Display Modes
Valyar
Senior Member
 
Join Date: Jul 2017
Posts: 347

Old July 23rd, 2017, 10:09 PM
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?
Valyar is offline   #1 Reply With Quote
Davout_1806
Junior Member
 
Join Date: Jul 2014
Posts: 24

Old July 24th, 2017, 04:30 PM
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.
Davout_1806 is offline   #2 Reply With Quote
daplunk
Senior Member
 
Join Date: Jan 2016
Location: Adelaide, Australia
Posts: 2,294

Old July 24th, 2017, 05:09 PM
Quote:
Originally Posted by Davout_1806 View Post
Valyar,
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.
Mechanics cannot be assigned to the Story Almanac just like World Almanac content cannot be assigned to the Mechanics Reference. You need to create a new view for the Mechanics section and assign it to that view.

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
daplunk is offline   #3 Reply With Quote
daplunk
Senior Member
 
Join Date: Jan 2016
Location: Adelaide, Australia
Posts: 2,294

Old July 24th, 2017, 05:11 PM
Quote:
Originally Posted by Valyar View Post
Is there a way to make bulk import of data into realm works after the "schema" has been prepared in Realm Works?
The only way currently was provided by the community (Farling). You want to read THIS.

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
daplunk is offline   #4 Reply With Quote
Farling
Senior Member
 
Join Date: Mar 2013
Location: Greater London, UK
Posts: 2,623

Old July 24th, 2017, 11:04 PM
Quote:
Originally Posted by daplunk View Post
The only way currently was provided by the community (Farling). You want to read THIS.
It is a nice simple tool if you have the data available in CSV format.

How you get the data in that format might still be an issue?
Farling is offline   #5 Reply With Quote
Valyar
Senior Member
 
Join Date: Jul 2017
Posts: 347

Old July 31st, 2017, 09:53 PM
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.
Valyar is offline   #6 Reply With Quote
Acenoid
Senior Member
 
Join Date: Dec 2013
Posts: 798

Old August 1st, 2017, 10:38 AM
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
Acenoid is offline   #7 Reply With Quote
Valyar
Senior Member
 
Join Date: Jul 2017
Posts: 347

Old August 4th, 2017, 10:19 AM
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)
Attached Images
File Type: jpg 01.jpg (316.6 KB, 33 views)
File Type: jpg 02.jpg (377.5 KB, 26 views)
File Type: jpg 03.jpg (355.6 KB, 22 views)
File Type: jpg 04.jpg (290.3 KB, 24 views)
File Type: jpg 05.jpg (267.6 KB, 25 views)
Valyar is offline   #8 Reply With Quote
Farling
Senior Member
 
Join Date: Mar 2013
Location: Greater London, UK
Posts: 2,623

Old August 4th, 2017, 01:34 PM
Quote:
Originally Posted by Valyar View Post
I would like to report that the bulk import operation via the mentioned CSV tool was flawless. Fabulous work, i am extremely happy.
I'm glad you like it :-)
Farling is offline   #9 Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -8. The time now is 07:38 AM.


Powered by vBulletin® - Copyright ©2000 - 2024, vBulletin Solutions, Inc.
wolflair.com copyright ©1998-2016 Lone Wolf Development, Inc. View our Privacy Policy here.