# Importing Records with IP addresses **URL:** \ **Category:** General Discussion\ **Created:** [November 19, 2015, 5:13pm UTC](https://forum.mautic.org/t/importing-records-with-ip-addresses/2811 "2015-11-19T17:13:48Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![stephenweinberg](https://avatars.discourse-cdn.com/v4/letter/s/7ba0ec/32.png) [@stephenweinberg](https://forum.mautic.org/u/stephenweinberg)\ **Post date:** [November 19, 2015, 5:13pm UTC](https://forum.mautic.org/t/importing-records-with-ip-addresses/2811/1 "2015-11-19T17:13:48Z")
Hi, I’m new to Mautic but it looks incredibly powerful and in just a short time throughly impressed! I’m considering a move from a another Automation software, and can output all my records including their IP address when i do so. Is there a way for me to import these records with that IP Data? Right now anonymous traffic appears in reports with IPs in the name field, so I wouldn’t want to put the data in there? But is there any value bringing the IP data in if the individual hasn’t clicked through a tracked link from a campaign? Would Mautic be able to identify an individual based soley on their IP address if it’s know in my contacts list? Thanks for any insight. ---
**Author:** ![stephenweinberg](https://avatars.discourse-cdn.com/v4/letter/s/7ba0ec/32.png) [@stephenweinberg](https://forum.mautic.org/u/stephenweinberg)\ **Post date:** [November 19, 2015, 5:13pm UTC](https://forum.mautic.org/t/importing-records-with-ip-addresses/2811/2 "2015-11-19T17:13:48Z")
Hi, I’m new to Mautic but it looks incredibly powerful and in just a short time throughly impressed! I’m considering a move from a another Automation software, and can output all my records including their IP address when i do so. Is there a way for me to import these records with that IP Data? Right now anonymous traffic appears in reports with IPs in the name field, so I wouldn’t want to put the data in there? But is there any value bringing the IP data in if the individual hasn’t clicked through a tracked link from a campaign? Would Mautic be able to identify an individual based soley on their IP address if it’s know in my contacts list? Thanks for any insight. ---
**Author:** ![escopecz](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/escopecz/32/370_2.png) [@escopecz](https://forum.mautic.org/u/escopecz)\ **Post date:** [November 20, 2015, 11:23am UTC](https://forum.mautic.org/t/importing-records-with-ip-addresses/2811/3 "2015-11-20T11:23:51Z")
> [@](#): > > Right now anonymous traffic appears in reports with IPs in the name field Are you sure the IP address is stored in the name field? Take a look in the lead edit form. Anonymous leads show IP as a name because there is no other information we have about them yet. > [@](#): > > Is there a way for me to import these records with that IP Data? Yes, you can import leads from a CSV file from the lead manager. IP address is also importable. > [@](#): > > Right now anonymous traffic appears in reports with IPs in the name field, so I wouldn’t want to put the data in there? Again, IP addresses are not in the name field (or really shouldn’t be). So you can import their names to the name fields without any problem. > [@](#): > > But is there any value bringing the IP data in if the individual hasn’t clicked through a tracked link from a campaign? Would Mautic be able to identify an individual based soley on their IP address if it’s know in my contacts list? I don’t understand what is the point of those questions. How the tracking works? That’s a long story. The best way how to understand the tracking algorithm is to take a look at the source code which is quite easy in case of Mautic since it is open source project. ---
**Author:** ![stephenweinberg](https://avatars.discourse-cdn.com/v4/letter/s/7ba0ec/32.png) [@stephenweinberg](https://forum.mautic.org/u/stephenweinberg)\ **Post date:** [November 20, 2015, 3:32pm UTC](https://forum.mautic.org/t/importing-records-with-ip-addresses/2811/4 "2015-11-20T15:32:02Z")
Thanks for the reply! Very helpful. ---
**Author:** ![screenmachine](https://avatars.discourse-cdn.com/v4/letter/s/e99b99/32.png) [@screenmachine](https://forum.mautic.org/u/screenmachine)\ **Post date:** [December 1, 2015, 1:34pm UTC](https://forum.mautic.org/t/importing-records-with-ip-addresses/2811/5 "2015-12-01T13:34:16Z")
Hello, I have a database with contacts and their IP addresses as well in Salesforce (IP was collected over the past several years via form submissions). I have a self hosted copy of Mautic. I have the IP address for ABC Company, I would like to setup an email alert that comes to me when ABC Company visits the site again. I see I can import lead data, including IP but I wanted to confirm a few things before trying since I couldn’t find an existing CSV template. 1. When I prepare my import file do I use the alias as the column header? Ex: title, firstname, lastname, company, etc. 1.1) If yes, what do I label the IP address field as? I see a field name of ip\_address in the MySQL database but not on the Manage Fields screen. 1.2) I’m assuming I need to ad ip\_address as a field on this screen but wanted to confirm the name before doing anything. 2. Will doing this only add new entries or will it tie together the IP address of historical anonymous traffic (I installed Mautic early November) to the account name I import? 2.1) If not, can this be done in a different way? Thank you for your thoughts and for creating Mautic! ---
**Author:** ![stephenweinberg](https://avatars.discourse-cdn.com/v4/letter/s/7ba0ec/32.png) [@stephenweinberg](https://forum.mautic.org/u/stephenweinberg)\ **Post date:** [December 2, 2015, 2:58pm UTC](https://forum.mautic.org/t/importing-records-with-ip-addresses/2811/6 "2015-12-02T14:58:46Z")
@screenmachine - All will be clear once you start the import process. I played it safe and started with a small set of records so i could validate things went to the right place and could delete if they were’t correct. The import process involves a complete field mapping… and shows IP address and a few other fields that you don’t see in manage fields. Be sure to add and custom fields you need. For question 2. I’m not sure what would happen… if records would auto-update or not. Since you have MySQL access, perhaps you should consider exporting your current records and then using the Unique Key for the records in the import so you can update rather than overwrite records. Just a thought. ---
**Author:** ![milescantley](https://avatars.discourse-cdn.com/v4/letter/m/848f3c/32.png) [@milescantley](https://forum.mautic.org/u/milescantley)\ **Post date:** [January 20, 2016, 12:23pm UTC](https://forum.mautic.org/t/importing-records-with-ip-addresses/2811/7 "2016-01-20T12:23:39Z")
Hello, I have a similar situation to @screenmachine in that I have some external data that I would like to merge with Mautic. I would like to update the anonymous Mautic leads with company names from the external source, partly because Geo location is not working. Is there a way to export the anonymous leads, and add data to them before importing them back again? ---
**Author:** ![escopecz](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/escopecz/32/370_2.png) [@escopecz](https://forum.mautic.org/u/escopecz)\ **Post date:** [January 20, 2016, 1:19pm UTC](https://forum.mautic.org/t/importing-records-with-ip-addresses/2811/8 "2016-01-20T13:19:48Z")
My suggestion is to build a plugin which would do that and possibly provide such plugin to the community. I just tested the MaxMind GeoIP2 City Download (the free geoIP lookup which downloads the database locally) and it works. ---
**Author:** ![silavapi](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/silavapi/32/7424_2.png) [@silavapi](https://forum.mautic.org/u/silavapi)\ **Post date:** [February 2, 2020, 10:56pm UTC](https://forum.mautic.org/t/importing-records-with-ip-addresses/2811/9 "2020-02-02T22:56:49Z")