Jump to content

Macfreq

Members
  • Content Count

    42
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Macfreq

  • Rank
    member

FileMaker Experience

  • Skill Level
    Expert
  • FM Application
    17

Platform Environment

  • OS Platform
    X-Platform
  • OS Version
    Mojave, Win 10 Pro
  1. Barb, good sleuthing to find out what the issue was. I have a client that is using FileMaker in an RDS Farm and is having Not Responding issues intermittently during the say, mostly in the morning. We are trying to make sure there isn't a network issue that is causing the issue and it appears not to be a database issue. Do you have any recommendations for the configuration of the RDS Farm? Or can point me in the direction on how to configure the farm for working with FileMaker Server and FileMaker client? Currently we are using FileMaker Pro 18 client and FileMaker Server 17. We will be moving to FMS 18 in the next month, which will hopefully improve the database processing. We are running Windows Server 2012 for FMS and Windows 2016 for the thin clients. What is the configuration for the client you are taking about in this post? Thanks for help. Tom
  2. I'm using a web viewer to display a html webpage that allows the user to interact with it via java scripts. The web page works on a Mac running FM13 and FM14 with Mac OS X 10.10 and 10.11. When I try to view the web page in a web viewer on Windows 7 running with IE11 installed, the webpage doesn't allow any interaction with the java scripts, and the web page renders incorrectly. I'm running FM13 and FM14 in Windows 7, and they both render the webpage incorrectly. When I copy the HTML out of FileMaker and paste it into a file and open it directly in IE11, I get a security warning on the bottom of the window that says "Internet Explorer restricted this webpage from running scripts or ActiveX controls", when I click Allow, the page renders correctly. If the Allow button is not clicked, the page would render exactly like it does FileMaker's web viewer. So it looks like FileMaker is suppressing this popup and just showing the web page with the scripts disabled. I checked Internet Options in IE and all relevant scripting options are enabled, but every time I try to display the page in IE directly, I get the security warning. So I'm assuming if I can get the page to display in IE without the prompt I can get the page to display in FIleMaker. What options need to get set to allow the scripts to run? Why does it work on Mac OS X and not Windows 7?
  3. Wim, do you still have the examples available somewhere? I can't find a downloads section on your website. I'm trying to execute a VBscript from within FileMaker Pro 13 so I can in turn execute an Adobe InDesign VBscript automation script and return any errors back to FileMaker Pro 13. I can do this now on a Mac with AppleScript and an InDesign automation AppleScript, but I need to port the process to Windows 8. Thanks for help. Tom
  4. This is a show stopper for me too. Apple doesn't make it easy to change the default ports for Mac OS X Server web and wiki services. So I'm stuck with the hacking work around. I agree, Apple dropped the ball on communicating with a company they own and show a total lack of collaboration with FileMaker.
  5. When I wrapped the on error section in a tell section the error was ignored by FileMaker. try return 100 / 0 on error tell Application "Finder" set fp to open for access file "Macintosh:Users:tomhorton:Desktop:NewFile" with write permission write "productID, outputFailed" & return to fp starting at eof close access fp end tell end try
  6. I'm trying to setup an error capture method for catching errors from an AppleScript that will be called from FileMaker. The test script is listed below. This script works fine using Apple's Script Editor but I get an error trying to add this script to the Perform AppleScript step in FileMaker. I'm trying to enter the exact script into the Native AppleScript field in the Perform AppleScript step but get the following error on the write command: "Expected end of line, etc. but found """. Does the write command need a different syntax than the normal AppleScript syntax? try return 100 / 0 on error set fp to open for access file "Macintosh:Users:tomhorton:Desktop:NewFile" with write permission write "productID, outputFailed" & return to fp starting at eof close access fp end try
  7. Removing carriage returns beforehand might be a good way around the problem. The ultimate goal is automation so I don't care if the files are human readable. I'll try this out.
  8. I'm trying to use Export Records on a single record to export a single field containing XML code. The file needs to be in UTF-8 format, which is why I'm using Export Records instead of Export Field Contents. I'm exporting as a Tab separated file. The problem I'm having is that the resulting XML code is malformed because the carriage returns are stripped out and there is one single line. Is there a way force FileMaker to keep the carriage returns so the code is correct? When I use Export Field Contents the code is unchanged. Thanks
  9. The applescript looks promising but I haven't ran an applescript from within FileMaker before. For the following code, how do I export a global field called g_field to a file called text.txt? I'm not sure where to put the actual field and filename. copy cell "filename" of current record to fileName copy cell "Text_" of current record to exportMe do shell script "echo -n " & quoted form of exportMe & " > ~/desktop/" & quoted form of fileName
  10. I have a global field that I'm trying to export into a file using Export Field Contents but FileMaker is creating a UTF16 encoded file. I need a UTF8 encoded file. Is there a system or FileMaker setting somewhere that can change this default? I'm on a Mac running 10.6 Thanks,
  11. Thanks for the confirmation. I was thinking that was the case. Oh well, I should be able to come up with a script that will automate the import of the data I need from Access. Full ESS woudl have been easier.
  12. Does ESS in FileMaker 9 fully support the lastest releases of MS Access? I don't want to just import data from Access through ODBC but want to use it as a data source through a shadow table to get data on a regular basis. Thanks, for the help. I've been reading about ESS support for Oracle, MS SQL Server and MySQL but not much on MS Access apart from importing.
  13. Hey Tom, I have a similar problem. I have a single value Option list that I want to be visible only when otherfield1=otherfield2. I set the text properties to be invisible by default, like you suggest. I can get the conditional formatting to work for making the text of the option list appear, but I don't see how to apply the conditional formatting to the option's circle so it is appears too. Is that possible? Thanks.
  14. That's a good question. Unlike Tiger, Leopard doesn't give you the option to add individual ports, you add firewall permission on a program by program basis. After I allow the access everything works fine, so the correct ports are enabled in the firewall, it just has to ask EVERY time.
  15. I have Leopard's firewall on but every time I launch FileMaker 9 it asks me if I want to accept incoming network connections. I click Allow and in the Firewall Preferences I have FileMaker selected to Allow connections. But it keeps asking me every time. Is there a firewall setting I'm missing? Thanks.
×
×
  • Create New...

Important Information

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