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 wrote:

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/

Hello Alxendar Thanks a lot again for the reference in admin manual. I added the lines in defaults.pm file and was able to see the fields I have added and deleted all unnecessary fields. My Customer database has only all the fields which I require Thanks again Rupa On Fri, Dec 11, 2009 at 12:30 PM, Alexander Halle wrote:

Otrs User wrote : [...]

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.

[...]

Hello Rupa,

to use additional columns you also need to tell OTRS about them. I'm sorry, this exceeds my knowledge, but as a start try chapter 11.2.1 of the admin manual.

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/