Extra Zap2It Meta Data

[ecorbin]

Quote[/b] (jorm @ Dec. 01 2004,18:05)]ecorbin,

lets try this first. There is now a file called zapdata.xml in your directory. Can you search for '1953-10-12' in there. The air date is the first air date. Maybe some old holiday movies that first aired in the 50's are being picked up. Let me know what you find.

Hmmm...the 1953-10-12 show is ABC World News Tonight. The next oldest date was 1956-11-26, which was for The Price Is Right. Is it giving the date for the first episode of these programs, rather than for the current episode?

[jorm]

It seems to be the first airing of the series not of the current episode.

[mroy]

Are you guys still working on this plugin? I downloaded & ran the zapimport.exe. It downloaded the 7.5 Mb zapdata.xml, and then came up w/ the following errors:

Alert Window:
CLR Debugging Services
Application has generated an exception that could not be handled.
Process id=0x990(2448), Thread id=0xca4(3236).

Command Line:
Total Loaded 0
Loading up schedules

Unhandled Exception: System.NullReferenceException: Object reference not set to an instance of an object.
at org.kjac.dev.DataDirect.ZapDataeader.loadSchedules(XmlNode rootNode)
at org.kjac.dev.DataDirect.MainClass.Main(String[] args)

Depending on what language you're writing this in I may be able to help out.

Any thoughts on doing this in MSDE? It's noticeably faster than access.

[KingArgyle]

The XML processing probably needs to change, as I believe since Jorm originally wrote this application, the Zap2It XML format has changed. Mainly the web services just need to be regenerated.

Once this is stabalized, I'll look at integrating this with MSDE as well since I did the original leg work on that research project. Shouldn't be to difficult to do, either a new database will exist, or a new set of tables.

[mroy]

Sounds great, thanks for your work.

[gwyden]

Quote[/b] (jorm @ Dec. 01 2004,14:32)]Well so far I have been able to access zap2it downloading a big xml file of the data. I parse it apart and populate a new database with the fields.

The problem I am having is I need to be able to compact the database. Any ideas?

@J: I don't know if you're still looking for an answer to this questions but check this out (for Access Version 2000 and later only):

<table border="0" align="center" width="95%" cellpadding="0" cellspacing="0"><tr><td>Code Sample </td></tr><tr><td id="CODE">
Public Function AutoCompactMe()
Dim fs, f, s, filespec
Dim strProjectPath As String, strProjectName As String
strProjectPath = Application.CurrentProject.Path
strProjectName = Application.CurrentProject.Name
filespec = strProjectPath &amp; "\" &amp; strProjectName
Set fs = CreateObject("Scripting.FileSystemObject")
Set f = fs.GetFile(filespec)
s = CLng(f.Size / 1000000) ‘convert size of app from bytes to Mb’s
If s > 20 Then ‘edit the 20 (Mb’s) to the max size you want to allow your app to grow.
Application.SetOption ("Auto Compact"), 1 ‘compact app
Else
Application.SetOption ("Auto Compact"), 0 ‘no don’t compact app
End If
End Function[/QUOTE]

Put this in as a Global Module

Then Call the Function from the procedure that closes down your app, before e.g. Docmd.Quit:

AutoCompactMe

[sub]

The application will already compact the database each time you click the OK button in the config app. It can only be done at this time because it needs to stop the recording service from accessing the database at the same time as the compact occurs.

[gwyden]

Quote[/b] (sub @ Mar. 14 2005,22:19)]The application will already compact the database each time you click the OK button in the config app. It can only be done at this time because it needs to stop the recording service from accessing the database at the same time as the compact occurs.

@sub: This is actually a suggestion for the zapdb.mbd that is holding the unused information.

[sub]

ah, sorry. skim reading....