SCM

[#1000502] Data File Column to Table Field Mappings based on Index or Header Row Name

View Trackers | Feature Requests | Download .csv | Monitor

Date:
2005-12-23 14:53
Priority:
3
State:
Open
Submitted by:
Nobody
Assigned to:
Nobody (None)
Category:
Group:
Summary:
Data File Column to Table Field Mappings based on Index or Header Row Name

Detailed description
I'd like to be able to define a mapping of Data file columns to Table Fields. I have some data coming from a source where I do not control the order of the data columns but it has a header row. It also has fields that i'm simply not interested in and would prefer to drop rather than import into my DB. Configuring the mappings in the config file (including an option to Ignore) would work perfectly.


An addition to this would be to support mapping the columns to fields in multiple tables.

I.e. i may have a data file with 10 columns. I may want 1-5 to be placed in table A and 1,6-10 in table B. This would allow for breaking data into more efficient groups during import. and generally make the tool more flexible.

Followup

Message
Date: 2006-11-21 12:51
Sender: Dimitri Fontaine

New pgloader version now needs the mapping to be defined, but still can't ignore data input columns.

This should not be difficult to code now.

Attached Files:

Changes:

No Changes Have Been Made to This Item

Powered By FusionForge