06-04-2008 04:48 PM
I updated my Act! to 10.0.2.191 today and have 2 questions/problems:
1) My internet security suite gives messages saying Act! is trying to act as server and monitor what I do on computer, Act could also be tracking what I do on my computer. If I click the "deny" button, Act! hangs. What is this tracking/monitoring thing about?
2) I have been trying for hours to import contact info into Act! My current database has about 200 contacts but none of them has email addresses. The email addresses are in a different email program. I have been able to put the email addresses on Excel, and save them in both Tab-delimited text file and comma-delimited file. However, I've tried several hours and imported many times--all failed. The email addresses just can't be imported. Please help!!
06-04-2008 09:07 PM
06-04-2008 04:58 PM
1. Part of ACT! (SQL Server) is supposed to be running a server. You should always allow this
2. Export the addresses to a text file, bring them into Excel, combine them with the other data to a single sheet, then export them to CSV or TXT. Then import this into ACT!
06-04-2008 05:36 PM
06-04-2008 05:41 PM
You have a single file with all the details for each contact and the contacts are not already in the database you're importing to?
Then, follow the steps listed at this ACT! Knowledge Base article - http://tinyurl.com/3l6xeo
In item 10 - make sure the email field is correctly mapped.
06-04-2008 06:15 PM
The text file from the address book of my email client contains only city and email address (only very few have first and last names; the first and last names are stored in Act!). In my Act! database, all the city fields are filled out. I have been trying to link the two by mapping "city" to "city". Apparently this doesn's work??? If not, is my only option manually copy-and-paste the 200 addresses??
My computer won't let me go to tinyurl.com. I don't know why. I've added the URL to my internet security program and have sent the company an email to find out.... Doesn't seem like my day for computer work....
06-04-2008 06:27 PM
Maybe try this link?
ACT! isn't good at importing to contacts already loaded, but if the fields are all blank, the link above would normally work.
But, if you don't have the names in the import file, how can you expect them to be matched up when you import them?
Maybe export the ACT! database to a CSV file, combing that with the address file in Excel, then use the link in this post to fill the empty email address fields.
06-04-2008 06:34 PM
06-04-2008 07:42 PM
06-04-2008 08:36 PM
Yay! The new table got imported!! The bad news is most of the City now have 2 records in Act!--one has phone number and street address, the other has email address. I am at my wit's end and decide to just go through the records one by one, manually combining the two and then delete one of them. I've spent about 9 hours today doing nothing but trying to get this database together. Now the end is in sight....
Thank you very much for your help. I really appreciate it!