As of version 3.1.0
It may still only be January but there’s no let-up on updating and improving Match2Lists. Some nice updates to mention thanks to user feedback.
- New Semi-Colon “;” can now be used as a delimiter in uploaded lists
- New User defined output result file delimiters
- Change File extension of output result files reflects output delimiter used
Allowing semi-colons as a delimiter of lists being uploaded came about after monitoring several users uploading such files even though it wasn’t a option – so in the end we added it.
Many users had requested that the output results files be comma separated but some did prefer the tab delimited that we were using. After some discussion it was decided to give each user the ability to select their own preferred output delimiter – lets hope that keep s everyone happy! Just go to the Settings tab in the My Details section of your account to make the changes.

New User Defined Export File Delimiter option
And with the change of output delimiter it sort of made sense to reflect that choice in the extension used on the output results files downloaded. So if you chose CSV as your delimiter the download files will have a *.csv extension allowing quick and easy import into applications like Microsoft Excel.
If you have any comments or suggestions on any of these new updates or updates you would like to see in the future drop us a line we would love to hear from you.
Until the next time, happy matching
As of version 3.0.1
We have been continually updating and improving the matching processes all projects go through so you should be seeing improvements in the quality of matches found. We’ve fixed a few bugs and improved the usability of the Match Visualiser.
- Design Match results in Match Visualiser are now displayed in descending Match Score
- Change Improved matching algorithms throughout matching processes
- Bug/Fix Match Visualiser inadvertently closing on page refresh
Your feedback does make changes. Any suggestions or improvements you think we can make to Match2Lists please let us know, we discuss and read every one. Many thanks.
Until the next time, happy matching.
Connecting to our FTP servers should be straightforward, but as with anything involving computers, things can conspire to make your work more complicated that it should be! The following are a few things that we have found to be the cause of most of the issues that our clients have experienced.
Check your Login details carefully
Your first port of call is to check that you have entered your username and password correctly. This should be easy to spot if this is the problem as the system will tell you straight away that your login details were incorrect. If you need a reminder on your password then please contact our support team.
Passive Vs Active connections
If you are sure that your details were entered correctly and you are not getting any messages about an incorrect username or password then your problems may be due to your settings in whatever FTP Client that you’re using. Our servers require a ‘Passive FTP’ connection to get through our firewall and some FTP Clients require you to explicitly specify this. What’s Passive FTP? Well put simply its the method used between client and server to establish what ports to use on the connection.
There are 2 types of FTP connection: Passive and Active. Active cannot be used on our servers as our firewalls will filter out the ports used – all you will see is your FTP program waiting for a response when logging in, but it will never get one as the request to login has already been blocked! Passive FTP is more strict on what ports can be used and thus more firewall-friendly.
So what do you do if you experience this? We have found that using a good FTP client such as FileZilla should work ‘out of the box’ without having to delve into the configuration as the program will intelligently work out the right connection to use. However if you are experiencing problems in another FTP client then try looking in that program’s settings. You are looking for options that specify Active or Passive mode – this may for example come under a subsection called ‘Connection’. Make sure Passive mode is selected if there is a choice between the two.
Windows as the FTP Client
It’s even possible to use Windows itself as the FTP client (XP, Vista, Windows 7) and this works for some people (but being windows it can be a bit temperamental – it’ll work fine for some but not for others
). Simply open an explorer window (NB not an internet explorer window, just an explorer window that you use to browse your local files e.g. by clicking on ‘My Computer’) Type the address into the Address Bar: ftp.match2lists.com – you should then be presented with a Log On box. Enter your details and you should be able to view your FTP area like any other windows folder and copy/move/delete files as normal, but note that if you are copying over the top of another file we have found that it’s best practice to first delete the file that you would be overwriting. Dedicated FTP software handles these situations much better and will ask you for confirmation and which file to use.
Note that Windows also has a Passive FTP option that is worth checking if you experience problems. It can be found in (Windows XP, other versions may vary) ’Internet Options’ either via Control Panel or under the ‘Tools -> Internet Options’ Menu. Go to the Advance Tab and under the Browsing subheading you will find an option ‘Use Passive FTP’. Make sure this is selected.
Still not working?
If you are still experiencing problems then it may be your own firewall that is blocking your ftp connection. Windows has a built in firewall but this usually doesn’t block FTP. You can try adding an exception that will always allow your FTP client though the firewall – this can be done in Control Panel (Windows XP) -> Windows Firewall -> Exceptions. Click Add program and find your FTP Client in the list, then add it.
Also any third-party Firewall software may need to be checked. A good test to see if this is the problem is to temporarily turn this software off and check if you can access FTP (You can do the same with Windows Firewall). If it now works then you need to add the exceptions in the third-party firewall program and turn it back on – it’s not a good idea to have to turn it off each time for FTP use as this increases your security risk and you may forget to turn it back on! See help/documentation on the third-party program to see how to add exceptions.
If your company’s network firewall is blocking you however, you will need to ask your network administrator about giving you access to FTP connections.
If all else fails
If you have tried everything at this point, are still having trouble and have a dedicated IT department then they may be able to resolve any issues. If not then contacting your ISP to find the problem may be an option. Otherwise our support team are happy to help you get your data to us and explore other options on how to do this.
Now when you upload your files you can identify your columns as either DUNS numbers or Global DUNS numbers for inclusion in your matching and De-duping projects.
Read More Post a comment (0)Did you buy a new marketing database and need to de-dupe and merge the contacts / companies with your existing database?
Then I think you’ll welcome the new Merge2Lists feature we have just launched within Match2Lists.
With the Merge2Lists feature you can now match & merge your new data against your existing master file, removing duplicates, filling blanks and combining fields with different names to create your new master list, all with the usual simplicity you expect from Match2Lists.
The data matching process uses our ground breaking Match Visualiser as normal, but you will be presented with new options to customise and select how you would like to merge the 2 lists and determine the structure of your new master file when you choose the download option.
We are currently in the process of putting together a video tutorial on this fantastic new feature, in the mean time you will find guidance on screen when merging your data.
Feel free to ping us any questions or comments. Thank you for using Match2Lists.
As of version 3.0.0
Just one update to the site to mention – but a good one!
- New De-Dupe Merged Export
When you export a De-Dupe matching project, 2 results files are now created for you to download.
File 1.) This is your main cleansed de-duped list, containing records that were not matched and the merged enhanced derived record from each de-duped group of matches.
File 2.) The “Master Grouping” file. This file contains all the matched/duplicate records grouped together by a unique Master Group ID. It allows you to see those records that were matched and grouped together.
Let me explain a bit about the merged/enhanced de-duped records in File 1.
For each group of matched records, which are in essence the duplicates you found and selected using the Match Visualiser, we create one master record for that group. This master record is derived from the most common values found within the group on a column by column basis.
So if some of the matched records didn’t have a value for some columns and other records in that same group did, then the most common value for that column would be used. This creates a more complete record to use.
In the case of an address Match2Lists will choose the most complete address from one of your de-duped records and use this address, this avoids issues with fictitious addresses being created.

