Converting fixed length data into XML through XSLT

Replies to This Discussion

Permalink Reply by CM on February 8, 2010 at 2:57pm

Hi Ray,

Are you saying that you changed the EnableDocumentFunction property to True and applied the change in the Transform Step and it still made that error?

• ▶ Reply

Permalink Reply by Raymond Frankulin on February 8, 2010 at 4:34pm

Where do change this property?

• ▶ Reply

Permalink Reply by CM on February 8, 2010 at 5:50pm

It's in the property grid on the lower right of the designer when you put the focus on the Transform Step. There should be 2 properties there, one for the document function and one for script.

• ▶ Reply

Permalink Reply by Raymond Frankulin on February 9, 2010 at 8:49am

I want to add the XSL under the Data/Transformation area and not the Pipeline designer.

• ▶ Reply

Permalink Reply by CM on February 9, 2010 at 9:22am

That area is basically an inert storage area. What happens when you use an XSLT or an Schema from that area is it is copied into the pipeline (via the import menu in either the Transform or Validate Step).

So, you can use it for storage, import from there and do minimal testing but if you want full featured testing and actually run the transform like it would be done at runtime you need to import it and run it through the pipeline designer.

• ▶ Reply

Permalink Reply by Raymond Frankulin on February 10, 2010 at 2:43pm

Thanks for the help so far ;-)

In my never ending saga of dealing with iSeries data, I am finding out that much of the data in the data queue is packed. So far I haven't been able to find any method using XSL for transforming packed data into XML decimal. So I thinking of a couple of different ways: using the Code pipeline step, calling a web service or creating a subscriber that will receive and convert these messages. Since this is a high volume message I don't think the latter 2 will work (basically all slot, pit, bingo, keno, etc... ratings will be processed). Any thoughts on how to handle this?

I tried using the Code method but I need to reference external DLLs which don't show in the Assembly Browser and I can't seem to select individual DLLs. Also when I put something simple in the Code Editor like a single line: "private String test;" and try to save, I get an error "There are compilation errors that must be resolved before saving" and yet no errors show in the Compile Errors area. Are there any examples for using the code editor?

Thanks!

• ▶ Reply

Permalink Reply by CM on February 10, 2010 at 3:12pm

We never disourage people from using code vs. XSLT so if that's easier definitely go that route.

The code editor accepts references from the GAC. So if you want to use a DLL of your own, sign it and GAC it.

If you just want to use the classes from preimported namespaces then for things like string you just declare it as

string myString = "some string";

If you want to work with classes from one of the dlls that are referenced by default but their namespaces are not preimported then you would type things like

System.Xml.XmlDocument doc = context.Data.ToXmlDocument();

You can think of everything inside the editor of a Code Step as being in a local method.

If you want to save state between steps then you can use

context.Properties.Add("mykey",[myobject]);

A Code Step How To is on my agenda and should be included in docs soon.

If you need to bang on it live or have me walk you through stuff live before then let me know and we'll LM.

• ▶ Reply

Permalink Reply by Raymond Frankulin on February 11, 2010 at 8:20am

So I was able to get the required files into the GAC (IKVM dlls and compiled java dll jt400.dll - again from the iSeries dataqueu adapter code). In the pipeline code editor I am able to reference all dlls except the jt400.dll which throws the attached exception. These file are all referenced by the adapter project and work as expected.

If we can't get this working I could modify the adapter code to be single purpose but that isn't the optimal solution.

Thanks for the help

Attachments:

• error.txt, 17 KB

• ▶ Reply

Permalink Reply by CM on February 11, 2010 at 2:38pm

Sorry for taking so ling today Ray. I'm going to ask dev to look at this...Still looks like something else may need to be GAC'd

• ▶ Reply