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)<http://www.otrs.com/en/news-and-press/news-details/article/translate-to-english-otrs-at-the-13th-iir-service-desk-forum-2009/?tx_ttnews%5BbackPid%5D=51&cHash=ef91fa143e>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.d...@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/ >
--------------------------------------------------------------------- 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/
