Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About jjjjp

  • Rank

Profile Information

  • Title
    university instructor and program director
  • Industry
  • Gender

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version

Recent Profile Visitors

3,994 profile views
  1. Ah, great, that’s what I was hoping. Thanks again.
  2. We would all be part of the same organization (a faculty within a university), and the databases would be administered by the same IT staff, but, functionally, there would be no need to stop the databases at once. Both databases would be relatively small without many users at any one time, and the code is fairly stable and so wouldn't need to be updated frequently. If all users need to be kicked out at once, we can probably accommodate that, but it's worth knowing what the options are ahead of time. Thanks for the help, Ocean.
  3. From all open databases, not just mine?
  4. Thanks for the information about how to migrate data without the risk and hassle of importing. I will definitely consider switching. My main concern at the moment is how to avoid having to stop the databases on the server every time I want to update to a new version and thereby interfering with the smooth operation of any other independent databases running on the same server. Are you saying that I can run Data Migration Tool to update to a new version without having to stop all of the databases sharing the server?
  5. I may in the future be part of a shared database that would include two, possibly more, distinct databases, and I would like to have a better understanding of the limitations, if any. Currently, whenever I want to replace my database with an updated version, I stop the database, import the data into the new version, the replace the old version with the new one, and then restart the database. As part of a shared database, would I need to stop activity for all of the other databases on the server whenever I want to update mine? Or is there a way to replace my database without stopping the other
  6. Thanks. Your item 1 ("the server itself could be configured to not allow outgoing traffic on the SMTP ports") seems to me the most likely. By server, I assume you mean not FM Server but the department server on which FM Server resides. Since the current IT support is very short-staffed now, I am going to leave raising item 3 for the future unless it is a possible source of the failure.
  7. It appear, then, that the blanks fields for SMTP would not be causing the script step from within the scheduled FM script to fail. This is very helpful to have confirmed. So I am going to assume there is nothing in the way FileMaker Server is configured that could be causing the Send Mail command to fail. If there is in fact something else in that configuration that would lead to failure, please let me know? But it appears that the problem lies outside of FileMaker. Thanks.
  8. I am trying to figure out why I am getting error code 1502 (Connection refused by SMTP server) whenever I send emails from a scheduled server script using the script step Send Mail [ Send via SMTP Server; . . . ]. The acting IT person in my department doesn't know FileMaker, so I am trying to help, but I didn't set up FM Server in the first place and don't have the kind of access he does. I would very much appreciate help from the Forum. The problem first arose when FM Server had to be reinstalled after a ransomware attack several months ago. The error has remained since then. I am quite cert
  9. I'm on FM Server 16. I would have gone higher but wanted to save other users the trouble of upgrading their versions of Pro. 16 serves our needs well enough. Does anybody know how high I would need to go (17, 18, 19?) to lose the bug?
  10. I created a duplicate of a database with a few small changes that I introduced for testing purposes. The original database and the copy both have an account called automaticreminders on it. I saved the duplicate of the database on the server in the same folder as for the original, and then I duplicated the scheduled script as follows. Next, I tried to edit the schedule ExecuteDailyScripts Copy so that it would use the test version of the database rather than the original. But after changing the database and entering the account name and password, I get the following error:
  11. Thanks for that tip, Ocean. Scripting errors aside, is it bad coding practice to, e.g., make an action conditional on the occurrence of an error on opening a record? The term "scripting error" suggests it is.
  12. Is there a way to change my coding of scripts so that so-called scripting errors don't show up in server logs when a scheduled script is executed on FM Server? I get dozens of such errors for each daily execution, and Using a Set Error Capture [On] script step doesn't seem to make a difference as to whether the "errors" show up in the server log. The kinds of error codes that do show up (101, 401) don't seem to me to be be the result of scripting errors at all. Rather, they are part of ordinary operations (e.g., testing to see whether to stop looping by checking whether a record exists in a fo
  13. I host a database on my university computer to administer a series of group workshops for the undergraduate community in fall and early winter terms. Each morning at 7, FM Server executes a script to send out email reminders to all workshop leaders for their upcoming presentations; provide them with essential information about location; etc. We had a ransomware attack on my College's servers last winter. Fortunately, the attack happened after the workshop schedule was almost completed, but the emails stopped going out successfully after the College recovered from the attack. The error code is
  14. Thanks, this last explanation is much clearer, and I think you've given me the insight I was after. In answer to your question, I do all of the work of expanding and coding locally but the file that matters is hosted. I have created scripts to import all of the data from the hosted version after I make coding changes. In any case, I believe the source of my accidental loss of custom order was local, either as result of items 3 or 5 in your bulleted list. I have been able easily to reproduce the "accident" on a test database. Unless I'm missing a point, however, it seems to me th
  15. Sorry, but I think I need more context to understand you. Based on what you're saying, I'm trying to reproduce the act of changing the custom order to alphabetical all at once and can't do it. In your first paragraph, for instance, are you talking about editing a layout with the left pane open, or are you taking about being inside Manage Database? If one were in Manage Databases, how would one accidentally change a list of 126 fields from the custom order to alphabetical when viewing by custom order other than to do so manually?
  • Create New...

Important Information

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