Page History

IMPORTANT
Read instructions carefully and input participant data in the specific:

...

ABOUT THE IMPORT PAGE

• These 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

...

• If a health condition is present, select the condition in the correct column. (For example, if a physical health conditions, choose "Physical" from the drop down field.)

• Please provide an explanation of those chosen Input explanations for selected health conditions in the appropriate columnsWrite out
  • Please remember that only time an explanation is needed is if a condition is selected.
  • Choose & explain the health conditions in right columns.
  • • Only selected conditions require explanations
  • Input medications, and dietary restrictions in right columns.

  Anchor
  4b14 4b14

  Height, Weight  & Measurement Date/Type

  ...

  • Only numbers will be accepted – a phone number with an area code, no NO symbols
  • Must be a 10 digit number
  • Provide a personal email if the individual has one that is different from the family email

  Anchor
  4b15 4b15

  Mobile Carrier
  • Select option from the right options from the drop down menu.
  • If the selection is other, please specify it by entering the information in the column labeled Other Mobile Carrier (Column BL and FG).

  Anchor
  4b16 4b16

  Individual Address/Contact information

  ...

  • Choose ONLY from the dropdown menu options. If they have more than one preferred method of contact, indicate all
  • If a preference for call or text is not specified for either Family, Home, Mobile, or Work, the default options is "Call"
  • If an individual only lists Home and Mobile as preferred contact methods, either choose Call Home in column BP, or choose Call Mobile in column BR.
  • If the selection is Other, please specify it by entering the information in the column labeled "Other Contact Method" (Column CI) 

  Anchor
  4b18 4b18

  Preferred Contact Time
  • Indicate the preferred contact time of the individual by choosing the right options from dropdown menu in the appropriate column
  • For example, if the individual prefers Evening, choose Evening
  • If the selection is Other, please specify it by entering the information in the column labeled "Other Contact Time" (column CO)

  Anchor
  4b19 4b19

  Study Name
  • Copy/Paste or Enter the Study Name of which the study file came from
  • (It should be the same as the one created in Studies page on Revolution database)

  ...

  • Select items ONLY from the dropdown menu options – use your best judgement if the dropdown options are not exact with the values in the study file or if you are not sure or there's no information, leave cell empty

  
  **Repeat steps if there is

  ...

  are other household members enrolled in the study

  ...

  **

  
  

  Warning
  You must keep all columns even if they are not relevant and make sure the important cells are not empty!!

  Anchor
  5 5

  FINAL STEPS
  *Before uploading import file:*

  ...

       5. If there are no errors or they have been corrected then you may save the file.

  

       6. 'Save' import file in your desired location:

  ...