Skip to main content
Solved

Smart Synchronize does not work between mappings sets and normal mappings

  • April 30, 2024
  • 3 replies
  • 135 views

andrew.gebhard
TimeXtender Xpert
Forum|alt.badge.img+2

Hi team, 

I have a table in a data-area that is filled by a single mapping set, in this case containing 7 tables. Because we discovered some differences between the fields we need from each table, I want to convert it to a normal mapping. 

I tried to do this via ‘Smart Synchronize’, but it is only working for fields that have not had a name change. In other words, when choosing to smart synchronize a single table onto a table with a mapping set, it seems to perform a ‘Synchronize (only existing fields)’ instead of looking at the name of the fields in the mapping. 

Is this expected behavior?

Kind regards,

Andrew

Best answer by Christian Hauggaard

Hi @andrew.gebhard 

I have tested this and for a table without mapping set, the table looks like this to begin with

I delete the name field and rename the ISVIRTUAL field to ISVIRTUAL2

I then try to do a smart synchronize, and this results in no changes (i.e. same fields and same mappings) 

If I do a normal synchronize

it adds the 2 fields (which were originally renamed)

I see the same behavior when I use mapping sets. I have the following table where I have setup a mapping set, once again I renamed my ISVIRTUAL field to ISVIRTUAL2 and removed the name field.

When I do a smart synchronize, no fields are added to the table, but a new mapping is added to the field with the same name as the original name (i.e. ID field)

When I do a normal synchronize, the mapping for the existing field ID is added and the 2 original fields (NAME, and ISVIRTUAL). Please note that this is a normal mapping and not a mapping set mapping. 

Therefore please try a “normal” synchronize to convert the mapping set to normal mappings.

View original
Did this topic help you find an answer to your question?

3 replies

Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

Hi @andrew.gebhard 

I have tested this and for a table without mapping set, the table looks like this to begin with

I delete the name field and rename the ISVIRTUAL field to ISVIRTUAL2

I then try to do a smart synchronize, and this results in no changes (i.e. same fields and same mappings) 

If I do a normal synchronize

it adds the 2 fields (which were originally renamed)

I see the same behavior when I use mapping sets. I have the following table where I have setup a mapping set, once again I renamed my ISVIRTUAL field to ISVIRTUAL2 and removed the name field.

When I do a smart synchronize, no fields are added to the table, but a new mapping is added to the field with the same name as the original name (i.e. ID field)

When I do a normal synchronize, the mapping for the existing field ID is added and the 2 original fields (NAME, and ISVIRTUAL). Please note that this is a normal mapping and not a mapping set mapping. 

Therefore please try a “normal” synchronize to convert the mapping set to normal mappings.


Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

@andrew.gebhard did you get a chance to try a “normal” synchronize to convert the mapping set to normal mappings?


Forum|alt.badge.img

Hi Andrew, 

I often use a staging area between ODX server and DSA where you simple add your tables from mappings and/or mapping sets without any changes to fields.  

In case something changes in the way the source is set up or your initial setup in DSA is not your preferred choise anymore, you can simply drag and drop using any synchronize you want. In DSA you then further transform and rename anything you like. 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings