Community
Showing results for 
Search instead for 
Do you mean 
Reply

Problems importing

Copper Contributor
Posts: 15
Country: United States

Re: Problems importing

I'm having this same problem currently, but I don't see a clear solution in the posts attached. Can anyone advise me on what to do??

 

 We're on ACT 2009 Premium for Workgroups.

 

I've done numerous imports in the past but I cannot get this one to work!!! Is there a system issue or a patch I can get?! This is a big problem given the number of records in my DB ( 40K+)

 

Here is the problem…

 

·        I am exporting about 4 fields from the company level data that needs to be placed onto the contact level

·        Importing contact records, tab delimited (I've tried csv files too with no luck)

·        All fields in the txt file match up to existing fields in the DB

·        Contact merge options are:

o   If source records match destination records: MERGE

o   If source records do not match destination records: ADD

§  (I’m doing ADD only so I can actually see what’s happening & IF anything is working; otherwise I’d say DO NOT ADD)

§  Another consultant told me to change this to DO NOT ADD, but the records still aren’t merging.

·        Nothing is merging, despite me telling the db to match on Company Name . The company name on the company level & contact level do match  with my test data & roughly 90% of all records.

·        Obviously the data I’m trying to get onto the contact level does not currently exist there; that’s why I’m importing it to the contact level in the first place. But is that what’s causing the issue?? I've managed to get some of the “new” data into the system, but it’s creating all new records which will not work.

  

What is the deal?!!? Please help!!!!!

 

New Member
Posts: 4
Country: United States

Re: Problems importing

Bukadmin I am having the same issues and must have tried hundreds of different combinations of files and options. Have you recieved information on a fix? I cant seem to see any real answers to this issue it always seems to be the same advice...file type, duplicate, fields, and merge/add. How can i not find any answers to a thing you would think would be a pretty important functuion for ACT to do. Well if you or anyone on here has something other than the stuff mentioned above please enlighten me. Thank you in advance.
Platinum Elite Contributor
Posts: 14,854
Country: Australia

Re: Problems importing

Are the fields you are trying to bring the data into all blank?

 

ACT! can merge into fields and replace data

New Member
Posts: 4
Country: United States

Re: Problems importing

Hi Mike,

 

Thanks for our quick response. I'm not too sure what your asking. I'm have a excel contact list that I recieved from a customer. I manualy changed all the header fields to match ACT's fields and saved it under xls,xlsx,csv, and txt files and tried all the suggestions i mentioned above including checking if my sql server 7 is running and it was. Its wierd cause when I try to Import it brings up a loading screen, but nothing happens for 30 seconds and it takes me to ACT screen with no changes and error message. I really need some help and can't find it anywhere. any suggestions???

New Member
Posts: 4
Country: United States

Re: Problems importing

I also tried the Outlook to ACT2010 import and same thing. I did however succesfuly import my list to Outlook2007. I keep geting the importing data screen with nohting happening for 30 seconds and than it goes back to the ACT screen with no changes and no error message.
Copper Super Contributor
Posts: 104
Country: United States

Re: Problems importing

I had the same problem.   When I restarted SQL Server (ACT7) and tried again all went well.

 

Leslie

Leslie Munson
ACT! Certified Consultant
Swiftpage Gold Drip Marketing Certified Consultant
Patricia Egen Consulting,LLC
Leslie@egenconsulting.com
www.egenconsulting.com
423-875-2652
New Member
Posts: 4
Country: United States

Re: Problems importing

Leslie I just tried that, but still does the same thing. I have no idea at this point and feel like I've done everything everyone suggested. anybody else want to take a crack at it.
Copper Contributor
Posts: 74
Country: United States

Re: Problems importing

are you still stuck on this?

i had thought i should disabled duplicate checking, but it turns out that i needed to enable it, in a certain way:

http://kb.sagesoftwareonline.com/cgi-bin/sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=2610...
New Member
Posts: 1
Country: USA

Re: Problems importing

We have been having the same issue. Tried doing the import on another computer and it worked fine! The difference between the two computers? The one that it worked fine is 32 bit. The one that it did not work on is 64 bit. Is it possible data imports on 64 bit computers don't work?