Skip to main content
To homepage To homepage
Solved

New column not showing in datasource

  • December 3, 2024
  • 8 replies
  • 53 views
B
Contributor

Hi,

we have an Afas datasource via provider cddata rest 2023. The Afas getconnector has been updated with new columns. When i run the sync task for this Afas datasource i expect timex to detect the new columns but this is not the case. What do i need to do to let timex see this new columns?

 

thank u in advance,

Bob

Best answer by Thomas Lind

Hi ​@Bob 

The RSD files will not automatically be updated, you will need to rename the existing ones or delete them to generate new ones.

If you have customized the existing ones, you can then add the new rows from the newly formed file and add it to the existing one. Since this is supposedly a REST provider you also have to be sure these new files are a part of the JSONPath setting. Then it should work again.

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

rvgfox
Problem Solver
Forum|alt.badge.img+4
  • rvgfox
  • Problem Solver
  • December 3, 2024

I’ve detected the sam problem with diferent data source.

In the new version 6822.1 you must:

  1. Run the Meta data task (previously synchonize task)
  2. Use the Metadata Manager to include the new fields
  3. Synchonize with the Ingest instance in the Prepare instance (I think that this would not be necessary in my opinion)
  4. If you select the source in the Mappings of the table, in the rignt side, Data Movement section, the new fields doesn’t appears (I think that it’s an error)
  5. You must delete the mapping and add the same table agaig and now you will see the new fields in the Data Movement section.

Hope this helps

 

B
Contributor
  • Bob
  • Contributor
  • December 3, 2024

@rvgfox, thanks for your answer, unfortunately we are still on version 20.10.31.64, so the metadatamanger function is not available..

i hope there is another workaround for our version.

 

thank& regards,

Bob

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

​@rvgfox Please see the below guide, if you encounter different behaviour please submit a support ticket

 

​@Bob for your version 20.10.31, please right click on the data source and click Select columns and include the column and then execute the sync task

B
Contributor
  • Bob
  • Contributor
  • December 3, 2024

HI Christian,

i allready tried that but de new columns do not show there, i've clicked search but only the current columns appear. we also have de settting "include all collumns ”in the rigth pane.

 

kind regards, Bob

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

​@Bob Did you execute the synchronize task after “include all columns”? Did you check the data source explorer afterwards to see if the new column is present? are you using rsd files for the REST data source? if so these files may need to be updated or re-generated to include the new columns

B
Contributor
  • Bob
  • Contributor
  • December 3, 2024

Hi Christian, yes to the first 3 questions. So the rsd file is not updated automatically? how can i do that manually? we have altered the file so it handles pagination how do we keep the code(copy paste?)

 

kind regards,

Bob

 

Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Thomas Lind
  • Community Manager
  • December 3, 2024

Hi ​@Bob 

The RSD files will not automatically be updated, you will need to rename the existing ones or delete them to generate new ones.

If you have customized the existing ones, you can then add the new rows from the newly formed file and add it to the existing one. Since this is supposedly a REST provider you also have to be sure these new files are a part of the JSONPath setting. Then it should work again.

Christian Hauggaard
B
2 people like this
  • Christian Hauggaard
    Christian Hauggaard
  • B
    Bob
B
Contributor
  • Bob
  • Contributor
  • December 4, 2024

Hi Thomas,

i copied the original file, the sync task than produces a new rsd file and after copying the custom lines to this new rsd file it works! Thanks for your advise. 

 

Kind regards,

 

Bob

Christian Hauggaard
B
2 people like this
  • Christian Hauggaard
    Christian Hauggaard
  • B
    Bob

Reply


Most helpful members this week

Terms and ConditionsCookie settings

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