Problem
I often need to re-import a CSV file with the same structure into a table. Not all the columns have the same heading and so whilst some headings auto match , others don't. As the structure of the CSV file and the table will stay the same, I am wondering if the import could save the mappings so I don't have to repeat this every time? Maybe there could be an option to default to the last import settings, or maybe there could be a 'favourite imports' feature where this could be stored. Or maybe there could be an option to simply match the order of the columns, regardless of the column names?
Proposed solution
No response
Alternatives considered
No response
Related database type
MySQL / MariaDB
Problem
I often need to re-import a CSV file with the same structure into a table. Not all the columns have the same heading and so whilst some headings auto match , others don't. As the structure of the CSV file and the table will stay the same, I am wondering if the import could save the mappings so I don't have to repeat this every time? Maybe there could be an option to default to the last import settings, or maybe there could be a 'favourite imports' feature where this could be stored. Or maybe there could be an option to simply match the order of the columns, regardless of the column names?
Proposed solution
No response
Alternatives considered
No response
Related database type
MySQL / MariaDB