LostBoysThinking

LostBoysThinking
Second Star

"Multiple REF fields in X12-856 EDI schema" by Jim on May 23, 2008, 1:48 pm, in category BizTalk Mapping

We answered this question on the MSDN forums: The question was:

I want to have the following in the outgoing 856 schema : two REF fields populated from 2 different fileds from source xml .

REF*BM~
REF*LP~

supplierParty maps to REF01 in 1st REF node
billoflading maps to REF01 in 2nd REF node

I need two seperate REF segments for the two fields . How can I do this? I tried changing the schema , but it throws me run time schema vali.....

(Read more...)

Comments

"New Direction for SSPS" by Jim on May 23, 2008, 1:41 pm, in category General

For the record, SSPS has resigned as a Covast services provider. Covast is moving into the business of providing services (see www.motion10.com) which places them in direct competition with us. We felt that having clients pay extra to get our services through them was not the best option for the clients. There was no animosity in the separation, which we initialized; just hope that clients and us would benefit from direct contractual agreements......

(Read more...)

Comments

"Forcing an N3 Loop" by jimdawson on May 5, 2008, 2:33 pm, in category BizTalk Mapping

I recently answered a question on forcing a loop.  The input:

   Address1
   Address2
   Address3

needed to be output in the format:

  N3*Address1*Address2
  N3*Address3

The looping functoid would not work since the addresses were children of the party, and the party was already looping.

Forcing a loop is often difficult.  We've found that a quick way to handle this when.....

(Read more...)

Comments

"Extracting from Loops" by jimdawson on September 11, 2007, 4:26 pm, in category BizTalk Mapping

Given problem

<LineItem>
   <ShippingInfo>
      <ShipCode>01</ShipCode>
      <ShipQuantity>231</ShipQuantity>
   </ShippingInfo>
   <ShippingInfo>
      <ShipCode>02</ShipCode>
      <ShipQuantity>44</ShipQuantity>
   </Sh.....

(Read more...)

Comments

"Mapping Specifications" by Jim on July 3, 2007, 11:07 am, in category General

We have found so many instances where clients want us to create maps for them but they have no specifications that describe the document formats or the mapping rules. The document at the below URL describes why mapping specifications are important and provides basic descriptions of what those specifications should contain. http://www.sspsi.com/Documents/MappingSpecs.doc
Comments

"BizTalk Mapping -- Flattening Data" by Jim on June 25, 2007, 5:01 pm, in category BizTalk Mapping

I saw on a newsgroup a question related to this issue.  The input had two instances of a record.  The data in these two records needed to be output into a single record on the output side.  The problem was that the output was looping to match the input.  Thus the input:

- <File>
- <HeaderRecord>
- <DataRecord>
  <DataItem1>Red</DataItem1>
  <DataItem2>RedItem(loop1)</DataI.....

(Read more...)

Comments

"Gettng the Last Item from a Loop" by Jim on June 22, 2007, 3:58 pm, in category BizTalk Mapping

A client wrote:

------------------
I hope I am not bugging you too much. I have a question. In my test file I have root <File> with two child nodes: <HeaderRecord> and <DataRecord> where each <HeaderRecord> could have many <DataRecord>.

My question is next: "How can I get a value from the very last <DataRecord> node only?" I do not care about all other nodes, but I need a very last one. .....

(Read more...)

Comments

"date format conversion" by Jim on June 14, 2007, 1:17 pm, in category BizTalk Mapping

Jim is on a client site this week, and he asked me to send you a note about your question on date conversion in a map.

There are a variety of ways to transform dates. The fundamental way is to use the string functoids to extract the parts of the date you need and to then re-arrange them in the fashion you want. This example transforms the system date as provided by the date functoid (YYYY-MM-DD) into the format required by EDI (YYYYMMDD). The example us.....

(Read more...)

Comments

"New Categories" by Jim on June 5, 2007, 11:38 am, in category General

We've added new categories to help separate topics. If you need a new one, let us know.
Comments

"Map Converters" by Jim on June 5, 2007, 11:16 am, in category BizTalk Mapping

Ok, this is a rant. A MS partner came to us a couple of days ago having found themselves in deep trouble. They had just run out of time on a project and gotten a two month extension. What happened? MS has a map converter that converts Sterling Gentran maps to BizTalk R2 maps. When I heard that I laughed.

MS is not the only company that claims to have tools that automatically convert maps from one tool to another. They wou.....

(Read more...)

Comments

New Post

Not a user?

July 2008