Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


IdealData last won the day on September 1 2017

IdealData had the most liked content!

Community Reputation

24 Excellent

About IdealData

  • Rank

Profile Information

  • Gender
    Not Telling
  • Location
    Leeds, UK.

FileMaker Experience

  • Skill Level
  • FM Application
    14 Advanced

Platform Environment

  • OS Platform
  • OS Version

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. IdealData

    how setup custom menu in all layouts?

    However, each layout can be individually assigned I imagine that the "other" layouts are still using the "Standard Filemaker Menus" because that's what was assigned when they were created.
  2. I have a KIOSK mode application (please note NOT a runtime) that has been happily working since around FM11. The basis of the application is a door logging system that needs to pass the collected data on touch screen Windows tablets back to the server. The tablets also collect "user" records from the server so the user can be validated when they enter a PIN code on the tablet. It is designed to be network tolerant and will survive even when the network or WiFi have dropped out - hence it runs locally on the tablets. FM16 appears to have broken this, and I'm suspecting it to be a security issue. The KIOSK solution still runs fine in FM15 talking to a Server 15, and also runs ok using NATIVE FM16 to the same server. But the KIOSK solution in FM16 waits forever when it tries to open a file on the server, or possibly it is not displaying the "Security Alert" dialog. If I hit escape during the attempt to open the server file then the script advances (returns error code 0) but of course the file has not opened. I don't have SSL enabled on the server (don't want to!) and I'm not ready for Server 16 yet. Any one have similar issues or know a fix? Many thanks.
  3. I have tried all combinations of portal with/without scroll bars but cannot make scrolling happen when using finger swipes. It is possible to 'pin' down the scroll bar with a finger and then pull the scroll bar (same as a mouse) however cannot scroll when swiping up/down in the portal body. This has always worked in FM14 and FM15, but does not work in FM16. Any one else have the same experience, or fix? Thanks
  4. IdealData

    adding a container image to the web page

    The PHP and XML access methods have independent extended privileges. Although you have authenticated your PHP session in your script this is not carried forward to the XML engine. Try setting the fmxml extended privilege to a "Guest" account. Support for the old http://username:password@address is almost non-existent. Did you also look at the php method getContainerData()? (NB. does not work for external storage))
  5. IdealData


    You might be better off knowing the UPLOAD speed of the client's internet connection. Whilst it's difficult to give exact numbers I wouldn't consider anything less than 10Mb/s useful except for remote-in methods. It's also not clear how many users are expected. Other factors include the ping response time and the number of router hops between client and server. At the very least test the experience first and get an opinion on performance.
  6. IdealData

    Using FM value list in the web form search

    Hi John The getValueList method is deprecated and replaced with getValueListTwoFields. See the API documentation on your server for details.
  7. IdealData

    Count Down Timer

    Yes, your field definition now looks correct.
  8. IdealData

    Count Down Timer

    Your field must be a CALCULATION field, the storage options are then available at the bottom of the calculation definition. You have defined a NUMBER field with Auto-enter options and so your data is STORED. This means the field will not re-evaluate and will hold the initial value unless "Contract_End_Date" is changed.
  9. IdealData

    getting started FM on the web

    Aussie John. I loaded your test file on my own server and used the code by doughemi. The code has a fault in the error trap - there is no method for code(), it is actually getCode(), see below my modification: <?php //================================= define('FM_HOST', "localhost"); $fm_file = "TestProjects"; $fm_user = 'PHP User' ; $fm_pass = 'arina'; include("FileMaker.php"); //include ('include/filemaker14/FileMaker.php'); # instantiate a new FileMaker object $connection = new FileMaker($fm_file, FM_HOST, $fm_user, $fm_pass); $accessed = $connection->listLayouts(); if(FileMaker::isError($accessed)){ echo $accessed->getMessage(); echo "Sorry, the database is not available at this time.<br /><br />Please use your browser's back button to return to the AMYA webpage."; exit; } else{// else not usually left in file; it is here for testing purposes print_r($accessed); echo '<br>'; } $cmd =& $connection->newFindCommand('PHP Test'); $cmd->addFindCriterion('Name', 'xpamela'); $result = $cmd->execute(); if (FileMaker::isError($result)) { echo 'unable to find Pamela: ' . $result->getMessage() . '(' . $result->getCode() . ')'; die(); } $records = $result->getRecords(); $record = $records[0]; $name = $record->getField("Name"); $color = $record->getField("favorite color"); echo $name.' - '. $color; ?> Now the error trap actually works and should return you a FileMaker error code - notice I have changed the find criterion to 'xpamela' to deliberately force the error - which is of course a 401. getCode() is NOT DOCUMENTED in the Filemaker API for PHP Documents, nor in the Custom Web Publishing Guide and IS INCORRECT on the sixfriedrice blog (I think that's where you started from?). See also the following posting to confirm the undocumented "feature" (!!) https://fmforums.com/topic/74737-geterror-as-code-not-text/ 10-4.
  10. IdealData

    getting started FM on the web

    Aussie John. I suggested you follow the FMI instructions to test matters - that would at least give you some clues. Thanks.
  11. IdealData

    Portal in Web Direct

    Does the version of Chrome meet the minimum for WebDirect. Minimum is v55.
  12. IdealData

    Another User On The Record

    There is a further scenario.. If you are editing a record that has a portal then all the portal rows become locked If you editing a portal row then the parent record is locked, and rule 1 applies again The EXCEPTION to this is when editing the RELATED records from a different layout with a different context. Even if the context is the same as the PORTAL then you can still edit the related records when the parent record is locked. You cannot edit related records in either layout if the related record is actually locked directly.
  13. IdealData

    Another User On The Record

    Mr I. Apart from the obvious record lock, where a user is actually editing the record, there are other scenarios: A backup is running - FMS will lock the database during the backup. You have nightly and hourly backups running? As Josh says, a script is running and has locked the record. A developer is editing the layout!! - Yes, it does report the record is locked if you are editing the layout. A developer is editing the database schema - this locks the database/table when making changes. If a user 'crashes' out then FMS will release the record after 2 minutes. If you run a script via PSOS that edits a record then you need to COMMIT the record before the script ends. Whilst PSOS is 'like' an FM Client I discovered that running off the end of the script without declaring close window/exit app/commit record leaves the record locked. Rule 5 (above) resolves the issue eventually. This is easily overlooked and could be very much your case. And; If this user has a second window open on the same record, and the record has not been committed in the first window then this will also produce as lock but there is a different message if that's the case.
  14. IdealData

    getting started FM on the web

    AussieJohn - it would be a good test to follow the FMI instructions. Might help to resolve your issues. Get it working there first.
  15. IdealData

    getting started FM on the web

    That path does not look right to me. Please read the CWP manual at https://fmhelp.filemaker.com/docs/15/en/fms15_cwp_guide.pdf. In particular section 7 paragraph 4 Incidentally, your test layout name is actually "PHP Test", not "PHP test" as you have used earlier.

Important Information

By using this site, you agree to our Terms of Use.