Cannot create file mapping in Ax2012 Enterprise Portal

How to solve Error: Cannot create file mapping in Ax2012 Enterprise Portal

Sometimes a perfectly fine, up and running Enterprise portal (Role center) will stop working and throw the below error.
Error Message: "An unhandled error has occurred. To view details about this error, enable debugging in the web.config file or view the Windows event logs. Go back to site." 

You will generally get an error message like "Unhandled exception has occurred" or "An error has occurred. Contact your administrator for further assistance" on the Enterprise portal site or on the Ax Thick client (for role centers). But to have the understanding of the actual error, look into the Event Viewer (eventvwr).

Solution:
The solution that worked for me is quite simple to implement and you can give it a try even though you have some other issue related to Enterprise portal.

1. Go to System administration > Setup > Enterprise portal > Deployments
2. In the opened dialog, verify if the Deployment target is pointed to the correct folder (typically DynamicsAx)
   
3. And then click Deploy button, which will updates all static files, web controls, images, and proxy files for a specific Enterprise Portal site and also deploys new page definitions.
   

This will take little time but proved effective everytime for me. Hope this helps. Good luck !!

Import Financial Dimension using Data Import framework | AX 2012 R3

This post illustrate how to import the financial dimension using the data import framework in Dynamics AX 2012 R3. Follow the steps bellow to import the financial dimension values to Dynamics AX 2012.

1- Go to Data import export framework --> Setup --> Data import / export framework Parameters

2- Click browse to select shared working directory then click Valitate button then close the form

3- Go to Data import export framework --> Setup --> Source Data format, Create new source name and make sure to chose File in the Type then Change the Column delimiter if needed

4- Go to Data import export framework --> Common --> Processing Group, Create New Group then Click the Entities Button.

5- in the entities form select the Dimension Entity, CSV in the Source data format, then Click the generate source file button.

6- in the wizard make sure to select the following fields:
Type (Dimension Type)
Name (Dimension Name)
Value (Dimension Value)
Description ((Dimension value Description)
then click Generate sample file.

7-Save the file in the shared folder we created in step .

8-Open the file using MS Excel, fill the data then save the file.

9-Go back to the processing group --> entities---> Select the Sample file path then click the generate source mapping button.

10- if the mapping done successfully Click the Preview source file button to preview the data then close the form.

11- in the processing group select the group name then click the Get staging data button to copy the file data to staging table.

14-Click OK to create job.

15-Click Run in the staging data execution form.

16-Click OK.

17-The records will be inserted in the staging.

18-In the processing group select the group name then click Copy Data to target button.

19-Select the Job ID that we created in step 13 then click OK.

20-Click Run to import the data

21-Click Ok.

21-The data will be written to target.

22- Go to the  Financial Dimension form you will found that the Dimension and the Dimension values imported successfully.

  
Enjoy

Import Vendors using Data Import framework | AX 2012 R3

This post illustrate how to import Vendors Accounts using the data import framework in Dynamics AX 2012 R3


1- Go to Data import export framework --> Setup --> Data import / export framework Parameters.

2- Click browse to select shared working directory then click Validate button then close the form.

3- Go to Data import export framework --> Setup --> Source Data format, Create new source name and make sure to chose File in the Type then Change the Column delemiter if needed.

4- Go to Data import export framework --> Common --> Processing Group, Create New Group then Click the Entities Button.

5- in the entities form select the vendor Entity, CSV in the Sourcse data format, then Click the generate source file button.

6- in the wizard make sure to select the following fields:
Accountnum (Vendor Code)
Name (Vendor Name)
VendGroup (Vendor Group)
Currency (Vendor Currency) 
LineOfBusinessId (Line Of Business)
then click Generate sample file.

7-Save the file in the shared folder you specified in step 2.

8-Open the file using MS Excel, fill the data then save the file.

9-Go back to the processing group --> entities---> Select the Sameple file path then click the generate source mapping button.

10- if the mapping done successfully Click the Preview source file button to preview the data then close the form.

11- in the processing group select the group name then click the Get staging data button to copy the file data to staging table.

12-Click Ok to create job.

13-Click Run in the staging data execution form.

14-Click Ok.

15-The records will be inserted in the staging.

16-In the processing group select the group name then click Copy Data to target button.

17-Select the Job ID that we created in step 12 then click OK.

18-Click run to import

19-Click Ok.

20-The data will be written to target

21-Go to the Vendor List form, note that the vendors records was imported successfully.

Import Customers using Data Import framework | AX 2012 R3

This post illustrate how to import Customers basic information using the data import framework in Dynamics AX 2012 R3

1- Go to Data import export framework --> Setup --> Data import / export framework Parameters.

2- Click browse to select shared working directory then click Validate button then close the form.

3- Go to Data import export framework --> Setup --> Source Data format, Create new source name and make sure to chose File in the Type then Change the Column delimiter if needed.

4- Go to Data import export framework --> Common --> Processing Group, Create New Group then Click the Entities Button.

5- in the entities form select the Customer Entity, CSV in the Sources data format, then Click the generate source file button.

6- in the wizard make sure to select the following fields:
Accountnum (Customer Code)
Name (Customer Name)
CustGroup (Customer Group)
Currency (Customer Currency  ) 
CountryRegionID (Currency Region)
then click Generate sample file.

7-Save the file in the shared folder you specified in step 2.

8-Open the file using MS Excel, fill the data then save the file.

9-Go back to the processing group --> entities---> Select the Sample file path then click the generate source mapping button..

10- if the mapping done successfully Click the Preview source file button to preview the data then close the form.

11- in the processing group select the group name then click the Get staging data button to copy the file data to staging table.

12-Click OK to create job.

13-Click Run in the staging data execution form.

14-Click OK.

15-The records will be inserted in the staging.

16-In the processing group select the group name then click Copy Data to target button.

17-Select the Job ID that we created in step 12 then click OK.

18- Click Run to import the data

19- Click OK.

20-The data will be written to target.

20-Go to the Customers List form, note that customers records was imported successfully.