install

开源MARC数据处理

	account. if you are the admin you can administer the phpmylibrary.
	
	- Anyway, the instruction on installing as postnuke has been said before. In summary
	you'll just have to copy the PhpMyLibrary/ into your postnuke/modules/ directory.
	The PhpMyLibrary is case sensitive, don't change its name. The PhpMyLibrary
	structure goes like this:
	
	PhpMyLibrary/
		index.php
		functions.php
		.
		.
		polerio/
			config/
				conf.php
			module/
			.
			.
	
	- Then as a postnuke module installation, go to your blocks directory at
	PhpMyLibrary/polerio/blocks/ then copy the phpmylibrary.php to your 
	postnuke/includes/blocks/ directory then activate it into your postnuke
	administration page.
	
	- Be noted that this software runs on Linux and Windows system, you only need to download
	if installing for Window system, the Apache for windows server software. The PHP and MySQL
	Then if you want to install it into your linux system just download the rpm's or source, 
	tarball, of Apache, PHP, and MYSQL. 
	
	- This new version now have python file, this the MARC to SQL conversion file. This can be
	used to fasten your importing of MARC data into your database.
	
	- I also created a polGenSQL.py file. Its main purpose is to generate SQL files out of
	your MARC file. This means that you can just convert your MARC files into
	SQL commands thereby allowing you to just export it into your phpmylibrary database.
	From what I see, this is the most reliable importing engine I created because it doesn't
	miss any records. 
	
	
	
Oct 2, 2002

	- 5 months had passed and here I am again. Basically, the things that I feel
	very excited in this version is its clean coding. I made some revision on database
	coding, and that is not some, it consumes my time a lot. It was the conversion of all
	the database sql commands to ADODB implementation. ADODB compliant means database 
	independent application meaning, you can install this into your Oracle database, Postgresql
	Access, MSSQL, etc. And that's the advantage of it. If I will be able to make a 
	good installation of Postgresql on my PC, I will then try this ADODB implementation
	to give you a working example. I haven't tries it yet because I'm still configuring my
	PC, but if you will try, go with it. The phpmylibrary is now adodb compliant. 
	
	At last the full implementation of the Library Automation function has been applied
	to the phpmylibrary software. This software now has the Online reservation module which
	I tried to code a long time ago but due to lack of time and a little bit of laziness
	I've been very late. Not so much of a laziness but of too much work on my job. Basically 
	the software now comprise library automation major features. MARC import/export, 
	which was enhanced with the addition of CDS/ISIS import. This all resides on Record 
	Import Module. The WebOPAC, from which you have had already, which allow yout search using
	the bibliiographic records using keywords from the author, title, notes, subjects etc.
	Reservation Module as I always tend to call transaction module. It is because module of
	this kind does not only allow users to reserve material from the library, you also have 
	the capability to manage it. Wether to approve or disapprove.
	
	The Import Module has been extended to facilitate megabytes of data. We all know that
	this software is running online, uploading 7mb of marc data for import would cause
	but time-out. To answer this question I created import.py, this is an import module file
	written in python. This runs both on windows and linux system. Thus if you want to 
	encode or import more MARC data into your library database use this. It can be found at
	PhpMyLibrary/polerio/python directory of your download. In this directory you will
	find samplemarc.txt, try this file to test if your importing of data runs ok.
	This basically needs python software and MySQLdb: a Python interface for MySQL. Search
	the MySQLdb term on sourceforge.net or google site and then download it. More info
	can be found on the file itself. Some brief explanation is included in the file.
	
	Theme Management. If you're not a postnuke user then still be happy because I have made 
	this program flexible. You can now chose from wide variety of themes from around the net
	and download it. Put it in your PhpMyLibrary/themes directory and then open your 
	PhpMyLibrary/polerio/module/config/conf.php to change its default theme value.		


PhpMyLibrary 1.0.4b

May 15, 2002

	- What I've written on May 14 was wrong. It is because I still have corrupted database 
	when I update my catalog entry. The only way that takes myself out of that problem is the
	recoding of the sql file at polerio/sql/phpmylibray.sql. There's no mysql version issue
	in here, it is just that I made a wrong sql schema. This version basically comprise 
	accessioning, you  can now add, delete, modify accession numbers of the specific material
	you encoded. Andd this accessioning comprise the Holdings Module. In addtion, this version
	also has its Cataloging module. You can now edit or create new catalog entry. This is very
	useful because if your country have a new publication which is not yet published on any 
	country, this will mean that you will be the first to create its MARC. With this, you will
	add record on phpmylibrary software. You will add the title, author, etc. If you're finished
	with this, you can now export your MARC if you want to make a backup copy of your library, or
	perhaps you want to share it to other phpmylibrary user or other library software that 
	recognizes MARC data.

	Be noted that this version has an ISIS import function which is added on MARC Import
	module. Please read further to find instruction on howto import ISIS. The instruction
	can be found on polerio/docs/CHANGELOG file.

