Lem Alpha

  • Content count

  • Joined

  • Last visited

  • Days Won


Everything posted by Lem Alpha

  1. Do you have access to an older version of filemaker pro ? If you have access to a v13, you can access "manage security" without the first dialog.
  2. For the moment, your [fullaccess] account has no password, so you may access security by just entering your account name and leaving the password blank. Then you'll set a password, and when you validate the settings, it will prompt you with the same dialog again, which you will then fill with your brand new password.
  3. Maybe the "Require Password-Protected Databases" setting was not enabled before ? Anyway... You can "Download Database" from the same menu (in your first screenshot), then delete the db from server (trash icon on the top-right) Open the file locally with Filemaker Pro, set a password, then upload it again to FMS using "Share / Upload to server" in filemaker pro.
  4. It is the file we are talking about.
  5. That's the problem : your filemaker server is set to only open files where [fullaccess] accounts are password protected , but from what you say, none of the accounts has a password, so obviously the [fullaccess] doesn't have one. In order for your file to open, you'll have to set a password for [fullaccess] accounts. Which is more than highly recommended anyway. Other obvious security flaws that prevent a file to be opened : "auto log in with account :" set with a [fullaccess] account, or a Guest account with [fullaccess] privilege.
  6. "Open" is what you're looking for, which for some reason doesn't work for you, obviously. What does the log say ? ("Log Viewer" in the left pane)
  7. Yes, as our German friend's doppelganger just said : go have a look ! Even if it's only through the eyes of a kid at a magician's show ! It's worth it.
  8. This is also a good remark. In my case of making it easier for users to search for emails, it was never an issue because when someone puts in the @ it means they put in a complete address, so there shouldn't be any parasitic results. But of course, for such a scripted search, it would not be bulletproof then. Thanks for pointing out these caveats, both of you.
  9. True. But I have seldom seen emails encoded with upper case, so I think the benefits of users being able to search for emails using @ are greater. And just making this field an auto-entered calc Lower ( Self ) would prevent indexing upper case chars. I was specifically speaking of users manually searching for emails, of course.
  10. Really long shot here, but would you consider having an emoji instead of a "real" image ? You could then have a calculation field (= empty or emoji according to your condition) an append it to your merged text ?
  11. Or you could set indexing to "unicode" in the field definition (thanks to JFS for the reminder...) This is especially helpful when such an email field is accessible in search mode for users...
  12. All right, I didn't get this, and it did seem strange to me that such an experienced member would have that kind of questions... I think I did switch parameters a couple of times, and rewrote the calcs, but I've no memory of such problems. I definitely will try to reproduce this one of these days (unless you do come up with a demo in the meanwhile) So, again sorry for the useless answer.
  13. Hi there, I'm not really sure I understand what bothers you about this, so excuse me if I'm completely missing the spot : the order of parametes matters because it's the only way for the custom function to know which string is what. There is no such thing as "parameter name" when you call that function, as there can be f.i. in an URL e.g. google.com/#q=sometext&hl=fr imagine that the server didn't need parameter identification, and that URL was written that way : google.com/#sometext&fr if you switch the input parameters like this, google.com/#fr&sometext the server would try to search for the text "fr" and try to show only pages in "sometext" language... Because it's the order of the parameters that tells him that "fr" is the text to look for, and "sometext" the selected language of the results. And if you switch the expected parameters order on the server, so that the first string he sees will tell him the language and the second the search request, you would of course have to write any URL in that particular order. Same thing for FM custom functions (and internal I guess, though you can not alter these) : in the definition of your CF, let's say BinomDist, you tell FMP that the first string encountered is "successes", the second "trials", etc. If you switch them in the definition, but leave all the written calculations unchanged, FMP will understand that the first value you entered (and meant to be "successes" when you originally wrote it) is now the value you want for "trials", and so on. So you would obviously have to rewrite the calcs with the "trials" value first, ... Hope it helps.
  14. Hello there, I'm getting strange results using "distinct" in an agregate Count in the following query : SELECT s.Zkf_Formateur, li.Zkf_Groupe, COUNT(DISTINCT li.Zkf_Contact) FROM LISE__ AS li JOIN SEAN__ AS s ON li.Zkf_Seance=s.Zkp WHERE li.Zkf_Groupe='GROUCF63457729200OF90YL24' AND s.Zkf_Formateur='CONT63394136111XUYM50SA' GROUP BY s.Zkf_Formateur, li.Zkf_Groupe this returns, with a pipe separator and spaces added here for clarity : CONT63394136111XUYM50SA | GROUCF63457729200OF90YL24 | 11 This should return CONT63394136111XUYM50SA | GROUCF63457729200OF90YL24 | 12 as does the same request with just COUNT(li.Zkf_Contact). As a proof, here is the result of the query with no agregation. the li.Zkf_Contact column shows 12 distinct values : SELECT s.Zkf_Formateur, li.Zkf_Groupe, li.Zkf_Contact FROM LISE__ AS li JOIN SEAN__ AS s ON li.Zkf_Seance=s.Zkp WHERE li.Zkf_Groupe='GROUCF63457729200OF90YL24' AND s.Zkf_Formateur='CONT63394136111XUYM50SA' CONT63394136111XUYM50SA | GROUCF63457729200OF90YL24 | CONT63457835431ZLV16T9Z CONT63394136111XUYM50SA | GROUCF63457729200OF90YL24 | CONT634578354311S9V0QB9 CONT63394136111XUYM50SA | GROUCF63457729200OF90YL24 | CONT63457835430VD51X3E1 CONT63394136111XUYM50SA | GROUCF63457729200OF90YL24 | CONT63457835430RR1B7S51 CONT63394136111XUYM50SA | GROUCF63457729200OF90YL24 | CONT63457835430FTDSF16C CONT63394136111XUYM50SA | GROUCF63457729200OF90YL24 | CONT63457835430OO09T4P9 CONT63394136111XUYM50SA | GROUCF63457729200OF90YL24 | CONT634578354301M3GKDA1 CONT63394136111XUYM50SA | GROUCF63457729200OF90YL24 | CONT63457835430383HDB8F CONT63394136111XUYM50SA | GROUCF63457729200OF90YL24 | CONT63457835430XJJQ60DZ CONT63394136111XUYM50SA | GROUCF63457729200OF90YL24 | CONT634528279168RIKDYJS CONT63394136111XUYM50SA | GROUCF63457729200OF90YL24 | CONT63452479959YV4FIMH8 CONT63394136111XUYM50SA | GROUCF63457729200OF90YL24 | CONT634524799598J803ZA2 Now, I may not be (and am not !) an SQL expert, but there's something here I really can't figure out... Anyone having an idea ? Thanks a lot
  15. Just a little follow-up, for those interested : still the same problem in 12v3 and native ExecuteSQL. Updated issue report can be found here : http://forums.filemaker.com/posts/4d4bb0da3e
  16. Hi there, in a scheduled server-side script, I'm trying to launch another script by specifying its name. I tried to achieve this by using the CallScriptImmediately function. The problem is the function returns "ERROR", and in the log I can see : GRAVE: PluginFunction PluginFunction{name='CallScriptImmediately'} got an error with converted args [my_file_name, Mail Test 02, null] com.prosc.fmkit.FmScriptException: Error 100: There is no file open named 'my_file_name' my_file_name is correct, it has been set using Get (FileName). Am I doing something wrong ? Win7 / FMS11 / SM 4.122 (I know it's not the last version, but I can't stop the DB server to update it till tonight) Thanks a lot !
  17. Yup, but my problem was to launch a script by calculated name... (sorry if this wasn't clear) So I'll try some other way, thanks for your answer. ;)
  18. Hi there, the other IPs are the ones created by VMWare for the virtual adapters. Anyway, there could be other reasons to see more than one value. I have a similar test running in my solutions : I suggest you create a field in some parameter table, e.g. "RouterIP". That field could be set once and for all when the DB admin "installs" the file. (that is, opens it for the first time on that machine) Then you should be able to easily retrieve the correct value by somehow filtering the IP list, comparing values against the first 3 groups of figures of the router's IP (including the 3rd dot) : 192.168.1. The only difference is that I'm hosting the DB vith FMS, so I'm not running the test against a "user defined RouterIP field", but against the HostIP returned by FileMaker (which would probably not be helpful for you).
  19. Hi there, the foreign key CANNOT be an auto enter serial number, by design. First of all, without any Filemaker technical considerations, and just out of pure logic : this foreign key is part of the link between the two tables, but in order to be "automatically entered", the link would somehow have to be already set, just to know which record of the other table it should be linked to... As we say in french : "that's the snake eating his own tail..." So you'll have to set this foreign key either manually or by script.
  20. Hi there, I was wondering if there's something out there, usable with SM, that could allow me to read / write tags from / to an mp3 file. (attention : if there is, my next question will be : how do I get it to work in SM, since I'm a complete newbie at java/groovy and writing custom modules ! But ready to learn... ) It must be able to manipulate any mp3 tag, especially non-standard, extra user defined tag input fields. Thanks for your hints.
  21. Hi John, sorry, did not answer earlier... Thanks a lot, I'll have a look at these links.
  22. Hi there, when using an aggregate function (such as COUNT, SUM...), you MUST put all the other columns (ie that are not aggregated) in the GROUP BY. Therefore, try : ExecuteSQL( "SELECT Text, GroupNum, Count (GroupNum) FROM Test GROUP BY Text, GroupNum" ;"";"" )
  23. Hi there, I'm trying to run a command with RunShellScript, to use PsExec on windows (win 7 pro x64 / FMP11adv / SM 4.132). (this exe allows to run a command or batch on a remote computer, allowing me to control my FileMaker Server over command line) the exe is in C:\Window\system32, and from within a system cmd window, everything is working fine. But using ScriptMaster RunShellScript (from the example file), it returns a shell error : java.lang.RuntimeException: 'psexec' is not recognized as an internal or external command, operable program or batch file. I tried some native commads, such as ipconfig, netstat, copy, systeminfo, ... : everything is working fine with SM. I also tried different syntaxes : psexec , psexec.exe , C:\Windows\system32\psexec.exe etc. but to no avail. These are my first attempts with this RunShellScript module... Am I doing something wrong ? Thanks !
  24. Actually, I didn't even try, because this is just some testing I'm running. But the return result could be helpful indeed. So, I tried with Send Event, and I got the same results. I double-checked everything, the presence of the exe in the system32 folder (even if this was obvious, since everything works fine in a regular command shell), the windows variables (%PATH%), and all. Then something came into my mind : I copied the exe in the C:WindowssysWOW64 folder (the 64bit equivalent of system32) and tried again with send event : it worked. So it seems that on a x64 Windows system, Send Event and also the RunShellScript are calling the 64bit version of the exe, even if one specifies its full (32 bit) path ! The 'duplication to the 64 folder' workaround does the trick for SM too. This is quite puzzling, and I'd be curious to find any explanation... Thanks anyway for your suggestion, because it helped me find this out.
  25. Hi there, it may seem quite odd, but even over 2 years later, someone does find this helpful ! getValueList was still working well for me (I have no ampersand) on a FMS v11 deployement. (the php code was there since FMS v9) But I'm currently testing our whole FileMaker application on v12, and now there's the problem of broken value lists when containing characters with accents. After some research, I found this post and tried the solution. It worked. So thanks for sharing the info !