
tbfilemaker
Members-
Posts
34 -
Joined
-
Last visited
Everything posted by tbfilemaker
-
We converted our previous FileMaker 6 databases to FileMaker 11 and are running them on FileMaker Server 11 Advanced with no known issues.
-
Thanks for the information, in the past FileMaker would specifically list this limitation, it was not that obvious with the release of FileMaker Server 11 Advanced. Thanks again for your help, much appreciated.
-
Can someone help me understand the maximum number of FileMaker files Server 11 Advanced can host simultaneously? The FileMaker site advertises the following, does this mean FMSA11 now can host "unlimited" files per HW constraints? "NEW! FileMaker Server 11 Advanced does not limit the number of FileMaker Pro clients. Connections are limited only by your hardware and operating system." Thanks in advance, much appreciated.
-
If User Name is > 20 character then...
tbfilemaker replied to tbfilemaker's topic in Script Workspace and Script Triggers
Fitch- Thanks for the pointer, a variation of that function worked like a charm. Here is my final script: Set Field ["filemaker user name","Status(CurrentUserName)"] If ["Length (filemaker user name) > 20"] Show Message ["Invlaid User Name, please change..."] Else Open ["Database.fp5 (*)"] Thanks for all of your suggestions, it is really appreaciated. -
Problem: I am attempting to create a work around for not allowing users onto a server if they have a "User Name" setting in the Preferences > Application greater than 20 characters. It turns out that some individuals have long user names which is crashing our FileMaker Server 5.5 application. Proposed Solution: Create a jump script within FileMaker Pro 6 to place on the client machines with the following: If User Name is > 20 characters then show message, "Please see your local Administrator to reconfigure your User Name." Else Go to file on server. Note: it would be ideal if one file worked for all users. Any insight or any ideas on how to accomplish this would be greatly apprecaited. Thank you kindly.
-
Stanley, thank you kindly for the insight, I will be sure apply these lesson learned. On a good note, we located the problem. It turns out that during our Domain migration activities, the Macintosh account names were changed to a long text string of information resulting in 50+ plus characters. This also affected the User Names in the FileMaker Pro clients. By using the "Custom Name" and shortening the name, the FileMaker Server no longer crashes. This was an extensice trouble shooting activity, we literally tried everything, and it seeems that it boiled down to this solution. Again, thanks for your insight and great list of best practices, it really is appreciated a great deal.
-
Fellow FileMakers, I host 85 mission critical FileMaker 6 files via FileMaker Server 5.5.2, unfortunately, the FileMaker 5.5 Server continues to crash on our Apple Xserve running 10.4.11 Server with the following errors: --- Date/Time: 2010-01-26 16:35:42.824 -0800 OS Version: 10.4.11 (Build 8S169) Report Version: 4 Command: fmserverd Path: fmserverd Parent: launchd [1] Version: : ( PID: 279 Thread: 18 Exception: EXC_BAD_ACCESS (0x0001) Codes: KERN_INVALID_ADDRESS (0x0001) at 0x6563686e --- I have tried the following on the Apple Xserve 10.4.11: -Updating FileMaker Server to 5.5.4 -Re-seating the memory -Performed the "Recover..." command on all of the files -Recovered the files from our backup from the known function set of files Next: I attempted to load FileMaker Server 5.5 on XP Pro 5.1.2600. Unfortunately the Server crashed on this system as well! Does anyone have any pointers or ideas on what to try next? I realize I should upgrade the FM Server software, but for the time being, we really need to function with our current setup while we perform the upgrade. Any help would be greatly and dearly appreciated. Thank you kindly.
-
1,2,3. If not 3 then 2, If not 2 or 3, 1.
tbfilemaker replied to tbfilemaker's topic in Calculation Engine (Define Fields)
Fitch, that works perfect. Thank you all for your help. -
1,2,3. If not 3 then 2, If not 2 or 3, 1.
tbfilemaker replied to tbfilemaker's topic in Calculation Engine (Define Fields)
Greetings, I have three (Number) fields: Field1, Field2, Field3 that track Cost. I am looking for a calculation result that will take the ladder of these 3 arguments: If Field1 has a value,1 If Field2 has a value,2 If Field3 has a value,3 Meaning, if there is a value in field1, field1. If there is a value in field1 and field2, field2. I there is a value in field1,field2 and field3, field3. Note: If there is a value in field3, there will always be info in field1 and field2. If there is a value in field2, there will always be a value in field1. I apologize for posting a similar question last week, my requirements have changed. Thank you kindly. -
1,2,3. If not 3 then 2, If not 2 or 3, 1.
tbfilemaker replied to tbfilemaker's topic in Calculation Engine (Define Fields)
There will always be something in field2. There has to be something in field2 before field3 can occur. Thanks for the feedback, much appreciated, I will implement this into my system. Thanks again. -
D J, I am currently using FileMaker 6 since we have some older systems around that don't support FM9. Hence There is no "Else If" command. Your 1st example is exactly what I am looking for, the 2nd example does not work because I am pulling in different signature fields based on the Passcode entered. Are there any other work arounds that don't use the "Else If" command? Thanks for the feedback, I will be sure not to use numbers as field names in my examples. Thanks again.
-
Date notification email
tbfilemaker replied to ptcruiser's topic in Script Workspace and Script Triggers
It sounds like you want an e-mail triggered when a date is met. If so, your script would look like this: If = Send Mail [To: ""; Subject: "Renewal Due", message: "Please Renew". End If This will send an e-mail to a user when their renewal date is met. Other things to consider will be setting a flag to show that the e-mail was sent and also looping the script. In order to have this done automatically, you can use this Plug-In: http://www.worqsmart.com/s.nl/it.I/id.8/.f?sc=2&category=-102 or have the script triggered by an user event (i.e. a script that is used routinely). It all depends on your database client/server setup. Hope this helps. -
Essentially, I have one field that has more than one "passcode". If 1=1, 1. If 1=2, 2. If Neither, Show Message: "Incorrect Password" So far this is what I have, but it doesn't work as desired. ---- If 1=1, "Approved" Else Show Message: "Incorrect Password" End If If 1=2, "Approved" Else Show Message: "Incorrect Password" End If ---- Any tips would be greatly appreciated. Thank you kindly.
-
Thanks for all the suggestions here, I am now implementing this into my solution. Fitch, I am using 1,2 & 3 as flags in order to send the e-mail in the right sequence. I have John(1), Sue(2) and Kate(3). Sometimes only John(1) needs to sign and not the others (and so on). So I have 1,2 & 3 set based on the signatures required. Also, thanks for mentioning setting the flag for when the e-mail has already been sent, I implemented that and it is working great. Thanks for all your help.
-
I apologize, I forgot to mention there are three different Action Calc fields, sorry about that. They are set by the approver level. If John(1), Sue(2) and Kate(3) need to approve the PR, those 3 fields will get set to: Action Calc 1=1 Action Calc 2=2 Action Calc 3=3 Once the approver digitally signs the PR the Action Calc is set back to 0. I have this part figured out. Where I am running into trouble is in the script that triggers the e-mail. So what I am looking for is: If Action Calc 1 = 1, then send e-mail to John, if it is 0 move on to next step If Action Calc 2=2, then send e-mail to Sue, if it is 0 move on to next step If Action Calc 3=3, then send e-mail to Kate, if it is 0 exit script. I hope this clears things up, thanks for your patience and help, it is really appreciated.
-
Error -1071 and -1072 ???
tbfilemaker replied to tbfilemaker's topic in FileMaker Legacy fp3 and fp5
Solution: This was due to the machine going to sleep, we disabled the "Sleep" function. -
John(1), Sue(2) and Kate(3) need to be notified that a Purchase Request needs authorization. John must sign it first, then Sue and lastly Kate. If John(1) already singned, then Sue(2) needs to be notified and so on. I have a calculation that marks who needs to be notified next, I call it "Action Calc". I will be running this script every 30 minutes. I need a script that will notify the person next in line, but I can't quite get it to work. So far I have this: If ["Action Calc=1"] Send Mail ["Hi , please approve PR."] End If If ["Action Calc=2"] Send Mail ["Hi , please approve PR."] End If If ["Action Calc=3"] Send Mail ["Hi , please approve PR."] End If Currently this calculation e-mails John(1), Sue(2) and Kate(3). If my criteria is met I need it to only e-mail John. And then once John signs it, the script will run again and should e-mail Sue and so on. Any help would be greatly appreciated. Thanks in advance!
-
I have a Mac OS 10.4.10 Machine running FM 6 accessing files from a FM Server 5, every 15 minutes the file looses a connection and gives me this error: "Communication was lost with host... ... error -1072" Any ideas on how to fix this? Thank you kindly...
-
Get value on right side of decimal?
tbfilemaker replied to tbfilemaker's topic in Calculation Engine (Define Fields)
Thanks for the feedback, it turns out that there will only be two decimal values for my result so *100 will work just fine. Thanks again for this solution! -
Get value on right side of decimal?
tbfilemaker posted a topic in Calculation Engine (Define Fields)
Greetings, I need to get the values on the left and right side of a decimal. I have the left side figured out via the truncate function, however, how do I get the value on the right side of the decimal? Left Side Calc=Truncate(TOTAL_COST, 0) Ride Side Calc= Any help would be greatly appreicated. Thanks in advance! -
Export Date to Maintain Leading Zeros?
tbfilemaker replied to tbfilemaker's topic in Importing & Exporting
I am using Excel just to view the data. I have to break the date into into a total of 8 characters (i.e. 1/1/2006 = 20060101) in order for my ASCII file to work with the COBAL system I am importing into. I have to concatenate several fields into one text string equaling 2050 characters, so having all the spaces and zeros are critical. Everthing seems to be working good in regards to this issue. Thanks for all the feedback. -
Export Date to Maintain Leading Zeros?
tbfilemaker replied to tbfilemaker's topic in Importing & Exporting
"comment", I am trying to automate this export process to provide an output file for another system periodically, ideally I don't want to interact with Excel, currently I am only using Excel as a means of validating my data. Thanks for the quick responses. "comment", I used your calculation and read your link which helped explain the issue in more detail. It is clearly an issue with how Excel interprets the text file. Lessons Learned: When opening my FileMaker exported file as a text file it maintained the leading zeros. However, when opening with Excel it trims the zeros. By changing the import delimiter options in Excel when importing I was able to maintain the zeros. Thanks again for the help.