Jump to content

Jim Gill

  • Content Count

  • Joined

  • Last visited

  • Days Won


Jim Gill last won the day on January 4

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
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version
    Server 2016, Win 10

Recent Profile Visitors

2,747 profile views
  1. Jim Gill

    Simulated Annealing

    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
  2. Jim Gill

    Simulated Annealing

    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
  3. Jim Gill

    Webd URL Syntax for login screen

    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>
  4. 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
  5. 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?
  6. Jim Gill

    Email List Calculation

    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
  7. Jim Gill

    Email List Calculation

    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
  8. Jim Gill

    License Web letter

    Still haven't received my email from FM - am I being impatient?
  9. Jim Gill

    SSL CSR & Correct Sub-domain

    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
  10. Jim Gill

    SSL CSR & Correct Sub-domain

    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
  11. Jim Gill

    SSL CSR & Correct Sub-domain

    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
  12. 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.
  13. Jim Gill


    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
  14. Jim Gill

    HTTPS website interaction

    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
  15. Jim Gill


    Hello Mike - From the SipXcom Wiki http://wiki.sipxcom.org/display/sipXcom/Call+Control+Web+Service: Services If you are issuing the curl command from a trusted host ( i.e. one where sipx proxy is running) please use only HTTPS (no authentication is required). From a non-trusted host you must authenticate the curl command with Digest authentication. There are some examples with notes in the source directory. Download the source code from svn and take a look at the scripts in sipXcallController/test 6666 is the HTTPS port. 6667 is the HTTP port. You can use either HTTPS or HTTP when issuing the curl command from a non-trusted host. Since version 4.6 you should use the redirector in sipxconfig as using port 6666 seems deprecated. The REST interface can be reached (using digest authentication) on http(s)://<host>/sipxconfig/rest/my/redirect/callcontroller etc. Also I have now managed to get httppost to work but NOT how the wiki at Sipxcom direct the URL to be written. I'm starting to think it may be more of a Sipxcom issue than FMP. Here is the syntax that works for my Click to Call script: "httppost://mydomain.com:6667/callcontroller/"&click_to_call|Selfjoin::User_Ext&"/"&$$DialedNumber&"?"&click_to_call|Selfjoin::User_Password Thanks for any advice or leads you can give me. Also the progression of my post at Sipxcom forum can be found here: https://groups.google.com/forum/#!searchin/sipxcom-users/click$20to$20call/sipxcom-users/hPB6b2LnnIk/2dDQ4UqUIDkJ Jim

Important Information

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