[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 198
  • Last Modified:

From Command Prompt to Access DB in Real Time

I have a txt file that includes the names and phone numbers. This file is read by a dialing software and then the number is dialed. In the other room, the operator can see the number and the name of the person, who the program is calling. The operator sees the number in Dos prompt / Cmd line mode. It looks like something like this
Calling: Asim Meesaq
           1234567890
           
            XYZABC(AFTER FIRST CALL IS COMPLETED)
           1234567890

Now the problem is that I want to see this results in Access window. Reason, its more clear, more prominent and looks good. Plus it keeps a data. So in other words I want to the operator to be able to see what they are looking at in the dos promopt at the moment, in access forms. If there is a better idea or easier way, I am willing to acquire that way too. The bottom line is that the screen infornt of the operators should be nicer plus they should be able to write some comments when they are talking over the phone to the customer. Right now, in Dos prompt/ command line, they can not write any thing what they are talking to the customers. So they have to switch the screens betwwen the dos and access to write down the comments, and on top of that they have to type the name and phone number so it takes too long of their time. Even a small VB script if it can get the job done will do fine for me.

Thank You guys. And we will be intouch
Asim
0
syedasimmeesaq
Asked:
syedasimmeesaq
  • 3
  • 3
  • 2
1 Solution
 
Steve BinkCommented:
How does the data get into the DOS window?  If the dialer program puts it there, you must have a way to intercept that communication, or send it to Access instead.  Tell us more about the dialer.
0
 
ArjiCommented:
Actually, I believe there is a phone dialer in Access.  
You must have a working Hayes or Hayes-compatible modem to use this procedure.

Open a table or form in Datasheet view (Datasheet view: A window that displays data from a table, form, query, view, or stored procedure in a row-and-column format. In Datasheet view, you can edit fields, add and delete data, and search for data.) or a form in Form view (Form view: A window that displays a form to show or accept data. Form view is the primary means of adding and modifying data in tables. You can also change the design of a form in this view.).

-On the View menu, point to Toolbars, and then click Customize.
-Click the Commands tab in the Customize dialog box.
-Click Records in the Categories list.
-Drag AutoDialer  to the Form view or Datasheet view toolbar, or to a custom toolbar.
-Click Close.
-In the form or datasheet, select the phone number you want to dial.
-Click AutoDialer  on the toolbar.
-Check to see that the phone number is entered correctly, and then click OK.

Note  You can change your modem options by clicking Setup in the AutoDialer dialog box.

You could use this to dial phone numbers from within your Access form.
0
 
syedasimmeesaqAuthor Commented:
Thank You for the quick reply. The dialer programs reads the file from a text file which is called, test.out
Then it sends that data to the dos prompt.
For the second reply, Access does have the dialing capabilities but I don't want to use the modem. i have to use my telephony device which unfortunately are not a product of dialogic or brooktrout. So using already build functions in access is not an option for me.
Somehow I should be able to getthis data which is displaying on Dos and just display it in Access form.
Routinet, the dialer is written using VS C++ 6. It takes its data from that test.out file and dials the numbers. There is a client , server integration in the dialer. Where the operator is a client and the dialer machine is a server. the client registers with the server using Dos prompt.
I hope that helps
Thank You
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
ArjiCommented:
Does your dialer program have a Telephony API available?
0
 
syedasimmeesaqAuthor Commented:
yes it uses Dialogic APIS
0
 
ArjiCommented:
If it's 'call-able' from VBA,  maybe you can call the dial routine with the API and dial a number with a Command Button from Access.  A lot of APIs are usable from VBA.  
0
 
syedasimmeesaqAuthor Commented:
I don't think it will work
0
 
Steve BinkCommented:
As I see it, your options are limited...

1) If available, use an API interface with the dialer to retrieve the data you need.  This depends on whoever coded the dialer leaving such an interface open and available, and will require documentation on how to use it.  
2) If you get the handle for the DOS window, you MIGHT be able to read data from it, or at least hook into the data stream going to it from the dialer.  

Neither option looks friendly, and I wish you luck in exploring them.  
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 3
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now