Search the Community

Showing results for tags 'fms13'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Categories

  • Custom Function Library

Categories

  • Journal

Community Forums

  • Community Resources
    • FileMaker Pro 15 Discussions
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Security Management
    • Security Concepts
    • Intellectual Property
  • FileMaker Server Administration
    • FileMaker Server 15
    • FileMaker Server 14
    • FileMaker Custom SSL Certificates
    • External Server Authentication
    • Stand by Server Deployment
    • Legacy FileMaker Server Discussions
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • FileMaker Go for iPhone & iPad
    • iBeacon Support
    • FileMaker IOS App SDK
    • FileMaker Discussions
    • Brain Food
  • FileMaker and the Internet
    • FileMaker Cloud
    • FileMaker WebDirect
    • Custom Web Publishing
    • Other Internet Technologies
  • Geist Interactive Product Support Forums
    • Visit Geist Interactive
    • Visit Modular FileMaker
    • FMPerception
    • Generator
    • fmQBO
  • 360 Works Official Product Support Forums
    • 360 Works General Support
    • MirrorSync by 360Works
    • SuperContainer by 360 Works
    • ScriptMaster by 360 Works
    • FTPeek by 360 Works
    • 360Works Email Plugin
    • DocuBin by 360 Works
    • Zulu – FileMaker, iCal & Google Calendar.
  • FM Forums Affiliate Sponsors
    • SyncServer Pro by LinearBlue
    • Open Source Frameworks
    • Monkey Bread Software (MBS Plugin)
    • FileMaker Plug-Ins
    • ISO FileMaker Magazine
    • User Group Central - Sponsored by FMPug.com
  • FM Starting Point - By Richard Carlton Consulting
    • Visit FM Starting Point
    • FM Starting Point - General Discussions
  • 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

Blogs

  • 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

Categories

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

Calendars

  • FileMaker User Groups

