Thanks for the reply Ray, i understood the key now.

Ray i have another doubt, am facing issue while importing customers along wt its contacts. I am able to import customers alone wtout any errors but when i tried wt its contacts OE cant recognise the data and giving out error. Not sure am i missing out the right fields to use. Can u let me know if you are aware of the exact fields for customer and contacts.

hi i have cracked it no need to worry, btw t key is to have each contact as a separate line item under a Parent company and adding a new column related company will do the needful at one shot.

Thanks for your answer Alain. Will try doing the same, but doing the same in libre office seems to be a permanent solution for this.

Hi and yes i understood now, converting an Excel to csv in windows has an issue so tat openerp cannot recognise the ascii format of the texts it seems, if am correct. Anyways am doing the alternate approach as u suggested as i have another OS i.e Ubuntu besides Windows 8. But dont wish to switch the OS every time i want to import the data. Thanks a lot for your answer. Good day ahead!.

I have another small problem which am facing i.e i want to import all the customers with its respective contacts at one shot, but am unable to do so. I am not sure which is the relative field for the "contacts column. I tried using all t combinations as i know but all failed returning error. I am able to import the customers witout contacts but not with both at one shot. Can you tell me whats the right fields to be used. ? Would of great help to me in that case.

hi i have cracked it no need to worry, btw t key is to have each contact as a separate line item under a Parent company and adding a new column related company will do the needful at one shot.