Describe the bug
When importing excel file, the columns from excel file are mapped to columns in database , in sequence.
[Example:
If excel file has following columns: Task Name | Client Name | Task Due Date
If teable db has following columns: Preparer Name | Task Name| Client Name | Task Due Date
During Import,
The Task Name (Excel) will be mapped to "Preparer Name"
The Client Name (Excel) will be mapped to "Task Name"
The Task Due Date (Excel) will be mapped to "Client Name"
The Task Due Date (in teable) will appear as "Do Not Import"
To Reproduce
Create a Task Table:
Export the CSV and remove existing records.(keep headers intact)
Remove irrelevant columns.
Enter new data to be imported and save as Excel. [Refer screenshot below]
Import the excel
We can see that Count column is mapped to Status column (As Count is the 2nd Column in Teable and Status is the 2nd Column in Excel).
Expected behavior
The mapping should be done based on the Field Names [As they match with the Field Names appearing in teable]
Screenshots
Screenshots in line with description above.
Client (please complete the following information):
OS: Windows
Browser Firefox
Version 126.0b8 (64-bit)
Platform (Please tell us which deployment version you are using)
Teable.io and Docker-Standalone, both.
Describe the bug When importing excel file, the columns from excel file are mapped to columns in database , in sequence. [Example:
During Import, The Task Name (Excel) will be mapped to "Preparer Name" The Client Name (Excel) will be mapped to "Task Name" The Task Due Date (Excel) will be mapped to "Client Name" The Task Due Date (in teable) will appear as "Do Not Import"
To Reproduce Create a Task Table:
Export the CSV and remove existing records.(keep headers intact) Remove irrelevant columns. Enter new data to be imported and save as Excel. [Refer screenshot below]
Import the excel
We can see that Count column is mapped to Status column (As Count is the 2nd Column in Teable and Status is the 2nd Column in Excel).
Expected behavior The mapping should be done based on the Field Names [As they match with the Field Names appearing in teable]
Screenshots Screenshots in line with description above.
Client (please complete the following information):
Platform (Please tell us which deployment version you are using) Teable.io and Docker-Standalone, both.
Additional context N/A