Automapping CSV import fields
Posted: 29.05.2007, 15:22
Hi,
This would require some work, but I often have to import a CSV file where the column headers are identical to the destination table's field names.
It often is about 30 columns, so I have to go through the tedious process of mapping the source column to the destination column, even though the names are identical.
It would be great if identical source and destination column names are automatically mapped to each other. Any other columns can then be mapped manually by the user.
Also, the CSV import is quite slow. Is the import done inside ONE transaction? That seems to speed up things a lot.
regards,
Francois
This would require some work, but I often have to import a CSV file where the column headers are identical to the destination table's field names.
It often is about 30 columns, so I have to go through the tedious process of mapping the source column to the destination column, even though the names are identical.
It would be great if identical source and destination column names are automatically mapped to each other. Any other columns can then be mapped manually by the user.
Also, the CSV import is quite slow. Is the import done inside ONE transaction? That seems to speed up things a lot.
regards,
Francois