Trail Blazer Knowledge Base

 

Home : Using Trail Blazer : Copying Attributes From One Database To Another

Knowledge Base







User:

Password:



Article ID: KB176
Keyword Name: Moving, Synching, Tree, Categories, Categorization, Multiple, DB
Created: February 06, 2013
Viewed: 11808

Copying Attributes From One Database To Another

Overiew

 

In this article we will show you how you can copy attributes from voters/donors in one database to another database.

 

There are a few ways to do this.  In this case I going to assume you have a large list (over 100,000 records).  I’m going to give you the method with the least amount of work, but the most counter-intuitive.

 

Steps

 

The first step is to create a format that contains ONLY what you need.  The SOS is the linking value between the two databases.

 

(for more information on Formats, see http://www.trailblz.com/kb/?action=view&kb=50&cat=1 or http://www.youtube.com/watch?v=zeQO4kmKTQg)

 

 

Although the ID column is not needed in this case, our system does require that column be present.  You just won’t be using it.

 

Next, export the 500k records to a CSV file.

 

It will look like this in Excel:

 

 

You will need to eliminate all the 0’s from columns C through G.

 

Import the resulting file:

 

 

The SOS will match automatically.  You will need to match the attribute columns as shown below.  Do NOT attempt to match by the ID column.  This is the ID column that Trail Blazer assigns to every voter/donor record.  This will NOT match any other database.

 

 

Once imported, you will have an Attribute Tree that looks something like this:

 

 

Now create a Group folder or whatever name you wish.

 

 

Drag the other folders INTO the Group folder one at a time.  You will see messages like this:

 

 

My Attribute Tree now looks like this:

 

 

If I expand Group:

 

 

You will notice each of your attributes is now a folder.  You will need to expand the folders to see the value that was imported.

 

 

If you rename all the 1 folders to the same name as its parent folder you can then drag them to the Group folder and delete the empty parent folder.

 

 

In the photo below I have renamed the 1 folders, moved them to the Group folder and deleted the original parent folder.  It now looks like the source database.

 

 

Are you ready to learn more? Contact Us