Microsoft Excel CSV import fails to import the distinctive enumerated values to Rational doorways

difficulty(abstract)

When a Microsoft Excel CSV sheet (with dissimilar enumerated values separated with the aid of a semi-colon) is imported to Rational doorways; the dissimilar enumerated values are handled as a single string.

Symptom

The assorted enumerated values are displayed in a single string after the import

trigger

Rational doorways fails to discover the numerous enumerated values in Microsoft Excel CSV right through the import.

ambiance

Microsoft windows, Rational doors - All models, Microsoft office - All types

Resolving the problem

with the intention to overcome this, please separate the distinctive enumerated values in the Microsoft Excel CSV (comma separated cost) sheet after which make the quintessential environment changes in Rational doors as described beneath in order that Rational doorways recognizes them as an enumerated Multi-valued attribute.

that you could separate these values within the Microsoft Excel CSV sheet by using the key combos ALT+ENTER to fill diverse values in a single mobile and then retailer the spreadsheet in CSV structure.

subsequent, make the indispensable settings alterations in Rational doors earlier than the import. For that follow the steps beneath:

1. Create an attribute of classification "Enumerations" in Rational doors.

2. deliver the equal values which are there within the Microsoft Excel CSV spreadsheet.

3. whereas, creating an attribute on the basis of class "Enumeration", select the option of "Multi-valued".

4. Now try importing the Microsoft Excel CSV spreadsheet.

Related products

Scheduler123: Excel-based Production Scheduling System

The Excel Nexus