Skip to main content
Solved

Data movement ODX -> DSA with mapping set

  • 5 September 2024
  • 2 replies
  • 36 views

Hi

It looks impossible to add a new field from the ODX onto the DSA, once you have added fields before. I’m not able to drag a new field (one of the grayed out fields) onto the table. Only solution seems to drop the existing mapping set and restart. Am I missing something?

 

Situation as is:

  1. We are using TX-version is V21
  2. Different agencies, all using the same ERP. Have created different ODX-sources for each agency.
  3. Created a mapping set to import data from ODX to DSA. Mapping set is a handy feature. Instead of dragging each data source individually, you can create a mapping set that will pull in all the tables with the same name and structure
  4. Problem seems to be that when you have created the mapping set, that you can’t change/add something afterwards. This can’t be the case I assume.

In the example I have added 14 fields before. I now want to add (1) more but the application won’t let me drop it on the table (or mapping set).

 

 

Thanks for your thoughts/solutions

Hi @woutersmike 

As you know, you can only map fields that exist across all tables in your mapping set. They can’t have different case settings either, it has to be exactly the same. So the fields you do see in the Data movement are fields that are available across all the mapped tables.

It does seem like you can’t add them.

You will have to turn off the mapping set add one of the tables and the missing fields and then make it a mapping set again.

I will ask if this is supposed to work like this.

Hi @woutersmike the product team have informed me that they will fix this issue in an upcoming release. In the meantime please use the workaround suggested by Thomas above

Reply


Terms and ConditionsCookie settings