Author Topic: Not able to import xml interchange file  (Read 5421 times)

Phil Beauvoir

  • Archi Guy
  • Hero Member
  • *****
  • Posts: 1501
  • Archi Guy
    • Archi
Re: Not able to import xml interchange file
« Reply #15 on: January 25, 2017, 21:40:57 PM »
And...as I keep telling people, the real solution is to use the "Data - > From Text" option when importing CSV into Excel, not to just open it. https://www.hesa.ac.uk/support/user-guides/import-csv

Anyway, this thread seems to have veered from the original problem... :-)
If you value and use Archi please consider making a donation! https://www.archimatetool.com/donate

brain_work

  • Active Member
  • ***
  • Posts: 60
Re: Not able to import xml interchange file
« Reply #16 on: January 25, 2017, 22:33:01 PM »
Thanks for the clarification :-)

BTW I'm building my own Archi maintenance scripts now so I don't have to use Excel :-)

Regards,
Peter

Phil Beauvoir

  • Archi Guy
  • Hero Member
  • *****
  • Posts: 1501
  • Archi Guy
    • Archi
Re: Not able to import xml interchange file
« Reply #17 on: January 25, 2017, 22:36:43 PM »
Thanks for the clarification :-)

BTW I'm building my own Archi maintenance scripts now so I don't have to use Excel :-)

Regards,
Peter

What's the real, underlying, use case here? Is it manipulating the data? Is CSV just a means to get at the data? Would a scripting language provide a better solution?
If you value and use Archi please consider making a donation! https://www.archimatetool.com/donate

brain_work

  • Active Member
  • ***
  • Posts: 60
Re: Not able to import xml interchange file
« Reply #18 on: January 25, 2017, 22:55:49 PM »
I start to use scripting to manipulate data (import from other sources, export to TiddlyWiki, repair/change things in the model, simple reporting etc.).  I use LINQPad (licensed version with debugger), so I personally don't need a builtin scripting language.

Regards,
Peter