• Content count

  • Joined

  • Last visited

  • Days Won


dansmith65 last won the day on September 12 2016

dansmith65 had the most liked content!

Community Reputation

81 Excellent

About dansmith65

  • Rank
  • Birthday

Profile Information

  • Gender
  • Location
    B.C. Canada

FIleMaker Profile

  • FM Application
  • Platform
    Windows XP
  • Skill Level
    Authorized Trainer
  • Certification
  • Membership

Recent Profile Visitors

10,842 profile views
  1. Sorry, I had it backwards this whole time! Now I get why it seemed so strange; it seems strange to me too now. But then again, if you do a regular old find in that number field with the text ASDF3GHJK4QWERTY5, it will match a record with number 345. If you didn't want the text to cause a match in a regular find, you'd have to surround the value in quotes "ASDF3GHJK4QWERTY5", to make it match a phrase.
  2. I think the reason it seems so strange is because number fields weren't meant to hold text and when you put text in them, they won't work like a text field. If you convert that field into a text field, your searches would work as you would expect them to.
  3. Yes, I believe so. Since that field is defined as a number, it's index will only contain numbers. So the index for that value would contain: 301, which explains the match.
  4. @Lee Smith I'm not sure; I'd like to know if it did, though. For the record, here's what I was referring to with the recovery option...
  5. The advanced recovery options allow you to rebuild all field indexes, which is what you did on one field when you followed Lee's directions. You could test that. If that doesn't work; it's going to be tedious finding out which exact field is causing the problem. There isn't any easy way to resolve it; you'll have to just be methodical and work your way through it. Not sure which field it's matching against? disable quickfind one field at a time until it stops matching.
  6. Probably not; I hadn't thought of that. I usually don't run scheduled scripts as Administrator, so that hasn't come up. In that case, I would use a script to create the scheduled task. Here's an example: (the options would need to be changed to get it to run as Administrator) # https://technet.microsoft.com/en-us/library/jj649816(v=wps.630).aspx $Action = New-ScheduledTaskAction ` -Execute powershell.exe ` -Argument "-ExecutionPolicy Bypass -File C:\GetSSL.ps1" $Trigger = New-ScheduledTaskTrigger ` -DaysInterval 85 ` -At 1:00am $Settings = New-ScheduledTaskSettingsSet ` -AllowStartIfOnBatteries ` -DontStopIfGoingOnBatteries ` -ExecutionTimeLimit 00:05 ` -StartWhenAvailable $Principal = New-ScheduledTaskPrincipal ` -UserId $([System.Security.Principal.WindowsIdentity]::GetCurrent().Name) ` -LogonType S4U $Task = New-ScheduledTask -Action $Action -Trigger $Trigger -Settings $Settings -Principal $Principal ` -Description "TODO:explain what the task is for" Register-ScheduledTask -TaskName "TODO:task-name" -TaskPath "TODO:optional-folder-name" -InputObject $Task -Force
  7. Great job @Smef! I've been wanting to use Let's Encrypt, but didn't think it was compatible with FileMaker. When I schedule tasks on a FileMaker Server, I prefer to schedule them from within FileMaker Server itself. Since FMS can't run powershell scripts directly, I send this bash script the name of a powershell script to run and any parameters to send to the powershell script, if needed: :: file name: run_powershell_script.cmd :: Created by: Daniel Smith http://scr.im/fmconsulting :: change current directory to script location @PUSHD %~dp0 :: this is the old method that I disabled because of a bug in powershell.exe :: powershell.exe -file %* :: calling powershell.exe with -file option causes exceptions to NOT return an error code to this script :: I implemented a work-around linked to from here: http://stackoverflow.com/a/15779295 :: I am replacing " with ' because, when using the -command option, " does not group data into a single value :: FMS reads an errorlevel of 1 as "aborted by user" and only set's the log level to information, :: I am trapping for uncaught errors and returning 100 so the log level is set as error in FMS :: Since the actual error returned by the powershell script is lost, I'm sending it to a file. SET params=%* SET params=%params:"='% PowerShell.exe -ExecutionPolicy unrestricted -command "& {trap{Out-File -FilePath "..\Documents\run_powershell_script_errors.log" -Append -InputObject $_ ; exit 100} .\%params%}" @POPD EXIT /B %ERRORLEVEL%
  8. Have you reviewed the layout to see which fields have QuickFind enabled? Is the serial number field defined as a number, or text field?
  9. No You could have the second popover somewhere else and have a button on the first popover open the second popover by object name. If you did this, the first popover would close and the second one would open.
  10. You might want to check out https://www.geistinteractive.com/products/filemaker-drawing-tool-godraw/
  11. @bcooney I'm still not using EasySync in any client application's so I wouldn't have noticed this yet myself, but it does seem to be a limitation of the method used for syncing. I would suggest opening/closing a record instead of setting a field to control this. The problem with setting a field is when a client looses connection in the middle of a sync, or some other error occurs; that flag will remain set to "sync in progress". If you create a record (or table with one record) and open/close it when starting/completing syncing, then that lock will be more likely to clear on it's own. In the case of a client disconnect, for example, that record will be closed when the client disconnects (although I suppose it takes a bit for the connection to time out on the server). The only other possibility I can think of is to store the time the sync start, and the time it finishes, then add one more process at the end of a sync to see if any records were changed between those two times. Then you could run another sync to get the missing parent records. Note, you may need to resolve the following issue before this method works as expected: https://github.com/dansmith65/FileMaker-EasySync/issues/24
  12. Check the external file reference in your local file. There should only be one location listed and it should point to your hosted file. That's the most likely issue, if that's not causing it then I'm not sure what is.
  13. Thanks! I hadn't noticed that yet. I created an issue for it on GitHub.
  14. I stored segments the same way they were returned by the server, but I combined them, as necessary, in the "Loop over the records" section. So, I loop through all the segments if necessary, until "<record>" is found, adding the result to the $record variable... At least that's what I was trying to do, and I think it's working.
  15. I think this is the key issue, and I don't think any amount of ingenuity on the developers part can have the imact I'd like to see in this area. I think this is up to FileMaker to implement a method of merging changes, like can already be done with text files and Git. That's been done from the start of the repo! Check out the fmp_text folder. I created a DDR and processed it by fmpvc on most commits. That allows you to compare any two commits on GitHub and see what was changed. Here is an example showing my last commit to the dev branch: https://github.com/dansmith65/FileMaker-EasySync/compare/dev%5E1...dev If you wanted to contribute code to the repo, I'd consider that, but we would have to co-ordinate our efforts. Basically, I would have to stop making changes on the files, while you are making changes, then I'd have to pull your stuff into the repo before I can start work on it again. Like I said, I'm open to that option if you want, just send me an email/pm and we'll discuss it. I haven't been working on EasySync lately, anyways.