RSS

Monthly Archives: September 2014

DIXF – {CR}{LF} vs {LF}

A client was doing an DIXF Import for a Purchase Order Line entity and kept getting this error.

“The field “VendGroup” is not present in source”

image

INVESTIGATION:

This happened when i tried to preview data or to promote data from csv to staging. What happened was the DIXF framework stores header of csv file to a container and validates these header fields against source that user already defined during mapping.

Container[25] = “VendGroup”
Entity Field.FeldName = “VendGroup”

These 2 should be equal; however, it failed

image

I was thinking there should be a special character that is coming from the csv file which regular text editor can’t see. i used Notepad++ to verify the header and there is {CR}{LF} right behind “VendGroup”

image

{CR} Carriage Return;  {LF} Line feed

SOLUTION

I started looking at “Source data format” of the entity and realized it was using “{LF}” as row delimiter. That explained why the method confind could not match the string because of special character {CR}

Container[25] = “VendGroup{CR}”
Entity Field.FeldName = “VendGroup”

image

Changing row delimiter from {LF} to {CR}{LF} fixed my problem.

Advertisements
 
1 Comment

Posted by on September 9, 2014 in Development

 

Tags: , , , ,

Azure Service Bus 101

I’m in a process of configuring Active Directory Federation Services , Azure Service Bus and Microsoft Dynamics AX Connector for Mobile Application. I asked myself what is Azure Service Bus. A basic tutorial of Azure Service Bus can be found here
http://channel9.msdn.com/Shows/Azure-Friday/Azure-Service-Bus-101-with-Dan-Rosanova

 
Leave a comment

Posted by on September 9, 2014 in Development

 

Tags: , , , , ,

 
%d bloggers like this: