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,316 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 script and attached is a screenshot of my debugging efforts. As always - thank you to the people here which share your wisdom - a big reason I love Filemaker so much. Jim IWP: IWP: Bunk Choice Select #This script allows WebD users to select bunkmates for the coming summer. #List All Chosen Names Set Variable [ $BR_List; Value:List ( BRE__BUNKSREQUEST_tog::Bunk Request Choice 1;BRE__BUNKSREQUEST_tog::Bunk Request Choice 2;BRE__BUNKSREQUEST_tog::Bunk Request Choice 3;BRE__BUNKSREQUEST_tog::Bunk Request Choice 4 ) ] Set Variable [ $BunkRequest; Value:Agegroup_Names_List::Name_Full ] Set Variable [ $BR_Check; Value:FilterValues ( $BR_List ; $BunkRequest ) ] #IF check to see if the names has already been selected If [ $BunkRequest = $BR_Check ] Show Custom Dialog [ Title: "No Duplicates"; Message: "You have already chosen this person. Please give us FOUR differnt names! Thanks!"; Default Button: “OK”, Commit: “Yes” ] Exit Script [ ] End If If [ BRE__BUNKSREQUEST_tog::Bunk Request Choice 1 = "" ] Set Field [ BRE__BUNKSREQUEST_tog::Bunk Request Choice 1; $BunkRequest ] Else If [ BRE__BUNKSREQUEST_tog::Bunk Request Choice 2 = "" ] Set Field [ BRE__BUNKSREQUEST_tog::Bunk Request Choice 2; $BunkRequest ] Else If [ BRE__BUNKSREQUEST_tog::Bunk Request Choice 3 = "" ] Set Field [ BRE__BUNKSREQUEST_tog::Bunk Request Choice 3; $BunkRequest ] Else If [ BRE__BUNKSREQUEST_tog::Bunk Request Choice 4 = "" ] Set Field [ BRE__BUNKSREQUEST_tog::Bunk Request Choice 4; $BunkRequest ] End If Commit Records/Requests [ Skip data entry validation; No dialog ]
  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. Jim
  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 moving things around to allow everyone to have a full schedule. Example: Sylvie wants Ballet in Period 1 however their is no space; there is space in Period 4 however Sylvie is already scheduled into Play Rehearsal. Jane is scheduled in Ballet Period 1 and has Tennis in Period 4 - Tennis is offered all day in every Period. So we switch Jane's schedule so she has Tennis in Period 1 and now has Ballet in Period 4. This opens a space for Sylvie in Period 1 so she can be scheduled into Ballet. There is an algorithm that does this as well called Simulated Annealing. http://katrinaeg.com/simulated-annealing.html I have a Schedule Rank (temperature) for each kid based on what they chose and what they received (see upper right of screenshot). As humans, we are smart enough (for now) to see the solution and reason things out. A script that can do it? Each time I sit down to attempt this through scripting - I just don't know where to begin. Has anyone else attempted a Simulated Annealing or anything similar. Any help is appreciated!! Best, Jim Gill
  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 _ParentData::P{1-3}email and to move the email addresses to a new Table::field would be a huge job. Am I not understanding? Either way - thank you! You made my job a lot easier. Jim
  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_Parent2@mydomain.com; Email_Parent3@mydomain.com; SuperParent_Email@mydomain.com alternatively if a record is missing an email: Email_Parent1@mydomain.com; Email_Parent2@mydomain.com What I'm getting is this: P1Email@gmail.com; P2Email@hotmail.com; Note the semicolon at the end Here is what I have for a calculation for the field Email_List List ( Case ( flag_P1_Mailings=1; If ( IsValid (Email_Parent1);Email_Parent1 & If ( IsValid (Email_Parent2);"; ";""))); Case ( flag_P2_Mailings=1; If ( IsValid (Email_Parent2);Email_Parent2 & If ( IsValid (Email_Parent3);"; ";""))); Case ( flag_P3_Mailings=1; If ( IsValid (Email_Parent3);Email_Parent3 & If ( IsValid (__ParentData_SuperParent::SuperParent_Email);"; ";""))); Case ( IsValid (__ParentData_SuperParent::SuperParent_Email);__ParentData_SuperParent::SuperParent_Email;"") ) Can someone help me clean this up please? Thanks so much! Jim
  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) that resolves directly to the Public IP on my server. Thanks in advance for your help! Jim.
  • Create New...

Important Information

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