The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Emain notification after import XML is finished (SD 4.5)

Highlighted
Dmitry Utkin
Super Collector

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
Honored 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
Honored 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
//Add this to "OnDomLoad" event