Hi there list members, External/Separate Company DB's; After a fare amount of time poring over user posts in the mail list archives it appears that it is possible to reference Company information from our own database. What I think I need is an example of this being done. Is there anyone that could post an example of this being done. Exchange Contacts; Is it possible to devise a lookup and link in tickets to a contact on an Exchange Public folder? Regards, Mikola (Mik) Rose PowerSoft Development Corp. CIO, Information Technology / Support Services Customer Service: 1 (250) 642-0199 Sales Dep.: 1 (888) 833-7697 Support Dep.: 1 (250) 642-0295 www.power-soft.com
It's hard to tell from your post if this will be obvioius to you or not... but the first question is: * Do you have a driver that allows perl access to your datasource (at an acceptable performance level)??? I have no idea if this is the case for Exchange or not... we became a Microsoft Free shop many years ago and I know nothing of Exchange anymore. (We're also happier, more profitable and more efficient, btw...) * If the answer is yes, then it's mostly a matter of defining the datasource schema in config.pm, in the "Map" array definition, within the "CustomerUser Stuff" section... I don't remember much more than that... hope it helps
Hi there list members,
External/Separate Company DB's; After a fare amount of time poring over user posts in the mail list archives it appears that it is possible to reference Company information from our own database. What I think I need is an example of this being done. Is there anyone that could post an example of this being done.
Exchange Contacts;
Is it possible to devise a lookup and link in tickets to a contact on an Exchange Public folder?
Regards,
Mikola (Mik) Rose PowerSoft Development Corp. CIO, Information Technology / Support Services Customer Service: 1 (250) 642-0199 Sales Dep.: 1 (888) 833-7697 Support Dep.: 1 (250) 642-0295 www.power-soft.com
_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Mike Morris The Music Place 1617 Willowhurst Avenue San Jose, CA 95125 (408) 445-ARTS (2787) ------------------------------------ Your Free Quote: Underlying most arguments against the free market is a lack of belief in freedom itself. - Milton Friedman (1912-), Nobel Prize-winning economist ------------------------------------
Thank you for responding.. The external database is a separate postgreSQL server. I am using the DB::Pg driver already for OTRS. I really wish I could do away with exchange. This is one in many steps. We were using public folders for ticket tracking.
datasource schema in config.pm, in the "Map" array definition, within the "CustomerUser Stuff" section...<<
Our external Data is more in a Company format, so I would leave the User
specific stuff to the already configured ldap lookups to our active
directory and associate those users to the external db for Company data.
I do apologize I am poking into the unknown here with my limited knowledge
of how to format a schema and field mappings to connect the external
database. I would probably have a better understanding if I could get an
example of a schema and mapping of a Company in the Config.pm.
Linking to an exchange server public folder was just a thought but not realy
desired. Ill forego that idea.
Re: [otrs] External Company DB and Exchange Contacts
Mike Morris
Thu, 11 Sep 2008 11:19:49 -0700
It's hard to tell from your post if this will be obvioius to you or not...
but
the first
question is:
* Do you have a driver that allows perl access to your datasource (at an
acceptable performance level)??? I have no idea if this is the case for
Exchange or not... we became a Microsoft Free shop many years ago and I
know nothing of Exchange anymore. (We're also happier, more profitable
and more efficient, btw...)
* If the answer is yes, then it's mostly a matter of defining the
datasource
schema in config.pm, in the "Map" array definition, within the
"CustomerUser
Stuff" section...
I don't remember much more than that... hope it helps
On 11/09/08 10:55 AM, "Mik Rose"
Hi there list members,
External/Separate Company DB's; After a fare amount of time poring over user posts in the mail list archives it appears that it is possible to reference Company information from our own database. What I think I need is an example of this being done. Is there anyone that could post an example of this being done.
Exchange Contacts;
Is it possible to devise a lookup and link in tickets to a contact on an Exchange Public folder?
Regards,
Mikola (Mik) Rose PowerSoft Development Corp. CIO, Information Technology / Support Services Customer Service: 1 (250) 642-0199 Sales Dep.: 1 (888) 833-7697 Support Dep.: 1 (250) 642-0295 www.power-soft.com
Mikola (Mik) Rose PowerSoft Development Corp. CIO, Information Technology / Support Services Customer Service: 1 (250) 642-0199 Sales Dep.: 1 (888) 833-7697 Support Dep.: 1 (250) 642-0295 www.power-soft.com
Hi, Here I wrote short explanation about the external customer database integration I did in our company. Since you use Postgresql I recommend you to use integration based on database schemas and views - it allows you to have single database connection and reliable foreign keys. It will save time for writing complex code if for example you want to do time accounting for different customers. In this case the report (usually) is just a simple join of 2-3 tables. http://lists.otrs.org/pipermail/otrs/2008-August/024394.html Cheers, Atanas Karashenski BlueBoard LLC
Thank you very much...
On 14/09/08 2:24 AM, "Atanas Karashenski"
Hi,
Here I wrote short explanation about the external customer database integration I did in our company. Since you use Postgresql I recommend you to use integration based on database schemas and views - it allows you to have single database connection and reliable foreign keys. It will save time for writing complex code if for example you want to do time accounting for different customers. In this case the report (usually) is just a simple join of 2-3 tables.
http://lists.otrs.org/pipermail/otrs/2008-August/024394.html
Cheers, Atanas Karashenski BlueBoard LLC _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Mikola (Mik) Rose PowerSoft Development Corp. CIO, Information Technology / Support Services Customer Service: 1 (250) 642-0199 Sales Dep.: 1 (888) 833-7697 Support Dep.: 1 (250) 642-0295 www.power-soft.com
participants (3)
-
Atanas Karashenski -
Mik Rose -
Mike Morris