I want to export about 13000 records from zope db to text file. But after reading about 7000 it stops and browser shows the message that site not found etc. When I use other database with fewer records (about 10000), it works well. Is the script timing out? If yes then, is there any way to set the time out period of a script? Using Zope Management or inside script? Below is the external method I am using to export data: def export_pupils(self): container = self self.REQUEST.RESPONSE.setHeader('Content-Type','text/csv') pupils=container.Catalog() pupilsData = "" rec_count = 0; #firstTime = 1 for pupil in pupils: o = pupil.getObject() addr = (o.address) sdate = "%s" %(o.start_date) mdate = "%s" %(o.meeting_date) current = "%s" %(o.current) base_lesson_hours = "%s" %(o.base_lesson_hours) hours_paid_for = "%s" %(o.hours_paid_for) no_date_marker = "%s" %(o.no_date_marker) address = "" for ad in addr: address += ad + " " pupilsData += o.id + "^^^ " + o.forename + "^^^ " + o.surname + "^^^ " + address + "^^^ " + o.phone + "^^^ " + o.mobile + "^^^ " + o.comments + "^^^ " + no_date_marker + "^^^ " + sdate + "^^^ " + current + "^^^ " + o.payment_method + "^^^ " + o.payment_amount + "^^^ " + o.payment_offer+ "^^^ " + o.instructor_id + "^^^ " + o.area + "^^^ " + o.advert_id + "^^^ " + o.operator_id + "^^^ " + o.licence_type + "^^^ " + base_lesson_hours + "^^^ " + mdate + "^^^ " + o.meeting_time + "^^^ " + o.age_range_text + "^^^ " + hours_paid_for + "^^^ " + o.reason_for_leaving + "^^^ " + o.comment_on_leaving + "^^^ " + o.surname[0] + "^^^^^\n" rec_count = rec_count + 1 print (rec_count) # if firstTime: # break return pupilsData If I want to export just current pupils ( current field/variable has 1) how do I pass that to script (container.Catalog())?
Sukhwinder Singh wrote:
I want to export about 13000 records from zope db to text file. But after reading about 7000 it stops and browser shows the message that site not found etc.
When I use other database with fewer records (about 10000), it works well.
Is the script timing out? If yes then, is there any way to set the time out period of a script? Using Zope Management or inside script?
It is probably more likely that your browser is timing out. What browser are you using? I woulod perhaps try a different browser, or try a commandline tool to download the url (e.g. for unix/linux there is fetch, curl, wget, etc.) -Matt -- Matt Hamilton matth@netsight.co.uk Netsight Internet Solutions, Ltd. Business Vision on the Internet http://www.netsight.co.uk +44 (0)117 9090901 Web Design | Zope/Plone Development & Consulting | Co-location | Hosting
participants (2)
-
Matt Hamilton -
Sukhwinder Singh