Solved

Filemaker Pro DDE Command for Internet Explorer

Posted on 2006-07-07
10
1,192 Views
Last Modified: 2009-12-16
I would like to know what commands to use in a Filemaker "Send DDE Execute" step to copy a field from Filemaker and paste it into a field on a website in Internet Explorer.  I have no problem getting filemaker to open the site but I do not know DDE commands nor how to tell it which field in which to paste on IE.
0
Comment
Question by:tammyf
  • 6
  • 4
10 Comments
 
LVL 28

Expert Comment

by:lesouef
Comment Utility
Are you sure this kind of thing is embedded in IE? I never heard of anybody using DDE commands with IE (which is not a real proof I admit!).
If you know the URL to submit this data to, why don't you use the URL command directly?


0
 

Author Comment

by:tammyf
Comment Utility
I need to paste a tracking number from a filemaker record into the tracking field on the UPS website.  I can make filemaker copy the field and open the ups website but the Send DDE event is the only way I can think of to paste it into a website using a PC.  I do not know the DDE commands to put in the Send DDE event setup in Filemaker.
0
 

Author Comment

by:tammyf
Comment Utility
I found a way to do it by making a field that contained the full URL that UPS listed when tracking a package.  I just concatenate the Ups required info with the record tracking number and then I use the Open URL with that field specified.  I still would like to know of a way to use the DDE commands so I will leave this question open with a lower point value since it is no longer urgent.
0
 

Author Comment

by:tammyf
Comment Utility
I retract that last remark about the point value.  It will remain the same.  I really want to know if I can use the Send DDE Event for this even though I have a solution.
0
 
LVL 28

Accepted Solution

by:
lesouef earned 500 total points
Comment Utility
DDE commands, if any, are released to dev people only, so unless there is somebody here who is a microsoft dev person, no chance. Even for word or excel, these commands are not documented in the regular doc.
On top I think the URL method is better, since it can also work on macs, while DDE is a windows only technique. Might be worth to check microsoft site for DDE commands on IE?
0
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

 

Author Comment

by:tammyf
Comment Utility
I have already checked the microsoft site and some other sites and I did find a few of the commands.  Since everything I do have to work cross platform, I am trying to find solutions for things I already do using applescript.  I suppose I should use the Send Event with a visual basic macro instead.
0
 
LVL 28

Expert Comment

by:lesouef
Comment Utility
Why would you use a send event if a rum command works?
0
 

Author Comment

by:tammyf
Comment Utility
I am not sure what you mean.  I currently use filemaker to run an applescript that goes to a URL, downloads the info and saves a working copy and a backup dated copy, then it imports that info into filemaker.  Since I am teaching myself applescript, for fun I had it announce to me when it is finished.    I would like to have that script work from a pc also so I figured that I would need to write a VB script to do the same thing the applescript is doing.  I am certainly no expert but I have found ways to automate the things I need done.  I thought 'Send Event' would be the way to get the VB script to run from Filemaker.  I do wonder why the DDE execute command is available if there is no way for regular people to get the right syntax to use it.  Any advice is appreciated.  
0
 
LVL 28

Expert Comment

by:lesouef
Comment Utility
sorry, I mistyped my previous post, it should have been " if a URL command works?"
I thought the data post was the only thing to do, so the URL command was enough. Of course if you need more, an applescript is one of the ways.
The send event is the PC equivalent indeed. According to what you want to do, a VB script may be more complicated than a regular CMD script, but if you are VB aware, why not.
Also consider the Troi URL plug-in (www.troi.com) which allows quite a few things on URLs.
And about DDE, why did they make it available? probably because it is an interesting feature, it still allows to open or print a word document from within filemaker. But it remains widely unused because very few software companies are documenting it, even when they support it.
0
 

Author Comment

by:tammyf
Comment Utility
Thanks for the explanation on DDE.  I am already using a troi file plug in for part of the script I mentioned above.  I think I need to look at some of its other uses.  As for VB, I am learning that on my own just like applescript in my attempt to automate more of my increasing workload.   Thanks for the advice.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

744 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now