SRC Forum - Message Replies

Forum: Reliability & Maintainability Questions and Answers

Topic: Reliability & Maintainability Questions and Answers

Topic Posted by: Reliability & Maintainability Forum ( )
Organization: System Reliability Center
Date Posted: Mon Aug 31 12:47:36 US/Eastern 1998

Back to message list Show all replies Topics List About this forum
Original Message:

Posted by: Thomas Urbanczyk ( )
Organization:SystemA Engineering GmbH
Date posted: Wed Mar 10 3:29:23 US/Eastern 2004
Subject: Export to Excel - Import to Prism
Problem: I've got a big assembly with lots of sub-assemblys (about 130 sub-assemblys, 800 parts in total). Now I have to change a value for most of the parts, which could be done easily with excel. Therefore I used the export function, in the next step I imported the file to excel and changed the relevant values. Problem is, the import back to PRISM doesn't work, or better said, I have to manually build up the assembly structure again. Is there any way to do it correctly?


Subject: Export to Excel - Import to Prism
Reply Posted by: Nathan Holzhauer ( )
Organization: Alion Science and Technology
Date Posted: Fri Apr 2 11:17:23 US/Eastern 2004
Answer posted by Tammy Sehn ( in the PRISM Forum ( "The initial idea behind the export of a file generated by PRISM was/is related to file sharing between users. While your approach to making a change to a large number of items is not invalid, it is not the recommended course. Due to the complexity of your situation, it is recommended that you use the "Find" tool and search for the components that will be changed. If what you are changing are fields that are stored in the library, it is recommended that you utilize the component library and the find tool together to make the change. Your concerns have been noted and we will try to put them into a future update."

Reply to this message