topic Re: email post editing in Data Management Questions

email post editing

gp2014 — Tue, 10 Sep 2013 12:43:35 GMT

Dear all,
I would like send an email (for example at an administrator) whenever an user modify a layer/table. The layers/table are within a version of enterprice geodatabase on ArcSDE10-Postgresql.
Is there this opportunity?

Thank in advanced.
Giuseppe P.

Re: email post editing

VinceAngelo — Tue, 10 Sep 2013 13:20:22 GMT

That sounds like an excellent way to "mail bomb" your GIS admin.

What is your definition for "modify?" An SQL edit? A table structure change?
Addition of new tables?

There exist libraries for batch mail transmission, and there are ways to detect
databases changes, I just think you'd have a difficult time justifying the cost
of configuring them with any benefit that could result.

- V

Re: email post editing

gp2014 — Tue, 10 Sep 2013 15:12:18 GMT

I would like alert an administaror when a user update/insert/delete rows within a geodatabase.

For example i would like send this email:
****
Dear admin,
the following tables/layers are changed with project X version:
- layer 1
- layer 2
- layer 3
- table 1

Now, you can to approve/verify these layer and post it to parent version using post/reconcile utils.
****
every week to remember and show to him which layer/table he must approve.

Thanks in advanced.

That sounds like an excellent way to "mail bomb" your GIS admin.

What is your definition for "modify?" An SQL edit? A table structure change?
Addition of new tables?

There exist libraries for batch mail transmission, and there are ways to detect
databases changes, I just think you'd have a difficult time justifying the cost
of configuring them with any benefit that could result.

- V

Re: email post editing

VinceAngelo — Tue, 10 Sep 2013 15:46:47 GMT

Hence my concern about mail-bombing. What would happen if a user updated every row
in a million-row table? Would that generate a CPU-week of e-mails, crashing the mail server?

If you only want a summary analysis to do done once a day, or once a week, that's all well
and good, but the level of granularity you're suggesting (row-level) is not in any way reasonable.

I also question why it's necessary to send someone e-mail to do their job. Wouldn't a competent
participant in the editing protocol know how often to check for outstanding edits? And if they don't,
why do they have a role? It seems as if you're trying to create a nag-bot; I'd think that there would
be better ways to encourage participation.

My recommendation would be to start mining the version tree for your information, and once you
have the data collected in a report, *then* worry about how it gets communicated.

- V

Re: email post editing

JoeBorgione — Tue, 10 Sep 2013 19:06:19 GMT

Like Vince, I'm a systems administrator and I get enough mail selling me hoses, pharmacuteculs, and low interest rate re-financing loans, not to mention those emails looking for money to help get diamonds out of some third world country....

My suggestion is to create a trigger that gets pulled upon an edit. This trigger updates a date field. Then instead of an email, the admin guy just queries the data for a particular edit_date. See this thread...

Re: email post editing

ChandreyeeLahiri — Tue, 24 Feb 2015 18:02:23 GMT

Vince:

I'm asking the same question only I want to be emailed/notified only when a point is added to a hosted feature service. The addition of a point marks the start of a workflow in my project and I want to be notified so that I can launch a particular workflow.I'm not talking of a versioned database...just a simple hosted File Geodatabase.

Can you clarify HOW to set up email notification without the postgresq solution outlined below?

Re: email post editing

VinceAngelo — Tue, 24 Feb 2015 18:47:35 GMT

I have never given that sort of solution any consideration, so I cannot begin to suggest how to solve it.

I expect you'll find it challenging to associate events with rows outside a relational database context.

Good luck.

- V