Stamp Community Family of Web Sites
Thousands of stamps, consistently graded, competitively priced and hundreds of in-depth blog posts to read
Stamp Community Forum
 
Username:
Password:
Save Password
Forgot your Password?

This page may contain links that result in small commissions to keep this free site up and running.
Welcome Guest! Need help? Got a question? Inherit some stamps?
Our stamp forum is completely free! Register Now!

Philatelic Foundation Database And Submission Research

Previous Page | Next Page    
 
To participate in the forum you must log in or register.
Author Previous TopicReplies: 100 / Views: 2,967Next Topic
Page: of 7
Pillar Of The Community
United States
6559 Posts
Posted 01/31/2023   1:06 pm  Show Profile Bookmark this reply Add Cjd to your friends list  Get a Link to this Reply
Anyone see a difference in their potential liability if they are only promising to say "yes" or "no" to a particular inquiry, rather than undertaking to promise to identify the most-valuable possibility?

(No affiliation.)
Send note to Staff  Go to Top of Page
Bedrock Of The Community
10109 Posts
Posted 01/31/2023   2:36 pm  Show Profile Bookmark this reply Add rogdcam to your friends list  Get a Link to this Reply
I fail to see how the PF has much liability either way given that they only express opinions.
Send note to Staff  Go to Top of Page
Pillar Of The Community
Learn More...
United States
5759 Posts
Posted 01/31/2023   5:16 pm  Show Profile Check revenuecollector's eBay Listings Bookmark this reply Add revenuecollector to your friends list  Get a Link to this Reply

Quote:
I fail to see how the PF has much liability either way given that they only express opinions.


... and unlike APEX, the PF does not back its opinions with any form of money-back guarantee. I say that not as a criticism of the PF; what APEX offers in this regard is very unusual for the expertizing field.
Send note to Staff  Go to Top of Page
Pillar Of The Community
Learn More...
United States
5759 Posts
Posted 01/31/2023   5:27 pm  Show Profile Check revenuecollector's eBay Listings Bookmark this reply Add revenuecollector to your friends list  Get a Link to this Reply

Quote:
The catalog number cannot be a Primary key in a database since it is not a unique number. Typically, you add an 'ID' field as the Primary key field and let the database assign its own unique ID numbers. And you almost always keep this ID field hidden from users since they do not need to know it and the DB indexes on it.


In this case, couldn't the cert number be the primary key rather than the catalogue number? I believe cert numbers are unique.

I actually don't see a problem with the PF's database per se; the problem is the formatting of the data from said database and how it is presented to the public.

Even simplifying the presentation to something along the lines of:


Quote:

Stamp submitted as: Scott #R97a, $15 blue, imperforate
Stamp actually is: Scott #R97a
Expertizer comments: Genuine in all respects.



Quote:

Stamp submitted as: Scott #1193a, error of color
Stamp actually is: Scott #1193, normal stamp
Expertizer comments: You're blind as a bat. The color is all wrong for an 1193a. Try again, doofus.
Send note to Staff  Go to Top of Page
Moderator
Learn More...
United States
11596 Posts
Posted 01/31/2023   6:11 pm  Show Profile Check 51studebaker's eBay Listings Bookmark this reply Add 51studebaker to your friends list  Get a Link to this Reply

Quote:
...couldn't the cert number be the primary key rather than the catalogue number?...

Yes.
Although a really good certification DB, in my opinion, would also support a certification revisions. This would then prevent the cert number from being a primary key field.

I also agree that there is a significant delineation between developing a brand-new PF DB and simply working with what they have to develop better queries and reports.

It is not rocket science to develop a much better filtering capability into the existing PF DB (assumption being that it is a MSSQL DB).
Here is a screen shot of what I have done, as a single development volunteer on the PSE DB on Stamp Smarter, in implementing a good filtering capability. (click on image to see full size)

Users can build as complex filter as they desire. There are literally thousands of custom questions that can be asked of the certification data, limited only by the user's imagination.
The screen capture above shows a filter I built in 30 seconds which returns all 613 certs that are;
- genuine
- used stamps
- and have a cert date before 1/30/2021

It does not take a huge budget, it does not take hiring an expert.

https://stampsmarter.org/public/PSECertFUSA.php
Don
Send note to Staff  Go to Top of Page
Pillar Of The Community
United States
6559 Posts
Posted 01/31/2023   7:48 pm  Show Profile Bookmark this reply Add Cjd to your friends list  Get a Link to this Reply

Quote:


Stamp submitted as:
Scott #1193a, error of color
Stamp actually is: Scott #1193, normal stamp
Expertizer comments: You're blind as a bat. The color is all wrong for an 1193a. Try again, doofus.


