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
<ahalle-otrs@radprax.de> 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