Jump to content

Jim Gill

  • Content Count

  • Joined

  • Last visited

  • Days Won


Jim Gill last won the day on January 4 2018

Jim Gill had the most liked content!

Community Reputation

3 Neutral

About Jim Gill

  • Rank

Profile Information

  • Title
  • Industry
    Making the World a better place.
  • Gender
  • Location
    Harrison, Maine

Contact Methods

  • Website URL

FileMaker Experience

  • Skill Level
  • FM Application

Platform Environment

  • OS Platform
  • OS Version
    Windows Server 2016, Win 10

FileMaker Partner

  • Certification
    Not Certified
  • Membership
    FileMaker TechNet

Recent Profile Visitors

3,410 profile views
  1. Thank you so much Comment - this was the correct answer! ******* carriage returns - they get me every time! Thank you again!!
  2. This is probably one of those questions which separates me from people that make money as developers and those that don't (that would be me). I have a simple script that compares two variables. The variables are populated with text (Peoples Names). Basically, if the the two variables are TRUE (the variables are equal) I want to stop the script. Despite the two variables being equal - the IF continues. I have noted when I use the same numbers to populate the variables - the script works as expected. Please tell me Filemaker is smart enough to evaluate text in variables. Below is the my
  3. Hello All - I have a wildcard cert from Godaddy for my domain. I have successfully reinstalled this cert on Server 17 by using the White Paper from Steven & Wim - thank you! My issue is this: I would like to use the certs/key on other machines/platforms but adding the keyfilepass is causing issues with my linux firewall -> PFSense. I have tried omitting the keyfilepass option however the CLI tells me this is a problem. Is there a way to generate the CSR without using the keyfilepass option? This would give me more options on the other machines. Thank you! Jim
  4. Thanks Fitch - yeah it is a tough one. The only thing I have really come up with is running the same scheduling script multiple times and comparing the mean Rank (temperature) and selecting the higher value. The order campers are scheduled is randomized each time (to be fair). This would be random optimization of the schedule instead of optimizing the existing schedule. There are coders for hire out there that specialize in Simulated Annealing but I have yet to find one that can help me with a FMP script. I will get this eventually (or someone I hire will) - watch this space. J
  5. Hello Left Brainers - I have a solution that schedules 230 campers (we are a summer camp) into six activity periods each day. There are several conditions that must occur for a class to be scheduled. For example: The class must be open, the camper must be in the appropriate grade, the class must have space - and there are others as well. When all the classes are scheduled there are always kids that have blanks where the scripting could not put a class in their schedule for various reasons. We are able to fill the blanks by manually looking at ALL the kids schedules and movi
  6. To save the next person the hours of research... And the correct answer is = https://<YOURDOMAIN.com>/fmi/webd?db=<FILE_NAME>&loginerr=0&guesten=0 or more simply = https://<YOURDOMAIN.com/fmi/webd/<FILE_NAME>
  7. I just moved my solution from Server 15 to 16.03 and everything went smoothly except on small issue. My solution has a WebDirect file that users login from the web. The URL on my site is supposed to take the directly to the login screen but since the upgrade drops them directry on the WebDirect Home Screen. Am I missing something? Did something change in Server 16? This worked flawlessly in 15 Here is the link: https://fcserver.fernwoodcove.com/fmi/webd#FC_Databases Thank you in advance! Jim
  8. Are your Users logging in with the same credentials from each location? Are there multiple files being opened when logging on? How are your Users being Authenticated? This sounds like a Permissions or Dependency issue. Can you post the OnStartUp script?
  9. Thanks Fitch - that was exactly what I needed! Sometimes I over complicate when simple is much better. Here is what I ended up with: Substitute( List( If ( flag_P1_Mailings=1; Email_Parent1); If ( flag_P2_Mailings=1;Email_Parent2 ); If ( flag_P3_Mailings=1;Email_Parent3 ); If ( not IsEmpty ( __ParentData_SuperParent::SuperParent_Email);__ParentData_SuperParent::SuperParent_Email)) ; ¶ ; "; " ) Are you talking about a self-join TO or a new Table? I see the logic however my solution has many references/dependencies to _ParentDat
  10. Hello, I'm have an issue sending emails via SMTP Server using a calculation field in the "To:" field. When I use the calc my outgoing emails are filtered as spam by the hosting service. If I put the Email Field in the SMTP To: emails are sent successfully. Here is the setup: I have a Parent Table with the fields Email_Parent1, Email_Parent2, Email_Parent3 and a related SuperParent_Email. Parents can opt-out/in of mailings by selecting flag_P{1-3}_Mailings. I'm trying to to get the field Email_List output to look like this: Email_Parent1@mydomain.com; Email
  11. Still haven't received my email from FM - am I being impatient?
  12. Update: Problem Solved! I may have misunderstood Wim - I was deleting the *.pem files from the Admin Console. I went directly into the C:\....\Filemaker_Server\ directory and did a search for *.pem. I then deleted all the files with a modification/creation date of yesterday or today(I actually cut/pasted them into a folder onto the desktop - just in case) . I then went back to the Admin Console and clicked the Create Request button and was blessed with the dialog box in Wim's screenshot. Thanks again Wim - you led me to the solution. Best, Jim
  13. Thanks Wim - I have tried your suggestion (previously) as well as uninstalled and reinstalled FMS 15 and tried generating the CSR (which does happen - just without any dialog/input from me). At no time am I prompted with the dialog in your screenshot. Have you heard of anyone else having this issue on a windows machine? Could this possibly be a bug (surely someone else would have had this issue previously). Again I really appreciate your help. Thank you! Jim
  14. Hey Wim - thanks for the reply. I understand exactly what you're saying here but I don't get the dialog you provided in your screenshot. I only get the option to Download or Start Over and not given the option to provided the correct info. Where are you getting the dialog box in your screenshot? Thanks again! Jim
  15. I just installed FMS 15 on a Windows 2008 R2 machine - everything checked out and the install went smooth. I then purchased a Wildcard SSL certificate from Go Daddy. I generated a CSR from the FMS Admin Console and pasted the encrypted text into Go Daddy's text box to setup my SSL. Here is the problem: The CSR generated from the FMS Console set the domain as mydomain.com instead of fmpserver.mydomain.com Where does Filemaker Server Console get the information used to generate the CSR? How do I get FMS to generate a CSR with the correct sub-domain? It is a FQDN (sub) th
  • Create New...

Important Information

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