www.ritlabs.com [Topic: How can TB macro access database data?] http://www.ritlabs.com New posts in How can TB macro access database data? of forum at www.ritlabs.com [www.ritlabs.com] en http://backend.userland.com/rss2 Fri, 22 Jul 2011 16:10:34 +0300 How can TB macro access database data? How can TB macro access database data? as title in forum The Bat! - Templates and Macros.

====quote====
luci excell wrote:
Hello,
http://szumi.one.pl/thebat/SQL/ is not Online anymore..
http://nobat.ru too. From where i can find SQLPlugin.tbp  

please help ..
=============

I've found this link:
http://www.findthatfile.com/search-338454-hRAR/winrar-winzip-download-sqlplugin01-rar.htm
22 July 2011 16:10:34, K_S.]]> http://www.ritlabs.com/en/forums/forum6/topic3725/message33834/ http://www.ritlabs.com/en/forums/forum6/topic3725/message33834/ Fri, 22 Jul 2011 16:10:34 +0300 The Bat! - Templates and Macros How can TB macro access database data? How can TB macro access database data? as title in forum The Bat! - Templates and Macros.
Hello,
http://szumi.one.pl/thebat/SQL/ is not Online anymore..
http://nobat.ru too. From where i can find SQLPlugin.tbp :(

please help ..
06 July 2011 21:18:39, luci excell.]]> http://www.ritlabs.com/en/forums/forum6/topic3725/message33766/ http://www.ritlabs.com/en/forums/forum6/topic3725/message33766/ Wed, 06 Jul 2011 21:18:39 +0300 The Bat! - Templates and Macros How can TB macro access database data? How can TB macro access database data? as title in forum The Bat! - Templates and Macros.
First, You must to install ODBC driver for your database (for MySql http://dev.mysql.com/downloads/connector/odbc/3.51.html). 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
====code==== 
%SQLCommand("SQL_Connection_String", "SQL_Command")
=============
returns nothing.

for example
====code==== 
%_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.

Sorry for my ungrammatic English
21 October 2007 19:48:04, K_S.]]> http://www.ritlabs.com/en/forums/forum6/topic3725/message19886/ http://www.ritlabs.com/en/forums/forum6/topic3725/message19886/ Sun, 21 Oct 2007 19:48:04 +0300 The Bat! - Templates and Macros How can TB macro access database data? How can TB macro access database data? as title in forum The Bat! - Templates and Macros.
Hello K_S & List

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 http://szumi.one.pl/theba­t/SQL/ sounds very helpfull.

Any experiences, English manual? Thanks for some input.
05 October 2007 16:23:49, Christian Hauser.]]> http://www.ritlabs.com/en/forums/forum6/topic3725/message19654/ http://www.ritlabs.com/en/forums/forum6/topic3725/message19654/ Fri, 05 Oct 2007 16:23:49 +0300 The Bat! - Templates and Macros How can TB macro access database data? How can TB macro access database data? as title in forum The Bat! - Templates and Macros.

====quote====
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?
=============

Perhaps SQL-plugin http://szumi.one.pl/thebat/SQL/ will help You.
29 October 2006 14:33:10, K_S.]]> http://www.ritlabs.com/en/forums/forum6/topic3725/message14471/ http://www.ritlabs.com/en/forums/forum6/topic3725/message14471/ Sun, 29 Oct 2006 14:33:10 +0200 The Bat! - Templates and Macros How can TB macro access database data? How can TB macro access database data? as title in forum The Bat! - Templates and Macros.
Thank you your valuable reply.  I will try it! :oops:  
28 October 2006 06:16:29, cy cheung.]]> http://www.ritlabs.com/en/forums/forum6/topic3725/message14462/ http://www.ritlabs.com/en/forums/forum6/topic3725/message14462/ Sat, 28 Oct 2006 06:16:29 +0300 The Bat! - Templates and Macros How can TB macro access database data? How can TB macro access database data? as title in forum The Bat! - Templates and Macros.
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.
27 October 2006 19:27:17, Roelof Otten.]]> http://www.ritlabs.com/en/forums/forum6/topic3725/message14455/ http://www.ritlabs.com/en/forums/forum6/topic3725/message14455/ Fri, 27 Oct 2006 19:27:17 +0300 The Bat! - Templates and Macros How can TB macro access database data? How can TB macro access database data? as title in forum The Bat! - Templates and Macros.
  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!

27 October 2006 18:29:49, cy cheung.]]> http://www.ritlabs.com/en/forums/forum6/topic3725/message14453/ http://www.ritlabs.com/en/forums/forum6/topic3725/message14453/ Fri, 27 Oct 2006 18:29:49 +0300 The Bat! - Templates and Macros