MDM 321 – SAP Netweaver Master Data Management

Symptom
When importing a delimited text file with delimiter semicolon (”;”) the Import Manager throws the next error message at the “connect to source” stage:
“Number of field values does not match the field columns. Line # [Pos #].”

Reason and Prerequisites
* The following reason and solution are valid only if apostrophe (’) or inverted commas (”) are been used inside the import source file.
Apostrophe (’) and inverted commas (”) are special characters for the
Import Manager and you experience correct behavior of Import Manager.
Those characters are special in a matter that they need to be imported in pairs.
The Import Manager will not allow importing word or phrase that start with apostrophe (’) and finished with inverted commas (”) and vice versa.
Solution
Please make sure to surround the word with pairs of apostrophe (’) or pairs of commas (”).
Other option leave the word as it is without any use of apostrophe or pairs of commas.
Please choose your best option.