Hi Brian, I read the reference in the DP Manual regarding the Transaction Log but it doesn't explain much of anything regarding it's use in a web environ. If I understood your article right ... The PERL script (which I assume is a type of CGI script) invoked from the website, triggers DP in the server to run a specific panel's transaction log report, then shuts down DP again, reads the log file searching for a match to the parameters selected by the web user, retrieving said data and displaying to the web user's screen. Unfortunately, I didn't understand where (or how) you triggered DP to start and run the specific report.
Please let me know if my very limited understanding is at least in the ballpark or if I'm not even in the same zip code that maybe I should get professional help. Thanks. Ed. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of E. Marfil, MAST UNITED Sent: Monday, August 06, 2007 1:25 PM To: 'Dataperfect Users Discussion Group' Subject: RE: [Dataperf] Linking DataPerfect data to the Website Hi Brian, Thank you for the link and for posting your process. There is a lot of new information to digest and more research on my part to understand the info. Even understanding only a small portion of it I can see that you must have spent a lot of effort in keeping the construction as simple as possible but still derive the results you aimed for. Regards, Ed. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Hancock Sent: Sunday, August 05, 2007 6:59 PM To: Dataperfect Users Discussion Group Subject: Re: [Dataperf] Linking DataPerfect data to the Website Hi Edward, I have put some notes together on my website about the web enabling of an application.. http://brileigh.net/bws/story/ I was hoping to release a commerical application based on it for this year, but I have been snowed under with other work, so I have stilled used the pilot of it again this year... It is working well, and is very reliable. I have served up hundreds of thousands of session on it now... Regards Brian ----- Original Message ----- From: "E. Marfil, MAST UNITED" <[EMAIL PROTECTED]> To: "'Dataperfect Users Discussion Group'" <[email protected]> Sent: Monday, August 06, 2007 5:28 AM Subject: [Dataperf] Linking DataPerfect data to the Website > Hello all. > > I'm seeking advice on how to provide data from a DP database to a website > inquiry prompt. > > I'm trying to build a website where users can query an order number and > the > result will show the historical and current status of that order. The > status data is stored in a DataPerfect database on my server. All I need > is > to have the webpage extract it from DataPerfect. I'm not HTML savvy so > I'm > not sure if this is simple to do or not. > > Right now, my option is to have DP run a report creating a file for each > order number (using the number as the filename) with its status history > and > when queried, the website opens the filename and displays the data. > Unfortunately, this means the data is only as fresh as when the DP report > was most recently run, as well as having to manually run the report > frequently. I'm wondering if there is a more "real-time" method to this > and > hopefully automatic or less human involvement to keep the data current. > > Thanks for any opinion. > > Ed. > > _______________________________________________ > Dataperf mailing list > [email protected] > http://lists.dataperfect.nl/mailman/listinfo/dataperf > _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
