View Single Post
  #1 (permalink)  
Old July 15th, 2004, 11:04 AM
pbyers pbyers is offline
Registered User
 
Join Date: Jun 2003
Location: Northolt, Middlesex, United Kingdom.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Please save my sanity

Good Afternoon All

    The two XML files shown below, contain the same data.

    I need to translate from one to the other (BOTH WAYS) in two ASP files.

    I can do this by the use of some rather cumbersome VBS.

    However, I seem to remember seeing an article somewhere showing how to do it using XSL (I think)

    I cant find the article sadly.



    I also would like to get some "generic"-ish script to do the job.


    Can anyone please either;

        point me to a resource that tells me how to do it;

    or

        give me some working scripts that would do the job.



    I thank you all in advance and anticipation - if you can help, you will save an old guy from 'going completely round the twist'.


Best regards
Thank you

Pete (Northolt UK)





<?xml version="1.0"?>
<HOTEL-STUFF>
    <ROOM-DETS>
      <ROOM-CODE VALUE="R40"/>
      <RESN-CODE>
       <RESN-REF VALUE="VR-407"/>
       <ARRIVAL-DATE VALUE="27/07/1998"/>
       <STAY-DAYS VALUE="2"/>
       <CLIENT-CODE VALUE="DAL00322"/>
       <CLIENT-NAME VALUE="Marzak"/>
      </RESN-CODE>
      <RESN-CODE>
       <RESN-REF VALUE="VR-417"/>
       <ARRIVAL-DATE VALUE="29/07/1998"/>
       <STAY-DAYS VALUE="14"/>
       <CLIENT-CODE VALUE="DAL00217"/>
       <CLIENT-NAME VALUE="Hathaway"/>
      </RESN-CODE>
      <RESN-CODE>
       <RESN-REF VALUE="VR-477"/>
       <ARRIVAL-DATE VALUE="27/07/2004"/>
       <STAY-DAYS VALUE="2"/>
       <CLIENT-CODE VALUE="DAL00322"/>
       <CLIENT-NAME VALUE="Marzak"/>
       <ROOM-FIXED VALUE="True"/>
      </RESN-CODE>
    </ROOM-DETS>
    <ROOM-DETS>
      <ROOM-CODE VALUE="R72"/>
      <RESN-CODE>
       <RESN-REF VALUE="VR-123"/>
       <ARRIVAL-DATE VALUE="27/07/1998"/>
       <STAY-DAYS VALUE="2"/>
       <CLIENT-CODE VALUE="XYZ00322"/>
       <CLIENT-NAME VALUE="Smith"/>
      </RESN-CODE>
    </ROOM-DETS>
</HOTEL-STUFF>





<?xml version="1.0"?>
<HOTEL-STUFF>
    <ROOM-DETS ROOM-CODE="R40" RESN-REF="VR-407" ARRIVAL-DATE="27/07/1998" STAY-DAYS="2" CLIENT-CODE="DAL00322" CLIENT-NAME="Marzak"/>
    <ROOM-DETS ROOM-CODE="R40" RESN-REF="VR-417" ARRIVAL-DATE="29/07/1998" STAY-DAYS="14" CLIENT-CODE="DAL00217" CLIENT-NAME="Hathaway"/>
    <ROOM-DETS ROOM-CODE="R40" RESN-REF="VR-477" ARRIVAL-DATE="27/07/2004" STAY-DAYS="2" CLIENT-CODE="DAL00322" CLIENT-NAME="Marzak" ROOM-FIXED="True"/>
    <ROOM-DETS ROOM-CODE="R72" RESN-REF="VR-123" ARRIVAL-DATE="27/07/1998" STAY-DAYS="2" CLIENT-CODE="XYZ00322" CLIENT-NAME="Smith"/>
</HOTEL-STUFF>