Dynamics Ax 2012 – AIF Import CSV File

Hi there!

While searching for an answer on weather some file data could be imported into AX 2012 via AIF I found Shashi's Ax.Net Space blog.

In the article I'm to share he explains, in detail, the following:

1. Create a transformation library using the Microsoft.Dynamics.IntegrationFramework in a Visual Studio Solution.
2. Creating classes from XSD, and
3. Loading the transformation library back into AX 2012.

You can access his article from HERE

Microsoft Dynamics AX 2012 White Paper: Selecting the Best Development Technology for Your Application Development Scenario

Microsoft Dynamics AX 2012 provides developers with new choices for programming models and developer technologies.

The following link discusses the following topics:

• Development patterns in Microsoft Dynamics AX 2012

• Programming models available in Microsoft Dynamics AX 2012

• Changes to the core development framework in Microsoft Dynamics AX 2012

• Selecting the appropriate programming model for your development patterns

• The Microsoft Dynamics AX development technologies road map

Here is the link!

http://www.microsoft.com/download/en/details.aspx?id=24322

strRem Function - Delete a Character from String - AX 2009

The following code searches a specified string character and deletes it. The cool thing about this function is that it is case sensitive.

str strRem(str text1, str text2)

text1  The string from which to remove characters.

text2 The characters to exclude from the output string.

For example:

strRem("MynameIs","is"); //Returns the string "MynameI".

Get the length of a string in x++

str _myString = '123456789';
int _len;
;

len = strlen(myString);

info(strfmt('%1', len);

returns 9

SubStr function - Axapta

str SubStr (str _text, int _position, int _chars)

SubStr("MyString",20,3);  // Returns ""

SubStr("MyString ",4,50);  // Returns "tring"

Workaround to Exception::CLRError using System.IO.StreamWriter

In one of my projects I was using the System.IO.StreamWriter to write data into a text file in X++. Everything went well until I started testing for exception in order to handle them (the System.IO is a .Net class that allows us to maniluplate file operations, including folders. So, I though in catching the exception with the Exception::CLRError one. )

The problem I was having was that when an exception was raised by a problem creating the file (Incorrect file name), the operation will not fall into the Exception::CRLError exception, Instead, it would just crash and I wasn't able to properly handle the exception.

The reason for this is that when using an AX class that runs on the server, the exception never comes back to the client and therefore cannot be handled correctly. I'm using the SalesFormLetter class main method to call my own class after an invoice is generated, and this class (SalesFormLetter) is (1) an abstract class and (2) runs on the server and I really did not want to do this.

A workaorund is to use the TextIO class in AX along with the FileIoPermission. For example, when using the TextIo to create (and/or overwrite) a file, we get a null value when the file could not be created (and/or overwritten). Then, we can throw an exception when the object is null.

In my case I have a central class that handles all errors, so when the TextIO object is null, I call this class and I throw an error, then the error comes back to my method and falls into the Exception::Error exception.

The following is the code

Lightswitch "How Do I?" Videos - Visual Studio Lightswitch

A few weeks ago I downloaded Visual Studio Lightswitch. I'm still getting to know the application and new features that are offered by Microsoft. You can have a full definition of Visual Studio Lightswitch here:

https://community.altiusconsulting.com/blogs/mikevinson/archive/2010/11/09/microsoft-visual-studio-lightswitch-what-is-it.aspx

I do have to say that the development of business applications has been taken to the next step. I think the most interesting aspect of Visual Studio Lightswitch is that we can now develop apps for the cloud. This is really interesting to me as I'm getting into SharePoint development and I just read that Microsoft will have the Office 365 available really soon.

Anyway the Silverlight team has some interesting tutorials about developing data-centered silverlight apps for the web by using Visual Studio LightSwitch. You can find it here:

http://team.silverlight.net/announcement/announcing-visual-studio-lightswitch-beta-2-is-available/


Also, the MSDN LightSwitch has some easy to understand How Do I videos around Visual Studio LightSwitch here:

http://msdn.microsoft.com/en-us/lightswitch/gg604823

114 windows forms tutorials - Thanks Joe Stagner

The following is a great resource on tutorial for win forms.

http://www.msjoe.com/2011/03/windows-forms-training-videos-114/?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+MSJoe+%28MSJoe%29

Creating a simple Pager user control with ASP.NET and C#

The following is a simple user control that will display a Pager functionality for any type of web page that deals with large amount of data that need to be segmented in pages.

This is part of a larger project and perhaps in the future I will present the finished project, but for now this user control can help us organize our data with a data list.

1. Create a new web site project in Visual Studio
2. Add a new Web User control named Pager.
3. In Source View (Asp.Net) write the following code
4. <%@ Control Language="C#" AutoEventWireup="true" CodeFile="Pager.ascx.cs" Inherits="UserControls_Pager" %>
   <p>
   Page
   <asp:Label ID="currentPageLabel" runat="server" />
   of
   <asp:Label ID="howManyPagesLabel" runat="server" />
   
   
   <asp:HyperLink ID="previousLink" runat="server">Previous</asp:HyperLink>
   
   
   <asp:Repeater ID="pagesRepeater" runat="server">
       <ItemTemplate>
           <asp:HyperLink ID="hyperlink" runat="server" Text='<%#Eval("Page") %>' NavigateUrl='<%#Eval("Url") %>' />
       </ItemTemplate>
   </asp:Repeater>
   <asp:HyperLink ID="nextLink" runat="server">Next</asp:HyperLink>
   </p>

Schedule a Windows Task to call an ASP.NET web page - ASP.NET - VB.NET, Windows Task Scheduler

The following is how you can schedule a windows task that can call an ASP.NET web page. Usually we want to schedule task from Windows. I have seen lots of questions regarding this in the past.

The cool thing about Windows task is that you can execute custom jobs to be executed in the server without the need of a user to be logged in.

The following code can be used to call ASPX web pages to run a specific job that needs to execute some sort of logic. The script is written in VB.NET, but the web page can be written with C# as the vbscript only is used to create the call from the server to the page.

The steps are as follow:

Data List Control (.NET) - Create a fully dynamic user control that handles URL links and Css Classes - ASP.NET

A few days ago I wrote a post on how to create a fully dynamic Link class in C# that will return a full query string based on what a user is clicking within a page. In the following example I'll present the table design, Stored Procedure, C# class, CSS Class and ASP.NET user control I'm using to