Nominet Zone File Released in May

[armistice]

Any one know what software should be used to open these files???

They are text files inside the zip, you can view them with any text viewer (although since the files are big notepad won't work well ).
You could import them into sql server, or even excel. Depends what you want to do with the data.

 

[ian]

They are text files inside the zip, you can view them with any text viewer (although since the files are big notepad won't work well ).
You could import them into sql server, or even excel. Depends what you want to do with the data.

Tried all that, too big to open in any mainstream software and excel struggles to import more than just the letter A's!

 

[redbird]

According to Nominet stats http://www.nominet.uk/news/reports-statistics/uk-register-statistics-2016/ there should be around 10.5m domains, I am only seeing less than 9.8m. Anyone else see more?

 

[GUI]

According to Nominet stats http://www.nominet.uk/news/reports-statistics/uk-register-statistics-2016/ there should be around 10.5m domains, I am only seeing less than 9.8m. Anyone else see more?

I'm seeing 10,700,061 domains.

 

[redbird]

9,783,544 in the csv dump file. I thought that was all of them?
Maybe my import into msql failed somewhere. I used LOAD DATA LOCAL INFILE

 

[AssetDomains]

Tried all that, too big to open in any mainstream software and excel struggles to import more than just the letter A's!

Haven't tried it on the Zone but bigdump was handy when I was looking to import the uk postcode data that runs into millions of records
http://www.ozerov.de/bigdump/

 

[redbird]

Haven't tried it on the Zone but bigdump was handy when I was looking to import the uk postcode data that runs into millions of records
http://www.ozerov.de/bigdump/

Is that level of postcode data publicly available, appreciate a link if free?

 

[invincible]

Tried all that, too big to open in any mainstream software and excel struggles to import more than just the letter A's!

You might do better using Linux with vi. TextWrangler for Mac imports them. Clearly some regular expressions will need to be performed on the data to remove the unnecessary parts before processing.

 

[AssetDomains]

Is that level of postcode data publicly available, appreciate a link if free?

You cant get the official royalmail one free but there are open source alternatives if you google

https://www.freemaptools.com/download-uk-postcode-lat-lng.htm I think I used

 

[ian]

Even the provided CSV file complains about size and only shows around 1mil results.

 

[invincible]

9,783,544 in the csv dump file. I thought that was all of them?
Maybe my import into msql failed somewhere. I used LOAD DATA LOCAL INFILE

My last line within that is 10700061.

 

[invincible]

Even the provided CSV file complains about size and only shows around 1mil results.

Yes. Sorry. Too advanced for you.

 

[ian]

Yes. Sorry. Too advanced for you.

Thanks David, great help as usual; you're a credit to Acorn

For anyone else looking for a simple solution, this text editor can cope with the file size:
https://www.emeditor.com/download/

 

[GUI]

Even the provided CSV file complains about size and only shows around 1mil results.

I guess you're attempting to open in Excel? If you're on Windows, grab something like Notepad++ to view the whole file.

 

[ian]

I guess you're attempting to open in Excel? If you're on Windows, grab something like Notepad++ to view the whole file.

Notepad++ suffers the same issue it seems. Will look at the config for it when I have more time. Thanks.

 

[GUI]

Notepad++ works fine for me.

 

[ian]

Notepad++ works fine for me.

.uk file size is much smaller than the .co.uk

 

[jmcc]

You might do better using Linux with vi. TextWrangler for Mac imports them. Clearly some regular expressions will need to be performed on the data to remove the unnecessary parts before processing.

If it follows the usual zonefile format, then it should be possible to use Awk or Perl to pull out the domain names if that's all that is required. However it will be necessary to filter out any non-domain name data.

Regards...jmcc

 

[GUI]

.uk file size is much smaller than the .co.uk

This is the full domain file, db-dump-20160516.csv, with the line number on the left, showing 10,700,061 domains.

Notepad++ works fine for me. Use whatever works for you.

 

[jmcc]

So is the zone file the full zone file complete with nameservers and glue records?

Regards...jmcc