Import from Obsidian Portal into RealmWorks

[Zaphod Beebledoc]

Excellent!

So, would a similar type of conversion be able to be done on other files? An Excel or .csv file for example?

[kbs666]

Originally Posted by Zaphod Beebledoc

Excellent!

So, would a similar type of conversion be able to be done on other files? An Excel or .csv file for example?

It should be possible to convert most such structured formats into XML and therefore into RW.

[Farling]

Originally Posted by Zaphod Beebledoc

So, would a similar type of conversion be able to be done on other files? An Excel or .csv file for example?

Yes, if you have the scripting knowledge.

The simplicity of the OB script is that it uses XSLT to convert one XML format to another XML format.

[EightBitz]

Originally Posted by Farling

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.

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

EDIT: Which means, of course, there's a new version up.

[daplunk]

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?

[daplunk]

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">&lt;p&gt;Copyright Material Removed&lt;/p&gt;</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>

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

https://drive.google.com/file/d/0B_6...ew?usp=sharing

[Farling]

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.

[Parody]

Originally Posted by daplunk

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?

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.

[daplunk]

You can Mail Merge into XML?

/XML Noob here

[kbs666]

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.