Importing requirements with past date

[Maciou]

Hi,
I'm trying to import reqirements from csv.
I set creation date from the past, but EA takes it from moment of importing.
Is there any trick or walkaround to import requirements with creation date from past?

[qwerty]

I guess the only way is by tweaking the database with a SQL (from a script). I seem to remember some option that deals with date handling. It might well be useless in this context. Good luck in searching for it in the options jungle.

q.

[Mauricio Moya (Arquesoft)]

I suggest the following procedure:

• Import the elements via CSV specification
• Export the elements imported via the same CSV specification but adding the GUID column
• Create a final CSV containing only the GUID and the original creation date
• Create a script that executes in the database something like: 'UPDATE t_object SET Creation_Date = ? WHERE ea_guid = ?'
• Iterate based on the CSV content parsed as jscript vector
• That's it