| Line 1966... |
Line 1966... |
| 1966 |
sheet_iterator+=1
|
1966 |
sheet_iterator+=1
|
| 1967 |
|
1967 |
|
| 1968 |
filename = "/tmp/flipkart-report-"+runType+" " + str(timestamp) + ".xls"
|
1968 |
filename = "/tmp/flipkart-report-"+runType+" " + str(timestamp) + ".xls"
|
| 1969 |
wbk.save(filename)
|
1969 |
wbk.save(filename)
|
| 1970 |
try:
|
1970 |
try:
|
| 1971 |
#EmailAttachmentSender.mail("build@shop2020.in", "cafe@nes", ["kshitij.sood@saholic.com"], " Flipkart Auto Pricing "+runType+" " + str(timestamp), "", [get_attachment_part(filename)], [""], [])
|
1971 |
EmailAttachmentSender.mail("build@shop2020.in", "cafe@nes", ["kshitij.sood@saholic.com"], " Flipkart Auto Pricing "+runType+" " + str(timestamp), "", [get_attachment_part(filename)], [""], [])
|
| 1972 |
EmailAttachmentSender.mail("build@shop2020.in", "cafe@nes", ["chandan.kumar@saholic.com","manoj.kumar@saholic.com","yukti.jain@saholic.com","ankush.dhingra@saholic.com","manoj.pal@saholic.com"], " Flipkart Scraping "+runType+" " + str(timestamp), "", [get_attachment_part(filename)], ["rajneesh.arora@saholic.com","anikendra.das@saholic.com","vikram.raghav@saholic.com","kshitij.sood@saholic.com","chaitnaya.vats@saholic.com","khushal.bhatia@saholic.com"], [])
|
1972 |
#EmailAttachmentSender.mail("build@shop2020.in", "cafe@nes", ["chandan.kumar@saholic.com","manoj.kumar@saholic.com","yukti.jain@saholic.com","ankush.dhingra@saholic.com","manoj.pal@saholic.com"], " Flipkart Scraping "+runType+" " + str(timestamp), "", [get_attachment_part(filename)], ["rajneesh.arora@saholic.com","anikendra.das@saholic.com","vikram.raghav@saholic.com","kshitij.sood@saholic.com","chaitnaya.vats@saholic.com","khushal.bhatia@saholic.com"], [])
|
| 1973 |
except Exception as e:
|
1973 |
except Exception as e:
|
| 1974 |
print e
|
1974 |
print e
|
| 1975 |
print "Unable to send report.Trying with local SMTP"
|
1975 |
print "Unable to send report.Trying with local SMTP"
|
| 1976 |
smtpServer = smtplib.SMTP('localhost')
|
1976 |
smtpServer = smtplib.SMTP('localhost')
|
| 1977 |
smtpServer.set_debuglevel(1)
|
1977 |
smtpServer.set_debuglevel(1)
|
| 1978 |
sender = 'support@shop2020.in'
|
1978 |
sender = 'support@shop2020.in'
|
| 1979 |
#recipients = ["kshitij.sood@saholic.com"]
|
1979 |
recipients = ["kshitij.sood@saholic.com"]
|
| 1980 |
msg = MIMEMultipart()
|
1980 |
msg = MIMEMultipart()
|
| 1981 |
msg['Subject'] = "Flipkart Scraping" + ' '+runType+' - ' + str(datetime.now())
|
1981 |
msg['Subject'] = "Flipkart Scraping" + ' '+runType+' - ' + str(datetime.now())
|
| 1982 |
msg['From'] = sender
|
1982 |
msg['From'] = sender
|
| 1983 |
recipients = ['rajneesh.arora@saholic.com','anikendra.das@saholic.com','vikram.raghav@saholic.com','kshitij.sood@saholic.com','khushal.bhatia@saholic.com','chaitnaya.vats@saholic.com','chandan.kumar@saholic.com','manoj.kumar@saholic.com','yukti.jain@saholic.com','ankush.dhingra@saholic.com','manoj.pal@saholic.com']
|
1983 |
#recipients = ['rajneesh.arora@saholic.com','anikendra.das@saholic.com','vikram.raghav@saholic.com','kshitij.sood@saholic.com','khushal.bhatia@saholic.com','chaitnaya.vats@saholic.com','chandan.kumar@saholic.com','manoj.kumar@saholic.com','yukti.jain@saholic.com','ankush.dhingra@saholic.com','manoj.pal@saholic.com']
|
| 1984 |
msg['To'] = ",".join(recipients)
|
1984 |
msg['To'] = ",".join(recipients)
|
| 1985 |
fileMsg = email.mime.base.MIMEBase('application','vnd.ms-excel')
|
1985 |
fileMsg = email.mime.base.MIMEBase('application','vnd.ms-excel')
|
| 1986 |
fileMsg.set_payload(file(filename).read())
|
1986 |
fileMsg.set_payload(file(filename).read())
|
| 1987 |
email.encoders.encode_base64(fileMsg)
|
1987 |
email.encoders.encode_base64(fileMsg)
|
| 1988 |
fileMsg.add_header('Content-Disposition','attachment;filename=flipkart.xls')
|
1988 |
fileMsg.add_header('Content-Disposition','attachment;filename=flipkart.xls')
|
| Line 2143... |
Line 2143... |
| 2143 |
mailServer = smtplib.SMTP("smtp.gmail.com", 587)
|
2143 |
mailServer = smtplib.SMTP("smtp.gmail.com", 587)
|
| 2144 |
mailServer.ehlo()
|
2144 |
mailServer.ehlo()
|
| 2145 |
mailServer.starttls()
|
2145 |
mailServer.starttls()
|
| 2146 |
mailServer.ehlo()
|
2146 |
mailServer.ehlo()
|
| 2147 |
|
2147 |
|
| 2148 |
#recipients = ['kshitij.sood@saholic.com']
|
2148 |
recipients = ['kshitij.sood@saholic.com']
|
| 2149 |
recipients = ['rajneesh.arora@saholic.com','anikendra.das@saholic.com','vikram.raghav@saholic.com','kshitij.sood@saholic.com','khushal.bhatia@saholic.com','chaitnaya.vats@saholic.com','chandan.kumar@saholic.com','manoj.kumar@saholic.com','yukti.jain@saholic.com','ankush.dhingra@saholic.com','manoj.pal@saholic.com']
|
2149 |
#recipients = ['rajneesh.arora@saholic.com','anikendra.das@saholic.com','vikram.raghav@saholic.com','kshitij.sood@saholic.com','khushal.bhatia@saholic.com','chaitnaya.vats@saholic.com','chandan.kumar@saholic.com','manoj.kumar@saholic.com','yukti.jain@saholic.com','ankush.dhingra@saholic.com','manoj.pal@saholic.com']
|
| 2150 |
msg = MIMEMultipart()
|
2150 |
msg = MIMEMultipart()
|
| 2151 |
msg['Subject'] = "Flipkart Auto Pricing" + ' - ' + str(datetime.now())
|
2151 |
msg['Subject'] = "Flipkart Auto Pricing" + ' - ' + str(datetime.now())
|
| 2152 |
msg['From'] = ""
|
2152 |
msg['From'] = ""
|
| 2153 |
msg['To'] = ",".join(recipients)
|
2153 |
msg['To'] = ",".join(recipients)
|
| 2154 |
msg.preamble = "Flipkart Auto Pricing" + ' - ' + str(datetime.now())
|
2154 |
msg.preamble = "Flipkart Auto Pricing" + ' - ' + str(datetime.now())
|
| Line 2226... |
Line 2226... |
| 2226 |
mailServer = smtplib.SMTP("smtp.gmail.com", 587)
|
2226 |
mailServer = smtplib.SMTP("smtp.gmail.com", 587)
|
| 2227 |
mailServer.ehlo()
|
2227 |
mailServer.ehlo()
|
| 2228 |
mailServer.starttls()
|
2228 |
mailServer.starttls()
|
| 2229 |
mailServer.ehlo()
|
2229 |
mailServer.ehlo()
|
| 2230 |
|
2230 |
|
| 2231 |
#recipients = ['kshitij.sood@saholic.com']
|
2231 |
recipients = ['kshitij.sood@saholic.com']
|
| 2232 |
recipients = ['rajneesh.arora@saholic.com','anikendra.das@saholic.com','vikram.raghav@saholic.com','kshitij.sood@saholic.com','khushal.bhatia@saholic.com','chaitnaya.vats@saholic.com','chandan.kumar@saholic.com','manoj.kumar@saholic.com','yukti.jain@saholic.com','ankush.dhingra@saholic.com','manoj.pal@saholic.com']
|
2232 |
#recipients = ['rajneesh.arora@saholic.com','anikendra.das@saholic.com','vikram.raghav@saholic.com','kshitij.sood@saholic.com','khushal.bhatia@saholic.com','chaitnaya.vats@saholic.com','chandan.kumar@saholic.com','manoj.kumar@saholic.com','yukti.jain@saholic.com','ankush.dhingra@saholic.com','manoj.pal@saholic.com']
|
| 2233 |
msg = MIMEMultipart()
|
2233 |
msg = MIMEMultipart()
|
| 2234 |
msg['Subject'] = "Flipkart Lost Buy Box" + ' - ' + str(datetime.now())
|
2234 |
msg['Subject'] = "Flipkart Lost Buy Box" + ' - ' + str(datetime.now())
|
| 2235 |
msg['From'] = ""
|
2235 |
msg['From'] = ""
|
| 2236 |
msg['To'] = ",".join(recipients)
|
2236 |
msg['To'] = ",".join(recipients)
|
| 2237 |
msg.preamble = "Flipkart Lost Buy Box" + ' - ' + str(datetime.now())
|
2237 |
msg.preamble = "Flipkart Lost Buy Box" + ' - ' + str(datetime.now())
|
| Line 2312... |
Line 2312... |
| 2312 |
mailServer = smtplib.SMTP("smtp.gmail.com", 587)
|
2312 |
mailServer = smtplib.SMTP("smtp.gmail.com", 587)
|
| 2313 |
mailServer.ehlo()
|
2313 |
mailServer.ehlo()
|
| 2314 |
mailServer.starttls()
|
2314 |
mailServer.starttls()
|
| 2315 |
mailServer.ehlo()
|
2315 |
mailServer.ehlo()
|
| 2316 |
|
2316 |
|
| 2317 |
#recipients = ['kshitij.sood@saholic.com']
|
2317 |
recipients = ['kshitij.sood@saholic.com']
|
| 2318 |
recipients = ['rajneesh.arora@saholic.com','anikendra.das@saholic.com','vikram.raghav@saholic.com','kshitij.sood@saholic.com','khushal.bhatia@saholic.com','chaitnaya.vats@saholic.com','chandan.kumar@saholic.com','manoj.kumar@saholic.com','yukti.jain@saholic.com','ankush.dhingra@saholic.com','manoj.pal@saholic.com']
|
2318 |
#recipients = ['rajneesh.arora@saholic.com','anikendra.das@saholic.com','vikram.raghav@saholic.com','kshitij.sood@saholic.com','khushal.bhatia@saholic.com','chaitnaya.vats@saholic.com','chandan.kumar@saholic.com','manoj.kumar@saholic.com','yukti.jain@saholic.com','ankush.dhingra@saholic.com','manoj.pal@saholic.com']
|
| 2319 |
msg = MIMEMultipart()
|
2319 |
msg = MIMEMultipart()
|
| 2320 |
msg['Subject'] = "Flipkart Cheap But Not In BuyBox Items" + ' - ' + str(datetime.now())
|
2320 |
msg['Subject'] = "Flipkart Cheap But Not In BuyBox Items" + ' - ' + str(datetime.now())
|
| 2321 |
msg['From'] = ""
|
2321 |
msg['From'] = ""
|
| 2322 |
msg['To'] = ",".join(recipients)
|
2322 |
msg['To'] = ",".join(recipients)
|
| 2323 |
msg.preamble = "Flipkart Cheap But Not In BuyBox Items" + ' - ' + str(datetime.now())
|
2323 |
msg.preamble = "Flipkart Cheap But Not In BuyBox Items" + ' - ' + str(datetime.now())
|
| Line 2398... |
Line 2398... |
| 2398 |
mailServer = smtplib.SMTP("smtp.gmail.com", 587)
|
2398 |
mailServer = smtplib.SMTP("smtp.gmail.com", 587)
|
| 2399 |
mailServer.ehlo()
|
2399 |
mailServer.ehlo()
|
| 2400 |
mailServer.starttls()
|
2400 |
mailServer.starttls()
|
| 2401 |
mailServer.ehlo()
|
2401 |
mailServer.ehlo()
|
| 2402 |
|
2402 |
|
| 2403 |
#recipients = ['kshitij.sood@saholic.com']
|
2403 |
recipients = ['kshitij.sood@saholic.com']
|
| 2404 |
recipients = ['rajneesh.arora@saholic.com','anikendra.das@saholic.com','vikram.raghav@saholic.com','kshitij.sood@saholic.com','khushal.bhatia@saholic.com','chaitnaya.vats@saholic.com','chandan.kumar@saholic.com','manoj.kumar@saholic.com','yukti.jain@saholic.com','ankush.dhingra@saholic.com','manoj.pal@saholic.com']
|
2404 |
#recipients = ['rajneesh.arora@saholic.com','anikendra.das@saholic.com','vikram.raghav@saholic.com','kshitij.sood@saholic.com','khushal.bhatia@saholic.com','chaitnaya.vats@saholic.com','chandan.kumar@saholic.com','manoj.kumar@saholic.com','yukti.jain@saholic.com','ankush.dhingra@saholic.com','manoj.pal@saholic.com']
|
| 2405 |
msg = MIMEMultipart()
|
2405 |
msg = MIMEMultipart()
|
| 2406 |
msg['Subject'] = "Flipkart Price Mismatch" + ' - ' + str(datetime.now())
|
2406 |
msg['Subject'] = "Flipkart Price Mismatch" + ' - ' + str(datetime.now())
|
| 2407 |
msg['From'] = ""
|
2407 |
msg['From'] = ""
|
| 2408 |
msg['To'] = ",".join(recipients)
|
2408 |
msg['To'] = ",".join(recipients)
|
| 2409 |
msg.preamble = "Flipkart Price Mismatch" + ' - ' + str(datetime.now())
|
2409 |
msg.preamble = "Flipkart Price Mismatch" + ' - ' + str(datetime.now())
|