• Please note: In an effort to ensure that all of our users feel welcome on our forums, we’ve updated our forum rules. You can review the updated rules here: http://forums.wolflair.com/showthread.php?t=5528.

    If a fellow Community member is not following the forum rules, please report the post by clicking the Report button (the red yield sign on the left) located on every post. This will notify the moderators directly. If you have any questions about these new rules, please contact support@wolflair.com.

    - The Lone Wolf Development Team

Import from Obsidian Portal into RealmWorks

F

Farling

Well-known member
Hi folks,

I've managed to put together something which will take your existing Obsidian Portal information and migrate the data into Realm Works.

The Basic Process

1) Go to Obsidian Portal and download a backup of your campaign.
2) Run my converter.
3) Import the generated .rwexport file into your RW realm.

More Detail

Step 1 - Obsidian Portal
1 - go the web page for your obsidian portal campaign.
2 - select "settings" in the left panel.
3 - select "Advanced" in the page's menu.
4 - select "download backup"

Step 2 - Run my converter
1 - Download the convert.ps1 (a powershells script)
2 - Download the ob2rw-xsl1.xslt file (a XSL version 1.0 specification)
3 - Put these two files in the same folder (I use "Documents\Realm Works\Scripting".
3 - Right click on the convert.ps1 and select "Run with PowerShell"
4 - In the file selector dialog that appears, select the .ZIP file that was downloaded from obsidian portal

Step 3 - import into realm works
1 - open an existing realm
2 - select import and choose the ".rwexport" file which was created using my converter
3 - tidy up the information inside Realm Works (optional)

Extra Information

1 - The conversion process creates 5 new topic categories to handle the imported information (adventure logs, characters, items, wiki pages, forum posts)
2 - Pictures are not exported as part of the Obsidian Portal backup file, so they are not imported into RealmWorks
3 - the current version of the scripts will NOT work to re-import updates later (this is a future evolution).

Access to the files:

Download the ZIP file from https://github.com/farling42/RealmWorksScripting/archive/release_0.1.zip, then unzip the contents.

Known Issues

- Links are not converted, and remain as blue underlined text when RealmWorks automatically unlinks them.
- No images are transferred, and links to images are not transferred yet.
- Importing a subsequent OB backup creates duplicate topics.
 
Last edited:
That is very cool! If I used OP I'd be one happy chica ;) Thanks for sharing your work with the community =D
 
Farling said:
Hi folks,

I've managed to put together something which will take your existing Obsidian Portal information and migrate the data into Realm Works.

The process is:

1) Go to Obsidian Portal and download a backup of your campaign.
2) Run my converter.
3) Import the generated .rwexport file into your RW realm.

----------
More Detail

Step 1 - Obsidian Portal
1 - go the web page for your obsidian portal campaign.
2 - select "settings" in the left panel.
3 - select "Advanced" in the page's menu.
4 - select "download backup"

