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,

Release the product using X++

Hi,

static void AlfasithReleaseProducts(Args _args)
{
EcoResProductReleaseManagerBase::releaseProduct(
                EcoResProduct::findByProductNumber('1022214').recId,
           CompanyInfo::findDataArea('CEU').RecId);
    info("Product released");
    // here Product name and item name & Product ID and Item Id will be same...
}

Regards,

DMF issue - Access denied for the user - On clicking preview data

Hi,

DMF issue -"Access denied for the user" on-clicking preview data in after validating.

1.This error will be retained even you add the user into Microsoft Dynamics AX Data Import Export Framework Service Users .
 For that we need to update the server (Windows updates ) and restart the server.  This will solve your issue.

Regards,

DMF issue - Access denied for the user

Hi,

"Access denied for the user".

This error will be prompted in many cases.
This is post will solution for the prompt during the validation of shared folder and my next post will be explain to preview records after validating.

1. Make sure that concern folder granted with full rights to everyone.

2. in shared working directory needs to mentioned as "\\serverName\FolderName\"  not as Drive:\Folder\ 

3.Add the DMF user in to local user group of Microsoft Dynamics AX Data Import Export Framework Service Users.

4. Restart the AOS.

Regards,

DMF issue - The version of Microsoft Excel is not supported.

Hi,

"The version of Microsoft Excel is not supported.-The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine"

When this error prompts then we need to install the driver for th MS excel with reference to the OS bit (32 or 64).

Microsoft Access Database Engine 2010 Redistributable' (AccessDatabaseEngine_x64.msi) for 64 and same file ends with 32 for 32 bit.

PFB the URL for Microsoft page for downloading both the drivers.

http://www.microsoft.com/en-us/download/details.aspx?id=13255

Regards,