Contact Zone:CSV Input: Difference between revisions

From Melissa Data Wiki
Jump to navigation Jump to search
mNo edit summary
No edit summary
 
(3 intermediate revisions by the same user not shown)
Line 1: Line 1:
[[Contact Zone:Reference|← Contact Zone Reference]]
{{ContactZoneBasicsNav
 
|InputCollapse=
{| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"
}}
! style="text-align:left; color:black; border-bottom:1px solid #aaaaaa;"|'''Contact Verify Navigation'''
|-
| style="padding-right:220px;"|
|-
|[[Contact Zone:Basics|Overview]]
|-
|[[Contact Zone:Tutorial|Tutorial]]
|-
|
{| class="mw-collapsible" style="width:100%;"
|- align="left"
! style="color:black;"|Input
|-
|[[Contact Zone:Excel Input|Excel Input]]
|-
|[[Contact Zone:CSV Input|CSV Input]]
|-
|[[Contact Zone:MySQL Input|MySQL Input]]
|}
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|MD Components
|-
|[[Contact Zone:Contact Verify|Contact Verify]]
|-
|[[Contact Zone:Global Verify|Global Verify]]
|-
|[[Contact Zone:IP Locator|IP Locator]]
|-
|[[Contact Zone:MatchUp|MatchUp]]
|-
|[[Contact Zone:Personator|Personator]]
|-
|[[Contact Zone:Presort|Presort]]
|-
|[[Contact Zone:SmartMover|SmartMover]]
|}
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|Output
|-
|[[Contact Zone:Excel Output|Excel Output]]
|-
|[[Contact Zone:Text Output|Text Output]]
|}
|-
||[[Contact Zone:Reporting|Reporting]]
|}
 


{{CustomTOC}}
{{CustomTOC}}
Line 68: Line 15:
==Configuring the Step==
==Configuring the Step==
1. Double-click the CSV file input Step. (Or right-click the Step and select Edit step.)
1. Double-click the CSV file input Step. (Or right-click the Step and select Edit step.)
[[File:CZ_CSVInput_Input.png|link=]]


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:
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:
Line 95: Line 44:


7. Click OK to finish defining the CSV Input Step.
7. Click OK to finish defining the CSV Input Step.
[[File:CZ_CSVInput_Input.png|link=]]




[[Category:Contact Zone]]
[[Category:Contact Zone]]

Latest revision as of 00:46, 3 January 2017

← Contact Zone

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.