By default, the passwords in the Customer table are assumed to be hashed with md5.

If you'd set Admin > SysConfig > Framework > Frontend >Customer::AuthModule::DB::CryptType to "Plain" you should be able to get this working.

If you don't want to mess with the password encryption, another possibility would be to create the CustomerUsers from CSV with a small API script. See syncuser_csv2otrs.pl which syncs agent accounts (not customerusers) from CSV, that could be an example.
--
Michiel Beijen
R&D

OTRS AG
Norsk-Data-Str 1.
61352 Bad Homburg
Deutschland

T: +31 (0) 6457 42418
F: +49 (0) 9421 56818-18
I:  http://www.otrs.com/

Business Location: Bad Homburg, Country Court: Bad Homburg, Commercial register: 10751, Tax ID: 003 240
97505 Chairman of the Board: Burchard Steinbild, Managing Board: André Mindermann (CEO), Martin Edenhofer

CU@ IIR Service Desk Forum in Mainz (Germany) and get to know more about OTRS  at booth no. 12 from Nov 24-25, 2009!

On Tue, Oct 13, 2009 at 2:29 PM, Dunn, Jeff <Jeff.Dunn@amplifon.com> wrote:

All,

 

I am new to OTRS, and am in the process of setting up a new OTRS installation, for testing and then deployment.

 

We are transferring from another ticketing system and need to copy a large amount of customer data from the old system. I know that MySQL has the LOAD DATA INFILE facility, and using a CSV file, this works very well except for setting up initial passwords for the users on the new system.

 

If I leave the password blank I have been unable to logon as the new users.

 

Is there a way of setting the default passwords in a CSV import file?

 

Thanks and regards

 

Jeff Dunn

 




-----------------------------------------------------------------------------------------------------------------------------
The receiver of this message is required to check if he/she has received it erroneously. If so, the receiver is requested to immediately inform the sender and - in consideration of the responsibilities arising from undue use or disclosure of the message or the information contained therein - destroy the original message and any copy or printout thereof.

Amplifon Ltd
Registered and Head Office : Ultravox House, Styal Road, Manchester M22 5WY
Registered In England No 1315581
VAT No 596 2575 91
-----------------------------------------------------------------------------------------------------------------------------


---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/