Robert Heller
Forum Replies Created
-
Forum: Plugins
In reply to: [WebLibrarian] Bulk Upload IssuesOK, there was a bug. The WP DB code *quietly* fails to insert records when fields are over length. (No error is reported!). I updated my code to check and truncate over length fields. You should be able to update the plugin and things will work better.
Forum: Plugins
In reply to: [WebLibrarian] Bulk Upload IssuesWhen I copy-pasted your sample CSV file, the quote marks were UTF-8, not ASCII. I don’t know if that was a side effect of copy and pasting from a webpage or not (I’m guessing yes).
Forum: Plugins
In reply to: [WebLibrarian] Bulk Upload IssuesThe header line does not have any commas.
The field widths are:
barcode varchar(16)
title varchar(128)
author varchar(64)
subject varchar(128)
description text
category varchar(36)
media varchar(36)
publisher varchar(36)
publocation varchar(36)
pubdate date
edition varchar(36)
isbn varchar(20)
type varchar(16)
thumburl varchar(256)
callnumber varchar(36)Forum: Plugins
In reply to: [WebLibrarian] Bulk Upload IssuesIf you are not actually going to use a bar code reader and put bar codes on your books, you probably should just not include the barcode column. The bulk upload with generate unique bar codes. Setting all of the bar codes to the same value will prevent the items from being uploaded.
Question: Does the CSV file include a header line? That is, does the first line itentify the columns and do you enable the header processing? Unless you have the columns in the *correct* order, things are going to work poorly, so it is probably best to use the header processing and include a header line.
I don’t know if Notepad++ has a strict 7-bit ASCII mode, but it is important that the separators (,) and quote marks are the *ASCII* comma and double quote and NOT the UTF-8 characters.
Otherwise, I don’t know. Do you have a short sample from your CSV file that I can look at and/or try to upload to my test site?
Forum: Plugins
In reply to: [WebLibrarian] Bulk Upload IssuesYes, a final check with the text editor is always a good idea.
Forum: Plugins
In reply to: [WebLibrarian] Bulk Upload IssuesHow are you preparing the CSV files? Excel is *notorious* for “misformatting” CSV files. Check the files with a *plain text editor* before uploading. Note for some fields (notably the barcode field) UTF-8 characters will be problematical.
Forum: Plugins
In reply to: [WebLibrarian] Multiple copies of the same bookEach *physical* item in the library needs to have a *unique* bar code. If you have multiple copies of a book, each copy needs to have a different bar code. Don’t use the ISBN or UPC bar codes for your library bar codes.
Forum: Plugins
In reply to: [WebLibrarian] About the reservation logicNo queue. “B” can checkout, even though “A” reserved first.
Forum: Plugins
In reply to: [WebLibrarian] Some more basics inquiry….1. Are there are due date to cancel for a reservation hv been made but patron hv not borrowed that book?
Holds have an expiration date and the loan period for the item is used to compute the expiration date of the hold.
2. Possible to assign different type of patrons with a) different amount of books can be borrowed? b) with differnent days for a book to be borrowed?
This would require major changes to the code.
3) How to modify the number of books can be borrowed? (Now is unlimit)
This would require changes to the code. Probably these changes would be simple.
4) How to modify the number of renewal for each patron? (Now is 3 times)
This would require a change to the code. The renewal count is currently hardwired to 3 in WebLibrarian.php.
Forum: Plugins
In reply to: [WebLibrarian] Date FormatYou will have to edit the file includes/short_codes.php to change the displayed date format.
Forum: Plugins
In reply to: [WebLibrarian] Error display on checkout items?Ok, this looks like a real bug. I suspect I am not carrying some state info into the pagination link code. I’ll have a look and make an update soon.
Forum: Plugins
In reply to: [WebLibrarian] French translationSend them to [email protected]. This will open a ticket, which I will resolve once I merge the files into the plugin.
Forum: Plugins
In reply to: [WebLibrarian] Enquire some basics of this plugin, as a libarian.Yes, the “Hold List” is available as a feature of the Circulation Desk page. There is not “export”, but the Librarian should be able to use the Print function of the web browser to make a hard copy to carry down to the stacks and collect the books on hold and bring them to the hold shelf.
Forum: Plugins
In reply to: [WebLibrarian] Translation to Brazilian PortugueseI believe there already is a brazilian portuguese translation.
Forum: Plugins
In reply to: [WebLibrarian] Issues w/ List Checked Out ItemsI am not able to re-create your problem. Can you give be the *exact* squence to reproduce it?