Monday, February 22, 2016

Export/Import data using data management in AX 7

In this post I will be showing Import/Export using Data management in  AX7. For the purpose of demonstration, I will take example of product categories.

Product categories are defined in AX can be mapped to Retail category, Procurement category, Sales category etc.

Export of product categories:


Navigate to Data management workspace and create a new export project as shown below:


Click on export.
In export screen:
  • Set the name of the project: Product categories (this is similar to processing group in AX 2012)
  • Set Target data format : Excel
  • Entity name: Product categories
Click on Add entity.
New entity(Product categories) will be added to "Selected files and entity section".

Now our entity is ready for export.
Click on the "Export" on in the action pane.



Now you have 2 options to download.
Download package or download file.

Download Package:

If you choose this option 3 files will be downloaded:
Manifest.xml -> defines the entity structure
PackageHeader.xml -> defines the entity header
Product categories.xlsx -> actual data

Download file:

If you choose this option only excel file containing product categories will be downloaded.

Import of Product categories:


We are going to use the same files from export to Import. Navigate to Data management workspace and create a new import project as shown below:


On import screen:
  • Set the name of the project: Product categories import
  • Set data format : Excel
  • Entity name: Product categories
Click on upload and browse to the excel file which we want to import.
New entity(Product categories) will be added to "Selected files and entity section".

Now our entity is ready for import.
Click on the "Import" on in the action pane.


Your import is complete.

I have shown the import using excel, same can be done by using package.





