How do I pass infomation to another application?

Posted on 2003-02-28
Medium Priority
Last Modified: 2010-05-01
ok my problem is that I got this program that will recieved an ID from another computer and upon recieving it, the user can choose to accept this ID.
If this ID is accepted, it should pass the ID to the CRM system and then display the details of the customer with the ID.

Now my problem is how do I go about passing the ID to the CRM system to invoke a search on the system and then displaying the result from my program?

Can you suggest some ways for me to do this?
Question by:victkh
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
  • +4

Expert Comment

ID: 8046508
if the crm application has an API maybe that's the way
if it has DDE maybe that is the way
at worst case you could do something like: find the CRM app window and set focus to it, them use the sendkeys command to simulate user trying to find this ID

Expert Comment

ID: 8046627
yeap, at least you should know how this ID is accepted by the CRM app, have you tried passing this ID as a parameter, like Shell "crm.exe IDString" ?
if you have the source or you know how it works,it's rather easy, but if you don't, you may possibly debug it(by softice or other debuggers) to check out the way ID is passed.

Expert Comment

ID: 8046637
Perhaps you can find a way to get access to the data source of the CRM without having to interact with it directly.  If the CRM has any capability to export data then you could search for the information you need in external files...or if the information is kept in a database that you can have access to over a network then you can search for the result directly from your own application and bypass the CRM.
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Expert Comment

ID: 8046903
You have basicly 4 options:
DDE: don't know too much about this one
COM: interface
API: calls the send messages to other apps
File Drops:  We have several legacy systems that make wide use of this.  Its probably the most horrid means of interapplication communication but it will work with any laguage that can read a text file.  You basicly have one prog make and drop the file, and then have the other prog poll the direcory for this file on somesort of regular interval.  The plus side to this is that it can often communicate with programs that never meant to be able to speak with other apps.

Expert Comment

ID: 8047465
If COM, DDE and API is not possible you can use sentkeys to get the Infos to the App. (It,s not a verry nice Way, but its possible!)

Expert Comment

ID: 8048908
And you could try running a report tool from the CRM to report this cust to a file and read this afterwards.

Also if this is a modern CRM maybe it has WebServices so you can submit a http request and get XML data in return....

Author Comment

ID: 8054347
erm.. thanks so far for answering my question but basically, I must take in the fact that there alots of CRM on the market(sorry my company does not work with only one CRM), and I must take in regard, that my program must work for most of the popular CRM..

So far, my boss did suggest, that sending keystroke to the CRM by using the Spy++ to find the CRM window.But it might not work if i got another type of CRM.

Accessing the datasource is not the way, as most CRM do not had the same type of datasource.
IF i use the API, will it work when i use another CRM?

But as for Dynamic Data Exchange(DDE), I don't know much about it but do hope someone can provide me more information and Da_Weasel (Can you explain more on the file drop method?)

Thx in advance

Accepted Solution

DanAvni earned 150 total points
ID: 8055360
Hmmm.... Well if you are going to use diffrent CRM applications i do not think there is one solution that will fit all of the CRM applications out there (or at least the major ones). i think that you will need to code support for each CRM application individually based on the current version of the application (using the sendkeys is the most dangerous way here because key strokes might change between versions of the CRM app.)

best bet is DDE (if the CRM app supports it) which i believe will be supported with version changes of the same CRM app for backward competability.

more on DDE is at:

there is also an explanation there about automation which might be another solution to your question

again it must be written for each specific application.

Expert Comment

ID: 8058111
Basicly the 'file drop' method is this:
One program creates a file in a place on the network when some event happens.  Another program checks that network location for the existence of that file.  If is finds it then it opens it and reads the data.

We use this to get our order entry software to open to the appropriate account.  A call comes in and is assigned to an operator.  A file is created that has the same name as the computer that the operator is using.  The order entry software checks to see if the file [computername].pop exist.  If it does then the application opens the file, reads the number from it, and attempts to open and account with that number.

This is certainly not the best method but its a great fall back when nothing else will work.

Author Comment

ID: 8068767
Currently, there no a sure solution for my question but it seem that, no one else can provide me answer, so i shall accept the one closely solution that i can be use..so as to close this question as well

Sorry to the other guys

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.   There is also a companion Debug Toolbar that looks like the followin…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Suggested Courses
Course of the Month15 days, 4 hours left to enroll

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question