Errors Converting and Importing ACT 8.0 to BCM

[cmglaser]

I have been trying to import my ACT 8.0 database into BCM and have
encountered two scenario. There are about 8300 contacts in the ACT database
and many user-defined fields.

1) When I tried to import only Contact records, but all subcategories i.e.
activities, attachments etc. The process would only go as far as record #395
and then give me an error "The data that you selected was not successfully
converted into BCM format" When I checked the BCM log it says "Contact,
loading of the ImageList did not succeed" Any suggestions with what could be
stopping this import?

2) I then tried to import only Contact records, but elimated the Activies
subcategory. I was able to get as far as record #5384. When it got to that
record, the progress screen simply just disappeared and left the Business
Data Import/Export screen active. When I tried to continue with the import I
received the error "Some errors occurred while your data was being imported.
The import file could not be read. Please verify the file is of the right
format.

Any help would be appreciated.

 

[Lon Orenstein]

cmglaser:

I'm not sure what the ImageList problem is -- did you create any new
activity types in ACT! (other than Calls, Meetings, and ToDos)? That would
explain why you got farther when eliminating the activities...

Have you run ACTDIAG on your database and verified that there are no errors?
This could help find and fix corruption...

You might try exporting contacts from ACT! in CSV format, then importing
into BCM to verify that the contact records are OK. You could then go back
and import the ACT! db again, selecting No Duplicates, and see if you get
farther...

Let us know how it turns out, please.

Lon

___________________________________________________________
Lon Orenstein
pinpointtools, llc
(e-mail address removed)
Author of Outlook 2007 Business Contact Manager For Dummies
Author of the eBook: Moving from ACT! to Business Contact Manager
800.238.0560 x6104 Toll Free (U.S. only) +1 214.905.0401 x6104
www.pinpointtools.com

 

[cmglaser]

Thank you for your suggestion. I haven't created any new activity types in
ACT so I don't know what that log means either.

However, I did export the ACT contacts to a .csv file and then into Outlook
with some success. Now, how do I now import the histories from ACT. I went
back to Outlook Import wizard and when I selected the .pad file, it takes me
to the conversion wizard, which was my initial problem. If you read my
previous post, I couldn't get the file conversion to finish. However, I
re-did the import process today and it finished the conversion and took me to
the import wizard. When I selected the new .bcm file, I received the
following error "Some errors occurred while your data was being imported. The
import file could not be read. Please verify that the file is of the right
format."

Any new suggestions?

Thanks

 

[Lon Orenstein]

Well, I'm stumped for now... Let me check with some ACT! folks and I'll
respond asap. Maybe the BCM Team has some ideas. The problem is in the
ACT! database and I'm not sure which direction to advise you to take.

One idea is to break up your ACT! db into smaller numbers of contacts on the
theory that BCM is choking on all that history or activities. Another is to
purge the ACT! db of some of the history or activities (you can always leave
ACT loaded and go back to it). Do you have many activities from the past
that have not been cleared? ACT! keeps those in the activities table and
your previous post suggests that the corruption may be there since it got
further without selecting activities than with. You could try clearing all
those old activities -- BCM will try to schedule an activity for all those
uncleared ones.

HTH,
Lon

___________________________________________________________
Lon Orenstein
pinpointtools, llc
(e-mail address removed)
Author of Outlook 2007 Business Contact Manager For Dummies
Author of the eBook: Moving from ACT! to Business Contact Manager
800.238.0560 x6104 Toll Free (U.S. only) +1 214.905.0401 x6104
www.pinpointtools.com

 

[Sat]

Can you please do the following and narrow down the problem?

1. Import the ACT8demo.pad which comes with ACT 8. Please select all
contacts, its sub categories, and import the file into BCM. Click Dont send
on the watson you get after import.

2. If that succeeds, I recommend, you take the database which is creating
problems, and import one activity at a time, and narrow down as to where it
exactly fails.

I did not find anything like ImageList in ACT 8.

-Sat.

 

[Sat]

Any update on this?

Can you please do the following and narrow down the problem?

1. Import the ACT8demo.pad which comes with ACT 8. Please select all
contacts, its sub categories, and import the file into BCM. Click Dont send
on the watson you get after import.

2. If that succeeds, I recommend, you take the database which is creating
problems, and import one activity at a time, and narrow down as to where it
exactly fails.

I did not find anything like ImageList in ACT 8.

-Sat.

 

[Lon Orenstein]

Sat:

I just posted an update in this thread below, Re: Stall when importing ACT 9
Database.

Lon
___________________________________________________________
Lon Orenstein
pinpointtools, llc
(e-mail address removed)
Author of Outlook 2007 Business Contact Manager For Dummies
Author of the eBook: Moving from ACT! to Business Contact Manager
800.238.0560 x6104 Toll Free (U.S. only) +1 214.905.0401 x6104
www.pinpointtools.com

 

[Sat]

Hi cmglaser,

This is Sateesh from the BCM team. Can you please give me your e-mail
address and company information? Is it possible to share the problem
database for further analysis?

 

[Lon Orenstein]

Sateesh:

We've got some ACT! databases we can send you that we've had trouble
converting... Which versions do you want?

Thanks,
Lon

___________________________________________________________
Lon Orenstein
pinpointtools, llc
(e-mail address removed)
Author of Outlook 2007 Business Contact Manager For Dummies
Author of the eBook: Moving from ACT! to Business Contact Manager
800.238.0560 x6104 Toll Free (U.S. only) +1 214.905.0401 x6104
www.pinpointtools.com

 

[Sat]

Hi Lon:

You can send all the problem versions. I need your e-mail address to create
a workspace so that the database files can be shared.

Sateesh