|
|
Troi URL Plug-in
2.6
Troi URL Plug-in lets you post and retrieve
information from the Internet. Troi URL Plug-in can
help you fill in web forms on the Internet, all
from FileMaker Pro. It also retrieves data or
images from any HTTP and HTTPS URL.
|
overview
| download
| details | comments
| buy-it
New version can tweet from FileMaker Pro 11!
The new Troi URL Plug-in 2.6 is an updated version of our
plug-in that retrieves web images, pages and fills in HTTP forms all
from FileMaker. This version adds 3 new (related) functions to make web service authorization and subsequent sending of authorized requests easy. These functions specifically make it very easy to work with a Twitter account and post tweets! We have included an example to get you tweeting in no time!
We also added these useful functions:
- TURL_ToURLEncoded: this can URL encode text (also known as percent-encoding). It can also encode higher Unicode characters, for example Japanese text.
- TURL_HMACSHA1: this can calculate a keyed-hash message authentication code (HMAC-SHA1) signature.
Together with a few bug fixes, the improved proxy support and images handling and Windows 7 compatibility from the 2.5 version, Troi URL plug-in 2.6 is a very powerful internet plug-in.
You can see the complete list of changes on our version history
page.
List of Features
Fill out web forms from FileMaker
Pro
Troi URL Plug-in can help you fill in forms and retrieve
the result directly in FileMaker Pro. It can fill for
example a form similar to this:
And you can submit the data of this form all from a
FileMaker script, without the need of a
browser. In a ScriptMaker Script you can fill this
form with the TURL_Post function:
Set Field [result ,
TURL_Post( "-Unused" ;
"http://www.filemaker.com/greatform/cgi-sys/formmail.pl" ;
"field1=data1&field2=data2&secret=A12474&Submit=Submit%20for%20Processing")]
This will send the data to a web server and get the
result back. A sample result might be:
<HTML><HEAD><TITLE>Example
Web Page</TITLE></HEAD>
<BODY><p>You have posted the data.</p>
</BODY>/HTML>
The actual result can be quite different in your
situation and may also be more complicated.
Get data from the web
You can also use the plug-in like this:
- use the GET method to retrieve data
- use a secure connection (HTTPS) using SSL
- get access to password protected web pages
- use it with proxy
server
- send cookies
Support for Unicode and bigger fields
Troi URL Plug-in can handle up to a gigabyte of data
per field. And it can handle Unicode characters too!
Get images right into a container field!
From the 1.8 version it is possible to get JPEG and
GIF images directly into a container field. This allows you
to harvest images, like photos from a web site!
Suggested Uses
Troi URL plug-in allows you to:
- fill in forms on web sites or your intranet
- get online data like stock quotes, weather reports,
etc.
- automatically add information to listings and online
databases
- search the Internet for terms or other specific items
(like in Sherlock)
Function names
Below are all functions of Troi URL Plug-in:
|
Function
name
|
Short
description
|
|
TURL_Version
|
Use this function to see which version of the
plug-in is loaded. This function is also used to
register the plug-in
|
|
TURL_Get
|
Gets the raw data of the specified URL. This can
be for example the HTML of a web page
|
|
TURL_Post
|
Sends data to the server, using the POST method,
and returns the result as raw data
|
|
|
|
TURL_GetLastProperties
|
Returns information (image type, width and height) about the last image downloaded.
|
|
TURL_Reinitialize
|
Restarts the plug-in
|
|
TURL_SetCookies
|
Sets the cookies text to be used in subsequent
calls
|
|
TURL_SetCustomHeader
|
Sets a custom header to be used
|
|
TURL_SetPassword
|
Sets the password to be used for password
protected URLs
|
|
TURL_SetProgressText
|
Sets a custom text to be used for the progress
dialog
|
|
TURL_SetProxy
|
Sets an explicit proxy server to be used, via which the data is sent to the web server. Now you can also add authorization, by specifying a user name and password
|
|
TURL_SetUserAgent
|
Sets a custom text for the name of the user
agent the plug-in sends to a server
|
|
TURL_SetUserName
|
Sets the user name to be used for password
protected URLs
|
|
TURL_ToHTTP
|
Encodes a text in HTTP format
|
|
TURL_ToURLEncoded
|
URL encodes text (also known as percent-encoding)
|
|
TURL_HMACSHA1
|
Calculates a keyed-hash message authentication code (HMAC-SHA1) signature
|
|
|
|
TURL_GetAuthorizationURL
|
First step to authorize for a web service: gets an authorization URL
|
|
TURL_SendAuthorizationPIN
|
Second step to authorize for a web service: sends the PIN to the web service to complete the authorization
|
|
TURL_SendAuthorizedRequest
|
Sends a request (like posting a tweet), using credentials obtained during authorization
|
User Manual and Extensive
examples
Example databases will show you how to implement the
functions. In addition we've included a user guide in the
download.
Known Issues
Troi URL Plug-in has some limitations. Please be aware of
the following:
- There is no progress dialog on Windows.
- Error codes on Mac and on Windows can be different in
the same situation.
- The maximum size of URLs is limited, but see also the
user guide and here
for more info on URL lengths.
- You can not save data directly to disk. A possible
solution is storing the data in a field and then use the
Troi File Plug-in to write
it to disk.
What are the costs?
 Below
