Jump to content


  • Posts

  • Joined

  • Last visited

  • Days Won


Everything posted by IdealData

  1. In your original post you mentioned “a client needs this soon”. Is your client also running v14? If so, how do they propose to keep their system operational? v14 is now over 5 years old and is no longer supported.
  2. No, I am referring to CHROME on your phone - it's obvious then. You are running CHROME on your phone, aren't you?
  3. I'm no JS pro either. Check out qrserver.com It's an online solution but you could collect lots of qrcodes to use later.
  4. I downloaded and can confirm that FM Go 16 fails. Maybe this has something to do with it - it looks like a platform issue. https://community.claris.com/en/s/question/0D50H00006dsmn6/fmp-go-17-web-viewer-with-js-not-working
  5. If you're using WebD on Android then stick to Chrome (that's the only supported browser anyway). I'm not sure which browser you're running there but it don't look like Chrome. Make sure "Desktop Site" in NOT checked on the top-right menu. That would give the exact result you are describing. Incidentally, WebD works very well provided you allow it do so. I have an entire business management solution that runs all platforms and all devices. I also use 320px wide, but only 480px height to accommodate older phones., but that's really a design decision that's over 4 years ago. Newer releases of FM Server have raised the bar for both iOS and Android platforms and a 320px wide phone that meets the specs is unlikely to be even available now.
  6. Hi I am not an expert with PHP but see below some points that might get you a better performance.. You don't mention the specs on your hardware but I'd expect something pretty serious - SSD + 16GB + 8-Core?? This is something you can address easily. Is your solution in multiple files? How many tables? How complex? How many internal FM users? Adjustments here will obviously take longer. AFAIK the PHP engine is fed by XML calls. I'm not sure how the REST API is fed but it would make sense if it WAS NOT from XML as future editions of FMS are certainly heading towards the REST API and the PHP outlook is looking uncertain (the Linux version distinctly says there will be no PHP/XML options) and general advice is to go with the REST API. Is your PHP optimised? When FMS returns data to the PHP or REST API then it is based on the target layout and returns all the fields on the layout. This includes fields which are outside the normal viewing area too! If you pursue the SQL data method then the ESS performance hit will land on the internal FM users. Can't comment on MirrorSync but you sound like you understand it pretty well. Have you considered WedDirect? WebD offers the ability to implement multiple worker machines to spread high load situations - but your licensing costs could be dramatic! Sorry, no actual answer but do use this as a checklist.
  7. My understanding is that the ExecuteSQL statement will not rely upon the context of the layout, so any layout will do. FileMaker layouts are all about context, and you must be on a layout to do anything; but not everything needs context.
  8. As Fitch says, prove the data is missing first - it may just be missing the relationship key or other data that's obscuring it. In particular look at the data as a list or table view - and check the Get(RecordID). If there are gaps then that proves the records existed at one point. You don't need a button to delete records in WebD... 1. Are the menus available to the user? 2. Did you check ALL the relationships? Cascade deletes happen if there's any single instance of a table occurrence (with "delete related") even if you didn't delete the record from that context? 3. Cascading deletes can work BOTH ways. If you have the relationship setup to delete the parent when the child is deleted then you could easily achieve your situation. 4. Did the WebD session terminate or lose network? 5. Is the user using a compatible browser? Check application and version compatibility with your server. Your application should be checking and validating the web browser at start up. FileMaker does not prevent incompatible browsers. 6. Is there any scripting involved? That's your bag. Getting the wrong context is all too easy. 7. New user?? Mmm... I'm taking note of your "newbie" status so some of the above might be obvious if you're a more experienced developer.
  9. Thanks Laretta. Now i just need my download links that are now 72 hours overdue!
  10. Can you point me to this new script step in the online help guide please. https://help.claris.com/en/pro-help/#page/FMP_Help%2Findex.html
  11. Sounds brilliant - but I can't find it in the online help.
  12. All of the curl commands require a space before them so, & "--data-binary @$file\"" & Char(13)&Char(10) should be & " --data-binary @$file\"" & Char(13)&Char(10) I'm not convinced you need the CR/LF pairs. Also, have you tried running the curl command manually - from the command prompt?
  13. Is the Content-Type correct? If this is PDF should it be application/pdf?
  14. In your child file you need to capture the script parameter. Are you doing that? Set Variable [$sp = Get(ScriptParameter)]
  15. If your object is appearing on all panels then it is not inside the slide control at all. A quick test is to move the slide control and if the object moves with it then it is inside the slide control, otherwise it is outside. I have found that when you drag/drop an object then it will place it inside the slide control, however other methods of object movement (alignment, setting the position manually) do not place the object inside the slide control - merely at the position specified. I suppose FM can't determine which control panel to place the object in if you simply specify the position because all the panels occupy the same coordinate space. Use the Layout Objects tool to see a heirarchy of all objects on your layout. It really explains a lot.
  16. Aaaahh... of course you're executing an SQL command however it will use the fmapp privilege set because you're not going through the ODBC driver, it is actually an FMP command, but using the plugin. So, ODBC not required. Must be a permissions thing. Interesting you can access the security setting but not the script workspace - custom menus??
  17. So, now you know how to add TOs to your file then why not establish a relationship to it? Relationships can be sorted, so you can get a reverse sorted table to access the end of the table first. AFAIK FM relationships can be cached, however SQL is never cached. The report to XLSX is fairly slow, try CSV instead.
  18. Or even consider HOSTING options - there's plenty around, just google "filemaker hosting". Your single file requirement and low user count is ideal for this.
  19. I have been victim of this may times too. As far as I understand it FMS runs the http service with settings that are generated during the FMS install. Sadly, when macOS updates then the http service may be left incompatible with the FMS settings. You mention that the WPE doesn't start automatically is one I have witnessed too. Ultimately this needs a re-install. Personally I turn off OS-updates and Java updates too. Purists might reckon I'm leaving the machine "exposed", but I don't really want to be a slave to the machine! I've also managed to work out manual starting of the web services, but they also fail eventually. Incidentally, if you plan to upgrade to FMS18 then be prepared for the Java changes - after FMS 18.2 Java is no longer included with the installer so check the installation notes thoroughly; ideally trial run on a spare machine.
  20. Quite right comment. For the OPs benefit I was showing how to write the code in a simplified form which is easier to read and therefore debug.
  21. Here is your case statement on a line-by-line basis Case ( IsEmpty ( DatePaid ) or DatePaid>Due Date ; AmountDue*.05 ; 0 ; Due_Date<Get (CurrentDate) ; AmountDue*.05 ; 0 ) All I have done is put in some returns to separate the individual cases Notice that case #2 starts with "0". This is not a comparative but will always be true and will yield either 0 or 1 based on Due_Date<Get(CurrentDate) Should your statement actually be... Case ( IsEmpty ( DatePaid ) or DatePaid>Due Date ; AmountDue*.05 ; Due_Date<Get (CurrentDate) ; AmountDue*.05 ; 0 )
  22. 49 files is obviously not a simple solution - determine if you really need to consolidate first. I've been running a 30 file solution for 20 years and have considered the consolidation route also. Originally I had nearly 40 files to deal with but I did consolidate some of them because they were merely "utility" files. I even created a new file to hold all the "contacts" from 5 other files simply from an interface perspective only (it makes sense in this instance). One of the benefits of a multi-file solution is that you can develop in different files at a time and deploy them individually. Possibly important if you have more than one developer! Some years ago I had a chat with a very experienced developer that retails a significant application; he said it nearly killed him and actually migrated a 30 file solution in 2 consolidations because he had to maintain a deliverable product. Break the problem down to smaller chunks that you might deliver as "modules" (like my contacts?) Factor in your migration path too - you need to get the data from your production system to the new version ultimately. The final product will likely be somewhat different to the end-user current experience so, once again, consider delivering in smaller units to take the pressure off yourself and ease the users into the new world.
  • Create New...

Important Information

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