Jump to content

djlane

Members
  • Content Count

    168
  • Joined

  • Last visited

Community Reputation

0 Neutral

About djlane

  • Rank
    member

Profile Information

  • Gender
    Male

FileMaker Experience

  • Skill Level
    Intermediate
  • FM Application
    15 Advanced

Platform Environment

  • OS Platform
    Windows
  • OS Version
    Win 10

Recent Profile Visitors

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

  1. Turns out this was just in the field definitions. UNCHECK : Do not replace existing value of field UNCHECK : Prohibit modification of value during data entry CHECK : Data validation, unique values only, Validate always UNCHECK : Data validation, allow user to override during data entry
  2. We have a duplication script takes a single record and duplicates it (plus all related records) around 50 to 100 times. We are using get(UUID) as the auto entered calculation of the pk. Maybe once in one hundred times or less, MS reports a duplicate pk. When we check the database where the record was created (Hub), there is no duplicate key. The duplicate is only on the spoke database, ie in a record created completely by MS. (For this test we created all records on the Hub only). So this means that MS is creating a record in the spoke database but using the wrong primary key for that record, presumably the pk from the record that was duplicated. We observed that this only happens when the duplication script runs while MS is actively syncing. So, we are wondering if it's possible that MS is somehow able to capture the primary key of the original record just as it is in the process of being duplicated? Is it possible that when FM makes a duplicate record, the record is published to the database first, then the auto enter pk calculation updates the record with the new pk , and in that millisecond window, MS has grabbed the old pk ?
  3. FM17 What's New page says : "Work while reconnecting If you lose your network connection, continue working with files that don’t depend on that host while the connection is being restored." Is this referring to the infamous spinning blue circle in WebDirect ? That thing happens way too often.. I'm also wondering what files you might be working on that "don’t depend on that host" ?
  4. djlane

    Web Viewer -- "Unsupported Browser"?

    I'm having the same problem now when displaying Google maps in a Web viewer. The WebViewer says that my browser is not supported, but when I click on "Learn More" it shows that I have the latest version of IE (IE 11 on Windows 10) The exact error message is "You are using a browser that is not supported by the Google Maps JavaScript API. Consider changing your browser. I updated to the latest Java, still the same. This google api page shows that IE 11 is supported https://developers.google.com/maps/documentation/javascript/browsersupport I have tried everything here http://answers.microsoft.com/en-us/ie/forum/ie11-windows_7/getting-message-that-ie-browser-is-not-supported/be916dc1-b8a8-4967-a2fe-eab537e47fea?auth=1 No change, and anyway Google Maps works fine in an actual IE 11 window. The Web Viewer seems to actually work fine - just has that annoying message. it's happening in Fm 14 and 15
  5. Thanks Wim. I had no idea that you can use a browser like that to view data and perform actions in a hosted database. But my original question still remains - is there a way to trigger a script automatically when a field value is changed via ODBC ?
  6. I have a system for calculating golf handicaps. I noticed that a handicap of 14.5 rounded to 14 instead of 15. A players playing handicap for a round of golf is calculated as Handicap Index / 113 * Course Slope Rating. In this case the Handicap Index is 14.5 and the Slope is 113. The playing handicap is 14.5, which rounds to 15. So I opened a data viewer window and entered Round(14.5, 0). The result is 15, which is correct. Again in the data viewer I entered Round(14.5/113*113) and the result is 14. That seems wrong to me. I entered 14.5 / 113 * 113 on my calculator (an old Casio), and strangely, the answer is 14.4999999. On my phone calculator and in excel, 14.5/113*113 evaluates correctly to 14.5 Round(14.5/113*113) correctly evaluates to 15 in Excel. Am I doing something wrong? (This is in FMPA13)
  7. I have an application that was using IWP under FM Server 12, to allow my friends and friends of friends to upload their golf scores, and my system would calculate their USGA handicaps. After upgrading to FM Server 13, IWP not longer exists, and WebDirect does not support mobile devices. So, I set up an alternative server using FM12. A lot of guys that I don't have contact details for, used that IWP based system to upload golf scores. So I don't have a way to tell them all the new URL. Using the old IWP URL, you are presented with a screen that says "The requested page is not found. Check the URL you are using to access FileMaker WebDirect." I want to edit that page to add some additional information telling them the new URL etc. But I can't find any document with that content in any FM Server folder or sub folder. Anyone know where I can find it ? thanks
  8. OK, I found what i think is the problem, and a partial solution. Problem The problem appears to be the keyboard. On a mobile device, the keyboard pops up when you enter an entry field. When using WebDirect on a mobile, you will notice that when you place the cursor in any field, the keyboard keeps appearing and disappearing, making it almost impossible to enter anything. If you do manage to enter a few characters and get one wrong, you will have as much difficulty trying to erase characters. It happens in any field, not just drop-downs. I assume (but cannot confirm) that a mobile with a fixed keyboard won't have this issue. Partial solution SwiftKey Keyboard app has an option whereby you can dock and undock the keyboard. If you undock the keyboard, the problem mentioned above does not happen. (Well, the keyboard disappears once only, not continuously). When the keyboard is undocked, you can move it around the screen, however, it might cover the part of the screen you are interested in, so you might need to push the screen or keyboard around so you can see what you are entering. In normal mode, the keyboard will never block the field you are entering. Maybe it's this behaviour that's causing difficulty for FM. So, a little inconvenient, but if you need to access a database using Webdirect on an android mobile, it does work. (not yet available for iPhone or Windows phones) Swifkey is available here : https://play.google.com/store/apps/details?id=com.touchtype.swiftkey New note : seems that in Find Mode, you can't enter text at all. You'll have to use a workaround for finds.
  9. Dropdowns in IWP using a mobile device worked fine, but with FM13, IWP is gone. FM says that "FileMaker WebDirect is not currently designed for use on a mobile device." Well, that's a little inconvenient for those of us who own a device which does not support FM Go. I have a system which tracks golf handicaps for my golfing group. The guys enter their scores after playing a round, usually using their phone. Now it doesn't work anymore. I have tried Firefox, Chrome and Dolphin browsers. I tried using popup menu and drop-down list. None work properly on a mobile, all work fine using a desktop browser. Anybody gotten this to work ?
  10. I had this same problem and it had me stumped for a week. Apparently, both the programs for 64 bit and 32 bit ODBC DSN have the SAME NAME ! They are both called odbcad32.exe If you go to Start > Run on Windows 7 64 bit and run odbcad32.exe what you are actually running is the 64 bit version. I had wrongly assumed it was the 32 bit version due to the 32 in the name. So make sure to use the version of odbcad32.exe in c:WindowsSysWOW64
  11. djlane

    Best Specs for FM12

    12 GB RAM ? OK, this is the point that I'm making Steven. FM says 8 GB is "recommended", and yet you say 12 GB is "a good starting point". So really what should be on the FM website as recommended for Windows 2008 server is "12+ GB".
  12. djlane

    Best Specs for FM12

    Great, thanks Wim. They need to put that info on their website as well !
  13. djlane

    Best Specs for FM12

    FM have issued a list of minimum and recommended specs for FM12 http://www.filemaker.co.uk/products/filemaker-server/server-12-specifications.html They show the recommended RAM and HDD space for each supported Operating System - my question is, does it make a difference which OS we use ? ie does it make any difference if we use Windows 7, or 2003 or 2008 ? Or 32 bit vs 64 bit ? FM just says they are all supported, but does not seem to say if one is better than another. Am I wrong in thinking that a server that is hosting databases that are larger or busier or have more users might run better on one OS vs another ? Or does it really not matter which one you use, as long as you follow the recommended RAM and HDD space for that OS? djlane
  14. djlane

    Need advice

    Eyeguy, You can use the UniqueValues Custom Function http://www.briandunning.com/cf/596 Use a self join, and make a calculation field, eg. ZipCodeListAll which is List(related::ZipCode). That gives you a field containing a list of all the zip codes. Then create another field UniqueValues(ZipcodeListAll). You could also use a script to set these fields instead of using calculations, which might be a little slow to display.
×

Important Information

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