Insert text qualifier while Importing CSV file by X++

Hi, 
When importing CSV file by X++ code in Dynamics AX we may encounter a situation when we need to eliminate extra string from master data . That string may be in form of an extra comma or | or speech mark or any other symbol. To achieve this goal and clean maser data i have written a job. Good Luck 


static void Job669(Args _args)

{
    str         _text,note,cleanText;
    int         charpos,s1,s2,i,more;
    int         x;
   char        RepChar = ',';
   char        RepCharWith = ' ';
    str text(str text)
    {
        s1 = strFind(text,'"',1,strlen(text));
        s2 = strFind(text,'"',s1,strlen(text));
        for (i=s1;i<s2+4;i++)
        {
            charpos = strScan(text,',',s1,s2);
            text = strpoke(text,' ',charpos);
            s1 = strFind(text,'"',1,strlen(text));
            s2 = strFind(text,'"',s1+1,strlen(text));
            charpos = strScan(text,',',s1,s2);
            if (charpos > s2)
            {
                break;
            }
        }
        if (s1 || s2)
        {
            text = strdel(text,s1,1);
            text = strdel(text,s2-1,1);
        }
        return text;
    }
    ;
    more = 1;
    _text = 'AXT001,"House,42,ENF",Enfield,"U,K"';
    while( more !=0)
    {
        _text = text(_text);
         more = strFind(_Text,'"',1,strlen(_Text));
    }
    info(_text);
}

Dilip's blog on DYNAMICS AX: Dynamics AX Salary Report (Detailed Analysis from ...

Dilip's blog on DYNAMICS AX: Dynamics AX Salary Report (Detailed Analysis from ...: 1 - Introduction This global salary survey is the largest completed to date that focuses specifically on the Microsoft Dynamics communit...

Creating a View in Dynamics AX

Hello Everyone, In this blog i gonna show you how to create a simple view in Dynamics AX that consists of ItemID, Name, Sales ID, Customer Group and Customer Name using the following steps:
1. Right-click on the Views node and select New View. A new view will be created. You can open its properties by right-clicking and selecting Properties. 

2. Change the name of the view to InventSalesCust and give it a label that describes the contents of the view.  

3. The views can actually use queries that have already been created as a base for the data selection. This is done in the Properties of the view by choosing the query from the Query property. However, in our example, we will create the view from scratch. 

4. Under the Metadata node, right-click on the Data Sources node and select New Data Source 

5. Select the newly created data source and enter InventTable in the table property. The name of the data source will automatically change to InventTable_1, which is normal. 

6. Under the InventTable data source, find the Data Sources node, right-click on it, and select New Data Source. This time, we want to use the SalesLine table so change the table property to SalesLine. Also change the relations property to Yes in order to get the link between the two tables active in the view. 

7. Do the same to add the CustTable as a child data source to the SalesLine.

8. The next step is to define the fields that should be made available when this query is executed. Simply drag fields you need to use in the view from the InventTable_1,SalesLine_1, and CustTable_1 data source and drop them onto the Fields node. 

9. You should now have a view that looks like the following screenshot:

Delete all the transactions from Dynamics AX

‎ Hi, to delete all the transactions from Dynamics AX 2009-12 please take the following steps .
1- go to AOT
2-open the classes
3-search on SysDatabaseTransDelete class
4- right click on the this class
5-choose open
6-click yes on the message box appear to you
7-info will appear to you "operation completed"

Microsoft Dynamics Ax 2009 web project template is missing in visual studio 2008

If you cant see the Dynamics AX Web Project template in Visual Studio, please go through the following list:

If a user can see Microsoft Dynamics Ax Web Project template it’s because in his/her profile on system the template is available. In general the template is located on a windows 2003 server at C:\Documents and Settings\[user id ]\My Documents\Visual Studio 2008\Templates\ProjectTemplates\Visual Web Developer\CSharp\ AxWebProject.zip

To make Microsoft Dynamics Ax Web Project template available for other users copy the Templates folder from the user who can see template and paste it to other users’ profile It assumed that your templates are available in the default located as mentioned in above path

1.    Go to C:\Documents and Settings\[user id ]\My Documents\Visual Studio 2008\

2.    Copy Templates folder

3.    Open the other users’ profile and go to C:\Documents and Settings\[user id ]\My Documents\Visual Studio 2008\

4.    Paste the Templates folder. If system says to overwrite it click on yes option.

5.    You may need to refresh Visual Studios cache of templates after copying them:

6.    Open the Visual Studio command prompt (Start \ Programs \ Microsoft Visual Studio 2008 \ Visual Studio Tools \ Visual Studio 2008 Command Prompt) and type devenv /installvstemplates.

7.    If you still don't see the template, remember that you need to select C# as your project programming language before it shows up.

If you can see the template but can't connect to the AX AOS from Visual Studio check the following:

1.    Check that .NET Business Connector has been correctly installed and that the configuration points to the correct AOS instance.

2.    Check that the user you run Visual Studio with, has login and proper development permissions in AX.

 

3.    Check that the "Dynamics AX Enterprise Portal Tools" Add-in is correctly installed in Visual Studio. Open Visual Studio / Tools / Add-in Manager to verify that Add-in is correctly installed and configured. If you can't see it, you must reinstall the EP Development Tools.

Sequence of Form's Methods in Dynamics AX

This gives the information of method calls in the form level while

1. Opening the Form.

2. Creating/Updating/Deleting the record in the Form.

3. Closing the Form.

Sequence of Methods calls while opening the Form

Form — init ()

Form — Datasource — init ()

Form — run ()

Form — Datasource — execute Query ()

Form — Datasource — active ()

Sequence of Methods calls while closing the Form

Form — canClose ()

Form — close ()

Sequence of Methods calls while creating the record in the Form

Form — Datasource — create ()

Form — Datasource — initValue ()

Table — initValue ()

Form — Datasource — active ()

Sequence of Method calls while saving the record in the Form

Form — Datasource — ValidateWrite ()

Table — ValidateWrite ()

Form — Datasource — write ()

Table — insert ()

Sequence of Method calls while deleting the record in the Form

Form — Datasource — validatedelete ()

Table — validatedelete ()

Table — delete ()

Form — Datasource — active ()

Sequence of Methods calls while modifying the fields in the Form

Table — validateField ()

Table — modifiedField ()

Highlight the Selected Record Row in Axapta Report

Hi,
To highlight the  row in axapta report based on specific value just add the following code in the execution section  of section group.

public void executeSection()
{
    int usecolor
    ;
    usecolor=WinApi::RGB2int(255,0,0);
    if(inventTable.itemprice>5)
    {

        this.foregroundColor(usecolor);
    }
    else
    {
        this.foregroundColor(white);
    }
    super();

}

this will highlight all the record where item greater then 5.
I hope it works .
Regards,