Jump to content

Search the Community

Showing results for tags 'fms11'.

More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Custom Function Library

Community Forums

  • Community Resources
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Security Management
    • Security Concepts
    • Intellectual Property
  • FileMaker Server Administration
    • FileMaker Server 16
    • FileMaker Custom SSL Certificates
    • External Server Authentication
  • FileMaker Go & Mobile Strategies
    • FileMaker Go for iPhone & iPad
    • iBeacon Support
    • FileMaker IOS App SDK
  • FileMaker and the Internet
    • FileMaker REST API
    • FileMaker Cloud
    • FileMaker WebDirect
    • Custom Web Publishing
    • Other Internet Technologies
  • FileMaker Interface Features
    • Cards & Window Management
    • Interface Design Discussions
    • Layouts
    • Themes and Styles
    • Button, Popovers, Button Bars, SVG Icons
    • Tab and Slide Control Panels
    • Portals
    • Web Viewer
    • Conditional Formatting
    • Custom Menus
    • Value Lists
    • Tool Tips
  • FileMaker Schema & Logical Functions
    • Managing Scripts
    • Calculation Engine (Define Fields)
    • Custom Functions Discussions
    • FileMaker Query Language or FQL
    • Relationships
    • Charting
    • Remote Container Fields
    • Finding & Searching
    • Importing & Exporting
    • External Data Sources
    • Advanced & Developer Features
    • Reports, Printing & Publication
  • Brain Food
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • OS Level Database Automation
    • Hardware & Networking
    • Bar Codes (Printer, Scanners, Software)
    • Accounting Solutions
  • FileMaker Discussions
    • FileMaker Pro 16
    • FileMaker Pro 15
    • Legacy FileMaker Platform Discussions
  • Productive Computing Support Forums
    • Visit Productive Computing
    • General Discussion for Productive Computing Products
    • Core CRM Solutions
    • QuickBooks and Accounting Plug-ins
    • Contact and Calendar Management Plug-ins
    • FileMaker Utility Plug-ins
  • 360 Works Official Product Support Forums
    • 360 Works General Support
    • MirrorSync by 360Works
    • 360Deploy
    • SuperContainer by 360 Works
    • ScriptMaster by 360 Works
    • FTPeek by 360 Works
    • 360Works Email Plugin
    • DocuBin by 360 Works
    • Zulu – FileMaker, iCal & Google Calendar.
  • Geist Interactive Product Support Forums
    • Visit Geist Interactive
    • Visit Modular FileMaker
    • FMPerception
    • Generator
    • fmQBO
  • FM Starting Point - By Richard Carlton Consulting
    • Visit FM Starting Point
    • FM Starting Point - General Discussions
  • FM Forums Affiliate Sponsors
    • Monkey Bread Software (MBS Plugin)
    • SyncServer Pro by LinearBlue
    • ISO FileMaker Magazine
    • Open Source Frameworks
    • FileMaker Plug-Ins
    • User Group Central - Sponsored by FMPug.com
  • FileMaker Classifieds
    • FileMaker Product & Service Announcements
    • Professional FileMaker Training
    • Services for Hire
    • Services Wanted
    • Solutions Wanted
    • Tools Of The Trade
  • The Water Cooler
    • Member Lounge
    • Wants & Wishes
  • FM Forums Operations
    • FM Forums Feedback & Site News
    • Site Instructions
  • FileMaker Platform


  • Captain's Blog
  • FileMaker Weetbicks
  • FileMaker Security Blog
  • The FileMaker Rift
  • HOnza's Bits @ FMForums
  • SeedCode
  • CampSoftware, Hal Gumbert
  • FileMaker Hacks
  • Skeleton Key's Blog
  • Wing Forward Solutions
  • 360Works Articles and Tutorials
  • GoBillit
  • Filemaker - an amateur's view
  • Linear Blue
  • Surya Kanta Mekap's Blog
  • eXcelisys' Blog
  • Manjit Behera
  • Blue Feather's Blog
  • RCC's FileMaker News and Bits
  • Thorsen Consulting
  • DB Services Blog
  • FileMaker Magazine
  • Eye on FileMaker
  • Dev Talk
  • The Philosophy of FileMaker
  • Button Bar Icon - Text Alignment Issue
  • 1-more-blog
  • Productive Computing


  • Samples
  • Solutions
  • White Papers
  • Plug-Ins
  • FMGo

