In the previous exercise you loaded the data from the Source System and a View into staging tables. In this exercise you will do the same for Dynamic and Translation Valuesets. 

As you remember from Studio, Valuesets come in 3 different flavours.

Data is provided in Studio itself. For static Valuesets, data is part of the generated engines and loaded into the staging tables as part of the engine setup. There is no need to do anything more.
Data has to be loaded by calling the extension that is specified on the Valueset. In this exercise the Valuesets are loaded using the migFx Default extension delivered with migFx. This extension reads Valulesets from Excel files.
A Translation Valueset is published in the Tracker for users to provide the data content. The Tracker stores the data content internally and in this exercise you will load the staging table from this internal Tracker store.

Load Dynamic Valueset CardTypes

The Valueset CardTypes was created in the Target map and is part of the Target engine. The Valueset is using the Valueset provider delivered with migFx. This provider reads the Valueset data from an Excel file and it expects that Excel file at a specific location in the folder structure of the track. 

This file is already in the correct location as part of the training setup:

To load the Dynamic Valueset, select Target/Valuesets in the Director menu. The Director will show you alle the Valuesets from the Target Engine. At the top you have the Static Valuesets, lower left the Dynamic Valuesets and lower right the Translation Valuesets. There are no Translation Valuesets in the Target Engine.

You can double-click any Valueset to see its data content in the staging table.

The CardTypes Valueset is in the list, but of course not loaded yet (if you don't see the Valueset, try to click the Refresh button). Check the Select check box for CardTypes and click the Update Selected button to submit a job to load the Valueset.

Check the job in the Job list and when done, go back to the Valuesets and click the Rferesh button to update the row for CardTypes.

Load Translation Valueset TranslateCardTypes

As outlined in the beginning of this exercise, that data content for Translations Valuesets are provided by user of the Tracker application. Of course there is a little hitch here as this is a training setup and there are no real users anywhere to provide this content. Luckily the Director allows you to load the data into the Tracker application from an Excel sheet in one go. I a real life scenario, this functionality is often used to provide the Tracker users with an initial data content for them to complete.

Load the Tracker data content

Select Administration/Translation in the Director menu to see the Translation Valuesets. 

  • Select TranslateCardTypes in the Valueset list
  • Click the Import from Excel button 
  • We have provided the data content for you in the file Documents\MigFx\Runtime\Track\01\Files\Valuesets\TranslateCardTypes.xlsx
  • Navigate to this file and click the Open button to import the data content into the Tracker

Now the data content is loaded (and visible) in the Tracker. You can see that for yourself by opening the Tracker

  • Open Internet Explorer (it should be in the Windows Taskbar, otherwise search for it in the Wondows Start Menu)
  • Select the Track Workshop - Training
  • Click the Translation Tab
  • And finally, on the translation tab click TranslateCardTypes
  • As an aside: Note the Validation column of the Translation Valueset in Tracker. migFx provides utility functions to: 
    • unload the data content, perform some kind of validation, in this case for instance validating the TargetCardType against known Card types in the Target System 
    • load the result of the validation and mark the rows in the Translation Valueset accordingly

So far so good. Now the data content is stored internally in the Tracker application as if the (imaginary) users had entered it in the Tracker. But it is still not loaded into the Director staging table.

Load the Director Staging table

Next step is to load the Director staging table with the data content for the Tracker. This is pretty much the same thing as loading the Dynamic Valueset above.

Select Source/Valuesets in the Director menu to see the Valuesets of the Source Engine:

TranslateCardTypes is there, but not loaded yet. Check mark TranslateCardTypes and click the Update Selected button to submit the load job. Check the job in the Job list and refresh the Valueset list when finished.

What happened here?

You have loaded the staging tables for the non-static Valuesets. The static Valuesets where loaded as part of the Engine setup you did in an earlier exercise. For the Translation Valueset there was the intermediary step of simulating user data entry by importing the data content into the Tracker from a spreadsheet. This extra step is related to the training setup. In a real life scenario there would of course be real users to enter the data.

The data content for translation Valuesets are maintained by the users in the Tracker and loaded to the Director staging table in order to ensure a well-known and stable data content. Even if users are updating the data content in Tracker while the migration runs. In addition, rows with validation errors in the Tracker will not be loaded into the staging table.

Now everything is in place and in the next exercise you will be migrating the Cards - finally!