Found 324 results

  1. I want to start at 1 for the next quarter, but it is currently 13 days before the end of this quarter. Logically I could start auto-enter serial at -13 and incrememtn by 1. So the first record would be -13, then -12 etc. Doesn't seem to like it. First record is -13, second is -14. Is this a bug, a feature, or known behaviour?
  2. I have a portal that shows records from another table. They are 'available' or not currently assigned records. The problem is that the list is too long. I would like to be able to filter the list by entering characters in a Filter field. The relationship currently looks like this: Available = yes I would like something like: Available = yes and Filter (is a substring of) Productname I can't for the life of me figure out how to do that.
  3. I have a look up table of products with parameters such as style, size, colour etc and of course price. In another table I have the items ordered which allows you to choose a style, size, and colour and looks up the price form the products table. I achieve this calculation using a field which contains a concatenated string like this 'style-size-colour' in both tables and a relationship based on this field. I use this relationship to return the price. It works the first time, but when I change one of the parameters the price is not immediately updated. How do I force a refresh?
  4. mac

    Hi there I'm trying to get SyncDeK to connect to FMS 13 on a clients' server. I have it working successfully on my own development server, but for some reason, ODBC/JDBC won't start on the clients' machine. FMS 13.0.5.520 on OSX 10.8.5 Apart from ODBC / JDBC access, FMS has installed and deployed correctly. Although ODBC/JDBC is ’switched on’ in the Admin Console, there is no ’tick’ on the left hand side. Additionally, the fm_xdbclistener process is not listed in the Mac 'Activity Monitor'. I have attempted to start the xdbc process from the command line by using "fmsadmin start xdbc" but receive an error message ("Error: 10017 (Requested object is disabled)". When I attempt to connect via JDBC (from SyncDeK) I get the following message: "Couldn't build table profiles, caused by: [FileMaker][FileMaker JDBC] Connection refused. Check that the host address and port are correct and that xDBC sharing is enabled on the host." This appears to confirm that the XDBC service is not running. I've got a call in with FileMaker support, but wanted to see if anyone else had come across this problem before? I've been tearing my hair out all day trying to fix it, and have reinstalled FMS twice... Thanks in advance.
  5. I have a table called Employees. These are either Current, Freelance, or No Longer Employed. I want a list available to select current employees. I have a filed called Currentcalc which is a 1 if the employee status is current. All I want to do is to go to an unrelated table and be able to select current employees from a lost. I simply cannot get my head around how to filter lists. I have tried every possible combination of settings and cannot understand the logic of filtered lists. This should be so simple but I have now wasted an entire day to it. I cannot find a simple explanation on how this works, anywhere. Can anyone explain to me how drop down lists, based upon a calculation filed work?
  6. Good morning. My client has FMS14 running on a terminal server with about 8 clients using it at any one time from that terminal server. From the reports I am getting back, when they open the solution, they are getting a message that appears to show that the Network Sharing has been enabled. As I understand it, when the solution is hosted on FMS, then the Network Sharing (for peer to peer?) should be disabled, however, even after turning off Network Sharing, it appears to come back again. Why is this? How do I stop it please? The only problem it seems to be causing is the initial error message when the solution is opened. I access the file remotely (not through the TS) and I don't get that message - I'm also the only Mac client if that makes any difference. Any ideas would be appreciated. :-) Greg
  7. I had to migrate a Mac OS Mini Server running Mavericks 10.9.5 and Filemaker Server 13 to Filemaker Server 14.0.4 on El Capitan 10.11.6 today. It turned out to be an unpleasant and tiring operation, so I wrote a little manual that hopefully can help and save time for other people running into this situation. Some steps my not be necessary, but the following list describes the road I took, stumbling from one problem to the next. Rest assured that I left out a lot of swearing and three letter words that were also part of the process ;-) Greetings Ernst Backup your databases, stop and de-install any previous Filemaker Server version. The Filemaker 13 de-installer is located in the Extra’s folder on the Filemaker Server 14 installation disk image. Install El Capitan 10.11.6 + updates Do not install OS X server ( yet ) - see the notes at the end of this little manual. Remove the Java version installed with Mac OS - in my case Java 8 update 111. Steps from the Oracle website: In the Terminal window Copy and Paste the commands below: sudo rm -fr /Library/Internet\ Plug-Ins/JavaAppletPlugin.plugin sudo rm -fr /Library/PreferencePanes/JavaControlPanel.prefPane sudo rm -fr ~/Library/Application\ Support/Java Install the version required by the 14.0.4 Filemaker Installer: Java 8 update 60 before installing Filemaker. Installer is called: jre-8u60-macosx-x64.dmg After creating an Oracle account and logging in it can be downloaded from: http://www.oracle.com/technetwork/java/javase/downloads/ - Scroll all the way down and click Java Archives - Click Java SE 8 - Scroll down to Java SE Runtime Environment 8u60 - Click Accept License Agreement - Download jre-8u60-macosx-x64.dmg The Filemaker installer is supposed to install this Java version by itself, but in my case it appeared to contain the Java 8 update 31, causing a loop within the Filemaker installer, repeating the process of installing the wrong version. Get Filemaker fms_14.0.4.412.dmg. Use the full installer! In my case installing an earlier version and running the updater did not work - the updater to 14.0.4 hung during installation. Filemaker also advises this but unfortunately chose not to put the full installer on their website, so I had to Phone Filemaker support and supply the original sales contract number. After providing these details they mailed a link to the 14.0.4 full installer. Install fms_14.0.4.412.dmg Because I was planning a co-install with OS X Server App I used port 8080 and 8443 in stead of the standard 80 and 443 during the setup. Also I did not enable web publishing and ODBC/JDBC during installation because I desperately wanted to get the normal services working. Do not start Deployment when the installer finished but click Quit in the finishing dialog. Next step is to stop the server process via the terminal, as per Filemaker’s instruction: type or paste sudo launchctl stop com.filemaker.fms in a terminal window, enter and administrator password when required. In my case I had to restart the Mac and do this last step again after a fresh restart, before the FileMaker Server 14.0.4b Software Patch wanted to run without complaining about the Server being running. Run the FileMaker Server 14.0.4b Software Patch from http://help.filemaker.com/app/answers/detail/a_id/15575 Note that this installer will update your Java version to Java 8 update 66, in my case this went without any hiccups. Log in to the Admin console using the FMS 14 Admin Console.webloc shortcut placed on the Desktop by the installer. Alternatively point your browser to http://localhost:16001 and click Start Admin Console About co-installing with OS X Server version 5.2 I know the true purist warn against this; in this case the server is under a relatively light load, so performance does not seem to be an issue. Getting OS X Server to co-exist with FM Server proofed tricky though. Initially I had OS X Server app installed before trying the last FileMaker Server 14.0.4b Software Patch which caused the installer to hang again. So I had to command-drag to move the Server App from the Applications folder to the Desktop. After authenticating the Mac detects the removal and presumably stops and repatches all services involved. Then the FileMaker Server 14.0.4b Software Patch installed, after which I could put the OS X Server app back, re-login to server, re-enable the services, restart the Mac and finally login to the Filemaker Admin console. Next time I would leave the OS X Server installation as last step; possibly this will be less work.
  8. I have a couple of sequence scripts configured on our FM14 server (under Windows 2008 R2) and for some reason, the system level scripts after the internal FM scripts no longer launch under the identity I specify in the schedule config. They always launch under System and that's causing access problems. The server has been rebooted and I have tried brand new schedules for the tasks but nothing changes. Anyone seen similar behavior and have a solution? Thanks
  9. I have a FileMaker layout with a portal to another table. The relationship shows all unassigned records (related < 1). On each portal row I have a button which runs a script. The idea is that when you press the button the a value from the main record is copied and pasted into a field in the portal row (and as a result the portal record becomes 'assigned' and is removed from the portal. I have the button running a script and pasting the value from the main record but it is pasting it in the first portal record, not the one whose button was clicked. Is there a simple way of having the value pasted into the portal record where the button was clicked or do I have to store the record number (or something) and paste back to that record?
  10. For nearly 8 months, the company I work for has been experiencing very frustrating issues with xDBC Listener on FileMaker Server 12. We migrated to FileMaker Server 13 last week and we're seeing the same issues.  Both FMS12 and FMS13 have been installed on (separate) virtual machines, both running Windows Server 2008 R2 Standard (Dual-core, 16GB RAM, hosted DBs and backups live on secondary drives). ODBC connections hitting database files hosted on these servers are aborted anywhere from once to four times a day, but not always every day (it may go several days between abortions). The error reported on the server when the ODBC disconnections occur is "xDBC Listener process has terminated abnormally".  I have reported this problem to FMI and am in routine contact with their top-level support regarding this issue. They understand how important it is to fix this problem, but after nearly 8 months of troubleshooting with FMI, we are still having the same headaches.  I'm just wondering, am I the only one experiencing issues with xDBC Listener? I've searched the forum and found a few older posts semi-related, so I apologize if this is a duplicate post in any way.  Here's a screenshot of the xDBC Listener's affect on processor performance: What you don't see in the image is the CPU consumption for the listener alone is 55%. Once the ODBC connections drop off, CPU usage drops off to a normal state (<30% total).  My suspicion is that xDBC Listener.exe is simply the problem child of the FMS software. It's either the Listener, or possibly the ODBC driver that's at the root of the problem. Either way, I'm hoping this will be resolved soon. Without a reliable way for external systems to access data, it's hard to argue in favor of the FIleMaker platform is a viable enterprise-level solution for data management.
  11. Hello all. I am running the FMS 14 backup scripts to a custom folder on the same disk as the Filemaker install. There are a number of errors generated. Schedule window Status says "permission denied" Main Status window say "Schedule "Daily" aborted; the destination "filemac:/server HD/fmsbak/" is not writable." Folders ARE created the backup databases but some files are corrupted (although others not) The backup folders do not delete after the schedule number of backups. And only recently I can't change the folder path as nothing happens if I validate or save and to log out I have to revert. Any help with this would be terrific. Thanks
  12. mac

    Is there a way to uninstall Filemaker Server 11 on Maverick from the Terminal. The FMS 11 'Install/Uninstall' program won't load. Running on a Mac Mini running OS X 10.9.1
  13. FileMker, Inc. has released the 15.0v2 updater fro FileMaker Server. http://www.filemaker.com/support/downloads/
  14. Hi, I'm am using BasicElements BE_ExecuteSystemCommand via PSOS to run different commands and commandline tools for different purposes (PDF and image handling etc.) - and it works perfectly. However some commands needs to be run from an Administrator account or even Domain Administrator account, but FMS uses the NT Authority/System account for running scripts. How do I get around this? Is there anyway to change which account FMS is using?
  15. Hi everybody, Is there someone that have a licence to sell for a filemaker server 15? U can MP Thanks
  16. I have a database on a Filemaker 13 server. Initially I was having trouble uploading to a container, as it started taking a VERY long time for small documents. This was due to port 443 not being open. It is open for me now; however, I still get intermittent periods of slowness as if it isn't open. What seems to happen is when I go to the server, to check if things are still open - nothing seems to have changed, but when I go back - the file uploads much faster. The power saving settings on the server are disabled, but I think this slowness has something to do with when it goes to sleep. I'm not even sure what to look at or search for, it's so bizarre. Little Snitch reports that I'm accessing port 443 with no difficulty re: my filemaker connection.
  17. Hi Gang, long time no see! Anyway, I am attempting to use Insert From Url to pull in some XML data and am having no luck with it. When I use a url such as "https://ipaddress/fmi/xml/fmresultset.xml?-dbnames", I receive the expected result: <fmresultset version="1.0"><error code="0"/><product build="05/08/2015" name="FileMaker Web Publishing Engine" version="13.0.10.1003"/><datasource database="DBNAMES" date-format="" layout="" table="" time-format="" timestamp-format="" total-count="4"/><metadata><field-definition auto-enter="no" four-digit-year="no" global="no" max-repeat="1" name="DATABASE_NAME" not-empty="yes" numeric-only="no" result="text" time-of-day="no" type="normal"/></metadata><resultset count="4" fetch-size="4"><record mod-id="0" record-id="0"><field name="DATABASE_NAME"><data>FMServer_Sample</data></field></record><record mod-id="0" record-id="0"><field name="DATABASE_NAME"><data>LatestUpdates</data></field></record><record mod-id="0" record-id="0"><field name="DATABASE_NAME"><data>PSoS_Log_CWP</data></field></record><record mod-id="0" record-id="0"><field name="DATABASE_NAME"><data>TEST_XML</data></field></record></resultset></fmresultset> When I attempt to query the TEST_XML file, however, e.g., "https://ipaddress/fmi/xml/fmresultset.xml?-db=TEST_XML&-layoutnames", nothing is returned. TEST_XML is a simple one-table (called TESTER) file with one field ("id"), one layout ("Testing") and a handful of records. It is set to auto-login as [Guest], which has the [Full Access] privilege and only the fmxml Extended Privilege. The server is running Windows Server 2008 R2 Standard, SP1 and FM Server 13.0.10.1004, with everything enabled in the Admin Console. I am using Advanced 13.0v9 and Pro 13.0v9, though I receive an empty result in FireFox and IE also. Am I missing something obvious?
  18. Hi, we are going to sync two filemaker server 15 with 360works mirrorsync. does anyone have any experiance with that? how did it work? Thanks for your help Mikael.
  19. Hi all, I am trying to write a script that let me display multiple fields of the same tables and create a button that run that script. for example a button to show the current address and another on to show the previous address, or some thing like that. I don't know if this idea is doable or not. Thanks in advance for your help and advice. I am using filemaker pro 13 Thanks
  20. "This is the first time I'm setting up a script to run on a server with the help of a schedule, so I will probably make a lot of strange mistakes, but how hard can it be? Hard, obviously. :|" I have a script that check for new files in a folder, process them, export some data and move the files to a new destination. It works flawless with the Filemaker Client. On the Server I can't get it to work! I'm using the BE_ListFilesInFolder step. The folder that I want to check is the following (the FMServer User have both read and write privileges on all mentioned folders): C:\FTP\FM\In\ This is outside the server Documents folder, so just to be sure I tried to change it to: C:\Program Files\FileMaker\FileMaker Server\Data\Documents\In\ I get the same error on both. I have tried to use a field as the path as well as hardcoded as well as variables in different combinations: BE_ListFilesInFolder ( System::FMIn Folder ) BE_ListFilesInFolder ( "C:\Program Files\FileMaker\FileMaker Server\Data\Documents\In" ) Set variable($folderpath) and then BE_ListFilesInFolder($folderpath) Same error. I have tried a zillion different ways. With the Client it works. From the server it does not. I GET CRAZY!!! What have I missed? ...or should I just skip the Filemaker Server Schedule and do this with a client instead? Tia, /Andreas [Windows 2012 r2, FM Server v15.0.1.137]
  21. Does anyone have any work around for getting at the contents of a file imported into a container field that will work using a server side script? I would like a user to import a file into a container field and have the server process the file later. Ideas?
  22. Hello i'm new in FM, i making a data for my company, and i have a problem i been like to 2 days try to solved with out any luck, i have 3 tables: the company(table "company") can have many projects (table "projects") and the projects can have many person in charge (table "in_charge") and i have a 4th table "project_incharge" in other to add specific person to specific project so far i got the picture clear the problems is wen i add a portal to the projects table, and to a a record to it from the people in charge i just want to see the people charge for the current client, but i see the list from all the client in charge. so the idea asigne some in charge people to a specific project that work for a specific client, not all the in charge for all the clients i hope i make my self clear.
  23. Hi Filemaker experts, Please have patients on me for I’m still novice with this Filemaker language. I got two tables here: ServiceRequest and Customers Service Request table contains sixteen(16) fields: 1.SRNo 2.Name 3.Account No. 4.Address 5.Meter No. 6.RequestService 7.RequestType 8.Remarks 9.Attention 10.DateTimeCreated 11.Receivedby 12.Notedby 13.Confirmedby 14.DateTimeAction 15.Actedby 16.Conformedby Customers table contains four(4) fields and have 500 records: 1.CustName 2.CustAddress 3.CustAccountNo. 4.CustMeterNo. The “Name” field as drop-down list under the Service Request table, I’m using “Autocomplete using Value List” for user to type the customer’s name and just select it. But the problem is, when I selected the customer’s name, the Account No, Address, and Meter No. will not automatically fill-up with their corresponding address, account no and meter no of the customer. What I want is: When a user selected a Customer’s name from a drop-down Customers name’s list, the address, account number, and the meter number should as well automatically filled-up with the corresponding information of the selected customer in the customer’s name field. Let say, If I selected the name “EDDIE GARCIA” in the drop-down list Name : EDDIE GARCIA Account No. : Address : Meter No. : The Account No, Address, and Meter No as well should be automatically filled-up with the corresponding information of EDDIE GARCIA. Name : EDDIE GARCIA Account No. : 012-012-015 Address : Brgy. 06 Jose Rizal Street Meter No. : 90806450 I will appreciate very much if someone can help me with this. Thanks!
  24. I have a job that I will need Filemaker to do, At the moment I would have to load it onto our old 2008 standard server till we get a new machine in the new year. For now this project will not be very intensive about 5/6 users at most. Would it work?
  25. After php 7.0.1 installation (successfull) i can´t edit filemaker server´s deployment anymore. on test step, there´s a message: "The FileMaker installation process was unable to communicate with the web server.". Someone knows how can i fix this?