Service Desk Practitioners Forum
cancel

Emain notification after import XML is finished (SD 4.5)

Highlighted
Dmitry Utkin
Trusted Contributor.

Emain notification after import XML is finished (SD 4.5)

Hi all!

If anybody can help me with where I can tune automaticaly sending email after XML import finished. I would like to receive custom formatted email with text like "10 new users has been added"

Many thanks for you help and advises.
2 REPLIES
Ruth Porter
Acclaimed Contributor.

Re: Emain notification after import XML is finished (SD 4.5)

Hi there,

Could you always import one additional record that says how may real ones there are and then have a DB rule which runs when this additional record is modified?

Regards, Ruth
http://www.teamultra.net
Vasily Kamenev
Acclaimed Contributor.

Re: Emain notification after import XML is finished (SD 4.5)

Hi Dmitry.
I mean you use the scheduled batch process.
Use the following: in the import .bat file add one more line to run the web-api script. In sql server create one trigger for insert with action update new records the Boolean field to "1".
The script must be read Person by this Boolean field on, activate before from Custom fields. after reading set this field to 0, calculate and send mail to you.
Of course script possible be not on web-api, use any other languages, but then you must use sql direct connection.

Believe this help to you,
Vasily