- Als neu kennzeichnen
- Lesezeichen
- Abonnieren
- Stummschalten
- RSS-Feed abonnieren
- Kennzeichnen
- Anstößigen Inhalt melden
am 09-19-2017 11:37 PM
Can you please remove the quotes from below true keyword, hoping this is onStart() script?
ignore = 'true';
- Als neu kennzeichnen
- Lesezeichen
- Abonnieren
- Stummschalten
- RSS-Feed abonnieren
- Kennzeichnen
- Anstößigen Inhalt melden
am 09-26-2017 03:41 AM
This is my onstart script
(function transformRow(source,map, log, target) {
if(action == 'insert'){
ignore = true;
}
if(source.ST.validation_ID, == ''){
ignore = true;
error = true;
error_message='Supplier Validation Results field is blank, Please update the field to complete the update';
}
})(source, map, log, target);
this wil only the row skip if validation id is empty, it is not aborting the whole insert if any one validation id is empty.
- Als neu kennzeichnen
- Lesezeichen
- Abonnieren
- Stummschalten
- RSS-Feed abonnieren
- Kennzeichnen
- Anstößigen Inhalt melden
am 09-26-2017 08:00 PM
is the source field name is ST.validation_ID. Can we replace the dot after ST with underscore like ST_validation_ID and also in you if condition there is a comma after ST.validation_ID. Can you please remove that and try. Can we something like this with nil() function.
(function transformRow(source,map, log, target) {
if(action == 'insert'){
ignore = true;
}
if(source.ST_validation_ID.nil()){
ignore = true;
error = true;
var error_message='Supplier Validation Results field is blank, Please update the field to complete the update';
log.info(error_message);
}
})(source, map, log, target);
- Als neu kennzeichnen
- Lesezeichen
- Abonnieren
- Stummschalten
- RSS-Feed abonnieren
- Kennzeichnen
- Anstößigen Inhalt melden
am 09-26-2017 11:58 PM
Replace the dot after ST with underscore like ST_validation_ID and replace the code like this -> source.ST_validation_ID.nil(),
it is onstart script, still it is not working
- Als neu kennzeichnen
- Lesezeichen
- Abonnieren
- Stummschalten
- RSS-Feed abonnieren
- Kennzeichnen
- Anstößigen Inhalt melden
am 09-27-2017 12:02 AM
Can we change the field name in lower case and try, like: st_validation_id