mindtpi99

Hi I'm looking for advise. I need to read from an access log, get the result (which is tab-delimited text) and write each line as a separate record in a database. It's a constantly changing file so it'd need to read from it constantly and retrieve any new entries What's the best way to achieve this? PHP? Built-in FM function? 3rd party plugin? Is Filemaker the best way to do it, should I use PHP/MySQL instead? If anyone has any advise/tips it'd be greatly appreciated

Thanks for that - I've attached the page client_details.php.zip

Thanks for that - it now at least starts to load the page, but doesn't display any content below that - but it feels like progress!! I've attached a screen shot so you can see what I mean

The active jobs field is basically a calculation that concatenates the CustomerID with an active job identifier and this is used to create the relationship. If there is an active job for the client it works perfectly, however, if there isn't, the ActiveJobs recordset generates and error and sends it to the error page - I want it still display the client detail page.

Hi What I've done is to create a page with two record sets: From a results page you click on a link to the client record. The client record page has two record sets on it; the client detail (from the clients table) and all jobs linked to that customerID (from the Jobs table). When you click on a link, if there are jobs against that client, everything displays fine, however, if there are no linked jobs for a client the jobs record set returns goes to the error page and gives a 401 error . How do I get it to suppress that error and still display the client detail from the clients table whether there are linked jobs or not? I would have just used a portal but need record set paging and this doesn't seem to work for portals. Alternatively, is there a way I can trap the 401 error and ignore it? Any suggestions gratefully accepted!! Here is the PHP code I'm using: <?php require_once('Connections/PressLogin.php'); ?> <?php // get variable from URL and set to $Variable $ActiveJobs = $_GET['ActiveJobs']; ?> <?php $PressLogin_find = $PressLogin->newFindCommand('Clients_Web'); $PressLogin_findCriterions = array('KP_CustomerID'=>'=='.fmsEscape($_GET['KP_CustomerID']),); foreach($PressLogin_findCriterions as $key=>$value) { $PressLogin_find->AddFindCriterion($key,$value); } $ActiveJobs_find = $PressLogin->newFindCommand('Jobs_Web'); $ActiveJobs_findCriterions = array('ActiveStatus'=>$ActiveJobs,); foreach($ActiveJobs_findCriterions as $key=>$value) { $ActiveJobs_find->AddFindCriterion($key,$value); } fmsSetPage($PressLogin_find,'PressLogin',10); fmsSetPage($ActiveJobs_find,'ActiveJobs',10); $PressLogin_result = $PressLogin_find->execute(); $ActiveJobs_result = $ActiveJobs_find->execute(); if(FileMaker::isError($PressLogin_result)) fmsTrapError($PressLogin_result,"error.php"); if(FileMaker::isError($ActiveJobs_result)) fmsTrapError($ActiveJobs_result,"error.php"); fmsSetLastPage($PressLogin_result,'PressLogin',10); fmsSetLastPage($ActiveJobs_result,'ActiveJobs',10); $PressLogin_row = current($PressLogin_result->getRecords()); $ActiveJobs_row = current($ActiveJobs_result->getRecords()); $ActiveJobs__Clients_portal = fmsRelatedRecord($ActiveJobs_row, 'Clients'); $ActiveJobs__JobsActiveJobs_portal = fmsRelatedRecord($ActiveJobs_row, 'Jobs_ActiveJobs'); // FMStudio v1.0 - do not remove comment, needed for DreamWeaver support ?>

I would have thought it was asking for the root directory for your website that you are defining. This is in /Library/WebServer/Documents If you use MAMP (which is pretty handy) you can set it to be anywhere you want. When you define the site in DreamWeaver just use http://127.0.0.1/ which leads to the above. Is this what you meant? Also, make sure PHP is definitely enabled in the php.ini file - if I were you though I'd just use MAMP, it's free and easy to use

Hi I've just started using Lasso so I can use the Session commands - what I want to know is the correct syntax for to add the current Session_ID via an inline, e.g., [inline: -Add, -Database='orders', -Table='main', -KeyField='ID', 'ClientReference'="[session_ID: -Name='MySession']"] [Error_CurrentError: -ErrorCode] [Error_CurrentError] [/inline] Ta!!

