MirrorSync will automatically detect which fields are eligible for mapping, and display them in the next window. Confirm that the diagram is correct by pressing Next. If the table does not use a foreign key, leave that table’s row blank.įrom that information, MirrorSync will pull an Entity Relationship Diagram mapping out the relationships between tables. A foreign key is a unique number or ID that is used to relate tables. If there are multiple, enter the first selection for a table and a new line will appear. Therefore, there is never a need to re-write foreign keys. When using UUIDs, the primary keys stay the same on every device because there is no possibility of conflict. MirrorSync needs to know which foreign keys which point to the primary keys, in order to write the new primary key value to each foreign key. When using serial numbers, primary keys can be (and usually are) re-numbered when they are transferred to another device. This screen will not appear if you are using UUIDs as a primary key. In the next screen, choose the foreign keys and primary keys for each table. The Primary Key 2 field is optional and would be used if it were a join table that had multiple foreign keys, rather than a simple unique primary key. Next, choose the Primary Key and Modification Timestamp fields in MirrorSync. Then select these new sync layouts in MirrorSync. After creating these layouts without summary fields and excess data, be sure to include the primary key and modification timestamp. At the moment, container fields are not supported with MirrorSync.Įvery table requires a primary key and a modification timestamp. An easy way to tell would be looking for a green hourglass in layout mode- if it doesn’t have one it’s a summary field. Be sure to remove any summary fields, related fields, global fields, and calculations unless they are read only while implementing a one-way sync. It is a good idea to create layouts specifically for MirrorSync, as this will sync only the fields the users require. Enter a description, host, username and password for the database, and select the database.Īfter entering that information, MirrorSync pulls up a list of layout names and asks which tables should be synced. Next, enter the information for the database that already exists. For a simple backup solution, consider 360Works SafetyNet. However, UUIDs are unavailable in FIleMaker 11.īe sure the database is fully backed up before implementing MirrorSync. They are also more secure, as sequential IDs are easily guessed. UUIDs are preferable for several reasons, as they can be randomly generated on the offline copy and never happen to generate an ID that is already in use. UUID Universally Unique IDentifiers: are randomly generated combinations of numerals and letters with 36 total characters. For example, 101, 102, 103 might be examples of sequential primary keys. Sequential primary keys these keys are auto-incremented numerals. ![]() ![]() One way syncs could be used, for example, to push changes from an iPad to FileMaker Server. One way sync changes from a source database are written to a destination database. ![]() Select the options that are most relevant to your configuration.īidirectional sync changes from either database are written to the other database. You may also import a configuration from this main screen, or edit existing configurations. To create a new MirrorSync, choose “Add” from the main screen. Log in using the username and password selected at the installation of MirrorSync. The digital signature from 360Works has been verified." Select Allow to continue.Īfter installation on FileMaker Server, users may configure the synchronization from any computer with access by navigating to where servername is replaced with the address of the server.īlue question marks appear where more information and help is available. A second security dialog might appear after, asking "The application 'MirrorSync' from 'ServerName' is requesting access to your computer. A security dialog may appear, asking to enable the applet plug-in and Web Start applications. If you are still having problems, 360Works offers custom database development, including MirrorSync integration.Īfter pressing “Launch MirrorSync Client,” a desktop application will download and begin to walk you through the configuration process. You can also watch a video of the installation here, or read through the following steps below. If you have a question, hover over the blue question marks to see helpful tooltips. We try to make the configuration process as simple as possible.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |