Redpoint Best Practices Documentation
Redpoint Best Practices Documentation
Breadcrumbs

How to create a Data Project

This process is for RPI v6 and lower. For RPI v7 and higher, please refer to Data Import.

To create a Data Project:

  1. In the Quick Access menu, create and save a new data project.

image-20240930-211744.png

  1. In the Definition tab’s Acquisition panel, select Upload and Analyze File to identify a delimited or fixed-width file to base the new data project on.

image-20240930-211924.png

  1. View a sample of the file’s contents and verify that it matches the File Upload Preview dialog.

image-20240930-212019.png

  1. In Definition.Acquisition, watch as RPI uploads the file to the Redpoint Interaction server and then analyzes its contents.

  2. If the file is delimited:

    • In the Definition tab’s File Analysis panel, specify the data project’s high-level properties.

    • In the Definition tab’s Field Analysis panel, verify Redpoint Interaction’s analysis of the file’s field structure, making any changes as necessary, and specify any required field-level properties.

  3. If the file is fixed-width:

    • In the Definition tab’s File Analysis panel, specify the data project’s high-level properties.

    • Invoke Preview to view a preview of Redpoint Interaction’s automatic determination of the file’s field boundaries in the Preview dialog, and make manual adjustments as required.

    • Invoke Re-analyze to allow RPI to reflect the defined field boundaries by populating the Definition tab’s Field Analysis panel’s Fields grid.

    • In Definition.Field Analysis, specify any required field-level properties.

image-20240930-212601.png

You need to manually specify the primary key for your table.

image-20240930-212648.png

  1. Select Validate and Load to ensure that all rows within the file are accordant with its defined structure, and to initiate loading of the data project’s initial file into the database.