HOWTO:Sync And Purge

Command Line Shortcut: NONE User Permissions Level: All Product Level: XLT PRO Sync with and purge undesirable data.

---

---

Warning: Backup your database before doing this. I'm not kidding.

---

Before You Start

Backup your database before doing this. Your global database may be on your local machine or on a network share or a SQL server. We can't tell from here. You will need to figure this out so you can properly back up. See these topics on file location:

Proceedure

1. Back up your database. Did I say that?
2. Open your global Manufacturers database. Database>Manufacturers Grid.
3. We will be using the [User Added] field to store a flag ([User Added] is the only user field in this table) that we can filter on later. If the [User Added] field does not show in the grid, right-click any column header and click Column Chooser, then drag the [User Added] field onto the column header row.
4. Populate the [User Added] field with some known data that we can filter on later. For purposes of this tutorial we will use "1" as the flag but you can substitute anything you like.
   1. Enter 1 in the top row.
   2. Drag from the top row to the bottom row. Be careful to only select the [User Added] column.
   3. Click Edit>Copy Down. This will copy 1(this top row) into all the cells in the [User Added] column.
   4. Click File>Save.