Developer forum

Forum » Integration » Where did Refresh Schema go in DW 10?

Where did Refresh Schema go in DW 10?

Imar Spaanjaars Dynamicweb Employee
Imar Spaanjaars
Reply

Hi there,

I have an integration job that maps from an XML document to a custom SQL table (using the DynamicWeb provider). I've added a new column to my table. but it won't show up in the backend's job. in DW 9 we had Refresh Schema but I can't seem to find that in DW 10.

Any ideas?

Imar


Replies

 
Rasmus Sanggaard Dynamicweb Employee
Rasmus Sanggaard
Reply

Hi Imar,

It is right in the action menu on the mappings screen:

It checks for changes, and then you can choose to update the schema afterwards:

BR Rasmus Sanggaard

 

 
Imar Spaanjaars Dynamicweb Employee
Imar Spaanjaars
Reply

Not for me: I have Table schema errors only:

And when I click that it says there are no errors (records)

 

 
Rasmus Sanggaard Dynamicweb Employee
Rasmus Sanggaard
Reply

Hi, 

 

It is the same, just another name in the newest version. 

You can read all about it on our famous documentation site: https://doc.dynamicweb.dev/manual/dynamicweb10/integration/setup/activities.html?tabs=general#table-schema-check

 

BR Rasmus Sanggaard

 
Imar Spaanjaars Dynamicweb Employee
Imar Spaanjaars
Reply

I see; found it now.

So is Check schema changes the new or the old name? I like that better than Table schema errors as changes captures everything, including errors, and a new column or so doens't really qualiy as an error.

Also, in DW 9 it would show you what's chnaged, but I don't see that anymore. Is that by design? It was helpful to see which changes were detected before applying them.

 

 
Rasmus Sanggaard Dynamicweb Employee
Rasmus Sanggaard
Reply

Hi, 

Changes is the new name, glad you like it. 

The list shows your changes from source / destination vs. the schema in the job file, then you can choose to update it or not. 

 

BR Rasmus Sanggaard

 
Imar Spaanjaars Dynamicweb Employee
Imar Spaanjaars
Reply

That's not what I am seeing. Here's what I did:

1. XML provider as source
2. Dynamicweb provider as target
3. Mapped the XML into a custom table
4. Ran the job; all good
5. Added a new column in the custom database table
6. Open the job mappings
7. Chose Table schema errors. This screen appeared:


8. Chose Actions | Update schema for source and destinations

This cases the page to reload (with a progress bar) but nothing else.

Afterwards, I could select the column I added in step 5 but I didn't see it anywhere in the UI before or during the refresh.

 
Rasmus Sanggaard Dynamicweb Employee
Rasmus Sanggaard
Reply

Hi,

Thanks for the steps to reproduce. There is a bug in the DynamicWeb provider where it looks in the wrong place for changes. Bug #20742 is already resolved, and a PR is waiting for approval. After that, you should be able to update it through App Store.

BR Rasmus Sanggaard

 
Imar Spaanjaars Dynamicweb Employee
Imar Spaanjaars
Reply

Excellent, thanks!

 

You must be logged in to post in the forum