[Koha-win32] Amazon stuff on 2.2.9

[Scott Owen]

Hi all,

I am unable to find much info on making the Amazon links etc.. work on 
Koha 2.2.9 for windows.

I can get the images, but then it seems to break my opac-details.pl file 
and I get the /xml3 errors in my Apache logs.
For the Linux users, there seems to be a upgrade/patched 
opac-details.pl.....I can't seem to find this fo the win32 version.

Is there a way to just edit line 62 in the amazon.pm module to make this 
point to the correct amazon pages ???
Does someone have a working system that I could borrow these files from ??

Thanks for any assistance.

Scott Owen
Alma Public Schools

P.S.
As a token of my appreciation to the Koha lists here are my install notes..
(very rough...but maybe someone can get some information from them...)

Koha Install on Windows XP. (as of 5/13/2008)

The following packages were used (Google is your friend…)

Apache 2.0.63

MySQL 4.1.22 (initially…upgraded to 5.0.51b about half way through…)

ActiveState Perl 5.8.8.822

Koha 2.2.9

mysql-gui-tools-5.0-r12-win32.msi

Install instructions were followed as recommended at 
http://www.koha.rwjr.com/

This gave a successful Koha install that allowed the windows system to 
access Koha by accessing the http://OPAC and http://INTRANET URL’s.

******************************************

Added a section (and edited a few lines) in the "C:\program files\Apache 
Group\apache2\conf\httpd.conf" file to make the 2 sites accessible via 
the rest of the LAN.

as per http://www.nabble.com/How-to-access-koha-in-LAN-td8724664.html

******************************************

Also added DNS info to my internal DNS server.

*******************************************

Ports 80 and 8000 are set to “listen” in the httpd.conf

To access the OPAC side of Koha, my users can browse to 
http://koha.mydomain.net <http://koha.mydomain.net/>

To access the INTRANET side of Koha, my users browse to 
http://koha.mydomain.net:8000 <http://koha.mydomain.net:8000/>

*****************************************

To make a custom search page:

(ie: “I want my students to only search my branch as default”)

Edit c:\~\OPAC\cgi-bin\koha\opac-search.pl

Save a copy as PINEopac-search.pl

Edit line 202 (template_name) to “PINEopac-search.tmpl”

Edit c:\~\OPAC\htdocs\opac-tmpl\css\en\opac-search.tmpl

Save a copy as PINEopac-search.tmpl

Edit line 87 to read

<option value=“PINE”>Pine</option

Point browsers to http://<site>/cgi-bin/koha/PINEopac-search.tmpl

*******************************************

Barcodes & labels

Free barcode 39 font http://www.squaregear.net/fonts/free3of9.shtml

Free (for non-profit and edu) label making/design software 
http://www.idautomation.com/labelsoftware/free/

On the server use MySQLAdmin (GUI) > Query Browser > select (double 
click) on “items” (the query should pop-up in the query window) (SELECT 
* FROM items I;)

Right click on the results, select export, the export as a CSV file.

This will give a CSV that contains the Barcode and call numbers, among 
other things, now we just need the title.

Sort the data you want to keep by biblio number.

Get the title by performing a 2nd query on the biblio table. Export as 
CSV, sort by biblio.

Combine and pares the two CSV files to get the appropriate info to/from 
the CSV files so that you wind up with :


Title, barcode, Call Number, and anything else you want on the barcode 
label, in CSV format.

IE:

The Lovely Bones, 75000, FIC SEB, MySchoolBranch

You will want to examine this CSV data closely to make sure everything 
matches

BE CAREFUL….the items table data WILL NOT always be an exact match to 
the biblio data.

OPTIONAL: use a multi-table MySQL query to pull all of the data from 
both the biblio and items tables into a single “outputable” table, then 
export to CSV.

http://www.daniweb.com/forums/thread22066.html

http://www.informit.com/articles/article.aspx?p=377068&seqNum=7 
<http://www.informit.com/articles/article.aspx?p=377068&seqNum=7>

the SQL query :

SELECT biblio.biblionumber, biblio.title, items.barcode, 
items.itemcallnumber FROM biblio, items WHERE biblio.biblionumber = 
items.biblionumber;

Will produce (in my case) a CSV like

biblionumber

        

title

        

barcode

        

itemcallnumber

1

        

Novell's ZENworks administrator's handbook /

        

1

        

2

        

The New York Public Library desk reference.

        

30525

        

031 new

3

        

Picture perfect /

        

36003

        

FIC PIC

6

        

Just listen :

        

30431

        

FIC DES

5

        

The lovely bones :

        

30319

        

FIC SEB

8

        

Unexplained /

        

109541

        

001.94 ALL

9

        

Whatever happened to Janie? /

        

109542

        

10

        

The bad beginning /

        

50000

        

F SNI

11

        

The field guide /

        

50003

        

F DIT

12

        

The clique :

        

109528

        

F HAR

As you get into larger and larger biblionumbers you may want to add a > 
to the query:

