Jump to content
Make Add-ons Better

E.J. Sexton

Members
 View Profile  See their activity

  • Posts

    12

  • Joined

  • Last visited

Profile Information

  • Gender
    Male
  • Location
    Ankara, Turkey

Contact Methods

  • Website URL
    http://www.ejsexton.com/
  • Skype
    ejsexton82

E.J. Sexton's Achievements

Rookie

Rookie (2/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges

0

Reputation

  1. E.J. Sexton
    Okay, I encountered this problem twice in the last two weeks. The first time, I did what no1tmorrow recommended, and it worked: Delete the FileMaker Server Admin Console Java Applet. Uninstall FileMaker Server, Java, and Bonjour. Delete the Program File folders for FileMaker Server, Java, and Bonjour. Disabled all of my Network Adapters. Reinstalled FileMaker Server. Enabled all of my Network Adapters. However, I was unable to do this when installing FileMaker Server remotely. I was also able to fix the problem by following the instructions for resetting the FileMaker Admin Console Password (Search FMKB: 6989): Delete the FileMaker Server Admin Console Java Applet. Navigate to the FileMaker Admin Conf directory: [drive]:Program FilesFileMakerFileMaker ServerAdminconf Delete the following 4 xml files: managerconfig.xml server_config.xml wpe_workerconfig.xml ws_workerconfig.xml Restart the FileMaker Admin Server from the command line: [drive]:Program FilesFileMakerFileMaker ServerDatabase Serverfmsadmin.exe restart adminserver This problem had been driving me crazy for days. I hope this helps someone else!
  2. E.J. Sexton
    It looks like the 360Works SelectFile() function is returning the network path of the file. With a bit of manipulation, you can use this value in FileMaker: Set Variable [$$SelectImportFile; Value:SelectFile] Show Custom Dialog ["Windows"; "filewin:" & Substitute($$SelectImportFile; "\\"; "/")] This should yield the following result: This value can then be used in various script steps like "Import Records []" and "Export Records []".
  3. E.J. Sexton
    You could host the website on a LAMP server, but the FM Web Publishing would have to remain on the Windows 2003 Server. The "$IPAddress" would then be the address of the Windows 2003 Server, not the LAMP server.
  4. E.J. Sexton
    This is the script that I came up with in my solution: ## # Load URL Script # Set Error Capture [ On ] Set Variable [ $webviewer; Value:"webviewer" ] Set Variable [ $url; Value:"http://www.fmforums.com/" ] Set Variable [ $lastTag; Value:"</html>" ] Set Variable [ $timeout; Value:30 ] ## # Load the URL # Set Web Viewer [ Object Name: $webviewer; URL: $url ] If [ Get(LastError) ] # Error: Either the webviewer is missing or did not load properly Exit Script [ Result: False ] End If ## # Wait for the URL to load # Loop Pause/Resume Script [ Duration (seconds): 1 ] If [ GetLayoutObjectAttribute ( $webviewer ; "content" ) <> "<HTML></HTML>" ] Exit Loop If [ PatternCount ( GetLayoutObjectAttribute ( $webviewer ; "content" ) ; $lastTag ) ] End If Set Variable [ $timer; Value:$timer + 1 ] If [ $timer = $timeout ] # Error: Url did not load in time Exit Script [ Result: False ] End If End Loop Note: The "<>" symbol should be a "Not Equals" symbol. I hope that helps!
  5. E.J. Sexton
    You could probably also pass the field values from the Quote record that you need as script parameters: Perform Script ["Check Availability"; Parameter: Quote::field1 & "¶" & Quote::field2 & "¶" & Quote::field3] And then retrieve those values in the "Check Availability" script: Set Variable [$field1; Value:GetValue(Get(ScriptParameter);1)] Set Variable [$field2; Value:GetValue(Get(ScriptParameter);2)] Set Variable [$field3; Value:GetValue(Get(ScriptParameter);3)]
  6. E.J. Sexton
    If the names are on the same line, try WordCount(): Let( filed="Male Female"; WordCount(filed) ) If the names are on different lines, try ValueCount(): Let( filed="Male¶Female"; ValueCount(filed) ) If the names are in different repetitions, try Count(): Count(Table::filed) Finally, if the names are in two places, try Not IsEmpty(): Let([ filed1="Male"; filed2="Female" ]; Not IsEmpty(filed1) + Not IsEmpty(filed2) )
  7. E.J. Sexton
    What about this: Let([ startdate=Get(CurrentDate); period=3.5 ]; Date (Month(startdate) + 12*period; Day(startdate); Year(startdate)) )
  8. E.J. Sexton
    Okay, here's the deal: My client is running a 2-machine deployment of FileMaker Server 9.3. Two weeks ago, their Domain Controller server died and needed to be replaced. We have a website set up using Custom Web Publishing. Shortly after the DC was replaced, CWP stopped working intermittently for hours at a time. Everything else works fine--Users are still able to access the database using FileMaker Pro. When CWP stops working, port 5003 stops accepting new connections on both the Worker and the Master machine. FileMaker reports this as an 802 "Unable to Open File" error. Restarting IIS clears this problem up. Sometimes, this problem goes away on its own. Recently, it seems like this problem will occur to some web users while other web users are able to use the website simultaneously without any problems, but we have not verified this. I have tried restarting both machines as well as redeploying the CWP, but neither has helped. Any thoughts or suggestions would be appreciated. Thank you for your time.
  9. E.J. Sexton
    You can create a global field which links to the company name field in your list. What you would do is type the first couple of letters of the company name and then display the matching results in a portal. When the user clicks on the company name, you could execute a script which would update the necessary field with the company name. However, you would have to tab out of the global field to update the company name portal. Currently, I don't think there is a way to dynamically update the portal every time you type a letter without the help of a plugin. FusionPlugins.com has a plugin called Reactor v2 which they demonstrated at DevCon which adds a lot of dynamic functionality to FileMaker. One of the demonstrated uses was to filter records as the user was typing using a variation on the method I described above--e.g. if you type 'T', then it would show all the records starting with the letter T without having to tab out of the search field. I have not used Reactor myself, but they made it look fairly simple. More information about Reactor v2 can be found here: http://www.fusionplugins.com/reactor/
  10. E.J. Sexton
    You were correct, we had a DNS problem. The worker machine could resolve the master machine using its IP address, but it could not resolve the master machine using its domain name. The IT personnel modified the DNS so that the worker machine would be able to reference the master machine by its domain name and the issue was resolved. I'm not overly familiar with how networks work, so I apologize if my description is lacking. Thank you for all your help.
  11. E.J. Sexton
    I have checked the maximum number of web sessions in the admin console and it was set to the default 100 sessions. I tried changing the number of sessions and restarting/redeploying, but it did not solve the problem. I have forwarded PBainbridge's post on to my client's IT guys to see what they make of it.
  12. E.J. Sexton
    I have a client who recently upgraded from a single-machine FMSA8 deployment to a dual-machine FMS9 deployment. We have spent nearly a month trying to get Custom Web Publishing up and running, but we keep receiving "Maximum number of web sessions exceeded (Error 956)" errors whenever we make a query. I have restarted both servers and redeployed the WPE numerous times, but this has not solved the issue. Many of the articles I have read on this subject state that this is a Firewall problem, but they never say what the problem is exactly. I have checked the ports on both machines as well as the firewall using the FileMaker Tech Info 6427 resource, but with no luck. My client's IT personel have even spent a couple hours in a conference call with FileMaker Tech Support, but it does not appear that they were able to come up with a solution. Has anyone any information on this issue? Anything at all will be appreciated. Thanks. E.J. Sexton
×
×
  • Create New...

Important Information

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

  I accept