开发者

Importing csv-style text attachment from gmail into any kind of db/spreadsheet automatically?

开发者 https://www.devze.com 2023-04-03 01:54 出处:网络
Every hour, I get a csv style file (delimited by | (pipe)) delivered via email to a gmail address with a few rows of stuff like 12X98XJ|75.00|0.00||0.00|23.15

Every hour, I get a csv style file (delimited by | (pipe)) delivered via email to a gmail address with a few rows of stuff like 12X98XJ|75.00|0.00||0.00|23.15

I'd like to automatically import to/update a database. I was thinking Google Docs "email to docs" functionality. Except helpfully they seem to have disabled that now.

I feel there MUST be a simple method in existence that does what I want.

Once it's in something where I can get at it with an API, it's plain sailing from then on. Even something as simple as importing to Amazon SimpleDB would do. But a good half a day of Googling just leads down disappointing paths.

Two notes: All email functions are disabled on my server, so the .py scripts I found to retrieve from a local mail store file aren't going to work.

Don't ask me why the data is given to me in suc开发者_运维百科h a cack-handed way. It's historical. I seem to be working with people getting ready to migrate to windows 3.1


What about using the pair of fetchmail + procmail

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号