Alfasith AX

Alfasith AX
اللَّهُمَّ انْفَعْنِي بِمَا عَلَّمْتَنِي، وَعَلِّمْنِي مَا يَنْفَعُنِي، وَزِدْنِي عِلْمًا

Sunday, August 9, 2015

DMF Issue - "Could not load file or assemble.The system cannot find the file specified"

Hi,

DMF Issue - "Could not load file or assemble.The system cannot find the file specified".


There are list objects and files should be available in certain folders on installing the DMF.

A. Installation procedure.

1. Data Import / Export Framework (DIXF) service should be installed on a SQL Server machine.
2. AOS component should be installed on AOS server machine.
3. Client can be installed any machine.

B. Verify the existence of files and objects in the directory.

1. AOS server:
Dir: 'C:\Program Files\Microsoft Dynamics AX\60\'

Microsoft.Dynamics.AX.Framework.Tools.DMF.DriverHelper
Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper
Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelperService
Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelperService.exe

2. Client system.
Dir: 'C:\Program Files (x86)\Microsoft Dynamics AX\60\Client\Bin\'

Microsoft.Dynamics.AX.Framework.Tools.DMF.DriverHelper.dll
Microsoft.Dynamics.AX.Framework.Tools.DMF.Mapper.dll
Microsoft.Dynamics.AX.Framework.Tools.DMF.PreviewGrid.dll
Microsoft.Dynamics.AX.Framework.Tools.DMF.ServiceProxy.dll

C. Add the users in to Microsoft Dynamics AX Data Import Export Framework Service Users. 
D. Activate the DMF inbound services in AX client.
E. Restart the AOS.

Regards,

X++ code to delete the employee

Hi,

static void AlfasithDeleteAnEmpl(Args _args)
{
    HcmWorker hcmWorker,hcmWorkerSel;
    HcmEmployment  hcmEmployment,hcmEmploymentSel;
    DirPartyTable  dirPartyTable,dirPartyTableSel;
    DirPerson      dirPerson,dirPersonSel;
    DirPersonName  dirPersonName,dirPersonNameSel;
    DirAddressBookParty  dirAddressBookParty,dirAddressBookPartySel ;
        int n=0;
    ;

     select hcmWorker where  hcmWorker.PersonnelNumber == "000097";
    // If you dont select particular personnel number you can delete complete employees..
    select HcmEmployment where hcmEmployment.Worker == hcmWorker.RecId;
    select dirPerson where dirPerson.RecId ==hcmWorker.Person;
    select dirPartyTable where dirPartyTable.RecId == dirPerson.RecId;
    // deleting the selected records as follows...
    delete_from dirAddressBookParty where dirAddressBookParty.Party == dirPartyTable.RecId;
    delete_from dirPersonNameSel where dirPersonNameSel.RecId == dirPerson.RecId;
    delete_from dirPartyTableSel where dirPartyTableSel.RecId == dirPartyTable.RecId;
    delete_from HcmEmploymentSel where HcmEmploymentSel.RecId == HcmEmployment.RecId;
    delete_from dirPersonSel where dirPersonSel.RecId == dirPerson.RecId;
    delete_from hcmWorkerSel where hcmWorkerSel.RecId == hcmWorker.RecId ;
    n++; // Here I'm Alfasith made n++ for printing the no of deletion in records...
    print n;
    pause;
}

Regards,

Get a table ID in SQL - D365

Hi select ID from SysTableIdView where  SysTableIdView .Name = 'CustTable' Regards,