XML Transformation Script (PowerShell)

[ErinRigh]

i, on the other hand, prefer Word, but html is a nice option

 

[manchuwook]

Word

Word would probably allow for smoother integration into PowerPoint presentations, Excel spreadsheets, and other office apps - I'd think. At the point, you can use the base functionality for dropbox/google drive/box.com/owncloud/etc.

Also, for the folks that want to use spell check and all of that - you can get Grammarly for free and it comes with its own standalone editor. I usually type my stuff into that before pasting it into RW.

 

[Grey Mage]

I can see situations where both would be of value, so put me down for option C.

 

[Parody]

I'd use both at times, though I'd be more likely to convert to text tagged properly for further processing and/or import into my desktop publishing system.

 

[Farling]

i know the orriginal was to convert obsidian portal stuff to realmworks but it seems you have done a lot more work to the program.

Actually that was a different program, EightBitz was primarily dealing with export not import.

The OB import was my work, see http://forums.wolflair.com/showthread.php?t=57474

 

[Acenoid]

Hello EightBlitz!

I have tried out finally the HTML export. Though the help commands did not work for some reason, the GUI was quite easy to use. Thanks for the great work.

I tried to export my realm for testing purposes. I was interested in the mechanics section and did a full "export" (Compact output) and chose a mechanics source file. Changed the policy settings correctly.

I encountered some issues:
1. Script did not finish the convension, due to an unexpected NULL value with a smart image:

Checked the topic in question. It has a smart image tag added which is unedfined, but has a Annotation text. This seems to be the issue. Removing the smart image snippet fixed it.

[ERROR]
Command Line: &(".\RWExport-To-HTML.ps1") -Source 'H:\RWExport\Shadowrun 1.rwoutput' -Destination '.\MyRealm.html' -Sort 2 -SimpleImageScale 0 -SmartImageScale 0 -CSSFileName 'RWExport_091b_1.5.css' -Format 'HTML' -Prefix -Suffix -Details -Indent -SeparateSnippets -Force
Reason: InvalidOperation - Es ist nicht möglich, eine Methode für einen Ausdruck aufzurufen, der den NULL hat.

Location: Line 1215, Character 17
Script Line: $SplitFileName = $FileName.split(".")

Topic: Bruderschafts Sektion
Section: Description
Snippet Type: Smart_Image
[/ERROR]

The same issue appeared in a second attempt with a picture snippet. No picture but annotation text. Removed the snippet to fix the issue.

2. The resulting HTML could be reviewed anyways: German umlaute and special characters don't appear correctly in the browser (äöüß), maybe there should be an option to choose a codepage (or use utf-8) also just a guess atm?

3. I also make extensive use of tables in my realm. The text from tables seems often to be garbled (overwrites itself, however the documentation states that tables are untested / not supported) Example image: http://i.imgur.com/mr4qIlD.png

I suppose that here the line breaks need to be triggered somehow, when an end of a cell has been reached.

4. Exporting to word did not work. Following error message was reported:

H:\RWExport\RWExport-To-HTML.ps1 : Das angeforderte Element ist nicht in der Sammlung vorhanden.
In Zeile:1 Zeichen:1
+ &(".\RWExport-To-HTML.ps1") -Source 'H:\RWExport\Shadowrun1.rwoutput' ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : OperationStopped: ) [RWExport-To-HTML.ps1], COMException
+ FullyQualifiedErrorId : System.Runtime.InteropServices.COMException,RWExport-To-HTML.ps1

It seems to claim that the input file is not present? However it starts when going for a html file:

----

That was all for the first export attempt. Thanks again for the effort and great documentation.

 

[EightBitz]

Hello EightBlitz!

I have tried out finally the HTML export. Though the help commands did not work for some reason, the GUI was quite easy to use. Thanks for the great work.

I tried to export my realm for testing purposes. I was interested in the mechanics section and did a full "export" (Compact output) and chose a mechanics source file. Changed the policy settings correctly.

I encountered some issues:
1. Script did not finish the convension, due to an unexpected NULL value with a smart image:

Checked the topic in question. It has a smart image tag added which is unedfined, but has a Annotation text. This seems to be the issue. Removing the smart image snippet fixed it.

