You are viewing limited content. For full access, please sign in.

Question

Question

Windows account duplicate in cf_user_snapshot

asked on October 11, 2018

Hi all,

 

One of our customer use Windows Accounts to connect to Laserfiche.

In Laserfiche Forms, the users don't have email (I don't know why).

We added emails directly to the Form's database => dbo.cf_user_snapshot and dbo.cf_user and it worked for a times.

Sometimes the emails get away, so we add them one more time in the database.

 

We have observed that under dbo.cf_user_snapshot, we had duplicate users.

 

It looks like, because we changed the database (added the email manually), Laserfiche try to correct the database by add the user again and again (without the email).

 

 

In my mind, if we find why Laserfiche didn't import the email, we could correct this, and we'll not need to add it manually then we will not have duplicate.

 

Someone have any idea?

 

Thanks in advance.

Regards

 

0 0

Replies

replied on October 11, 2018

Are these really Windows users or are they repository users that link to a Windows login?  If the latter, you go into the Attributes for the user and add the email attribute.  For Forms, its [Forms]E-mail and the actual email goes in the data field.  I do believe it's case sensitive.  You can do the same thing for Workflow:  [Workflow]E-mail.  If they truly are Windows users, wouldn't it be easier to add the email in AD rather than trying to manually update the LF db?  Even if they are true Windows users, it looks like you add the attribute for Windows users as well.

3 0
replied on October 11, 2018

Was about to ask/suggest the same thing as Donald. 

Also just to note, it is HIGHLY discouraged to manually manipulate the database to try and solve problems without contacting LF support first. 

1 0
replied on October 12, 2018

Hi all, thank you for your returns.

 

I asked my customer to add the attribute [FORMS]Email.

This is the database dbo.cf_user_snapshot before.

 

Then he add the email

 

then, under the Forms, he synchronized the users

 

The email is still missing

0 0
replied on October 12, 2018

Did you check if it is a Windows Account or a Repository User? If it is a Windows Account, then the email address attribute in AD needs to be populated so it is brought in.

0 0
replied on October 12, 2018

Hi Blake,

Thanks for your help.

 

How do you check that?

0 0
replied on October 12, 2018

You would need to pull the user up in AD and check.

0 0
replied on October 15, 2018

Hi all.

My customer use Active Directory (Windows SBS Console) to create a new window's session.

 

 

But under Laserfiche, he used Windows' Account until use LDAP's account

 

 

Is it our error?

 

Thanks in advance.

Regards

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.