I am having trouble exporting records to FileMaker Server 7. I am trying to create a script that will export all records in a table from their personal file to a respective table in the server's file automatically for my users. I have been able to do the import script pretty easily. Either I'm to tired of doing this or there is no way to do the export side. Can anyone help?:

Thanks!

I'd try it in reverse. Trigger a script in the server file that will import the records from the personal file. That way you have control over what is going into your server file.

haha. well it ran me into one more problem. The users needing to do the export are exporting from several different locations. So they have dynamic IP's and the host is dynamic. The users also move around so they themselves spit out different IP's. How does the server side know where to grab the file for importing

As long as the file name on the client side is not changed, when you trigger an import on the server side and do not specify an IP address or location, the import will work.

In this situation, the client file will work the same as Globals - the import script is from the client's perspective - NOT the server's.

I use this scenario in a system that uploads (imports) records from about 40 clients all over the state to an external FM server, then is uploaded (imported) to the main [internal] file. The clients use all sorts of connections from LAN, WAN, CDPD, WLAN, Cellular data, dial-up, DSL, ADSL, Cable, and even one client using an 800mhz radio data connection.

It will work.

Just a word of warning - trap for any errors during the import in case of a lost connection to protect the data.

Thanks a bunch to both of you guys for helping me out!