VKontakte.DJ
forum traveling
 

Celestial Software

...better by design

Home Support SSH Client Forums
Welcome, Guest
Please Login or Register.    Lost Password?
DDE (dynamic data extract) with AbsoluteTelnet? (1 viewing) (1) Guest
Go to bottom Favoured: 0
TOPIC: DDE (dynamic data extract) with AbsoluteTelnet?
#2653
DDE (dynamic data extract) with AbsoluteTelnet? 12 Years, 6 Months ago  
Howdy's,

I just want to double check.. (I might have missed an option somewhere).. But AbsoluteTelnet doesnt support DDE (dynamic data extract) right? (kind of like "data scraping").

In my current emulation program, you can highlight an area of the terminal, copy, and then 'right-click' and use 'Paste Special' into Excel 2003/2007, and choose 'Paste Link'...

Thanks!
Cya
Hugo
hugow (User)
Fresh Boarder
Posts: 9
graphgraph
User Offline Click here to see the profile of this user
Logged Logged  
 
The administrator has disabled public write access.  
#2654
Re:DDE (dynamic data extract) with AbsoluteTelnet? 12 Years, 6 Months ago  
And what exactly does this allow you to do?

Brian
bpence (Admin)
Admin
Posts: 1404
graph
User Offline Click here to see the profile of this user
Logged Logged  
 
Brian Pence
Celestial Software
SSH , SFTP, and Telnet in a tabbed interface for Windows XP, Vista, Mobile, and others
 
The administrator has disabled public write access.  
#2655
Re:DDE (dynamic data extract) with AbsoluteTelnet? 12 Years, 6 Months ago  
It allows us to pull data from our legacy order system (telnet connections into a unix box with sales application) into Excel, and create - for example - 'Quotes' .. for faxing/emailing to customers etc.

Thanks
hugow (User)
Fresh Boarder
Posts: 9
graphgraph
User Offline Click here to see the profile of this user
Logged Logged  
 
The administrator has disabled public write access.  
#2656
Re:DDE (dynamic data extract) with AbsoluteTelnet? 12 Years, 6 Months ago  
So you have excel macros that grab data from portions of the screen?
bpence (Admin)
Admin
Posts: 1404
graph
User Offline Click here to see the profile of this user
Logged Logged  
 
Brian Pence
Celestial Software
SSH , SFTP, and Telnet in a tabbed interface for Windows XP, Vista, Mobile, and others
 
The administrator has disabled public write access.  
#2657
Re:DDE (dynamic data extract) with AbsoluteTelnet? 12 Years, 6 Months ago  
Not macro's no.. the relevant excel cells have the following 'statement' in them:

=Emulwin|'10.1.1.1'!'ScreenRect(0,9,1,9,9)'

Where 'EmulWin' is the application, '10.1.1.1' is the name of the window in the program, and 'ScreenRect(w,x,y,z)' is the area of the terminal to 'capture' from ...

This dynamically updates as long as the spreadsheet is open and the 'EmulWin' program is open -- EmulWin is a program called 'Tun EMUL for 32-bit windows' ... we bought it back in the 90's :)

Thanks
hugow (User)
Fresh Boarder
Posts: 9
graphgraph
User Offline Click here to see the profile of this user
Logged Logged  
 
Last Edit: 2011/09/12 04:37 By hugow.
 
The administrator has disabled public write access.  
#2658
Re:DDE (dynamic data extract) with AbsoluteTelnet? 12 Years, 6 Months ago  
AbsoluteTelnet/SSH *can* be used as an activeX control. I wonder if we can figure out some way to get Excel to talk to it.

Brian
bpence (Admin)
Admin
Posts: 1404
graph
User Offline Click here to see the profile of this user
Logged Logged  
 
Brian Pence
Celestial Software
SSH , SFTP, and Telnet in a tabbed interface for Windows XP, Vista, Mobile, and others
 
The administrator has disabled public write access.  
#2659
Re:DDE (dynamic data extract) with AbsoluteTelnet? 12 Years, 6 Months ago  
Yeah - that would certainly be an option to look at... Do you have any pointers (examples with AbsoluteTelnet etc) to get me running? (i am unfamiliar with ActiveX but I tend to learn quick)..

Txs
hugow (User)
Fresh Boarder
Posts: 9
graphgraph
User Offline Click here to see the profile of this user
Logged Logged  
 
The administrator has disabled public write access.  
#2660
Re:DDE (dynamic data extract) with AbsoluteTelnet? 12 Years, 6 Months ago  
First, you need to figure out how Excel invokes ActiveX controls. This part, I'm unsure about. Every application tends to have its own methods/capabilities in this regard.

Second, read up on the AbsoluteTelnet API. THis API is used both in the VBScript scripting language built into Absolute for automation (login, authentication, screen scraping, etc) and it is also the same API used by the ActiveX control. www.celestialsoftware.net/terminal-featu...sh-vbscript-api.html

Third, there is an example program installed in the AbsoluteTelnet/SSH startup folder called 'AutomationTest' which is a C# program that uses AbsoluteTelnet/SSH as an ActiveX control. You can use it to test specific calls and to see what you get back.
bpence (Admin)
Admin
Posts: 1404
graph
User Offline Click here to see the profile of this user
Logged Logged  
 
Brian Pence
Celestial Software
SSH , SFTP, and Telnet in a tabbed interface for Windows XP, Vista, Mobile, and others
 
The administrator has disabled public write access.  
#2661
Re:DDE (dynamic data extract) with AbsoluteTelnet? 12 Years, 6 Months ago  
Ok - thats great - thanks for the help!
hugow (User)
Fresh Boarder
Posts: 9
graphgraph
User Offline Click here to see the profile of this user
Logged Logged  
 
The administrator has disabled public write access.  
Go to top