LANSync is the name of the synchronization functions within SI 5. The primary function of LANSync is to allow you to keep your Product Data consistent on all PCs running SI 5. LANSync also synchronizes some of the information from your Setup tab.
The graphic below represents a typical LANSync configuration:
Configuring LANSync
Once you've installed SI5, it is a good idea to establish your LANSync database on your server. To do this:
Note: Our Trial installation and Express Installation install both the SI5 Server and SI5 Client on the same machine. It is perfectly fine to establish your SI5 Server database from the SI5 Client on the same machine.
Once you've done your initial configuration for LANSync, your databases will stay in sync via the "Sync product data" function. When you choose to sync, a comparison (date/time) is made between records in your local SI5 database and your server SI5 database:
In addition to Product data, the following data from your Setup tab will also be synchronized:
The following tables from your Setup tab will NOT synchronize by default, they are listed in red:
In order to share changes (that have been made after your initial LANSync configuration) to the above data/tables with other users, you will need to use the [Copy Project Defaults] function, described below.
Additional setting can be made for LANSync. Here under the LANSync tab in the MMPD interface you have functions that allow you to re-configure your data on the server should you need to.
We recommend that you check both of the boxes: “Automatically synchronize when MMPD starts” and “Automatically synchronize when MMPD closes”.
This saves you the trouble of having to remember to synchronize. When you open and/or close MMPD, you will be prompted to sync (even though it says "automatically", you have to click [Yes] on the prompt):
Keep in mind, this prompt only occurs when you open the MMPD interface, not when you open or close SI5. There is an additional setting that will automatically (yes, actually automatic this time) sync your data when you login to SI5 (this only syncs when you login to SI5, not when you close SI5). This function can be accessed directly in the SI5 Navigator by selecting File->Sync Product Data on Startup:
[Synchronize Now] - this button synchronizes your data. This is the same as clicking the "Sync product data" links within the SI5 Navigator.
[Copy Down To Local] - this function is rarely used and should only be used if you ever have to re-established your server SI5 database from another machine using the [Copy Up To Server] function, described below. This button will copy the contents of the database on the SQL server to your local database, overwriting the data currently in your local SI5 database.
[Copy Up To Server] - this function is rarely used and should only be used if you wish to re-establish your server SI5 database. This step must be performed in order for LANSync to operate and is generally only done once, during the initial setup of SI 5 (occurs the first time you ever click the "Sync product data" function).
This step should be performed on the machine that has the “best” or “most current” database. This function copies your Product Data and Setup tab information from your local SI5 database to the server SI5 database. When you click this button, you will asked to verify the action:
Progress will display:
You will be notified when this completes:
Note: Following this procedure, all other Client machines must use the [Copy Down to Local] function prior to thier next synchronization.
[Copy Project Defaults] - This function should only be used when changes have been made to your Setup tab after you have initially configured LANSync. Not every table under the Setup tab synchronizes with our sync function so this is necessary if you want to share your changes with other users. This data includes: Status List, Location List, Project Staff, etc. This would only be done from a machine where the data has been verified and a decision has been made to share this data with all users. After using this function, the very next time that all other Clients synchronize they will get the changes you made.
[Resolve Conflicts] - Use this function to resolve any data conflicts that you are notified of.
Conflicts are rare but can occur when the following scenario takes place:
The date is 6/26/2007. The data on the SQL databasehas a Date/Time Stamp of “6/25/2007 5:35 PM” from the previous day’s work. Reed and Seth arrive at work, open MMPD, and synchronize with LANSync on each of their machines. Reed edits the pricing on a few items in the database at 11:59 AM and then heads out the door to lunch, leaving MMPDopen on his machine. Seth edits the same items at 12:35 PM and then synchronizes. When he synchronizes, the data that was edited was pushed out to the SQL databasewith a Date/Time Stamp of “6/26/2007 12:35 PM. Reed returns from lunch and decides to synchronize. The edits to the data that Reed made earlier are pushed out to the SQL databasewith a Date/Time Stamp of “6/26/2007 11:59 AM” which is earlier than the date of the data on the server (“6/26/2007 12:35 PM”). This is a “Conflict”.
When you click the [Resolve Conflicts] button, the following form will open where you can review the conflicts in your database:
The newest (based on date/time) record will be checked by default for each product with conflicts. You can manually go through and uncheck/check the correct records and then click [Resolve] for each conflict individually. If you are certain that you want all of the defaults to be the data you keep, click the [Resolve All] button.