Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


sean360Works last won the day on August 7

sean360Works had the most liked content!

Community Reputation

14 Good

1 Follower

About sean360Works

  • Rank

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version
    High Sierra 10.13.4

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Hello Mark, The request that is failing is MirrorSync testing whether it can connect to the hosted database by "pinging" the layout ProscNoSuchTable. If successful, it will receive a 105 response from FileMaker indicating the layout is not there. However, if it cannot connect to the database, you will see the error you reported. Have you tried the sync again to see if it was just a temporary issue? Judging from the server address of the request, it looks like MirrorSync may be installed on the same machine as FileMaker Server. If so, the issue should not be network related. Could you step through the sync configuration in the configuration client to see if you can pull up the database JPG-MIS-Data in the list of databases drawn up when clicking the "Choose..." button on the page where you specify the FMS and MirrorSync addresses? If you're still experiencing the issue, please submit a log file to us. You can do so by visiting the MirrorSync launch page ([server address]/MirrorSync), clicking Send Problem Report and Log Files, filling out the form and submitting. It would be helpful if you reproduced the issue right before sending the log file.
  2. Hello, I recommend building your separate mobile by just making a copy of your hub file, and then removing records/layouts/tables from that file as you see fit. MirrorSync updates a timestamp in the MirrorSync table on the hub regularly so that MirrorSync can better evaluate the state of the records in new copies. You'll want this timestamp to be properly captured in your separate mobile file to avoid record conflicts. Any time you import records to the offline copy from the hub, you'll want to update this timestamp. Copying the hub as a base to generate your separate mobile file will take care of this. You probably won't need to both changing the DatabaseVersion value in the separate mobile file as the database updater feature is not available for separate mobile files. You'll need to make any db changes to the hosted mobile file, have users that use a separate mobile file for syncing run a final sync of their copy, and then download a copy of the updated mobile file.
  3. Hello, For file downloads, the MirrorSync table should have at least a server record(field type has value 'server'), and usually has a hub record in it as well. You don't need to mess with any of the fields on this table except for the sync4 field, which you would update if you are pre-populating your separate mobile file.(http://docs.360works.com/index.php/MirrorSync_5_advanced_topics#Can_I_pre-populate_my_offline_database_to_speed_up_initial_sync.3F) There should not be client record in this table. Other than that, you should not need to do anything more with the MirrorSync table beyond updating the DatabaseVersion field value, which you can do from the Manage Database dialog. You can absolutely pre-populate your separate offline file to reduce the initial sync time. However, you'll need to make sure the records you have in the offline file match the customization you set up to filter the records. Please reference the link I provided above to guide you on pre-populating your offline file
  4. Hello, Yes, placing a button on the fields won't affect MirrorSync's ability to access data in fields and to write to them.
  5. Hi Caroline, I apologize for the delay in response. I sent you a reply through the bug report you submitted, but I guess you did not receive it. Could you please download and install the latest build of MirrorSync? You can download it from the link below. http://sc.360works.com/SuperContainer/RawData/pro/360/NewMirrorSyncBuild5 The log you submitted indicates you are running MirrorSync 5.0, and the latest dev build of MirrorSync (5.0045) may already resolve your issue. Please let me know if you continue to experience the Access is denied error.
  6. Hello, You would need to make use of the MimeMessage class's setHeader() function. You can set the e-mail as plain text with call msg.setheader("Content-Type", "text/plain") https://stackoverflow.com/questions/12511744/custom-mail-headers-using-mime-in-java You may also need to specify "text/plain" as the second parameter in your [body object].setBody() call. The proper key to set an Unsubscribe List is "List-Unsubscribe". At the link below, someone applies it, and also includes a loop the prints all the headers to the console. https://stackoverflow.com/questions/21959235/javamail-api-listing-header-doesnt-work You can probably set a list of headers to a return variable to test out your function call, something like: String headersList; Enumeration headers = msg.getAllHeaders(); while (headers.hasMoreElements()) { Header header = (Header) headers.nextElement(); headersList += "\n" + header.getName() + ": " + header.getValue()); } return headersList;
  7. Hello, Thank you, OlgereDiekstra, for sharing that insight about the userspace. ScriptMaster includes a function, RunShellScript, that could allow you to connect to the remote Share through the script if the userspace context/authentication is the issue. However, to diagnose the reason ListAllFilesInDirectory is not working, could you please reproduce the issue, then locate the log file generated by our plugin, and attach that to this thread? You can reference our docs at the link below to locate the log file. http://docs.360works.com/index.php/Plugin_log_files
  8. Hello, Yes, developer-managed keys should perform better because it is not having to reference a SyncJoin to verify record-matching across the sync---it will only make changes based on the actual primary key values of the records. However, this performance difference may be negligible as compared to other factors like database size, network speed, server specs, etc. The only other reasons developer-managed keys(assuming you're using UUIDs) are that UUIDs are less prone to duplications, and also, should you run into any sync data issues, the option to use our built-in Repair sync data feature is available only if the sync configuration employs developer-managed keys. Having multiple sync configurations in your solution will not take away from the reliability of MirrorSync-managed v developer-managed keys beyond the reasons mentioned above. If you need to reset your sync data for any reason, all of the sync configurations associated with the same file located at the same address will be affected. MirrorSync already keeps an internal db associating matching records across the sync. If you do not configure the settings in your database to ensure record key uniqueness across multiple instances of the database(e.g. employing UUIDs), then you should select MirrorSync-managed keys in your sync configuration.
  9. Hello, I apologize, but custom code falls out of the scope of our free support. However, we have developers who are able to provide consultation work for you. If you'd like to hire one of our developers to generate custom code, I can put you in touch with our Project Coordinator. Send us an e-mail at support@360works.com or call us at 770-234-9293 making that request. You and the Project Coordinator will discuss the details of the work and determine an estimate for how much it will cost. We usually charge $185/hr for consultation work. If you share your code, either we or someone else on the forum can point you in the right direction. Someone may even provide the code you need. Stackoverflow.com is a good resource, too. https://stackoverflow.com/questions/4365850/list-unsubscribe-in-e-mail-header-how-to This may not be the solution, but I recently helped a customer with a similar issue---their e-mails were going to recipients' Spam folder---and we found that the issue was that they were trying to send an e-mail using a different domain from that of the email server. The e-mail server needed a SPF record that communicated to recipients' servers that it was authorized to send e-mails for that domain(http://bananatag.com/hub/spf-records-and-why-theyre-important/). That could be something to look into if you're using a different domain from your SMTP server. If you're experiencing an issue with ScriptMaster itself, then that would be something we can help you with at no charge. Please produce the issue, then look for the log file capturing the behavior. You can reference our docs at the link below to help you locate the log file. http://docs.360works.com/index.php/Plugin_log_files
  10. Hello, With MirrorSync 5, on the initial sync, the user is prompted a password input for the sync credentials(the creds used to log into the hub file to conduct the sync). MirrorSync will store this password in a HSQL table and provides the syncing database with a UUID associated with the password entry. On subsequent syncs, MirrorSync will reference this UUID to select the password for logging into the hub. This is strictly for convenience to reduce the number of times a user is prompted password input to only when they log into their database, and for the initial sync. This feature will not help users who forgot their password and are unable to log into their database instance.
  11. Hello, Could you send me the log file capturing ScriptMaster's activity? You can locate it on the server at C:\Program Files\FilesMaker\FIleMaker Server\Logs\360Plugin Logs. Look for a file called '360Works_ScriptMaster_Server.log'. Attach it to this thread and I'll review it to see if ScriptMaster is experiencing any errors. Also, I'd like to try to reproduce this issue. Could you provide the steps or a screenshot of your scripts that you're running via cron? If you're evaluating any custom functions not already provided in ScriptMaster, could you provide that Groovy in a .txt file attachment as well?
  12. Hi, The error report would certainly provide more detail. It will provide the error that is thrown as well as what MirrorSync was trying to do when the error occurred. Are you saying you have multiple solutions that you'd like to sync with one solution? If so, MirrorSync can certainly accommodate that. You can set up multiple sync configurations on the same file to cater to different syncing requirements. Regarding the dynamic nature of your FM apps, any schema changes that affect how data syncs would need to be reflected in the MirrorSync configuration and MirrorSync script as well, so I can see applying regular schema changes becoming cumbersome. That's not to say configuring MirrorSync is itself taxing. The MirrorSync config client makes it easy to set up a configuration once a database is sync ready---by 'sync ready' I mean appropriate layouts are set up in the database file with the appropriate fields. However, it would be an added step that would need to be done each time a change is deployed to your files' syncing tables. Of course, I don't know what your entire process looks like, so please feel free to test out MirrorSync to evaluate for yourself if you want to incorporate it into your work flow. You can set up a FileMaker Server to FileMaker Pro/Go configuration for 1 syncing device at no charge. A sync configuration between two databases hosted on different FMS instances is similar to a FMS-to-FMPro/Go configuration. For a FM-to-SQL configuration, I would say that MirrorSync IS the best choice for that process, but I may be biased.😉 We also provide trial licenses for users wanting to test a FMS-to-Server(FMS or SQL), so let me know if you'd like to get one. I recommend setting up a FMS-to-FMPro/Go config first as you can work at your own pace while learning how to set up a MirrorSync config---a trial license usually lasts for 2 weeks. If you run into any issues or have questions, certainly contact our support line at support@360works.com or call us at 770-234-9293.
  13. Hello, During the process of setting up a MirrorSync configuration, MirrorSync generates a FileMaker script that gets pasted into the syncing solution. In this script are all of the fields you specify to include in the sync. If changes are made to the structure of the database of which MirrorSync is not aware, it could result in an error. If a field is added to a sync layout---the layout specified in the configuration as the interface by which MirrorSync syncs data---changes to that field will be ignored. However, any changes to that field would trigger the modification timestamp to change, so MirrorSync will pick up on this discrepancy between the hub and spoke mod timestamps---the driving factor for processing changes---not find any field value changes, and may perform a slow deletion scan or run in recovery mode, which will slow down the sync process. If a field is added or the name changed, FileMaker will probably throw a "missing field" error because the Set Field script step in the MirrorSync script will try to write to a missing field. This will cause the sync to abort, or for changes to not sync properly. MirrorSync logs all sync activity, especially errors. Major errors like a sync failure can be reported to an e-mail specified in the sync configuration if you select this option. Any changes in the database configuration that affect the sync or cause it to fail will just register as a errors with MirrorSync. MirrorSync does not do a separate evaluation of the databases on both sides of a sync to ensure the schemas match up perfectly. This is assumed. How often are you wanting to back up your information? Are you wanting to perform a minute-by-minute back up to maintain data integrity? This is the scenario I imagine where using MirrorSync to back up your data would be advantageous. Otherwise, if you just want something like an hourly backup, if you're looking for a 3rd party app to back up your databases, we offer SafetyNet(https://360works.com/filemaker-offsite-backup/) which backs up FMS hosted solutions to Amazon S3. On the topic of schema changes, we also have a product, 360Deploy(https://360works.com/filemaker-deploy-versions/), that makes deploying new FileMaker database versions to your prod server very easy. I hope that answers your questions. Let me know if you have more!
  14. Hello, We don't currently have a function or demo script that imports batches of information from FileMaker to a .xlsx. You would have to call ScribeDocLoad on the Excel file you want to manipulate(like a template file), loop through ScribeDocWriteValue calls to write values to specific cells in the Excel file, and then call ScribeDocSaveFile or ScribeDocSaveContainer to save the edited file. You can also use ScribeDocSubstitute to replace placeholder values if they already exist in your template file. If ever you'd like to hire a developer to expedite your process, we offer consultation services as well. I can put you in touch with our Project Coordinator to set that up, and we usually charge $185/hr. Let me know if you're interested in pursuing consultation work, otherwise I would use the approach outlined above, and reference our docs at https://static.360works.com/plugins/Scribe/documentation.html. If you run into any issues or have questions in your development, please contact us at our support line(support@360works.com; 770-234-9293).
  15. Hello, Sorry for the delay in response. Right now, Scribe is not capable of that functionality. It can only read a list of Sheets in an Excel file to FileMaker(ScribeDocListFields), and read/write values from/to target cells (identified as "[Sheet name]![Cell coordinate]") already present in an Excel file(ScribeDocReadValue, ScribeDocWriteValue). Here is a link to the functions currently available with Scribe.(https://static.360works.com/plugins/Scribe/documentation.html) I can submit a request to our developers to add such features to a future release of Scribe. I don't have a timeframe when that can be completed. If you'd like us to generate for you a custom plugin build, I can put you in touch with our Project Coordinator. They will set you up with one of our developers to create that plugin as consulting work, for which we typically charge $185/hr, and provide an estimate on how long it take the developer to fulfill the work you request. If you'd like to inquire about consulting work or if you have any other questions, please email us directly at support@360works.com or call us at 770-234-9293.
  • Create New...

Important Information

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