artifact_id;status_id;status_name;priority;submitter_id;submitter_name;assigned_to_id;assigned_to_name;open_date;close_date;last_modified_date;summary;details;"Category";"Group"
1000502;1;"Open";3;100;"Nobody";100;"Nobody";"2005-12-23 14:53";"";"2012-09-24 02:14";"Data File Column to Table Field Mappings based on Index or Header Row Name";"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.";"None";"None"
1000582;1;"Open";3;100;"Nobody";100;"Nobody";"2006-03-07 13:01";"";"2012-09-24 02:14";"Update";"Hi,

I want to thank for your program. 
It's very good with importing data.

Do yout think it can be used and for import UPDATE queries?

Thank you,

Nicu TANASE <bitlevel at gmail dot com>";"None";"Next Release (example)"
1000780;1;"Open";3;100;"Nobody";100;"Nobody";"2006-11-15 15:15";"";"2012-09-24 02:14";"Flat File";"I have flat files that need to be import into the database tables.  I see you can to delimited formats, but I have have plain flat files.";"None";"None"
1010199;1;"Open";3;107658;"Brannon Smith";100;"Nobody";"2007-11-28 18:08";"";"2012-09-24 02:14";"Skip/Ignore duplicate keyed rows";"Often the data files being bulk loaded may contain rows that were loaded in a previous pass (e.g., the data file is being generated nightly from another database without consideration for previous runs). The resultant primary key violation that results from subsequent load attempts of said rows immediately terminates the job leaving the remainder of the data file unloaded. Would it be possible to add a ""skip-dupes"" or ""ignore-dupes"" option that would enable the offending rows to be logged as with other conflicting rows and allow processing to continue?";"None";"None"