CSV Data Mapping Wizard

To create a CSV File data mapping wizard, the following steps are involved:

• Start by opening the Creating a New Data Mapping Configuration wizard.
• In the list, select Data mapping Configuration -> Data mapping Wizards -> CSV File and click Next.
• On the first screen, choose the proper settings::
• • Browse to the CSV File you want to open.

  • Encoding: Choose the correct encoding to read the file.

  • Take a look at the preview to ensure that the file is the right one and the encoding correctly reads the data.

  • Click Next

• On the second screen, choose the proper settings:
• • Note that these settings are generally detected automatically.
  • Separator: Defines what character separates each fields in the file.

  • Comment Delimiter: Defines what character starts a comment line.

  • Text Delimiter: Defines what character surrounds text fields in the file, preventing the Field Delimiter from being interpreted within those text delimiters.

  • Ignore Unparsable Lines: Ignores any line that does not correspond to the settings above.

  • First row contains field names: Uses the first line of the CSV a headers, which automatically names all extracted fields.

• Verify that the data is read properly and click Finish.