Rupa wrote :
[...]
I have customer Info with fields like (Name , location , E-mail ID and
Phone) in excel sheet , Can I import it in OTRS customer database and
overwrite the existing field
[...]
Hello Rupa,
use a sql client to import the data right into the database. You don't
need any import script, it's pretty straightforward. Sorry, I don't
remember the table name, but this was easy to find by looking through
the database with a sql gui client (e.g. HeidiSQL for Windows).
Please note that I had to experiment first by adding records manually
before I found out what columns I needed in my to be imported csv file.
Regards
Alexander
--
radprax Gesellschaft fuer medizinische Versorgungszentren mbH,
Bergstr. 7 - 9, 42105 Wuppertal,
Fon: +49 202 2489 1110, Fax: +49 202 2489 94 1119
Geschaeftsfuehrer: Andreas Martin, Dr. med. Heiner Steffens, Dr. med. Renate
Tewaag
Amtsgericht Wuppertal: HRB 19359, St.-Nr.: 5132/5889/0264, DE 814559152
Web: http://www.radprax.de
---------------------------------------------------------------------
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/
