DOE CODE   /    Search Results   /    eCo-Pylot - A Python-Based Script for Sending Parsed Email Data to a Database

eCo-Pylot - A Python-Based Script for Sending Parsed Email Data to a Database

RESOURCE

Publicly Accessible Repository
https://github.com/sandialabs/PYLOTDB
https://doi.org/10.11578/dc.20171025.1317

SAVE / SHARE



SNL Badge

Abstract

eCo-PylotDB, written completely in Python, provides a script that parses incoming emails and prepares extracted data for submission to a database table. The script extracts the database server, the database table, the server password, and the server username all from the email address to which the email is sent. The database table is specified on the Subject line. Any text in the body of the email is extracted as user comments for the database table. Attached files are extracted as data files with each file submitted to a specified table field but in separate rows of the targeted database table. Other information such as sender, date, time, and machine from which the email was sent is extracted and submitted to the database table as well. An email is sent back to the user specifying whether the data from the initial email was accepted or rejected by the database server. If rejected, the return email includes details as to why.
Developers:
Release Date:
2011-11-02
Project Type:
Open Source, Publicly Available Repository
Software Type:
Scientific
Licenses:
Other (Commercial or Open-Source): https://ip.sandia.gov
Sponsoring Org.:
Code ID:
1977
Site Accession Number:
SCR# 1459
Research Org.:
Sandia National Laboratories
Country of Origin:
United States

RESOURCE

Publicly Accessible Repository
https://github.com/sandialabs/PYLOTDB
https://doi.org/10.11578/dc.20171025.1317

SAVE / SHARE



SNL Badge

Citation Formats

Barnette, Daniel W. eCo-Pylot - A Python-Based Script for Sending Parsed Email Data to a Database. Computer Software. https://github.com/sandialabs/PYLOTDB. USDOE. 02 Nov. 2011. Web. doi:10.11578/dc.20171025.1317.
Barnette, Daniel W. (2011, November 02). eCo-Pylot - A Python-Based Script for Sending Parsed Email Data to a Database. [Computer software]. https://github.com/sandialabs/PYLOTDB. https://doi.org/10.11578/dc.20171025.1317.
Barnette, Daniel W. "eCo-Pylot - A Python-Based Script for Sending Parsed Email Data to a Database." Computer software. November 02, 2011. https://github.com/sandialabs/PYLOTDB. https://doi.org/10.11578/dc.20171025.1317.
@misc{ doecode_1977,
title = {eCo-Pylot - A Python-Based Script for Sending Parsed Email Data to a Database},
author = {Barnette, Daniel W.},
abstractNote = {eCo-PylotDB, written completely in Python, provides a script that parses incoming emails and prepares extracted data for submission to a database table. The script extracts the database server, the database table, the server password, and the server username all from the email address to which the email is sent. The database table is specified on the Subject line. Any text in the body of the email is extracted as user comments for the database table. Attached files are extracted as data files with each file submitted to a specified table field but in separate rows of the targeted database table. Other information such as sender, date, time, and machine from which the email was sent is extracted and submitted to the database table as well. An email is sent back to the user specifying whether the data from the initial email was accepted or rejected by the database server. If rejected, the return email includes details as to why.},
doi = {10.11578/dc.20171025.1317},
url = {https://doi.org/10.11578/dc.20171025.1317},
howpublished = {[Computer Software] \url{https://doi.org/10.11578/dc.20171025.1317}},
year = {2011},
month = {nov}
}