Release List Reviews Shop Join News DVD Giveaways Video Games Advertise
DVD Reviews | Theatrical Reviews | Price Search Buy Stuff Here
DVD Talk
DVD Reviews DVD Talk Headlines HD Reviews


Add to My Yahoo! - RSS 2.0 - RSS 2.0 - DVD Talk Podcast RSS -


Go Back   DVD Talk Forum > Shopping Discussions > DVD Bargains > DVD Clubs

DVD Clubs Discuss & Strategize about DVD Clubs like Columbia House

Reply
 
Thread Tools
Old 03-19-03, 08:40 AM   #1
bga
Senior Member
 
Join Date: May 2002
Location: Minnesota
Posts: 584
The new updated list of CH DVDs (data miner)

I've written a perl script that generates a list of all titles it can find on the website as well as all the titles available for enrollment through the website. There are some titles that are not available for enrollment via the website but are available for enrollment by phone, see the FAQ and the Phone-Only enrollment threads at DVDTalk DVD Club forum. In general, these are one or two disc titles that were released several months ago, and have a suggested retail price less than $45.

The file is in comma separated value format, which can be read by just about any spreadsheet program. If you don't have a spreadsheet program, you can download a pretty good one for free at Open Office.

Note: The number of discs column in the datafile is based on a parameter in the CH links or a mention of the number of discs in the description, and does not always reflect the actual number of discs associated with the title. For example, some box sets show up as one disc.

A new listing for this is available. Here is the link to the list.
__________________
Help Project Gutenberg make more free e-books by joining Distributed ProofReaders

Last edited by bga; 03-20-03 at 08:53 AM.
  Reply With Quote
Old 03-19-03, 01:19 PM   #2
Member
 
Join Date: Mar 2002
Posts: 64
bga,

Excellent list.

I've taken the 3/11 CSV file and ported it into Excel. I've then added a couple fields (marking what I know I want, what I already have, etc.).

Taking the HTML update list, what do you think is the best way to update the XLS without having to manually key it?

I've got Access available to me and can port the XLS into Access if necessary.

Thanks.
  Reply With Quote
Old 03-19-03, 02:10 PM   #3
Senior Member
 
Join Date: Feb 2000
Location: Albany, NY
Posts: 437
anyone have any idea what this 1970706 Dawn Of The Dead that showed up is? The old version has been out of print for quite some time now (and fetches a pretty good price on ebay) and the new one isn't slated for this summer.
__________________
My DVDs
  Reply With Quote
Old 03-19-03, 03:59 PM   #4
Senior Member
 
Join Date: Dec 2001
Location: Portland, OR Originally; Now California
Posts: 313
Say WHAT?!?!

This is from the 3-18 update...
2763704 James Bond Collection, The
old price: 124.96
new price: 19.95

now that's one helluva decrease....

