Same application to 250 users with their own data

Question

Hello,

I have 250 users from different cities. I want to give them an app to update their own data.

I want each user to view and update only his own data.

How can I do it, other then creating 250 * {layer-views, maps, apps, groups}?

I allready have 250 usernames.

Thanks in advance.

Ofra

OfraAinemer · Answer

I thought it would be great, but it didn't work.

I've created feature layer in SDE, with "enable editor tracking" and updated the value of created user and last updated user as the AGOL test user name to be the owner (using SSMS).

Then I've published the layer to AGOL as hosted feature layer.

I've defined "Enable editing" and "Keep track of who created and last updated features" was automatically checked.

But, the created and last edited user changed to the user who published the layer... all features with the same user.

By the way, I've tried to update one feature using my test user, so created user was the publishing one, and last edited was the test user.

Then I've defined "Editors can only see their own features" and the test user didn't see those features. That means that each user can see only the features that he has created by himself.

😞

Any other idea.

Thanks anyway for you help

Ofra

jcarlson · Answer

I know making direct SQL edits to an SDE table is a no-no, but could you update the editor columns from an SQL client like pgAdmin or similar?

I would test this on a copy first, to make sure it doesn't break anything.

OfraAinemer · Answer

Hi,

I can manage having the layer hosted on the AGOL side and sync it to my SDE.

If made some trial and it does work, that each user can see and update only his own features.

The only problem left is how do I set the initial features that I've created, as if the city user has created them. I cannot update the "Editor" or "creator" column.

Any other trick?

Thanks in advance

Ofra