Searching for txt file and importing to ms access

[Mark Line]

Hello!



I'm a python n00b!



I've been writing in c++ for a few years so programming's not new to me, 
just python that I don't know the syntax!



What I'm trying to do is get an email from an pop3 account, and then search 
the email for some CVS data and import that information into MS Access.



I'm managed to get some code to download a message from the email account 
and save it to a text file, does any one have a link to some sample code to 
search though a file until a string of characters is matched?  Or could 
point me to some functions that may help me with this?



I've also managed to connect to my access database, and just print out a 
field in a table, but I cant find anywhere on the web that will help me to 
import data?  Any help would be great?!



By the way I'm running on windows, and have installed the windows add on's.



Thanks in advance

Mark



email code



import sys, poplib


f = open('c:\\myfile.txt', 'w')

mailserver = 'pop3.abilitec.com'
mailuser   = '[EMAIL PROTECTED]'
mailpasswd = '***'



print 'Connecting...'
server = poplib.POP3(mailserver)
server.user(mailuser)  # connect, login to mail server
server.pass_(mailpasswd)   # pass is a reserved word

try:
print server.getwelcome()  # print returned greeting message
msgCount, msgBytes = server.stat()
print 'There are', msgCount, 'mail messages in', msgBytes, 'bytes'
print server.list()
print '-'*80

for i in range(msgCount):
hdr, message, octets = server.retr(i+1)# octets is byte count
for line in message:
 # retrieve, print all 
mail
f.write(line)
f.write('\n')
print '-'*80   # mail box locked till 
quit
if i < msgCount - 1:
   raw_input('[Press Enter key]')
finally:   # make sure we unlock 
mbox
server.quit()  # else locked till 
timeout
print 'Bye.'

f.close()





access



import sys, win32com.client

print 'start'

connection = win32com.client.Dispatch(r'ADODB.Connection')
DSN = 'PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA 
SOURCE=c:\\booking.mdb;/root/blackcomb'
connection.Open(DSN)
recordset = win32com.client.Dispatch(r'ADODB.Recordset')
recordset.Open('SELECT * FROM tblBooking', connection, 1, 3)
fields_dict = {}
for x in range(recordset.Fields.Count):
fields_dict[x] = recordset.Fields.Item(x).Name
print fields_dict[x], recordset.Fields.Item(x).Value

print 'end'







-- 
http://mail.python.org/mailman/listinfo/python-list

Re: Searching for txt file and importing to ms access

[Mark Line]

Once i have this working i was planing to kept all the txt files as logs, 
i'd have to give them a real name and stuff.

But thanks for you help so far

Mark


"Mike Meyer" <[EMAIL PROTECTED]> wrote in message 
news:[EMAIL PROTECTED]
> "Mark Line" <[EMAIL PROTECTED]> writes:
>> I'm managed to get some code to download a message from the email account
>> and save it to a text file, does any one have a link to some sample code 
>> to
>> search though a file until a string of characters is matched?  Or could
>> point me to some functions that may help me with this?
>
> datafile = open("c:\\myfile.txt", "r")
> data = datafile.read()
> datafile.close()
> start = data.index(myindicator)
>
> will leave start as the index in data where the the string in
> myindicator first appears. If you want the end of myendicator, use
> start = data.find(myindicator) + len(myindicator).
>
> Have you considered not saving the message to disk? You can manipulate
> it all in memory.
>
>> I've also managed to connect to my access database, and just print out a
>> field in a table, but I cant find anywhere on the web that will help me 
>> to
>> import data?  Any help would be great?!
>
> Can't help with that. The phrase "win32com" comes to mind, but I'm not
> a windows person.
>
>   -- 
> Mike Meyer <[EMAIL PROTECTED]> http://www.mired.org/home/mwm/
> Independent WWW/Perforce/FreeBSD/Unix consultant, email for more 
> information. 


-- 
http://mail.python.org/mailman/listinfo/python-list