Access XML XSLT Q
- Started
- Last post
- 6 Responses
- redant
I need to change tags or elements in XML that is exported from Access to to put data into a calendar.
Can you give me a hint or point me somewhere to get help? No no google!This:
<Courses>
<Date>3/04/2009</Date>
<Title>Ocean Star Museum FENG 1001</Title>
<Description>Galveston Offshore Rig Museum</Description>
</Courses>To this:
<events>
<event>
<month>3</month>
<day>4</day>
<year>2009</year>
<text>Ocean Star Museum FENG 1001</text>
<popuplink/>
<style/>
<tooltip/>
<script/>
</event>I know I need to use XSLT, but can I parse the date? SHould I put Day Month and Year separate in the database? Can it be parsed?
- Nairn0
Why do you want to split the date up so? Your server-side software should be able to deal with some form of typical long form notation.
- neverblink0
is there a <course> around each.. well, course?
- Nairn0
We need to get Horp down on this shit.
- neverblink0
dude.. this isn't as hard as it might seem, you can use a substring to get the dates sorted.. then it's a basic XSLT transformation..
XPath & strings: http://www.w3schools.com/xpath/x…
- vaxorcist0
small perl script