Hi Friends,
Data importing is slightly different in AX 2012 R3, in earlier version can import data through SQL but now here is something new for us.
Before performing below operation you should have following tools/Setups with you
1. Dynamics AX 2012R3 (of course it will be there :P )
2. Demo data file (downloadable from Partner source)
DynamicsAX2012R3DemoData.exe
3. Data transfer tool (downloadable from Partner source
AX2012TestDataTransferTool.msi
Ohk, now we have all the require setups with us, so let’s start now.
Step 1. Extract demo data file, run “DynamicsAX2012R3DemoData.exe”
In this case I extract it on C drive.
Step 2. Run “AX2012TestDataTransferTool.msi” file.
It will create a new folder in under following path
C:\Program Files (x86)\Microsoft Dynamics AX 2012 Test Data Transfer Tool (Beta)
Step 3. Import “MetaDataXMLGenerator.xpo” , it will import a new job named “MetaDataXMLGenerator” in AOT, Run this job.
This operation will create a XML file names “MetaData.xml” under below path
(You can directly go this folder by using “%temp%” from run)
7/29/2014 5:00 PM - Screen Clipping
Step 4. Copy this file and paste is in “[List]” folder (where Test Data Transfer Tool has been extracted). If the file already exists, then overwrite the file. In this example path will be following
“C:\AX 2012 Test Data Transfer\[Lists]”
Step : 5 Close all AX instances and stop the AOS services.
Now you have all data and required files with you.
Step 6. Now run command prompt as administrator
Navigate to the directory where your “AX2012TestDataTransferTool” folder exist. In this case I have “C:\AX 2012 Test Data Transfer” (just copied from program files J )
Now the final stunt, Run following command
DP.exe IMPORT “C:\AXR3DemoData” AX2012R3DB
Pease note: Make sure all AX instance and AOS service are stopped.
Here
Ø “DP.exe” is executable file in “AX2012TestDataTransferTool” folder
Ø “C:\AX2012R3DemoData” is your demo data folder path
Ø “AX2012R3DB” is your AX database name
System will ask to your acceptance to import data, simply press “y/Y”
Note: Some time system will show below error
“Unhandled Exception: System.UnauthorizedAccessException: Access to the path ‘C:\Program Files (x86)\Microsoft Dynamics AX 2012 Test Data Transfer Tool (Beta)\DP Log.xml’ is denied.
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, I
nt32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions o
ptions, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolea
n useLongPath, Boolean checkHost)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access,
FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean
bFromProxy)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access,
FileShare share, Int32 bufferSize, Boolean useAsync)
at System.Xml.XmlWriterSettings.CreateWriter(String outputFileName)
at System.Xml.Linq.XDocument.Save(String fileName, SaveOptions options)
at DP.Program.Execute(String currentDirectory, DataportDirection direction, S
tring directory, String database, String server, DataportAction action) in e:\bt
\110700\Source\DataPort\DP\Program.cs:line 182
at DP.Program.Main(String[] args) in e:\bt\110700\Source\DataPort\DP\Program.
cs:line 82
If you are facing the same error than try to run following command (Its same command as above without “ ”)
DP.exe IMPORT C:\AXR3DemoData AX2012R3DB
Now it will work J
As next, Below window will open
Here you done your part, now wait to complete this operation and open your AX client.
-Harry
