Jump to content


  • Content count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About SarahS

  • Rank

Profile Information

  • Gender
  • Location
    Cedar Falls, Iowa

Contact Methods

  • Website URL

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version
    El Capitan

FileMaker Partner

  • Certification
  • Membership
    FileMaker Business Alliance

Recent Profile Visitors

1,239 profile views
  1. Runtime Engine Upgrade

    I'm embarrassed to discover I never acknowledged your response - thank you very much for your suggestions & help. I currently use Actual Installer for the PC platform (but I think there are probably others equally as good) and a zip file for Mac platform. I can't seem to get a .dmg file to upload or download properly from my website for the Mac platform.
  2. Since making my original post, I have changed the new ID_OLD field and the devicePrefix fields to have auto-enter calculations from the (same) device prefix global field, but they do not replace existing values. There are only a few scripts in my solution that duplicate records, so I am manually resetting the fields by script when a new record is created by duplication. This seems to be working but doesn't seem like the best solution....
  3. I just updated all the IDs in my solution to use UUIDs due to issues I was having with duplicate IDs. I am confused about how auto-enter calculations (that replace existing values) work with MirrorSync. My question: How is the value in a field with an auto-enter calculation (that replaces an existing value) different when the field is specified as the primary key field in the MirrorSync configuration versus when it is not? Does the value get changed during synchronization depending on if a global field is referenced? Does having the option to evaluate the field even if the referenced fields are empty also create a difference in behavior? Thank you very much for helping clarify this!!! This is how I used to be creating the IDs and have now abandoned for the UUID method: serialNumber (number) field: number field that auto-enters a serial number - the value of this field gets reset in each table by script using "GetNextSerialValue" each time a user logins and their device prefix is identified ID (text) field: auto-enter calculation (replaces existing value) that combined the device prefix (stored in a global field) & the record serialNumber - this field was used as at the primary key as well as the user-visible record number devicePrefix (text) field: auto-enter calculation (replaces existing value) of the left two characters of the ID field This is how I am now setting the UUID & user-visible IDs: no changes to field def. - serialNumber (number) field: number field that auto-enters a serial number with modifications prohibited - the value of this field gets reset in each table by script using "GetNextSerialValue" each time a user logins and their device prefix is identified new field - ID_OLD (text) field: auto-enter calculation (replaces existing value) that combines the device prefix (stored in a global field) & the record serialNumber - this field was set with the existing IDs prior to converting to UUIDs and is used as the user-visible ID changed field def. - ID (text) field: auto-enter calculation (replaces existing value) of Get(UUID) - this field is still the primary key field changed field def. to reference the ID_OLD field vs. the ID field - devicePrefix (text) field: auto-enter calculation (replaces existing value) of the left two characters of the ID_OLD field
  4. File Access Protection & Encryption

    Thank you for your response Steven. Would a simple copy & paste of the file affect the file access protection (FAP)? I am using copies of the UI and data files (made with copy & paste), but not of the opener file. I didn't think copy & paste would affect FAP since when I try to add authorization for the opener file again, it says the opener file is already authorized. Below is what I tried with the snapshot link suggestion: - I logged in to the file using my full access account & created a snapshot link. - I closed the program and tried opening the program again with the snapshot link and got the error message below: "Cannot restore the snapshot link file "open UI_File.fmpsl" Make sure that the status toolbar is accessible in at least one window of the referenced database." I do have the status toolbar enabled in my full access account, but not in the other accounts. I plan to do a file upgrade soon and can test how the snapshot link behaves with newly uploaded files.
  5. I have a solution that is hosted by FMS14 and remotely accessed by my client. My development files have file access protection enabled, and I have authorized the opener file to open the UI file, but they do not have encryption-at-rest (EAR) enabled. Prior to uploading the files to server, I add EAR protection. I am confused because after the encrypted files are uploaded and I go to open them with the opener file (that I thought was authorized), I get the error message that the opener file is not authorized and I am required to input my full access credentials. I am willing to do this, but it means that every time I update the files, I have to re-send my client the opener file that has been authorized for the updated files, and they have to download and replace their opener file for all users and I would like to eliminate this hassle for them. Is there a way to allow the opener file to remain authorized when uploading updated files? Do I need to add authorization for the opener file while the UI and data files have EAR enabled? Thank you for your guidance!
  6. Upgrade Recommendation

    Thank you very much for the helpful & timely response. I'm really thankful the upgrade can be very simple for my users.
  7. My client has not been able to update the files on her devices recently. The MirrorSync script currently on her devices was created with version 2.40510 (last updated 6/1/2015). The MirrorSync version on the server is 2.505 (running FM 14 Server). She is currently running the files in FileMaker 12 & the Go 12 app due to an issue last year with synchronizing from FileMaker 13. I see the current MirrorSync version is 2.6. What sequence would be best to avoid compatibility issues and to get her using at least the Go 14 App (or Go 15), the server to MirrorSync 2.6, and the files on her devices to have a MirrorSync script with the current version? Thank you!
  8. Files & Tables Consolidation

    TSGal from FileMaker found the solution to my problem, as detailed below. I had an external data source with the same name as the current file and the TOs that had an issue were all pointed to that external data source. I noticed in the Relationships graph that the tables in question are in Italics, which means you are linking to another file's table; not the current file. If you hover over the top left corner of each italic table, you will see you are linked to a file, even if it is the current file. If you hover over the top left corner of a non-italic table, you will see the Data Source set to <current table>. Changing these externally linked tables to current tables will then display the table occurrence in the Tables tab "Occurrences in Graph".
  9. Files & Tables Consolidation

    Yes, I am very thankful. It is an answer to prayer!
  10. Files & Tables Consolidation

    I did some more testing and have created an Issue Report in the FM Community, which can be viewed at: https://community.filemaker.com/message/539877#539877 The initial posting in that issue report is copied to below: Product and version: FileMaker 14.0.4 (but I was able to replicate the issue in 13.0.9 as well) OS and version: Mac 10.10.5 Browser and version (for WebDirect only): N/A Hardware: MacBook Description: I have a file with 107 tables and when you duplicate a TO in the relationship graph, that TO is not listed on the "Tables" tab in Manage Database in the "Occurrences in Graph" column. If you add a new TO using the "Add New" button (instead of duplicating an existing one), then the new TO DOES show up in the "Ocurrences in Graph" column of "Tables" in Manage Database. Note: This does not seem to be a problem when there are not fewer data tables (& TOs on the graph). How to replicate: From a file with many data tables, duplicate an existing TO from the relationship graph. Workaround (if any): Use the "Add new TO" button vs. duplicating existing TOs The consistency check as well as running recover on a copy of the file did not indicate that there are any issues with the file. This is a brand new empty file that I began with as "from scratch" recently. It has not crashed at any point. I created the data tables by importing .xls spreadsheets (with one row only for the field names). I would like to know from FileMaker if this bug affects the integrity of my file at all or if it is okay to continue developing my files that I duplicated TOs in vs. adding as new TOs?
  11. I have an old solution that started out in FileMaker 5 with 35 files and I am working to consolidate it down to 5 files. The user interface will be two files and the data will be three files (general data, more sensitive data, & images/containers data). There are currently 106 tables in the general data file and quite a few less in the other two files. 1) Is it unwise to have so many tables in one file if there should be data corruption that requires recovery? 2) I am re-creating the field definitions and just noticed after duplicating a table occurrence that the name does not appear in "Occurrences in Graph". I have tried re-doing the action, opening & closing the file, and duplicating other table's TOs and the same problem occurs. Is there a maximum number of TOs that are displayed in the "Occurrences in Graph" column of the tables tab? (Seeing this happen is what made me wonder if I was doing the wrong thing by consolidating so many tables into the same file...) Is this an issue? Thank you, Sarah
  12. I have a solution with a text field that has a varying amount of text stored in it for each record. I am working on a print layout using two columns to print the records found set of this text field. As it is currently designed, if the text in the last record in a column is too long to be displayed in the column, it gets chopped versus wrapping. I have found multiple postings regarding this topic from 2008-2009 time frame, but don't see anything current. If I compiled the information into a variable and then split it up based on a character count, would that work or does anyone have suggestions on how to print multiple column layouts for large text blocks across a found set of records? I could also send the records to a temporary table & split the large text blocks up there for printing, but think that would make the printing operation/script take a lot of time, especially considering usage on iOS. Thank you for your suggestions!
  13. Runtime Engine Upgrade

    Thank you for your response Mike. I really need to learn more about building installers for both the Mac & PC platforms. Do you have any suggestions regarding where to learn or what installers work best for both platforms? Several users have manually replaced the runtime engine and it is working fine, so hopefully it truly is this time... I will study up for next time.
  14. I have a Mac runtime solution that multiple people around the world are using. It was originally created using 13.0.5. Some users tried running it on El Capitan and rightly got error messages that files were missing as it is not compatible with 10.11. I created a new runtime of the same files that were distributed using 14.0.4 and tested simply replacing the runtime engine file only (& none of the data/interface files). The solution seems to run perfectly on El Capitan with this runtime engine upgrade. I see this the same as upgrading the FileMaker Pro application version, and no changes need to be made to the .fmp12 files. Am I making a bad assumption if I simply have the users replace the runtime engine file (& none of the other files) to be compatible with Yosemite?
  15. SMTP & Google Apps e-mail account

    Thank you Josh, that seems to have been my problem as well. After I changed that setting & re-ran the "SMTP Send Mail Interrogation", I found the correct settings and have it working! For the reference of those that may read this in the future, the tool is available at: http://www.savvydata.com/blog/2009/11/fixing-smtp-send-mail-error-1506/

Important Information

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