Page History

...

ABOUT THE IMPORT PAGEThese instructions are for integrating participants' data collected from a Survey (i.e., SurveyMonkey, Qualtrics) to Revolution Database Excel Import Template.

...

Depending on criteria used for the survey, different studies will collect different information (different columns will be filled in)

...

. In order to have a successful import, you must make sure the order of the columns of information and the information in the cells are in a specific format

...

. Missing cell values are OK as long as the important cells are filled out

• Family Address
• Family Phone Number
• "Self"
• Biological Relationship
• First/Last Name
• Date of Birth
• "Self" Contact Number

Table of Contents 

1. Enabling Import File
2. Overall Structure of the template
3. General Copy and Paste Instruction (Copying only values)
4. Inputting Information and Formating
   1. Family Information
      1. Address, Address 2, Town or City, Postal Code, and Country
      2. Family Phone
      3. Family Email
   2. Individual Information
      1. Dropdown Field
         • Household Status
         • Biological Relation
         • Sex
         • Pregnancy
         • Marital Status
         • Highest Education
         • Mobile Carrier
         • Public Assistance
         • Ethnicity
      2. Multiple Selection Fields
         • Race
         • Preferred Contact Method
         • Preferred Contact Time
         • Health Conditions
      3. Text Fields
         • Study Name
         • First Name, Middle Name, Last Name, Suffix, and Other Text Fields
         • Health Condition Text Fields, Medications and Dietary Restrictions
      4. Numeric Fields
         • Phone
         • Height, Weight and other numeric fields
      5. Dates: format of YYYY-MM-DD
         • Date of Birth, Measurement Date, Status Date, and other date fields
5. Final Steps (Importing a survey file to database steps)

...