Jump to content

Donald Clark

  • Content count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Donald Clark

  • Rank

Profile Information

  • Gender
  • Location

Recent Profile Visitors

2,179 profile views
  1. WebDirect display problems

    Thanks for your feedback. It's a single file solution, so no related file and now authentication needed. Also, it works fine in Client, just not in WebDirect. Solved! It seems we did not try enough alternate themes to the Cool Gray theme. The Vibrant theme fixed all the major problems, but still has some minor issues, such as Italic text on WD not present in FileMaker, and the need for a black background with white text for one of the portals. Other than that, functionality is 100%!
  2. WebDirect display problems

    Thanks for your feedback. It's a single file solution, so no related file and now authentication needed. Also, it works fine in Client, just not in WebDirect.
  3. WebDirect display problems

    I have a FileMaker server 13.v10 database solution that changed somehow during development and now does not display several WebDirect objects properly. For starters, the text shows up as white on a white background, which it did not do before. We have been and are using the Cool Grey theme. Other problems with display: 1. 3 value lists will not display: One a regular list from a set of values, another list from a related layout, and a third a filtered list from another layout. Another value list works normally 2. A picture in a container field (locally stored, not external yet) does not show. 3. A filtered, sorted portal does not show the records, nor are they accessible in the portal. The filtering and sorting are straightforward. We have tried several things to correct the issue: 1. Made a new layout, grouped everything together and paste it on the new layout. 2. Made a new layout and made the fields and portal from scratch. 3. Simplified and changed the relationships to the portal 4. Substituted simplified relationships for the value lists (just for testing. 5. Tried the db on FM Server 16 and made most of the changes above, nothing was different. 6. Used Dropdowns, Popups, and radio buttons, no change in behavior 7. We had FMDiff examine the db for corruption, but they found no problems, so file corruption is not an issue. We also compacted the db in order to reindex all indexed fields, but that did not help. Everything works fine using FM client. Only WebDirect has problems. A photo showing the problems on WebDirect is attached, as is a photo showing the fields properly displayed in FileMaker Client. Please forgive the look and feel; the photos show the layout as we made changes and are troubleshooting. Has anyone seen this before? Do you have any ideas how to fix it? Thanks for your help.
  4. System Script Aborted by User

    Hi Jesse- I am trying to make this work, too, but can't get the scripts to stop aborting. I pasted this into the etc/sudoers file using sudo visudo: Host_Alias FMSHOST = yourhostname Defaults:fmserver targetpw, timestamp_timeout=0, passwd_tries=1 fmserver FMSHOST = (ALL) /Library/FileMaker\ Server/Data/Scripts/*, /bin/kill and changed the hostname to the name returned by running the hostname command. At what point in the sudoers file did you put this command? I have tried it on the end and after the Alias HostName line. Also, did you put your password where it says "taargetpw" or did you leave that there? I have tried changing permissions on all of files I am accessing from the applescript I am running. I have tried using different passwords and usernames. I have tried fmserver user name and password explicitly. All for naught. The script keeps saying user aborted. Do you have any other ideas, perhaps? Thanks- Don
  5. Hi Jesse, I just installed on Mac Mini running 10.9.5 and FM server 14 and got this error: "Installation worked but Web Server forwarding is not working. You will need to access MirrorSync at the direct connect URL:". Do you have any ideas about how to fix it? Thanks, Don Clark
  6. I have two (sometimes more) clients using IWP on a dedicated, shared FM 12 Advanced server running on Win 2008. I rewrote the imp_home.html, imp_auth.html, and the imp_home.css pages, and added websites to IIS, so that each client had a custom index.html home page with their logos and a link to their database. When they logged out, they were returned to their custom home page. This worked flawlessly in FileMaker 11. I cannot seem to make it work in FileMaker 12 except for the default domain, possibly due to some security changes in FM 12 - at least I have found similar code online that broke with FM 12. The client home page link (http://website/fmi/iwp/cgi?-db=dbName&-startsession, for example) returns a 404 Page not found. FileMaker only responds to the default website address or the raw ip. The problem with that is the modified imp_home.html page redirects the user back to the website address in the original link, so the only place they can go on logout is to the default website index.html page on the server, not to their custom home page. Does anyone know what could cause this change or if there is a work-around? Thanks- Don
  7. Enter Find Mode, type Hello in the text field. Make a new find request and type Hi There. Perform the find and all parent records with both of those criteria will show. And, yes, you can script it. Don't feel bad-sometimes we can't see the forest for the trees. Happens to everyone.
  8. Excluding certain records from Value List?

    Check out the Magic Value List example at FileMakerhacks.com. Using ExecuteSQL, you can easily make a dropdown list without a relationship and call exactly what you want. For example (insert your field names below): MVL_Dropdown ( ExecuteSQL ( "SELECT ChartName FROM All Charts WHERE NOT Status = ?" ; "" ; "";"Retired") ) The example file does not give a great explanation, but with a bit of work, you can set it up for any file. Essentially, you use a combination of custom functions, SQL, a couple of scripts, script triggers, and a global field to generate drop down lists, checkboxes, and radio buttons, as well as conditional lists based upon input from other fields. Take the time to learn this technique and you won't regret it.
  9. FYI - no help needed. This post is just to help out others. I had a situation where I was running FM 12 Advanced with RemoteScripter on a Windows 2008 Server. RemoteScripter requires a "robot" file running on FileMaker Pro Client (not server) that can handle the run script requests from IWP clients or web pages via URL. Running the client on the server was the only viable solution for my client. The problem was, what happens if the server restarts unexpectedly or if you have it restarting routinely after installing patches? The FileMaker client "robot" needs to be running for RemoteScripter to function, so I needed to find a way to start the client and the database automatically. Here's how to do it. First, make a windows shortcut file to open your database from the desktop (see here for more info). Here's an example: fmp://AcountName:Password@IPAddress/MyDatabase.fmp12 Copy that line into a web browser and click on the little icon to left of the address and drag it to the desktop (again, see here for more info). Double click the icon to make sure it opens the file. Next, move that shortcut to the following folder: C:\Users\username\AppData\Roaming\Microsoft\Windows\Start Menu\Programs\Startup Now when you login into your server, your database will start. Finally, set up your windows server to auto login on startup - click here to learn how to do that. It's not hard. That's it - when your server restarts, windows will login and your database starts automatically. One note of warning - if anyone has access to your physical machine, they will be logged on automatically on startup or restart. My machine was in the cloud, so that was not a problem. I also tried to remote desktop into it with just the ip number, but needed the user name and password to do that successfully. Consider the security implications before implementing this solution. Enjoy! Don Clark FM Database Consulting
  10. Avoid iwp homepage on entry and exit

    See this thread: http://fmforums.com/forum/topic/85096-custom-login-page-for-database-homepage-default/page__hl__windows%20auto%20start%20file%20server#entry395809 It may be what you are looking for... Don Clark
  11. Custom login page for 'Database HomePage' default?

    Use dsghs's info to get to the imp_auth.html and imp_home.html files. Make a new imp_home.html file with this content: <script type="text/javascript"> document.write(location.protocol); if(location.protocol == "http:"){ window.location = "http://" + window.location.hostname; } else { window.location = "https://" + window.location.hostname; } </script> Make a new iwp_auth.html and change the reference css file (located just above the </head> tag: <link href="/fmi/iwp/res/iwp_home1.css" rel="stylesheet" type="text/css"> Make a file named imp_home1.css and copy this into it: /* copyright: © Copyright 2003-2010 FileMaker, Inc. All Rights Reserved */ .databasehomepage { color: #CCCCCC; font-style: normal; font-size: 16px; font-family: Arial, Helvetica, Geneva, Swiss, SunSans-Regular } .bannerWhite { color: #CCCCCC; font-size: 28px; font-family: Arial, Helvetica, Geneva, Swiss, SunSans-Regular; letter-spacing: -.5px } .links { color: #3333CC; font-size: 16px; font-family: "Times New Roman", Arial, Helvetica, Geneva, Swiss, SunSans-Regular } #relativeBannerBox { position: relative; left:0; top:0; width: 100%; height: 60px; visibility: hidden; display: block; overflow:hidden;} #bannerBox { background-color: #FFFFFF; position: absolute; left:0; top:0; width: 100%; height: 30px; visibility: visible; display: block; overflow:hidden;} #fmBox { text-align: right; position: relative; top: 20px; left: 0px; width: 100%; height: 35px; visibility: hidden; display: block } #homeBox { text-align: right; vertical-align: bottom; position: absolute; top: 40px; left: 0px; width: 100%; height: 25px; visibility: hidden; display: block } #iwpBottomBox { position: absolute; top: 17px; left: 17px; width: 550px; height: 40px; visibility: visible; display: block } #iwpTopBox { position: absolute; top: 15px; left: 80px; width: 550px; height: 40px; visibility: hidden; display: block } #linksBox { position: absolute; top: 250px; left: 15px; right: -15px; height: 100%; visibility: visible; display: block; } A { color: #3333CC; font-size: 16px; font-family: "Times New Roman", Arial, Helvetica, Geneva, Swiss, SunSans-Regular } .db { vertical-align:text-bottom; } Rename your original files (and back them up) and put these new files in the folder. When you logon to your website index page, put a link to your database. Clicking that takes you to a mostly blank login page (no graphics, although you could modify that with css), and when the user logs off it will take them back to the index page. This works with multiple websites (including https) and multiple databases.
  12. RemoteScripter Connection Refused error

    Hi Brent- Thanks for your reply - it works great now with the robot running on the server, which is the way I needed it. FYI, I had to remove the port forwarding on the firewall to get it to work again, as that was somehow messing up the whole process. Don
  13. I have successfully configured remotescripter to call a script from IWP when the web browser is running on the same computer as the FM server. I then changed the IP address to my ISP IP address in the calling script, and I get a message of "Connection Refused". The router is open on the port I am calling (tested from outside), and the plugin is responding, but with the above error. I am running Mac Server 10.6.8, and FileMaker 12 advanced (fully patched). The 360works_webpublishing log shows the following: Sep 9, 2012 10:04:06 AM com.prosc.fmkit.PluginBridge$3 run CONFIG: === Executing plugin function RemoteScripterTrigger on thread Thread-124 === Sep 9, 2012 10:04:06 AM com.prosc.io.IOUtils getUrlContents INFO: Reading URL contents of http://75.146.1xx.xxx:49500?param postArgs size = 0 Sep 9, 2012 10:04:06 AM com.prosc.fmkit.Plugin setLastError SEVERE: PluginFunction PluginFunction{name='RemoteScripterTrigger', functionID=21146, minArgs=2, maxArgs=4} got an error with converted args [75.146.1xx.xxx, 49500, param, null] java.net.ConnectException: Connection refused at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:351) at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:213) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:200) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:432) at java.net.Socket.connect(Socket.java:529) at java.net.Socket.connect(Socket.java:478) at sun.net.NetworkClient.doConnect(NetworkClient.java:163) at sun.net.www.http.HttpClient.openServer(HttpClient.java:388) at sun.net.www.http.HttpClient.openServer(HttpClient.java:523) at sun.net.www.http.HttpClient.<init>(HttpClient.java:227) at sun.net.www.http.HttpClient.New(HttpClient.java:300) at sun.net.www.http.HttpClient.New(HttpClient.java:317) at sun.net.www.protocol.http.HttpURLConnection.getNewHttpClient(HttpURLConnection.java:970) at sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:911) at sun.net.www.protocol.http.HttpURLConnection.connect(HttpURLConnection.java:836) at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1172) at com.prosc.io.IOUtils.urlConnectionAsString(IOUtils.java:153) at com.prosc.io.IOUtils.getUrlContents(IOUtils.java:192) at com.prosc.remotescripter.RemoteScripter.RemoteScripterTrigger(RemoteScripter.java:222) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.prosc.fmkit.StaticFunction.invoke(StaticFunction.java:231) at com.prosc.fmkit.Plugin.invokeFunction(Plugin.java:333) at com.prosc.fmkit.RegisterablePlugin.invokeFunction(RegisterablePlugin.java:77) at com.prosc.fmkit.Plugin.invokeFunctionNoErrors(Plugin.java:314) at com.prosc.fmkit.PluginBridge$3.run(PluginBridge.java:1055) at com.prosc.fmkit.PluginBridge.runTask(PluginBridge.java:1264) at com.prosc.fmkit.PluginBridge.doFunction(PluginBridge.java:1069) Since the plugin is receiving the command, I have ruled out firewall issues. And, since the same code works when calling "localhost" when called from a web browser on the server, it seems the rest of the code is correct. Anybody have any ideas?
  14. My SuperContainer installation is not working, and I cannot figure out why. I have tried to upgrade it and I get a message that says "Can't write to the installation directory, please make sure you are logged in with an administrative account". I am logged in as admin. Setup: Windows 2008 server on a Worldcloud server. It was working, then quit sometime recently (not heavily used). The files are still located in C;/Users/Supercontainer When I browse to localhost/SuperContainer, I get an error page (see attached file). I made sure that the web.xml file Windows Path points to the above directory. I have restarted the server several times. I have change the permissions on the install folders - as best as I can determine they are - without luck. I have also followed the instructions here: http://wo.360works.c...SuperContainer8 I tried manually installing it and changing the uriworkermap.properties file (successfully), but that did not work. Any help would be greatly appreciated. Don

Important Information

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