Sunday, October 14, 2012

Automatic timeout shutdown value is stored in UserInfo table

static void User_Timeout(Args _args)
{
UserInfo userInfo;
;
ttsbegin;
while select forupdate *
from userInfo
{
userInfo.autoLogOff = 30;
userInfo.update();
}
ttscommit;
}

Saturday, October 13, 2012

How export data to csv file in Ax 2009

public static void main(Args _args)
{
    Commaio file;
    container line;
    InventTable inventTable;
    #define.filename("C:\\dpk_Items.csv")
    #File
    ;
    file = new Commaio(#filename , #io_write); or  file = new Commaio(#filename , 'W');
    //file.outFieldDelimiter(';');
    if( !file || file.status() != IO_Status::Ok)
    {
        throw error("File Cannot be opened");
    }
    while select inventTable
    {
        line = [inventTable.ItemId,inventTable.ItemName];
        file.writeExp(line);
    }
}
  As per this you can save the document in any format such as doc,txt,xls only.

How to identify the user that was used to change an object from AOT in AX2012

Get the object name for which we need to track these (user and date&time) information's. Login to SQL Server Management Studio an...