Terry McDanel
09-12-2003, 08:37 PM
Mac OSX - Safari - SQL - Forte - Troi URL - FMP6
I eventually need our FMP solution to interact with a SQL database
that, apparently, i wont be given direct access to, that is cant send
SQL commands directly to. So the front end is a web site delivered by
Forte. It would seem to me to be reasonable to expect to be able to
automate logging in, downloading information by requesting particular
pages and uploading by html code with Troi URL plugin.
For example, a user clicks a link for "Homeroom Student List", gets a
page with a homeroom number pop-up button, sets the button, clicks Go,
and receives a list of students and IDs. So my first question is,
is it realistic to duplicate this with an automated FMP script & Troi
URL?
When doing this with a browser, the http address appears not to change.
It appears to remain:
http://215.205.130.6/cgi-forte/forteisapi.dll?ServiceName=dscyService&Te
mplateName=signonsucess.htm&districtid=S1&schoolid=GU&year=2004&termcode
=1
Is there a way to capture the http exchange to duplicate it? Or does
it work differently than i imagine, through a separate port, via
javascript... ? i dont know about this stuff and have a lot to learn.
b
Normally at sites like this i have seen a lot of code going up directed
to cgi, that when not encrypted, is relatively intelligable. In this
case i am not seeing any. Does Forte work in a different way?
Is it possible to upload information to web pages like this by "filling
in fields", clicking radio buttons, popups, etc, with FMP6 & Troi URL?
tmcdanel at fastmail dot fm
I eventually need our FMP solution to interact with a SQL database
that, apparently, i wont be given direct access to, that is cant send
SQL commands directly to. So the front end is a web site delivered by
Forte. It would seem to me to be reasonable to expect to be able to
automate logging in, downloading information by requesting particular
pages and uploading by html code with Troi URL plugin.
For example, a user clicks a link for "Homeroom Student List", gets a
page with a homeroom number pop-up button, sets the button, clicks Go,
and receives a list of students and IDs. So my first question is,
is it realistic to duplicate this with an automated FMP script & Troi
URL?
When doing this with a browser, the http address appears not to change.
It appears to remain:
http://215.205.130.6/cgi-forte/forteisapi.dll?ServiceName=dscyService&Te
mplateName=signonsucess.htm&districtid=S1&schoolid=GU&year=2004&termcode
=1
Is there a way to capture the http exchange to duplicate it? Or does
it work differently than i imagine, through a separate port, via
javascript... ? i dont know about this stuff and have a lot to learn.
b
Normally at sites like this i have seen a lot of code going up directed
to cgi, that when not encrypted, is relatively intelligable. In this
case i am not seeing any. Does Forte work in a different way?
Is it possible to upload information to web pages like this by "filling
in fields", clicking radio buttons, popups, etc, with FMP6 & Troi URL?
tmcdanel at fastmail dot fm