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.