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