Exercise 2: Export and Import the data

The goal of the lab exercise is to apply the knowledge we have learned regarding the import and export data.

Note: You need to complete Exercise 1

Instructions:

  1. Go to Workspaces > Data management.

  2. Select the Export tile.

  3. In the Group name field, enter Item groups

  4. In the Description field, enter Export item groups

  5. In the Data project operation type, select Export.

  6. In the Project category, select Project.

  7. Select + Add entity.

  8. In the Entity name field, enter Item groups

  9. In the Target data format, select EXCEL

  10. Select Add.

  11. Select Close.

  12. Select Filter.

  13. In the Criteria field, enter or select TV&Video

  14. Select OK.

  15. Select Applicable legal entities.

  16. Select + New.

  17. In the Data area field, enter or select USMF

  18. Select Save.

  19. Close the page.

  20. Select Export.

  21. In the Batch job scheduled, select Close.

  22. Select Refresh button.

  23. Close the execution details page.

  24. Close the project page.

  25. In the All project tab, mark the selected Item groups.

  26. Select Download.

  27. Select Save.

  28. Close the page.

  29. Select Import.

  30. In the Group name field, enter Imported Item group

  31. In the Description field, enter Import an item group

  32. Select Add file.

  33. Select Upload and Add.

  34. Navigate to Download folder and select the package. Select Open.

  35. Select Close.

  36. Select View map.

  37. Review the mapping.

  38. Close all pages.