If you're thinking of a kickstarter, let us know...I'll buy in.
Send note to Staff  Go to Top of Page
Pillar Of The Community
United States
8755 Posts
Posted 01/31/2023   8:41 pm  Show Profile Bookmark this reply Add revcollector to your friends list  Get a Link to this Reply

Quote:
You're blind as a bat. The color is all wrong for an 1193a. Try again, doofus.


This might prove useful......
Send note to Staff  Go to Top of Page
Pillar Of The Community
Learn More...
United States
5759 Posts
Posted 01/31/2023   8:45 pm  Show Profile Check revenuecollector's eBay Listings Bookmark this reply Add revenuecollector to your friends list  Get a Link to this Reply
In restrospect, I should have used R13e for that example. The number of milky blue R13c being offered as R13e by national (non-revenue) dealers and even auction houses drives me up the wall.
Send note to Staff  Go to Top of Page
Valued Member
Japan
270 Posts
Posted 02/13/2023   12:55 pm  Show Profile Bookmark this reply Add Stephen-P to your friends list  Get a Link to this Reply
Rogdcam said:

Quote:
IMO what you are seeing reflects the reality of people sending stamps in for certificates that they think are a valuable type, whether faked/altered or misidentified, when they are actually the more common stamp. Human nature dictates folks running to submit when they think they have hit the jackpot.


I absolutely agree with this. But most certainly the obverse should be true as well, or at least much more prevalent that what we see now. Searching varieties like the "Dot in U" is proof of that.
Send note to Staff  Go to Top of Page
Valued Member
Japan
270 Posts
Posted 02/13/2023   1:01 pm  Show Profile Bookmark this reply Add Stephen-P to your friends list  Get a Link to this Reply
Does anybody know if I can use a credit card to pay for the charges after an evaluation has taken place? I've emailed the PF numerous times on both their site and personal address over the span of three weeks regarding this matter but have yet to get a reply.
I'm in a place where it's almost impossible to get a hold of USD, so I haven't been able to submit anything yet.
Send note to Staff  Go to Top of Page
Pillar Of The Community
Learn More...
United States
762 Posts
Posted 02/13/2023   3:37 pm  Show Profile Bookmark this reply Add jleb1979 to your friends list  Get a Link to this Reply

Quote:
Does anybody know if I can use a credit card to pay for the charges...?


I ask every time I need to send something in, hoping.... But when I inquired earlier this month, the PF assured me they do not accept credit cards.
Send note to Staff  Go to Top of Page
Pillar Of The Community
Learn More...
United States
5759 Posts
Posted 02/13/2023   6:14 pm  Show Profile Check revenuecollector's eBay Listings Bookmark this reply Add revenuecollector to your friends list  Get a Link to this Reply

Quote:
But when I inquired earlier this month, the PF assured me they do not accept credit cards.


The PF, much like Amos Media, is poised, ready to leap into the 1990s!
Send note to Staff  Go to Top of Page
Pillar Of The Community
United States
1661 Posts
Posted 02/13/2023   8:25 pm  Show Profile Bookmark this reply Add cjpalermo1964 to your friends list  Get a Link to this Reply
Rather than being backwards, it's likely more about excluding the risk of a chargeback. Many organizations that provide services with a non-zero dispute or complaint rate will only accept non-reversible payment methods.
Send note to Staff  Go to Top of Page
Pillar Of The Community
547 Posts
Posted 02/13/2023   8:28 pm  Show Profile Bookmark this reply Add StateRevs to your friends list  Get a Link to this Reply

Quote:
The PF, much like Amos Media, is poised, ready to leap into the 1990s!


Try checking their MySpace page for updates?
Send note to Staff  Go to Top of Page
Bedrock Of The Community
10109 Posts
Posted 02/13/2023   8:29 pm  Show Profile Bookmark this reply Add rogdcam to your friends list  Get a Link to this Reply
PSE, APEX and PSAG all accept CC payment.
Send note to Staff  Go to Top of Page
Page: of 7 Previous TopicReplies: 100 / Views: 2,967Next Topic  
Previous Page | Next Page
 
To participate in the forum you must log in or register.


Go to Top of Page
Disclaimer: While a tremendous amount of effort goes into ensuring the accuracy of the information contained in this site, Stamp Community assumes no liability for errors. Copyright 2005 - 2023 Stamp Community Family - All rights reserved worldwide. Use of any images or content on this website without prior written permission of Stamp Community or the original lender is strictly prohibited.
Privacy Policy / Terms of Use    Advertise Here
Stamp Community Forum © 2007 - 2023 Stamp Community Forums
It took 0.24 seconds to lick this stamp. Powered By: Snitz Forums 2000 Version 3.4.05