Skip to Navigation Skip to Main Content

Prepare your Import

check_circle 1

Welcome to Import - Overview

check_circle 2

What is the file type to Import

check_circle 3

Do have an existing Extract Project created to import to?

check_circle 4

Create a New Project

Welcome to Extract Import

Here are the major steps. NOTE: Your work will be saved while you work.

  1. Prepare: Answer a few questions before you upload your data that will help you confirm if your file and it’s data are ready. Use NEXT button below to cycle through questions. Some responses MAY enable follow up questions.

  2. Upload your file

  3. Map your column fields to Extracts Standard Library of moderated fields and then to individual screens or forms.

  4. Validate Fields: Normalize the data to make sure it fits inside of your fields data ranges

  5. Validate Data: Remove conflicts and duplicates relating to individual records with the same unique ID (patient number).

  6. Merge Data: Select secondary identifiers that repeat through multiple spreadsheet pages.

  7. Export: Export your data to your selected data repository.

File type to Import

Is your file above 1000mB?

Existing Extract Project

Do you have an existing Extract Project that you want to import this file into?

  • Some info on what Builder is and entails to building a project here vs. doing building and import at the same time goes here. A dropdown of their projects is shown if the user toggles YES.
  • Integer at lorem sapien volutpat sagittis faucibus. Eu interdum ultrices vitae viverra. Molestie lobortis aliquam lorem interdum. Ut diam mauris amet augue. Consectetur velit sapien dui magna libero mauris risus tellus. Malesuada at id

Create a New Project

Selecting a template has many advantages. The system will auto-populate your project with fields selected just for your data repository. Some extra meta data fields will be required.

Import Spreadsheet

Accepted file formats include: .csv, .xls, xlsx

Source File Uploaded Successfully

Map your Imported Fields ...

25%

Complete

.. to Standard Library Concepts

Selecting the BioPortal template has preloaded the required default fields!

Validate your Fields ...

... to ensure your data values are correct

Merge Data

Repeating Screens

Select Unique ID Fields: procedures_field

Select at least one unique ID field for each repeating form / screen.

Field Name

Procedure Type

Field ID

procedure_type

Type

dropdown

Field Name

Surgery Date

Field ID

surgery_date

Type

text

Field Name

Procedure Location

Field ID

procedure_location

Type

dropdown

Field Name

Cytoreductive Surgery

Field ID

cytoreductive_surgery

Type

yesno

Field Name

Adverse event number

Field ID

eb_adverse_event_number

Type

dropdown

Field Value Conflicts

Record Merge Conflicts

Invalid Value

n

Value Frequency

1

Sheet

Primary Research

Record Values

Invalid Value

N

Value Frequency

1

Sheet

Primary Research

Record Values

Invalid Value

O

Value Frequency

15

Sheet

Primary Research

Record Values

Invalid Value

O

Value Frequency

8

Sheet

Primary Research

Record Values

Invalid Value

O

Value Frequency

10

Sheet

Primary Research

Record Values

REDCap Export Preview

Record Type more_vert
redcap_cbp_id more_vert
redcap_last_name more_vert
redcap_first_name more_vert
redcap_asst_vent_therapy more_vert
redcap_postal_code more_vert
Updated 12341234 Appeno Hal 0 11218
Updated 53837593 Golightly Holly 0 10022
Updated 39837783 Turner Paige false 11214
Updated 93894743 Molive Paul true 07111
Updated 27367483 Melon Walter 1 10023
Updated 38384755 Membrit Ira False 11217
Updated 56644567 Didas Maya TRUE 11218
Updated 12341234 Appeno Harold 0 11218
Updated 22343567 Ander Cory 1 07112
Updated 87699223 Matic Otto 0 11213
Updated 66445621 Cracker Graham FALSE 11217
Updated 88997678 Dente Al true 11218
Updated 11232245 Ficial Arty 1 07112
Updated 12341234 Appeno Hal 0 11218
Updated 45990088 Power Will 0 11213
Updated 99353426 Ender Bart false 11217
Updated 857557432 Petty Manny TRUE 07523
Download Field Mapping