Community
Showing results for 
Search instead for 
Do you mean 
Reply

Problem importing contacts from Excel

New Member
Posts: 4
Country: France

Problem importing contacts from Excel

Hello,

 

Im trying to import 200 contacts from excel using the tab delimited (both .txt or .csv) but only the first contact is importing.

 

Firstly i made a new contact layout, perhaps its the problem's source and secondly my excel database is not fully complete, there are many blanks in contacts informations.

 

Do anybody had the same problem?

Thanks 

 

Bronze Elite Contributor
Posts: 3,292
Country: USA

Re: Problem importing contacts from Excel

it will sound odd but use the comman option
-MM
World Famous ACT! Certified Consultant @ www.ActiveSales.net
Platinum Elite Contributor
Posts: 14,388
Country: Australia

Re: Problem importing contacts from Excel

Also check the fields you're using for duplicate checking... maybe turn it off for the import and then back on after
New Member
Posts: 4
Country: France

Re: Problem importing contacts from Excel

[ Edited ]

Hello, i tried to turn it off but it doesnt work,

 

What do you mean exactly by 'use the command option'? (Im sorry, its the first time I use sage for my training period ^^)

 

I think that the problem comes from the layout or my excel sheet, do i have to do something to activate ;y layout?

 

Because if i import my excel database in just one field of the basic layout, everything is imported, if i retry in my new layout, just one contact is imported

 

One last thing, when i choose the fields to import, though the preview of my 200 contacts is good, the result is not.

Edit : I tried zith the full contacts database (1400 contacts) and now its zorking a bit better as i have 700 imported contacts instead of one, still 700 contacts to import Smiley Tongue but how lol
Message Edited by Charoulet on 07-29-2009 03:52 AM
Platinum Elite Contributor
Posts: 14,388
Country: Australia

Re: Problem importing contacts from Excel

New Member
Posts: 4
Country: France

Re: Problem importing contacts from Excel

Hello, 

 

Yes I followed exactly this "tutorial". Then I tried new things, but nothing was successfull. In fact I am following a training period and they just want to import this database. I think that the propblem comes from the database but Ive no knowledge in database exportation so i dont know lol.

Platinum Elite Contributor
Posts: 14,388
Country: Australia

Re: Problem importing contacts from Excel

Have you tried creating a new database with File | New and importing it there?

 

Failing that, it might be some bad characters in the Excel file

Bronze Elite Contributor
Posts: 2,548
Country: New_Zealand

Re: Problem importing contacts from Excel

What version of ACT!?

Graeme Leo
Xact Software - consultants and developers
Follow us on Twitter and check out our Blog


New Member
Posts: 4
Country: France

Re: Problem importing contacts from Excel

Ok ill try today

Its the latest version of ACT PREMIUM (11) 

New Member
Posts: 2
Country: USA

Re: Problem importing contacts from Excel

The same thing is happening to me.  Did you find the answer?  I called support the other day and they changed the settings to merge and to add.  It worked one time.  I've checked the settings they are fine.  But it only imports 1 record.