actual retail price: (fromt he accnt i logged into: $106.21

Is there something wrong with the script? B/c it did list all price decreases as being to $19.95 (but most of the rest are believable except this one).
  Reply With Quote
Old 03-19-03, 04:40 PM   #5
DVD Talk Limited Edition
 
Join Date: Apr 2000
Location: Korova Milkbar
Posts: 5,423
Noticed the same thing on the Star Trek box set... Real price is $111.95 not $19.95.

Dawn of the Dead - No idea but it shows up as The Director's Cut - no picture - with Elite as the studio. Obviously, there's something wrong there since both OOP editions are from Anchor Bay (since when would CH carry Elite products?). Anyone want to take a shot at Dawn and see what they get?
__________________
Blu-ray | DVD

Dilauded is pure sunshine wrapped in bacon and delivered straight to your pleasure center by a naked goddess. If I could get my hands on a gallon of it, I would start a new religion. - Cosmosguy
  Reply With Quote
Old 03-19-03, 04:47 PM   #6
Senior Member
 
Join Date: Sep 2002
Location: San Francisco
Posts: 445
Re: Say WHAT?!?!

Quote:
Originally posted by Berserker2069
This is from the 3-18 update...
2763704 James Bond Collection, The
old price: 124.96
new price: 19.95

now that's one helluva decrease....

actual retail price: (fromt he accnt i logged into: $106.21

Is there something wrong with the script? B/c it did list all price decreases as being to $19.95 (but most of the rest are believable except this one).
I guess you didn't read bga's message at the bottom. Try again.
__________________
Gold Trader like everyone else

for trade

want list
  Reply With Quote
Old 03-19-03, 08:26 PM   #7
DVD Talk Hero
 
D.Pham4GLTE (>60GB)'s Avatar
 
Join Date: Jul 2001
Location: Stick out your tongue!
Posts: 38,210
thanks for the update!
  Reply With Quote
Old 03-20-03, 09:39 AM   #8
Senior Member
 
Join Date: Feb 2000
Location: Albany, NY
Posts: 437
Quote:
Originally posted by Johnny Zhivago
Anyone want to take a shot at Dawn and see what they get?
Gave it a shot, expecting a raincheck (or the wrong movie). Let you know when it comes.
__________________
My DVDs
  Reply With Quote
Old 03-20-03, 09:46 AM   #9
DVD Talk Special Edition
 
Join Date: Oct 2000
Location: Davie, FL USA
Posts: 1,224
So bga, that is the reason we now have a 3/19 after having a 3/18?
  Reply With Quote
Old 03-20-03, 01:14 PM   #10
DVD Talk Special Edition
 
Join Date: Oct 2000
Location: Davie, FL USA
Posts: 1,224
I just checked your big list against my own 'to buy list' I made when I got my 1st catalog in mid-Feb. Anyway 2 titles I wanted to get, "Gotti" and "Rain Man" are not listed. And I also looked on the web site, they're definitely not there, definitely, definitely not available from CH, have to get 'em at K-Mart. Why is that? Why do titles just drop off the radar screen like that?
  Reply With Quote
Old 03-20-03, 06:21 PM   #11
bga
Senior Member
 
Join Date: May 2002
Location: Minnesota
Posts: 584
Yes, I deleted the 3/18 update because of the wrong prices. As to the titles that disappear, I presume CH had limited stock and ran out.
__________________
Help Project Gutenberg make more free e-books by joining Distributed ProofReaders
  Reply With Quote
Old 03-20-03, 09:12 PM   #12
DVD Talk Special Edition
 
Join Date: Feb 2001
Location: Ashley,Pa,USA
Posts: 1,676
Thanks! Nice List!
__________________
"Fear. Fear affects the fearful, the strong, the weak, the innocent, the corrupt, Fear is my ally."
  Reply With Quote
Old 03-21-03, 12:28 AM   #13
DVD Talk Special Edition
 
Join Date: Apr 2000
Location: Hollywood, USA
Posts: 1,571
Quote:
Originally posted by Qui-Gon John
Anyway 2 titles I wanted to get, "Gotti" and "Rain Man" are not listed. And I also looked on the web site, they're definitely not there, definitely, definitely not available from CH...
Can't say for GOTTI but RAIN MAN is OOP in advance of an SE planned for 2004.
__________________
Check out my new blog with posts on some of my cult film moviegoing experiences:

http://fdupflix.blogspot.com
  Reply With Quote
Old 03-21-03, 08:27 AM   #14
Member
 
Join Date: Mar 2002
Posts: 64
Anyone got a good methodology on using the HTML update file to auto update an ongoing spreadsheet?

Thanks.
  Reply With Quote
Old 03-26-03, 05:25 PM   #15
DVD Talk Special Edition
 
Join Date: Oct 2000
Location: Davie, FL USA
Posts: 1,224
What happened with SPY KIDS 2. I could swear on an older "not yet available for enrollment" list, it showed 3/24 as the date it would be available for enrollment? Now it's 5/18.
  Reply With Quote
Old 03-27-03, 12:38 AM   #16
DVD Talk Limited Edition
 
Join Date: May 2000
Location: Wichita, KS
Posts: 7,308
Thanks for the update
__________________
- Eddy B

Proud to be a Wichita State Shocker

My dining blog: Wichita By EB
  Reply With Quote
Old 03-27-03, 07:56 AM   #17
bga
Senior Member
 
Join Date: May 2002
Location: Minnesota
Posts: 584
I have no idea about Spy Kids 2. My program doesn't estimate when something becomes available for enrollment. Spy Kids 2 was released about a month ago, so I would expect it to become available either mid April or mid May depending on whether the CH has a 2 month or 3 month wait established for titles from this publisher.
__________________
Help Project Gutenberg make more free e-books by joining Distributed ProofReaders
  Reply With Quote
Old 03-31-03, 03:35 PM   #18
Banned
 
Join Date: Feb 2001
Location: NYC
Posts: 15,957
Is there an excel sheet of this? I know there used to be one.
  Reply With Quote
Old 04-01-03, 07:59 AM   #19
Senior Member
 
Join Date: Jan 2003
Location: Michigan
Posts: 927
Quote:
Originally posted by digitalfreaknyc
Is there an excel sheet of this? I know there used to be one.
The file is in comma separated value format, which can be read by just about any spreadsheet program including excel.
  Reply With Quote
Old 04-02-03, 08:47 AM   #20
bga
Senior Member
 
Join Date: May 2002
Location: Minnesota
Posts: 584
Save it to disk, and then open it, your spreadsheet program should open it automatically. BTW, a new update is available.
__________________
Help Project Gutenberg make more free e-books by joining Distributed ProofReaders
  Reply With Quote
Old 04-02-03, 09:20 AM   #21
Banned
 
Join Date: Feb 2001
Location: NYC
Posts: 15,957
Thanks so much!! this list is fantastic! I guess the only thing I'd have to ask is to add a date that some of the discs will be available for enrollment. Wasn't there a list of that floating around?
  Reply With Quote
Old 04-02-03, 11:49 AM   #22
DVD Talk Special Edition
 
Join Date: Oct 2000
Location: Davie, FL USA
Posts: 1,224
I believe in one of the 2 top sticky threads there is a link to the "not yet available for enrollment" and in that, it has the projected date it will be available.

Last edited by Qui-Gon John; 09-10-03 at 11:46 AM.
  Reply With Quote
Old 04-05-03, 12:59 PM   #23
Senior Member
 
Join Date: Aug 2002
Location: Tampa, FL
Posts: 712
For some reason, when I save and then try to open the 4/1/03 comma delimited list with excel, it says "this file is not a recognizable format" and puts a bunch of gibberish into a spreadsheet.

The 3/25/03 list works fine for me, though.
__________________
My DVD Collection
  Reply With Quote
Old 04-05-03, 01:52 PM   #24
Senior Member
 
Join Date: Jun 2002
Location: Bay Area
Posts: 443
Quote:
Originally posted by spyzdope
For some reason, when I save and then try to open the 4/1/03 comma delimited list with excel, it says "this file is not a recognizable format" and puts a bunch of gibberish into a spreadsheet.

The 3/25/03 list works fine for me, though.

I don't have any problems. Have you tried to download it again?
__________________
My DVDs/Blus/HD DVDs
  Reply With Quote
Old 04-06-03, 02:26 PM   #25
Senior Member
 
Join Date: Aug 2002
Location: Tampa, FL
Posts: 712
Quote:
Originally posted by bga
That's odd. I can read it fine with OpenOffice on FreeBSD, and with Excel 97 on Windows 98.
I've determined that there's definitely something wrong on my end when I decided to open up both the 4/1/03 and 3/25/03 files in wordpad to see if I noticed any differences:

The 3/25 list opens up in wordpad and is clearly has all of the correct cell data in quotes and separated by commas (i.e. "Selection","Title","Studio","Release Date","Genre","Price",......).

When I open the 4/1 file, it has a bunch of gibberish (i.e. {7v&N|m'9`D&.......) until about a quarter of the way down the page, at which point it begins listing normal cell data in quotes and separated by commas, starting with Stargate-UE.

The weird thing is that if I go to your page, and click on the 4/1/03 CSV link, and then choose "Open this file from it's current location", instead of saving to disk, it seems to open fine. Clearly, the file is getting screwed up when I save it to my hard drive. I hope it's not a virus or something. I'm about to start a full virus scan on my system to check.
__________________
My DVD Collection
  Reply With Quote
Reply


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are Off
Pingbacks are Off
Refbacks are Off



All times are GMT -5. The time now is 02:37 PM.


Copyright 2011 DVDTalk.com All Rights Reserved. Privacy Policy and Terms of Use.

Content Relevant URLs by vBSEO 3.2.0