SarahS

Members
  • Content count

    44
  • Joined

  • Last visited

Community Reputation

0 Neutral

About SarahS

  • Rank
    member
  • Birthday

Profile Information

  • Gender
    Female
  • Location
    Cedar Falls, Iowa

FIleMaker Profile

  • FM Application
    14 Advanced
  • Platform
    Cross Platform
  • Skill Level
    Intermediate
  • Certification
    9
    13
  • Membership
    TechNet
    FileMaker Business Alliance

Recent Profile Visitors

913 profile views
  1. 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.
  2. 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!
  3. Thank you very much for the helpful & timely response. I'm really thankful the upgrade can be very simple for my users.
  4. 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!
  5. 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".
  6. Yes, I am very thankful. It is an answer to prayer!
  7. 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?
  8. 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
  9. 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!
  10. 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.
  11. 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?
  12. 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/
  13. I am really confused with trying to get Send Mail as SMTP working with a Google Apps email address (i.e. office@mydomain.com as a gmail e-mail address). I have been doing a lot of research on Google and FileMaker forums and can't understand why I can't get it working (as so many others have gotten it work with settings I have tried). I was hopeful when I found Savvy Data's amazing "SMTP Send Mail Interrogation" tool, but the results it produced two times are copied below. Does Send Mail as SMTP have to be run on a hosted file? That doesn't seem to be my issue, but I'm not sure. Does anyone have Send Mail as SMTP working with a Google Apps email address? If so, can you please share what settings are working for you? Thank you very much in advance! Elapsed time: 0:08:16 Out of 189 iterations, 189 failed and 0 succeeded. Unsuccessful count by Error#: ============================= Error# 1501: 2 Error# 1502: 171 Error# 1503: 3 Error# 1504: 1 Error# 1505: 0 Error# 1506: 12 Error# 1507: 0 Other (not tracked): 0 Error# Legend: ----------------------------------- 1501 SMTP authentication failed 1502 Connection refused by SMTP server 1503 Error with SSL 1504 SMTP server requires the connection to be encrypted 1505 Specified authentication is not supported by SMTP server 1506 Email(s) could not be sent successfully 1507 Unable to log in to the SMTP server
  14. I have a (separation model) runtime solution that was bound with FileMaker version 10 and is used by 20-30 persons around the world. They (& I) consider the data they have input into the program as private. I am currently upgrading the solution to use FileMaker 13 (which is obviously necessary to support users using newer OS!) The two options I have thought of to upgrade the users and to save their data are: 1) For them to send me the data files & I will manually convert the files & import the data into the upgraded solution and rebind the solution to send back to them. I have promised them that I will maintain the confidentiality of their data and only analyze it to the extent necessary to ensure it is completely & accurately converted & imported, however several of them are still not comfortable with that. 2) For them to sign up for a trial version of FileMaker 13 so they can convert the runtime data files themselves & then use those converted files to import the data into an upgraded runtime version (by script). This is not my preference as it would require a lot of hand holding & is error-prone (and would sign them up for e-mail communications that they probably don't need/want). Are there any other options to upgrade a runtime solution in which the user can transfer their data from fp7 runtime files to runtime fmp12 files? If not, does anyone have any suggestions on how to make option #2 above a smooth & accurate transition process for the user? Thank you!
  15. That was in fact the issue, thank you Jesse. I hadn't changed my layout, so I'm not sure what happened!