Jump to content

Jim Gill

Members
  • Content Count

    64
  • Joined

  • Last visited

  • Days Won

    2

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
    Intermediate

Profile Information

  • Title
    Owner/Director
  • Industry
    Making the World a better place.
  • Gender
    Male
  • Location
    Harrison, Maine

Contact Methods

  • Website URL
    http://www.fernwoodcove.com

FileMaker Experience

  • Skill Level
    Intermediate
  • FM Application
    17

Platform Environment

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

FileMaker Partner

  • Certification
    Not Certified
  • Membership
    FileMaker TechNet

Recent Profile Visitors

2,838 profile views
  1. 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
  2. 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
  3. 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
  4. 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>
  5. 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
  6. 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?
  7. 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
  8. 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
  9. Still haven't received my email from FM - am I being impatient?
  10. 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
  11. 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
  12. 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
  13. 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.
  14. Update: Mike your question was the key to the correct answer: I was able to get Insert from URL function to work using httpspost. - No plugin! Here is what is looks like: Insert from URL [No dialog; "httpspost://"&click_to_call|Selfjoin::User_Ext&":"&click_to_call|Selfjoin::User_Password&"@sipx.mydomain.com/sipxconfig/rest/my/redirect/callcontroller/"&click_to_call|Selfjoin::User_Ext&"/"&$$DialedNumber&"?"&click_to_call|Selfjoin::User_Ext&":"&click_to_call|Selfjoin::User_Password] Note that once I included the auth (click_to_call|Selfjoin::User_Ext&":"&click_to_call|Selfjoin::User_Password&"@) this made everything work - both from client and server. Thank you! Jim
  15. You can POST data by the "Insert from URL" script step: http://help.filemaker.com/app/answers/detail/a_id/11626/kw/About%20importing%20data%20using%20an%20HTTP%20request
×
×
  • Create New...

Important Information

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