Contact Zone:CSV Input

From Melissa Data Wiki
Revision as of 20:22, 14 August 2014 by Admin (talk | contribs)
Jump to navigation Jump to search

← Contact Zone Reference

Contact Zone Basics Navigation
Overview
Tutorial
Input
Excel Input
CSV Input
MySQL Input
MD Components
Contact Verify
Global Verify
IP Locator
MatchUp
Personator
Presort
SmartMover
Output
Excel Output
Text Output



CSV stands for Comma-Separated Values. Contact Zone can use CSV files as input.

This step is located in the View/Design Pane, under the Design tab, in the Input folder, with the name CSV file input.

To get started, Left-click drag and drop the CSV file input from the View/Design Pane to the Transformation Pane.

Configuring the Step

1. Double-click the CSV file input Step. (Or right-click the Step and select Edit step.)

2. Here the configuration window that belongs to this type of Step will appear. In this case, the CSV Input window. Here we need to setup:

  • Step name - If needed, we can change this name to be more descriptive.
  • Filename - Here we link this Step with our input data file.
Click the Browse... button and navigate to the desired data file.
  • Delimiter - Specify what type of delimiter the file uses.
  • Enclosure - Specify what type of enclosure the file uses.

3. Now we need to click Get Fields to populate what fields our CSV file has.

4. A pop-up will open. The default amount of 100 sample lines is fine. Click OK.

5. After this we get the Scan results. Take note of any warnings listed. These warnings may indicate a need to modify the input fields.

6. Generally the Type and Length fields need alterations, but any field can be altered, depending on the input data file.

  • Click on the cell under Type that we want to change, click the small down arrow to the right of the cell, and choose the desired type from the drop-down menu.
  • Click on the cell under Length that we want to change, then enter the desired length in the cell.
  • These modifications will prevent errors in our output and give us better results.
Note
If you encounter errors or the output data seems incomplete, it may well be due to incorrect settings on our input file fields. So it is recommended to check this step if any errors occur.

7. Click OK to finish defining the CSV Input Step.