May 14, 2002

	- At last. I almost get dissapointed from what I am doing on MySQL version 3.22.30 of
	mysql.sourceforge.net. Actually, this new version should have been released already but 
	wanting to make an active demoonstration on my hosting, at sourceforge.net I recoded the 
	program to work with mysql version 3.22.30, and it doesn't work. I always get a corrupted 
	table. Now, fortunately the sourceforge mysql server had upgraded thier version. My hosting
	now used MySQL 3.23.36 and I restored my original code. Really, I made my code on version 
	3.23.xx of MySQL and when I test it in sourceforge I always get corrupted table, it was 
	because they use version 3.22.30 then. Now it's ok. What is important to me is that I 
	should at very least made an actual demo of cataloging module on my hosting. As this would
	describe the credibility of what I am saying. 

	Now, great thanks to sourceforge.net. I now have a code compatible on the latest version of
	mysql. Thus, phpmylibrary user, don't!!! use MySQL 3.22.30 I advise you now in advance to 
	download the latest version of mysql. Ignoring this would result in reinstalling your database
	server because the table has been corrupted and cannot be repaired. In addition if you just
	host your mysql on some server meanig you don't have root access, you'll really have to 
	contact your sysyem administrator to repair your mysql account. Now my database still suffer, 
	its impact--I can't open it in my phpmyadmin. When I try to repair it in the shell, I am 
	still unable to just drop the database. The commonly most affected tables is the tblxxxindex. 
	Thus if you use old version of mysql you would probably experience what have had happened on 
	my mysql account at sourceforge.

	At least. The versionm 1.0.4b is now ready for download.


May 6, 2002	

	- The Cataloging and holdings have been done. To install it, you must save your existing
	MARC if you're upgrading. Then reintall the phpmylibrary application. Then copy-paste 
	or upload your MARC again. The language 'de' for German has been 60% complete. 
	
	- The are more settings you can customize at polerio/phpmylibrary/config/conf.php
	
	- The MouseOver function has been applied, taken from phpmyadmin application.
	
	- The adding/deleting of Accession number is very easy now. Just delete it if you
	want it. Note: once you click add in holdings table, it will insert one entry. Then 
	modify it, then Update it. 
	
	- In installing, just open/execute the sql at polerio/sql/phpmylibrary.sql in your database
	and you're done. Be noted that if you're a non-postnuke user, you must encode
	your own password on the sql file itself. I'm not yet done on automated installation thus
	you must change it literally at polerio/sql/phpmylibrary.sql
	
	- If you are upgrading, please do back-up your MARC first by searching on your WebPAC module
	then save the MARC as zip. Search %%% to browse all the results. I suggest you to
	search %%% with a limit of 1000. save everything on a disk then reintall the phpmylibrary
	software. Then again import all the data again into your database using phpmylibrary software.
	This problem will be correct soon, on the next release.
	
	- For additional info visit phpmylibrary.sourceforge.net/html. This would have
	some additional notes about this version. 	
	

PhpMyLibrary 1.0.4a

Apr 21, 2002

	- To run this version please visit the site at http://phpmylibrary.sourceforge.net
	This holds some information you need to run the new version. Be noted that this version 
	can be installed on an Stand-alone application or in a Post-nuke site. For more info. 
	visit the Phpmylibrary site.
	
	All Users:
	
		The database configuration settings can be found on polerio/config/conf.php
	You will need this to start your Phpmylibrary software. Do encode the needed settings
	on that file, i.e the database server name, database name, database user, database 
	password. 
	
		To specify the length of search term of the user, proceed to 
	polerio/phpmylibrary/config/conf.php

		The File Export as ZIP is already done. I would suggest you to import a 
	lot of MARC data to your Phpmylibrary software to test the capacity of your
	server. I've tried this software on our computer Pentium III Computer with XP and
	I've imported almost 12,000 of data. You should at least import a maximum of one 
	diskette per import, meaning 1.44 MB in size is enough. You should wait because on 
	our Pentium IIIcomputer it takes 15 to 30 seconds to totally encode the 1,000 
	to 1,500 of MARC data. I've repeat it 10-12 times and I've got a total of 
	11,500+ entries on my Phpmylibrary software.
	
	PostNuke users: 
	
		Be noted that the blocks needed for the Phpmylibrary-1.0.4a menu 
	can be found on polerio/blocks/phpmylibrary.php, do paste this at your 
	post-nuke-directory/includes/blocks/ directory.
	
		Be reminded that you should rename the PhpMyLibrary-1.0.4a to PhpMyLibrary 
	then paste this directory in your post-nuke modules directory. The file index.php
	of the PhpMyLibrary/index.php can be found on polerio/pml/index.php, you will need
	this if in case you delete the index.php in your PhpMyLibrary directory.
	
	Stand-alone Users:
	
		The current template is located on polerio/phpmylibrary/mytemplate directory, if 
	you decided to use another template, do make a copy of that file on the mytemplate 
	directory and rename it as html.php, do follow the same setup that I made on my 
	default template.	The only thing you should be given attention there is the menu.php 
	and content.php. 
	
	All:
	
		Visit the http://phpmylibrary.sourceforge.net site for more info.
	If you have further question or suggestion be free to email me at	
	[e-mail].	The Cataloging, Transaction, and Circulation 
	Module is currently on 	development.

		I'm looking for a volunteer translator. I've made a copy of template at 
	polerio/lang/eng/global.php, this is an English Language translation, loaded
	as default. If you have time translating, I would be grateful if you could
	translate something in Phpmylibrary so that more user will be able to use it.
	
	Thanks!
	
		
