• Content count

  • Joined

  • Last visited

  • Days Won


jaboda last won the day on April 18 2011

jaboda had the most liked content!

Community Reputation

2 Neutral

About jaboda

  • Rank

Profile Information

  • Gender

FIleMaker Profile

  • FM Application
    15 Advanced
  • Platform
    Windows 7
  • Skill Level
  1. The theme in the file.
  2. I've just tried your file in WebDirect and it doesn't show the lines. Additionally if I move the mouse over the active tab the background colour disappears. Same problem I'm having with my live solution.
  3. The main problem is I can't change the tab control elements - for example add a border or reliably change colours. I also can't create more than one style (as well as Default) - otherwise the styles don't work properly in Webdirect. When using another theme these features work fine.
  4. This seems to be a bug in Filemaker as the layout is not displaying correctly in Webdirect. If there's a corruption in the Theme then repairing the file should fix it - hence why I think it's a bug. I have attached an image of how it displays in Filemaker, Webdirect 14 and also the file. The only way I can think of to fix it is to rebuild the entire theme, but this is a massive pain. Any other suggestions? Thanks. Theme Test.zip
  5. It appears the HKCU entry can be edited, and is not overwritten. Don't quite know why I didn't try this before. This means that you cannot set it system-wide (in HKLM) but it can be set in the database as required (by running the Reg utility). It's not ideal, and I still think it's a bug, but at least there's a workaround.
  6. Oops good point - I'm using Windows 7 64 bit, with 64 bit FileMaker Pro Advanced 15.
  7. I believe this is a bug in FileMaker. I have posted more details about this here.
  8. I am using a Web Viewer Control to embed Google Docs content on Windows. Unfortunately Google is reporting that my web browser is out of date and not supported. Tested on FileMaker Pro Advanced This is a bug in FileMaker. Here's why: The FileMaker Web Viewer uses Internet Explorer on Windows. The version is controlled by the FEATURE_BEHAVIORS and FEATURE_BROWSER_EMULATION keys, which can either be in the HKCU or HKLM in the registry. I am assuming an HKCU value overrides HKLM ones. On previous verisions (at least FileMaker 11) a registry key could be created in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer\MAIN\FeatureControl\FEATURE_BROWSER_EMULATION which fixed the issue - annoying but manageable. On FileMaker 15 an entry is created in HKCU automatically when FileMaker is loaded - which forces Internet Explorer 9 to be used. This is no longer supported by Google. Please note this is irrelevant of what is the default browser, or what browsers are installed. I will report it to FileMaker. Any ideas/input greatly received.
  9. I have now updated this script to allow for authentication (for use with Google's SMTP Servers, but should work with others). You can see the new version here.
  10. Some time ago, in this thread, I shared a ScriptMaster script to send HTML e-mails which supported multiple recipients and attachments. I am going to switch from using our own SMTP Server to the gMail SMTP Servers, which of course require authentication. Therefore I've updated the script to allow for this. The code is as follows: HTMLEmail ( from ; to ; cc ; bcc ; subject ; htmlBody ; attachmentPath ; smtpHost ; username ; password ) import javax.mail.*; import javax.mail.internet.*; Properties props = new Properties(); if (username == null){ props.setProperty("mail.smtp.host", smtpHost); } else { //If a username is specified then use security props.put("mail.transport.protocol", "smtps"); props.put("mail.smtps.host", smtpHost); props.put("mail.smtps.auth", "true"); } MimeMessage msg = new MimeMessage(Session.getInstance(props)); if (attachmentPath == null) { // HTML E-Mail Only msg.setContent(htmlBody, "text/html"); } else { // HTML E-Mail with Attachment(s) Multipart content = new MimeMultipart(); // first the message body MimeBodyPart bodyPart = new MimeBodyPart(); bodyPart.setContent(htmlBody, "text/html"); content.addBodyPart(bodyPart); // then the attachment(s) attachmentPath.tokenize(";").each {it -> attachmentPart = new MimeBodyPart(); attachmentPart.attachFile it; content.addBodyPart attachmentPart; } msg.setContent(content); } msg.setSubject(subject); msg.setFrom(new InternetAddress(from)); to.tokenize(";").each {it -> msg.addRecipients(Message.RecipientType.TO, new InternetAddress(it)) } if (cc != null){ cc.tokenize(";").each {it -> msg.addRecipients(Message.RecipientType.CC, new InternetAddress(it)) } } if (bcc != null){ bcc.tokenize(";").each {it -> msg.addRecipients(Message.RecipientType.BCC, new InternetAddress(it)) } } if (username == null){ Transport.send(msg); } else { Session mailSession = Session.getDefaultInstance(props); Transport transport = mailSession.getTransport(); int port = 465; transport.connect(smtpHost, port, username, password); transport.sendMessage(msg, msg.getAllRecipients()); transport.close(); } return true; It works the same as before if the username is left blank. Otherwise it uses SSL on port 465. When using gMail you have to "Allow less secure apps to access your account", but I think this is the same as the built-in FileMaker Send Mail command. As before I have created an example database which is attached. SendHTML.zip
  11. Thanks Karsten, That worked - I hoped it would be something simple and it was .
  12. The script generates a hash but it's not correct (when I generate the hash manually it's different). I am using this to download information via a a proprietary web-based API. They require a Hmac Hash for validation.
  13. I saw that thread and it was useful but won't work with a pass key (not Hmac SHA-256).
  14. Hi, I'm trying to generate an SHA-256 Hmac hash of some text and a key using ScriptMaster. Basically I need to create a version of the PHP hash_hmac command. I've tried the following code and it generates a hash but it isn't correct. Here's the script: SHA_Hash (text;key) import javax.crypto.Mac; private static String toHex(byte[] hash){ StringBuffer buf = new StringBuffer(hash.length * 2); for (int i=0; i<hash.length; i++) { byte element = hash; int intVal = element & 0xff; if (intVal < 0x10){ // append a zero before a one digit hex // number to make it two digits. buf.append("0"); } buf.append(Integer.toHexString(intVal)); } return buf.toString(); } // generate hash def hashkey = new javax.crypto.spec.SecretKeySpec(key.getBytes(), "HmacSHA256"); def digest = Mac.getInstance("HmacSHA256"); digest.init(hashkey); def rawSig = digest.doFinal(text.getBytes()); def sig = new sun.misc.BASE64Encoder().encode(rawSig); byte[] hash = sig; return toHex(hash); It's probably a simple error but my Groovy and SHA-256 knowledge isn't good enough to find out what's wrong. Any ideas? I'm sure this would be a useful function for others too. Thanks.