Has anyone come across a limit to how many patrons you can import at a time? I seem to keep getting a php timeout error. Thanks! -- Linda Culberson lculber@mdah.state.ms.us Archives and Records Services Division Ms. Dept. of Archives& History P. O. Box 571 Jackson, MS 39205-0571 Telephone: 601/576-6873 Facsimile: 601/576-6824
Linda, I tend to split the load file down to units of 1000 lines each. It is a bit confusing and frustrating when a patron load fails that way as you do not know what errors were going to be reported (and you need to use sql to see how far the load got so you can carry on with the rest). This number might be affected by the system performance or the network connection so the number of 1000 is not very scientific but it works on a number of our systems. Ian On 12/08/2010 18:18, Linda Culberson wrote:
Has anyone come across a limit to how many patrons you can import at a time? I seem to keep getting a php timeout error. Thanks!
-- Ian Bays Director of Projects PTFS Europe.com mobile: +44 (0) 7774995297 phone: +44 (0) 800 756 6803 skype: ian.bays email: ian.bays@ptfs-europe.com
Thanks, Ian. I'm afraid I'm a bit impatient. I did separate them into smaller units at first but since there were so many, I got frustrated and loaded them using sql. They look fine, and I'm hoping that using sql load didn't break anything. They look good in in the client, so I'm hoping I didn't do too much damage. On 8/12/2010 4:14 PM, Ian Bays wrote:
Linda,
I tend to split the load file down to units of 1000 lines each. It is a bit confusing and frustrating when a patron load fails that way as you do not know what errors were going to be reported (and you need to use sql to see how far the load got so you can carry on with the rest).
This number might be affected by the system performance or the network connection so the number of 1000 is not very scientific but it works on a number of our systems.
Ian
On 12/08/2010 18:18, Linda Culberson wrote:
Has anyone come across a limit to how many patrons you can import at a time? I seem to keep getting a php timeout error. Thanks!
-- Linda Culberson lculber@mdah.state.ms.us Archives and Records Services Division Ms. Dept. of Archives& History P. O. Box 571 Jackson, MS 39205-0571 Telephone: 601/576-6873 Facsimile: 601/576-6824
Sorry I'm late reading this - but I'm loading 28,000 lines at a time(all of our secondary students) and about (20,000) lines at a time elementary students. All through the browser - it spins for a long time, but eventually get a report. I'm actually working with a vendor to build a script to load these automatically every Monday from our student records system. It picks up a file using certain parameters and loads them using the .pl program. David Schuster Plano ISD Archival1 wrote:
Thanks, Ian. I'm afraid I'm a bit impatient. I did separate them into smaller units at first but since there were so many, I got frustrated and loaded them using sql. They look fine, and I'm hoping that using sql load didn't break anything. They look good in in the client, so I'm hoping I didn't do too much damage.
On 8/12/2010 4:14 PM, Ian Bays wrote:
Linda,
I tend to split the load file down to units of 1000 lines each. It is a bit confusing and frustrating when a patron load fails that way as you do not know what errors were going to be reported (and you need to use sql to see how far the load got so you can carry on with the rest).
This number might be affected by the system performance or the network connection so the number of 1000 is not very scientific but it works on a number of our systems.
Ian
On 12/08/2010 18:18, Linda Culberson wrote:
Has anyone come across a limit to how many patrons you can import at a time? I seem to keep getting a php timeout error. Thanks!
-- Linda Culberson lculber@mdah.state.ms.us Archives and Records Services Division Ms. Dept. of Archives& History P. O. Box 571 Jackson, MS 39205-0571 Telephone: 601/576-6873 Facsimile: 601/576-6824
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- View this message in context: http://old.nabble.com/-Koha--importing-patrons-tp29421074p29589723.html Sent from the Koha - Discuss mailing list archive at Nabble.com.
I did finally get them to load and have successfully done up to 15,000 at a time for testing, but it does take a long time. I found out that my problem was with the entries that that had double quotes in them - usually for nicknames. Thanks for letting me know that you are doing so many at a time, because I will need to load about 28,000 or so when we do our final load. On 1:59 PM, David Schuster wrote:
Sorry I'm late reading this - but I'm loading 28,000 lines at a time(all of our secondary students) and about (20,000) lines at a time elementary students. All through the browser - it spins for a long time, but eventually get a report.
I'm actually working with a vendor to build a script to load these automatically every Monday from our student records system. It picks up a file using certain parameters and loads them using the .pl program.
David Schuster Plano ISD
-- Linda Culberson lculber@mdah.state.ms.us Archives and Records Services Division Ms. Dept. of Archives& History P. O. Box 571 Jackson, MS 39205-0571 Telephone: 601/576-6873 Facsimile: 601/576-6824
participants (3)
-
David Schuster -
Ian Bays -
Linda Culberson