Import Text > Allow fields to be mapped more than once about sequelpro HOT 5 CLOSED

Author:[email protected] Date:2008-08-01 00:19:32

Sorry my bad. I should have double checked the interface first before posting this. You can ignore the above
comments

Ideally the field mapping sheet would show ALL the columns in the database and then allow you to pick the
columns from the data file to map to each database column.

This would then allow you to duplicate data across multiple fields as well as allow you to set a default for
fields where there is no corresponding field in the data file.

A combo box would probably work best in this scenario. pre-populated with the fields in the data file with
the option of setting a custom value.

Hope that makes more sense.

from sequelpro.

Author:[email protected] Date:2008-08-01 00:31:06

OK, so to word it properly... :p

Instead of selecting the table column for each csv column, you want to select the csv column for each table
column. And as an aside, you think we should be able to set the value for table columns which will not be
mapped.

Sure, sounds great to me.

from sequelpro.

Author:[email protected] Date:2008-08-01 00:37:41

Yup exactly right. The code for it is all in TableDump.m
I've had a quick play with it and got a combo box cell in there. Next is to swap the column data over and fix up a
few bugs. Will play with it more once I get back to Oz

from sequelpro.

Author:[email protected] Date:2008-12-05 08:58:20

Fixed in r223 and r224.

Known Issue: A table must be selected in TABLES list first before using the Import... menu

from sequelpro.

Author:[email protected] Date:2008-12-06 14:44:33

Known issue now fixed in r232

from sequelpro.