The new updated list of CH DVDs (data miner) - Page 5

bga · 09-24-03, 01:09 PM

I don't see why they would deny me, I just received 11 emails telling me that they want me back!

nrose101 · 09-24-03, 01:15 PM

ditto here. I just called them and they said it can take 2-3 weeks for a web application to be approved...we all know this is bs but it seems there standard line for now.

Qui-Gon John · 09-24-03, 02:45 PM

Yep, besides all the emails I got like 3 envelopes in the mail one day, and another 3 the next day. All wanting me back, all with the lame intro of 5 @.49 plus S&H.

ajsands · 09-30-03, 01:11 PM

I'm trying to determine what's new at Columbia House since mid-April. Sorting your spreadsheat by DVD Release date seems to do that for me. Just wanted to make sure I'm not missing anything(?). THANKS for continually doing this; I'll be checking back tomorrow for an update.

bga · 10-02-03, 07:57 AM

The DVD Release date is only updated when a title is available for prerelease. If CH added titles since April after the DVD was release (and they have), you'll miss them. It doesn't look like Excel has an option to compare two spreadsheets, but OpenOffice does.

BTW, the data miner has died too many times this week. I'm working on changes to the perl script so that if it dies it doesn't have to start over at the beginning. I expect to finish it after work today, but there definitely won't be a new update until Friday or Saturday.

Qui-Gon John · 10-02-03, 10:12 AM

I wonder if the problems it is having are related to the problems people are having to get web accounts to go through?

nrose101 · 10-08-03, 12:37 PM

BGA is the miner still dead...This is the second wednesday with no list I am starting to get the shakes...first CH is not accepting applications..now this...oh the horror!

Qui-Gon John · 10-08-03, 01:34 PM

Jeez, what if CH goes out of business. Oh my God!

Adrenaline · 10-08-03, 04:13 PM

Quote:

Originally posted by Qui-Gon John
Jeez, what if CH goes out of business. Oh my God!

the amount of dvds I buy per month will drop considerably

vivarey · 10-08-03, 05:40 PM

Quote:

Originally posted by Qui-Gon John
Jeez, what if CH goes out of business. Oh my God!

I only have one response to that:

Oh, the HUMANITY!

bga · 10-08-03, 06:56 PM

It's still running. I didn't get the changes I was going to make last week done until this morning. I also noticed that CH had some links that didn't have quotes around them, so I had to fix that before the enrollment check speedup would work. It's got at least 16000 links to process before it's done. It should be done sometime tonight, and the worse case should be that I just have to reprocess the enrollment section if I broke something.

thawtz · 10-08-03, 08:06 PM

Thanks for your effort bga! I think CH should pay you since this board and your data in particular are directly responsible for me being a customer.

nrose101 · 10-08-03, 08:16 PM

Thank you bga you are the greatest!

bga · 10-11-03, 03:19 PM

I've finally put out a new version. I think I've fixed all the issues with it, in particular, the ability to restart, and that it was missing a bunch of links, but it also took about 36 hours to run, mainly because many of the "new" links are for cast members that have links to only one movie. I'm planning on ignoring them again in the future. The number of discs in the package are more likely to be correct now, too.

bga · 10-12-03, 01:29 PM

I noticed that also. Since CH has been offering video games for a month or two, I think that they're showing up as new because the changes in my data miner script now find them. If they were found because actors are doing voices for them, they may go away next week, though.

RevKarl · 10-13-03, 06:51 PM

Quote:

Originally posted by xpfshost
Very cool. Thanks, bga! Now I can see all the DVDs that CH carries that I can't get because they aren't approving accounts!! I'm starting to get the shakes....

Ditto...with another thanks for all bga's work in putting these CH lists together.

bga · 10-21-03, 08:26 PM

A new update is available. For some reason, CH has brought back some non SE versions of titles, like the 6th Day and Pulp Fiction, At least 30 new titles and 30 new enrollments.

bga · 10-28-03, 11:33 PM

A new update is out, with about 40 new titles including a music video by Avril Lavigne (with whom I share a natal anniversary), a half dozen TV series season sets, and a couple of anime titles. About 30 new titles available for enrollment.

Berserker2069 · 10-29-03, 01:19 PM

bga,

Do you think it would be possible to take this newest spreadsheet, and an older one (before we started seeing the more expensive DVDs going away, BHD, Fight Club 2-disc, etc) and get a list of "recently unavailable for enrollment" ?

I'm no programmer, and i don't know how you generate the spreadsheet, etc but it seems like you could just take all the old available enrollments and make sure its an enrollment in the new one.

I would greatly appreciate it.

bga · 10-30-03, 12:04 AM

I was thinking about this the last couple of days. I can probably modify the script that generates the HTML differences to notice the unavailable for enrollment. I'll probably regenerate the weekly differences when I'm done.

D-Ball · 10-30-03, 02:15 AM

Quote:

