Search the Community
Showing results for tags 'fms12'.
Found 95 results
-
mac Completely newbie question: Import data from excel
chichi_delux posted a topic in Importing & Exporting
Hello Group! Is it possible to import many images into my FM file from a very basic unlinked excel file? If so any tips are greatly appreciated. Thank you in advance, Chichi -
When I try to open the FMS12 Console, I see a dialog   Is this because I'm running Java 7.75?  I could not find any settings in System Preferences or Safari Preferences that had to do with certificates.   This occurred on Yosemite.  On Mavericks, nothing at all happens when I click the Start Admin Console button.  Please give me some suggestions.  --Doug  EDIT:  Fixed with installation of version 12.0.5 on Yosemite.  Off to install 12.0.6 on Mavericks to see if that helps there.
-
Filemaker website says this combination works, but how is it in real life? Am I missing anything significant by not going to Server 13? I'm currently running FMS 10 on Mac OS 10.6.x. If I go to Server 13, I'd have to update my OS as well as Parallels and I'd rather avoid that. Also, how do the concurrent user licenses work with FMS 12? Or is that specific only to version 13?
-
pc server side script not waiting for a calculation before continuing script
happymac posted a topic in FileMaker Server 12
I have a script that 1) loads a layout and on that layout there are a series of calculations that take a few minutes to calc. 2) it them exports that data to a CSV The script runs fine on a workstation (filemaker Pro 12), but when running on the server (server 12) it doesn't complete. It actually does run the scripts successfully, but no data is exported. After much troubleshooting, I think the problem is that the server is not waiting for the calculations to load before it goes on to the next step. as an example, on the workstation the process takes about 20 minutes to complete, yet on the server the script is over in about 15 seconds. Is there a way to force the server to wait for the calculations to complete before continuing with the next script step? -
Hi, I'd like to sort records using value lists as well as text fields. My FirstName field works (try Steve) but I'm at a loss on how to make the valuelist sort records correctly. I want to search records from CA in my State valuelist. Here's a link and the php code. Thanks All! http://ssvtennis.com/valuelistsort.php valuelistsort.php
-
Does anyone know when I can buy FileMaker Server 12 ? I'm currently on version 11 and want to upgrade. Can some please help me out? Thanks, John
-
Hello, was wondering if someone could share some insight onto how server scripts handle global variables. I have an email script set on a schedule that, as part of it, moves between layouts. One of the layouts it goes through has a script trigger for OnLayoutEnter that changes the custom menu set based upon username. The 'Install Menu Set' aspect of that script trigger breaks the email schedule and forces an abort. I've tried to work around that by using: If $$Script = 1 Exit Script End Ifin my script trigger. Then declaring Set Variable [$$Script; Value: 1] <email stuff with layout changes> Set Variable [$$Script; Value: ""] in my email script. But, the schedule seems to ignore the global variable and proceed to run through the script trigger, breaking itself. Am I doing something wrong or can I just not use global variables in scripts run by schedules? Any help appreciated.
-
Greetings! I've inherited an instance of FileMaker Server 12 that is hosting 100+ files, and 80% of them haven't been used or even logged into in years. 5% are used regularly, and 15% are used very occasionally. The issue is I haven't the foggiest idea which is which. Does anyone have any clever ideas on how I could, in one fell swoop, figure out which ones have fallen out of use? Are there database file properties hiding somewhere? In a perfect world, I would like to know: The date any user last logged into a file; The date any user last edited any data in the file; The account name of those users; The date the file was actually hosted. (I realize the answer is probably no, but I can dream, right? And there has to be SOME way to figure this out besides asking 500 people which databases they use...) Any and all ideas are welcome. Thanks! - Joy
-
Hi All, Â Need a help urgent. Â I have written a Filemaker server side Script. All the script steps are correct according to me. Howerver, when i run on the FM Sever 12, it gives script error. Â I am attaching the screen shot of the Filemaker script, as well as Logs created on FileMaker server. Â Please help me to solve this issue. Â Thanks in advance. Â Â
-
I have noticed for quite a while now (a few years) that often when I try to reopen a hosted file that FMPA will spin for 20-30 seconds and respond with "file not available on this server..." error. But upon retrying it a 2nd time, it always comes right up. Anyone else run into this? This has happened on FMS12, 13 and 14 for me. This has been across multiple servers (same client location), different machines/clients, and different files. It has been just a minor annoyance so I haven't tracked it real well: I can't attest to whether it happens every single time I open the file; or perhaps it is only after leaving the office (after properly shutting a file down), and then coming back to the office the next day; or ?? Anyone else had something similar happen? -- Justin
-
Hi, As we know that we have option to configure FileMaker Server with PHP (which is installed on IIS).. Like the way.. I have another question.. Do we able to configure FileMaker server with PHP Which is installed on Apache (with Linux machine).. Please clarify.. If you already experienced please help us to configure Filemaker 12 server with Apache.. Many Thanks ~Guru
-
php edit form, get dropdown to pull value for that record
randyinla posted a topic in FileMaker Server 12
Hi, I was successful in creating records with drop down valuelists from my db, now I'd like an edit form on a new page to show those values and edit them. I only see the unedited drop down lists in the edit form. Here is some code: $layout =& $fm->getLayout('mylayout'); $values = $layout->getValueList('statelist'); $statelist = '<select name="State">'; foreach ($values as $value) { $statelist .='<option value="' . $value . '">' . $value . '</option>'; } $statelist .= '</select>'; $edit = $fm->newEditCommand('mylayout', $_POST['id']); $edit->setField('State', $_POST['State']); $edit->execute(); $record = $fm->getRecordById('mylayout', $_GET['id']); $State = $record->getField('State'); <td><?php echo $statelist; ?></td> Thanks so much! -
Hi Am running FMS12 - I found the post regarding server import export and have followed these instructions. http://fmforums.com/forum/topic/64713-server-side-imports-and-exports/ However the script that I set up to import a file is failing, I believe this is because it is not finding the file to import, although I get no error only a time out, and given the test is for but 100 records am certain that it is not because of inadequate time to run it. I have tried: Setting up a variable to Get (DocumentsPath) & "[filename].xls" Have added "file:" and "filewin:" types to precede that so "file:" & Get ( DocumentsPath ) & "Kinds.xls" and "filewin:" & Get ( DocumentsPath ) & "Kinds.xls" Have used the "Get (DocumentsPathListing) to gather the files in the documents folder and used the explicit path to try to import from that. Alas to no avail. Noted that the directory uses back slashes not forward slashes (as the documents path listing shows) when I view this in properties, so I've even tried the path from there. Am exporting fine into the directory using the same variable, was then hoping to switch to another layout and import the same records back in, works fine on standard FMP, but just can't get it working on FMS. Any ideas would be gratefully received. Thanks
-
pc The PHP connection to the FMServer_Sample database failed (Error 22)
BarryBKS posted a topic in FileMaker Server 12
Hi all, I'm new here so I hope I get everything right. I've done a search already, but I can not find my issue listed. Sorry if it's been covered before. OK, here goes..... VMWare Server running on HP Prolient G7 tin 2 Virtual Cores 4Gb RAM Windows Server 2012 R2 DataCenter x64 IIS v8.5 (Default for 2012 R2) FileMaker Server 12 FileMaker Pro 12 Advanced with Bonjour JRE v7 This is a brand new build specificity for this use. I've installed FileMaker Server 12 on to the above setup with Custom Web Publishing using PHP I followed the deployment wizard and deployed for a single machine setup. I allowed FMS to install the provided version of PHP with it's own configuration. There is NO SSL configuration on the server at present. The admin console shows three green ticks to indicate that everything is happy. However, when I run the PHP Custom Web Publishing Test, I get the page displayed correctly, (PHP is working) and it identifies the name of the server, but below the main information box, I get the following error message: The PHP connection to the FMServer_Sample database failed. The PHP test was not able to communicate with the Web Publishing Engine. Make sure you have PHP publishing enabled and the database has the fmphp extended privilege enabled. (Error 22; Unknown error) The sample database is installed and it is listed in the admin console, status, normal and dots across the line. I can't imagine that it wasn't installed with the correct Extended Privileges for CWP and I would not be 100% confident to know what I should check for. I am viewing the CWP Test webpage on both the server and a client and getting the same error message. Can anyone suggest any further areas that I should be looking at? Cheers in advance, Barry. -
Maybe I’m the last one to notice this, but I’ve come to appreciate that Filemaker Server backups don’t replace the copy of any database that has not changed during the daily backup for instance. The result is that if one has the verification box checked it doesn’t happen for those databases. What’s interesting is that one can see the pattern of change simply by looking at the pattern of successful consistency checks. Where I seem to recall reading about databases where there is no change, not being replaced with each backup, I don’t recall anyone mentioning that by implication there would be no verification happening in those circumstances. Did I get that about right? Useful to know for sure when a manager or development team member asks. Bill Bill LeDrew bledrew@mac.com ORC Filemaker Support Wizards of the Coast
-
I'm moving my FX solutions from FMS11 to FMS12 and there are a few problems along the way. I'm finding that passing the current record number into the parameter '-recid' does not result in a successful edit. I get an error 101. Is there a change with Filemaker 12 in the name or syntax of the current record id? Gary
-
[FM Server 12.v05] Test web server (endpoint): Connection refused: connect
Joost Miltenburg posted a topic in FileMaker Server 12
LS, I am trying to enable Web Publishing tool in FileMaker Server 12.05 on a Windows 7 x64 with Java 7 (update 75) and IIS running (World Wide Web Publishing Service running normally) . but I am facing this wired error which I can't get rid of. Tried a lot of things I saw on the internet without any luck. I have attached a snap of the error as well. Any tips or ideas are highly appreciated it. -
My office has 3 Macs using 10.7 and 10.8, and FM 12, one is a laptop that does work locally and remotely, the others stay in the office. We currently pay $29 to have 2 DB's hosted on an internet based site. I would like to have about 6-8 DB's hosted, but I believe at that point it would be better to have them hosted locally. I know Pro will handle up to 5 connections so I've been avoiding buying Server. The DB's are quite small, one is 33 MB, and the others are of a trivial size, used for printing forms and labels, and keeping checkbooks. I would like to be able to access all of them from inside and outside the office without having to pay a hosting company a lot of money each month. I suppose I could host them on one secretary's computer, which is quite lightly used, or buy a Mac Mini as a dedicated host to run a copy of FM or FM Server to host it on. What does the jury say? Thank you.
-
Hi all - (not sure if this is a "server" question or a "scripting" question - apologies if I'm in the wrong forum) We have FMP Server 12 hosing 50 files or so on an OSX ethernet. We typically open remote files from a small "control" panel on users machines firing an "openfile" script to bring up the right db. All is well except just recently ONE file won't respond to the OpenFile script command - all the others work fine. I can open the file manually via the "Open Remote" menu command - it's right there in the list of hosted files. Can someone throw me a bone? What might I be missing? Cheers, Jeff in VA
-
mac | pc open record when server script exceeds it's time limit
dansmith65 posted a topic in FileMaker Server 12
I brought this question up in Friday night chat: What happens to a new and open/uncommitted record when a server side script exceeds it's time limit? To clarify: I'm referring to a script that is configured to run with a specified time limit, as defined in the Server Admin Console. And to be specific: I have a script that creates thousands of records in a single transaction. It creates the records in a portal and does not commit until the end of the script. When I validated the primary key as unique for the table that just had thousands of records created, it could take ~30 minutes to complete the commit record step. Since the script was only allowed to run for 30 min, when it went over the time limit the server canceled the script and as far as I can tell, committed the record, saving part of those thousands of records previously created, but not all of them. I have not definitively proved this is what happened, but this is my suspicion at this point. -
mac | pc Filemaker.php Class 'FileMaker_Command_Find' not found in
Dudematters posted a topic in FileMaker Server 12
We run a webserver in a datacenter based on CentOS Linux. We have our website running on that server. For the client portal we use a connection to our local Filemaker 12 Server via FM_API_for_PHP_Standalone.zip. We have a good connection (tested with fmi-test sample database) to out local server. So that works. We have run the filemaker php code for many years on the local server with no problems. Now I've moved the php code to the webserver and installed and configured FM_API_for_PHP_Standalone.zip correct (php date and php curl modules installed, path updated, etc). As said, the fmi-test sample runs correct on our webserver to the fms12 server. My code generates errors, after logging in, and I cannot find what causes these errors. Fatal error: Class 'FileMaker_Command_Find' not found in /home/admin/FileMaker/FileMaker/Implementation/FileMakerImpl.php on line 122 My gut feeling tells me this is something simple, but what? Can someone help me out here? Thanks in advance. -
Running Server Advanced 12.0.5.551 on Mac Server 10.8.5 Started having an issue last week when the web servers certificate was replaced. Now the PHP publishing just does not connect (for the Test Page I get an XML error: not well-formed (invalid token) The IWP sample DB works perfectly, however ever other IWP DB does not open and gives a FM Web Publishing - - wpc1 Error: 500 "/fmi/iwp/cgi?-authinfo" 500 10356 I'm assuming that these are related. Do I need to reinstall FMS or is there a setting that I'm missing somewhere?
-
mac | pc FMSA 12 and PHP: 'hostspec' defined = failed CWP?
Justin Close posted a topic in FileMaker Server 12
We have a (fortunately) backup server we are trying to bring up and we testing our PHP/CWP solutions on it as the last step. Up to this point, everything seemed to be working fine: all the canned server tests (well, IWP and CWP) had worked OK; a couple of add-ons appeared to be working fine; client access was good; custom IWP solutions were good. Then we ran into a problem with the CWP solutions that we have. We have a login system where you start at an Index page, it reroutes you Login if you aren't logged in. The initial redirection and showing of the login page works OK. But when you log in, it apparently fails to authenticate you and just returns error: "XML error: Not well-formed (invalid token) at line 1" (or something like that). The failed login attempt doesn't show up in the FMS logs, either. So it is almost as if it isn't even contacting the server. These CWP pages are working fine under the live server (thankfully), which is configured very similarly: Windows 2008 R2 FMSA 12.05 SSL two plugins that run as tomcat processes IIS 7.5 (using URL re-write for HTTPS redirection) We have even had them running on an OSX based server without problems. I think that I discovered the apparent cause of the CWP problems, at least, but I would like to know WHY, and how to fix it if someone knows: I had to remove the 'hostspec' definition from the dbaccess.php file we use. remove the 'hostspec' definition from "dbaccess.php" = works define 'hostspec' in "dbaccess.php" = fails remove the 'hostspec' definition from "dbaccess.php" = works I found this because the canned FMS CWP test does not use a 'hostspec' definition. I suspect that it may have something to do with the php.ini or various other FMS configuration files around there. You see, we didn't have SSL installed at first, but installed it after FMS was setup. So during the installation of SSL, I have previously discovered that there are a few files you have to manually adjust (I posted about them here), even if you do a redeployment. But, it could also be because of some IIS redirection issue, it seems. Any ideas? Thanks, Justin -
mac | pc FileMaker 12 Sever with FileMaker Pro 11 clients: will it work?
Ralph Schwegler posted a topic in FileMaker Server 12
Hello A customer of mine runs a mainly Windows environment. They have troubles with Java to log in the admin console. The Windows (Server and clients) supporter has not the time to update the server and the clients at the moment (the licences are available). He thinks, updating the server in a first time and run the solution with FileMaker Pro 11 clients could do the trick for the moment. Will that work? Should I ask him to give updating to 11v5 Server one more chance? Thank you for your feedback -
Hi Guys, We currently have a FileMaker Server instanace running, it already has PHP web publishing running. I'm just wondering is it as simple as ticking enable XML web publishing for it to be up and running or have I got to restart the server?? Thanks
