[james_foran]

If you are updating a date field, make sure the 3rd line of the CSV file contains the date format as follows:

EXEC SQL ALTER SESSION SET NLS_DATE_FORMAT = 'DD/MM/YYYY'

Line 1 must contain the table name
Line 2 must contain the column names, separated by a comma. Make sure there are no additinoal commas after the last column.

Always edit CSV files in a Text editor. Excel plays havoc with CSV files. Particullary with AGENT_ACTION_DETAILS and SAVED QUERY records where certain fields may contain a large amount of data.

I use the following SQL Script to extract AGENT_ACTION_DETAILS from the DB:

SELECT AD.AGENT_GID, AGENT_ACTION_GID, ACTION_FLOW, ACTION_SEQUENCE,'"'||replace(replace(replace(ACTIO N_PARAMETERS, chr(9), ' '), chr(10), ' '), chr(13), ' ')||'"' ACTION_PARAMETERS,DOMAIN_NAME, DATA_TYPE_ASSOCIATION_GID FROM AGENT_ACTION_DETAILS AD WHERE agent_gid in(
:agent_gid)

It removes all tabs and line returns.

I cannot see the file, so I hope this helps with your issue. If not, attache the file (or at least the first 4-5 lines), and I will have a look into this for you.

Cheers,