Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
New Member
Posts: 10
Country: UK
Message 1 of 3 (641 Views)

Sage Act 2012 Premium Import

[ Edited ]



I have been trying to import the data from swiftpage/emarketing to update our database for email/eshot suppression reason.


Unfortunatly I carnt seem to get it to work.


On the import file it just has 2 columns of data. email and suppresion reason. I have mapped them to the correct field and it feels like its done it as it says import success with no errors or whatever. But when I check the records that should have been updated no change has been made.


Can anybody help me with this.




Platinum Super Contributor
Posts: 5,276
Country: USA
Message 2 of 3 (617 Views)

Re: Sage Act 2012 Premium Import

You'll want to check your 'Duplicate Checking' settings and only have them set to match on e-mail address.  If there are other fields listed in the Dup Checking, they won't be able to match because your file doesn't contain them.


Duplicate Checking can be found under Tools > Preferences > Admin tab (far right after Startup tab) > Duplicate Checking.

Greg Martin
New Member
Posts: 10
Country: UK
Message 3 of 3 (600 Views)

Re: Sage Act 2012 Premium Import

Thats great thanks seems to be working, though it only seems to update the first 300-400 out of just over 4000 records it should be updating, then when I run the import again it seems to update another few hundred.