Exporting Data

This chapter provides an overview of the export feature in PeopleSoft Customer Behavior Modeling and discusses how to export profiles.

After you have built a profile, you may want to export it to a:

Note. If you are exporting a profile, segment, or sample text file, define a physical export location using the File Management feature.

The following table lists the jobstream ID, engine, and tables used during processing.

Note. The jobstreams listed are for the sample data that PeopleSoft delivers; therefore, you may choose to create your own jobstreams.

Process	Delivered Jobstream ID	Engine Used	Tables Accessed	Tables Updated
Write all data to file	CR_EXPT	CR_EXPT	CR_COMP_DEF, CR_COMPCOL_F00, CR_COMPVAL_F00, CR_DRAW_TBL, CR_DRAW_SEQ, CR_SEGM_DEF, CR_SEGM_SEQ, CR_SEGMENT_F00, CR_SAMPLE_DEF, CR_SAMPLE_F00, RUN_CR_EXPT_JOB	CR_COMP_AUDIT
Data mining model creation	CR_EXPT	CR_EXPT	Same as above plus: CR_DMI_MDL_DEF, CR_DMI_MDL_ISQ, CR_DMI_MDL_OSQ	CR_COMP_AUDIT
Generate scores	CR_BATCH	CR_EXPT, CR_IMPT	Same as above plus: CR_DMI_MDL_DEF, CR_DMI_MDL_ISQ, CR_DMI_MDL_OSQ	CR_COMP_AUDIT

To export profiles, use the Export Definition (CR_DRAWTBL_CP) component and the Run Engine to Export Data RUN_CR_EXPT_JBSTRM) component.

This section discusses how to export profiles.

Page Name	Object Name	Navigation	Usage
Exports	CR_DRAW_TBL	Customer Behavior Modeling homepage, Customer Analysis link, Data Export link, Exports Customer Behavior Modeling homepage, Customer Analysis link, Target Profiles link, Profile. Click the Export button on the Profile, Samples, or Segment Groups page. Customer Behavior Modeling homepage, List Creation Center link, List Creation Center Click the Export definition and Export execution links.	Select or create an export definition.
Export to File	RUN_CR_EXPT_JBSTR1	Click the Run Export button on the Exports page.	Export a profile.

Access the Exports page.

To define exports:

On the Export page, select one of the existing export definitions.

Alternatively, you can:
Add a new export.

Enter a new Export Name and select the Type of Export from the available options:

Write all data to file: System generates a file of the profile, samples, and segments selected.

Data Mining Model Creation: System generates a file that you can use to build a data mining model.

Generate Scores: System generates a file using the data mining model that you previously created in the Data Mining component of PeopleSoft Customer Behavior Modeling. The file is automatically passed to a batch scoring process that integrates with a data mining tool of your choice.
Click the Add button to access the Exports page.

On the Exports page:

Enter values in Model Name and Import Name fields.

The system displays these two fields for the Generate Scores export type only. You previously created the model name on the Model Definition page of the Data Mining Integration component. PeopleSoft delivers the import name for the scores with the system.
Indicate whether you want to export the Entire Profile or a Set of Samples and/or Segments. If you are exporting a set of samples and segments, select the sample name, segment group, and segment name from the available options.
The system displays information in the Last Update group box regarding the last export process that you ran.
Save your entries.
Click the Run Export button to process the export.

Access the Export to File page.

To define the processing parameters:

The system displays the File Options group box only if the export type is Write all Data to File or Data Mining Model Creation.

Enter the file Path and specify the Delimiter. Values are: Comma, Semicolon, Colon, Hyphen, Tab, or Other Delimiter.
Click the Export button to schedule to run the process.