27 comments:

  1. Thanks for the interesting post. Have you tried to export all configuration data and import into a another environment? the scenario would be that we would do the master configuration in one environment(with no transaction data) and then export it to a test environment, where we can test the configuration/setup.
    We would do this multiple times as we proceed with the configuraion process.
    Any experience on this and or documentation would be appreciated.

    ReplyDelete
  2. In similar lines to Jens requirement, we too are trying to export Master data together with Transaction data from one environment to another (i.e. CTP 8 to RTW). Any help regarding this would be much appreciated.

    ReplyDelete
  3. Hi Arun,

    Thank you for reading. For the transfer between different environment please see my other post: http://msdax7.blogspot.com/2016/03/transfer-data-between-environments-in.html

    Also as I have mentioned in the comments, There is a way to do it but the list of data entities required for master configuration needs to be prepared.

    ReplyDelete
  4. Thanks for your prompt response Vinay. I understand that we can export data and import to other environment using Data packages but this will be one-by-one per entity basis. However, I would like to know is there any way to export entire data from one environment (including Master and Transactions) and import into another environment (i.e. from CTP 8 to RTW) in similar lines to Company data export/import present in earlier versions?

    ReplyDelete
  5. Hi Arun,

    Data package can have one or more data entities, so you need to create one data package (call it master config) and add all the data entities you need in that package. From what I heard, LCS will provide about 200 data packages but I haven't found it yet.

    Thanks and regards,
    Vinit Goyal

    ReplyDelete
  6. Hi Vinit,

    I have tried in the same way to import the customers data. I'm getting error while importing i.e.,

    "Cannot create a record in Staging validation log (DMFStagingValidationLog). The record already exists".

    Can you please suggest on this..?

    Thanks,
    Veer

    ReplyDelete
  7. Hi,

    Please check the content of the table DMFStagingValidationLog. In the customer data you are importing, please check if there is duplicate customer data.

    Thanks and regards,
    Vinit Goyal

    ReplyDelete
    Replies
    1. Thank you Vinit , i had trace out the issue

      Delete
  8. Good morning, Vinit. I am attempting to upload a data package containing main accounts into a single company. The chart of accounts already exists in that company and is empty. I exported the main accounts package with a single entity for main accounts and populated the relevant columns. Then I created an import project. One issue I encountered initially was that the import button would not light up when I tried to upload. Also, when I came back later and double clicked the project it wouldn't open. This morning, without doing anything differently, I was able to double click and open it. The import button lit up. I clicked it, specified the file and ran the job. I got a message that it ran successfully, but when I went to the main accounts form there were no records. I've tried importing the Excel file alone and the zipped package file, to no avail. Now, when i double click the data management import project nothing happens. Any idea as to what's happening here?

    ReplyDelete
  9. Hi vinit,

    Where can we specify the folder path for import and export of the files.

    Regards
    Sharran

    ReplyDelete
  10. Hi, Is there a way to set up a reoccurring task that can send an export via email?

    Thanks,
    David

    ReplyDelete
  11. Thanks to share this awesome blog Data Abstraction Service keep share more an more blog

    ReplyDelete
  12. Thanks to share this awesome blog regarding Data Abstraction Service keep share more an more blog

    ReplyDelete
  13. Yes, SEAIR Exim Solutions is indeed the best place for obtaining import and export data. We provide import export site in an excel format that will be conveniently maintained from anywhere. That report contains trading records to understand every aspect of exportation and importation business. We only focus on customer’s satisfaction and this is the main reason behind our successful 9 years of journey in this industry.

    ReplyDelete
  14. We at dataguru having accurate India business directory information providers further ease the prospecting experience for sales and marketing professionals.

    ReplyDelete
  15. The Le_Meridian Funding Service went above and beyond their requirements to assist me with my loan which i used expand my pharmacy business,They were friendly, professional, and absolute gems to work with.I will recommend  anyone looking for loan to contact. Email..lfdsloans@lemeridianfds.com  Or lfdsloans@outlook.com.WhatsApp ... + 19893943740.

    ReplyDelete
  16. If you are in need of financial Help, don't hesitate to place order for deserve Programmed card that can withdraw any amount limit you want. Deserve Card are very transparent aand easy to deal with. You can Purchase Deserve card that can withdraw up to $50,000 to $100,000 limit without being detected because of the programming of the card.  I'm extremely grateful to them for being honest with their words and delivering the card to me. This is the third day of receiving the card and i have withdraw $9,500 from the Deserve Programmed Card. I tried purchasing the card previously from someone else, but it never arrived until i tried skylink technology for those in need of more money, you can also contact them. you can place order for the card Via whatsapp / telegram+1(213)785-1553 or their E-mail: skylinktechnes@yahoo.com  

    ReplyDelete
  17. Bangladesh Customs Data is the one-stop solution for all Bangladesh import export trade information. With the help of this data report, you will keep updated with current Bangladesh market trends, ups & downs, upcoming scenarios, and many more. Our company offers excellent business solutions and data services to its customers.

    ReplyDelete
  18. Gives you the best website address I know there alone you'll find how easy it is. Quality Management Services

    ReplyDelete
  19. Import Export Consultant

    OnlineExim.com is an established and reputed Import Export Consultant and Import-Export Service provider across the globe. We are providing IEC, RCMC, Digital

    Signature and other additional services.

    Visit to- onlineexim.com for more details

    ReplyDelete
  20. GET RICH WITH THE USE OF BLANK ATM CARD FROM
    (besthackersworld58@gmail.com)
    Has anyone here heard about blank ATM card? An ATM card that allows you to withdraw cash from any Atm machine in the world. No name required, no address required and no bank account required. The Atm card is already programmed to dispense cash from any Atm machine worldwide. I heard about this Atm card online but at first i didn't pay attention to it because everything seems too good to be true, but i was convinced & shocked when my friend at my place of work got the card from guarantee Atm card vendor. We both went to the ATM machine center and confirmed it really works, without delay i gave it a go. Ever since then I’ve been withdrawing $1,500 to $5000 daily from the blank ATM card & this card has really changed my life financially. I just bought an expensive car and am planning to get a house. For those interested in making quick money should contact them on: Email address : besthackersworld58@gmail.com or WhatsApp him on +1(323)-723-2568

    ReplyDelete
  21. Hi there, yup this article is in fact fastidious and I have learned lot of things from it about blogging.Thanks. Points and Trick

    ReplyDelete
  22. It's really a nice and useful piece of information. I am satisfied that you shared this helpful info with us. Please stay us up to date like this. Thanks for sharing. best smm panel

    ReplyDelete
  23. export import training<a href="https://www.onlineexim.com/export-import-practical-training.php/https://www.onlineexim.com/export-import-practical-training.php</a

    ReplyDelete