|
JP1 Remotes
|
View previous topic :: View next topic |
Author |
Message |
ElizabethD Advanced Member
Joined: 09 Feb 2004 Posts: 2348
|
Posted: Thu Jun 24, 2010 1:28 pm Post subject: |
|
|
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. _________________ Liz
Tweeking 8910, HTPro/9811, C7-7800, 6131o, 6131n, AtlasOCAP-1056B01, RCA-RCRP05B and enjoying the ride |
|
Back to top |
|
|
The Robman Site Owner
Joined: 01 Aug 2003 Posts: 21237 Location: Chicago, IL |
Posted: Thu Jun 24, 2010 2:01 pm Post subject: |
|
|
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:
http://www.hifi-remote.com/forums/dload.php?action=file&file_id=8559 _________________ Rob
www.hifi-remote.com
Please don't PM me with remote questions, post them in the forums so all the experts can help! |
|
Back to top |
|
|
ElizabethD Advanced Member
Joined: 09 Feb 2004 Posts: 2348
|
Posted: Thu Jun 24, 2010 4:52 pm Post subject: |
|
|
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. _________________ Liz
Tweeking 8910, HTPro/9811, C7-7800, 6131o, 6131n, AtlasOCAP-1056B01, RCA-RCRP05B and enjoying the ride |
|
Back to top |
|
|
The Robman Site Owner
Joined: 01 Aug 2003 Posts: 21237 Location: Chicago, IL |
Posted: Thu Jun 24, 2010 4:58 pm Post subject: |
|
|
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
www.hifi-remote.com
Please don't PM me with remote questions, post them in the forums so all the experts can help! |
|
Back to top |
|
|
3FG Expert
Joined: 19 May 2009 Posts: 3367
|
Posted: Wed Jun 30, 2010 2:42 am Post subject: |
|
|
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 |
|
Back to top |
|
|
The Robman Site Owner
Joined: 01 Aug 2003 Posts: 21237 Location: Chicago, IL |
Posted: Wed Jun 30, 2010 7:32 am Post subject: |
|
|
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. _________________ Rob
www.hifi-remote.com
Please don't PM me with remote questions, post them in the forums so all the experts can help! |
|
Back to top |
|
|
ElizabethD Advanced Member
Joined: 09 Feb 2004 Posts: 2348
|
Posted: Wed Jun 30, 2010 8:25 pm Post subject: |
|
|
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? _________________ Liz
Tweeking 8910, HTPro/9811, C7-7800, 6131o, 6131n, AtlasOCAP-1056B01, RCA-RCRP05B and enjoying the ride |
|
Back to top |
|
|
The Robman Site Owner
Joined: 01 Aug 2003 Posts: 21237 Location: Chicago, IL |
Posted: Wed Jun 30, 2010 9:13 pm Post subject: |
|
|
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. _________________ Rob
www.hifi-remote.com
Please don't PM me with remote questions, post them in the forums so all the experts can help! |
|
Back to top |
|
|
ElizabethD Advanced Member
Joined: 09 Feb 2004 Posts: 2348
|
Posted: Wed Jun 30, 2010 9:31 pm Post subject: |
|
|
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. _________________ Liz
Tweeking 8910, HTPro/9811, C7-7800, 6131o, 6131n, AtlasOCAP-1056B01, RCA-RCRP05B and enjoying the ride |
|
Back to top |
|
|
The Robman Site Owner
Joined: 01 Aug 2003 Posts: 21237 Location: Chicago, IL |
Posted: Wed Jun 30, 2010 9:42 pm Post subject: |
|
|
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. _________________ Rob
www.hifi-remote.com
Please don't PM me with remote questions, post them in the forums so all the experts can help! |
|
Back to top |
|
|
3FG Expert
Joined: 19 May 2009 Posts: 3367
|
Posted: Fri Feb 04, 2011 2:21 am Post subject: |
|
|
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 |
|
Back to top |
|
|
The Robman Site Owner
Joined: 01 Aug 2003 Posts: 21237 Location: Chicago, IL |
Posted: Fri Feb 04, 2011 11:58 am Post subject: |
|
|
Thanks Dave, I'll have to check it out. _________________ Rob
www.hifi-remote.com
Please don't PM me with remote questions, post them in the forums so all the experts can help! |
|
Back to top |
|
|
3FG Expert
Joined: 19 May 2009 Posts: 3367
|
Posted: Sun Apr 03, 2011 11:37 am Post subject: |
|
|
I've included files through March 31, 2011. About 50 new files since Feb 1.
JP1-Master1.07 |
|
Back to top |
|
|
3FG Expert
Joined: 19 May 2009 Posts: 3367
|
|
Back to top |
|
|
vickyg2003 Site Admin
Joined: 20 Mar 2004 Posts: 7073 Location: Florida |
Posted: Mon Jul 11, 2011 7:09 am Post subject: |
|
|
Thanks Dave. Do you happen to know how many upgrades were added? _________________ Remember to provide feedback to let us know how the problem was solved and share your upgrades.
Tip: When creating an upgrade, always include ALL functions from the oem remote, even if you never plan on assigning them to a button. Complete function lists makes an upgrade more helpful to others.
|
|
Back to top |
|
|
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
|