Using EDIFabric to Determine File Type

• 

  Robert Rathman

  • April 03, 2023 17:14

  Hi,
  
  I create empty lists of edi messages ( = new List<EdiMessage>() ) matching the file types I am possibly expecting (one list per type). open the files one at time using the X12Reader, read the file to a list of EdiItems using StreamReader, then for each EdiItem in the list I check if it contains the type I am looking for, if so, add it to the appropriate EDI message list to process after all files have been processed from the SFTP server.
  
  There are more elegant ways to perform this process but this has worked fine for me.
  
  

  Stream ediStream = new StreamReader(filepath).BaseStream;
              List<EdiItem> ediItems;
              List<EdiMessage> edi944s = new List<EdiMessage>();
              List<EdiMessage> edi945s = new List<EdiMessage>();
              List<EdiMessage> edi997s = new List<EdiMessage>();
              List<EdiMessage> edi947s = new List<EdiMessage>();
              List<EdiMessage> edi846s = new List<EdiMessage>();

              try { 
                  using (var ediReader = new X12Reader(ediStream, "EDI Fabric", Encoding.ASCII, true))
                  {
                      ediItems = ediReader.ReadToEnd().ToList();

                      foreach (EdiItem ediItem in ediItems)
                      {
                          if (ediItem.ToString().Contains("944"))
                          {
                              edi944s.Add((EdiMessage)ediItem);
                          }
                          if (ediItem.ToString().Contains("945"))
                          {
                              edi945s.Add((EdiMessage)ediItem);
                          }
                          if (ediItem.ToString().Contains("997"))
                          {
                              edi997s.Add((EdiMessage)ediItem);
                          }
                          if (ediItem.ToString().Contains("947"))
                          {
                              edi947s.Add((EdiMessage)ediItem);
                          }
                          if (ediItem.ToString().Contains("846"))
                          {
                              edi846s.Add((EdiMessage)ediItem);
                          }

                      }

                      //Process 947s
                      foreach (EdiMessage ediMess947 in edi947s)
                      {...}

  
  
   
  
  
  

  0
• 

  Dshoultz

  • April 03, 2023 20:52

  Thanks you very much, Robert. This looks like a good approach and I'll try to create a working example in my project with it.

   

   

  0
• 

  Admin

  • Edited April 05, 2023 08:39

    Hello,

  Here is how you resolve the message type before loading the appropriate template. Here is the GitHub example.

  Another example of how to determine the message type is by checking the type - example in GitHub.

  So, in the snippet above you won't do (because you'll be doing a second foreach, and no need to do ToString):

  foreach (EdiItem ediItem in ediItems)
  {
       if (ediItem.ToString().Contains("944"))

  but do this:

  using (var ediReader = new X12Reader(ediStream, "EdiFabric.Templates.X12"))
  {
   while (ediReader.Read())
    var m944 = ediReader.Item as TS944;
    if (m944 != null && !m944.HasErrors)
    {
    edi944s.Add(m944)
    }

  0

Please sign in to leave a comment.