Is it possible to prevent a record to be imported ...
# suitescriptb
BS
05/16/2022, 7:43 AMIs it possible to prevent a record to be imported via CSV by using an UE script? So the idea is that I also want to make sure that it's visible for the user how many records failed during the CSV import. At the job status one should easily should see how many records failed during the import.
c
CD
05/16/2022, 7:47 AMJust throw an exception in the beforeSubmit
👍 1
n
NElliott
05/16/2022, 7:47 AMA User Event on the specific record can check the context is csv import and you can throw an error on the before submit.
The error you throw is the one that the user should see in the list you mention. <-- to be clear I mean the file you downloaded with the errors in it.
👍 1
b
BS
05/16/2022, 7:48 AMHi CD, yes I tried it and it didn't worked. Now somehow it does :S
BS
05/16/2022, 7:49 AMSometimes NS drives me crazy
BS
05/16/2022, 7:49 AMmessage has been deleted
BS
05/16/2022, 7:49 AM@NElliott thx man! Yes I used that one too, now it seems to work
c
CD
05/16/2022, 7:50 AMYou have to make sure you have the CSV context turned on in the deployment, plus "Execute Suitescript, workflows etc" is turned on in the advanced options when you do the CSV import
👍 1
n
NElliott
05/16/2022, 7:50 AM^^ that's also a good point
b
BS
05/16/2022, 7:50 AMChecked that one too and those were also enabled
BS
05/16/2022, 7:50 AMThanks guys for your fast replies.
👍 1
BS
05/16/2022, 9:41 AMSo what am I missing here, when I throw the error by creating an error object it works and it doesn't add the record.
However when I enclose it within a try catch it won't throw the error and the record gets imported.
Copy code
try {
const myCustomError = error.create({
name: 'WRONG_PARAMETER_TYPE',
message: 'Wrong parameter type selected.',
notifyOff: false
});
throw myCustomError;
} catch (e) {
log.debug('Try catch error', e.message);
}c
CD
05/16/2022, 9:41 AMDon't catch it
CD
05/16/2022, 9:42 AMIf you're not re-throwing in the catch you're effectively saying "I have caught this, and have dealt with it, so you can continue happily"
👍 1
b
BS
05/16/2022, 9:42 AMah okay
12 Views