Jump to content

Eric Kelly

  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Eric Kelly

  • Rank
  1. Eric Kelly

    FM Developer Oakland CA

    Position filled.
  2. Eric Kelly

    FM 6 Win2003 Terminal Services freqnt disconnects?

    Actually we're using version 5.5 of server and 6 of Filemaker, and yes, the FM Server is on a separate computer from the terminal server machine.
  3. We are still ironing out the bugs in our new terminal server, and I'm trying to figure out why we get frequent disconnects (as often as once every two minutes). This is not a common bug with FM 6 and terminal services, is it? Thanks, Eric
  4. Eric Kelly

    Copy bug in FM 6 over Win2003 Terminal Server

    OK, scratch that previous post. In fact, sometimes the routine never works, so the loop above just goes on endlessly. A much better solution is: Enter find Mode [] Set Field ["User ID#", "gID Current User"] Perform Find [Replace Found Set] In other words, use Set Field instead of copy/paste -- which normally I always do, except I had been laboring under the misconception that setting a field using a global didn't work when in find mode. The problem was that I was trying to set a field from a global that was a different *type* of field. Unfortunately, I still have several scripts where I have to do this, involving date fields. I guess I'll use a loop script like in my previous example, but include a counter that exits after 20 passes and tell the user to try again.
  5. Eric Kelly

    Copy bug in FM 6 over Win2003 Terminal Server

    Good to know the problem is not just unique to our setup. I *think* I may have found a workaround. Because the problem is intermittant, creating a loop seems to work: Loop Enter Browse Mode [] Copy [select, "gID Current User"] Enter Find Mode [] Paste [select, No style, "User ID#"] Exit Loop If ["IsEmpty(User ID#)=0"] End Loop Perform Find [Replace Found Set] Running this little test script, I can sometimes see the screen blinking repeatedly as it cycles several times, but so far it has always eventually been successful at copying and pasting. The other thing I haven't tried yet, and need to wait till the weekend, is to update FM Server 5.5 from v2 to v4, though from the fix list it doesn't look like this will change anything relevant to our operation. One other issue which I'm not sure if it is with our terminal server setup or if it is a FM bug is that we keep dropping the connection, sometimes as often as every minute or two, and other times not at all during a 2+ hour session.
  6. We have FM Server 5.5 running on a G4, accessed by FM 6 clients on OS X 10.3 and XP. We just installed a terminal server running Windows Server 2003. In testing out our rather complex database solution over terminal services, I encountered one print script that is supposed to only select records for the current user and print them. Instead, it prints every user's records. I narrowed down the failure to the following script steps: Copy [select, "gID Current User"] <-- this is a global field Enter Find Mode [] Paste [select, No style, "User ID"] <-- this is a number field What fails (apparently randomly) is that the copy step fails to copy the global field, even though the global field is right there on the layout. This happens about once every 2-10 times the script is executed, and it only happens when using terminal services. Once it has happened, running the above mini-script fails unless I go into browse mode and start over. I have tried inserting pauses into the script, telling it to go into browse mode before copying, turning error capture on and off, and nothing has worked. Two questions: Is there any known fix for this? If not, can anybody think of a workaround? I need to set the number field to the value of the global field while in find mode somehow. Thanks,
  7. Glory halleluiah! Thanks so much. I knew it could be done, I just couldn't wrap my brain around it. In your debt, Eric
  8. I previously posted a question about this, but for some reason the thread seems to have disappeared. Here goes again, and I'm attaching a couple of generic sample files. If anyone can solve this one for me, I will reward them with...well, glory and praise. It seems to me like it should be incredibly simple, but I just can't solve it. In my two stripped down sample files, Clients.fp5 and Services.fp5, I've got 10 clients entered in Clients, with unique IDs. Services references these clients by ID, but some clients have different funding over time; in other words, client #1 may have three services paid for by Medi-Cal but then switches to Self Pay. The report (set up in Services with a script) needs to summarize how many services were provided for each pay source, and then how many discrete clients fell under each pay source. In my example, the correct numbers of discrete clients for each pay source should be: Insurance 6, Medi-Cal 4, Self Pay 5. Riley Waugh responded to my original post with a general suggestion to get the data via finds or relational portals from the Clients file. I keep thinking there must be a simpler way. Anyone up for this challenge? Example.zip
  9. Thanks, Riley. You are basically suggesting that I automate what I ended up having to do manually. While this would work, it bothers me that it seems like it wouldn't be very flexible. The way I'm envisioning it, I would have to predefine the funding source categories from the Service file in my find operation in the Clients file, so that whenever we added a new funding source, I'd have to reprogram the find scripts. I'm sure there's a more elegant solution, I'm just not coming up with it yet. Eric
  10. Eric Kelly

    How to Access FM Server on Web?

    I am hugely grateful to all who have posted, particularly Bob Kundinger. This is a terrific forum. Your info has greatly increased my understanding of the issues involved in our project. As it turns out, security is VERY important, while "branding" or prettiness isn't -- the main function of this system would be to allow psychotherapists to enter their confidential client notes from remote locations, rather than having to come back to the clinic to do it, and also to allow supervisors to review notes, and administrators to review productivity stats. If I understand the advice above correctly, we should go with some sort of third party application to interface with the FM database, rather than use either of FM's built-in tools, because of security concerns. We are a non-profit, so cost is a big issue; also, the database tends to be a bit sluggish as it is, so speediness would be a consideration in whatever tool we used. Given this extra info, would people care to recommend any particular third party tool (Lasso, PHP, etc.)? Thanks, Eric
  11. Eric Kelly

    How to Access FM Server on Web?

    Thanks so much for your helpful reply. I didn't realize that you could run FM Server and FM Unlimited on the same set of files simultaneously. There are potentially quite a few remote users who would wish to access files, so I don't think that purchasing extra FMPro licenses for everyone will be very practical. I am curious about one comment you made -- I thought FM Unlimited essentially could serve files directly to the web with layouts and formatting intact, but your comment sounds like there would be a lot of extra work involved in tailoring the solution to the web. I have never tapped the web features of FMPro, so have no idea what is involved. Thanks, Eric
  12. This may be a hopelessly ignorant question, but I'll ask anyway. We have a number of files running on our OS X network, hosted by FM Server 5.5. It now looks like we will need to provide remote access to these files via the Web, but still have them served inhouse by FM Server. I see how one can serve files on the web using FM Unlimited, but what about Server? Do we need to purchase some special additional CGI? Thanks, Eric

Important Information

By using this site, you agree to our Terms of Use.