JP1 Remotes

Oh, what a beautiful catalog!
Rob, there is one potential problem - a violation of the meaning of "currentRegion". You have an empty column. Excel hates blank rows and blank columns.
If you were, for instance, to sort on a protocol, all the stuff beyond column S will no longer apply to the stuff you sorted, i.e. Notes would have nothing to do with the file.
If you wanted to make the dropdown filter on all columns, you can't. It's the left side table or the right side table, but not both.
Suggestion: eliminate column S or give it a title ("x" will do) to make the entire table contiguous. Hope this makes sense.

You had me worried there for a minute. I just tried sorting the file and verified that the data beyond column S stays with the sort.

But none the less, in case some other version of Excel has a problem with this, I have eliminated the blank column from my "in progress" version (1.03) here:

https://www.hifi-remote.com/forums/dload ... le_id=8559

Worry - you should
Excel in Office2003 and 2000 here.
I just reproduced the anticipated problem like this:
Cursor on any cell on the left side, for instance on the FileID header.
Data > Sort - oops, the only area available to sort that Excel selects for me is the left of col.S area, and if sorted, LongDescription no longer belong on correct rows.
Only if I select the entire table it'll sort fine, but that's much too much work
I also confirmed that the Auto filter can go to one side or the other but not both.
So, at least for 2003 and earlier, removal/renaming of Col.S or any empty columns is desireable.

I guess we do our sorts differently. I always highlight the entire worksheet (by clicking on the black cell kitty-corner from cell A1) before sorting. I have sorted this spreadsheet many times and the data beyond column S is still in the right place.

Rob,
I guess that you don't need this anymore, since the spreadsheet seems to have lots of info in it, but here is JP1ScraperV2, which can download most of the files on this site, with the option to only download files which have been updated recently.

JP1ScraperV2

Thanks Dave, I'll check it out. I have been updating files from work and home, so when I'm done it will be nice to have a way to take a fresh download of everything, including the files that have been added since I started.

The Robman wrote:...when I'm done it will be nice to have a way to take a fresh download of everything, including the files that have been added since I started.

Will you be able to preserve the original file date when you redownload?

ElizabethD wrote:

The Robman wrote:...when I'm done it will be nice to have a way to take a fresh download of everything, including the files that have been added since I started.

Will you be able to preserve the original file date when you redownload?

Not sure I follow.

Bad choice of words (original filedate), I suppose. Sorry
Can you preserve the date the file was uploaded to yahoo? It's good to be able to tell old and newer things, and the date might help.

All of the files that we copied over from Yahoo have 2004 dates here now. The only way that I could change the date is to go and edit it on the database, which I could do, but it would be quite a bit of work for limited gain.

My primary goal here is to get the file section in as good a shape as I can, which I think I've been able to do. I have replaced several text files that contained lists of codes or instructions on how to create an upgrade, with actual upgrades. One guy even hacked into KM and found the Output sheet and copied it's contents to a text file, and that's what he loaded!

I'm also doing little edits, like changing the listed file names from things like sony-dvd to Sony DVD (ie, with a leading capital and a space between the words) so the files sort better.

I'm also working with Vicky to document all of the CCF files over at Remote Central, so if we find devices that don't exist over here, we can create upgrades for them.

Now that we can see which devices use the same device codes, we can cross-reference them to see if they share OBCs and if they do, create master files for them.

I've really found JP1Master to be very useful, so I've updated the file, and presumptively named it JP1Master-1.06. There are a couple of changes from Rob's versions.
1) I've added a column which shows the date the file was last updated.
2) JP1Scraper V3 attempts to identify homemade protocol executors automatically, so besides his "Y" and "?" classifications, there are some others based on the contents of the files. Quite probably this version has messed up some of Rob's classifications. To be honest, I don't think I could give an clear definition of a homemade executor.

The spreadsheet has a User Interface tab, which allows a user to change the file links to point to the directory structure on the user's computer, rather than the one on mine or Rob's.

The user can also run JP1Scraper (probably using the option to only download files newer than a specified date) and then import the resulting JP1Download.csv file into JP1Master. It was my intent that only a handful of mouse clicks would take care of the entire job, but still some handwork is needed to delete non-upgrade files, and to manually parse zip files.

Rob last updated JP1Master1.05 in October, and more than 300 upgrade files have been uploaded since then.

JP1Master-1.06

JP1ScraperV3

Thanks Dave, I'll have to check it out.

I've included files through March 31, 2011. About 50 new files since Feb 1.
JP1-Master1.07

Thanks Dave. Do you happen to know how many upgrades were added?