Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About domiller

  • Rank
  • Birthday 03/10/1958

Profile Information

  • Gender
  • Location
    Little Rock, AR
  1. That is what I am using. Just for grins I tried a bad password and get the "Authentication Failed" message, So I *am* putting in valid credentials. I was using this with a personal account in the past and it worked beautifully. That's what frustrates me now.
  2. I haven't tried sending mail, although it's worth a go. I'm trying to get an IMAP connection. I have tried the password with and without spaces (Google describes it as a 16-character password, so I assume the spaces are for humans rather than part of the password). I still receive the same (unhelpful) error.
  3. I have had this plugin working beautifully for my personal account (IMAP to Gmail) for a couple of years now. I had set gmail to allow less secure apps. Now I have a new, company-based email account from Google, which has 2-step verification turned on. I followed the instructions to generate an app-specific password, plugged everything in, and get the aforementioned " [ALERT] Please log in via your web browser: https://support.google.com/mail/accounts/answer/78754 (Failure)" error. Has anyone recently gotten IMAP from Google working with the email plugin and two-step verification? This really shouldn't be so hard.
  4. Wow! That's one I never would have found on my own. Yes, it did fix the problem (at least on the first system I tried). Thank you!
  5. I have found similar posts, but not quite what I am experiencing. I can start a clean copy of FileMaker, install the scriptmaster plugin (via the install plug-in script step), and everything works beautifully for that session. However, when I close FileMaker and re-open it, it crashes -- every time. The error is: Problem signature: Problem Event Name: APPCRASH Application Name: FileMaker Pro Advanced.exe Application Version: Application Timestamp: 5538423e Fault Module Name: 360Works_ScriptMaster.fmx Fault Module Version: Fault Module Timestamp: 550aeae2 Exception Code: c0000005 Exception Offset: 00008a10 OS Version: 6.3.9600. Locale ID: 1033 Additional Information 1: 5861 Additional Information 2: 5861822e1919d7c014bbb064c64908b2 Additional Information 3: 1318 Additional Information 4: 13181ae637ac2592fac0ca2dd662cdcc This is using Windows 2012R2, FMPA14.0.1 (32-bit), and Java 1.8.0_91-b15 (also 32-bit). FMS is also running on this system (with the appropriate 64-bit Java) if that matters. If I delete the ScriptMaster plugin, I can start FileMaker, re-install the plugin and once again everything is fine for that session. I have uninstalled everything, deleted directories and re-installed to no avail. I have similar systems on which this works perfectly. Any ideas?
  6. Take a look at the 2empowerFM SQL Runner plugin. You can plug in standard SQL Create Table scripts and have them work (mostly) as you would like. There are some differences between what MS SQL uses and what FileMaker expects. Basically, if you could use it in ODBC, you can use it in FileMaker. It's *far* better than having to do it all from scratch.
  7. While I have some limited experience with custom menus, I can't seem to find a way to affect the "Save as Excel" button that FileMaker places on the toolbar. I want it (in certain cases) to call a script rather than the standard export. Is there a way to do this? Can some kind soul point me in the right direction?
  8. I can't decide if I'm doing something wrong, or if I have found a bug. If I request all attachments (which should include inline as well), the results aren't promising. For true attachments, the EmailReadMessageValue( "attachments") returns strings of the form: C:Users{user redacted}AppDataLocalTemp6F2ACA98C-BE9D-4DBA-B154-9A14B08F9827@{domain redacted}image002.jpg which work perfectly. However, inline attachemnts are giving me only the filename. e.g. image001.png. The images are being written to disk just fine, but the path to them isn't there. Am I missing something, or is this a bug? Related question: I can compute the path for an image as "C:Users{user redacted}AppDataLocalTemp6" & MessageID & "" & Filename, but can I depend on the subdirectory under Temp always being 6? Thanks, Dale
  9. The answer is, of course it's possible. In FileMaker (with the right plugins) anything is possible. Now, is it reasonable? That's another matter. You didn't give details of the website in question other than it uses javascript, which we will sidestep for a moment. Whenever you fill out a web page and submit the information (with or without JavaScript), it creates either a GET or a POST request to the server. Either of those can be handled with a varying level of difficulty. To fairly easily find out which is the case, I use the "Live HTTP Headers" extension to Firefox. Enable it, make your request, and you can see the actual GET/POST traffic between the browser and the server. If your request can be processed as a GET, then all that is necessary is to construct the string and use the FileMaker "Insert from URL" script step. As an example, this (assuming appropriate variables are set) will pull a standardized address from the USPS: "https://tools.usps.com/go/ZipLookupResultsAction!input.action?resultMode=0&companyName=&address1="& $address_line1 & "&address2=" & $address_line2 & "&city=" & $address_city & "&state=" & $address_state & "&urbanCode=&postalCode=&zip=" & $address_zip If a POST is required, FileMaker cannot handle that natively, but ScriptMaster (from 360Works) comes with a basic "Post data to URL" script that might be able to fulfill your requirements. After all that, I'll introduce the part that probably complicates things -- you didn't mention whether this site requires authentication prior to requesting the information. If so, this is a multi-step process, likely requiring cookies. That's still doable, but I'm not aware of an existing plugin/script which handles cookies. (I am open to being pleasantly surprised if someone lets me know about one). You could certainly expand on the one in ScriptMaster, as I know there are Java libraries to handle this sort of thing. It all depends on the amount of time and effort you're willing to invest.
  10. Message-ID doesn't work like UID. UID is a per-account number assigned by the mail server, and will change if messages are moved to a different server. It is expected to be unique and always incrementing within an individual account, thus the ability to retrieve newer messages based on uid. Message-id, on the other hand, is a unique string generated by the message creator. It is expected to be universally unique, but you may *not* expect it to be incrementing, or, in fact, make any assumptions about it at all other than its uniqueness. It should be of the form <somestring>@<hostname>, but not all mailers are strict about this. RFC822 says: This field contains a unique identifier (the local-part address unit) which refers to THIS version of THIS message. The uniqueness of the message identifier is guaranteed by the host which generates it. This identifier is intended to be machine readable and not necessarily meaningful to humans. A message identifier pertains to exactly one instantiation of a particular message; subsequent revisions to the message should each receive new message identifiers. Thus , if you know a particular Message-ID (or a particular pattern), you can use this option to retrive messages, but it can't be used to grab arbritary groups in the same way that UID can.
  11. I am trying to read all the messages in a *large* gmail account. I quickly discovered that I needed to break it into chunks so that my system is not overloaded. It seemed that uid= with max= was the proper way to do that, and it almost works. I picked 200 as a viable chunk size. It seems that a combination of UID={some number} and max=200 does not retrieve the next 200 messages, but the next 200 UIDs. If a large number of messages have been deleted, there may be a gap in the UIDs of greater than 200, at which point the call returns zero messages. Finally to my question... is there some way to reasonably determine the higest UID in use? That way if my call returns zero I can see if I have reached the end and, if not, increment the UID by 200 and try again. Otherwise, I have to assume that I have reached the end of the mailbox. This is frustrating when I really haven't.
  12. I am maintaining a system which has been written by several prople over several years. A few days ago I needed to modify a routine which set global variables for each of about 40 columns in a record (so context could be switched and still access those fields). I needed to add about 15 more columns, and that sort of repetitive work doesn't appeal to me. Thus I came up with the following: Evaluate( "Let([" & Let(q=Get(LayoutTableName);ExecuteSQL(" select '$$'||fieldname||'="&q&"::'||fieldname from filemaker_fields where tablename = '"&q&"' and fieldclass = 'Normal' and fieldtype not like 'global%' order by fieldname ";"";";¶";""))&"];0)") Assigning this to a variable resluts in zero, but assigns a (global) variable for each non-null normal field in the current record. I don't know how much use this will be to anyone, but it seemed interesting enough to share.
  13. I notice that you are a Mac user, so I can't assume this is the same, but on Windows, using Send Event["aevt";"pdoc";"<filepath>"] will print any sort of document if (and here is the key), that file type has the correct definition in the file associations. If you can right-click the file and there is a "Print" option, then the command will work. If there is no print option, it won't. You can change the file associations and commands if you try hard enough. Earlier Windows versions weren't bad, but Windows 7 and 8 hide it from you. (I recommend http://www.nirsoft.net/utils/file_types_manager.html as a reasonable editor). For instance, I don't like the Microsoft-supplied picture printer, so I use IrfanView to print. Given how integrated the Mac is, I would be surprised if there wasn't a similar (and probably more user-friendly) method in place.
  14. Claus -- How do I re-deploy the console? I'm having the same issue, and I was hoping to avoid a reinstall.
  • Create New...

Important Information

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