As I’ve told some people, I have some code to put the info from SFX on what databases (ie SFX ‘targets’) have online coverage for a given serial, on the OPAC page for that serial. I think this is fairly easy improvement you can make with a big impact.
3) You need to get a MySQL account with select permission to your SFX database. If you are the SFX admin, no problem, else you need to convince the SFX admin.
You need to email me and ask for the PHP code that querries the SFX API based on ISSN and provides some HTML suitable for including on the page. Ex Libris asked me not to put the code (which contains proprietary Ex Libris information) on the public web. This code is not supported by Ex Libris or me, although I’m happy to answer questions as my time allows.
One downside is that, since the SFX API is missing some important information (the ‘coverage’ string, like ‘from 1992’ or whatever), I did need to write some code to access the MySQL db directly. This will break in SFX 4.0, I can guarantee. Perhaps by then Ex Libris will have written the neccesary stuff into the API, so this stuff can be re-written using only supported API calls.