Parse Autogenerated XML using XSLT
up vote
1
down vote
favorite
There is a program where I work that will export the following student training schedule in XML. It's an unusual format but Is there a way to create an XSLT stylesheet to parse the data in table format? We have no way of changing the exported file. We are wanting to use the data to display for scheduling.
<?xml version="1.0" encoding="utf-8"?>
<Tablix2>
<Details_Collection>
<Details SCHED_START_DATE_TIME_DT2="26-Sep-2018" BS_CLASS_NM_ST2="18-11"
EQ_NAME_NM2="OFT 18" Textbox41="0500 - 0800" EVNT_NAME_NM_2="KPNM05"
Instructor2="Doe, John" Textbox40="Student, Jim" />
</Details_Collection>
</Tablix2>
xml parsing xslt
edited Nov 10 at 8:41
Gabriel Devillers
6681925
asked Nov 9 at 20:02
bbuttry
61
add a comment |
up vote
1
down vote
favorite
There is a program where I work that will export the following student training schedule in XML. It's an unusual format but Is there a way to create an XSLT stylesheet to parse the data in table format? We have no way of changing the exported file. We are wanting to use the data to display for scheduling.
<?xml version="1.0" encoding="utf-8"?>
<Tablix2>
<Details_Collection>
<Details SCHED_START_DATE_TIME_DT2="26-Sep-2018" BS_CLASS_NM_ST2="18-11"
EQ_NAME_NM2="OFT 18" Textbox41="0500 - 0800" EVNT_NAME_NM_2="KPNM05"
Instructor2="Doe, John" Textbox40="Student, Jim" />
</Details_Collection>
</Tablix2>
xml parsing xslt
edited Nov 10 at 8:41
Gabriel Devillers
6681925
asked Nov 9 at 20:02
bbuttry
61
Right now there is not enough information to answer your question. But yes that seems to be the job of XSLT to parse XML to produce over kind of texts (such as HTML which could be appropriate to display).
– Gabriel Devillers
Nov 9 at 21:56
It's not such an unusual format, and it is easy to handle with XSLT. Especially so if eachDetailselement has exactly the same attributes, in the same order.
– michael.hor257k
Nov 10 at 9:46
What do you consider unusual about this format? It's completely standard XML and can be handled using completely standard XSLT. (Unless we know why you are finding the problem difficult, it's hard to give an answer.)
– Michael Kay
Nov 10 at 11:20
I admit, I am a total newbie to XSLT. I've seen other XML documents and they were formatted with individual open and closed tags so I thought this was 'unusual'. I've been reading several documents on XSLT but can't seem to figure out how to parse this type of list. Yes, the Details element is exactly the same for the entire document and it has more than just the short list I posted. What I'm wanting to do is create a table but change the header rows to something more identifiable for the 7 elements (START, CLASS, OFT NAME, TIME, EVENT, INSTRUCTOR, STUDENT) with data in the columns.
– bbuttry
Nov 11 at 14:51
add a comment |
up vote
1
down vote
favorite
up vote
1
down vote
favorite
There is a program where I work that will export the following student training schedule in XML. It's an unusual format but Is there a way to create an XSLT stylesheet to parse the data in table format? We have no way of changing the exported file. We are wanting to use the data to display for scheduling.
<?xml version="1.0" encoding="utf-8"?>
<Tablix2>
<Details_Collection>
<Details SCHED_START_DATE_TIME_DT2="26-Sep-2018" BS_CLASS_NM_ST2="18-11"
EQ_NAME_NM2="OFT 18" Textbox41="0500 - 0800" EVNT_NAME_NM_2="KPNM05"
Instructor2="Doe, John" Textbox40="Student, Jim" />
</Details_Collection>
</Tablix2>
xml parsing xslt
edited Nov 10 at 8:41
Gabriel Devillers
6681925
asked Nov 9 at 20:02
bbuttry
61
There is a program where I work that will export the following student training schedule in XML. It's an unusual format but Is there a way to create an XSLT stylesheet to parse the data in table format? We have no way of changing the exported file. We are wanting to use the data to display for scheduling.
<?xml version="1.0" encoding="utf-8"?>
<Tablix2>
<Details_Collection>
<Details SCHED_START_DATE_TIME_DT2="26-Sep-2018" BS_CLASS_NM_ST2="18-11"
EQ_NAME_NM2="OFT 18" Textbox41="0500 - 0800" EVNT_NAME_NM_2="KPNM05"
Instructor2="Doe, John" Textbox40="Student, Jim" />
</Details_Collection>
</Tablix2>
xml parsing xslt
xml parsing xslt
edited Nov 10 at 8:41
Gabriel Devillers
6681925
asked Nov 9 at 20:02
bbuttry
61
edited Nov 10 at 8:41
Gabriel Devillers
6681925
asked Nov 9 at 20:02
bbuttry
61
edited Nov 10 at 8:41
Gabriel Devillers
6681925
edited Nov 10 at 8:41
Gabriel Devillers
6681925
edited Nov 10 at 8:41
Gabriel Devillers
6681925
6681925
asked Nov 9 at 20:02
bbuttry
61
asked Nov 9 at 20:02
bbuttry
61
asked Nov 9 at 20:02
bbuttry
61
61
Right now there is not enough information to answer your question. But yes that seems to be the job of XSLT to parse XML to produce over kind of texts (such as HTML which could be appropriate to display).
– Gabriel Devillers
Nov 9 at 21:56
It's not such an unusual format, and it is easy to handle with XSLT. Especially so if eachDetailselement has exactly the same attributes, in the same order.
– michael.hor257k
Nov 10 at 9:46
What do you consider unusual about this format? It's completely standard XML and can be handled using completely standard XSLT. (Unless we know why you are finding the problem difficult, it's hard to give an answer.)
– Michael Kay
Nov 10 at 11:20
I admit, I am a total newbie to XSLT. I've seen other XML documents and they were formatted with individual open and closed tags so I thought this was 'unusual'. I've been reading several documents on XSLT but can't seem to figure out how to parse this type of list. Yes, the Details element is exactly the same for the entire document and it has more than just the short list I posted. What I'm wanting to do is create a table but change the header rows to something more identifiable for the 7 elements (START, CLASS, OFT NAME, TIME, EVENT, INSTRUCTOR, STUDENT) with data in the columns.
– bbuttry
Nov 11 at 14:51
add a comment |
Right now there is not enough information to answer your question. But yes that seems to be the job of XSLT to parse XML to produce over kind of texts (such as HTML which could be appropriate to display).
– Gabriel Devillers
Nov 9 at 21:56
It's not such an unusual format, and it is easy to handle with XSLT. Especially so if eachDetailselement has exactly the same attributes, in the same order.
– michael.hor257k
Nov 10 at 9:46
What do you consider unusual about this format? It's completely standard XML and can be handled using completely standard XSLT. (Unless we know why you are finding the problem difficult, it's hard to give an answer.)
– Michael Kay
Nov 10 at 11:20
I admit, I am a total newbie to XSLT. I've seen other XML documents and they were formatted with individual open and closed tags so I thought this was 'unusual'. I've been reading several documents on XSLT but can't seem to figure out how to parse this type of list. Yes, the Details element is exactly the same for the entire document and it has more than just the short list I posted. What I'm wanting to do is create a table but change the header rows to something more identifiable for the 7 elements (START, CLASS, OFT NAME, TIME, EVENT, INSTRUCTOR, STUDENT) with data in the columns.
– bbuttry
Nov 11 at 14:51
Right now there is not enough information to answer your question. But yes that seems to be the job of XSLT to parse XML to produce over kind of texts (such as HTML which could be appropriate to display).
– Gabriel Devillers
Nov 9 at 21:56
Right now there is not enough information to answer your question. But yes that seems to be the job of XSLT to parse XML to produce over kind of texts (such as HTML which could be appropriate to display).
– Gabriel Devillers
Nov 9 at 21:56
It's not such an unusual format, and it is easy to handle with XSLT. Especially so if each
Details element has exactly the same attributes, in the same order.– michael.hor257k
Nov 10 at 9:46
It's not such an unusual format, and it is easy to handle with XSLT. Especially so if each
Details element has exactly the same attributes, in the same order.– michael.hor257k
Nov 10 at 9:46
What do you consider unusual about this format? It's completely standard XML and can be handled using completely standard XSLT. (Unless we know why you are finding the problem difficult, it's hard to give an answer.)
– Michael Kay
Nov 10 at 11:20
What do you consider unusual about this format? It's completely standard XML and can be handled using completely standard XSLT. (Unless we know why you are finding the problem difficult, it's hard to give an answer.)
– Michael Kay
Nov 10 at 11:20
I admit, I am a total newbie to XSLT. I've seen other XML documents and they were formatted with individual open and closed tags so I thought this was 'unusual'. I've been reading several documents on XSLT but can't seem to figure out how to parse this type of list. Yes, the Details element is exactly the same for the entire document and it has more than just the short list I posted. What I'm wanting to do is create a table but change the header rows to something more identifiable for the 7 elements (START, CLASS, OFT NAME, TIME, EVENT, INSTRUCTOR, STUDENT) with data in the columns.
– bbuttry
Nov 11 at 14:51
I admit, I am a total newbie to XSLT. I've seen other XML documents and they were formatted with individual open and closed tags so I thought this was 'unusual'. I've been reading several documents on XSLT but can't seem to figure out how to parse this type of list. Yes, the Details element is exactly the same for the entire document and it has more than just the short list I posted. What I'm wanting to do is create a table but change the header rows to something more identifiable for the 7 elements (START, CLASS, OFT NAME, TIME, EVENT, INSTRUCTOR, STUDENT) with data in the columns.
– bbuttry
Nov 11 at 14:51
add a comment |
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53232590%2fparse-autogenerated-xml-using-xslt%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53232590%2fparse-autogenerated-xml-using-xslt%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Right now there is not enough information to answer your question. But yes that seems to be the job of XSLT to parse XML to produce over kind of texts (such as HTML which could be appropriate to display).
– Gabriel Devillers
Nov 9 at 21:56
It's not such an unusual format, and it is easy to handle with XSLT. Especially so if each
Detailselement has exactly the same attributes, in the same order.– michael.hor257k
Nov 10 at 9:46
What do you consider unusual about this format? It's completely standard XML and can be handled using completely standard XSLT. (Unless we know why you are finding the problem difficult, it's hard to give an answer.)
– Michael Kay
Nov 10 at 11:20
I admit, I am a total newbie to XSLT. I've seen other XML documents and they were formatted with individual open and closed tags so I thought this was 'unusual'. I've been reading several documents on XSLT but can't seem to figure out how to parse this type of list. Yes, the Details element is exactly the same for the entire document and it has more than just the short list I posted. What I'm wanting to do is create a table but change the header rows to something more identifiable for the 7 elements (START, CLASS, OFT NAME, TIME, EVENT, INSTRUCTOR, STUDENT) with data in the columns.
– bbuttry
Nov 11 at 14:51