Solved

Filemaker Pro DDE Command for Internet Explorer

Posted on 2006-07-07
10
1,214 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
ID: 17062631
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
ID: 17062897
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
ID: 17063211
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
Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

 

Author Comment

by:tammyf
ID: 17063233
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
ID: 17064079
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
 

Author Comment

by:tammyf
ID: 17064776
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
ID: 17065363
Why would you use a send event if a rum command works?
0
 

Author Comment

by:tammyf
ID: 17066880
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
ID: 17067124
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
ID: 17067671
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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

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…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

785 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