Search the Community
Showing results for tags 'fms12'.
Found 96 results
-
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
-
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
-
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.
-
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. Â Â
-
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.
-
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
-
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
-
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
-
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? -
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 -
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
-
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 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. -
[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. -
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! -
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
-
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
-
Today I found some clients has signed in multiple times to the server. Which caused a major problem like other users/client unable to access the file. So I needed to restarted the server. Then the problem fixed. I guess due to multiple signed in for some clients, this problem occurred. So can anyone please help me, why multiple signed in for some users happens? And is it related to server version? My current server version is 12.0.4.405 Thanks
-
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.
-
mac Script for Only Viewing Documents Created by Current User
ValMartinez8 posted a topic in FileMaker Server 12
We have 80+ iPads using the FileMakerGo app. I've created a table that includes three different layouts. All layouts include the field Employee Name. Employee name = Get(AccountName) I've also created a Privilege Set for users that limits the records they see to records created by their user name. Custom Record Privileges -> View -> Specify Calculation -> EmployeeName=Get(AccountName) Now the user is only able to see data created by their user account and all other documents still show but they have <No Access> in all editable fields. I want users to only have to scroll through their own, viewable, documents. In order to do this I believe I have to write a script. This script should only pull up documents created by the current user. I've spent hours trying to get this done with little progress. Any suggestions? Val -
I've been having a problem with FMS 12 backup schedules for the last few days, and it's giving an error code - 20411 - that I haven't been able to find documentation on. I currently have Hourly, Daily, and Weekly schedules running; Hourly to an internal drive, Daily and Weekly to an external USB drive. The problem is occurring with all three backup schedules, so I'm inclined to think it's not a problem with either a specific schedule, or with the backup destination. The database is hosted on a RAID 1 mirrored drive, and one of the drives recently failed; however, that doesn't seem to have affected the operation of the main database. Essentially, the backup starts, gets partway through, and then aborts. I get the following sequence of error messages: "Backup aborted by user or due to error; some incomplete files may be left in destination (20411)" "Schedule "Hourly" aborted; unexpected error. (20411)" Looking at the backup destination folder, it appears to have copied all but the last two .fmp12 files successfully; those two files exist in the destination, but only as 12KB placeholders. One thing about those two files that is different is that both use external container storage, while the other files do not; I'm not sure if that makes a difference. I've tried stopping and re-starting the FMS service, and also tried rebooting the entire machine, with no success. The machine is Windows Server 2008 R2 Standard, running on a Dell R610 server with 12 GB of RAM. Anyone know first, what error 20411 is; and second, anyone have any idea what the underlying problem might be? Many thanks!
-
mac | pc Strange Found Set of Records. Possible DB Corruption?
James Gill posted a topic in FileMaker Server 12
I've never seen anything like this, but as I was troubleshoot an unrelated issue, I happened upon a table of records that contained the following errors. (See attachment) I've already run a verification check on the file and is passed, so I'm at a loss as to what would cause this. Should I be concerned? Screen Shot 2014-02-24 at 1.54.16 PM.pdf -
mac | pc More than one login instances from same IP address and same client device
swarups posted a topic in FileMaker Server 12
I found a strange behavior with FileMaker 12 Server Adv. Since some days, I notice there are more than one login instances from same IP address and same client device. But FM server supposed to restrict the access when a duplicate connection occurs. Can any one please help me why this issue is occurring. Thanks in Advance:) -
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
-
Hi there, I'm getting back into details of FMP Server and wanted to ask for some advice about recommended methods for tweaking hosted files. We've had our FMP system that has run like a clock since version 5-something. We tweaked it a bit with the big change at version 7, as I recall. But then again we haven't had to touch it. Sweet. But now the time has come - our company and practices have evolved and so must our FMP databases. Not in a big way - need to tweak layouts and scripts a bit. Maybe change some container fields. We host FMPS 12 on a dedicated iMac. I'm looking for the easiest and quickest way to access my database files from a remote computer. I can't work from the server machine directly - but I do have ARD access. I can't find any recommendations in the server documentation or the admin guide. If I've missed something obvious please point me in the right direction. Thanks so much, Jeff in VA
