does anyone have any suggestions on how to take an email with data in it and have the values imported in to the database, creating a record as the are imported? I want to take a constistently formatted email and have each one's information be automatically imported in to a database. Anyone know how to do this?
![[H]ard|Forum](/styles/hardforum/xenforo/logo_dark.png){kind=logo}
Navigation
Install the app
How to install the app on iOS
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
More options
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
auto import information from email
- Thread starter iansilv
- Start date
What kind of DB is it?
If the DB is a MySQL DB, you can use MySQL GUI Tools.
Go to MySQL Query Browser -> Tools -> RegEx Text Importer to build insert queries from any data file according to a regular expression.
If it's not MySQL, I'm sure Toad (database admin client software, google it) has some kind of import/query building utility but I'm not sure where it is.
Barring those solutions above, you'll need to write some kind of script that can process the email, interpret it, interface with the database, and insert it into the database.
If the DB is a MySQL DB, you can use MySQL GUI Tools.
Go to MySQL Query Browser -> Tools -> RegEx Text Importer to build insert queries from any data file according to a regular expression.
If it's not MySQL, I'm sure Toad (database admin client software, google it) has some kind of import/query building utility but I'm not sure where it is.
Barring those solutions above, you'll need to write some kind of script that can process the email, interpret it, interface with the database, and insert it into the database.