Trail Blazer Knowledge Base

 

Home : General : Import Information - Definitions and Column Data Type

Knowledge Base







User:

Password:



Article ID: KB118
Keyword Name: Coulmn Data Type
Created: June 01, 2010
Viewed: 15078

Import Information - Definitions and Column Data Type

Import Information

1: Definitions


Table Name – The table name must not have any blank (TAB, Space) spaces and must not have any non-alpha characters. (Only a-z or A-Z)


Column Heading – The column heading must not start with any non-alpha characters. (Only a-z or A-Z) But can contain non-alpha after the first character (1-9, !, @, #, $, %, ^, &, _, ) but can not contain any math characters ( -, +, *, /, ( , ) ) .


2: Column Data Type

Standard Column Data Type – When importing the column data types will mostly be in the "Text" format.

Some exceptions to Column Data Types

"alt e-mail flag" is of type "Yes/No" (otherwise called Boolean or Bool)

"Amount" and "Amount from other" are type "Number" with field size set to "Decimal"

Birth Date (three available types: Text, Date/Time, Number)

"Birth Date String YYYYMMDD" is of type "Text" and must be in the YYYYMMDD format

"Birth Date" is of type "Date/Time"

"Birth Date Year Only" is of type "Number" field size set to "Integer" or "Long Integer" will set month and day to 1. (everyone will have 1/1/YYYY as birth date)


"Credit Card Expiration" is of type "Date/Time"


"Date" is of type "Date/Time"

Head of Household (three available types: Text, Date/Time, Number) in Trail Blazer is a Boolean value (True/False, binary value 1 or 0)

"Head of Household/Bool" is of type "Yes/No" (otherwise called Boolean or Bool) if Yes then set to true (1).

"Head of Household/Int" is of type "Number" field size set to "Integer" or "Long Integer" if integer is "1" then set to true (1).

"Head of Household/String" is of type "Text" if value is "H" then set to true (1).

Party (Two available types: Text, Number)

"Party ID" is of type "Number" field size set to "Integer" or "Long Integer"
This Party ID is a ranked system you MUST have 5 Groups setup to use this if integer is: 1 = "Dem1", 2 = "Dem2", 3 = "Center3", 4 = "GOP4", 5 = "GOP5".
Because it is a ranked system we do not set the party code just a group, if you wish to set the code after loaded this is possible.

"party", "setpartybyprimary" and "setpartybyprimary2" are of type "Text" and is looking for either the federal 3 character code (Federal Party Code ) for the party or the full name of the party. See attached Party List. If it is not on the list it will take the first 3 characters of the text line and make that the party code - NOTE this may conflict with something else. One major note if you have "setpartybyprimary" you must have "setpartybyprimary2" and the "party" can not be used (if it is it will get over written).

"PCR Date" is of type "Date/Time"


Registration Date (two available types: Text, Date/Time)

"Reg Date String YYYYMMDD" is of type Text and must be in the YYYYMMDD format.

"Registration Date" is of type "Date/Time"

Builder Fields

Address – In this section we are refering to If the Address is broken down into 2 or more columns use the following tools to build the address column.

Street Number
If your address line is broken down into 2 columns use this tool. (Number and Name) Note if you have an Address column this will over ride that information. Do not use, call Trail Blazer Campaign Services Inc support for help.

HouseNumBuilder1, HouseNumBuilder2, HouseNumBuilder3
If the House number (Street Number) portion of your address line is broken down into 2-3 columns use this tool. This creates a Street Number column. Note if you have an Address or Street Number column this will over ride that information. Do not use, call Trail Blazer Campaign Services Inc support for help.

Street Name
If the address line is broken down into 2 columns use this tool. (Number and Name) Note if you have an Address column this will over ride that information. Do not use, call Trail Blazer Campaign Services Inc support for help.

StreetBuilder1, StreetBuilder2, StreetBuilder3, StreetBuilder4
If the Street (Street Name) portion of your address line is broken down into 2-4 columns use this tool. (Name, Type, Direction) This tool creates a Street Name column. Note if you have an Address or Street Name column this will over ride that information. Do not use, call Trail Blazer Campaign Services Inc support for help.

Address 2 - If your Address 2 is broken down into 2 columns us the following tools to build the address column.

AptBuilder1 and AptBuilder2 – Apartment Builder columns
If the address line 2 is broken down into 2 columns, a descriptor ("Unit","Apt") and a number or designation ("1", "1A", "Left", "Top"). You will have the descriptor be AptBuilder1 and the number or designation assigned to AptBuilder2. Note if you have an Address 2 column this will over ride that information. Do not use, call Trail Blazer Campaign Services Inc support for help.

Phone – If the home phone is broken down into 2 -3 columns us the following tools to build the Home Phone column.

PhoneBuilder1, PhoneBuilder2, PhoneBuilder3
If the Home Phone number is broken down into 2-3 columns use this tool. This creates a Home Phone column. Note if you have an Home Phone column this will over ride that information. Do not use, call Trail Blazer Campaign Services Inc support for help.

Combined Fields

City State Zip – If the City State and Zip is combined in one column use "CityStateZip" to extract the 3 separate fields..

Full Name – If the entire Name is combined in one column use "Full Name" to extract the fields: Title, First, Middle, Last, Suffix.

 

Are you ready to learn more? Contact Us