Originally posted by Berserker2069
bga,

Do you think it would be possible to take this newest spreadsheet, and an older one (before we started seeing the more expensive DVDs going away, BHD, Fight Club 2-disc, etc) and get a list of "recently unavailable for enrollment" ?

I posted a list in this thread: http://www.dvdtalk.com/forum/showthr...hreadid=324603

Berserker2069 · 10-30-03, 12:57 PM

D-Ball,

I know but i'm just wondering if you got them all. No offense, but some good coding is a lot more thurough than hand checking. Plus, we might be able easier figure out if there is any similarities in the DVDs they pulled.

bga,

thanks a lot!

bga · 11-04-03, 11:35 PM

A new update is available. I didn't do the missing enrollments, because it looked like they were all pulled the same week, and the other thread is covering them, including the former phone-only enrollments which I can't spot. This week's update includes about 30 new tiles, 20 new enrollments. The most interesting thing I noticed was a DVD starter kit, for $180 ($300 list) with the 2004 Leonard Maltin guide and 15 DVDs (The Sound of Music, Grease, Braveheart, The Green Mile, Lawrence Of Arabia, Rear Window, The Wizard of Oz, Gladiator, Forrest Gump, E.T. The Extra-Terrestrial, Scarface, National Lampoon’s Animal House, Spider-Man, Casablanca, and Dances With Wolves).

bga · 11-12-03, 09:34 AM

A new update is available. About 25 new titles, 25 new enrollments, and 25 price reductions.

abintra · 11-17-03, 06:00 AM

How do you open the .csv file? I downloaded OpenOffice and tried to open it with that but all I get is gibberish.

Any chance it is because OO didn't install a Java program? It said it needed it but the option to install it was grayed out.

09-24-03, 01:09 PM	#101
bga Senior Member Join Date: May 2002 Location: Minnesota Posts: 584	I don't see why they would deny me, I just received 11 emails telling me that they want me back! __________________ Help Project Gutenberg make more free e-books by joining Distributed ProofReaders

10-02-03, 07:57 AM	#105
bga Senior Member Join Date: May 2002 Location: Minnesota Posts: 584	The DVD Release date is only updated when a title is available for prerelease. If CH added titles since April after the DVD was release (and they have), you'll miss them. It doesn't look like Excel has an option to compare two spreadsheets, but OpenOffice does. BTW, the data miner has died too many times this week. I'm working on changes to the perl script so that if it dies it doesn't have to start over at the beginning. I expect to finish it after work today, but there definitely won't be a new update until Friday or Saturday. __________________ Help Project Gutenberg make more free e-books by joining Distributed ProofReaders

10-08-03, 06:56 PM	#111
bga Senior Member Join Date: May 2002 Location: Minnesota Posts: 584	It's still running. I didn't get the changes I was going to make last week done until this morning. I also noticed that CH had some links that didn't have quotes around them, so I had to fix that before the enrollment check speedup would work. It's got at least 16000 links to process before it's done. It should be done sometime tonight, and the worse case should be that I just have to reprocess the enrollment section if I broke something. __________________ Help Project Gutenberg make more free e-books by joining Distributed ProofReaders

10-11-03, 03:19 PM	#114
bga Senior Member Join Date: May 2002 Location: Minnesota Posts: 584	I've finally put out a new version. I think I've fixed all the issues with it, in particular, the ability to restart, and that it was missing a bunch of links, but it also took about 36 hours to run, mainly because many of the "new" links are for cast members that have links to only one movie. I'm planning on ignoring them again in the future. The number of discs in the package are more likely to be correct now, too. __________________ Help Project Gutenberg make more free e-books by joining Distributed ProofReaders

10-12-03, 01:29 PM	#115
bga Senior Member Join Date: May 2002 Location: Minnesota Posts: 584	I noticed that also. Since CH has been offering video games for a month or two, I think that they're showing up as new because the changes in my data miner script now find them. If they were found because actors are doing voices for them, they may go away next week, though. __________________ Help Project Gutenberg make more free e-books by joining Distributed ProofReaders

09-24-03, 01:15 PM	#102
nrose101 Banned Join Date: Jan 2003 Location: South Florida Posts: 627	ditto here. I just called them and they said it can take 2-3 weeks for a web application to be approved...we all know this is bs but it seems there standard line for now.

09-24-03, 02:45 PM	#103
Qui-Gon John DVD Talk Special Edition Join Date: Oct 2000 Location: Davie, FL USA Posts: 1,224	Yep, besides all the emails I got like 3 envelopes in the mail one day, and another 3 the next day. All wanting me back, all with the lame intro of 5 @.49 plus S&H.

09-30-03, 01:11 PM	#104
ajsands Member Join Date: Nov 2002 Posts: 152	I'm trying to determine what's new at Columbia House since mid-April. Sorting your spreadsheat by DVD Release date seems to do that for me. Just wanted to make sure I'm not missing anything(?). THANKS for continually doing this; I'll be checking back tomorrow for an update.

