Create and update customers

•
Version: 10
• 2 minutes to read
 • 2 minutes to read

Void setValue(String column, String Value)

Sets a named field to the given value. Look up names in the reference section down below, or check out the class reference.

Note

Both parameters are strings! Remember to use quotes even for IDs.

You must call save() after setting all applicable values to actually create or update the company.

User u;
u.load(9);
u.setValue("email", "bob@example.com");
u.save();

Integer save()

Saves a new or updated user and returns its ID.

  • If the ID is set before calling save(), it's an update.
  • If the ID is empty, it's a create.
User u;
u.setValue("firstname", "Sam");
printLine(u.save().toString());

Reference

Frequently used values

Parameter Db field Description
id id ID (primary key)
username username Unique username or uid
profileId profile_id The user's profile (profile.id)
firstname firstname The first name of the person
lastname lastname The last name of the person
email Email 1 or more
ownerCompany The ID of the company linked to user's person entity
group usergroup The primary group for the user
status status Status
active (1), not present(2), deleted (3)
language language The user's language, see list below for values

Language values

Value Description
0 Norwegian
1 English
2 German
3 Swedish
4 Danish
5 Dutch
6 French
7 Spanish
8 Italian
9 Czech
10 Finnish
11 Polish
12 Russian
13 Ukrainian

Sign-in info

Parameter Db field Description
loginAttempts login_attempts How many times the user has tried to sign in with an incorrect password
lastLoginAttempt last_login_attempt The last time the user tried to sign in but failed
idleTime idle_time Duration in seconds the user has been idle

User flags and access flags

User flags represent preferences. For example, Use24HrsClock = 10.

Access flags represent what a user may do. For example, AccessDocuments = 8.

Ticket notifications

Notifications (pop-up warnings) to the user are controlled by a bit mask.

Value Description
1 NewTicket
2 NewTicketMessage
3 TicketEscalated
4 TicketActivated
5 ActiveTickets (filter)
6 TicketTakeOver
9 Hotlist (filter)
10 Custom

Learn more about tickets.