Activity for Fred LaPlante

  • Fred LaPlante Fred LaPlante posted a comment on discussion Help

    Try this: SELECT bibid, title, author FROM biblio WHERE bibid NOT IN (SELECT bibid FROM biblio_field WHERE tag=520) Fred LaPlante, WA1DLZ On 1/3/2018 10:38 AM, Alexander Anderson wrote: Dear Forum, This is a problem in SQL. I am wanting to get a list of all the books in our database that DON'T have any blurb entered for them. That's to say, in the web interface, the field "Summary, etc. note" has nothing in it. Most book entries in our database do have a blurb. With such an automatically generated...

  • Fred LaPlante Fred LaPlante posted a comment on discussion Help

    Good! glad to hear it. Sorry about the mess. Incidentally, while you can have more than one host selected, it really doesn't work out too well. Fred LaPlante, WA1DLZ On 8/19/2017 11:46 AM, Alexander Anderson wrote: I just did your amendment, as you described. I had to add yet another field, "schema", with the same doodads as "context", and "Tada!" I can switch hosts on and off as a library admin, just using OpenBiblio's interface. Thanks for the instructions. Sandy Installation Woes Sent from sourceforge.net...

  • Fred LaPlante Fred LaPlante posted a comment on ticket #92

    Hans, I think I recall that Jane found that ERROR class is not the same in PHP7 and she had to make some serious changes to get past that. You might wandt to ask her about it. Fred

  • Fred LaPlante Fred LaPlante posted a comment on discussion Help

    Thanks, that will be a big help. I have been having some luck running down various pamphlets, etc that lack ISBN or other identifying numbers. I have to use multiple keywords, and publisher name and date, etc. Sometimes it works, sometimes not. A bigger sample wouldt be useful. Fred

  • Fred LaPlante Fred LaPlante posted a comment on discussion Help

    Sandy, Would you send me a few Titles and authors, etc that define some of the various Herbal publications you were not likely to find at US LoC. I would like to do some investigation about if they do inded have those publications and How one could get information on them. Perhaps I could add to the lookup mechanism for other to use. Fred

  • Fred LaPlante Fred LaPlante posted a comment on discussion Help

    Indeed some are fussy that way. In fact some only respond to SRU via Z.3950. Visit the host web site for additional information on what they will support. If you are using a linux hosted server, YAZ is pretty easy to install, on Windows, it's hopeless.

  • Fred LaPlante Fred LaPlante posted a comment on discussion Help

    Hi, I bet if you checked the date on the various files in the ..../mysql/data folder you would find some of them (especially ib****) are recent. They are from use of nySql's inodb engine instead of the normal myisam engine. So some of your OB data is there and not in the openbiblio folder. You can see which is which by simple scan of the openbiblio folder content to see which tables are missing (they are combined in a ibdata file instead). Or you can look at phpMyadmin. Click on openbiblio in the...

  • Fred LaPlante Fred LaPlante posted a comment on discussion Help

    My solutions is to stop MySQL, then copy the entire mysql data folder to some other place. I copy the entire folder (not just the OB dat sub-folder) because my installation has some tables stored as my Isam while others are InnoDb (not my intent, but I discovered it too late). Then I restart MySql. I do this wekly, after loosing everything during the winter.

  • Fred LaPlante Fred LaPlante posted a comment on discussion Help

    I do not know about ver 0.7+, but v1.0-wip does, if enabled under Library Settings. If photos are enabled, then they show up on biblio searches both locally and via OPAC. Even have an app that will provide a paginated display of all book cover photos (user request). In fact I have spent the last few days adding code to allow you to dal with the case of having more than one camera (like a laptop with a builtin, plus an external camera used for book photos). Before I started this last exercise I had...

  • Fred LaPlante Fred LaPlante posted a comment on discussion Help

    For Question #1, the answer is 'MAYBE, it depends'. If work was slow, and there was never a case with two workers making db submissions simultaneously, all would be well. But MySQL's myisam engine does not do locks well and corruption is a possibillity. On the other hand OB was written to allow a cataloger and a checkout person to be working at the same time. But you should be able to do a quick test yourself. Bring up two sessions of OB on seperate browser windows, and attempt to do search or submits...

  • Fred LaPlante Fred LaPlante posted a comment on ticket #92

    Having gone through the move from mssql to mysqli to PDO, let me say that the last was as much work as the first. If I had to do it again, I would skip over mysqi altogether.

  • Fred LaPlante Fred LaPlante posted a comment on discussion Help

    The closest thing I have to that is a multi-volume set,(boxed or not). I enter the set as a single 'book' and then make a one copy to correspond to each volume with it's subtitle in the copie's description field. Down side of that is that a search will only find the 'book' title, not the individual volumes/copies. There is a method in ver 1-wip to handle bound 'papers' and have the individual papers be searchable. Only person I know of doing that is Neil Redgate of Scotland (in fact it was added...

  • Fred LaPlante Fred LaPlante posted a comment on discussion Help

    Release date? I have no idea. I have been trying to get that for a while now. Ver 1-wip (or alpha) is in use now in a couple of locations that I know of. All by peolpe that have some programming skills, though all would resent being called programmers. One in Scotland, one in Ireland, one in Louisiana US one in Oregon US, perhaps one in China, and me in Maine US. Each of these people found a spurt of bugs because they all use it differently. Most added (or got me to add) features unique to their...

  • Fred LaPlante Fred LaPlante posted a comment on discussion Help

    Frankly I had never considered such a limitation as the z39.50 specs imply no limit to the number of parameters. So no, at this time ver 1 would have the very same issue and it would be up to the user to limit themselves to a single parameter. Actually I think that would be a major limitation on searches. When I enter only the title, I sometimes get hundreds of hits. One search with only a title the other day responded with 3200 hits!!!. Seems to me I have the limit set to something like 50, but...

  • Fred LaPlante Fred LaPlante posted a comment on discussion Help

    Without visiting the libraries web site to see what is supported, it looks to me like they do not support a search by author (1004 code). Of course it might be that they simply allow only a single parameter search. Have you tried a search by title only, or by ISBN or ISSN?

  • Fred LaPlante Fred LaPlante posted a comment on discussion Help

    I believe that XAMPP gives you the choice of php7 or php 5. I suggest you stick to php 5. Also, I think you will be better off if you set the default database engine to be MyIsam instead of InnoDb.

  • Fred LaPlante Fred LaPlante posted a comment on discussion Help

    Here is a good way to find a list of available repositories with connect info. http://irspy.indexdata.com/find.html specifying 'United Kingdom' and protocol z39.50 got me 10 libraries.

  • Fred LaPlante Fred LaPlante posted a comment on discussion Help

    Lots of info on this topic doing a Google search of "map MARC tags to MODS xml". Many references to using MarcEdit.

  • Fred LaPlante Fred LaPlante posted a comment on discussion Help

    Well the best writeup I have seen is at https://www.loc.gov/standards/mods/v3/mods2marc-mapping.html which I have just discovered. So it looks like my earlier statement saying no map existed was wrong. But this is only a start. It would be nice if te YAZ package included this map as a built-in function. Seems a bit more research is needed. Glad to see that the British Library and Aberdeen were of some help.

  • Fred LaPlante Fred LaPlante posted a comment on discussion Help

    I believe there are several sites in UK that you can use. Those listed in Lookup are just those that have been reported to me at one time or another. Any that are in the list that you do not use can be deleted by you. When you do find a good MARC site in UK, please let me know and I will add it to the ver 1.0 list. Here is more info on COPAC for you: http://copac.jisc.ac.uk/developers/z39.50//#connect I put them into the host list years ago because someone reported them to me - perhaps their policy...

  • Fred LaPlante Fred LaPlante posted a comment on discussion Help

    Sure, you can use phpMyAdmin or equiv to simply change the 'active' field of the pertinent row in table 'Lookup_hosts'. But as I mentioned earlier, COPAC does not support MARC tags (via Z39.50 or SRU). They only provide an XML output which OB cannot handle as there is no way to map the results to the atabase. So other than using an online search via normal browser means and then manually posting data to OB, you are out of luck with COPAC and any other that doesnt support MARC tags.

  • Fred LaPlante Fred LaPlante posted a comment on discussion Help

    It just occurred to me that you might really want to use the DOI mechanism for your Herbalism papers. Especially if they are usually published as pamphlets rather than 'books'. That would definately be the cae for County Agricultural Extension service here in the States. For that you would have to go to ver 1.0 where it was added at Mr. Redgate's request. A mechanism for handling 'books' that are collections of published papers, each of which needs seperate identity, was also added for him.

  • Fred LaPlante Fred LaPlante posted a comment on discussion Help

    A few years ago I worked with with Neil redgate of Nothern Scotland. He is using ver 1.0 and instigated a large number of the features that ver 1 now has. He too wanted to use COPAC for all his Envirenmental publications. Unfortunately COPAC (as I recall) did not support Z39.50 which OB is based upon, but uses XML instead. That might be OK, but we were unable to find a map of the XML tags to Z39.50 tags. But ver 1.0 has the setup data for COPAC and it shows the syntax as 'dc'. I believe that 'context'...

  • Fred LaPlante Fred LaPlante posted a comment on discussion Help

    Release of ver 1.0 is not up to me. You need to talk with Hans. As I mentioned before, it is usable at this time depending on which features are imporrtant to you. I can think of 6 libraries that are currently using it. Many others have enquired, but I have not heard that they ever put it in production. I have never used book barcodes, though I do have them auto-created. Since they are just a number, you could simply write them on the inside of the cover (perhaps along with the call no in case it...

  • Fred LaPlante Fred LaPlante posted a comment on discussion Help

    Hmmm, unless the copy of Lookup you have is WAY out of date (it could be) you should only have had to enter: Title 'Bill Clinton', and author 'Hamilton, Nigel' to see a list of all possibilities. From the hit list you would simply click on the closest match to your holding. Much quicker. The help package is pretty minimal and altogether current. Help is best written by people other than the developers. They 'know it all already' and are frequently wrong. Now if you want to volunteer...?

  • Fred LaPlante Fred LaPlante posted a comment on discussion Help

    I have found that in the last ten years or so that a lookup by ISBN is largely pointless. There are so many editions of any work, each with its own ISBN code that the chances that LoC has a copy on file is near to zero. I usually do my lookups by Title and author and then enter the correct isbn by hand.

  • Fred LaPlante Fred LaPlante posted a comment on discussion Help

    I can see why you are perplexed. Only solution that I see is to keep the the most recent version of each file in the lookup2 folder and ignore the rest. Fred LaPlante, WA1DLZ On 5/2/2017 6:46 AM, Alexander Anderson wrote: Dear Fred LaPlante, I understand OpenBiblio 0.7x is a long time ago for you. But I'm so close to the finish line for installing lookup_2010-10-28 (Lookup2). I wonder if I can get some good guesses and suggestions for what to do if I showed the name clash details. It might jog some...

  • Fred LaPlante Fred LaPlante posted a comment on discussion Help

    It is certainly available to anyone that wants to try it. Weather it suits you is hard to say; There are bugs in in that may or may not effect you, depending on how you use it. The user interface is definitely different, but should present no problems. Installation is VERY different - just place code into a folder under your web server and access OB from your browser, program will detect first time run and take you from there. Best way to find if it suits you is to download a copy and try it for...

  • Fred LaPlante Fred LaPlante posted a comment on discussion Help

    Hi Sandy, Lookup 2 is fairly long in the tooth I am afraid. I am not sure where the sourceForge copy went. But I do have an archival copy of what appears to be the last version I uloaded to SourceForge. I will try to attach it here. I haven't used OB v0.7+ in a VERY long time and do not have a copy installed here to test with. Good luck with it. I use developmental version of OB 1.0 which has lookup integrated into it. Fred LaPlante

  • Fred LaPlante Fred LaPlante posted a comment on discussion Help

    The ID and PW you show above are for OB's database access. They are NOT for user...

  • Fred LaPlante Fred LaPlante posted a comment on discussion Development

    Seems to me to be a setup for easy book theft. If no one is watching people exit,...

  • Fred LaPlante Fred LaPlante posted a comment on discussion Development

    Hi Jane, Glad to see you are still at it.

  • Fred LaPlante Fred LaPlante posted a comment on discussion Help

    Your 2nd and 3rd errors are simply because you got the first message. Search your...

  • Fred LaPlante Fred LaPlante posted a comment on discussion Help

    By the way, that error report reads from the bottom up. the top-most line is the...

  • Fred LaPlante Fred LaPlante posted a comment on discussion Help

    Oh, one more thing. Some of the tables may now have data. I do not recall the v0.7...

  • Fred LaPlante Fred LaPlante posted a comment on discussion Help

    Well, being of the paranoid persuasion, I think I would repeat the entire process...

  • Fred LaPlante Fred LaPlante posted a comment on discussion Help

    Hi Ralph, I do not have a working 0.71 system unfortunately. Otherwise I would send...

  • Fred LaPlante Fred LaPlante posted a comment on discussion Help

    The 'new' you report as a table in phpMyAdmin is not a table but just a link to let...

  • Fred LaPlante Fred LaPlante posted a comment on discussion Help

    Yup, thought so. On my own home system I do "sudo chmod 0777 -R < path to your openbiblio...

  • Fred LaPlante Fred LaPlante posted a comment on discussion Help

    I wonder if there is a permissions issue on the OpenBiblio directory at the server?...

  • Fred LaPlante Fred LaPlante posted a comment on discussion Development

    Audience Level is an artifact of the customer base of the original developer of ver...

  • Fred LaPlante Fred LaPlante posted a comment on discussion Development

    In the original design those strings peculiar to a particular plugin go in the .tran...

  • Fred LaPlante Fred LaPlante posted a comment on discussion Development

    I do not believe that the installation program has ever been tested to enter sample...

  • Fred LaPlante Fred LaPlante posted a comment on discussion Development

    easiest way is to use input type=url for entry. supported in most browsers these...

  • Fred LaPlante Fred LaPlante posted a comment on discussion Development

    Looks good so far. You seem to have found most of the major features. Some will not...

  • Fred LaPlante Fred LaPlante posted a comment on discussion Development

    Done. Fred LaPlante, WA1DLZ On 3/24/2016 12:39 PM, Jane Sandberg wrote: Thanks! My...

  • Fred LaPlante Fred LaPlante posted a comment on discussion Development

    Documentation is so badly needed, that any place that makes sense to you would be...

  • Fred LaPlante Fred LaPlante posted a comment on discussion Development

    If you will sign up as a BitBucket user, I will read/write privileges and you can...

  • Fred LaPlante Fred LaPlante posted a comment on discussion Development

    Sounds good to me. Rare to meet someone here that is willing to modify OB code to...

  • Fred LaPlante Fred LaPlante posted a comment on ticket #65

    This is my third attempt to get thru to you. Lets hope that SF is playing nicely...

  • Fred LaPlante Fred LaPlante posted a comment on discussion Help

    Jason, I have online search (Lookup v2) working here with OB 0.7.1. contact me directly...

  • Fred LaPlante Fred LaPlante posted a comment on discussion Development

    Well I'm impressed! I spent enough time looking into similar changes for v1.0 that...

  • Fred LaPlante Fred LaPlante posted a comment on discussion Help

    Yes, you certainly can. But you will have to know the name or address of the machine...

  • Fred LaPlante Fred LaPlante posted a comment on ticket #65

    I'm sorry but that feature will not be available until ver 1.0 which is still a 'work...

  • Fred LaPlante Fred LaPlante posted a comment on ticket #64

    I think you got the installation nearly correct. Much had to be correct in order...

  • Fred LaPlante Fred LaPlante posted a comment on discussion Help

    Those with circulation privileges can NOT modify the catalog content in ANY way....

  • Fred LaPlante Fred LaPlante posted a comment on discussion Help

    As currently written, checkouts can be done by those people included as 'staff' and...

  • Fred LaPlante Fred LaPlante posted a comment on discussion Development

    Hi Alex, I'm probably the primary cuse of the problem, though I did have help at...

  • Fred LaPlante Fred LaPlante posted a comment on discussion Help

    My OB, both ver 0.71 and 1.0 are running on Ubuntu 13.04 which itself is hosted by...

  • Fred LaPlante Fred LaPlante posted a comment on discussion Help

    First off, OB will definately run under Linux with Apache and MySQL. That is perhaps...

1