{"id":5983,"date":"2007-06-06T12:13:00","date_gmt":"2007-06-06T12:13:00","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/vbteam\/2007\/06\/06\/visual-basic-xml-transform-teched-demo-prep\/"},"modified":"2024-07-05T14:45:31","modified_gmt":"2024-07-05T21:45:31","slug":"visual-basic-xml-transform-teched-demo-prep","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/vbteam\/visual-basic-xml-transform-teched-demo-prep\/","title":{"rendered":"Visual Basic XML Transform – TechEd demo prep"},"content":{"rendered":"

Hello from Orlando! I\u2019ve been at TechEd 2007 this week in very <\/i>sunny Orlando. As part of my demo prep, I had to create a little xml transform to convert the TechEd schedule that I got off the <\/font>www.msteched.com<\/font><\/a> website in an Excel XML format into a more readable xml file format. I could have done this all with one transform, but the newer XML file format made for good demo fodder to show off the XML Intellisense features coming in Orcas Beta2. <\/font><\/p>\n

I thought the code was interesting and fun \u2013 a great blend of XML properties, XML Literals, and query \u2013 so I\u2019ve posted it below:<\/font><\/p>\n

Imports<\/span> System.IO<\/span><\/p>\n

Imports<\/span> <<\/span>xmlns:ss<\/span>=<\/span>“<\/span>urn:schemas-microsoft-com:office:spreadsheet<\/span>“<\/span>><\/span><\/span><\/p>\n

 <\/span><\/p>\n

Module<\/span> Module1<\/span><\/p>\n

 <\/span><\/p>\n

 <\/span>‘Metadata info<\/span><\/span><\/p>\n

 <\/span>Enum<\/span> Column<\/span><\/p>\n

  <\/span>Code<\/span><\/p>\n

  <\/span>Title<\/span><\/p>\n

  <\/span>Description<\/span><\/p>\n

  <\/span>Track<\/span><\/p>\n

  <\/span>Session<\/span><\/p>\n

  <\/span>Level<\/span><\/p>\n

  <\/span>Speaker<\/span><\/p>\n

  <\/span>Room<\/span><\/p>\n

  <\/span>Timeslot<\/span><\/p>\n

 <\/span>End<\/span> Enum<\/span><\/span><\/p>\n

 <\/span><\/p>\n

 <\/span>Sub<\/span> Main()<\/span><\/p>\n

 <\/span><\/p>\n

  <\/span>Dim<\/span> fromFile = “C:TechEdScheduleExcelFormat.xml”<\/span><\/span><\/p>\n

  <\/span>Dim<\/span> toFile = “C:MyXMLFormat.xml”<\/span><\/span><\/p>\n

  <\/span>Dim<\/span> excelXML = XElement.Load(fromFile)<\/span><\/p>\n

 <\/span><\/p>\n

  <\/span>‘ Remove first row – metadata info<\/span><\/span><\/p>\n

  <\/span>excelXML…<<\/span>ss:Row><\/span>.First.Remove()<\/span><\/p>\n

 <\/span><\/p>\n

  <\/span>Dim<\/span> xml = _<\/span><\/p>\n

   <\/span><?<\/span>xml<\/span> version<\/span>=<\/span>“<\/span>1.0<\/span>“<\/span>?><\/span><\/span><\/p>\n

   <\/span><<\/span>EventSchedule<\/span> Event<\/span>=<\/span>“<\/span>TechEd2007<\/span>“<\/span>><\/span><\/span><\/p>\n

    <\/span><%=<\/span> _<\/span><\/p>\n

     <\/span>From<\/span> session In<\/span> excelXML…<<\/span>ss:Row><\/span> _<\/span><\/p>\n

     <\/span>Let<\/span> info = session…<<\/span>ss:Data><\/span> _<\/span><\/p>\n

     <\/span>Select<\/span> _<\/span><\/p>\n

      <<\/span>Event<\/span> ID<\/span>=<\/span><%=<\/span> info(Column.Code).Value %><\/span>><\/span><\/span><\/p>\n

       <\/span><<\/span>Title<\/span>><\/span><%=<\/span> info(Column.Title).Value %><\/span><\/<\/span>Title<\/span>><\/span><\/span><\/p>\n

       <\/span><<\/span>Description<\/span>><\/span><%=<\/span> info(Column.Description).Value %><\/span><\/<\/span>Description<\/span>><\/span><\/span><\/p>\n

       <\/span><<\/span>Track<\/span>><\/span><%=<\/span> info(Column.Track).Value %><\/span><\/<\/span>Track<\/span>><\/span><\/span><\/p>\n

       <\/span><<\/span>Session<\/span>><\/span><%=<\/span> info(Column.Session).Value %><\/span><\/<\/span>Session<\/span>><\/span><\/span><\/p>\n

       <\/span><<\/span>Level<\/span>><\/span><%=<\/span> info(Column.Level).Value %><\/span><\/<\/span>Level<\/span>><\/span><\/span><\/p>\n

       <\/span><<\/span>Speaker<\/span>><\/span><%=<\/span> info(Column.Speaker).Value %><\/span><\/<\/span>Speaker<\/span>><\/span><\/span><\/p>\n

       <\/span><<\/span>Room<\/span>><\/span><%=<\/span> info(Column.Room).Value %><\/span><\/<\/span>Room<\/span>><\/span><\/span><\/p>\n

       <\/span><<\/span>TimeSlot<\/span>><\/span><%=<\/span> info(Column.Timeslot).Value %><\/span><\/<\/span>TimeSlot<\/span>><\/span><\/span><\/p>\n

      <\/span><\/<\/span>Event<\/span>><\/span> _<\/span><\/p>\n

    <\/span>%><\/span><\/span><\/p>\n

   <\/span><\/<\/span>EventSchedule<\/span>><\/span><\/span><\/p>\n

 <\/span><\/p>\n

   <\/span>xml.Save(toFile)<\/span><\/p>\n

   <\/span>Shell(“C:Program FilesInternet Exploreriexplore.exe “<\/span> & toFile, AppWinStyle.MaximizedFocus)<\/span><\/p>\n

 <\/span><\/p>\n

 <\/span>End<\/span> Sub<\/span><\/span><\/p>\n

<\/span><\/span>End<\/span> Module<\/span><\/span><\/p>\n

 <\/font><\/p>\n

All this, so that in the demo, I could:<\/font><\/p>\n

1)<\/font>      <\/span><\/span><\/span>Open the resulting file, \u201cMyXMLFormat.xml\u201d, in Visual Studio<\/font><\/p>\n

