Can TB do it? Write a reply macro that extract incoming email data and use it to access database server(such as Mysql) to extract data information? Then the result return back to TB to complete the reply mail?
e.g. Passing eBay item number 8246789415 as parameter in order to connect database server to extract the date of the item shipped? e.g. It returns "10/21/2006" back to the reply mail content.
If it can't, any third party Plug-in program can do it? Thank you your help!
AFAIK TB can't access database servers, nor are there any capable plugins available that I know of.
However when you've got a command line driven tool that 's able to access your database and to place the output in a file, it's possible to make TB start it from a filter and place the output in a reply.
__________________________________ I'm just a user of The Bat! I don't work for Ritlabs.
cy cheung writes: Can TB do it? Write a reply macro that extract incoming email data and use it to access database server(such as Mysql) to extract data information? Then the result return back to TB to complete the reply mail?
In the days of SPAM I want to write a program which connects to my local CRM DB and to a web form.
1. TB checks in DB by SQL if the e-mail is known. 2. If not send an e-mail with a link to the web form 3. Web form sends CSV or XML record 4. TB adds record to the DB
So sounds very helpfull.
Any experiences, English manual? Thanks for some input.
First, You must to install ODBC driver for your database (for MySql ). Then You should use program %SystemRoot%\system32\odbcad32.exe (part of Microsoft Data Access Components) to quick and easy configuration of DNS to Your DB.
Then create a quick template (for example named 'ini') with a macro
Code
%SQLBuildConnectionString
and run this template (create a new message, type ini and press ctrl+space). Now choose a 'Microsoft OLE DB Provider for ODBC Services'. With other databases You must to choose other method (for MS Access it's 'Microsoft.Jet.OLEDB.4.0').
Now click on button 'Dalej' ('Next') and go to the 'Polaczenie' ('Connection'): 1. 'Okresl źrуdło danych' ('characterize data source') - 'uzyj nazwy źrуdła danych' - 'use the name of data source' (user DSN created in odbcad32.exe) - 'uzyj ciagu polaczenia' – 'use the connection tring' - Button ‘Konstruuj’ (Construct): there You can choose or create 'File DSN' ('plikowe źrуdło danych') or 'Computer DSN', the best option is to use a odbcad32.exe to creating and then simply choosing what You want.
2. 'Wprowadz informacje o logowaniu do serwera' ('input information about login') - 'Nazwa uzytkownika' (username) - 'Haslo' (password) 'Puste haslo' (empty password) 'Zezwalaj na zapisywanie hasla' (allow to save the password)
3. 'Wprowadz poczatkowy katalog do uzycia' (input start directory for use).
Button 'Testuj polaczenie' ('Test the connection'); use it
'Zaawansowane' ('Advanced') - there are options: 'ustawienia sieciowe' ('network settings'): 'poziom personifikacji' ('personalize level') and 'poziom ochrony' ('protection level')
'Inne' ('Others'): 'Limit czasu polaczenia' ('limit of a connection time'), 'uprawnienia dostepu' ('access rights')
'Wszystkie' ('All'): there You can manually edit all settings.
Click 'OK' and You will get a ‘connection string’: for example
Code
Provider=MSDASQL.1;Persist Security Info=False;Data Source=The Bat test
Copy this string somewhere, will be used in the next templates.
Now You should have access to Your database. You have two macros:
Code
%SQLQuery("ConnectionString", "SQL_Query")
returns dataset in lines, with data divided by commas
%_connstr="Provider=MSDASQL.1;Persist Security Info=False;Data Source=The Bat test"%-
%_query="SELECT * FROM mytable"%-
%SQLQuery(%_connstr, %_query)%-
If You have the connection and tested some templates (SELECT email FROM users WHERE email=’test@mail.com’ etc) You could start to create a machine for Your four points 1. TB checks in DB by SQL if the e-mail is known. %SQLQuery. Template in a filter? Template executed by script on Your server? 2. If not send an e-mail with a link to the web form Template could create mail for sending (/MAIL) 3. Web form sends CSV or XML record 4. TB adds record to the DB Very complicated filter with giant template and macro %SQLCommand - hard, but possible.
