DVD Clubs Discuss & Strategize about DVD Clubs like Columbia House

The new updated list of CH DVDs (data miner)

Old 03-19-03, 08:40 AM
  #1  
bga
Senior Member
Thread Starter
 
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.

Last edited by bga; 03-20-03 at 08:53 AM.
bga is offline  
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.
jgottlieb is offline  
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.
durin is offline  
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).
Berserker2069 is offline  
Old 03-19-03, 04:40 PM
  #5  
DVD Talk Limited Edition
 
Johnny Zhivago's Avatar
 
Join Date: Apr 2000
Location: Korova Milkbar
Posts: 5,435
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?
Johnny Zhivago is offline  
Old 03-19-03, 04:47 PM
  #6  
Senior Member
 
Join Date: Sep 2002
Location: San Francisco
Posts: 445
Re: Say WHAT?!?!

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.
drunk jay is offline  
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: 39,174
thanks for the update!
D.Pham4GLTE (>60GB) is offline  
Old 03-20-03, 09:39 AM
  #8  
Senior Member
 
Join Date: Feb 2000
Location: Albany, NY
Posts: 437
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.
durin is offline  
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?
Qui-Gon John is offline  
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?
Qui-Gon John is offline  
Old 03-20-03, 06:21 PM
  #11  
bga
Senior Member
Thread Starter
 
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.
bga is offline  
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!
DarthMaul420 is offline  
Old 03-21-03, 12:28 AM
  #13  
DVD Talk Special Edition
 
Join Date: Apr 2000
Location: Hollywood, USA
Posts: 1,571
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.
CrumpsBrother is offline  
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.
jgottlieb is offline  
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.
Qui-Gon John is offline  
Old 03-27-03, 12:38 AM
  #16  
DVD Talk Limited Edition
 
Join Date: May 2000
Location: Wichita, KS
Posts: 7,317
Thanks for the update
edytwinky is offline  
Old 03-27-03, 07:56 AM
  #17  
bga
Senior Member
Thread Starter
 
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.
bga is offline  
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.
digitalfreaknyc is offline  
Old 04-01-03, 07:59 AM
  #19  
Senior Member
 
Join Date: Jan 2003
Location: Michigan
Posts: 927
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.
SRGilbert is offline  
Old 04-02-03, 08:47 AM
  #20  
bga
Senior Member
Thread Starter
 
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.
bga is offline  
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?
digitalfreaknyc is offline  
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.
Qui-Gon John is offline  
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.
spyzdope is offline  
Old 04-05-03, 01:52 PM
  #24  
Senior Member
 
Join Date: Jun 2002
Location: Bay Area
Posts: 443
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?
basketb is offline  
Old 04-06-03, 02:26 PM
  #25  
Senior Member
 
Join Date: Aug 2002
Location: Tampa, FL
Posts: 712
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.
spyzdope is offline  

Thread Tools
Search this Thread

Archive Advertising Cookie Policy Privacy Statement Terms of Service

Copyright 2018 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.