Screenshot showing the 2 results files ready to download
Use it, try it out and let us know what you think. Leave feedback here or send us as email, we love reading feedback from our users.
Until the next time, happy matching.
P.S. The next upgrade will allow you to define your own logic to determine how to choose which value to incorporate in your master record.
We have been asked a few times now for a more detailed explanation of how the Match weightings work and how they affect the Match score.
The purpose of the Match weighting is to allow you to determine the importance that you want to place on each data description.
The match score is calculated by adding together the score of all the data descriptions and dividing by the number of descriptions. The weighting determines what percentage of the score for each data description is applied to the match score.
The example below will show how the match weighting affects the match score:
- Company Name – Weighting 100%
- Address – Weighting 100%
- City – Weighting 50%
- Postcode – Weighting 100%
Each description adds to the match score as below:
- Company Name contribution to MatchScore = (100% / 350% = approx 29%)
- Address contribution to MatchScore = (100% / 350% = approx 29%)
- City contribution to MatchScore = (50% / 350% = approx 14%)
- Postcode contribution to MatchScore = (100% / 350% = approx 29%)
Therefore by adjusting the match weighting you can determine the importance and contribution that each data description adds to the match score and can therefore adjust these weightings to help find new matches emphasising different elements of your data.
Just a quick note to advise that Match2Lists now allows you to specify fields as unique Idenities when uploading your lists. We have new descriptions for:
- Company ID
- Address ID
- Contact ID
You will find these descriptors at the bottom of the option list, when describing the contents of the lists you upload.
Please note that no transformation logic is applied to these data descriptors, so you will need to apply any transformations or validation before loading your data into Match2Lists.
You will only be able to identify exact matches with these data descriptors. If you would like more data description options feel free to reply or contact us directly.


