User Forum
Xequte User Forums
Profile    Active Topics    Forum FAQ    Search this forumSearch
     
Forum Tips
» This forum is for users to discuss their software problems and suggestions for improvement.  Remember that only a tiny percentage of our users experience such problems (To be precise less than 0.7% have ever posted on this forum)
» Include your software version number (as displayed in the About Box)
» Check the FAQ before posting as most common questions have already been answered
» You don't need to also e-mail us separately as our support team will respond to all questions on this forum
 
 All Forums
 Xequte User Forums
 MailList King
 Importing and avoiding Duplicates

Note: You must be registered in order to post a reply.

Size 
UserName:
Password:
Mode 
Format  BoldItalicizedUnderline Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkInsert EmailBrowse for an image to attach to your post Insert CodeInsert QuoteInsert List
   
Message 

 

Emoji
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Black Eye [B)]
Frown [:(] Shocked [:0] Angry [:(!] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
Skindude Posted - Nov 28 2009 : 02:53:37
Hi Nigel, I have searched and read as many posts as possible on avoiding Duplicates but none seems to answer my question.
My database has 15 Groups and members can be associated with several or all groups at the same time.
I wish to import a CSV file of email addresses which have been extracted from bonafide enquiry databases to our company. This is about 7500 emails.
The problem is this: I only wish to import those emails that are new to MLK. I can obvioulsy import them all to a new 0 membership group but this will import them all as Multiple mebership is allowed. How can I import them whereby, if the email address already exists in any single group, it will not be imported to the New group (the one where I want all the new imorts to appear) ?
Hope this makes sense
Thanks
Andrew

Andrew
3   L A T E S T    R E P L I E S    (Newest First)
xequte Posted - Dec 01 2009 : 02:41:19
OK, you'll need to use the manual method above to handle that situation.



Nigel
Xequte Software
www.xequte.com
nigel@xequte.com
Skindude Posted - Dec 01 2009 : 02:38:24
I only wat to import addresses that have never been in the database before - at all. The vast majority of the 7500 addresses I will be importing are in one or more Groups already. So what I am trying to do is double checking that I have got all the email addresses from historic enquiries to our website.
If I do as you suggest and I have already done, I get a new Group with 7500 members with multiple membership. In that New Group, I only want to keep those that are members of only that New Group - all the other multple group members should remain in their original groups but not be added to the New Group. In other words, The New Group members are just that - completely new additions to the Database who belong only to the New Group

Andrew
xequte Posted - Nov 28 2009 : 11:42:03
Hi Andrew

There is no automatic way to handle that. Can you explain your reasons so I can better understand whether there should be an option for it?

Why not just import them into a new group and then display the group and change the membership of any members that belong to multiple groups?



Nigel
Xequte Software
www.xequte.com
nigel@xequte.com