| View previous topic :: View next topic |
| Author |
Message |
mthao
Quite a regular
Joined: 10 Sep 2007
Posts: 16
|
| Posted: Mon Sep 10, 2007 9:41 am Post subject: Using an already existing MSSQL database |
 |
|
Is it possible to use an already existing database to get information from?
My company has a telephone-system that has all data that is wanted. The AD doesnt have all the required information.
Also is it possible to access the information in the "Other Telephone" field in AD? |
|
| Back to top |
|
 |
Jesper Frier
Certified Professional
Joined: 09 Sep 2006
Posts: 1940
Location: Stoevring, Denmark
|
| Posted: Mon Sep 10, 2007 9:45 am Post subject: Manage Data Sources |
|
|
| mthao wrote: | | Is it possible to use an already existing database to get information from? |
Yes, you can connect the signature templates to all OLE DB's (e.g. MS SQL or Access).
By default, the templates will look in your AD.
Click one signature and select Manage Data Sources.
| mthao wrote: | | Also is it possible to access the information in the "Other Telephone" field in AD? |
Which field is that? |
|
| Back to top |
|
|
mthao
Quite a regular
Joined: 10 Sep 2007
Posts: 16
|
| Posted: Mon Sep 10, 2007 9:51 am Post subject: |
|
|
How does the system read the info from the exisiting database?
How do I match the info from the existing database to match the fields in signature designer?
| Quote: |
Which field is that?
|
If you press the button next to the field containing the telephone number you get the option to add more numbers. The company has their internal numbers in the telephone field and their external number in the other telephone field "inside" that button |
|
| Back to top |
|
|
Jesper Frier
Certified Professional
Joined: 09 Sep 2006
Posts: 1940
Location: Stoevring, Denmark
|
| Posted: Mon Sep 10, 2007 10:01 am Post subject: MDAC |
|
|
The Cockpit uses MDAC (or ODBC if you prefer that) connection to read information from your data source.
When creating new signature you can select your data sources. Or you can change data source in existing templates.
Re. the 'Other Telephone' field, you can try and see if it's visible for the standard templates using AD as the data source.
If not visible, but needed, please post in feature request forum ...  |
|
| Back to top |
|
|
mthao
Quite a regular
Joined: 10 Sep 2007
Posts: 16
|
| Posted: Mon Sep 10, 2007 10:03 am Post subject: |
|
|
Ok thanks for the replies!
I will try the connection with the excisting database. |
|
| Back to top |
|
|
Jesper Frier
Certified Professional
Joined: 09 Sep 2006
Posts: 1940
Location: Stoevring, Denmark
|
| Posted: Wed Sep 12, 2007 4:47 am Post subject: Rule based deployment |
|
|
One more thing which might be worth looking into!
Not using AD as your data source, you can take advantage of Rule based deployment found in the menu Available Signatures:
We have a customer with +8,000 users and more than 100 rules to deploy signatures. |
|
| Back to top |
|
|
|
Register
Profile
Log in to check your private messages
Log in
Manage Email Signatures Centrally - For All Users Forum Index
-> English Support
|
About Us |
Terms and conditions |
© 2012 eMailSignature North America, Inc. and eMailSignature Aps.