AX2012 R3- How to Import Contoso Data using Test Data Transfer Tool (Beta)

Pre-requisites:

1-      Download the test data transfer tool from the below mentioned link.

https://informationsource.dynamics.com//RFPServicesOnline/Rfpservicesonline.aspx?ToolDocName=Microsoft+Dynamics+AX+2012+Test+Data+Transfer+Tool+(Beta)+-+Updated+7th+Jan+2014%7cQJ4JEM76642V-8-1465
2-      Download demo data for AX2012 R3 from partner source site.

Steps: 

  • Extract the demo data files from DynamicsAX2012R3DemoData.exe to a specific location.

zb1

  • The output folder will contain the files of following extension types:
  1. .OUT—– data file that contains metadata for AX transactional database
  2. .OutModel —- data file that contain metadata for AX model database
  3. .XML —- data file that contains AX table data.
  •  Run the Test Data Transfer Tool.Exe file to install the utility.

zb2

  • After successful installation, the folder will look like as shown below:

zb3

  • Open AX client and import the .XPO named (MetaDataXMLGenerator.Xpo)

zb4

  • On successful import a job will be created as shown below:

zb5

  • Run the job <MetadataXMLGenerator(usr)>, a  meta data file will be generated and the path will be displayed in the infolog as shown in the snapshot below:

zb6

  • Copy the metadata file from the above path and paste it in [lists] folder (where Test Data Transfer Tool has been extracted). If the file already exists, then overwrite the file.
  • Stop MS Dynamics AX service.
  • Open command prompt using administrator and navigate to the path where the Test Data Transfer Tool is extracted).
  • Run the following command:

Dp.exe Import “C:\R3DemoData\DynamicsAXR3DemoData” DynamicsAXR3

C:\R3DemoData\DynamicsAXR3DemoData—— update the path accordingly

DynamicsAXR3—— provide the actual database name.

zb7

If we enter ‘Y’, then following screen will open up describing the count for importing the table data and Error (if they come up)

zb8

  • The process may prolong depending upon machine configuration.
  • On successful import, Open AX client and data will show up.

zb9

COMMENTS (19)
Reply

Hi,

I have followed the steps mentioned above but at the end received below error and no table has imported.
Note: In My case both database server and AOS server’s are different.
I have executed the below command.
Dp.exe Import “C:\R3DemoData\DynamicsAXR3DemoData” DynamicsAXR3 Databaseservername(SQLSever\Instance).

“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

    Reply

    Hi Srinivas,
    In case of 3 tier environment, you need to install Test data transfer tool on SQL server and run DP command on same server.

    Regards,

    Reply

    Hi,
    i was having same problem.but now it got resolved.

    Solution: when your opening cmd,open with Run as Administrator

    Thanks & Regards
    Naresh.D

Reply

Once the import is done. I can log in with my administrator to the initial partition. How can I setup a user to login to a different partition such as the Public sector partition? Do I need to add my own entry in the userinfo table to reference the different partition?

Reply

Hi,

Thanks for this procedure, but the correct command is

DP.exe direction directory database server (without ” ” )

    Reply

    Hi ALEXANDRE,
    You can go with or without Commas, it depends you are using a path which contain spaces. If you don’t want to use Commas then select a path that doesn’t contain spaces.

    regards

Reply

Hi Srinivas:

Let me know on which machine you are executing the command, is it SQL machine or AOS. i assume and prefer to be SQL box.

Reply

Hi Alexandre AX4B:

I have executed the command using “” and it worked fine for me.

Reply

I am trying to use the tool to import contoso data to fresh install of ax 2012 R3.
Looks like every table is returning an error. Error count is going up for every table it is trying to read.
Please help!

Reply

Was the contoso DB extracted successfully, also check the permissions granted to the user through which the import process is being executed. try to run the command with admin user.

Reply

Hi Zubairrasheed Baber,

I’m wondering about this step: “Open AX client and import the .XPO named (MetaDataXMLGenerator.Xpo)”
Which AX system that we start to import this file?
– AX2012 R2 (testing DB, I’ve already had it now)
– Install new AOS and AX2012R3 fresh DB => do check list, compile code …. and then import this XPO file?
Many thanks,

MinhJ

Reply

Hi,
I also getting same error, and have gone through all discussion in this post.

Checked:

– Client Tool Connectivity[Installed]

– Client Tools Backward Compatibility[Installed]

– bcp.exe file is available in Path “C:\Program Files\Microsoft SQL Server\100\Tools\Binn”

– And “C:\Program Files\Microsoft SQL Server\100\Tools\Binn” path is already set to Environment Variable of System.

– Data files are available in C:\Users\dynamicsax2\Documents\ContosoDemoData\AXR3DemoData

– Logged in User is administrator.

But still I am facing same error while Importing the data using following command.

DP.exe IMPORT “C:\Users\dynamicsax2\Documents\ContosoDemoData\AXR3DemoData” MicrosoftDynamicsAx

Error:

