|
|
 next
|
  Subject: Re: XSLT help - newbie
Author: M Kline
Date: 31 Oct 2006 02:04 PM
|
Sorry, here is the attached XML file.
(See attached file: 820_Example.xml)
|---------+------------------------------------------------->
| | "stylus-studio-xslt Listmanager" |
| | <stylus-studio-xslt.listmanager@stylus|
| | studio.com> |
| | |
| | 10/31/2006 01:38 PM |
| | Please respond to "XSLT Help and |
| | Discussion" |
|---------+------------------------------------------------->
>----------------------------------------------------------------------------------------------------|
| |
| To: (Recipients of 'stylus-studio-xslt' suppressed) |
| cc: |
| Subject: XSLT help - newbie |
>----------------------------------------------------------------------------------------------------|
From: Mary Kline
Hello,
I posted originally in XQuery board, but maybe that was the wrong board.
I have an 820 (EDI Receiving Advice) from a Customer. I would like to
extract (forgive the terminology) certain parts of the XML they send,
however I cannot figure out how. I have it broken down to Item, then Value,
however everything in the XML is an <Item> or <Value> even though the data
content is different.
I'm attaching an example with the areas that I'd like to get on a report
somehow, sorted, for my Accounting Department.
StylusStudio is my last attempt before we have to pay the web-host a lot of
money to produce our desired results. Unfortunately, I do not know enough
about XML/XSLT to do this myself so I'm hoping someone could offer me some
assistance.
We receive this document weekly so the XSLT would be "applied" against the
new XML (by me) on a weekly basis.
Thanks,
Mary
--
To reply:stylus-studio-xslt.17397@stylusstudio.com
To start a new topic:stylus-studio-xslt@stylusstudio.com
To login:http://www.stylusstudio.com/SSDN/
To (un)subscribe:stylus-studio-xslt.list-request@stylusstudio.com
 820_Example.xml
|
 top
|
Subject: Re: XSLT help - newbie
Author: M Kline
Date: 03 Nov 2006 01:15 PM
|
Hi Tony,
Thank You. I will take a look at this.
I have added columns to the result, and added more in the <xsl:value-of
select statement to get the information I want on the .csv. The issue
I'm having at the moment, which I've not had too much time today to look
at, is getting this selection criteria to repeat throughout the entire XML
until it reaches the end. There might be 100, 200+ "sections" to go
through until the end of the document. Right now, it's only pulling the
very first grouping (if that makes any sense) in the result, and ultimately
on the .csv
I looked briefly at the <xsl:key function last night, however I kept
looking at my XSL, then back to the <xsl:key examples and my head started
to hurt. :-) Would you be able to tell me if the <xsl:key would
work for this type of thing or is there a different/better function I could
use? (sorry about the long file name)
(See attached file: 820_from_SS_add_Quantity.xsl)
Mary
|---------+------------------------------------------------->
| | "stylus-studio-xslt Listmanager" |
| | <stylus-studio-xslt.listmanager@stylus|
| | studio.com> |
| | |
| | 11/03/2006 12:14 PM |
| | Please respond to "XSLT Help and |
| | Discussion" |
|---------+------------------------------------------------->
>---------------------------------------------------------------------------------------------------------------------------------------------|
| |
| To: (Recipients of 'stylus-studio-xslt' suppressed) |
| cc: |
| Subject: Re: XSLT help - newbie |
>---------------------------------------------------------------------------------------------------------------------------------------------|
From: Tony Lavinio
Here is perhaps one other option.
This XSLT sort of 'denormalizes' your XML back into something
that you can use with the XSLT Mapper.
If you use this, please become a customer :)
--
Attachment: http://www.stylusstudio.com/SSDN/upload/kline.xsl (2KB)
--
To reply:stylus-studio-xslt.17458@stylusstudio.com
To start a new topic:stylus-studio-xslt@stylusstudio.com
To login:http://www.stylusstudio.com/SSDN/
To (un)subscribe:stylus-studio-xslt.list-request@stylusstudio.com
820_from_SS_add_Quantity.xsl
|
|
|
|
|
820.xsl