Community
Showing results for 
Search instead for 
Do you mean 
Reply

Need Help- Importing TXT files not working unless you "confirm each match"

New Member
Posts: 9
Country: USA

Need Help- Importing TXT files not working unless you "confirm each match"

I am importing files from excel, I saved as a txt file. I am using the wizard, I map everything correctly then I start the import and it looks like it is importing and then finishes and nothing was imported.

 

I try again and this time I check "confirm each match" and then the files import. The issue is that on the files I did "confirm each match" I get a message saying the name is already in the database (which it is not) so I click add and it works, but I could do this because it was not alot of records. I have several spreadsheets of data that have hundreds of records and I can't sit here and click "confirm each match" on 700 files. I tried for about 30 min and was able to do 100.

 

I am sure there is something simple I am not seeing so if anyone can point it out I would be grateful.

 

thanks

 

Shell

Copper Super Contributor
Posts: 206
Country: USA

Re: Need Help- Importing TXT files not working unless you "confirm each match"

Confirm your duplicate checking settings, "Tools, Preferences" The defaults are Company, Contact, Phone.
Brad Marquardt
realtimeACT, Inc
Colorado, USA