[OPEN-ILS-GENERAL] import patron

[Nuku Ameyibor]

there are many ways to load existing patrons into the evergreen
database.i created a php script to create the sql for me which i then
executed in a postrgres frontend.
this is the php script i used.its in the attachement .my users were in
a databse so i had to write  some lines to connect to the database and
then get the users.
you can read from the csv file to get the users if thats your purpose
remove parts of the code which arent relevant to you
i  edited the example i saw in the  subversion repositry to suite my purpose
.
but check in the database to see what profile_id corresponds to what
kind of user

.there are a couple of scripts in  tthe repository  that you can use
go here
http://svn.open-ils.org/trac/ILS-Contrib/browser/conifer/trunk/tools/migration-scripts
cheers!!!
On 9/15/09, Levani EL <levaniele at gmail.com> wrote:
> hello
> I wish to import students to a database to
> (register) know that the information I can find in CARD, usr
> and usr_address. I know that it is necessary to do CSV file look
> attachment. I think that it will go.
>
> i know steps:
> 1) create new table in postgre
> 2) copy csv to table
> 3) import to database
>
> what about home library, address and etc.
> i found script wrote in python but don`t help
> how generate barcodes and passwords?
>
> how write this steps correct in postgresql step by step?
> any documentation?
>
> thank you
>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: users_web.php
Type: text/php
Size: 3412 bytes
Desc: not available
Url : http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20090916/869c663f/attachment.bin