The Data load wizard load the csv data into a collection called 'LOAD_CONTENT'. In the upload wizard you can specify to use the first row of your file as column headers and you can reference a specific row using the collections' 'SEQ_ID' column. IN your case a query like following will result in the desired output:

select

( select to_date(c002,'dd/mm/yyyy')

from apex_collections

where collection_name = 'LOAD_CONTENT'

and seq_id = 1

) as date

, c001 as task

, c002 as count

from apex_collections

where collection_name = 'LOAD_CONTENT'

and seq_id > 1

union all

select

( select to_date(c003,'dd/mm/yyyy')

from apex_collections

where collection_name = 'LOAD_CONTENT'

and seq_id = 1

) as date

, c001 as task

, c003 as count

from apex_collections

where collection_name = 'LOAD_CONTENT'

and seq_id > 1

You can use this query to create a report, or to update a table or whatever it is that you want to do.

Indeed you'd need to know what you are importing. You can include extra columns in the union statement in case you're not always importing the same amount of date columns (add c004, C005, C006, etc..). So there is some flexibility, yet limited.

For the plugin, I can import it ok, just can't get it to work. I haven't been able to open the ZIP from apex-plugins at all, but I got the updated .sql file from his demo page. It doesn't come with instructions though so I don't know if I missed a step somewhere.

We're using Apex 4.2.3. Do you know if that should work ok?

Also, for your code, I would add that to a process that fires after the plugin?