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

Community Tip - New to the community? Learn how to post a question and get help from PTC and industry experts! X

Upload Global Enumerations from excel or csv file?

rdanner
1-Visitor

Upload Global Enumerations from excel or csv file?

Does anyone know if global enumerations can be added using an excel, csv or xml file using LoadFromFile or other tool? I have a list that is 250 rows and I do not want to type in each one.

1 REPLY 1
Valam
1-Visitor
(To:rdanner)

Yes this is possible.

I had a lot of lists to upload.

Here is my template for each item:

<!-- enum membership -->

<csvBeginEnumMemberView handler="com.ptc.core.lwc.server.BaseDefinitionLoader.beginProcessEnumMembership">

<csvname>«code»</csvname>

</csvBeginEnumMemberView>

<!-- entry properties -->

<csvPropertyValue handler="com.ptc.core.lwc.server.BaseDefinitionLoader.processEnumEntryPropertyValue">

<csvname>displayName</csvname>

<csvvalue>«description»</csvvalue>

</csvPropertyValue>

<csvPropertyValue handler="com.ptc.core.lwc.server.BaseDefinitionLoader.processEnumEntryPropertyValue">

<csvname>description</csvname>

<csvvalue>«description»</csvvalue>

</csvPropertyValue>

<csvPropertyValue handler="com.ptc.core.lwc.server.BaseDefinitionLoader.processEnumEntryPropertyValue">

<csvname>tooltip</csvname>

<csvvalue>«description»</csvvalue>

</csvPropertyValue>

<csvPropertyValue handler="com.ptc.core.lwc.server.BaseDefinitionLoader.processEnumEntryPropertyValue">

<csvname>selectable</csvname>

<csvvalue>true</csvvalue>

</csvPropertyValue>

<!-- entry link properties -->

<csvPropertyValue handler="com.ptc.core.lwc.server.BaseDefinitionLoader.processEnumMembershipPropertyValue">

<csvname>sort_order</csvname>

<csvvalue>«rank»</csvvalue>

</csvPropertyValue>

<csvEndEnumMemberView handler="com.ptc.core.lwc.server.BaseDefinitionLoader.endProcessEnumMembership"/>

You may find a complete xml file in the default dataload files.

I hope this helps,

VA

Announcements


Top Tags