Cardiofuse

No I noticed mine does the same thing along with some other irritating field entry problems different than the desktop.

I designed a a FM12 solution that has two fields. The first is a "pull-down" menu that looks up a value list. The second is a repeating field that based on which item you select from above will generate a pull down list of values to select. For some reason, just on the iPad (not the desktop version), when it enters the second field it "selects all" of the contents and allows you to cut/copy/paste. This occurs whenever you re-enter the field. It's just a bit annoying seeing the text get highlighted each time and takes another "point with the finger" to deselect it. Any cures to this? Rick.

Steven, Thank you. I am using the latest version of FM Server for all of our client connections. Is this feature on by default or are there particular settings I need to attend to? Thanks for clearing that up! Rickk.

Is anyone using a VPN connection to allow multiple users to connect to Filemaker Server? Our hospital IT department was thinking this was a more secure approach. I'm not familiar with VPN connection (most of our clients connect from PC's) to our Mac Server.

The Let() seems to work fine alone as....... Let ( [ TheText=GetAsText(Time OnCPBP#2); Reformat=(PatternCount(TheText;":")=0); RawNumber=GetAsNumber(TheText) ]; Case(Reformat; Time(Div(RawNumber;100); Mod(RawNumber;100) ;0); Time OnCPBP#2)) ....this allows me to manually enter a 4 digit number and it will place the colon in to create a military time. For some reason, I can't seem to auto enter the Time, when the Event field="On CPBP#2" ....I can do this separately without the Let function but I can't get them to work together.

Thank you; that was a pathway I did not think of. I entered it as: Case(Get ( ActiveFieldName ) = "Time OnCPBP#2"; Let ( [ TheText=GetAsText(Time OnCPBP#2); Reformat=(PatternCount(TheText;":")=0); RawNumber=GetAsNumber(TheText) ]; Case(Reformat; Time(Div(RawNumber;100); Mod(RawNumber;100) ;0); Time OnCPBP#2); Event = "On CPBP #2"; Get ( CurrentTime ); Time OnCPBP#2) .....and I get the usual error message "There are too many parameters in this function" Any thoughts. I have used the actual field names here. Thanks for the effort

I have a time field (Time OnCPBP) in which I can set a script to enter the current time; however when I want to enter the military time manually, I use the Auto-Enter Calculated value specified as: Let ( [ TheText=GetAsText(Time OnCPBP); Reformat=(PatternCount(TheText;":")=0); RawNumber=GetAsNumber(TheText) ]; Case(Reformat; Time(Div(RawNumber;100); Mod(RawNumber;100) ;0); Time OnCPBP)) This lets me enter the four digits and it inserts the semi-colon for me (much easier) for my users.... Problem: I have another time field (On CPBP #2) in which the calculated value is specified as: If (Event = "On CPBP #2"; Time), so whenever the "Event" field is "On CPBP #2) the time gets entered automatically. The caveat is, I would also like to enter the 4-digit method manually and format as above but I'm having trouble combining the two calculations. Any thoughts, not sure why this stumped me. I thought something like: If (Event = "On CPBP #2"; Time) + Let ( [ TheText=GetAsText(Time OnCPBP #2); Reformat=(PatternCount(TheText;":")=0); RawNumber=GetAsNumber(TheText) ]; Case(Reformat; Time(Div(RawNumber;100); Mod(RawNumber;100) ;0); Time OnCPBP #2)) I guess my basic problem is how to "nest" these two formula together. Each works separately but I need them both in this field. Thanks to anyone!

I currently host 15 Filemaker 9 Dbs on a dedicated iMac (new). Would I benefit from speed or anything else if I bought a Mac Server X machine runing Leopard Server software? Not sure if this gets me any more speed with Filemaker?

I hope this is not a lame question. Does port 5003 have to be open on the "client's" network (I know it has to be open on the server hosting network forwarded to the server machine). I have a remote client that can't see our databases from the open remote command. The other 11 clients can see them. THANKS!!!

I'm being asked by my IT person (trying to connect a client from a VA hospital to our hosted database) What fields are being passed across the internet connection and what encryption we are using....? How would I respond; I'm trying to convince him to open port 5003 at the hospital to connect to our server machine at our office. Isn't it true that port 5003 has to be open at "both ends" (client and host)?

My external backups to firewire (La Cie) and to the resident hard-drive (Library/Data/Backups) seems to be working fine. I first created a folder (Name Backups) and used the "get info" command to assure the folder has the correct permissions (namely that the group-fmadmins has read and write priviliges). I next changed the default backup folder to "point" to this folder. I then created two schedules; the first to use this new backup folder to backup daily at 8pm. I then created a second schedule to backup to the internal hard drive daily at 6pm. If you would like more detailed instruction; I would be happy to provide you with the written steps. You may have to restart a time or two to make the new priviliges "stick" as mentioned above. Good luck!

That would be incredibly helpful to see the example. My present work around (trial and error) was to change the default backup folder to "filemac:/La Cie Name/Server 8 Backup/" and then set up a schedule to backup at a certain time using this new "default" folder. I then set up a second schedule to "backup" to the original location of the old "default" folder. Don't ask me why this doesn't work the other way around but this allows me to backup both the the Data/Backup folder on the server's Library folder and also to an external drive (important if the Server "dies"). Hope this helps and THANKS (cardiofuse@mac.com)...

Has anyone figured out how to backup to an attached firewire drive (La Cie)? The filepath is valid (filemac:/LaCie d2 117 GB/Server 8 CQI Backups/) but no scheduled backup occurs. I have changed the group privileges to the La Cie to read and write for fmsadmin. (Do I need to change the ownership to fmserver?). My default folder backups are fine. I used to do this in Sever5.5v4. Any suggestions are greatly appreciated.

I tried to run a sample database(s) on my server 5.5 machine and it will not run both 5.5 and Server 8 at the same time. I can turn either on but when one is running the other will not start! Darn..........

Does anyone know how to export (via Scriptmaker) the layout fields into an existing Excel file. Whenever I export to the filepath of an existing file it overwrites the file. I'd like to have a "Sheet2" which will have preformatted charts so when I import (from FM8-via export to excel) the data I can see the graphs updated. Thank you anyone.....stumped.

I'd like to export selected fields from a FM8 database layout into an Excel spreedsheet. I can get the data to export to "Sheet1" but whenever I export to the target file it "rewrites" the sheet. My goal is to have a second sheet (Sheet2-already in the target file) to automate drawing graphs from the exportd data in Sheet1. Whenever I run the script it erases the second Sheet2 from the file and therefore I can not automate the graph drawing function. Does anyone know how to perform this task? Thank you. Rick Panama City, Fl.

Thank you for the great info. The literal error posted is: File has been forcfully disconnected by the h ost. All affected windows will be closed. [From Administrator:"Closing all files"]

Does anyone know if the demo version (trial) has a built in timeout. After X hours the server stops without my command. I'm testing the demo version and want to make sure this does not happen in the real version. Thanks everyone.

Well the answer to my problem is that the 5003 port was open on the original server machine but not on the demo FMS7 machine. I had to go back and open 5003 on the "specific" local computer (10.0.1.x). That fixed the problem. Thanks for all who hung in there but trial and error won another round. I hope this helps someone. I've been using this configuration for 3 years now with FMP6 and FMS5.5 and it has worked flawlessly behind the NAT configuration...maybe they should support it....or at least recommend a fix to this common setup.

You're right! Since the demo server installer was loaded on a different machine in the local network, I had to open the 5003 port to the specific machine (10.0.1.x). The wrong machine had the right port privileges.....good catch.

Does anyone use FM7 and FMP8 to access hosted databases from a non-local machine. I currently have Server 5.5 running on a remote machine in the office (IP address=68.59.xxx.xxx). The set up is for Macs connected via a Linksys router hub (I use an iMac as a "server" dedicated machine). Everything works fine. I installed Server version 7 on a machine connected to the network and "hosted" several FM8 files. I can "see" the hosted databases on the local address (file/open remote/ip=192.168.x.x) and this works fine. Here's the problem, unlike FMS 5.5 when I try to use the main IP address (68.59.xxx.xxx) I cannot see any of the files! When I leave the office and try to access the file from FM8 via the internet by adding a favorite host (IP=68.59.xxx.xxx) I cannot see any of the files. Any suggestions why I cannot view these files outside the office; afterall that is the point of hosted files. THANK YOU!

Can anyone tell me why I can see my hosted databases locally but not outside the office network via TCP/IP If I try to connect via open romote/favorite server and type in the machines IP address (68.59.xxx.xxx) I do not see any of the files. I can see them all on the local host (192.198.x.x) and FM Server 5.5 works great. I'd like to upgrade but I can't seem to get the demo to work. THANKS ANYONE!

Thank you for the clarification. I currently have Server 5.5 running on a remote machine in the office (IP address=68.59.xxx.xxx). The set up is for Macs connected via a Linksys router hub (I use an iMac as a "server" dedicated machine). I installed Server version 7 on a machine connected to the network and "hosted" several FM8 files. I can "see" the hosted databases on the local address (file/open remote/ip=192.168.x.x) and this works fine. Here's the problem, unlike FMS 5.5 when I try to use the main IP address (68.59.xxx.xxx) I cannot see any of the files! When I leave the office and try to access the file from FM8 via the internet by adding a favorite host (IP=68.59.xxx.xxx) I cannot see any of the files. Any suggestions why I cannot view these files outside the office; afterall that is the point of hosted files. THANK YOU!

I noticed on the demo when I choose connect to server the local host comes up with 127.0.0.1 instead of my local IP address...Why is this?

I'm using Server 5.5 now (probably going to upgrade to version 7). I'm using a standard iMac as a server for 12 hospital databases. They have to select open remote and select the IP address of the server machine behind a router. They enter (unless you have it permanently entered it into specify host) the IP address of the known server machine (68.59.xxx.xxx) not the LAN IP address (192.168.xx.xx). I hope this helps. I'm not sure how this works in version 7 (I'm assuming you enter the IP in the favorite host pulldown).