Author Topic: Importing requirements with past date  (Read 226 times)

Maciou

  • EA Novice
  • *
  • Posts: 14
  • Karma: +0/-0
    • View Profile
Importing requirements with past date
« on: June 12, 2019, 10:34:46 pm »
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

  • EA Guru
  • *****
  • Posts: 10683
  • Karma: +235/-202
  • I'm no guru at all
    • View Profile
Re: Importing requirements with past date
« Reply #1 on: June 12, 2019, 11:33:50 pm »
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.

Arquesoft

  • EA User
  • **
  • Posts: 259
  • Karma: +5/-3
  • EA Consulting and development in Spanish
    • View Profile
    • Arquesoft website
Re: Importing requirements with past date
« Reply #2 on: June 13, 2019, 01:02:18 am »
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