http://docs.360works.com/index.php?title=MirrorSync_4_advanced_topics&feed=atom&action=historyMirrorSync 4 advanced topics - Revision history2024-03-29T00:31:03ZRevision history for this page on the wikiMediaWiki 1.19.1http://docs.360works.com/index.php?title=MirrorSync_4_advanced_topics&diff=2515&oldid=prevJoshua: /* Does MirrorSync work with timezones? */2018-09-17T21:35:06Z<p><span dir="auto"><span class="autocomment">Does MirrorSync work with timezones?</span></span></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr valign='top'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 21:35, 17 September 2018</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 476:</td>
<td colspan="2" class="diff-lineno">Line 476:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><b>Be SURE to uncheck the box titled 'Do not replace existing value of field (if any)'.</b>:</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><b>Be SURE to uncheck the box titled 'Do not replace existing value of field (if any)'.</b>:</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><pre></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><pre></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del class="diffchange diffchange-inline">Case</del>( <del class="diffchange diffchange-inline">Modification timestamp</del>; Get( <del class="diffchange diffchange-inline">CurrentHostTimeStamp </del>) )</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">Let </ins>( <ins class="diffchange diffchange-inline">x = _ModificationTimestamp </ins>; Get(<ins class="diffchange diffchange-inline">CurrentHostTimestamp </ins>) )</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></pre></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></pre></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
</table>Joshuahttp://docs.360works.com/index.php?title=MirrorSync_4_advanced_topics&diff=2481&oldid=prevJoshua: /* Installing without a network connection */2018-07-05T18:15:47Z<p><span dir="auto"><span class="autocomment">Installing without a network connection</span></span></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr valign='top'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 18:15, 5 July 2018</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 91:</td>
<td colspan="2" class="diff-lineno">Line 91:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div># Contact support@360works.com and ask for a customized build of MirrorSync that does not need a network connection for license checking. Be sure to include your license key and registration information.</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div># Contact support@360works.com and ask for a customized build of MirrorSync that does not need a network connection for license checking. Be sure to include your license key and registration information.</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div># Manually create a new folder at /Library/360Works (on Mac) or C:\Program Files\360Works (on Windows).</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div># Manually create a new folder at /Library/360Works (on Mac) or C:\Program Files\360Works (on Windows).</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div># Download Apache Tomcat <del class="diffchange diffchange-inline">7 </del>from <del class="diffchange diffchange-inline">http</del>://archive.apache.org/dist/tomcat/tomcat-<del class="diffchange diffchange-inline">7</del>/<del class="diffchange diffchange-inline">v7</del>.0.<del class="diffchange diffchange-inline">55</del>/bin/apache-tomcat-<del class="diffchange diffchange-inline">7</del>.0.<del class="diffchange diffchange-inline">55</del>.zip and extract it into the 360Works directory.</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div># Download Apache Tomcat <ins class="diffchange diffchange-inline">9 </ins>from <ins class="diffchange diffchange-inline">https</ins>://archive.apache.org/dist/tomcat/tomcat-<ins class="diffchange diffchange-inline">9</ins>/<ins class="diffchange diffchange-inline">v9</ins>.0.<ins class="diffchange diffchange-inline">2</ins>/bin/apache-tomcat-<ins class="diffchange diffchange-inline">9</ins>.0.<ins class="diffchange diffchange-inline">2</ins>.zip and extract it into the 360Works directory.</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>Now you should be able to run the installer without any network connection.</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>Now you should be able to run the installer without any network connection.</div></td></tr>
</table>Joshuahttp://docs.360works.com/index.php?title=MirrorSync_4_advanced_topics&diff=2479&oldid=prevJoshua: /* I am running MirrorSync 2. What do I need to do to upgrade to 3? */2018-06-28T21:38:40Z<p><span dir="auto"><span class="autocomment">I am running MirrorSync 2. What do I need to do to upgrade to 3?</span></span></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr valign='top'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 21:38, 28 June 2018</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 73:</td>
<td colspan="2" class="diff-lineno">Line 73:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><div id="upgradeFrom1"></div></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><div id="upgradeFrom1"></div></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>====I am running MirrorSync <del class="diffchange diffchange-inline">2</del>. What do I need to do to upgrade to <del class="diffchange diffchange-inline">3</del>?====</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>====I am running MirrorSync <ins class="diffchange diffchange-inline">3</ins>. What do I need to do to upgrade to <ins class="diffchange diffchange-inline">4</ins>?====</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del class="diffchange diffchange-inline">Read </del>the <del class="diffchange diffchange-inline">documentation </del>on this at <del class="diffchange diffchange-inline">[[Updating </del>from MirrorSync <del class="diffchange diffchange-inline">2 </del>to 3<del class="diffchange diffchange-inline">]]</del></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">MirrorSync 4 configurations are not compatible with version 3 configurations. Before running this update, either ensure that all users with version 3.x offline files have synced all of their charges to </ins>the <ins class="diffchange diffchange-inline">server, or install MirrorSync 3 and 4 at the same time (see next paragraph). You will need to distribute new offline files for your users to have the MirrorSync 4 configuration.</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div> </div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">To ease the migration process, you may run MirrorSync 3 and 4 at the same time, </ins>on <ins class="diffchange diffchange-inline">the same server, without conflicting. If you'd like to do </ins>this<ins class="diffchange diffchange-inline">, choose the 'Hosting provider' option during installation and select a different application name than the default 'MirrorSync' name. For instance, you coud install it with the name 'MirrorSync4', which would allow you to continue running MirrorSync 3 </ins>at <ins class="diffchange diffchange-inline">the regular name 'MirrorSync'. You can configure MirrorSync 3 and MirrorSync 4 configurations in the same hosted FileMaker database, so that users with older offline files can continue to sync using the MirrorSync 3 configuration, while users with newer offline files will sync using the MirrorSync 4 configuration.</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div> </div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">Configurations </ins>from <ins class="diffchange diffchange-inline">version 3 can be imported into version 4, so you may choose to export your </ins>MirrorSync <ins class="diffchange diffchange-inline">3 configuration </ins>to <ins class="diffchange diffchange-inline">save some setup work in MirrorSync 4. Be sure to export these configurations BEFORE running the update to version 4 - you will not be able to export them after the upgrade. If you do decide to create new configurations, there are no changes needed to your FileMaker fields or layouts, so creating a new configuration should be relatively quick.</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div> </div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">You can use your existing MirrorSync </ins>3 <ins class="diffchange diffchange-inline">license key with MirrorSync 4, as long as you have up-to-date maintenance coverage for your MirrorSync 3 maintenance license (12 months from the date of purchase for MirrorSync is automatically covered, and can be renewed each year for 25% of the retail value).</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div> </div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">Updating MirrorSync only requires to you to double-click the installer and follow the instructions. You do not need to uninstall the previous version. In fact, if you do, you will lose any customizations you have made to the MirrorSync.xml file.</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div> </div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">If you encounter any problems during syncing, PLEASE use the 'send problem report' link on the MirrorSync launch page. This is much more useful than sending us an email. If you do email us, we will probably ask you to resubmit using that link, because that sends us the detailed sync log file, which is necessary to solve most tech support issues.</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>==== Installing without a network connection ====</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>==== Installing without a network connection ====</div></td></tr>
</table>Joshuahttp://docs.360works.com/index.php?title=MirrorSync_4_advanced_topics&diff=2475&oldid=prevJoshua: /* Can I pre-populate my offline database to speed up initial sync? */2018-06-22T21:25:33Z<p><span dir="auto"><span class="autocomment">Can I pre-populate my offline database to speed up initial sync?</span></span></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr valign='top'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 21:25, 22 June 2018</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 692:</td>
<td colspan="2" class="diff-lineno">Line 692:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* Import the records you want from the main file into the mobile file. Be sure to <b>uncheck</b> the box that says "Perform auto-enter options while importing". The primary keys, modification timestamps, and creation timestamps need to match between the mobile file and the server file. Make sure that you import most or all of the records that the user will have access to during the sync - it's faster for MirrorSync to sync an empty table than a table that has a small fraction of the desired records.</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* Import the records you want from the main file into the mobile file. Be sure to <b>uncheck</b> the box that says "Perform auto-enter options while importing". The primary keys, modification timestamps, and creation timestamps need to match between the mobile file and the server file. Make sure that you import most or all of the records that the user will have access to during the sync - it's faster for MirrorSync to sync an empty table than a table that has a small fraction of the desired records.</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* If you do not import all of the records in a table, be sure to modify your MirrorSync customization script (if using XML) or your SQL qualifier (if using JDBC) to exclude the records that you do not import. If you fail to do this correctly, it will lead to records on the server being deleted during the initial sync (see more details below).</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* If you do not import all of the records in a table, be sure to modify your MirrorSync customization script (if using XML) or your SQL qualifier (if using JDBC) to exclude the records that you do not import. If you fail to do this correctly, it will lead to records on the server being deleted during the initial sync (see more details below).</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>* After the import, <del class="diffchange diffchange-inline">create a new record in </del>the MirrorSync <del class="diffchange diffchange-inline">table on </del>the <del class="diffchange diffchange-inline">hosted database. Set </del>the type to 'Server'. Modify the sync4 field (you'll need to switch to layout mode to see which one that is), and set it to the timestamp when you ran the import, using the format 'YYYY-MM-DD hh:mm:ss' (in 24 hour time). <b>Note:</b> If you are not syncing with FileMaker Server (ex. MySQL<->FileMakerPro/Go) you will make this change in the offline file.</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>* After the import, <ins class="diffchange diffchange-inline">open your separate hosted mobile solution. Go to </ins>the MirrorSync <ins class="diffchange diffchange-inline">layout and click </ins>the <ins class="diffchange diffchange-inline">internal tab, find </ins>the <ins class="diffchange diffchange-inline">record with type 'Server' (create new record if necessary and set </ins>type to 'Server'<ins class="diffchange diffchange-inline">)</ins>. Modify the sync4 field (you'll need to switch to layout mode to see which one that is), and set it to the timestamp when you ran the import, using the format 'YYYY-MM-DD hh:mm:ss' (in 24 hour time). <b>Note:</b> If you are not syncing with FileMaker Server (ex. MySQL<->FileMakerPro/Go) you will make this change in the offline file.</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* Make sure that your offline users run a sync before making any database changes. Any new records that they create in the mobile file will be <b>deleted</b> during the initial sync. It's OK for them to add new records normally after the initial sync has successfully completed.</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* Make sure that your offline users run a sync before making any database changes. Any new records that they create in the mobile file will be <b>deleted</b> during the initial sync. It's OK for them to add new records normally after the initial sync has successfully completed.</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* It's easy to make a mistake in this process. Don't hesitate to contact 360Works support if you'd like help with this.</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* It's easy to make a mistake in this process. Don't hesitate to contact 360Works support if you'd like help with this.</div></td></tr>
</table>Joshuahttp://docs.360works.com/index.php?title=MirrorSync_4_advanced_topics&diff=2474&oldid=prevJoshua: /* Updating Timeout on Mac OS X */2018-06-22T20:05:17Z<p><span dir="auto"><span class="autocomment">Updating Timeout on Mac OS X</span></span></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr valign='top'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 20:05, 22 June 2018</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 971:</td>
<td colspan="2" class="diff-lineno">Line 971:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>Instructions + reference images for increasing this timeout on Windows in Internet Information Services (IIS): [[Update IIS timeout]]</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>Instructions + reference images for increasing this timeout on Windows in Internet Information Services (IIS): [[Update IIS timeout]]</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>===== Updating Timeout on Mac OS X =====</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>===== Updating Timeout on Mac OS X <ins class="diffchange diffchange-inline">FileMaker Server 15</ins>=====</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>To increase this timeout on FileMaker's built in Apache webserver, open up this file in a text editor of your choosing: <code>/Library/FileMaker Server/Admin/admin-helper/WEB-INF/conf/mod_proxy.conf</code>  </div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>To increase this timeout on FileMaker's built in Apache webserver, open up this file in a text editor of your choosing: <code>/Library/FileMaker Server/Admin/admin-helper/WEB-INF/conf/mod_proxy.conf</code>  </div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">* Locate this line:</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">** <code>ProxyPass /fmi/ http://127.0.0.1:16021/fmi/</code></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">* And change it to this:</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">** <code>ProxyPass /fmi/ http://127.0.0.1:16021/fmi/ timeout=600</code></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">*** <code>timeout=600</code> denotes a 10 minute timeout. Adjust as necessary, where 1200 is 20 minutes, 3600 is an hour, etc.</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">* Now restart FileMaker's built in Apache webserver using the following command in Terminal:</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">** <code>fmsadmin restart httpserver</code></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">If for some reason you get your timeout up to 7200 (2 hours) and still fail in your testing, subsequent timeout updates need to be changed in an additional file.</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">File: <code>/Library/FileMaker Server/HTTPServer/conf/httpd.conf</code></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">* Locate this line:</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">** <code>ProxyPass /MirrorSync ajp://127.0.0.1:42423/MirrorSync retry=1 timeout=7200</code></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">*** Keep in mind the <code>/MirrorSync</code> portion is dependant upon your installation method. If you installed using a hosting provider install, this portion will be whatever name you set during the installation.</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">* Update the <code>timeout=7200</code> designation to whatever you're updating your mod_proxy.conf to.</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">Finally, restart the httpserver as your would in the normal process.</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">===== Updating Timeout on Mac OS X  FileMaker Server 16+=====</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">To increase this timeout on FileMaker's built in Apache webserver, open up this file in a text editor of your choosing: <code>/Library/FileMaker Server/HTTPServer/conf/extra/httpd-proxy-fmiwebd.conf</code> </ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* Locate this line:</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* Locate this line:</div></td></tr>
</table>Joshuahttp://docs.360works.com/index.php?title=MirrorSync_4_advanced_topics&diff=2473&oldid=prevJoshua: /* How do I migrate MirrorSync from one server to another? */2018-06-13T15:36:44Z<p><span dir="auto"><span class="autocomment">How do I migrate MirrorSync from one server to another?</span></span></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr valign='top'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 15:36, 13 June 2018</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 91:</td>
<td colspan="2" class="diff-lineno">Line 91:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div># Stop Tomcat on the old server, by using the utility at C:\Program Files\360Works\360Works Admin.jar or /Applications/360Work Admin.jar</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div># Stop Tomcat on the old server, by using the utility at C:\Program Files\360Works\360Works Admin.jar or /Applications/360Work Admin.jar</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div># Uninstall MirrorSync on the old computer (because a license key can only run on one server at a time).</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div># Uninstall MirrorSync on the old computer (because a license key can only run on one server at a time).</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div># Copy the folder at C:\Program Files\360Works\<del class="diffchange diffchange-inline">SyncData2_MirrorSync </del>or /Library/360Works/<del class="diffchange diffchange-inline">SyncData2_MirrorSync </del>to the new computer. Make sure you have matched the file permissions from the previous computer.</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div># Copy the folder at C:\Program Files\360Works\<ins class="diffchange diffchange-inline">SyncData4_MirrorSync </ins>or /Library/360Works/<ins class="diffchange diffchange-inline">SyncData4_MirrorSync </ins>to the new computer. Make sure you have matched the file permissions from the previous computer.</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div># Install MirrorSync on the new computer.</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div># Install MirrorSync on the new computer.</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div># Run the MirrorSync admin utility. Edit the configuration and modify the addresses of the MirrorSync server if necessary. In the last step of the process where you copy and paste the script steps into the MirrorSync script, <b>be sure to first delete the 'MirrorSync_internal' and 'MirrorSync_external' items from the list of external data sources</b>. They will be recreated with updated values when you paste the script steps.</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div># Run the MirrorSync admin utility. Edit the configuration and modify the addresses of the MirrorSync server if necessary. In the last step of the process where you copy and paste the script steps into the MirrorSync script, <b>be sure to first delete the 'MirrorSync_internal' and 'MirrorSync_external' items from the list of external data sources</b>. They will be recreated with updated values when you paste the script steps.</div></td></tr>
</table>Joshuahttp://docs.360works.com/index.php?title=MirrorSync_4_advanced_topics&diff=2466&oldid=prevJesse: Documentation for doing an initial sync with a pre-populated database, and it causes records to be deleted on the server2018-05-29T14:44:04Z<p>Documentation for doing an initial sync with a pre-populated database, and it causes records to be deleted on the server</p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr valign='top'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 14:44, 29 May 2018</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 691:</td>
<td colspan="2" class="diff-lineno">Line 691:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><b>If you are syncing with a separate mobile file that you want to pre-populate</b>, here are the steps to follow:</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><b>If you are syncing with a separate mobile file that you want to pre-populate</b>, here are the steps to follow:</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* Import the records you want from the main file into the mobile file. Be sure to <b>uncheck</b> the box that says "Perform auto-enter options while importing". The primary keys, modification timestamps, and creation timestamps need to match between the mobile file and the server file. Make sure that you import most or all of the records that the user will have access to during the sync - it's faster for MirrorSync to sync an empty table than a table that has a small fraction of the desired records.</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* Import the records you want from the main file into the mobile file. Be sure to <b>uncheck</b> the box that says "Perform auto-enter options while importing". The primary keys, modification timestamps, and creation timestamps need to match between the mobile file and the server file. Make sure that you import most or all of the records that the user will have access to during the sync - it's faster for MirrorSync to sync an empty table than a table that has a small fraction of the desired records.</div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">* If you do not import all of the records in a table, be sure to modify your MirrorSync customization script (if using XML) or your SQL qualifier (if using JDBC) to exclude the records that you do not import. If you fail to do this correctly, it will lead to records on the server being deleted during the initial sync (see more details below).</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* After the import, create a new record in the MirrorSync table on the hosted database. Set the type to 'Server'. Modify the sync4 field (you'll need to switch to layout mode to see which one that is), and set it to the timestamp when you ran the import, using the format 'YYYY-MM-DD hh:mm:ss' (in 24 hour time). <b>Note:</b> If you are not syncing with FileMaker Server (ex. MySQL<->FileMakerPro/Go) you will make this change in the offline file.</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* After the import, create a new record in the MirrorSync table on the hosted database. Set the type to 'Server'. Modify the sync4 field (you'll need to switch to layout mode to see which one that is), and set it to the timestamp when you ran the import, using the format 'YYYY-MM-DD hh:mm:ss' (in 24 hour time). <b>Note:</b> If you are not syncing with FileMaker Server (ex. MySQL<->FileMakerPro/Go) you will make this change in the offline file.</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* Make sure that your offline users run a sync before making any database changes. Any new records that they create in the mobile file will be <b>deleted</b> during the initial sync. It's OK for them to add new records normally after the initial sync has successfully completed.</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* Make sure that your offline users run a sync before making any database changes. Any new records that they create in the mobile file will be <b>deleted</b> during the initial sync. It's OK for them to add new records normally after the initial sync has successfully completed.</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* It's easy to make a mistake in this process. Don't hesitate to contact 360Works support if you'd like help with this.</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* It's easy to make a mistake in this process. Don't hesitate to contact 360Works support if you'd like help with this.</div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">If you do an initial sync with a pre-populated database, and it causes records to be deleted on the server, it's because the records being deleted were 1) not imported into the offline files, and 2) were not excluded by the MirrorSync customization script. In this case, MirrorSync sees that these records are missing from the offline file, and also that they exist on the server with an old modification timestamp, so it assumes that they were deleted on the offline file and proceeds to delete them on the server.</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">You can test to see if the customization script is excluding the records (as it should) by going to the sync layout in question, finding all records (or a specific one that you want to test), then running the MirrorSync customization script with no parameters. If the record is removed from the found set, then it is being correctly filtered out. If it remains in the found set, then it is not being filtered out, and will be deleted on the server during the initial sync if that record does not exist on the offline file.</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>=== Security ===</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>=== Security ===</div></td></tr>
</table>Jessehttp://docs.360works.com/index.php?title=MirrorSync_4_advanced_topics&diff=2465&oldid=prevJoshua: /* Server-to-server sync */2018-05-25T20:59:10Z<p><span dir="auto"><span class="autocomment">Server-to-server sync</span></span></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr valign='top'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 20:59, 25 May 2018</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 556:</td>
<td colspan="2" class="diff-lineno">Line 556:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div># By checking the 'Auto Sync' checkbox in the MirrorSync configuration client, and selecting a desired frequency in seconds. This will continue to run as a background service, even if the MirrorSync configuration client is quit.</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div># By checking the 'Auto Sync' checkbox in the MirrorSync configuration client, and selecting a desired frequency in seconds. This will continue to run as a background service, even if the MirrorSync configuration client is quit.</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div># By running the MirrorSync script in FileMaker Pro / Go which is connected as a guest of FileMaker Server.</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div># By running the MirrorSync script in FileMaker Pro / Go which is connected as a guest of FileMaker Server.</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del class="diffchange diffchange-inline"># By triggering the sync URL, which can be found in the MirrorSync script. Contact 360Works for assistance with this.</del></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div> </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>==== How can I be notified of a problem that occurs during server-to-server sync? ====</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>==== How can I be notified of a problem that occurs during server-to-server sync? ====</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>There is an administrative e-mail address that is set during MirrorSync configuration. If you set this, you will receive e-mail notifications whenever the sync fails (or succeeds, depending on what granularity you set admin e-mails to). These e-mails are sent via Amazon Web Services, and thus do not require you to configure an SMTP server.</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>There is an administrative e-mail address that is set during MirrorSync configuration. If you set this, you will receive e-mail notifications whenever the sync fails (or succeeds, depending on what granularity you set admin e-mails to). These e-mails are sent via Amazon Web Services, and thus do not require you to configure an SMTP server.</div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">==== How can I trigger a Server-to-Server sync by URL? ====</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">Launch your MirrorSync Configuration Client and select the Server-to-Server configuration you want to build the URL for.  After selecting the name, click on the Export button to export that configuration to a text file.  In that text file search for "triggerUUIDs".  You will need to copy that value down.  The URL will be formated like this</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"><pre></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">http://yourserveraddress/MirrorSync/triggerSync/triggerUUIDs?wait </ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"></pre></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">So if your HUB server address is example.com and your triggerUUID value was 99e89e3b-8d54-469d-9678-0f8afa580c51 the URL you would need to initiate a Server-to-Server sync would be</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"><pre></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">http://example.com/MirrorSync/triggerSync/99e89e3b-8d54-469d-9678-0f8afa580c51?wait</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"></pre></ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>===Performance questions===</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>===Performance questions===</div></td></tr>
</table>Joshuahttp://docs.360works.com/index.php?title=MirrorSync_4_advanced_topics&diff=2442&oldid=prevJperez: /* Troubleshooting/Known Issues */2018-05-08T20:23:55Z<p><span dir="auto"><span class="autocomment">Troubleshooting/Known Issues</span></span></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr valign='top'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 20:23, 8 May 2018</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 1,122:</td>
<td colspan="2" class="diff-lineno">Line 1,122:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>If this occurs, and if you are running MirrorSync on a Linux server, make sure that you have the regular version of Java installed, rather than the headless version.</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>If this occurs, and if you are running MirrorSync on a Linux server, make sure that you have the regular version of Java installed, rather than the headless version.</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">====805 File is damaged. Use Recover====</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">This is often resolved by stopping and starting xDBC in the server admin console</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">====Container data appears corrupt, can't be opened, reduced in size====</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">If you use scripts to insert data into your containers, be wary of the options selected for the "insert file" dialogue. If "compress when possible" or "allow user to choose" is selected, it's likely that some of the container data will be compressed when syncing. On the receiving end, FileMaker doesn't seem to know how to handle the inserted file. </ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">[[File:InsertFileDialog.png|300px|thumb|center]]</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td colspan="2" class="diff-lineno">Line 1,128:</td>
<td colspan="2" class="diff-lineno">Line 1,134:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><center>[[File:ReturntoMainPage.png| 140 px |link=http://www.360works.com/products/ |alt= 360Works Plugins for FileMaker |FileMaker Help]]</center></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><center>[[File:ReturntoMainPage.png| 140 px |link=http://www.360works.com/products/ |alt= 360Works Plugins for FileMaker |FileMaker Help]]</center></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del style="color: red; font-weight: bold; text-decoration: none;"></del></div></td><td colspan="2"> </td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del style="color: red; font-weight: bold; text-decoration: none;">====805 File is damaged. Use Recover====</del></div></td><td colspan="2"> </td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del style="color: red; font-weight: bold; text-decoration: none;">This is often resolved by stopping and starting xDBC in the server admin console</del></div></td><td colspan="2"> </td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del style="color: red; font-weight: bold; text-decoration: none;"></del></div></td><td colspan="2"> </td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del style="color: red; font-weight: bold; text-decoration: none;">====Container data appears corrupt, can't be opened, reduced in size====</del></div></td><td colspan="2"> </td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del style="color: red; font-weight: bold; text-decoration: none;">If you use scripts to insert data into your containers, be wary of the options selected for the "insert file" dialogue. If "compress when possible" or "allow user to choose" is selected, it's likely that some of the container data will be compressed when syncing. On the receiving end, FileMaker doesn't seem to know how to handle the inserted file. </del></div></td><td colspan="2"> </td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del style="color: red; font-weight: bold; text-decoration: none;">[[File:InsertFileDialog.png]]</del></div></td><td colspan="2"> </td></tr>
</table>Jperezhttp://docs.360works.com/index.php?title=MirrorSync_4_advanced_topics&diff=2441&oldid=prevJperez: /* Container data appears corrupt, can't be opened, reduced in size */2018-05-08T20:22:25Z<p><span dir="auto"><span class="autocomment">Container data appears corrupt, can't be opened, reduced in size</span></span></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr valign='top'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 20:22, 8 May 2018</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 1,133:</td>
<td colspan="2" class="diff-lineno">Line 1,133:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>====Container data appears corrupt, can't be opened, reduced in size====</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>====Container data appears corrupt, can't be opened, reduced in size====</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>If you use scripts to insert data into your containers, be wary of the options selected for the "insert file" dialogue. If "compress when possible" or "allow user to choose" is selected, it's likely that some of the container data will be compressed when syncing. On the receiving end, FileMaker doesn't seem to know how to handle the inserted file.</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>If you use scripts to insert data into your containers, be wary of the options selected for the "insert file" dialogue. If "compress when possible" or "allow user to choose" is selected, it's likely that some of the container data will be compressed when syncing. On the receiving end, FileMaker doesn't seem to know how to handle the inserted file. </div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">[[File:InsertFileDialog.png]]</ins></div></td></tr>
</table>Jperez