10-02-03, 10:12 AM	#106
Qui-Gon John DVD Talk Special Edition Join Date: Oct 2000 Location: Davie, FL USA Posts: 1,224	I wonder if the problems it is having are related to the problems people are having to get web accounts to go through?

10-08-03, 12:37 PM	#107
nrose101 Banned Join Date: Jan 2003 Location: South Florida Posts: 627	BGA is the miner still dead...This is the second wednesday with no list I am starting to get the shakes...first CH is not accepting applications..now this...oh the horror!

10-08-03, 01:34 PM	#108
Qui-Gon John DVD Talk Special Edition Join Date: Oct 2000 Location: Davie, FL USA Posts: 1,224	Jeez, what if CH goes out of business. Oh my God!

10-08-03, 08:06 PM	#112
thawtz Member Join Date: Mar 2003 Location: Santa Babylon Posts: 143	Thanks for your effort bga! I think CH should pay you since this board and your data in particular are directly responsible for me being a customer.

10-08-03, 08:16 PM	#113
nrose101 Banned Join Date: Jan 2003 Location: South Florida Posts: 627	Thank you bga you are the greatest!

10-21-03, 08:26 PM	#117
bga Senior Member Join Date: May 2002 Location: Minnesota Posts: 584	A new update is available. For some reason, CH has brought back some non SE versions of titles, like the 6th Day and Pulp Fiction, At least 30 new titles and 30 new enrollments. __________________ Help Project Gutenberg make more free e-books by joining Distributed ProofReaders

10-28-03, 11:33 PM	#118
bga Senior Member Join Date: May 2002 Location: Minnesota Posts: 584	A new update is out, with about 40 new titles including a music video by Avril Lavigne (with whom I share a natal anniversary), a half dozen TV series season sets, and a couple of anime titles. About 30 new titles available for enrollment. __________________ Help Project Gutenberg make more free e-books by joining Distributed ProofReaders

10-29-03, 01:19 PM	#119
Berserker2069 Senior Member Join Date: Dec 2001 Location: Portland, OR Originally; Now California Posts: 313	bga, Do you think it would be possible to take this newest spreadsheet, and an older one (before we started seeing the more expensive DVDs going away, BHD, Fight Club 2-disc, etc) and get a list of "recently unavailable for enrollment" ? I'm no programmer, and i don't know how you generate the spreadsheet, etc but it seems like you could just take all the old available enrollments and make sure its an enrollment in the new one. I would greatly appreciate it. __________________ My DVDs Here

10-30-03, 12:04 AM	#120
bga Senior Member Join Date: May 2002 Location: Minnesota Posts: 584	I was thinking about this the last couple of days. I can probably modify the script that generates the HTML differences to notice the unavailable for enrollment. I'll probably regenerate the weekly differences when I'm done. __________________ Help Project Gutenberg make more free e-books by joining Distributed ProofReaders

10-30-03, 12:57 PM	#122
Berserker2069 Senior Member Join Date: Dec 2001 Location: Portland, OR Originally; Now California Posts: 313	D-Ball, I know but i'm just wondering if you got them all. No offense, but some good coding is a lot more thurough than hand checking. Plus, we might be able easier figure out if there is any similarities in the DVDs they pulled. bga, thanks a lot! __________________ My DVDs Here

11-04-03, 11:35 PM	#123
bga Senior Member Join Date: May 2002 Location: Minnesota Posts: 584	A new update is available. I didn't do the missing enrollments, because it looked like they were all pulled the same week, and the other thread is covering them, including the former phone-only enrollments which I can't spot. This week's update includes about 30 new tiles, 20 new enrollments. The most interesting thing I noticed was a DVD starter kit, for $180 ($300 list) with the 2004 Leonard Maltin guide and 15 DVDs (The Sound of Music, Grease, Braveheart, The Green Mile, Lawrence Of Arabia, Rear Window, The Wizard of Oz, Gladiator, Forrest Gump, E.T. The Extra-Terrestrial, Scarface, National Lampoon’s Animal House, Spider-Man, Casablanca, and Dances With Wolves). __________________ Help Project Gutenberg make more free e-books by joining Distributed ProofReaders

11-12-03, 09:34 AM	#124
bga Senior Member Join Date: May 2002 Location: Minnesota Posts: 584	A new update is available. About 25 new titles, 25 new enrollments, and 25 price reductions. __________________ Help Project Gutenberg make more free e-books by joining Distributed ProofReaders

11-17-03, 06:00 AM	#125
abintra DVD Talk Gold Edition Join Date: Jan 2002 Location: Somewhere between thought and expression Posts: 2,770	How do you open the .csv file? I downloaded OpenOffice and tried to open it with that but all I get is gibberish. Any chance it is because OO didn't install a Java program? It said it needed it but the option to install it was grayed out.