Book a Demo

Author Topic: Round trip XSD. Updating Previous Import  (Read 4971 times)

rumex

  • EA Novice
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
Round trip XSD. Updating Previous Import
« on: August 30, 2016, 06:56:04 pm »
I've a client who supplies an XSD every month and I'd like to import and update the existing information from a previous import.
I've tried this and ended up with duplicate Packages side by side in the same Parent Model.
I used Project -> XML Schema -> Import XML Schema.  Is there a better way?
Thanks

Sunshine

  • EA Practitioner
  • ***
  • Posts: 1353
  • Karma: +121/-10
  • Its the results that count
    • View Profile
Re: Round trip XSD. Updating Previous Import
« Reply #1 on: August 31, 2016, 07:22:51 am »
There is a Strip GUIDs tick box on the Import XSD dialog. Make sure that is not ticked then when you import it will replace rather then add duplicates.
Happy to help
:)

Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 8110
  • Karma: +119/-20
    • View Profile
Re: Round trip XSD. Updating Previous Import
« Reply #2 on: August 31, 2016, 08:26:20 am »
The Strip GUIDs option is for Import XMI. Not Import XSD.

Unfortunately, we do not have a function to update an existing model with a new XSD.

Sunshine

  • EA Practitioner
  • ***
  • Posts: 1353
  • Karma: +121/-10
  • Its the results that count
    • View Profile
Re: Round trip XSD. Updating Previous Import
« Reply #3 on: August 31, 2016, 11:03:59 am »
Oops didn't read that post too carefully did I? XSD vs XMI duh!

Thinking about that further I guess with the XSD not having Sparx EA GUIDs in it you could only match the elements by name. If the names change then it makes it rather difficult.  You need a way of matching up elements to merge the updates into the existing model.
If the names didn't change you could match the names and use some sql using a left or right outer join to merge the two sets of data after you imported them. using eap file you could use MS Access to write the SQL to merge.

Other than that don't have a lot of ideas without further info.


Happy to help
:)

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Round trip XSD. Updating Previous Import
« Reply #4 on: August 31, 2016, 07:33:25 pm »
I once made the mapping myself by writing an XSD im-/export. The basics were not too difficult. The only heavy part was to get the synch work as needed. It's possible, takes a bit of work but is feasible. I don't know how dependent you are and what you can spend on it. But you should investigate in that direction.

q.