2)<\/font>      <\/span><\/span><\/span>Right click on the XML menu item<\/font><\/p>\n

3)<\/font>      <\/span><\/span><\/span>Select create schema to infer an XSD from that file:<\/font><\/p>\n

\"Create<\/p>\n

 <\/font><\/p>\n

4)<\/font>      <\/span><\/span><\/span>Save the schema as an XSD and add it as an existing item in my project:<\/font><\/p>\n

\"Save <\/font><\/p>\n

5)<\/font>      <\/span><\/span><\/span>And get an awesome <\/i>Intellisense experience over the XML:<\/font><\/p>\n

\"XML<\/p>\n

 <\/font><\/p>\n

Pretty cool, no? <\/font><\/p>\n","protected":false},"excerpt":{"rendered":"

Hello from Orlando! I\u2019ve been at TechEd 2007 this week in very sunny Orlando. As part of my demo prep, I had to create a little xml transform to convert the TechEd schedule that I got off the www.msteched.com website in an Excel XML format into a more readable xml file format. I could have […]<\/p>\n","protected":false},"author":260,"featured_media":8818,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[192,195],"tags":[28,94],"class_list":["post-5983","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-featured","category-visual-basic","tag-amanda-silver","tag-linqvb9"],"acf":[],"blog_post_summary":"

Hello from Orlando! I\u2019ve been at TechEd 2007 this week in very sunny Orlando. As part of my demo prep, I had to create a little xml transform to convert the TechEd schedule that I got off the www.msteched.com website in an Excel XML format into a more readable xml file format. I could have […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/posts\/5983","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/users\/260"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/comments?post=5983"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/posts\/5983\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/media\/8818"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/media?parent=5983"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/categories?post=5983"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/tags?post=5983"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}