are the prices for our licenses.
|
New
licenses:
|
|
Single user license:
10-user pack:
25-user pack:
|
US$ 69 per user
US$ 299
US$ 449
|
Developer
licenses:
Allows you to include the plug-in with all FileMaker solutions that your company sells to organizations of up to 25 users.
|
|
|
Developer license for Mac + Windows:
|
US$ 449
|
Server/web license
Allows to use the plug-in in server-side scripts and in web published databases using FileMaker Server Advanced (no user limit).
|
|
|
ServerWeb license for Mac + Windows:
|
US$ 299
|
Upgrades from previous versions
If you bought a license on or after May 1st, 2010 the upgrade
is free! Note: Troi URL Plug-in 2.6 works with the 2.5 version of the
registration string. We have emailed all eligible customers a registration string in January 2011. Contact us if you have not received
yours.
If you bought a license before May 1st, 2010 you will need to upgrade to use the
2.5 and 2.6 version.
|
Upgrades from previous
versions:
|
|
Single license upgrade:
10-user pack upgrade:
25-user pack upgrade:
|
US$ 39 per user
US$ 149
US$ 199
|
|
Upgrades from previous
Developer Licenses:
|
|
Single platform Developer license to Cross platform Developer license:
Cross platform Developer license to Cross platform
Developer license:
|
US$ 299
US$ 199
|
-> Buy Troi URL Plug-in online here
Developer License available
For Troi URL Plug-in we have a developer license
specially intended for developers of databases. This license
allows you to include our plug-ins with ALL databases or
FileMaker solutions that your company sells. See the
Developer License page for
more information.
Related pages
On these pages you find some information to help you.
Currently we have these resources:
Version history
page
On this page you can see which new features were added
and what has changed with this and previous versions of Troi
URL Plug-in
Troi URL Plug-in FAQ
On this page you can see a list of Frequently Asked
Questions about Troi URL plug-in.
Proxy settings
page
On this page you can find information on how to use Troi
URL Plug-in with a proxy server (page is from 2006, needs actualization).
Troi URL Plug-in compared to the Web Viewer of FileMaker Pro 8.5
On this page you can read a more detailed comparison between web viewer and Troi URL Plug-in.
Auto
update with FileMaker Server
A page which describes how to start using the
auto-update feature of FileMaker Server 7/8.
Screenshots
A page with a screenshot of getting an image from the web.
Conversion from FileMaker 6
This page helps you convert old style plug-in calls from FileMaker Pro 6 or earlier to
the FileMaker 7 native calls.
Download
Troi URL Plug-in here
|
