Senior Member
Join Date: May 2013
Location: Birmingham, UK
Posts: 459
|
Excellent!
So, would a similar type of conversion be able to be done on other files? An Excel or .csv file for example? Sleet was enjoying a tasty beverage at his local tavern, when a Tarrasque showed up in the local area. He managed to valiantly get on it's back and ride it. How he did it is a mystery to this day... RW: Engine Heart, I Love The Corps! Home Brew: Star Gate: Avalon, Monda Minutia. I'm good with: OpenOffice, Paint, Lego Digital Designer. & not so good with: Realm Works, Hero Lab, CC3+, GIMP, Cityographer, Hexographer, Fractal Mapper, AstroSynth, Inspiration Pad Pro. RW Kickstarter Supporter. |
#11 |
Senior Member
Join Date: Oct 2014
Location: Chicago, IL
Posts: 1,690
|
It should be possible to convert most such structured formats into XML and therefore into RW.
my Realm Works videos https://www.youtube.com/channel/UCZU...4DwXXkvmBXQ9Yw |
#12 |
Senior Member
Join Date: Mar 2013
Location: Greater London, UK
Posts: 2,623
|
|
#13 |
Senior Member
Join Date: May 2013
Posts: 1,458
|
Quote:
EDIT: Which means, of course, there's a new version up. |
|
#14 |
Senior Member
Join Date: Jan 2016
Location: Adelaide, Australia
Posts: 2,294
|
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? 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 |
#15 |
Senior Member
Join Date: Jan 2016
Location: Adelaide, Australia
Posts: 2,294
|
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...
Quote:
https://drive.google.com/file/d/0B_6...ew?usp=sharing 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 |
|
#16 |
Senior Member
Join Date: Mar 2013
Location: Greater London, UK
Posts: 2,623
|
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. |
#17 |
Senior Member
Join Date: Jan 2013
Location: Rochester, MN
Posts: 1,517
|
Quote:
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 by Parody; January 30th, 2017 at 05:29 PM. |
|
#18 |
Senior Member
Join Date: Jan 2016
Location: Adelaide, Australia
Posts: 2,294
|
You can Mail Merge into XML?
/XML Noob here 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 |
#19 |
Senior Member
Join Date: Oct 2014
Location: Chicago, IL
Posts: 1,690
|
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. my Realm Works videos https://www.youtube.com/channel/UCZU...4DwXXkvmBXQ9Yw |
#20 |
|
|