Attaching files to catalog records

Users can upload documents (e.g. pdf, text, doc etc.) while cataloging with Koha version 3.22.x. Uploaded documents store in internal directory and the link add in 856$u tag. The main advantage is that no need to store files in external storage places like Google Drive and Dropbox.


Little tweaks are necessary on Koha system to make available this feature. Follow the steps:

Set upload path

1. Check Koha > About Koha > System information. Check the following warning.
2. Open koha-conf.xml file with your favorite editor and place destination directory.

leafpad /etc/koha/sites/library/koha-conf.xml

Place following line below, <docdir>/usr/share/doc/koha-common</docdir>

<upload_path>/var/lib/koha/library/uploads/</upload_path>

3. Restart Apache 

/etc/init.d/apache2 restart

4. Check again Koha > About Koha > System information. No warning message, if destination folder is ready,

Assign OPACBaseURL

Search for OPACBaseURL in Koha > Administration > Global system preferences

e.g. http://mgucat.mgu.ac.in
e.g. http://127.0.1.1

Add upload.pl plug-in in Bibliographic framework

Goto Administration > MARC Bibliographic Framework > Books, Booklets, Workbooks > MARC Structure

Search for Tag 856$u

Upload documents while cataloging

1. Click on the plug-in icon on 856$u field.

2. Upload file
 3. Choose the file to include in 856$u field.

4. Search in OPAC for the book and see the document link appeared in the details.

24 comments:

  1. Thanks for the acknowledgement buddy :-)

    ReplyDelete
  2. Replies
    1. Nope! Bug 6874 - Attach files to bibliographic records came into play only with 3.22 release. See the entry under Cataloging in the release notes https://koha-community.org/koha-3-22-released/#koha-features

      Delete

  3. Attaching files to catalog records but some error :- An error has occurred!
    Error 404
    This message may have been caused by any of the following reasons:
    You made use of an external link to an item that is no longer available
    You followed an outdated link e.g. from a search engine or a bookmark
    You tried to access a page that needs authentification
    An internal link in the client is broken and the page does not exist

    ReplyDelete
    Replies
    1. Can you paste the actual lines from the error log?

      Delete
  4. Good day sir, my school library uses Koha 3.2, I have done all steps you mentioned above but still can't find upload.pl when I try to edit my MARC Structure bibliographic frameworks.

    ReplyDelete
    Replies
    1. Koha 3.2 or 3.22??? The feature got added only in the 3.22 series, so if you are really on 3.2 (which by the way, is ANCIENT) you wont find the feature.

      Delete
  5. There is no error, I just can't find upload.pl when I got to this step ;"Go to Administration -> MARC Bibliographic Frameworks -> Books, Booklets, Workbooks -> MARC Structure. can't seem to paste the screen shot here

    ReplyDelete
  6. Wonderful!!! Thanks for the clear explanation.

    ReplyDelete
  7. Good day sir,
    I tried doing the ugrade, when I try to open Koha, I get this error
    "DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: Unknown MySQL server host 'Elchi_library' (0) at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line."
    I have trying to resolve this, but it's not working.

    Am thinking of Un-installing and reinstalling but I not sure if the server I download from has 3.22 or above. Please is there anyway I can find out which server has higher versions??

    Thanks

    ReplyDelete
  8. i did all steps above but when i try to open the link, i get this massage box
    you have chosen to open
    name.doc
    which is unknown
    from: http://127.0.0.1
    what should firefox do with
    open with
    save file

    when i open it i get distortion file

    ReplyDelete
  9. dear sir,
    also when i try again h get this error
    Not Found

    The requested URL /cgi-bin/koha/opac-retrieve-file.pl was not found on this server.
    Apache/2.4.10 (Ubuntu) Server at 127.0.0.1 Port 80

    ReplyDelete
  10. I got the following error message when I try to upload a file to catalogue.
    File could not be created. Check permissions. What will I do ?

    ReplyDelete
  11. I got a permission problem which i tried to resolve but with no avail

    ReplyDelete
  12. Dear Vimal today i have tested it but it works fine without changing the path "/var/lib/koha/library/uploads" . Just we need to enable upload.pl plug-in in Bibliographic framework. Can you please let me know the reason why you have changed to "/usr/share/doc/koha-common". After very long time i have did some work on Koha and do not understand the reason for changing the path. I have tested on Koha 16.0503000.

    Thanking you

    ReplyDelete
    Replies
    1. Sir,
      You can assign any folder for this purpose.

      Delete
    2. Dear Sir,
      I am Using 16.05.05 Koha & Ubuntu 14.04, When i try to upload E Book , I can Browse the book but when i clink on upload again its ask for browse a file , its repeating same . am unable upload e books.

      Delete
    3. Dear Sir,
      I got problem in uploading e book, after i browse the book i clink on to upload but after clinking upload its again ask for browse file/ book. and am getting msg file could not be created.check permission

      Delete
  13. How to get whol list of documents in koha

    ReplyDelete
    Replies
    1. Koha > Reports

      See https://wiki.koha-community.org/wiki/SQL_Reports_Library

      Delete
  14. Sir,
    I am getting the following error message when I try to upload a file to catalogue.
    File could not be created. Check permissions. What will I do ?

    Ubuntu-16.04
    Koha - 16.11

    ReplyDelete
    Replies
    1. Change the permission of upload folder.

      Delete