jamesrockford

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.

I have a form letter that I frequently send. Presently, I click a button on Filemaker and it opens the form letter. Then I have to manually put in the address and client information. I believe this process could be automated, as it is also stored on Filemaker. I don't want to do a "merge" and would rather accomplish this with applescript. The reason for this is because I don't want to have to do a "search" to limit my records, rather I want to just be "inside" that particular record - click the associated button I have that opens the document in word, and have it "find and replace". I have tried this: set thematter to cell "Mattername" tell application "Microsoft Word" set findRange to find object of selection tell findRange execute find find text "Matter" replace with thematter replace replace all end tell end tell Yet this has two problems: 1. It doesn't pull the data from the current record. It just pulls the data from "a" record. 2. It doesn't work with linked table records. For example, I have two tables. One that lists all the cases and one that lists all the clients. A client can have multiple cases, but a case only one client. The "current record" that I would be performing this task from would be in a case record. The problem with the above mechanism is that it does not seem to work when I attempt to grab client data itself. Any suggestions that can solve these issues?

I have a script of sorts, where I can add "tags" to a record, for ease of searching. The difficulty I am having is when it comes to deleting those tags. Here is my delete script: Set Variable [$TAG; Value:CaseLaw::CaseLaw_ShowTag] Freeze Window Go to Layout ["Tags" (Tags)] Enter Find Mode [] Set Field [Tags::Tags_Tag; $TAG] Perform Find [] Delete Record/Request [No dialog] Enter Browse Mode [] Go to Layout ["CaseLaw" (CaseLaw)] Set Field [CaseLaw::CaseLaw_ShowTag; ""] Go to Field [CaseLaw::CaseLaw_ShowTag] Refresh Window The problem is, lets say I have a tag that is: "criminal negligence" and then another that is simply "criminal". Let's say I want to delete the criminal tag. So I select the "criminal" tag and then run the delete script. It will INSTEAD delete the "criminal negligence" tag. What am I doing wrong that it does this? I also have a similar difficulty when I am adding the tag, in that I have it check for duplications. If I try adding "criminal negligence" first then adding a "criminal" tag second, it will say it's already been added. My script is below: Set Variable [$TAG; Value:CaseLaw::CaseLaw_ShowTag] Freeze Window Go to Layout ["Tags" (Tags)] Enter Find Mode [] Set Field [Tags::Tags_Tag; $TAG] Perform Find [] If [Get (FoundCount) ≠0] Show Custom Dialog ["NOTICE";"this has been entered before, etc"] Else New Record/Request Set Field [Tags::Tags_Tag; $TAG] End If It is driving me rather mad, I simply can't figure out what I have done wrong.

The script I use to open PDF and Word documents on a Mac and PC does not seem to work on the ipad or iphone. It simply says it cannot find the container. They are externally stored with the secured setting. Is there a better mechanism for this? Presently I have: Set Variable [$path; Value:Get (Temporary Path)] Set Variable [#filename; Value:Middle (GetAsText(Authorities::authorities_pdf) ; Position (GetAsText(Authorities::authorities_pdf): "/" ; 1 ; PatternCount (GetAsText(Authorities::authorities_pdf); "/")) +1 ; 1000...] Set Variable [$final_path; Value:$path & $filename] Export Field Contents [Authorities:authorities_pdf; "$final_path"; Automatically open] Now, the above does work when I connect with a PC or mac, but seems to fail on Go. What am I doing wrong? Perhaps everything!

Is there a way to tell whether the database has EAR? Originally I had encrypted the database, using the developer tools; however, things seemed slow on an already slow server, so I attempted to de-encrypt it. Things were never quite successful at that stage, according to the log. It would receive an "error". I'm wondering, now, as to whether it was ever properly encrypted. Originally it would ask me for an encryption password, but it no longer does that. Is there a way to tell?

Having a bit of difficulty getting my head around this, appreciate any assistance, suggestions or guidance. I am making multiple calculations, as various fields have different deadlines, so this is not an "all in one" solution. I have 2 types of deadlines I am having difficulty with. Then I have one weird anomaly situation, that maybe I will be able to easily resolve once I have a solution for the first 2. Some deadlines are based on years. So "2 years" from X date or "6 years" from X date (inclusive, so the first day count). Other deadlines are based on months, so "6 months" from X date or "3 months" from X date (inclusive, so first day counts). I have leap year concerns. --- Essentially, what I have is 2 dates: A "Start Date" and an "End Date". I want to create a calculation that tells me three things... 1) How many years have passed. 2) Has it went beyond 2 years? 3) If it has not went beyond 2 years, how many DAYS are left until it hits the 2 year mark? Example: 21/10/2012 to 21/10/2014 would be one day over the 2 year mark. The 2 year mark, for purposes of my calculation, would be 20/10/2014. 21/10/2012 to 1/10/2013 would say that 0 years have passed, it has not went beyond 2 years and there are 384 days remaining. I also have this same issue, as sometimes I have month deadlines. So same thing. A "Start Date" and an "End Date" 1) How many months have passed. 2) Has it went beyond 6 months? 3) if it has not went beyond 6 months, how many days are left until it hits the 6 month mark? Example: 21/10/2012 to 21/04/2013 would be past the six month mark. The six month mark, for purposes of my calculation, would be 20/04/13. --- I also have this odd situation with one type of deadline. There is a Start Date and a Pause Date; however, there is also a "Resume Date" and "End Date". In this instance, there is a 2 year deadline; however, the clock stops ticking on the "pause date". The clock does not start ticking again until SIX MONTHS AFTER the resume date. On balance, the difference between the start date and end date cannot be 2 years or more, with consideration given to the pause and then the six months added time. 1) How many months have passed that COUNT. 2) Has it went beyond 2 years, with consideration to the pause and then the six months on resume? 3) if it has not went beyond, how many days were remaining. Example Start Date: 21/10/2012 Pause Date: 20/10/2013. Resume Date: 21/10/2014 End Date: 20/11/2015 This would show that there were 19 months that passed, it did not go beyond 2 years, and that there were 5 months remaining (calculated into appropriate days). --- This is how I handled "days"...it's probably hacky, but I'm still learning this and maybe it will show what I'm trying to achieve: If (Cases_SOL_EndDate - Cases_SOL_StartDate +1 > 42; Cases_SOL_EndDate - Cases_SOL_StartDate +1 & " Days - Out of Time"; If ( Cases_SOL_EndDate - Cases_SOL_StartDate +1 <2 ; Cases_SOL_EndDate - Cases_SOL_StartDate +1 & " Day - In Time" & " - " & 42 - ( Cases_SOL_EndDate - Cases_SOL_StartDate +1) & " Days Remaining"; If (42 - (Cases_SOL_EndDate - Cases_SOL_StartDate +1) = 1; "41 Days - In Time - 1 Day Remaining"; Cases_SOL_EndDate - Cases_SOL_StartDate +1 & " Days - In Time" & " - " & 42 - ( Cases_SOL_EndDate - Cases_SOL_StartDate +1) & " Days Remaining"))) In the above scenario, there is a flat 42 day deadline and this is how I approached it. I am having a bit of difficulty with deadlines that are determinable by months or years.