Page 1 of 2

Ranfft Database

Posted: January 26th, 2021, 5:20 pm
by atkin68
I sent an email to Dr. Ranfft today asking if it was possible to get the data tables that feed his movement archive so that I could filter/query on specific fields. For example, at the moment I'd love to be able to query his data to find all PW movements with an outside diameter of >34mm and <40mm, which have an hour hand size of X and minute hand size of Y. Then I'd be able to search ebay a little more effectively in my hunt for cool movements which I know I can get hands for...

Anyway, wondering if anything like this has been attempted by anyone here. I will post back if and when I get a reply from Ranfft.

Dave

Re: Ranfft Database

Posted: January 26th, 2021, 5:35 pm
by straps68
select * from CoolMovements where AvailableHands = yes

:thumbup:

Re: Ranfft Database

Posted: January 26th, 2021, 7:41 pm
by blueradish
Awesome idea, really hope it works out. I don't know of anyone that has attempted this.

Re: Ranfft Database

Posted: January 28th, 2021, 4:19 am
by djolemag
You have advanced search on Ranfft site...

Sent from my P30 using Tapatalk


Re: Ranfft Database

Posted: January 28th, 2021, 12:55 pm
by atkin68
djolemag wrote: January 28th, 2021, 4:19 am You have advanced search on Ranfft site...

Sent from my P30 using Tapatalk
Never noticed it, how silly of me. It's a very cool set of criteria he has provided in the advanced search, but unfortunately doesn't include the ability to filter for hand hole sizes - my primary concern at the moment. Still, this will be very useful - thanks for pointing it out!

Re: Ranfft Database

Posted: January 28th, 2021, 4:01 pm
by djolemag
You can search by hole size... Just type exactly ad it says in some movement info, e. g. "1.50x0.90 mm"
It works😊

Re: Ranfft Database

Posted: January 29th, 2021, 10:27 am
by Emilio
djolemag wrote:You can search by hole size... Just type exactly ad it says in some movement info, e. g. "1.50x0.90 mm"
It worksImage
Thanks for the tip

Re: Ranfft Database

Posted: January 30th, 2021, 4:41 pm
by djolemag
Emilio wrote:
djolemag wrote:You can search by hole size... Just type exactly ad it says in some movement info, e. g. "1.50x0.90 mm"
It worksImage
Thanks for the tip
WelcomeImage

Sent from my P30 using Tapatalk


Re: Ranfft Database

Posted: January 31st, 2021, 9:54 am
by Yoda
We have this here in the "library":
Radiomires Watch Maker Notes.jpg

Re: Ranfft Database

Posted: January 31st, 2021, 10:16 am
by djolemag
Ok, let me add mainsprings...
Mainsprings – Watch Reference Database.pdf
Sent from my P30 using Tapatalk