Excel crashes when searching for a HA

Answers

• Options

  Adam_Dzyacky Product Owner Contributor Monkey ✭✭✭✭✭

  November 2016 edited November 2016 Answer ✓

  I experienced the identical issue and Cireson (well, @Tony_Collett) provided a more distilled Type Projection that could be leveraged with Asset Excel as the default one for Hardware Assets attemps to pull all relationships.
  
  I'm not entirely thrilled about the result because to me, it makes me question if perhaps I have some unnecessary degree of relationship complexity in an environment that this program (Asset Excel) is perhaps indirectly exposing. To be absolutely clear, there is no hard evidence to support this observation of mine - just something I've been pondering over.
  
  I have the unsealed MP which contains said TP, not sure if anyone at Cireson is opposed if I shared this.

  5
• Options

  David_Biot Partner IT Monkey ✭

  November 2016

  Hey Adam. It would be great if you can share this MP.

  0
• Options

  Adam_Dzyacky Product Owner Contributor Monkey ✭✭✭✭✭

  November 2016

  It probably goes without saying, change the extension from TXT to XML and then import. Then in the Asset Excel App before you go to query HW assets, head into the settings of Asset Excel and select this new type projection to be used.

  ExcelAppTypeProjections.txt 10.4K

  0
• Options

  damon_mulligan Cireson Consultant Advanced IT Monkey ✭✭✭

  February 2018 edited February 2018

  @David_Biot
  Did @Adam_Dzyacky answer/type projection work for you? If it did. please accept his answer above. If not, what issues are you still having?

  0