Difference between revisions of "HOWTO:Sync And Purge"
From WireCAD Online Help
Wirecadadmin (Talk | contribs) (Created page with "{{PageHeader |shortcut=Varied |perms=All |level=XLT PRO |desc=Sync with and purge undesirable data.}}<br> {{warning|Backup your database before doing this. I'm not kidding.}} _...") |
Wirecadadmin (Talk | contribs) |
||
| Line 1: | Line 1: | ||
{{PageHeader | {{PageHeader | ||
| − | |shortcut= | + | |shortcut=NONE |
|perms=All | |perms=All | ||
|level=XLT PRO | |level=XLT PRO | ||
| Line 18: | Line 18: | ||
== Proceedure == | == Proceedure == | ||
# Back up your database. Did I say that? | # Back up your database. Did I say that? | ||
| − | # | + | # Open your global Manufacturers database. Database>Manufacturers Grid. |
| + | # 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. | ||
| + | # 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. | ||
| + | ## Enter 1 in the top row. | ||
| + | ## Drag from the top row to the bottom row. Be careful to only select the [User Added] column. | ||
| + | ## Click Edit>Copy Down. This will copy 1(this top row) into all the cells in the [User Added] column. | ||
| + | ## Click File>Save. | ||
Revision as of 13:47, 13 February 2012
| Command Line Shortcut: NONE User Permissions Level: All |
 Warning: Backup your database before doing this. I'm not kidding.
|
Contents
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
- Back up your database. Did I say that?
- Open your global Manufacturers database. Database>Manufacturers Grid.
- 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.
- 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.
- Enter 1 in the top row.
- Drag from the top row to the bottom row. Be careful to only select the [User Added] column.
- Click Edit>Copy Down. This will copy 1(this top row) into all the cells in the [User Added] column.
- Click File>Save.