Found 55 results

  1. FMSA 11 - error 512

    I am running a server side script that attempts to update records in a MySQL table that is set up as an external data source. It runs without issue for hours to weeks at a time then gets hung on error 512 (Record was already modified by another user). The problem is that I can't figure out how to capture and handle this error. I've tried adding "If get(lasterror)=512 then <skip this record and continue to next> just after the 'Go to Record(next)' but it never gets to that step. Instead hangs on try to move the record pointer and writing error after error to the log. I've searched the forums fairly thoroughly but there is not a lot of info forthcoming. Surely this has been a problem for someone else that has figured out how to handle it. Any suggestions appreciated. Will be glad to provide more info on the environment if needed. Thanks in advance, Steve
  2. What is wrong when Database appears unavailable to the scheduler, yet regular users are logged in?
  3. I'm running FMS on OS X 10.9.5. It's serving forty databases, one of which is served to the web via custom web publishing. Everything is running smoothly but the campus security auditor is picking up a vulnerability with the old version of OpenSSL running on OS X 10.9.5's Apache. I addressed this on a different, non-FMS Mac by disabling Apple's bundled Apache and using MacPorts to install Apache2. How to do this on my FMS 11 Mac? Just getting MacPorts to install Apache2 is the first problem as port install apache2 fails with a conflicting ports message. I assume this is because the existing Apache is blocking installation of the new version but how to stop the existing one? I tried turning off web publishing in the FMS admin console but port install still fails with the familiar conflicting ports message. Even stopping the web server with Mark Banks' FMSControl didn't help. I therefore have a couple of questions: How do I stop the existing Apache so MacPorts will install Apache2? Once I have Apache2, how do I get FMS11 to use it instead of Apple's bundled Apache1? Thanks Colin
  4. Hi, I am using filemaker 11 to copy customer info from excel into the database and then it would generate special keys in pdf allowing us to send the file to the customer. My access to the filemaker is non-admin, and the import function of customer info has been blocked. We are keying in the record one at a time, so we are looking at ways to automate this process. When I try to create a new record using applescript with just it was not allowed. There are data that require validation like date and auto-indexed record number. So, is there a way we could create new record and then using the set function to copy data into the report?
  5. How can I get ESS access to PostgreSQL from FM11SA?
  6. I have two filemaker servers. One is version 7 and the other is version 11 advanced. I transferred the files from FM7 server to FM11 with no problem. Long story short, everything was great until I realized that the users were still using the FM7 files. To fix the problem, I shut down the filemaker service on both servers, then made a backup of each server by copying the files to another folder. Then I removed the FM11 files that were never used and copy and pasted the .fp7 files from the FM7 server to the FM11 server. I started the filemaker service on FM11, opened the files using the FM11 console. Now when I try to open the files on a workstation, the files do not show up in the Remote list. The server console shows that they are open. How can I correct this?
  7. Online backup

    Hi: I want to share a good cloud backup alternative, Hubic, it gives 25 GB free, and you can schedule backup to happen "x" hours or minutes after a file has changed. So just add a backup schedule to the "Hubic"folder of your PC or MAC where you have your server and instruct Hubic to sync 1 hour after, that way you make sure the upload will happen after your backup has completed. Neat and free. I was using Onedrive, but with the recent decrease in free capacity I looked for alternatives, I specially like the delay before upload. Carlos
  8. I'm helping a client who has an old install of Filemaker Server Advanced 11 running on a Mac Mini. It's been running Filemaker v11.5 for about 2 year without any issue... All of a sudden today, it stopped working! I checked to see if there were any updates installed from apple or java... NONE! I completely uninstalled Filemaker Server and reinstalled v11.5 and applied the java fix... still won't start. Just for laughs I installed v11.2, that installed fine, up and running no problem, as soon as I restart the Mac Mini, everything takes a dump. When I go to localhost:16000 or serverip:16000 in the browser, nothing happens, as if filemaker server was never even installed. If I double click the applet icon, it says "Unable to launch the application - Connection Refused". Any thoughts?
  9. I have added an internal SSD to my FMP server machine and have moved the databases to a folder on this drive. I specified this folder in the Additional Database folder path (and checked the box for use additional database folder). I am able to host the databases this way. However when the server is rebooted, they do not start up automatically as they did when they were in the default location. I cannot find anything to tell me how to control which databases are launched on startup. Is there a way to make my new folder the default folder? Thanks!!
  10. Hello, I have recently had to re-install our FM Server and for some reason, the cache flush distribution interval is set to 03:01 (3 hours and 1 minute) and it won't change. I don't understand why it is doing this. I have tried adjusting it, saving it, and restarting the server, but it just stays at 03:01. Has anyone else had this problem? After a few initial searches, I have not seen this come up anywhere else. Any clues on how to fix this? Thanks in advance!
  11. Does anyone have an idea of how many characters I can use into ExecuteSQL command? Or if there is a limit on an ODBC connection? I used ExecuteSQL and it gave me error message "string too long" till I reduced the size of data to 2000 characters only. Any idea if I can use more? And how?
  12. I'm using pyodbc to send SQL queries to a filemaker 11 server. I can read data, no problem. I can update data, no problem. But when I attempt to insert data, no errors are thrown but no records are added to the database.
  13. Sorry If this is a little basic, but I couldn't seem to find a straight answer on this. If I have developed a database with FMPA 13 can I host it using FM server 11? If it does work, does it need to be accessed with FMP 11 clients or FMP13 clients for all functionality to work?
  14. I am running FMS v11.0.2.217 Users are running 10.0 v3, I just realized a few are running 10.0 v1. Server is Windows 7 Pro SP1 In the last 30 days, 2 different times, When Windows Updates were applied, I am unable to log in to the database from all computers. The first time, I had to rebuild all the databases and restart all the PCs. The second time, All the PCs were restarted and can access the databases, but the server itself cannot login to the files. Here is the error I get on the server (note, no other users are affected): Problem signature: Problem Event Name: APPCRASH Application Name: FileMaker Pro.exe Application Version: Application Timestamp: 4a3ad6bc Fault Module Name: ntdll.dll Fault Module Version: 6.1.7601.18247 Fault Module Timestamp: 521ea8e7 Exception Code: c0150010 Exception Offset: 0008482b OS Version: 6.1.7601. Locale ID: 1033 Additional Information 1: 65ad Additional Information 2: 65ad32e6764235fd8ab502cb31467ec6 Additional Information 3: 7b91 Additional Information 4: 7b912993949a407ff6fd5159679aa61a Any input that can be provided would be helpful. Thank you. David Stark / Anchorage AK
  15. ODBC Imports

    I'm scripting an ODBC import (Microsoft SQL Server) from a hospital information system. I'm using this infomation to construct a report containing "notes" which can be viewed/printed else where in a different FM11 file. I'm unsure as to the best way to approach importing these records and I was hoping to get some opinions on the circumstance: Background Info: I have a relational key that can be used to join imported records to existing filemaker records. I have an ODBC driver installed on each workstation in order to access the appropriate SQL tables via FM 11 ODBC import. Approach: I could import reports at the moment an employee executes/navigates to a particular report layout. I could create an SQL import with the appropriate "WHERE" clause which would reduce the import performance hit (versus importing 10000 + records each time). Question 1: With the latter approach, I'm concerned about importing duplicates. To avoid duplicates in each imported table, will validation rules prevent duplicate records from updating? For example, if I put a validation rule on a primary key field and a import is conducted while a found set is present, will this alway result in the importation of new records? Tests: I have executed scripts to import records, including validation rules as described above, and it seems to be working to fit my need (not importing duplicates, even when found sets exists). Any comments or suggestions would be greatly appreciated!!
  16. Can FileMaker 11 Server Advance be upgrade using FileMaker 12 Server (regular Version not advanced). ??
  17. I have an input system in FMP11 that uses a dialog box with a global field to input quantities for each record. On click OK the script will add the value in the record proper field. The users should enter just one number in that dialog box global field (e.g.: "10" or "-10"). I'm trying to create a validation script to make sure that the users don't type weird stuff except that one number. (It happened that they typed expressions and spaces, making the system fail. e.g.: "+10-5+ 30- 15" ). So far I got to his: Once typed the value in the Custom dialog GLOBALFIELD and click OK -> On my tests everything looks fine but I would appreciate any comment from an external eye. Thank you all for your help. Have a great day.
  18. Fairly sure the issue is localized to the one client, but I cannot find the issue. This one newly installed client cannot see the files remotely hosted on our server, the other 400 clients have no issues. I've confirmed it is this one PC my installing NMAP on the client and scanning the server and it can see port 5003 open on the server. I've went even further and installed Wireshark on the client and filtered the server IP and tried to connect, wireshark showed no communication with the server, not even an attempt. This leads me to believe the issue is 100% with the client, but I don't know where to look or what to try. - Bonjour is installed - I can ping all of our servers with no issues I found one snippet of information that might help me: http://help.filemaker.com/app/answers/detail/a_id/5493/~/cannot-see-hosted-database But I could not find the resource they were talking about. Right now any help is appreciated.
  19. IWP Problem

    Using FM 11 Server Advanced  I am having a problem with IWP. On the attached picture there is a list of students with choices for teachers to input classes for next year. The choices were set up as a value list and radio buttons. All the students are defaulted to Standard (Using the client). When the teachers access the internet file and select a different radio button, it will only update one student at a time. Is there anyway the teacher can go down the list, click on the desired radio button for each student and then submit the selections to the server?  Is there some script that will accept the buttons then submit the data and go to the next student. I realize that I am looking a multiple records on one screen. But is there a way? Better yet is there a way to select a radio button for each student and then submit the data to the server?  Any help would be appreciated  Lester
  20. I'm doing something new so pardon me if I don't have all the details. My Company would like to get daily snapshots, for example, how many orders are in-house. Then you can graph and track the trend: are the number of orders going up or going down. My understanding is that the server (Filemaker 11 server standard) can utilize the "Schedule" feature to run the script. "created a schedule", selected my database and entered username/password. Selected the script to run. No timelimit, Set the frequency (currently every 1 minute since i'm testing it) My script: Goto TrendTable layout make a New Record Insert Current Date into DateField Insert Current Time into TimeField Set Field SOCount = Count(SalesOrderDatabase::SalesOrderNumber) When I run the script it works fine. When I run the Schedule to run the script, the server reports "Filemaker Script Error" I set up a notification Email, and it tells me "Schedule "Timer Test" completed; last scripting error (103)." First: am I on the right track? and 2nd: where is the problem? is it because I'm trying to get information from a related table? Thanks in advance. Scott
  21. As stated above, no idea where this came from. Last successful edits performed a few days ago, today, no modifications allowed. Logged in as admin remotely as well as on the server itself, same behavior. Can't change anything in the file, or in the security settings etc. This is on the MacPro running 10.6.8, latest available OS patches, server version, running with IWP, all other web options off. Security: FM accounts only; List only authorized DBs; SSL enabled. I did install the SSL patch for 11 several weeks ago, but no adverse effects were noted at the time... Any ideas welcome...
  22. This import script has run for 1-2 months non-stop, no problems. The script runs fine when: 1) I run the script manually from the scheduler in FileMaker Server Admin console. 2) run from FileMaker Pro But I m not really interested in any manual approach. The problem is that when the scheduler in FileMaker Server Admin console executes the script every 5 mins; an email is issued in essence telling me this: last scripting error (718).
  23. Hi fmforums! I'm drawing up a simple database management tool to manage multiple databases in FMP11. Nothing fancy, just the ability to assign users to multiple databases on FMServer 11, and then run a script to add these users to the assigned databases. I have created the following fields in my database table: Filename ExportFilename SvrLocation WinLocation MacLocation on the basis that the database filename would be recorded under filename and the full path to it would be recorded under WinLocation - if stored on a PC, MacLocation, if stored on a Mac and SvrLocation if stored on a server [just covering the bases] The script step that I'm having issue with is: Open File I was under the impression that Open File would allow me to provide a variable path similar to the Export File Script step. In that you can do: Set Variable $path = Database::MacLocation & Database::ExportFilename Export File using variable $path Is there some way that I could reproduce this flexibilty in the Open Path script step so that I wouldn't have to re-edit the script everytime a new database is created? Any suggestions would be appreciated.
  24. Hello Everyone Today I installed the "fms_11.0.5.510" updater to my database server and my web server.  I needed to run the "fms11patch" installed  in order to get the admin console working again. Once I logged into the admin console again I was greeted with a big old error message that I have never seen before.  When I am viewing the "Filemaker Server Overview" page there is a red light with a error message stating " Server Status Information - An error was encountered communicating with the server" I have attached a screen shot - the odd thing is all my Filemaker web services appear to be working correctly but i really want this red icon gone... Any advice would be greatly appreciated!
  25. Looking at the documentation, solutions, etc, I am unable to tell exactly where I should be looking to find a solution that will fit our needs. We've got FMS 11 setup and running and use it internally via the desktop program, now we want to expose part of the info to outside customers via web. I'm hoping if I explain our needs the community can point me in the right direction to find a solution! We'd like to provide a simple webpage for customers to enter in their order number and receive status/tracking info for it. If you know the order number you can get basic info. (yes this is a security concern, see below) We don't want the whole account exposed, just some very basic info. It appears that IWP (or WebDirect if we upgrade) is not the way to go for this. We'd like to not have to assign usernames and passwords, so we'd want just barebones order info shown with no personal account info of the customer. This will hopefully mitigate the security concerns of being able to pull up any order with only an order number. This does not require the ability to make any changes on the customer's part, just informational only. However if the data changes in the database we'd want that reflected in the output, so we'd like to avoid using static web pages. That's it to start, should we be looking at FileMaker PHP/XML publishing, moving to the newer version of FileMaker and using WebDirect, looking for a FileMaker consultant, etc? Thanks in advance for any assistance! (note, cross posted from a topic I started several days ago on the official forums that's gotten no response, please excuse if such cross posts are not allowed)

Important Information

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