Import file format for history information

This topic contains guidelines for history import files.

Each history import file must contain history information for only one record type. If you are importing multiple record types, create a history import file for each record type that contains history information.

The format for the history import file requires that each history entry be on a separate row and that each entry include the original ID number to identify the record to which the history belongs.

The remaining fields contain information about the action that was performed and must include the following fields:

• Original record ID
• Time stamp
• User name
• Action performed
• Old state
• New state

If you use the Export feature to export history data from another HCL Compass database, the original (old) record ID is saved in a field named display_name. Map the display_name field to the original (old) record ID.

The history import file in the following example uses the original IDs of the records for which this is the history:

"id","timestamp","user_name","action_name","old_state","new_state" 
"1","Apr  6 2000 8:31AM","srahman","close","open","closed" 
"2","Apr  6 2000 9:40AM","srahman","verify","closed","verified" 

In dates, do not truncate the year to the last two digits. You can use any of the following date formats:

• "6 April 2003"
• "April 6, 2003 8:30:00"
• "8:30:00 Apr 6 2003"
• "4/6/2003 8:30:00PM"