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 <[email protected]>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/ >
--------------------------------------------------------------------- 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/
