PRISM Forum - Message Replies
Topic: PRISM Questions and Answers
Topic Posted by: SRC
Date Posted: Wed Jan 12 8:33:33 US/Eastern 2000
Topic Description: Welcome to the PRISM forum! Please feel free to post your questions and comments about the PRISM assessment software here.
Posted by: Thomas Urbanczyk
Organization:SystemA Engineering GmbH
Date posted: Wed Mar 10 4:13:16 US/Eastern 2004
Subject: Prism Export to Excel - Import
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: Importing with PRISM
Reply Posted by: Tammy Sehn
Organization: Reliability Analysis Center
Date Posted: Fri Mar 12 11:24:44 US/Eastern 2004
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.