Contact Zone:CSV Input - Revision history

Admin at 00:46, 3 January 2017

2017-01-03T00:46:11Z

@@ Line 1: / Line 1: @@
-[[Contact Zone:Reference|&larr; 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;"
+}}
 {{CustomTOC}}

Admin at 20:22, 14 August 2014

2014-08-14T20:22:51Z

← Older revision		Revision as of 20:22, 14 August 2014
Line 51:		Line 51:
	\|[[Contact Zone:Text Output\|Text Output]]		\|[[Contact Zone:Text Output\|Text Output]]
	\|}		\|}
	\|-
	~~\|\|[[Contact Zone:Reporting\|Reporting]]~~
	\|}		\|}

Admin at 20:50, 8 August 2014

2014-08-08T20:50:31Z

← Older revision		Revision as of 20:50, 8 August 2014
Line 68:		Line 68:
	==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 97:

	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]]

Admin at 17:59, 2 July 2014

2014-07-02T17:59:40Z

← Older revision		Revision as of 17:59, 2 July 2014
Line 2:		Line 2:

	{\| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"		{\| 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="text-align:left; color:black; border-bottom:1px solid #aaaaaa;"\|'''Contact Zone Basics Navigation'''
	\|-		\|-
	\| style="padding-right:220px;"\|		\| style="padding-right:220px;"\|

Admin at 22:38, 19 June 2014

2014-06-19T22:38:29Z

← Older revision		Revision as of 22:38, 19 June 2014
Line 15:		Line 15:
	! style="color:black;"\|Input		! style="color:black;"\|Input
	\|-		\|-
	\|[[Contact Zone~~:Basics~~:Excel Input\|Excel Input]]		\|[[Contact Zone:Excel Input\|Excel Input]]
	\|-		\|-
	\|[[Contact Zone~~:Basics~~:CSV Input\|CSV Input]]		\|[[Contact Zone:CSV Input\|CSV Input]]
	\|-		\|-
	\|[[Contact Zone~~:Basics~~:MySQL Input\|MySQL Input]]		\|[[Contact Zone:MySQL Input\|MySQL Input]]
	\|}		\|}
	\|-		\|-
Line 47:		Line 47:
	! style="color:black;"\|Output		! style="color:black;"\|Output
	\|-		\|-
	\|[[Contact Zone~~:Basics~~:Excel Output\|Excel Output]]		\|[[Contact Zone:Excel Output\|Excel Output]]
	\|-		\|-
	\|[[Contact Zone~~:Basics~~:Text Output\|Text Output]]		\|[[Contact Zone:Text Output\|Text Output]]
	\|}		\|}
	\|-		\|-
	\|\|[[Contact Zone~~:Basics~~:Reporting\|Reporting]]		\|\|[[Contact Zone:Reporting\|Reporting]]
	\|}		\|}

Admin: Admin moved page Contact Zone:Basics:CSV Input to Contact Zone:CSV Input without leaving a redirect

2014-06-19T22:36:54Z

Admin moved page Contact Zone:Basics:CSV Input to Contact Zone:CSV Input without leaving a redirect

← Older revision	Revision as of 22:36, 19 June 2014
(No difference)

Admin at 22:33, 19 June 2014

2014-06-19T22:33:38Z

← Older revision		Revision as of 22:33, 19 June 2014
Line 19:		Line 19:
	\|[[Contact Zone:Basics:CSV Input\|CSV Input]]		\|[[Contact Zone:Basics:CSV Input\|CSV Input]]
	\|-		\|-
	\|[[Contact Zone:Basics~~:MySQL Input~~:MySQL Input\|MySQL Input]]		\|[[Contact Zone:Basics:MySQL Input\|MySQL Input]]
	\|}		\|}
	\|-		\|-

Admin: Created page with "← Contact Zone Reference {| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; c..."

2014-06-19T22:27:07Z

Created page with "← Contact Zone Reference {| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; c..."

New page

[[Contact Zone:Reference|← Contact Zone Reference]]

{| 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:Basics:Excel Input|Excel Input]]
|-
|[[Contact Zone:Basics:CSV Input|CSV Input]]
|-
|[[Contact Zone:Basics:MySQL Input: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:Basics:Excel Output|Excel Output]]
|-
|[[Contact Zone:Basics:Text Output|Text Output]]
|}
|-
||[[Contact Zone:Basics:Reporting|Reporting]]
|}

{{CustomTOC}}

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.

[[File:CZ_CSVInput_Workspace.png|link=]]

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.

[[File:CZ_CSVInput_Scan.png|link=]]

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.

[[File:CZ_CSVInput_Input.png|link=]]

[[Category:Contact Zone]]