File with empty mapping should not show empty records

[chavda-bhavik]

Describe the bug Impler validates empty files at first. But none of the columns are required, and the user doesn't do any mapping. The review step shows a table with empty records.

To Reproduce Steps to reproduce the behavior:

1. Go to https://web.impler.io
2. Create Import with following schema,

   [
   {
   "key": "Email",
   "name": "Email",
   "type": "Email",
   "alternateKeys": [],
   "isRequired": false,
   "isUnique": false,
   "isFrozen": false,
   "dateFormats": [
     "DD/MM/YYYY"
   ],
   "selectValues": []
   },
   {
   "key": "First Name",
   "name": "First Name",
   "type": "String",
   "alternateKeys": [],
   "isRequired": false,
   "isUnique": false,
   "isFrozen": false,
   "dateFormats": [
     "DD/MM/YYYY"
   ],
   "selectValues": []
   },
   {
   "key": "Last Name",
   "name": "Last Name",
   "type": "String",
   "alternateKeys": [],
   "isRequired": false,
   "isUnique": false,
   "isFrozen": false,
   "dateFormats": [
     "DD/MM/YYYY"
   ],
   "selectValues": []
   },
   {
   "key": "Company Name",
   "name": "Company Name",
   "type": "String",
   "alternateKeys": [],
   "isRequired": false,
   "isUnique": false,
   "isFrozen": false,
   "dateFormats": [
     "DD/MM/YYYY"
   ],
   "selectValues": []
   },
   {
   "key": "Twitter Handle",
   "name": "Twitter Handle",
   "type": "String",
   "alternateKeys": [],
   "isRequired": false,
   "isUnique": false,
   "isFrozen": false,
   "dateFormats": [
     "DD/MM/YYYY"
   ],
   "selectValues": []
   },
   {
   "key": "LinkedIn Handle",
   "name": "LinkedIn Handle",
   "type": "String",
   "alternateKeys": [],
   "isRequired": false,
   "isUnique": false,
   "isFrozen": false,
   "dateFormats": [
     "DD/MM/YYYY"
   ],
   "selectValues": []
   },
   {
   "key": "Lead Status",
   "name": "Lead Status",
   "type": "String",
   "alternateKeys": [],
   "isRequired": false,
   "isUnique": false,
   "isFrozen": false,
   "dateFormats": [
     "DD/MM/YYYY"
   ],
   "selectValues": []
   }
   ]

3. Import data with the following file. Ma Contacts (sample).xlsx
4. Do not map any columns.
5. The review step will show empty records,

Expected behavior The review step should exclude these empty records.

Additional context We can add check here for empty records, https://github.com/implerhq/impler.io/blob/next/apps/api/src/app/review/usecases/do-review/base-review.usecase.ts#L335

[ChinmoyDn]

Hi @chavda-bhavik, I would like to make an attempt at this. Could you please assign the issue to me?

[chavda-bhavik]

Sure @ChinmoyDn Feel free to ask any questions here or in discord

[rothardo]

Hi @chavda-bhavik is this issue up for grabs?