Jump to content

Mr. Scott

  • Content Count

  • Joined

  • Last visited

Community Reputation

2 Neutral

About Mr. Scott

  • Rank
    The more I know, the more I know I don't know

Profile Information

  • Gender

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version

Recent Profile Visitors

3,434 profile views
  1. Mr. Scott

    java.lang.OutOfMemoryError: Java heap space

    This error was encountered by us when the file on the SFTP server was over 17MB in size. We did implement the stated "fix" above to create a "memory size" file inside a "360FmKit" directory using Terminal, but it did not resolve the issue for us. Does anyone know how we can resolve this for files of this larger size?
  2. I have the same need for public key authentication (without password). According to "how to use SFTP (with Client Validation - Public Key Authentication)" on: https://enterprisedt.com/products/edtftpjssl/doc/manual/html/howtousesftpintroduction.html "In public key authentication SSH clients and servers authenticate each other via public/private key pairs. Each must have access to their own private key, and they must have access to each other's public key. The client's public key must be registered with the SSH server, typically by copying it into the server's authorized_keys file. The client's private key is loaded via SSHFTPClient's setAuthentication method before calling connect, supplying the full path of the private key file, the SSH username and the passphrase of the private key file. and on this page: https://enterprisedt.com/products/edtftpjssl/doc/manual/html/howtousesftpwithclientvalidationpublickeyauthentication.html Public Key Authentication involves using a private/public key pair to authenticate the client. The key pair must be in a file in OpenSSH or SECSH format and the name is passed as follows: ftpClient.setAuthentication("myprivatekey", "jack", "my_keyfile_password"); The user-name is the name of the user on the SFTP server, but the passphrase is the password for the key-file (if there is a password). Using Transmit from Panic Software, I choose the "SFTP" protocol, input the "server address", enter my "User Name", then choose my private SSH key instead of a password, and then put in a remote relative directory path to get files and the local path to receive them. Now, according to an April 7, 2014 reply from Joe Pampalon of 360Works: "FTPeek does not currently support this SFTP connection method, but 360Works can custom develop the plugin to suit your needs. Please send an email to infobox@360works.com if you are interested to receive a quote for the work." This is a very common aspect of connecting to SFTP servers. Is this still a "develop to suit" feature, or is it possible to accomplish with FTPeek? If supported, how do we do it, and which versions of FTPeek support SFTP authentication via keys without a password? Thanks in advance, - - Scott
  3. Well, I opened Matt Petrowsky's example plug-ins file on the server with FileMaker Pro Advanced 13, then chose to install the ScriptMaster plug-in locally, which then opened the old Apple Software Update and stated it needed to install Java 6, which I did. I then turned off, then on the Server via Admin Console, then opened Matt's example plug-ins file, and it installed ScriptMaster this time. This is the only way I know of that one could install Java 6 on a machine running newer Mac OS X versions, as Oracle has pulled it, and Apple's installers won't allow it to be installed from Apple's own site directly – only through a scenario such as this, apparently.
  4. From this TechNet discussion, it's coming down to the default popup menu value list is mirroring the "View Index" list. So far, we know that FileMaker 12 and 13 sort fields the same way: ignoring leading spaces and special characters (like the asterisk). FileMaker 12 displays value lists in popup menus that same way, but FileMaker 13 sorts the list exactly how it displays the "View Index" value index. Anybody else want to chime in here? - - Scott
  5. Heads up: Our users have found that value lists in popup menus that formerly ignored pre-pended characters for sorting, now respect them. For instance, in FileMaker 12, values that were pre-pended with an asterisk were displayed in Alpha-numeric order by default — and the pre-pended asterisk was ignored: Now, in FileMaker 13, these characters are included in the default sort order, so all of the pre-pended values are now together at the top of the list: If anyone has suggestions on how I can restore the previous behavior (short of reverting back to FileMaker 12!), I'm all "ears". Thanks in advance, - - Scott
  6. Just ran into this yesterday, and initially thought it was either an out-of-date plug-in or that the SC Server was not working right, but it seems to be an unexpected behavior of the SC Webviewer when opened in FileMaker Pro 13. What happens is that the SC content does not appear in the web viewer on records where it is known to exist (images or files), and neither does the UI in the web viewer to "Choose File" or "Upload File". The screenshot below is of the webviewer on a record with a known .png image that appears to be blank This is what it looks like in Layout Mode (sorry about the blue guidelines): Here is what the formatting bar in Layout mode appears like… …and the font size drop-down isn't even a value, it's a hyphen… Just setting the font size to a value (12 pt., in this case) resolved the issue for images… …and files: …as well as in Layout mode. Just figured I'd pass this on in case someone else freaks out - - Scott
  7. Mr. Scott

    Field pattern inside a portal

    I've used this calculation in conditional formatting to get this desired appearance in list view: Mod ( Get ( RecordNumber ) ; 2 ) = 0 It may work for portal rows as well? Let me know, please. - - Scott
  8. FYI: Comment's recommendation is right on. With respect to [FULL ACCESS] privileges, I don't allow a directory group (external authentication) to have such a high level of privileges (per Mr. Blackwell's security recommendations). I have FileMaker-only accounts for FULL ACCESS, but don't have an external "Admin" group. I also use Matt Petrowsky's "developer" custom function to enable developer-only (FULL ACCESS) functionality. This can be obtained from the Starter example file at filemakerstandards.org, or their GitHub repository. - - Scott
  9. Per the FM functions reference: Get(UserName): The name of the FileMaker Pro user, as specified in the General tab of the Preferences dialog box. Get(AccountName): The authenticated account name being used for the active database file. I recommend to my users that they choose "Other:" in the General tab and input their login name to make logging in to the database easier. Otherwise, the default User Name is usually the System Name - the user name setup on your computer (Users & Groups Preference Panel on Mac OS X). - - Scott
  10. Perhaps "Sid" is your account name used to login, which matches the account setup in FileMaker security (or LDAP/AD)? If so, change the function to Get ( AccountName) instead. - - Scott
  11. Hi, Doug: I think what bcooney said was to create two GLOBAL fields to as intermediate data entry placeholders. The "Create" button she suggested runs a script that grabs the values in the GLOBAL fields, then uses them to perform a "Find" for the existence of such a record. If FoundCount = 0, it creates a new record and populates it with the data you have from the GLOBAL fields. - - Scott
  12. It will work with FMP12… Are you an in-house repair group, Apple-Authorized repair company, or what, as I am curious? - - Scott
  13. Mr. Scott

    Where is Comment ( Michael Horak )?

    Hi Raybaudi and all responders: I am embarrassed I have not noticed this. I think Raybaudi did a great thing in reaching out to ensure "comment" is O.K., and to share acknowledgment of "Comment"'s absence, in concern for "Comment"'s welfare. I can tell you I have learned a lot from the "comments" of "Comment", and wish I had said so in response to "Comment"'s posted messages. Raybaudi is to be applauded for "publicly" stating his concern. Maybe…", I think Raybaudi thought, "someone else in fmForums knows "Comment" personally, and can validate 'Comment's' welfare?" This would allay the concern of all of those who know (like you, or those who don't yet know they should be concerned) that "Comment" missing? So, "Thanks!" RayBaudi…and, I hope "Comment" is alive and well. Selfishly, I hope "Comment" will be fine, and will continue to "contribute" here, and elsewhere. Sincerely, - - Scott Comment/tag: also referred to as "Michael Horak" (unconfirmed).
  14. Mr. Scott

    Creating email message utilizing database fields

    Hi, Brett: I saw that you came into chat tonight. Welcome, and don't be "freaked out" by the occasional pointy-eared messages. It's usually about coffee, cheeseburgers, and the weather! I hope you'll stick it out for a while and continue to observe and participate in future Friday Night Chats. Perhaps you could get to the Annual Developers Conference (a.k.a. DevCon - 2013) in San Diego during mid-August? If you do it right, you'll come away with much more than it costs to attend. Best regards, - - Scott
  15. Mr. Scott

    [Samples] MultiPage Letters

    Hi, Stephen: Do you think that this could be used to provide counts of unique occurrences of a value, instead of the 3 methods described by FileMaker KB Answer ID 3423: Counting the Number of Unique Values in a Field How do I count the number of unique values in a field? http://help.filemaker.com/app/answers/detail/a_id/3423/~/counting-the-number-of-unique-values-in-a-field

Important Information

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