AIF Transformation of Sales Order and ASN - Custom Code in Class Library

We used the following code to meet specific requirements of transformation.

1- Sales Order Transformation


  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Text;
  5. using System.Xml;
  6. using System.IO;
  7. using Microsoft.Dynamics.IntegrationFramework.Transform;

  9. namespace SalesOrderTransform
  10. {
  11.     public class Class1:ITransform
  12.     {
  13.         public void Transform(System.IO.Stream input, System.IO.Stream output, string config)
  14.         {
  15.             StreamReader sreader = new StreamReader(input);
  16.             XmlTextWriter xwriter = new XmlTextWriter(output, Encoding.UTF8);

  18.             string tagName = "SalesOrder";

  20.             string inputXml = sreader.ReadToEnd();

  22.             xwriter.WriteStartElement(tagName);

  24.             xwriter.WriteString(inputXml);

  26.             sreader.Close();

  28.             xwriter.WriteEndElement();
  29.             xwriter.Close();

  31.         }
  32.     
  33.     }
  34. }





2- ASN Transformation
  1. namespace AsnTransform
  2. {
  3.     using Microsoft.Dynamics.IntegrationFramework.Transform;
  4.     using System;
  5.     using System.IO;
  6.     using System.Reflection;
  7.     using System.Xml;
  8.     using System.Xml.XPath;
  9.     using System.Xml.Xsl;

  11.     public class AsnTrans : ITransform
  12.     {
  13.         public void Transform(Stream input, Stream output, string config)
  14.         {

  16.             Stream inputXML = File.Open(@"AsnTransform.AsnStylesheet.xslt", FileMode.Open);          
  17.             if (inputXML != null)
  18.             {
  19.                 XPathDocument document = new XPathDocument(input);
  20.                 XPathDocument stylesheet = new XPathDocument(inputXML);
  21.                 XslCompiledTransform transform = new XslCompiledTransform();
  22.                 transform.Load(stylesheet);
  23.                 XmlWriterSettings settings = new XmlWriterSettings
  24.                 {
  25.                     OmitXmlDeclaration = false,
  26.                     Indent = true
  27.                 };
  28.                 XmlWriter results = XmlWriter.Create(output, settings);
  29.                 transform.Transform((IXPathNavigable)document, null, results);
  30.                 results.Close();
  31.                 output.Close();
  32.             }
  33.             else
  34.             {
  35.                 output = input;
  36.             }         
  37.         }
  38.     }
  39. }
One the coding is done. We need to setup the transformation by using the following steps

Place the DLL to Client and Server Folders first.

 1- Client Path
C:\Program Files (x86)\Microsoft Dynamics AX\60\Client\Bin

 2- Server Path
C:\Program Files\Microsoft Dynamics AX\60\Server\MicrosoftDynamicsAX\bin
1- Setup Tools > AIF > Manage Transform from your Development Environment. Point to the DLL from the Client Path as follows. May be different for others
C:\Program Files (x86)\Microsoft Dynamics AX\60\Client\Bin

2- Once its setup then go to System Administration > Services and Application Integration Framework > Outbound Ports 

Click the checkbox Transform all responses and select the appropriate transformation as defined in the development environment. 

3- Now verification is required from Batch Jobs to check the transformation. Need to check if batch jobs are running properly to ensure document outputs.



Comments

Post a Comment

Popular posts from this blog

Export Data from AX 2012 - using DIXF (Data Migration Framework)

Importing is a well known task using DIXF, but at times we do need to export as well and then import it back in AX 2012. The export task can be done with the help of this information. https://technet.microsoft.com/en-us/library/dn144987.aspx Define the format of your source data Open  Data Import/Export Framework  >  Setup  >  Source data formats . Click  New , enter a name and a description, and then select  AX  from the  Type  list. Define a processing group to export data from Microsoft Dynamics AX Change the company to  CEU . In  Data Import/Export Framework , click  Common  >  Processing group , and then click  New  to create a new processing group. Set the group name to  Export-Cust  and add a description. Click  Entities  to select the entities to include in the processing group. In the  Select entities for processing group  form, click  New , and then, for an entity name, select  Customer . In the  Source data format  fiel
Read more

The virtual path maps to another application, which is not allowed

Image
During the development we came across this issue, which wasted a lot of our precious time. So I decided to share its solution with everyone. We have Project and Sub-Project Structure i.e. we have a root project and several sub-projects. The ROOT Project is entitled as TEMS8 and all other subprojects have been configured as per the image below. (Click on the image for large size) Now after setting up everything on a new Machine, we came across the Error as The virtual path maps to another application, which is not allowed Finally after investigation, we figured out that we have created multiple virtual directories which mainly causes the issue. For instance, we have another virtual directory created for DATADEF which is inside the virtual directory of TEMS8. So this was the main issue. The resolution was to remove the DATADEF Virtual Directory. Everything worked out perfectly, once we removed the inner virtual directory. We should not have something like this image below  W
Read more