Developer forum

Forum » Integration » Refresh schema

Refresh schema

E-mail notifications
Imar Spaanjaars Dynamicweb Employee
Imar Spaanjaars
Reply
Posted on 06/10/2015 13:56:54

Hi there,

Not sure if this belongs here, or in the Feature requests forum, but I am looking for a way to refresh the schema when building integration jobs. Quite often I have an XSLT file that starts out with, say 10 columns. Then when I add new columns to the transformation, I have to delete and then recreate my job for the new column to show up in the list of column mappings. How do I refresh the schema? And if you can't do it today, can we have a Refresh Schema button?

Note: it seems that when the schema is invalid, the Validate schema button (or whatever it's called) seems to do something already very close. However, that button usually doesn't show up.

Thanks,

Imar


Replies

 
Dmitriy Benyuk
Posted on 07/10/2015 10:00:18
Reply
This post has been marked as an answer

Hi Imar,
I was trying to reproduce this problem with making XML provider with xslt selected as a Source and CSV/User provider as a destination and after making a new job
I added a new column to the xslt file(AccessUserPhone123) and opened the job again, new column was added to my source table column list(see attached image)
Maybe I was looking not the same scenario as you are making. I am using Dynamicweb 8.7.1.
Could you give more details for reproducing this?
Regards, Dmitrij

Untitled.jpg
Votes for this answer: 1
 
Imar Spaanjaars Dynamicweb Employee
Imar Spaanjaars
Posted on 08/10/2015 00:31:46
Reply

Very interesting. I just tried this on a fresh 8.7 release and it does work there. Excellent, exactly what I needed.

Was this added recently? I could have sworn it didn't work in previous versions.

Imar

 
Gaetan Di Caro
Posted on 17/12/2015 09:51:20
Reply

Just Posting here because I have a similar issue. It seems that new columns are often alright, but if I change the data type in the source table it doesn't get refreshed. I have seen from time to time a big button with a green check and text like "check schema" but I have absolutely no idea when it's supposed to show up or not. Is there a way to make it appear ?

It would be VERY interesting that it shows up all the time instead.

 
Dmitriy Benyuk
Posted on 17/12/2015 10:00:38
Reply

Hi Gaetan,
this button is appearing when a new column was added to the table, any column was removed from the table, new/removed tables present, any column with not a valid column type is present in the mapping, missing tables or columns in the mapping, and also it should notify about changed column type.
Regards, Dmitrij

 
Gaetan Di Caro
Posted on 20/01/2016 09:36:53
Reply

Hi Dmitrij,

The button does show up when I remove or rename columns, but I think it doesn't work very well when you change the column type, I've had the issue several times. When that happens I have to edit the xml manually.

It would be very nice to have a way to manually force the update of the source and destination definitions in the XML, like that it would take care of any potential problem regarding the definitions.

Thanks !

 

You must be logged in to post in the forum