OrdaSoft forum
Welcome, Guest
Please Login or Register.    Lost Password?
Add some user defined fields (0 viewing) 

BookLibrary Wishlist

Go to bottom Favoured: 5

Add some user defined fields

admin (Admin)
Admin
Posts: 8228
graph
User Offline Click here to see the profile of this user
Re:Add some user defined fields 13 Years, 6 Months ago
Karma: 101  
Hello,

I understand why you need DCN in BookLibrary.

Please reply why you can't use BookId for add DCN number

Thanks,
OrdaSoft team
Logged Logged
The administrator has disabled public write access.
TtfnJohn (User)
Fresh Boarder
Posts: 6
graphgraph
User Offline Click here to see the profile of this user
Gender: Male St john The Evangelist Chuch Location: Ladysmith, BC, Canada Birthdate: 1953-03-06
Re:Add some user defined fields 13 Years, 6 Months ago
Karma: 0  
Thanks for your quick response.

My major concern, after looking at (not changing!) the database structure is that the bookid appears to be shared through tables such as lend, requests, lending and review tables though when I checked again today the column name is different (fk_bookid) than in the main table. The other concern has been that while bookid in the main table is text field the other tables show it as an integer field which leads me to believe they're not "connected" that way.

As long as it doesn't mess up anything I'll be more than happy to use it!

Of course, I'll have to search through the display code to change the field name there but that's a pretty minor thing as book id works for that too.

Thanks again!

ttfn

John
Logged Logged
The administrator has disabled public write access.
TtfnJohn (User)
Fresh Boarder
Posts: 6
graphgraph
User Offline Click here to see the profile of this user
Gender: Male St john The Evangelist Chuch Location: Ladysmith, BC, Canada Birthdate: 1953-03-06
Re:Add some user defined fields 13 Years, 6 Months ago
Karma: 0  
Just a little note:

It works provided you don't cut and paste the DCN number you may retrieve from the US Library of Congress.

While that is an invaluable resource when just about anything else fails it returns the DCN formatted like this "242/.8/0096 20" which causes an error complaining about the entry not being numberic. There's probably a restriction on the field (column in MySQL and other RDBMS speak) that non numeric characters aren't allowed. After checking elsewhere this translates into 242.80096.

For those using the DBN another excellent source for the number is classify.oclc.org which is where I discovered that what LC seems to be saying is that anything after the "/" is optional while what's after the spaces can be dropped.

Thanks again for your reply! I don't know if you have the time (or energy) to add this to a FAQ about shelving numbers (DCN) as opposed to selling numbers (ISBN) but I can tell you that the Library of Congress has failed me exactly once when looking up a rare, out of print book. catalog.loc.gov/webvoy.htm
Logged Logged
The administrator has disabled public write access.
admin (Admin)
Admin
Posts: 8228
graph
User Offline Click here to see the profile of this user
Re:Add some user defined fields 13 Years, 6 Months ago
Karma: 101  
Hello,

May be I not full understand you but:
BookId - at main book library interfaces (when you create new book) means any characters row with limit 20 sings and you can fill to it "242/.8/0096 20".
That special for any inner book library identification.
Very often this field not need for small library so for uses we added to BookLibrary Pro version in Backend setting parameter "BookID auto-increment"- "yes/no". So if you want type any value to this field you must set "BookID auto-increment" - "no"

In Database tables, BookID in main BookLibrary table - that "BookID" what you see at time Book creation(for fill any characters row). In other BookLibrary tables BookId - that reference to field ID in main bookLibrary table.
Because that these fields have different format.

Thanks,
OrdaSoft team
Logged Logged
The administrator has disabled public write access.
TtfnJohn (User)
Fresh Boarder
Posts: 6
graphgraph
User Offline Click here to see the profile of this user
Gender: Male St john The Evangelist Chuch Location: Ladysmith, BC, Canada Birthdate: 1953-03-06
Re:Add some user defined fields 13 Years, 6 Months ago
Karma: 0  
I still had the silly thing set to yes which is probably why it was complaining about duplicates, too. Not that the DCN system allows for duplicates. Of course not!

I wish this was a small library, it should be at a small rural church, but it isn't after a former rector and retired Bishop donated his entire collection of about 300 books to the church.

In a town of 7,000 we'll probably have more books than the local public library!

Thanks for your help and suggestions.
Logged Logged
The administrator has disabled public write access.
admin (Admin)
Admin
Posts: 8228
graph
User Offline Click here to see the profile of this user
Re:Add some user defined fields 13 Years, 6 Months ago
Karma: 101  
Hi ,

For remove duplication check in bookLibrary for BookID - please go to {yours host}/components/com_booklibrary/
create backup for file booklibrary.class.php

after that go to this file, find and remove below code

Code:

$this->_db->setQuery( "SELECT id FROM #__booklibrary "
. "nWHERE bookid='$this->bookid'");
$xid = intval( $this->_db->loadResult() );
if ($xid && $xid != intval( $this->id )) {
$this->_error = _BOOKLIBRARY_ADMIN_INFOTEXT_JS_EDIT_BOOKID;
return false;
}



Thanks,
OrdaSoft team
Logged Logged
The administrator has disabled public write access.
Go to top
»