Author Topic: Importing requirements with past date  (Read 335 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: 11117
  • Karma: +262/-246
  • 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 (Mauricio Moya)

  • EA User
  • **
  • Posts: 264
  • 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
-------------
Need email notifications in EA? fully-automated baselines? a simple way to share your models via web? A copy of all your model diagrams in a folder? visit https://latam.arquesoft.com/en