Import Excel to Database plugin only working when matching the Excel Headers Names and Table Columns Names

Certified Associate Developer

Import Excel to Database  Plugin -  we are importing the data with this plugin and using the latest version of it, but in the new version we are seeing one issue,  Excel headers and Table columns name required  to keep the same, for example  CONTACT_NUMBER(Excel template)  = CONTACT_NUMBER(Table column) then only plugin is going to work.

but user's file header with Contact Number not CONTACT_NUMBER.  is there any alternative way to have headers with camel case and the logical wording not the table column name in the template like CONTACT_NUMBER or any way to edit the template headers after upload and to make change in header from Contact Number->  CONTACT_NUMBER(Excel template) to match table column name?

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data