Import data through Data Pipeline

Updated 

Note:

  • This is the legacy method and is no longer recommended. The preferred approach is to use Excel for importing leads. (Refer to the article to know more about Importing leads through excel ).

  • This Article is only for reference for existing implementations leveraging Data Pipeline and supported for maintenance only.

Sprinklr enables you to import large dataset of users in any format. This doesn't require you upload the data in a Sprinklr format rather your own format. All you need to do is map the fields as per your format to the desired Sprinklr fields. Here the steps on how you can achieve this:

  1. Click the New Tab icon under Sprinklr Social, select Manage Pipelines within Listen.

  2. In the top-right corner of the Data Flow window, click Create Normal Pipeline.

  3. Click Add Datasource and select a source for the data.

  4. Click From file. Select the file and Enter the details according to the selected data source.

  5. Select Manual upload in Data Consumption section.

  6. Click Upload / Add Datasource / Save after entering the details.

  7. On the Pipeline window, hover over the Addition icon linked to the data source and select a data transformation function or an output junction for your final report. Data Transformation allows you to manipulate the data fetched in the pipeline using several functions and formulas to create a desired final report with the relevant data.

  8. Click on Addition icon once all the requirements are made in the dataset and click Generic Sink.

  9. Select Sprinklr profile from the Select Sink Element.

  10. Map the pipeline columns to match the sink report.

  11. Click Save in the bottom right corner to save the changes.

  12. In the top-right corner of the Pipeline window, toggle the Pipeline status icon to activate your pipeline.

  13. Once the pipeline is activated click on Manual Run in the bottom right corner and upload the file. Click Run.