Application: DP.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.NotSupportedException
Stack:
at System.Security.Util.StringExpressionSet.CanonicalizePath(System.String, Boolean)
at System.Security.Util.StringExpressionSet.CreateListFromExpressions(System.String[], Boolean)
at System.Security.Permissions.FileIOPermission.AddPathList(System.Security.Permissions.FileIOPermissionAccess, System.Security.AccessControl.AccessControlActions, System.String[], Boolean, Boolean, Boolean)
at System.Security.Permissions.FileIOPermission.AddPathList(System.Security.Permissions.FileIOPermissionAccess, System.String[], Boolean, Boolean, Boolean)
at System.Security.Permissions.FileIOPermission..ctor(System.Security.Permissions.FileIOPermissionAccess, System.String[], Boolean, Boolean)
at System.IO.FileSystemEnumerableIterator`1[[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]..ctor(System.String, System.String, System.String, System.IO.SearchOption, System.IO.SearchResultHandler`1, Boolean)
at System.IO.Directory.InternalGetFileDirectoryNames(System.String, System.String, System.String, Boolean, Boolean, System.IO.SearchOption, Boolean)
at System.IO.Directory.InternalGetFiles(System.String, System.String, System.IO.SearchOption)
at Microsoft.Dynamics.AX.Dataport.SqlHelper.GetDifferentialTableNames(Microsoft.Dynamics.AX.Dataport.DataportDatabase, System.String)
at DP.Program.Execute(System.String, Microsoft.Dynamics.AX.Dataport.DataportDirection, System.String, System.String, System.String, Microsoft.Dynamics.AX.Dataport.DataportAction)
at DP.Program.Main(System.String[])

Also I tried to Export the Data using same tool

DP.exe export “C:\test1” MicrosoftDynamicsAx

While exporting, I am not getting error details in command window, but DPLog.xml file is filled with the same error.

Failed
System.NotSupportedException: The given path’s format is not supported.
at System.Security.Util.StringExpressionSet.CanonicalizePath(String path, Boolean needFullPath)
at System.Security.Util.StringExpressionSet.CreateListFromExpressions(String[] str, Boolean needFullPath)
at System.Security.Permissions.FileIOPermission.AddPathList(FileIOPermissionAccess access, AccessControlActions control, String[] pathListOrig, Boolean checkForDuplicates, Boolean needFullPath, Boolean copyPathList)
at System.Security.Permissions.FileIOPermission.AddPathList(FileIOPermissionAccess access, String[] pathListOrig, Boolean checkForDuplicates, Boolean needFullPath, Boolean copyPathList)
at System.IO.Directory.InternalCreateDirectoryHelper(String path, Boolean checkHost)
at Microsoft.Dynamics.AX.Dataport.BulkCopy.WriteOutFile(String serverName, SqlTableName table, String query, String folder) in e:\bt\110700\Source\DataPort\Dataport\Library\BulkCopy.cs:line 263
at Microsoft.Dynamics.AX.Dataport.DataportQueryExtensions.WriteBulkCopyFiles(IDataportQuery query, String database, String server, String folder) in e:\bt\110700\Source\DataPort\Dataport\Model\DataportQuery.cs:line 94
at Microsoft.Dynamics.AX.Dataport.DataportQueue.<>c__DisplayClass8.<>c__DisplayClassc.<ProcessItem>b__7() in e:\bt\110700\Source\DataPort\Dataport\Model\DataportQueue.cs:line 240
at Microsoft.Dynamics.AX.Dataport.Functional.<>c__DisplayClass1.<Retry>b__0() in e:\bt\110700\Source\DataPort\Dataport\Library\Functional.cs:line 28
at Microsoft.Dynamics.AX.Dataport.DataportQueue.<>c__DisplayClass8.<ProcessItem>b__6(Object state) in e:\bt\110700\Source\DataPort\Dataport\Model\DataportQueue.cs:line 260
Export
Overwrite
MicrosoftDynamicsAX
ACCOUNTANTLOGISTICSLOCATIONROLE_BR
ACCOUNTANTLOGISTICSLOCATIONROLE_BR
“C:\test1”

I know I am doing something wrong, but could not find the solution in whole day.

Please advice me, how can I import data to AX, I shall thankful your advice.

With Best Regards

Kishore

    Reply

    Hi,

    I started the importing again, I dont know why I was getting the error. But this time I thought to write the Contoso Data Path another way..thanks to old DOS days.

    DP.exe IMPORT “../ContosoDemoData/AXR3DemoData” MicrosoftDynamicsAx

    Hurrey, It just worked fine. Sorry, for wasting your time by reading previous message.

    Regards.

    Reply

    Hi Kirk,
    Had the same issue but found it was due to the Quotes surrounding the path parameter once you copy the whole syntax from the webpage.
    If you copy the Command line in a tool like note pad you can see initial surrounding quotes are pointing top right to bottom left where as ending quotes are pointing top left to bottom right.

    Changing the initial quotes to be the same as the ending resolved the issue

    Regards

    Jago

Reply

HI,
After doing all procedure i got this message :
Cannot access database MicrosoftDynamicsAx
Did you mean AX_R3?
what i should do please
regards

Reply

Hi
I remplaced MicrosoftDynamicsAx by the name of my data base “AX_R3″ in the command and the problem is solved.

    Reply

    Great and Good luck.

Reply

Hi, tried to download testing transfer tool (beta) but link is no longer valid. Does anyone know where I could download the tool?

    Reply

    Did you managed to find the transfer tool? I’m in the same situation.
    Thanks.

Leave a Comment

Name (required)
Email (required)
Comment (required)

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>