Step 2 - Run my converter
1 - Download the convert.ps1 (a powershells script)
2 - Download the ob2rw-xsl1.xslt file (a XSL version 1.0 specification)
3 - Put these two files in the same folder (I use "Documents\Realm Works\Scripting".
3 - Right click on the convert.ps1 and select "Run with PowerShell"
4 - select the .ZIP file that was downloaded from obsidian portal

Step 3 - import into realm works
1 - open an existing realm
2 - select import and choose the ".rwexport" file which was created using my converter
3 - tidy up the information inside Realm Works

----------
Extra Information

1 - The conversion process creates 5 new topic categories to handle the imported information (adventure logs, characters, items, wiki pages, forum posts)
2 - Pictures are not exported as part of the Obsidian Portal backup file, so they are not imported into RealmWorks
3 - the current version of the scripts will NOT work to re-import updates later (this is a future evolution).

----------
Access to the files:

https://github.com/farling42/RealmWorksScripting/blob/master/convert.ps1
https://github.com/farling42/RealmWorksScripting/blob/master/ob2rw-xsl1.xslt
Click to expand...

Can we do it both ways? In other works use to export from RW and import into Obsidian?
 
From memory, Obsodian Portal does not support this so no. Once someone moves from Obsidian Portal to RW they will never want to go back! But yeah I understand the benefit this would bring. We could have a work around for player Web access until Web view arrives.
 
Obsidian Portal only allows a backup of the data to be made. There is NO facility to import data back into Obsidian Portal (even from the backup file).
 
daplunk said:
We could have a work around for player Web access until Web view arrives.
Click to expand...
You could take the EightBitz's HTML printing script and modify it to output separate HTML documents for each topic, and so build a web page to emulate your realm, if you really felt that you needed web right now.
 
Last edited:
Farling said:
You could take the EightBitz's HTML printing script and modify it to output separate HTML documents for each topic, and so build a web page to emulate your realm, if you really felt that you needed web right now.
Click to expand...

That's eminently doable, if someone feels compelled.
 
Thanks.

Awesome Job.

Now if Realm Works would just allow me to use Import/Export on D & D 5th edition, I could actually use Realm Works and start working on my campaigns. :(
 
Farling said:
You could take the EightBitz's HTML printing script and modify it to output separate HTML documents for each topic, and so build a web page to emulate your realm, if you really felt that you needed web right now.
Click to expand...

So let it be written; So let it be done.

EDIT: Which means, of course, there's a new version up.
 
So thinking this through.

I want to enter alot of data and need to understand the efficiency gains that can be made with this process.

lets say i have 300 of the same articles to enter. I'm thinking about items currently.

Article Name:
Type:
Group:
Rarity:
Description:
History:
Abilities/Effects:
Curse:

Would it be possible to put all the information into a spreadsheet and then manipulate the spreadsheet to output a text string in an XML format that could then be turned into an import file and loaded into RW?
 
Hmmm, not going to reinvent the wheel on this one. I suspect If I create an excel spreadsheet where I paste the source text and output each item in the following format and then paste the end result into the original XML file and run the script... then the result should be much faster entry of these items...

<item gm_only="false" pc="false">
<id>https://campaignname.obsidianportal.com/items/1001463</id>
<link>https://campaignname.obsidianportal.com/items/glow-dust</link>
<title>Glow Dust</title>
<category>potion/oil/substance</category>
<content gm_only="false" format="textile">Copyright Material Removed</content>
<content gm_only="false" format="html"><p>Copyright Material Removed</p></content>
<content gm_only="false" format="textile"></content>
<content gm_only="false" format="html"></content>
<content gm_only="true" format="textile"></content>
<content gm_only="true" format="html"></content>
</item>
Click to expand...

Wont be able to test this tonight... But theoretically this should work...

https://drive.google.com/file/d/0B_6BXlzLTlj8NEpzeGVDNjU0OFk/view?usp=sharing
 
Don't bother with the empty <content></content> tags, they won't do anything useful if you use my OB conversion stuff.

I did have a look via google for some CSV to XML conversion scripts, and there is web site which can do it, as well as tools which use XSLT v2 which might do it more directly.
 
daplunk said:
Would it be possible to put all the information into a spreadsheet and then manipulate the spreadsheet to output a text string in an XML format that could then be turned into an import file and loaded into RW?
Click to expand...
I'd make a template in Word and use Mail Merge. ::shrug::

When I was Publications and Webmaster for our local gaming convention I did our book and sorted event list menus that way. CSV from database->Excel to fix up the data->Word mail merge->extract plain text containing tagged text for the desktop publishing program or JavaScript for Acrobat, all done automatically via VBA.

If it's short enough you could just make a formula in your spreadsheet program, but that can get out of control pretty quickly. It worked for generating HTML results tables for our Car Wars group's website from my scoring sheets, though.
 
Last edited:
I think the work flow doesn't go directly from Word's mail merge to XML

I think he means he creates a bunch of mail merge documents and then runs a VBA script to extract the plain text from them. From there conversion to XML is easy enough.
 
You must log in or register to reply here.
Back
Top