Jump to content


  • Content count

  • Joined

  • Last visited

Everything posted by SarahS

  1. For anyone that may read this thread in the future, Tsiry from 360 Works provided great support and helped me get it resolved. I tried stopping/starting the 360Works application server using 360Works Admin.jar at /Library/360Works/ but that didn't help, but it did give me access to the MirrorSync page to allow me to submit a bug report including the day's server log. I then reinstalled MirrorSync 3.17 and that resolved it!
  2. I am running MirrorSync 3 on a FMS 14 machine (OS 10.9.5) and recently switched from using the self-signed certificate to a SSL certificate issued by a certificate authority supported by FileMaker. I was able to successfully install the SSL certificate. I didn't think I needed to make any changes in the MirrorSync configuration when I switched the SSL certificate since the configuration was already setup for SSL. Another major server change I made prior to installing the SSL certificate was I uninstalled FMS 14.0.1 & reinstalled 14.0.4 to enable communication with FM 16 clients. But according to the documentation topic "What if I need to redeploy FileMaker Server?", I didn't think there was action I needed to take with MirrorSync. My user in Mexico just notified me today that she cannot sync and I am unable to open MirrorSync on the server. Obviously MirrorSync was affected by one of the changes I made. I can't find an error log from today on the server from when the device tried to sync. I did have the device user try to use the Report Bug button, but she said it also gave her an error message. What do I need to do to recover & get back up & synchronizing? I do have a full server drive backup (made after stopping all FileMaker processes, and excluding the Data folder!) from prior to doing the uninstall and reinstall of FMS 14.0.1/14.0.4. When I do https://yourservername.com/MirrorSync, I get the "Object Not Found!" Error 404 page... I have a screenshot of the error dialog she is seeing on her device and can send that if you want. Thank you for your guidance!
  3. 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?
  4. 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.
  5. 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
  6. 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....
  7. 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!
  8. 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.
  9. 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!
  10. Upgrade Recommendation

    Thank you very much for the helpful & timely response. I'm really thankful the upgrade can be very simple for my users.
  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. 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".
  13. Files & Tables Consolidation

    Yes, I am very thankful. It is an answer to prayer!
  14. 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?
  15. 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!
  16. 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.
  17. 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
  18. 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/
  19. 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!
  20. That was in fact the issue, thank you Jesse. I hadn't changed my layout, so I'm not sure what happened!
  21. Note: ID_Inv_DataEntry shows up during the mapping process, but ID_Inventory does not. ID_Inv_DataEntry is a standard (indexed) text field.
  22. I am using a developer-managed schema & have an auto-enter text field that is not showing up during configuration. The auto-enter is not at all close to what a UUID would look like. To give you a little more info... The field that does not show up during mapping is in my sales order line items table and is named ID_Inventory. There is another field named ID_Inv_DataEntry that is visible to the user to input the product identifying info (UPC, ISBN, ID_Inventory, etc.) during data entry. Based on what is input, the auto-enter calculation on the ID_Inventory field inputs the ID_Inventory from the Inventory Items table. I don't understand why this text field is not showing up... Thanks for your help!
  23. I am considering using your solution, but one of the questions in my mind is what will be involved in implementing the new version once it is released? Will it require going through the initial setup stages again with the new files? Thank you!
  24. Future Versions Implementation

    Great. Thank you!
  25. I am working to implement MirrorSync to an existing solution. The solution is currently being used locally on a MacBook. The changes I am making will require the solution to be hosted in order that it can be accessed by several MacBooks, devices, as well as the internet. I am working on the hosted files to develop the solution & implement the MirrorSync tool. These files currently contain test data. The current data still resides on the user's MacBook and she still needs to use the program while I am implementing the changes. Will I run into problems by implementing & debugging MirrorSync with the test data, then later importing the current data and rerunning the sync tool? If so, what procedure do you recommend?

Important Information

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