| Line 1941... |
Line 1941... |
| 1941 |
sheet_iterator+=1
|
1941 |
sheet_iterator+=1
|
| 1942 |
|
1942 |
|
| 1943 |
filename = "/tmp/amazon-report-"+runType+" " + str(timestamp) + ".xls"
|
1943 |
filename = "/tmp/amazon-report-"+runType+" " + str(timestamp) + ".xls"
|
| 1944 |
wbk.save(filename)
|
1944 |
wbk.save(filename)
|
| 1945 |
try:
|
1945 |
try:
|
| 1946 |
EmailAttachmentSender.mail("build@shop2020.in", "cafe@nes", ["kshitij.sood@saholic.com"], " Amazon Auto Pricing "+runType+" " + str(timestamp), "", [get_attachment_part(filename)], [""], [])
|
1946 |
#EmailAttachmentSender.mail("build@shop2020.in", "cafe@nes", ["kshitij.sood@saholic.com"], " Amazon Auto Pricing "+runType+" " + str(timestamp), "", [get_attachment_part(filename)], [""], [])
|
| 1947 |
#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"], " Amazon Auto Pricing "+runType+" " + str(timestamp), "", [get_attachment_part(filename)], ["rajneesh.arora@saholic.com","anikendra.das@saholic.com","amit.gupta@saholic.com","kshitij.sood@saholic.com","chaitnaya.vats@saholic.com","khushal.bhatia@saholic.com"], [])
|
1947 |
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"], " Amazon Auto Pricing "+runType+" " + str(timestamp), "", [get_attachment_part(filename)], ["rajneesh.arora@saholic.com","anikendra.das@saholic.com","amit.gupta@saholic.com","kshitij.sood@saholic.com","chaitnaya.vats@saholic.com","khushal.bhatia@saholic.com"], [])
|
| 1948 |
except Exception as e:
|
1948 |
except Exception as e:
|
| 1949 |
print e
|
1949 |
print e
|
| 1950 |
print "Unable to send report.Trying with local SMTP"
|
1950 |
print "Unable to send report.Trying with local SMTP"
|
| 1951 |
smtpServer = smtplib.SMTP('localhost')
|
1951 |
smtpServer = smtplib.SMTP('localhost')
|
| 1952 |
smtpServer.set_debuglevel(1)
|
1952 |
smtpServer.set_debuglevel(1)
|
| 1953 |
sender = 'build@shop2020.in'
|
1953 |
sender = 'build@shop2020.in'
|
| 1954 |
recipients = ["kshitij.sood@saholic.com"]
|
1954 |
#recipients = ["kshitij.sood@saholic.com"]
|
| 1955 |
msg = MIMEMultipart()
|
1955 |
msg = MIMEMultipart()
|
| 1956 |
msg['Subject'] = "Amazon Auto Pricing" + ' '+runType+' - ' + str(datetime.now())
|
1956 |
msg['Subject'] = "Amazon Auto Pricing" + ' '+runType+' - ' + str(datetime.now())
|
| 1957 |
msg['From'] = sender
|
1957 |
msg['From'] = sender
|
| 1958 |
#recipients = ['rajneesh.arora@saholic.com','anikendra.das@saholic.com','amit.gupta@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']
|
1958 |
recipients = ['rajneesh.arora@saholic.com','anikendra.das@saholic.com','amit.gupta@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']
|
| 1959 |
msg['To'] = ",".join(recipients)
|
1959 |
msg['To'] = ",".join(recipients)
|
| 1960 |
fileMsg = email.mime.base.MIMEBase('application','vnd.ms-excel')
|
1960 |
fileMsg = email.mime.base.MIMEBase('application','vnd.ms-excel')
|
| 1961 |
fileMsg.set_payload(file(filename).read())
|
1961 |
fileMsg.set_payload(file(filename).read())
|
| 1962 |
email.encoders.encode_base64(fileMsg)
|
1962 |
email.encoders.encode_base64(fileMsg)
|
| 1963 |
fileMsg.add_header('Content-Disposition','attachment;filename=amazon-auto-pricing.xls')
|
1963 |
fileMsg.add_header('Content-Disposition','attachment;filename=amazon-auto-pricing.xls')
|
| Line 2096... |
Line 2096... |
| 2096 |
mailServer = smtplib.SMTP("smtp.gmail.com", 587)
|
2096 |
mailServer = smtplib.SMTP("smtp.gmail.com", 587)
|
| 2097 |
mailServer.ehlo()
|
2097 |
mailServer.ehlo()
|
| 2098 |
mailServer.starttls()
|
2098 |
mailServer.starttls()
|
| 2099 |
mailServer.ehlo()
|
2099 |
mailServer.ehlo()
|
| 2100 |
|
2100 |
|
| 2101 |
recipients = ['kshitij.sood@saholic.com']
|
2101 |
#recipients = ['kshitij.sood@saholic.com']
|
| 2102 |
#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']
|
2102 |
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']
|
| 2103 |
msg = MIMEMultipart()
|
2103 |
msg = MIMEMultipart()
|
| 2104 |
msg['Subject'] = "Amazon Auto Pricing" + ' - ' + str(datetime.now())
|
2104 |
msg['Subject'] = "Amazon Auto Pricing" + ' - ' + str(datetime.now())
|
| 2105 |
msg['From'] = ""
|
2105 |
msg['From'] = ""
|
| 2106 |
msg['To'] = ",".join(recipients)
|
2106 |
msg['To'] = ",".join(recipients)
|
| 2107 |
msg.preamble = "Amazon Auto Pricing" + ' - ' + str(datetime.now())
|
2107 |
msg.preamble = "Amazon Auto Pricing" + ' - ' + str(datetime.now())
|