Hi Can someone please help with this. What I want to do is get a value returned to CDML format page (in this case a file name), I then need to get the value into a PHP page that is running in the Apache root (OSX) to create a blind link to the file to download it (I'm assuming there is no way to run the PHP scripts out of the Web Companion Folder). I'm guessing that the best way to do this is with Javascript but I don't know anything about it. Any suggestions greatly appreciated!!

Thanks for that - that's a good idea

Hi I need a CDML search form that searches on the following: - find search term 1 or search term 2 - omit any record of search term 1 or search term 2 whose JobStatus equals "Completed" I know it's all to do with -LOP and -OP but I can't get it to work!! Any suggestions greatly appreciated

Without seeing the code I would think that you left off one of the [/FMP-if] statements

I want to hide the path to the file

Hi Can someone tell me if it is possible to use a form action to trigger the download of a file using CDML or would I need some sort of Javascript to trigger it? thanks

Hi Using CDML I want to create a form where clicking on it downloads a file. I know how to do it as a URL but I want to use a form to suppress the path name from being displayed. The path name to the file will be along the lines of: http://127.0.0.1:443/other/archive/[FMP-currenttoken].pdf Alternatively, is there something you can add to a web page that will force the browser (specifically Safari) to download the file rather than open it in a browser window? Any advice gratefully accepted!!

Hi can someone please tell me if there is any way to get the current user password that they use to login to the database - I can't see anything in scriptmaker to do it ta!!

I have a whole bunch of PDF files (tens of thousands) - what I want to do is use Lasso to search on the text inside the PDFs. Is is possible to get Lasso to search directly inside the PDF files? My other alternative is to catalog all the key words in the files into Filemaker as well as the filename so it serves up the file when the user selects it. In this case is it possible to open the PDF in the browser with the search term highlighted throughout the file? An example of something similar to what I am trying to achieve is the dtsearch web with spider (http://www.dtsearch.com) Any suggestions would be greatly appreciated.

The way I would do it would be by making the format file destination a [FMP-header] file - you could then stick the action in the header file and set the format file for that back to the page that displays the results. If you have several actions to do that can't be done in one form you can move from header page to header page. I use them for hiding response pages from forms and they work really well for me. From the CDML Reference database: --------------------------- What it does The HTTP header of the page sent to the browser is replaced with the text between the [FMP-Header] and [/FMP-Header] tags. None of the text between the tags will appear in the HTML portion of the page. The [FMP-Header] tag must be placed before the [FMP-ContentMimeType] and [FMP-SetCookie] tags in order for them to function properly. The [FMP-Header] tag will replace the current header entirely. Since these tags modify the header, their position is important. One example of the use of a header would be to redirect a browser to a different HTTP server instead of displaying the formatted page. Consult RFC 2068, Hypertext Transfer Protocol -- HTTP/1.1 for more information about HTTP headers. Syntax example(s) Direct the user's browser to the FileMaker home page after processing the request [FMP-Header] HTTP/1.0 302 Moved Temporary Location: http://www.FileMaker.com [/FMP-Header] Other tags that are required [/FMP-Header]

Hi Can someone please tell me how secure Filemaker 6 and FM Server 5.5 are? If I have set different levels of passwords in a database file (admin and general users), is there anyway that someone could get round the admin password to change startup Applescripts in the database (assuming only the admin user has access to these) What I want to do is lock down a database as tightly as possible so users on the network can't get into Scriptmaker or change the start up script. I don't want to bind the databases in Developer as if is networked and runs the web companion. Does anyon e know if there are any backdoors to getting into them? I'm not worried about the web security aspect of it as I have that pretty well tied Does anyone have any suggestions? Ta

I use oAzium Events and find it really good

Hi I've added the following script to some databases I administer inhouse that request a password after a specific date has passed. This script is set as the startup script (using "Perform AppleScript" in Scriptmaker) - each month I'll change the expiration date so users should never see it. Bearing in mind that I'm the only one with the admin password, access to document prefs and scriptmaker is there anyway users can bypass this if they don't have the admin password. If anyone has a better way of writing the script I'd be interested in that as well Ta!! ---------------------------------- property expiration date "January 11, 2005" property mypassword : "passwordtext" on run try set currentDate to (current date) tell application "Finder" if expiration > currentDate then tell application "FileMaker Pro" activate end tell else set the_password to text returned of (display dialog "Enter the password" buttons {"OK"} default answer "" default button {"OK"}) if the_password is equal to mypassword then tell application "FileMaker Pro" activate end tell else tell application "FileMaker Pro" quit end tell display dialog "Sorry, that is incorrect - FileMaker is quitting now" buttons {"OK"} default button "OK" end if end if end tell end try end run

Like Garry says, it depends on what you want to do. If I follow what it is that you want to do, I use [FMP-Header] to perform additional things in the background e.g., when you submit data the response page is the entered data displayed as part of a dataset - is this what you mean? cheers Howard

When I want to find a path name I just create a script like choose folder or choose file And then just copy the path from the result window

I can't see why not, but I don't know how to do it off the top of my head - there are quite a few threads in the forum on similar stuff that might help

Yep, basically all you have to do is replace the following line; Send Mail [ To: email_field, Subject: email_subject_field, Message: email_message_field][ No dialog ] with Perform AppleScript and then stick the following script in the AppleScript window; on run try tell application "FileMaker Pro" set emailaddress to cell "emailaddress" of current record set JobDescription to cell "JobDescription" of current record set JobStatus to cell "JobStatus" of current record set MailSubject to cell "CombinedJobNumber" of current record end tell tell application "Microsoft Entourage" set MyMessage to make new outgoing message with properties

Hi Garry When I click on the link to get me to the inline the link result is; FMPro?-db=media.fp5&-format=mediaactiveresults.htm&-lay=detail&rep=bob&aemediastatus=Requested%20by%20A%2fE&-max=5&-find= The link on the button for the next set of records is; FMPro?-db=media.fp5&-format=mediaactiveresults.htm&-lay=detail&rep=bob&aemediastatus=Requested%20by%20A%2fE&-max=5&-skip=5&-find= The link result at the bottom of the inline on the next results page is FMPro?-db=media.fp5&-format=mediaactiveresults.htm&-lay=detail&rep=bob&aemediastatus=Requested%20by%20A%2fE&-max=5&-find= However, it is still displaying the original records Cheers Howard