SELECT biblio.biblionumber, biblio.title, items.barcode, 
items.itemcallnumber FROM biblio, items WHERE biblio.biblionumber>4 = 
items.biblionumber;

The >4 causes the query to only show rows where the biblionumber is 
(greater than)> 4

*****************************************************

To access the MySQL database remotely (to export data) we will need to 
setup a remote user.

At the server launch MySQL Administrator, select User Administration.

Add a new user (just a username and password are required)

Don’t forget to add appropriate privileges in the “Global” “Schema” and 
“Schema Object” tabs.

Install mysql-gui-tools-5.0-r12-win32.msi on your local workstation and 
setup a connection to the server.

Connect with MySQL Administrator (hostname, user and password should be 
self explanatory….connect as the user you just created.)

You should be able to export the required data to CSV files and save 
them to your desktop.

****************************************************

From this point, it’s just a few quick steps to have the CSV ready to 
print labels.

1. Delete the biblionumber column.

2. Add a column for our School name

3. Install the free barcode 39 font (unzip and drag the 2 font files to 
your c:\windows\fonts folder)

4. Create your labels with the label making/design software

5. Link your CSV to the label software and……print labels.

6. or……Purchase a Brother QL-500 (comes with it’s own software that 
works almost exactly like the free stuff)

*******************************************************************************

_SQL Query stuff:_

Table t1: Table t2:

+----+----+ +----+----+

| i1 | c1 | | i2 | c2 |

+----+----+ +----+----+

| 1 | a | | 2 | c |

| 2 | b | | 3 | b |

| 3 | c | | 4 | a |

+----+----+ +----+----+

mysql> SELECT t1.*, t2.* FROM t1, t2 WHERE t1.i1 = t2.i2;

+----+----+----+----+

| i1 | c1 | i2 | c2 |

+----+----+----+----+

| 2 | b | 2 | c |

| 3 | c | 3 | b |

+----+----+----+----+

SELECT biblio.biblionumber, biblio.title, items.barcode, 
items.itemcallnumber FROM biblio, items WHERE biblio.biblionumber = 
items.biblionumber;

SELECT biblio.biblionumber, biblio.title, items.barcode, 
items.itemcallnumber FROM biblio, items WHERE biblio.biblionumber>4 = 
items.biblionumber;

(the >4 causes the query to only show fields > 4)

**************************************************************************************

_ _

_ _

_ _

_ _

_ _

_PHP Stuff----OPTIONAL NOT REQUIRED FOR KOHA_

_ _

From Cmd. Line : php –m to see modules

Download both the MSI package and the .zip

Install to c:\PHP with the MSI installer

Then unzip the .zip and copy the contents over the c:\php directory.

This will add a couple directories

Edit php.ini

Add:

***********************************************

;;;;;;;;;;;;;;;;;;;;;;;;;

; Paths and Directories ;

;;;;;;;;;;;;;;;;;;;;;;;;;

; UNIX: "/path1:/path2"

;include_path = ".:/php/includes"

;

; Windows: "\path1;\path2"

include_path = "c:\php\"

***********************************************

;;;;;;;;;;;;;;;;;;;;;;

; Dynamic Extensions ;

;;;;;;;;;;;;;;;;;;;;;;

;

; If you wish to have an extension loaded automatically, use the following

; syntax:

;

; extension=modulename.extension

;

; For example, on Windows:

;

extension=php_mysql.dll

extension=php_mysqli.dll

*****************************************************

Read:

http://us.php.net/manual/en/install.windows.apache2.php

_Apache Stuff_

Make sure this is added by php install

******************************************************************

#BEGIN PHP INSTALLER EDITS - REMOVE ONLY ON UNINSTALL

PHPIniDir "C:/PHP/"

LoadModule php5_module "C:/PHP/php5apache2.dll"

#END PHP INSTALLER EDITS - REMOVE ONLY ON UNINSTALL

**************************************************************************

_Mass Import of MARC records _

_GUI—mass import_

Follow the guide at

http://www.mitinet.com/LC_Download.aspx

Cut the marc record and paste to a raw text file.

(suggest sorting by shelf? One record per line? To aid organization. Do 
not to make the import file to big…for your own sanity)

Other MARC sites

http://www.ckls.org/~kdr/tech/marcsites.html 
<http://www.ckls.org/%7Ekdr/tech/marcsites.html>

Open the INTRANET interface.

Select “parameters” à “upload MARC records in reservoir”

Browse to the txt file, give it (the upload) a name….and import.

These records are NOT added biblios, they are just sitting in the reservoir

_Cmd Line---massimport_

Same as above for getting the MARC records into a single file.

Then:

Open a cmd prompt, and cd to c:\usr\koha229\scripts\misc\migration_tools

type bulkmarcimport.pl hit enter and read the command line options

bulkmarcimport –file (path to raw txt file) –t

will “test” the mass import file….no changes will be made to the database.

bulkmarcimport –file (path to raw txt file)

will add biblio records…..they bypass the reservoir.