Bulk import of CUSTOMERS

[andriy]

Hello Team,

Is it possible to bulk import list of Customers/Customer Companies to OTRS ?



Thanks !

[crythias]

Not directly. Usually people point it to existing db structures.

However, you may decide to populate customer_user directly with any number of different ways. only login must be unique.

Code: Select all

Field	Type	Null	Key	Default	Extra
login	varchar(100)	NO	UNI	NULL	 
email	varchar(150)	NO	 	NULL	 
customer_id	varchar(200)	NO	 	NULL	 
pw	varchar(50)	YES	 	NULL	 
salutation	varchar(50)	YES	 	NULL	 
first_name	varchar(100)	NO	 	NULL	 
last_name	varchar(100)	NO	 	NULL	 
phone	varchar(150)	YES	 	NULL	 
fax	varchar(150)	YES	 	NULL	 
mobile	varchar(150)	YES	 	NULL	 
street	varchar(150)	YES	 	NULL	 
zip	varchar(150)	YES	 	NULL	 
city	varchar(150)	YES	 	NULL	 
country	varchar(150)	YES	 	NULL	 
comments	varchar(250)	YES	 	NULL	 

[andriy]

Thank you . Will create script to import them directly to database

Does it harm if I change "required" field to NO ? I really do not need customer to login , just need for tracking purposes.

[crythias]

There is no field named "required". login is a required field, though, as well as any other field that has an asterisk in the Customer form of the Admin side.
login is important for lookups.
customer_id is required
email is required

If you don't have an email address, use (customer's phone number)@mailinator.com. Mailinator.com is a "disposable" email domain.

From Mailinator's FAQ:

Err... what's the password to get the email
There's no password. The email name itself is the only key you need to get in.

This sounds pretty insecure, what if I want to send important emails with sensitive super-secret information in them to Mailinator?
Then you are a stupid-head. That isn't what this is for.

[andriy]

Right , I was under impression what I have seen it somewhere. Thanks for the advice !