Hello Alxendar
Thanks for that great clue.
I installed the client and found the table (customer_user)
I inserted a column of my choice thru sql client.
But in OTRS under customer database I could not see that cloumn , do I need
to any other changes to show on frontend.
It is seen in the sql client , I also restarted the otrs service.
Thanks
Rupa
On Thu, Dec 10, 2009 at 3:08 PM, Alexander Halle
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/