Logs below applies only to Phpmylibrary-1.0.3 and below users. I've included this 
to get you some history of this software.

PhpMyLibrary-1.0.3

This has been tested on http://www.polerio.f2s.com/phpmylibrary-1.0.3

and 

http://phpmylibraryaut.sourceforge.net/phpmylibrary-1.0.3


Ja 19, 2002

    Get the phpmylibrary.sql

    To apply in your database, do this

    i.e. (This is what I do in my database)
    mysql -u phpmylibrary --database=phpmylibrary --host=mysql -p < /home/groups/p/
    ph/phpmylibraryaut/htdocs/phpmylibrary-1.0.3/sample.sql
    
    you should do this
    mysql --u username --database=databasename --host=hostname -p < locatioofphpm
    ylibrary.sql

PhpMyLibrary-1.0.2


1. Just copy the phpmylibrary.sql to your MySQL database.


dec 18, 2001

	the onyly files you will be interested of are 

	conf.php3    // this holds the configuration

	phpmylibrary.sql // this holds your sql schema

	install.txt and changelog.txt // holds info about all these.

	license.txt // if your interested reading our license.

	www.phpmylibrary.n3.net // where you can find an additional annoucements.

	www.polerio.n3.net // if you're interested in the person behind  
	all these programming.

	your default ADMINISTRATOR password is admin and username admin
        if you want to change it, go to your sql schema name phpmylibrary.sql 
        and change the word admin to your username and admin to your password. 

	I would be very thankful if you would send me some of your information 
	about your library, university or organization. This would help me strive 
	more in creating this software. The more I know that this is needed the more I become very interesed in what I do. Comments and suggestions are highly accepted. 
	
	Email it all at [e-mail] Thanks. or perhaps post it in 
	our phpmylibrary mailing lists.

	this should work on your server because i've tried installing it my 
	own in another server using this whole package. the location is at 
	http://phpmylibraryaut.sourceforge.net/phpmylibrary-1.0.2 I have found 
	errors during my installation and I already correct, if found another 
	please send me a mail so that i can focus on that. thanks.



dec 17, 2001

	--  pls be noted  that your deault password is written in this sql file 
	under the table phpmylibraryUsers. pls change that to your prefered username and password.
 	read also the changlog that i always update. we have now a new feature here. 
 	the color ombination in the program can be customized pls change this base 
 	on your ned. also the library name if you have some image to put, pls speciy 
 	its filename and location at your config.php3 file 

	--  if you have some question in mind that I can solve be free to 
	send it at  [e-mail] I will be glad to help to further 
	improve this opensource software.  my personal site is at www.polerio.n3.net 
	my development/programming  page is at www.phpmlibrary.n3.net. 
	Thank you for using this software.  if you have time pls send us 
	some of your library info. location, status etc., or perhaps you 
	can send us some greeting cards from your country so that i will be more 
	inspired in pursuing this good project.

	2. Get your MySQL server, dbase, username, password info.

	3. Put all needed MySQL info into your conf.php3.
	
	4. Put a value to your $SITE_URL; the location of the phpmylibrary.

	5. Also, in $IMG_URL; the location of the image files.

	6. You're done.

	7. For more info, visit http://phpmylibrary.sourceforge.net

	Thanks.
	
	Polerio Babo Jr.II
	http://phpmylibrary.sourceforge.net
	[e-mail]