[ERROR]
Command Line: &(".\RWExport-To-HTML.ps1") -Source 'H:\RWExport\Shadowrun 1.rwoutput' -Destination '.\MyRealm.html' -Sort 2 -SimpleImageScale 0 -SmartImageScale 0 -CSSFileName 'RWExport_091b_1.5.css' -Format 'HTML' -Prefix -Suffix -Details -Indent -SeparateSnippets -Force
Reason: InvalidOperation - Es ist nicht möglich, eine Methode für einen Ausdruck aufzurufen, der den NULL hat.

Location: Line 1215, Character 17
Script Line: $SplitFileName = $FileName.split(".")

Topic: Bruderschafts Sektion
Section: Description
Snippet Type: Smart_Image
[/ERROR]

The same issue appeared in a second attempt with a picture snippet. No picture but annotation text. Removed the snippet to fix the issue.

2. The resulting HTML could be reviewed anyways: German umlaute and special characters don't appear correctly in the browser (äöüß), maybe there should be an option to choose a codepage (or use utf-8) also just a guess atm?

3. I also make extensive use of tables in my realm. The text from tables seems often to be garbled (overwrites itself, however the documentation states that tables are untested / not supported) Example image: http://i.imgur.com/mr4qIlD.png

I suppose that here the line breaks need to be triggered somehow, when an end of a cell has been reached.

4. Exporting to word did not work. Following error message was reported:

H:\RWExport\RWExport-To-HTML.ps1 : Das angeforderte Element ist nicht in der Sammlung vorhanden.
In Zeile:1 Zeichen:1
+ &(".\RWExport-To-HTML.ps1") -Source 'H:\RWExport\Shadowrun1.rwoutput' ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : OperationStopped: ) [RWExport-To-HTML.ps1], COMException
+ FullyQualifiedErrorId : System.Runtime.InteropServices.COMException,RWExport-To-HTML.ps1

It seems to claim that the input file is not present? However it starts when going for a html file:

----

That was all for the first export attempt. Thanks again for the effort and great documentation.

Oof. That's, ummm ... a lot to take in.

1. The issue with the smart images and pictures is a known issue, and thank you for reminding me. That should be easy to fix.

2. I must admit, I wasn't considering other languages when I wrote this script, nor am I well versed in them. This is something I will have to look into.

3. I have not seen that kind of output with tables, so I'm at a loss. In a simple sense, I have tested tables rather extensively. What I have not tested is all the different types of formatting people can and do apply to tables. Font colors, background colors, italics, things like that.

4. Whuh? I don't even ... I mean, I know what you're saying about not being able to find the input file, but as you say, if it can find it for html, it should be able to find it for Word.

At the very minimum here, I have to ask if you would be willing to share your export via dropbox, GoogleDrive, OneDrive, or some other similar service.

In a situation like this, I would also normally ask if you would be willing to share a remote session via skype or join.me or something, but you obviously have your language settings set for German, and I'm not sure how well I would be able to follow along or even navigate myself (under your watchful eye, of course).

But if we could at least start with you sharing your export, I'll see what I can do with that.

