How to import a excel file even some of the rows are having incorrect data

0
Hi, I am facing a issue while trying to import a excel file when it is having a incorrect data in some of its rows, I tried it using excel importer module but was not able to import the data if any one of the row is having a incorrect data or missing data. I need to import the other rows which are having correct data and skip the incorrect one's. How can I achieve this !!!
asked
1 answers
0

Depends a bit on the definition of incorrect data;

  1. Can it occure on any value or only specific values?
  2. What is incorrect, and when incorrect how should it be handled?
  3. What is the complexity of the imported data, single entity or across multiple?

 

Solutions

  1. use a parsing microflow, which handles incorrect values
  2. Import the data as is on an  "import entity" and handle mapping to final data structure in a microflow after import (my preference in any case)
  3. If its a formatting issue, like a date/time: import it as a string or integer instead and convert to a DateTime after import icw solution 2

 

answered