on 11-21-2006 4:16 PM
I am receiving files from a legacy with material dimensions as L x W x H as whole numbers and fractions. The end goal of the user is to always retrieve the dimensions with the fractions.
How is it possible to import those fractions in a way where the UOM can be modified and still retain fractions? How does the show fraction functionality handle different UOM's?
Is it correct then to request that external data being imported be passed to MDM as whole numbers and 3 decimals for L x W x H in inches as a delimited text field? (ex. 1.500 in;2.750 in;4.625 in for 1 ½ in X 2 ¾ in X 4 5/8 in).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Brent,
No, I don't think this is necessary.
It's OK if the data you have contains fractions since MDM can handle this.
Also, you don't need to combine the three fields(L, W, H) into a delimited text field if the client systems have them as separate fields. You should have separate fields for Height, Width and Length in MDM so it's actually easier to map if they are also separated in the client systems. If they are combined in the client systems, then the MDM Import Manager allows you to split them into separate fields and map them to the individual fields in MDM.
Hope this helps,
Richard
Hi Brent,
Measurement fields in MDM are a compound data type that support a numeric value along with a physical dimension e.g. length and a unit of measure e.g. inches, feet, etc... This field type can also support fractions which is enabled via the Show Fractions property. The dimension and default unit of measure are defined as part of the field and cannot be changed. The unit of measure itself can be changed as needed by the user.
When you are import your material dimensions, make sure you map them to a measurement type field so that MDM will store all of the information (whole numbers, fractions, UOMs, etc... Depending on how the data is structured in you legacy file, configuration in the Import Manager might be required. There is good information about importing measurement data in the Import Manager Reference Guide or feel free to post additional questions.
I'm not sure if i exactly answered your question but i hope it helps.
Richard
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.