ScottHaneda

I amusing FMP 5, or I should say my client is, and it will remain that way, so please direct all solutions with this in mind. I need to export a set of records and ftp them to a remote server. I found MondoMail would do this, but it has a problem, you can export once, and then ftp, and then MondoMail locks the exported file as in use by the hidden MondoMail Daemon. I am stuck at this point, the only way to get the MondoMail Daemon to die, is to reboot. This wont work. How can I take a scripted export from FMP and get it ftp'd to a remote server? Are there any other options other tham MondoMail, I tihnk it is a bug and I have a feeling I will not be able to get it fixed. I can not run Lasso or webcompanion for internal reasons. Any suggestions on how to approach this?

Hello, I have a field that is set to a value list, values are : A B C D E F I want a summary field that will tell me across all records, how many A's there are, B's etc. I can not seem to figure out how to do this one. thanks

I have a DB that has several thousand zip codes in at that lost a leading character...for example, 1568 should be 01568. Anyone know how I can insert a "0" in front of all of them?