Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Type Designer - propagating properties of types

Status
Not open for further replies.

mlapse

IS-IT--Management
Jun 30, 2005
82
US
I have a trading partner who wants to send me EDI data. The catch (there always seems to be one) is that they want to send the data without any delimiters, only segment terminators which are <NL>'s.

The data for each field is to be padded with spaces to the max length (in case the data isnt that big).

The looping etc. of the file is just like EDI.

The issue is how do I change the properties of all the groups and items within those groups to be a fixed size and padded to the max length. I cant seem to do this in the type designer.
 
You would have to change each ITEM in Type Designer. Set Pad to Yes and Padded To to Fixed Size
 
i meant is there any way to change them all together? there are over 200 items in the type tree.
 
Can you export the type tree, edit the xml and reimport it?
 
What EDI standard are they using? Unless they are the 700 lb. gorilla, you should be able to make them stick to someones EDI standard.

The whole idea of EDI is to keep the data standardized.



BocaBurger
<===========================||////////////////|0
The pen is mightier than the sword, but the sword hurts more!
 
BocaBurger, could be that they aren't a 700 lb gorilla but they have 700 lb friends ;)

Did something similar here. reimported tree in a fashion that caused fixed length as default. Ended up being slightly less work in the end because I still need to confirm various aspects of the tree still applied and add rules that weren't imported.

janhess, would that be exporting to an mts file and editing that? looks like it might be about as much work doesn't it?
You'd have to add something like the following:

<PadText Justify="LEFT" ApplyPad="ANYCONTEXT"><PadValue>&lt;SP&gt;</PadValue>
<PaddedToFixedSize Length="1"/>

but changing the pad value and length for each element. Not an XML guy though so maybe I'm missing something.
 
I'd probably use a bit of xsl to change the Items in the mts file but otherwise if there are lots of different item lengths it may take as long to do manually.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top