My own EDI schema

Home Page Forums BizTalk 2004 – BizTalk 2010 My own EDI schema

Viewing 1 reply thread
  • Author
    Posts
    • #15255

      How can i create my own EDI schema (EDIFACT) for messages not supported by the base adapter?

    • #15256

      [quote:e35485e4d7=\”myPFerreira\”]You should see this:
      http://support.microsoft.com/kb/840113/en-us

      and use this page to see the codelist, and structure for your schema:
      http://www.stylusstudio.com/edifact/

      I was able to sucessfully construct a D96A standard:
      http://www.stylusstudio.com/edifact/D96A/ORDERS.htm%5B/quote:e35485e4d7%5D

      Do I need then the stylus Studio?

      • #15257

        I don’t know, as I am to begin. Do you know an exemplification?

        • #15258

          [quote:2c8e7e6965=\”CodeCola\”]This likely wont work or is very very difficult, use a Flat File schema.[/quote:2c8e7e6965]

          What about EDI Validation?

          There are a variety of syntax rules for each EDI message. Things like:
          -this segment is required
          -this element is required
          -if element A is used element B is required
          -one of the following Elements must be used
          -the element value must be in the enumeration
          etc…

          Not important?

          • #15259

            You should see this:
            http://support.microsoft.com/kb/840113/en-us

            and use this page to see the codelist, and structure for your schema:
            http://www.stylusstudio.com/edifact/

            I was able to sucessfully construct a D96A standard:
            http://www.stylusstudio.com/edifact/D96A/ORDERS.htm

            • #15260

              No, of course not!

              Read the Microsoft guide!
              The stylus studio page is only to help you creating the schema (I’m supposing you want to creat an existing standard schema), and to help you with the codelist.

              • #15261

                I have a D96A (EDIFACT), but as you figure I’m not allowed to make it \”public\”.

                But the Microsoft article is very clear.

                1 – New project with an Ochestration with a receive (set to receive a file) and a send shape (set to send XML)
                2 – configure the two parties (one with the sender and other receiver id codes)
                3 – Create the schema (use an existing standard and modify it, see the stylusstudio page to see the structure you want, or if it’s !your own structure build it according to the rules on the article apge)
                4 – Build the a table with you codes and values on the codelist database
                5 – configure ports,and you are good to go.

                I think I’m not missing nothing.

                • #15262

                  build your schema!!! It will work!! 🙂

                  • #15263

                    Read the Microsoft article!!! 🙂

                    It’s not an SQL table, it’s a simple MS Access database table.
                    It’s location by default is:
                    C:\\Program Files\\Microsoft BizTalk Server 2006\\EDI\\Adapter\\CodeLists\\EDICodeLists.mdb

                    I forgot to mention that on the schema file you have to configure it and say that the codelist database is located at the path I referred.
                    To do this click on the <Schema> node and on the properties under Biztalk you have a field named \”codelist database\”.

                    • #15264

                      This likely wont work or is very very difficult, use a Flat File schema.

                      • #15265

                        [quote:4809a0cffb=\”myPFerreira\”]I have a D96A (EDIFACT), but as you figure I’m not allowed to make it \”public\”.

                        But the Microsoft article is very clear.

                        1 – New project with an Ochestration with a receive (set to receive a file) and a send shape (set to send XML)
                        2 – configure the two parties (one with the sender and other receiver id codes)
                        3 – Create the schema (use an existing standard and modify it, see the stylusstudio page to see the structure you want, or if it’s !your own structure build it according to the rules on the article apge)
                        4 – Build the a table with you codes and values on the codelist database
                        5 – configure ports,and you are good to go.

                        I think I’m not missing nothing.[/quote:4809a0cffb]

                        A question on point number 4… what’s the a table? and where to find it? Is is in the BizTalkEDIDb database…

                        thx

                    • #15594

                      [quote user="myPFerreira"]Read the Microsoft article!!! 🙂

                      It's not an SQL table, it's a simple MS Access database table.
                      It's location by default is:
                      C:\\Program Files\\Microsoft BizTalk Server 2006\\EDI\\Adapter\\CodeLists\\EDICodeLists.mdb

                      I forgot to mention that on the schema file you have to configure it and say that the codelist database is located at the path I referred.
                      To do this click on the <Schema> node and on the properties under Biztalk you have a field named \"codelist database\".[/quote]

                       Great! Now it works with any custom schema 🙂

            • #16637

              Hi,

              I want to convert an incoming xml file to an EDI file ie to CODECO D95 EDI format. As CODECO message format is not provided in Biztalk server 2006, i have created my own schema using the same rules and structure specified in http://www.stylusstudio.com/edifact/ and mapping with the incoming schema.

              I m not getting the output. In the event viewer i am the below error. Pls can u tell me what this error means,  i am not able to understand what is the error: 

              Error encountered: ERROR (36), docnr 10002 :
              A required segment is not included in the document. Contact the sender.source format: [101  0  ,XML 1.0]
              source document: [CODECOD  95BDEFAULT          UN,Container gate-in/gate-out report m]
              source segment: [data#3,def#1,name=EFACT_d95b_CODECO]
              source element: [def#1,elm#0,comp#0,name=NADLoop1],  (msgnr:1 segnr:3)(line:1 pos:40 filepos:320)

              Thanks

              My email id is [email protected]

              Gaurav Garg

              • #16642

                It looks like you missing the NAD loop in the input document you are trying to serialize.

                Either add the data, which may not be an option for you , or remove the requirement for it in the schema.  I am not sure how to do that in this hacked context, maybe you can figure it out.
                 

                • #16657

                  When i have to convert an xml file to CODECO EDI D95B message format , i am using Passthru Send Pipeline (as XML Transmit pipeline was giving some error).

                  But i am not getting any output, infact the error msg is "the required segment is not documented" But i have created my the CODECO EDI D95B schema with all the standards in mind.

                  Pls suggest me where i am going wrong. Is it the issue of my schema or a Send pipeline , do i have to use any other pipeline or create any custom pipeline?

                  Thank you

                  Gaurav Garg

            • #21763

              This post really helped to get a headstart into creating my own EDIFACT schema. the stylusstudio website is really a great place to refer to for EDFACT schema.

Viewing 1 reply thread
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.