cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

We are happy to announce the new Windchill Customization board! Learn more.

Exporting and Importing Soft Attributes

TimBrungardt
1-Newbie

Exporting and Importing Soft Attributes

What is the recommended practice for exporting and importing soft attributes? I have two identical systems currently, akin to a dev and test windchill environment. I have created all my soft attributes in dev, and need to move those over to my test environment. Is there a way to export a csv of my soft attributes and then use the dataLoader utility to import them in? I see that the "export/import" utility doesnt support soft attributes, but what tool should I use? If anyone has any samples that would be great also, thanks in advance guys.
3 REPLIES 3

Tim,



The Windchill load utilities can be used to create soft attributes and
types from a xml file. I don't believe there's an OOB tool for exporting
the soft attributes and types from a Windchill system. You will need to
create this XML file using your favorite editor. I'm happy to send you a
xml template to start with if necessary although there should be some
examples in the loadfiles directory and/or the WCDataLoading.pdf.



Good Luck,



Chris Perren


Tim,

we (Sulis) created a tool that allows you to export the attributes and
types into an excel sheet and apply this to other windchill systems, so
the existing types and atts will match what is described in the excel
sheet. you can edit the excel data after export adding attributes and
types and constraints as necessary.
it also allows you to have arbitrary long value list on discrete set and
suggested values, and it can read these values from files, excel sheets,
call I*E tasks or methods on classes, so effectively populating the
values lists even from foreign systems.

We also have cases where the discrete set lists on types change as a
side effect of checking in the excel sheet defining the values 😉

martin


Tim Brungardt wrote:
> What is the recommended practice for exporting and importing soft
> attributes? I have two identical systems currently, akin to a dev and
> test windchill environment. I have created all my soft attributes in
> dev, and need to move those over to my test environment. Is there a
> way to export a csv of my soft attributes and then use the dataLoader
> utility to import them in? I see that the "export/import" utility
> doesnt support soft attributes, but what tool should I use? If anyone
> has any samples that would be great also, thanks in advance guys.
>
> -----End Original Message-----

Tim,
If you need to build the XML file as Chris has suggested, I would recommend running a report to get the attribute information. Otherwise, you would not be saving much time having to create the xml file and load it vs. just re-creating them in your test system. I have attached two example reports (one report to pull the attribute info and one to pull the type info).
Once you have the xml format that is required by the load utility, you can embed the report in excel using the get external data feature and use VB to build the XML.

Dax Williams
Business Administrator, Windchill
Lifetime Products, Inc.
-<">mailto:->

[cid:image001.jpg@01C9A7AB.24AB92C0]
Top Tags