Just to tell you the same thing I'm telling others, my free time isn't what it used to be. I'm having to be more aggressive on job hunting, and I do actually have a phone interview on Monday (wish me luck), which if that goes well, they'll invite me for an on-site interview, and if that goes well, I will again be gainfully employed. (Here's hoping).

If that falls through, I have a couple of other possibilities in play. But nothing is guaranteed with any of these, so I have to keep hunting.

EDIT: I'm searching for systems admin role in the Chicago/NWI area. If anyone is willing to help me network, please send me a private message.

 

[Acenoid]

Oh didn't know that you are seeking a position Don't forget to check with LWD maybe they need some dedicated persons Nowadays many of us need always to be watchful regarding jobs... things are certainly not getting better. Anyways all the best with your interview.

If you have time, we can share a remote session or I can upload an export, no problem. I can also check if I can make a recording of how to reproduce the error. I will set something up and write you a PM.

Tables:
I did not really make anything special with it. At first I used the LWD tables, later on I copied tables from word. Most of them are "simple" no shared cells ecetera. My wild guess is some kind of formatting option that (should) trigger "line breaks"

Word Export:
Well, maybe its not the input file missing no idea honestly. It says that that the requested element is not existing in the the collection. Maybe also an issue just with a "german" office? Does the version matter?

 

[EightBitz]

Hey, guys. I haven't dropped off the face of the earth. I've just been busy. I know I promised some updates for some reported bugs. I haven't forgotten. I started getting an unusually (but very welcomed) high number of phone calls from recruiters and potential employers, and even had a face to face interview. (yay!)

The interview was mixed. They liked the experience I had, but had concerns about certain gaps that were very relevant to their business.

I was supposed to have heard back by now, one way or the other, but I haven't, which means I have to follow up with them on Monday. They stated very firmly that they always follow up, whatever the decision, so maybe it's a good thing I haven't heard back yet. That might mean I'm still in the running. Right? Right?!?!? (Just nod your heads and agree with me.)

I've had a couple of other people who have taken a more-than-trivial interest in my resume. So here's hoping.

In addition to all of that, it's tax season, and my taxes were ... complicated, and I had to go through several thousand emails for some missing documents. (Yeesh!) The good news is that I'm getting a nice refund.

I've also been taking care of my dear, old, elderly mum, and that's kept me busy, too.

So, anyway, yeah. Those updates are still coming.

 

[Bidmaron]

Good luck on job search, Eight!

 

[Acenoid]

All the best, trust me I can imagine in what situation youre in.
I'll send you a pm anyway,once you have time again just let me know

 

[KaribouOfDoom]

First, make sure you have the current version, which is 1.5.

Second, if you're selecting Word as the output format, change your destination file to have a .doc or .docx extension.

Other than that, I'm not sure. Is anyone else besides ArgoForg having these issues?

Hi. First post here, so please excuse any general lack of understanding that I might have. I've read this thread and documentation thoroughly and I'm having the same issue as ArgoForg. Did you decide that this issue is the known bug of having a blacked-out-but-revealed smart snippet? My world is still very small, so I went in and "un-revealed" any snippet that might have qualified as a trigger for the bug, and I'm getting the same error. I'd really love for this to work.

Help?

 

[KaribouOfDoom]

Found the problem. For anyone getting this issue with the "= operator missing" (as reported in ArgoForg's post, the solution is to make sure you're running version 4.5 of the .Net framework and then download and install version 5.0 of Windows Management Framework. This will update PowerShell and the error will go away.

 

[EightBitz]

Finally updated, folks. I know a couple of you have been waiting patiently for these fixes. I apologize for the long delay, and I appreciate your patience.

See the top post or read the release notes.

 

[EightBitz]

Found the problem. For anyone getting this issue with the "= operator missing" (as reported in ArgoForg's post, the solution is to make sure you're running version 4.5 of the .Net framework and then download and install version 5.0 of Windows Management Framework. This will update PowerShell and the error will go away.

Thank you for finding this solution.

 

[tmilktoast]

Eightbitz,

There is a minor(ish) issue you may want to know about. The script errors out when confronted by an empty Labeled Text snippet. I have quite a few of those which I intend to fill in, of course, but right now they are sort of empty placeholders.

Ultimately, all that data will be filled in when I export this for real and the script will work properly, so it's not a big deal. I just thought you might want to know.

Here is the error code:

[ERROR]
     Command Line: &(".\RWExport-To-HTML.ps1") -Source 'D:\Owncloud\RPG\Utilities\RWExport\SWSkills 0.2.rwoutput' -Destination 'D:\Owncloud\RPG\Utilities\RWExport\skill02.html' -Sort 4 -SimpleImageScale 0 -SmartImageScale 0 -CSSFileName 'RWExport_091b_1.6.css' -Format 'HTML' -Prefix -Suffix -Details -Indent -KeepStyles -Force
         Reason: InvalidOperation - You cannot call a method on a null-valued expression.

       Location: Line 741, Character 17
    Script Line: $InsertPoint = $Text.IndexOf($TagPreface) + $TagPreface.Length

          Topic: Brawl
        Section: Overview
   Snippet Type: Labeled_Text
[/ERROR]

 

[Rabit]

First, EightBitz, thank you SO much for creating this!

Question: Has anyone been able to get the ExtractFiles function to work? Is there a trick to it that I'm missing? I've tried everything I can think of, but it doesn't work. It just fails (no error or anything), and subsequent attempts (until I reboot) give me an error (see attached).

Any assistance is greatly appreciated!

If it helps/matters, here's what I'm using (and yes, that folder is empty except for the CSS and the "realm_files" subfolder):
-Source 'C:\Users\russ\Documents\GAMING\Saltmarsh Campaign\_RW Info\saltmarsh_rw.rwoutput' -Destination 'C:\Users\russ\Documents\GAMING\Saltmarsh Campaign\_RW Info\saltmarsh_rw' -Sort 4 -SimpleImageScale 0 -SmartImageScale 0 -CSSFileName 'RWExport_091b_1.6.css' -Format 'HTML' -Prefix -Suffix -Indent -KeepStyles -ExtractFiles -Force

I've also tried "... -Destination 'C:\Users\russ\Documents\GAMING\Saltmarsh Campaign\_RW Info\saltmarsh_rw\'..." but that hasn't worked, either.

 

[EightBitz]

First, EightBitz, thank you SO much for creating this!

Question: Has anyone been able to get the ExtractFiles function to work? Is there a trick to it that I'm missing? I've tried everything I can think of, but it doesn't work. It just fails (no error or anything), and subsequent attempts (until I reboot) give me an error (see attached).

Any assistance is greatly appreciated!

If it helps/matters, here's what I'm using (and yes, that folder is empty except for the CSS and the "realm_files" subfolder):
-Source 'C:\Users\russ\Documents\GAMING\Saltmarsh Campaign\_RW Info\saltmarsh_rw.rwoutput' -Destination 'C:\Users\russ\Documents\GAMING\Saltmarsh Campaign\_RW Info\saltmarsh_rw' -Sort 4 -SimpleImageScale 0 -SmartImageScale 0 -CSSFileName 'RWExport_091b_1.6.css' -Format 'HTML' -Prefix -Suffix -Indent -KeepStyles -ExtractFiles -Force

I've also tried "... -Destination 'C:\Users\russ\Documents\GAMING\Saltmarsh Campaign\_RW Info\saltmarsh_rw\'..." but that hasn't worked, either.

Take off the -Force option, and add a -Log option. So, something like this:

-Source 'C:\Users\russ\Documents\GAMING\Saltmarsh Campaign\_RW Info\saltmarsh_rw.rwoutput' -Destination 'C:\Users\russ\Documents\GAMING\Saltmarsh Campaign\_RW Info\saltmarsh_rw' -Sort 4 -SimpleImageScale 0 -SmartImageScale 0 -CSSFileName 'RWExport_091b_1.6.css' -Format 'HTML' -Prefix -Suffix -Indent -KeepStyles -ExtractFiles -Log 'c:\users\russ\saltmarsh_export.log'

 

[EightBitz]

First, EightBitz, thank you SO much for creating this!

Question: Has anyone been able to get the ExtractFiles function to work? Is there a trick to it that I'm missing? I've tried everything I can think of, but it doesn't work. It just fails (no error or anything), and subsequent attempts (until I reboot) give me an error (see attached).

Any assistance is greatly appreciated!

If it helps/matters, here's what I'm using (and yes, that folder is empty except for the CSS and the "realm_files" subfolder):
-Source 'C:\Users\russ\Documents\GAMING\Saltmarsh Campaign\_RW Info\saltmarsh_rw.rwoutput' -Destination 'C:\Users\russ\Documents\GAMING\Saltmarsh Campaign\_RW Info\saltmarsh_rw' -Sort 4 -SimpleImageScale 0 -SmartImageScale 0 -CSSFileName 'RWExport_091b_1.6.css' -Format 'HTML' -Prefix -Suffix -Indent -KeepStyles -ExtractFiles -Force

I've also tried "... -Destination 'C:\Users\russ\Documents\GAMING\Saltmarsh Campaign\_RW Info\saltmarsh_rw\'..." but that hasn't worked, either.

OK, no word back from Rabit. Is anyone else having this issue?

 

[Acenoid]

The other issues prevent me from proceeding a bit. Still not certain were the problem lies Any news rgd. job?