| Line 2109... |
Line 2109... |
| 2109 |
|
2109 |
|
| 2110 |
filename = "/tmp/flipkart-report-"+runType+" " + str(timestamp) + ".xls"
|
2110 |
filename = "/tmp/flipkart-report-"+runType+" " + str(timestamp) + ".xls"
|
| 2111 |
wbk.save(filename)
|
2111 |
wbk.save(filename)
|
| 2112 |
try:
|
2112 |
try:
|
| 2113 |
#EmailAttachmentSender.mail("build@shop2020.in", "cafe@nes", ["kshitij.sood@saholic.com"], " Flipkart Auto Pricing "+runType+" " + str(timestamp), "", [get_attachment_part(filename)], [""], [])
|
2113 |
#EmailAttachmentSender.mail("build@shop2020.in", "cafe@nes", ["kshitij.sood@saholic.com"], " Flipkart Auto Pricing "+runType+" " + str(timestamp), "", [get_attachment_part(filename)], [""], [])
|
| 2114 |
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"], [])
|
2114 |
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","kshitij.sood@saholic.com","chaitnaya.vats@saholic.com","khushal.bhatia@saholic.com"], [])
|
| 2115 |
except Exception as e:
|
2115 |
except Exception as e:
|
| 2116 |
print e
|
2116 |
print e
|
| 2117 |
print "Unable to send report.Trying with local SMTP"
|
2117 |
print "Unable to send report.Trying with local SMTP"
|
| 2118 |
smtpServer = smtplib.SMTP('localhost')
|
2118 |
smtpServer = smtplib.SMTP('localhost')
|
| 2119 |
smtpServer.set_debuglevel(1)
|
2119 |
smtpServer.set_debuglevel(1)
|
| 2120 |
sender = 'build@shop2020.in'
|
2120 |
sender = 'build@shop2020.in'
|
| 2121 |
#recipients = ["kshitij.sood@saholic.com"]
|
2121 |
#recipients = ["kshitij.sood@saholic.com"]
|
| 2122 |
msg = MIMEMultipart()
|
2122 |
msg = MIMEMultipart()
|
| 2123 |
msg['Subject'] = "Flipkart Scraping" + ' '+runType+' - ' + str(datetime.now())
|
2123 |
msg['Subject'] = "Flipkart Scraping" + ' '+runType+' - ' + str(datetime.now())
|
| 2124 |
msg['From'] = sender
|
2124 |
msg['From'] = sender
|
| 2125 |
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']
|
2125 |
recipients = ['rajneesh.arora@saholic.com','anikendra.das@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']
|
| 2126 |
msg['To'] = ",".join(recipients)
|
2126 |
msg['To'] = ",".join(recipients)
|
| 2127 |
fileMsg = email.mime.base.MIMEBase('application','vnd.ms-excel')
|
2127 |
fileMsg = email.mime.base.MIMEBase('application','vnd.ms-excel')
|
| 2128 |
fileMsg.set_payload(file(filename).read())
|
2128 |
fileMsg.set_payload(file(filename).read())
|
| 2129 |
email.encoders.encode_base64(fileMsg)
|
2129 |
email.encoders.encode_base64(fileMsg)
|
| 2130 |
fileMsg.add_header('Content-Disposition','attachment;filename=flipkart.xls')
|
2130 |
fileMsg.add_header('Content-Disposition','attachment;filename=flipkart.xls')
|
| Line 2295... |
Line 2295... |
| 2295 |
mailServer.ehlo()
|
2295 |
mailServer.ehlo()
|
| 2296 |
mailServer.starttls()
|
2296 |
mailServer.starttls()
|
| 2297 |
mailServer.ehlo()
|
2297 |
mailServer.ehlo()
|
| 2298 |
|
2298 |
|
| 2299 |
#recipients = ['kshitij.sood@saholic.com']
|
2299 |
#recipients = ['kshitij.sood@saholic.com']
|
| 2300 |
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']
|
2300 |
recipients = ['rajneesh.arora@saholic.com','anikendra.das@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']
|
| 2301 |
msg = MIMEMultipart()
|
2301 |
msg = MIMEMultipart()
|
| 2302 |
msg['Subject'] = "Flipkart Auto Pricing" + ' - ' + str(datetime.now())
|
2302 |
msg['Subject'] = "Flipkart Auto Pricing" + ' - ' + str(datetime.now())
|
| 2303 |
msg['From'] = ""
|
2303 |
msg['From'] = ""
|
| 2304 |
msg['To'] = ",".join(recipients)
|
2304 |
msg['To'] = ",".join(recipients)
|
| 2305 |
msg.preamble = "Flipkart Auto Pricing" + ' - ' + str(datetime.now())
|
2305 |
msg.preamble = "Flipkart Auto Pricing" + ' - ' + str(datetime.now())
|
| Line 2387... |
Line 2387... |
| 2387 |
mailServer.ehlo()
|
2387 |
mailServer.ehlo()
|
| 2388 |
mailServer.starttls()
|
2388 |
mailServer.starttls()
|
| 2389 |
mailServer.ehlo()
|
2389 |
mailServer.ehlo()
|
| 2390 |
|
2390 |
|
| 2391 |
#recipients = ['kshitij.sood@saholic.com']
|
2391 |
#recipients = ['kshitij.sood@saholic.com']
|
| 2392 |
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']
|
2392 |
recipients = ['rajneesh.arora@saholic.com','anikendra.das@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']
|
| 2393 |
msg = MIMEMultipart()
|
2393 |
msg = MIMEMultipart()
|
| 2394 |
msg['Subject'] = "Flipkart Lost Buy Box" + ' - ' + str(datetime.now())
|
2394 |
msg['Subject'] = "Flipkart Lost Buy Box" + ' - ' + str(datetime.now())
|
| 2395 |
msg['From'] = ""
|
2395 |
msg['From'] = ""
|
| 2396 |
msg['To'] = ",".join(recipients)
|
2396 |
msg['To'] = ",".join(recipients)
|
| 2397 |
msg.preamble = "Flipkart Lost Buy Box" + ' - ' + str(datetime.now())
|
2397 |
msg.preamble = "Flipkart Lost Buy Box" + ' - ' + str(datetime.now())
|
| Line 2478... |
Line 2478... |
| 2478 |
mailServer.ehlo()
|
2478 |
mailServer.ehlo()
|
| 2479 |
mailServer.starttls()
|
2479 |
mailServer.starttls()
|
| 2480 |
mailServer.ehlo()
|
2480 |
mailServer.ehlo()
|
| 2481 |
|
2481 |
|
| 2482 |
#recipients = ['kshitij.sood@saholic.com']
|
2482 |
#recipients = ['kshitij.sood@saholic.com']
|
| 2483 |
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']
|
2483 |
recipients = ['rajneesh.arora@saholic.com','anikendra.das@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']
|
| 2484 |
msg = MIMEMultipart()
|
2484 |
msg = MIMEMultipart()
|
| 2485 |
msg['Subject'] = "Flipkart Cheap But Not In BuyBox Items" + ' - ' + str(datetime.now())
|
2485 |
msg['Subject'] = "Flipkart Cheap But Not In BuyBox Items" + ' - ' + str(datetime.now())
|
| 2486 |
msg['From'] = ""
|
2486 |
msg['From'] = ""
|
| 2487 |
msg['To'] = ",".join(recipients)
|
2487 |
msg['To'] = ",".join(recipients)
|
| 2488 |
msg.preamble = "Flipkart Cheap But Not In BuyBox Items" + ' - ' + str(datetime.now())
|
2488 |
msg.preamble = "Flipkart Cheap But Not In BuyBox Items" + ' - ' + str(datetime.now())
|
| Line 2564... |
Line 2564... |
| 2564 |
mailServer.ehlo()
|
2564 |
mailServer.ehlo()
|
| 2565 |
mailServer.starttls()
|
2565 |
mailServer.starttls()
|
| 2566 |
mailServer.ehlo()
|
2566 |
mailServer.ehlo()
|
| 2567 |
|
2567 |
|
| 2568 |
#recipients = ['kshitij.sood@saholic.com']
|
2568 |
#recipients = ['kshitij.sood@saholic.com']
|
| 2569 |
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']
|
2569 |
recipients = ['rajneesh.arora@saholic.com','anikendra.das@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']
|
| 2570 |
msg = MIMEMultipart()
|
2570 |
msg = MIMEMultipart()
|
| 2571 |
msg['Subject'] = "Flipkart Price Mismatch" + ' - ' + str(datetime.now())
|
2571 |
msg['Subject'] = "Flipkart Price Mismatch" + ' - ' + str(datetime.now())
|
| 2572 |
msg['From'] = ""
|
2572 |
msg['From'] = ""
|
| 2573 |
msg['To'] = ",".join(recipients)
|
2573 |
msg['To'] = ",".join(recipients)
|
| 2574 |
msg.preamble = "Flipkart Price Mismatch" + ' - ' + str(datetime.now())
|
2574 |
msg.preamble = "Flipkart Price Mismatch" + ' - ' + str(datetime.now())
|
| Line 2645... |
Line 2645... |
| 2645 |
mailServer.ehlo()
|
2645 |
mailServer.ehlo()
|
| 2646 |
mailServer.starttls()
|
2646 |
mailServer.starttls()
|
| 2647 |
mailServer.ehlo()
|
2647 |
mailServer.ehlo()
|
| 2648 |
|
2648 |
|
| 2649 |
#recipients = ['kshitij.sood@saholic.com']
|
2649 |
#recipients = ['kshitij.sood@saholic.com']
|
| 2650 |
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']
|
2650 |
recipients = ['rajneesh.arora@saholic.com','anikendra.das@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']
|
| 2651 |
msg = MIMEMultipart()
|
2651 |
msg = MIMEMultipart()
|
| 2652 |
msg['Subject'] = "Flipkart Negative Margin" + ' - ' + str(datetime.now())
|
2652 |
msg['Subject'] = "Flipkart Negative Margin" + ' - ' + str(datetime.now())
|
| 2653 |
msg['From'] = ""
|
2653 |
msg['From'] = ""
|
| 2654 |
msg['To'] = ",".join(recipients)
|
2654 |
msg['To'] = ",".join(recipients)
|
| 2655 |
msg.preamble = "Flipkart Negative Margin" + ' - ' + str(datetime.now())
|
2655 |
msg.preamble = "Flipkart Negative Margin" + ' - ' + str(datetime.now())
|
| Line 2730... |
Line 2730... |
| 2730 |
mailServer.ehlo()
|
2730 |
mailServer.ehlo()
|
| 2731 |
mailServer.starttls()
|
2731 |
mailServer.starttls()
|
| 2732 |
mailServer.ehlo()
|
2732 |
mailServer.ehlo()
|
| 2733 |
|
2733 |
|
| 2734 |
#recipients = ['kshitij.sood@saholic.com']
|
2734 |
#recipients = ['kshitij.sood@saholic.com']
|
| 2735 |
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']
|
2735 |
recipients = ['rajneesh.arora@saholic.com','anikendra.das@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']
|
| 2736 |
msg = MIMEMultipart()
|
2736 |
msg = MIMEMultipart()
|
| 2737 |
msg['Subject'] = "Flipkart Competitive But No Inventory" + ' - ' + str(datetime.now())
|
2737 |
msg['Subject'] = "Flipkart Competitive But No Inventory" + ' - ' + str(datetime.now())
|
| 2738 |
msg['From'] = ""
|
2738 |
msg['From'] = ""
|
| 2739 |
msg['To'] = ",".join(recipients)
|
2739 |
msg['To'] = ",".join(recipients)
|
| 2740 |
msg.preamble = "Flipkart Competitive But No Inventory" + ' - ' + str(datetime.now())
|
2740 |
msg.preamble = "Flipkart Competitive But No Inventory" + ' - ' + str(datetime.now())
|
| Line 2815... |
Line 2815... |
| 2815 |
mailServer.ehlo()
|
2815 |
mailServer.ehlo()
|
| 2816 |
mailServer.starttls()
|
2816 |
mailServer.starttls()
|
| 2817 |
mailServer.ehlo()
|
2817 |
mailServer.ehlo()
|
| 2818 |
|
2818 |
|
| 2819 |
#recipients = ['kshitij.sood@saholic.com']
|
2819 |
#recipients = ['kshitij.sood@saholic.com']
|
| 2820 |
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']
|
2820 |
recipients = ['rajneesh.arora@saholic.com','anikendra.das@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']
|
| 2821 |
msg = MIMEMultipart()
|
2821 |
msg = MIMEMultipart()
|
| 2822 |
msg['Subject'] = "Flipkart Auto Pricing Inactive" + ' - ' + str(datetime.now())
|
2822 |
msg['Subject'] = "Flipkart Auto Pricing Inactive" + ' - ' + str(datetime.now())
|
| 2823 |
msg['From'] = ""
|
2823 |
msg['From'] = ""
|
| 2824 |
msg['To'] = ",".join(recipients)
|
2824 |
msg['To'] = ",".join(recipients)
|
| 2825 |
msg.preamble = "Flipkart Auto Pricing Inactive" + ' - ' + str(datetime.now())
|
2825 |
msg.preamble = "Flipkart Auto Pricing Inactive" + ' - ' + str(datetime.now())
|