JP1 Remotes Forum Index JP1 Remotes


FAQFAQ SearchSearch 7 days of topics7 Days MemberlistMemberlist UsergroupsUsergroups RegisterRegister
ProfileProfile Log in to check your private messagesLog in to check your private messages Log inLog in

Upgrade Files - Cross Reference - jp1-master
Goto page Previous  1, 2
 
Post new topic   Reply to topic    JP1 Remotes Forum Index -> Code Search
View previous topic :: View next topic  
Author Message
tranx



Joined: 13 May 2012
Posts: 682
Location: Hants, UK

                    
PostPosted: Thu Nov 26, 2015 4:20 am    Post subject: Reply with quote

Thanks very much for the update which also acts as a useful reminder. Reckon the XLS makes it easier to find the right file and not to overlook it if it is present. I tried a couple of links which worked perfectly.
Back to top
View user's profile Send private message
3FG
Expert


Joined: 19 May 2009
Posts: 3365

                    
PostPosted: Mon Oct 05, 2020 2:35 am    Post subject: Reply with quote

JP1Master-1.16 has been uploaded.
Back to top
View user's profile Send private message
The Robman
Site Owner


Joined: 01 Aug 2003
Posts: 21211
Location: Chicago, IL

                    
PostPosted: Mon Oct 05, 2020 10:41 am    Post subject: Reply with quote

Thanks for the update Dave, I use this thing almost every day!
_________________
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
View user's profile Send private message Visit poster's website
Barf
Expert


Joined: 24 Oct 2008
Posts: 1402
Location: Munich, Germany

                    
PostPosted: Sat Mar 25, 2023 9:08 am    Post subject: Reply with quote

Two and a half years since last update... Crying or Very sad Sad
Back to top
View user's profile Send private message Send e-mail Visit poster's website
3FG
Expert


Joined: 19 May 2009
Posts: 3365

                    
PostPosted: Mon Mar 27, 2023 1:30 am    Post subject: Reply with quote

OK, here's JP1Master 1.17

The good news is that it only took 1 hour to download all of the Device Upgrades, excepting Wav, UEI, and Slingbox. Computers and servers apparently do get faster. Even better, the whole process only failed on one file, and that is much improved compared to earlier scraping.

The bad news for me is that I no longer have Excel on my personal computer, and I had to jump through some hoops to just move the CSV file via email to my work computer. Then I had to make some minor changes to the VBA code in Excel to work on a 64 bit OS. I don't know how much longer it will be possible to do this scraping without a complete rewrite--which I'm not inclined to do.

Roughly counting, there were 190 new or revised upgrades in the last 2.5 years.
Back to top
View user's profile Send private message
The Robman
Site Owner


Joined: 01 Aug 2003
Posts: 21211
Location: Chicago, IL

                    
PostPosted: Mon Mar 27, 2023 8:58 am    Post subject: Reply with quote

Thanks Dave, I use this file extensively, so this is much appreciated.

Was there something about the file that broke it that I can fix?
_________________
Rob
www.hifi-remote.com
Please don't PM me with remote questions, post them in the forums so all the experts can help!


Last edited by The Robman on Mon Mar 27, 2023 3:49 pm; edited 1 time in total
Back to top
View user's profile Send private message Visit poster's website
Barf
Expert


Joined: 24 Oct 2008
Posts: 1402
Location: Munich, Germany

                    
PostPosted: Mon Mar 27, 2023 3:20 pm    Post subject: Reply with quote

Thank you very much Dave! Cool I use it within RemoteLocator (which is a tool embedded in IrScrutinizer, Pane Import -> RemoteLocator. It allows to browse and sometimes download remotes from the the JP1 collection, Lirc, Irdb and my own GirrLib.)

Migrating away from Microsoft Office to free software is a good thing. Have you tried if it works with LibreOffice Calc? Another free alternative may be Gnumeric.
Back to top
View user's profile Send private message Send e-mail Visit poster's website
3FG
Expert


Joined: 19 May 2009
Posts: 3365

                    
PostPosted: Mon Mar 27, 2023 8:04 pm    Post subject: Reply with quote

The JP1Scraper program has been in the File Section for years, but I see that I had omitted a necessary DLL. I also revised the instructions a bit, so I've uploaded again.
JP1Scraper V5.

Barf, I use LibreOffice at home, but JP1master.xls uses Visual Basic for Application code. LibreOffice also has a macro language but it is not compatible with VBA.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic       JP1 Remotes Forum Index -> Code Search All times are GMT - 5 Hours
Goto page Previous  1, 2
Page 2 of 2

 
Jump to:  
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
Top 7 Advantages of Playing Online Slots The Evolution of Remote Control