Community
Showing results for 
Search instead for 
Do you mean 
Reply

import tab delimited file to ACT 2010 does not work

New Member
Posts: 2
Country: Australia

import tab delimited file to ACT 2010 does not work

Using import wizard.

Everything works fine. Importing bar shows, but no green bar begins. The Importing box disappears and takes me to the list view which shows me the original 69 contacts I had but has not added the 1410 requested.

I have told it to merge any duplicate contacts of which there should be none from the existing 69.

 

I created a blank copy of this database and imported. It showed 18 "duplicates" and imported all 1410 contacts in less than 2mins (with me pressing create for the 18 duplicates)

 

I then imported this same .txt file to the correct database - same thing happens. Importing box comes up, no green bar starts, box disappears and it flicks to the list view showing only the original 69 contacts. No contacts imported, no errors show up.

 

Try it in a created blank copy and it works.

Why will the existing database not bring up the duplicates screen?

Why wont it import the contacts?

There are no formulas in my original excel spreadsheet.

New Member
Posts: 2
Country: Australia

Re: import tab delimited file to ACT 2010 does not work

Further to this issue...

 

I have removed all data that is not required to merge.

I have removed ALL formulas (used several to change info so that it fit the ACT fields such as concatinate)

Saved the spreadsheet as a new file.

Then created a new tab delimited text file.

 

This now causes about 800 "duplicate" in the new database, but I am able to tick "create contact" and carry on until all 1410 are imported. In teh new database... same thing. Importing box opens, bar does not even appear. After approx 15secs the importing disappears and the screen changes to the list view showing the original 69 contacts. I have tried it starting in the list view, same result.

 

The problem would appear to be that it is not asking me to create the contact when it finds duplicates in the existing database. I cant avoid this or change the data as I am importing vacant land lists where quite often several lots are owned by the one person or company = contact.

 

HELP..... Smiley Happy

Platinum Super Contributor
Posts: 5,275
Country: USA

Re: import tab delimited file to ACT 2010 does not work

If you are still having issues with the import, here is a way to test the creation of your spreadsheet:

- start with a new/blank Excel spreadsheet

- manually enter your header row

- manually enter 1 or 2 rows of contacts that you know should be found as duplicates

- save as csv

- open your database and verify the Duplicate Checking (Tools > Preferences > General tab > Duplicate Checking button)

- import the new file into your database to test

 

You can also test this in the demo database (to see if the issue is specific to your database), but setting Duplicate Checking in the demo and importing the file twice.

Greg Martin
Sage