Community
Showing results for 
Search instead for 
Do you mean 
Reply

Imported File Mapping Incorrectly in ACT 2010

Astute Commentator
Posts: 78
Country: USA

Imported File Mapping Incorrectly in ACT 2010

I was using ACT 2008 on an XP machine.  Got a new Windows 7 machine, loaded ACT 2010 and successfully converted a copy of my database.  Everything looks  and works fine.  However, today I imported a csv file with 500 contact records, all the fields were mapped correctly but when I finished the import most of the data in the imported file was in the wrong fields.  For example:

 

City from my file went to Fax Phone field on ACT

Phone # from my file went to Prefix field on ACT

 

I deleted them and ran the database check and repair and then tried to import again but got the same results.

 

Help and thank you!!

 

 

Silver Contributor
Posts: 1,813
Country: USA

Re: Imported File Mapping Incorrectly in ACT 2010

The first thing that jumps out to me is that You are using ACT 2008 on an unsupported system. (Win7) Other than being suprised that it worked at all, I don't know if that is your problem.  However, the results you are receiving is not typical of the import performance of ACT, so I would also wonder if everything is set up properly on your end.  There is a lot you can do to prepart the data.

 

My best guess is that there are commas in other places in your .csv file.  Try this along with the following KB articles.  Open your file in Excel, and make sure all the collumns line up with data in the correct places.  Then save as a tab delimited text file from Excel,  Then try importing the .tab delimited file into ACT.  if all of this fails, you would need to consider upgrading.

 

7 Updated - Importing From a CSV File Does Not Import Data Into Contact Field
8 Updated - How To Export and Import Drop-down Lists for ACT! Fields
9 Updated - How to Export Your Contact Data from ACT! to a Text Delimited File
Test Drive Act! and Quickbooks over Citrix http://GoTryAct.com

Jon Klubnik| ActTrainer.com
(866)710 4228

ACT! Certified Consultant / ACT! Premier Trainer / ACT! Hosting Provider

Astute Commentator
Posts: 78
Country: USA

Re: Imported File Mapping Incorrectly in ACT 2010

Thanks for the suggestions.  I will try them later today.

 

I am running ACT 2010 on the Win 7 machine. Smiley Happy

Astute Commentator
Posts: 78
Country: USA

Re: Imported File Mapping Incorrectly in ACT 2010

I removed all commas from my Excel spreadsheet and saved it as a tab delimited .txt file and imported it to ACT and got the same field mismatches:

 

State has blank

Last Name has State

Mobile Phone has a date

Zip Code has Suffix

and so on

 

I'm running ACT! by Sage 2010 Version 12.1.181.0, Hot Fix 1 on Windows 7.

Silver Contributor
Posts: 1,813
Country: USA

Re: Imported File Mapping Incorrectly in ACT 2010

If you want to send me the file, i'll take a look info@acttrainer.com

 

Test Drive Act! and Quickbooks over Citrix http://GoTryAct.com

Jon Klubnik| ActTrainer.com
(866)710 4228

ACT! Certified Consultant / ACT! Premier Trainer / ACT! Hosting Provider

Astute Commentator
Posts: 78
Country: USA

Re: Imported File Mapping Incorrectly in ACT 2010

I emailed the file to you.  Thanks for taking the time to look at it!

Silver Contributor
Posts: 1,813
Country: USA

Re: Imported File Mapping Incorrectly in ACT 2010

I didn't see anything that popped out at me as being wrong.  Sometimes when an import give us difficulties, we will import into text fields (like user1, user2, etc) and then use edit replace or edit copy to move the data around within the database.

 

 

Hope this helps bit.

Test Drive Act! and Quickbooks over Citrix http://GoTryAct.com

Jon Klubnik| ActTrainer.com
(866)710 4228

ACT! Certified Consultant / ACT! Premier Trainer / ACT! Hosting Provider

Bronze Contributor
Posts: 930
Country: USA

Re: Imported File Mapping Incorrectly in ACT 2010

As a rule, I always try to get my text file into Tab delimited, rather than comma delimited, format.  Commas really can screw up an import because they can be both the delimiter and occur naturally within fields, like the Company name (think "Dewey, Cheatham and Howe").  If you load your comma delimited file into Excel, you can then save it as a Tab-delimited file, then try importing it into ACT!

Signature
Astute Commentator
Posts: 78
Country: USA

Re: Imported File Mapping Incorrectly in ACT 2010

Tab delimited did not work either. 

 

Same results when importing to Demo database.

 

I removed all commas from file - same results.

 

I copied the spreadsheet and pasted as unformatted text into a new spreadsheet - same results.

 

What the heck?!?!  I've got 500+ records and I don't want to key them manually!  Any other suggestions?

New Member
Posts: 5
Country: USA

Re: Imported File Mapping Incorrectly in ACT 2010

I'm having the same problem with ACT 10 and Excel csv not mapping the city or address. (Vista OS)

 

Did you find a solution?

 

Mike