Jump to content

MileFaker3000

Members
  • Content Count

    9
  • Joined

  • Last visited

Community Reputation

0 Neutral

About MileFaker3000

  • Rank
    member

FileMaker Experience

  • Skill Level
    Novice
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
    Windows
  • OS Version
    10

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. MileFaker3000

    Sending Emails is Slow

    An update: As I was debugging something else, I noticed that the delay is definitely on the EmailConnectSMTP & EmailConnectIMAP functions. EmailConnectSMTP is definitely slower than EmailConnectIMAP though. Everyone here is suggesting network issues, maybe I'm misunderstanding what is meant by that. Are you referring just to network speeds, etc? We are not having any network issues with anything else we are doing. What's a normal delay for the EmailConnectSMTP & EmailConnectIMAP functions? We are seeing ~5-10 seconds. Can someone remind me why I need to use both EmailConnectSMTP & EmailConnectIMAP? Somewhere I was told to use the IMAP for moving to sent folders. Can I just use IMAP instead of connecting to both? If I'm reading the documentation correctly, both have the ability to send. Thanks!
  2. Firstly, sorry if this is the wrong section of the forum but this was the best fit I could find. I am currently using fmLog (https://app.works/tag/fmlog/) to keep an audit list for our dbs. It works great, except with certain characters. I believe this is the part that should be validating (removing) some chars that will break the script except it doesn't seem to be working. Let ( [ n = Substitute ( Get (ScriptParameter) ; "¶" ; "\¶" ); prefix = "$" ; e = PatternCount ( n ; " = " ) = 0 ; string = Substitute ( n ; [ " ; " ; "\"; " & prefix ] ; [ " = " ; "= \"" ] ) ] ; "Let ( [ " & prefix & string & "\" ] ; \"\" )" ) I know that a semicolon and equal sign will break it, but isn't this exactly what the above substitute is accounting for? Or am I missing something? Thanks.
  3. I currently am setting up a bulk-send script that needs to include an attachment. The attachment is a pdf in a folder that is saved ahead of time (from outside FM). I am not sure where in the script to put the actual attachment function. Outside the loop: The same file is sent in every email. (The pdf that relates to the first record) Inside the loop: The first email is right, the 2nd has the first pdf, plus the correct one, the third has the first two plus the correct one, and so on. What am I missing? Thanks. EmailRegister [..] EmailConnectSMTP [..] EmailConnectIMAP [..] EmailCreate [..] Go to Record [First] Loop EmailAttachfile [..] EmailRecipients [..] EmailSetSubject [..] EmailSetBodyFile [..] ... EmailSend EmailMoveCurrentMessage [..] Go to Record [Next] End Loop EmailDisconnect Fixed. I moved EmailCreate inside the loop. That was easy.
  4. MileFaker3000

    Sending Emails is Slow

    According to the docs it should be a setting on the EmailSend function, but I am unable to add any parameters to that function. What am I missing? I'm on Windows if it matters. I am also struggling to figure out the error capture. Shouldn't I be able to just add a step right before EmailDisconnect that is essentially: If Get ( LastError ) = "ERROR" then show custom dialog with EmailLastError as body? Again maybe I'm just missing something.
  5. MileFaker3000

    Semi-colon breaking email send

    Thanks Ryan. I just wanted to verify that it was the semi-colon that was actually breaking it, and you've done that. I need to get some error checking in the send scripts pronto.
  6. MileFaker3000

    Sending Emails is Slow

    EmailConnectSMTP and EmailConnectIMAP are definitely outside of the loop. EmailOutboundIsConnected: I do not have this in my script (there's no info in the docs about it). Would adding this into the loop speed the process up? Something to the effect of "if EmailOutboundIsConnected = 1 then send, else cancel" ? The emails do send as is so the connection is definitely staying open. Additionally, here's an example of my batch script so we're on the same page: EmailRegister [...] EmailConnectSMTP [...] EmailConnectIMAP [...] EmailCreate [From:FieldA; To:FieldB; Subject:"Text "& FieldC";] Go to Record/Request/Page [First] Loop EmailRecipients [...] EmailSetSubject [...] EmailSetBodyFile [url:"file:///H:/...template.html"] EmailBodySubstitute [Search String: %%FirstName%%; Replace String: FieldD] EmailBodySubstitute [Search String: %%LastName%%; Replace String: FieldE] EmailBodySubstitute [Search String: %%Salutation%%; Replace String: FieldF] ...etc (usually 8-15 of these) EmailSend EmailMoveCurrentMessage [Folder:"Sent Items"] Go to Record/Request/Page [Next; Exit after last: On] End Loop EmailDisconnect Thanks! We are using Office365, set up as follows: EmailConnectSMTP [Host: "smtp.office365.com:587"; Username: ...; Password: ...; Secure connection: "Case (0;1;1;1;0)"] EmailConnectSMTP [Host: "outlook.office365.com:993"; Username: ...; Password: ...; Secure connection: "ssl=1"] Maybe the security is not set up correctly? I had to figure that one out with some google-fu. There are no other speed issues on the network, and it's the same on all 3 workstations that currently use the email plugin, so I don't think it's hardware based. Thanks!
  7. In our database some people have emails like: email@address.com; email2@address.com This seems to be breaking the email plugin. The emails never send. Is this the expected function? I know I should separate the email addresses into different fields/records/etc but this is a synced database, and that's how it was handled for years prior. I plan on fixing them all but it's causing issues elsewhere to make the changes. Thanks (and sorry for double posting)
  8. MileFaker3000

    Sending Emails is Slow

    We have been using the email plugin for about a month or so and sometimes it's quite slow. I'm wondering if it's my setup. Here's a basic example of how we'd send a single email. EmailRegister [...] EmailConnectSMTP [...] EmailConnectIMAP [...] EmailCreate [From:FieldA; To:FieldB; Subject:"Text "& FieldC";] EmailSetBodyFile [url:"file:///H:/...template.html"] EmailBodySubstitute [Search String: %%FirstName%%; Replace String: FieldD] EmailBodySubstitute [Search String: %%LastName%%; Replace String: FieldE] EmailBodySubstitute [Search String: %%Salutation%%; Replace String: FieldF] ...etc (usually 8-15 of these) EmailSend EmailMoveCurrentMessage [Folder:"Sent Items"] EmailDisconnect I also have a batch version that adds a loop that seems to be even slower (per email). Am I doing something incorrectly? Are there certain elements of the plugin that run particularly slow (i.e. EmailBodySubstitute or EmailMoveCurrentMessage)? Is it the email server? Or just email in general. An example of speed: I was just told it took 4 minutes to send 10 emails (via the batch script). Typically individual emails are somewhere between 5 seconds and 30 seconds a piece.
  9. @alanf did you ever get this working? I'm trying to do the same and can't seem to figure it out.
×

Important Information

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